eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ONT.OE_HEADER_ACKS#

Source

View Text - Preformatted


select HEADER_ID HEADER_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, ORDER_NUMBER ORDER_NUMBER, ORDERED_DATE ORDERED_DATE, ORG_ID ORG_ID, CHANGE_DATE CHANGE_DATE, CHANGE_SEQUENCE CHANGE_SEQUENCE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACCOUNTING_RULE ACCOUNTING_RULE, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG, FIRST_ACK_CODE FIRST_ACK_CODE, LAST_ACK_CODE LAST_ACK_CODE, FIRST_ACK_DATE FIRST_ACK_DATE, LAST_ACK_DATE LAST_ACK_DATE, BUYER_SELLER_FLAG BUYER_SELLER_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, BOOKED_FLAG BOOKED_FLAG, AGREEMENT_ID AGREEMENT_ID, AGREEMENT AGREEMENT, AGREEMENT_NAME AGREEMENT_NAME, CONTEXT CONTEXT, PRICE_LIST PRICE_LIST, PRICE_LIST_ID PRICE_LIST_ID, PRICING_DATE PRICING_DATE, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_FROM_ORG SHIP_FROM_ORG, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, SHIP_TO_ORG SHIP_TO_ORG, SOLD_FROM_ORG SOLD_FROM_ORG, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_TO_ORG SOLD_TO_ORG, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CANCELLED_FLAG CANCELLED_FLAG, CLOSED_FLAG CLOSED_FLAG, CONVERSION_RATE CONVERSION_RATE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CUST_PO_NUMBER CUST_PO_NUMBER, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, DELIVER_TO_CONTACT DELIVER_TO_CONTACT, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER, DELIVER_TO_ORG DELIVER_TO_ORG, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, DEMAND_CLASS DEMAND_CLASS, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT, ERROR_FLAG ERROR_FLAG, EXPIRATION_DATE EXPIRATION_DATE, FOB_POINT FOB_POINT, FOB_POINT_CODE FOB_POINT_CODE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS FREIGHT_TERMS, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, HEADER_PO_CONTEXT HEADER_PO_CONTEXT, INTERFACE_STATUS INTERFACE_STATUS, INVOICE_ADDRESS_1 INVOICE_ADDRESS_1, INVOICE_ADDRESS_2 INVOICE_ADDRESS_2, INVOICE_ADDRESS_3 INVOICE_ADDRESS_3, INVOICE_ADDRESS_4 INVOICE_ADDRESS_4, INVOICE_CITY INVOICE_CITY, INVOICE_COUNTRY INVOICE_COUNTRY, INVOICE_COUNTY INVOICE_COUNTY, INVOICE_CUSTOMER INVOICE_CUSTOMER, INVOICE_CUSTOMER_NUMBER INVOICE_CUSTOMER_NUMBER, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE, INVOICE_PROVINCE_INT INVOICE_PROVINCE_INT, INVOICE_SITE INVOICE_SITE, INVOICE_SITE_CODE INVOICE_SITE_CODE, INVOICE_STATE INVOICE_STATE, INVOICE_TO_CONTACT INVOICE_TO_CONTACT, INVOICE_TO_CONTACT_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME, INVOICE_TO_ORG INVOICE_TO_ORG, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, INVOICE_TOLERANCE_ABOVE INVOICE_TOLERANCE_ABOVE, INVOICE_TOLERANCE_BELOW INVOICE_TOLERANCE_BELOW, INVOICING_RULE INVOICING_RULE, INVOICING_RULE_ID INVOICING_RULE_ID, OPEN_FLAG OPEN_FLAG, OPERATION_CODE OPERATION_CODE, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, ORDER_SOURCE ORDER_SOURCE, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORDER_TYPE ORDER_TYPE, ORDER_TYPE_ID ORDER_TYPE_ID, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED, PAYMENT_TERM_ID PAYMENT_TERM_ID, PAYMENT_TERM PAYMENT_TERM, PO_ATTRIBUTE_1 PO_ATTRIBUTE_1, PO_ATTRIBUTE_2 PO_ATTRIBUTE_2, PO_ATTRIBUTE_3 PO_ATTRIBUTE_3, PO_ATTRIBUTE_4 PO_ATTRIBUTE_4, PO_ATTRIBUTE_5 PO_ATTRIBUTE_5, PO_ATTRIBUTE_6 PO_ATTRIBUTE_6, PO_ATTRIBUTE_7 PO_ATTRIBUTE_7, PO_ATTRIBUTE_8 PO_ATTRIBUTE_8, PO_ATTRIBUTE_9 PO_ATTRIBUTE_9, PO_ATTRIBUTE_10 PO_ATTRIBUTE_10, PO_ATTRIBUTE_11 PO_ATTRIBUTE_11, PO_ATTRIBUTE_12 PO_ATTRIBUTE_12, PO_ATTRIBUTE_13 PO_ATTRIBUTE_13, PO_ATTRIBUTE_14 PO_ATTRIBUTE_14, PO_ATTRIBUTE_15 PO_ATTRIBUTE_15, PO_REVISION_DATE PO_REVISION_DATE, PROGRAM PROGRAM, PROGRAM_APPLICATION PROGRAM_APPLICATION, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RELATED_PO_NUMBER RELATED_PO_NUMBER, REMAINDER_ORDERS_ALLOWED REMAINDER_ORDERS_ALLOWED, REQUEST_DATE REQUEST_DATE, REQUEST_ID REQUEST_ID, RETURN_REASON_CODE RETURN_REASON_CODE, SALESREP_ID SALESREP_ID, SALESREP SALESREP, SHIP_TO_ADDRESS_1 SHIP_TO_ADDRESS_1, SHIP_TO_ADDRESS_2 SHIP_TO_ADDRESS_2, SHIP_TO_ADDRESS_3 SHIP_TO_ADDRESS_3, SHIP_TO_ADDRESS_4 SHIP_TO_ADDRESS_4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_CONTACT SHIP_TO_CONTACT, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_COUNTY SHIP_TO_COUNTY, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_PROVINCE SHIP_TO_PROVINCE, SHIP_TO_SITE_INT SHIP_TO_SITE_INT, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, SHIPMENT_PRIORITY SHIPMENT_PRIORITY, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPMENT_PRIORITY_CODE_INT SHIPMENT_PRIORITY_CODE_INT, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, SHIPPING_METHOD SHIPPING_METHOD, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SOLD_TO_CONTACT SOLD_TO_CONTACT, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, SUBMISSION_DATETIME SUBMISSION_DATETIME, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON TAX_EXEMPT_REASON, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_POINT TAX_POINT, TAX_POINT_CODE TAX_POINT_CODE, TRANSACTIONAL_CURR TRANSACTIONAL_CURR, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE, VERSION_NUMBER VERSION_NUMBER, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, DROP_SHIP_FLAG DROP_SHIP_FLAG, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE, SHIP_TO_EDI_LOCATION_CODE SHIP_TO_EDI_LOCATION_CODE, SOLD_TO_EDI_LOCATION_CODE SOLD_TO_EDI_LOCATION_CODE, BILL_TO_EDI_LOCATION_CODE BILL_TO_EDI_LOCATION_CODE, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4, SOLD_TO_CITY SOLD_TO_CITY, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE, SOLD_TO_COUNTRY SOLD_TO_COUNTRY, SOLD_TO_STATE SOLD_TO_STATE, SOLD_TO_COUNTY SOLD_TO_COUNTY, SOLD_TO_PROVINCE SOLD_TO_PROVINCE, SOLD_TO_CONTACT_LAST_NAME SOLD_TO_CONTACT_LAST_NAME, SOLD_TO_CONTACT_FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME, SHIP_FROM_ADDRESS_1 SHIP_FROM_ADDRESS_1, SHIP_FROM_ADDRESS_2 SHIP_FROM_ADDRESS_2, SHIP_FROM_ADDRESS_3 SHIP_FROM_ADDRESS_3, SHIP_FROM_CITY SHIP_FROM_CITY, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY, SHIP_FROM_EDI_LOCATION_CODE SHIP_FROM_EDI_LOCATION_CODE, SHIP_FROM_REGION1 SHIP_FROM_REGION1, SHIP_FROM_REGION2 SHIP_FROM_REGION2, SHIP_FROM_REGION3 SHIP_FROM_REGION3, SHIP_FROM_ADDRESS_ID SHIP_FROM_ADDRESS_ID, SOLD_TO_ADDRESS_ID SOLD_TO_ADDRESS_ID, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, INVOICE_ADDRESS_ID INVOICE_ADDRESS_ID, SHIP_TO_ADDRESS_CODE SHIP_TO_ADDRESS_CODE, TP_CONTEXT TP_CONTEXT, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, XML_MESSAGE_ID XML_MESSAGE_ID, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, INVOICE_CUSTOMER_ID INVOICE_CUSTOMER_ID, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ACKNOWLEDGMENT_TYPE ACKNOWLEDGMENT_TYPE, BLANKET_NUMBER BLANKET_NUMBER, BOOKED_DATE BOOKED_DATE, FLOW_STATUS_CODE FLOW_STATUS_CODE, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, CHECK_NUMBER CHECK_NUMBER, CREDIT_CARD_CODE CREDIT_CARD_CODE, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, SOLD_TO_PHONE_ID SOLD_TO_PHONE_ID, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE, SALES_DOCUMENT_NAME SALES_DOCUMENT_NAME, QUOTE_NUMBER QUOTE_NUMBER, QUOTE_DATE QUOTE_DATE, USER_STATUS_CODE USER_STATUS_CODE, SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID, SUPPLIER_SIGNATURE SUPPLIER_SIGNATURE, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE, CUSTOMER_SIGNATURE CUSTOMER_SIGNATURE, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE, SOLD_TO_PARTY_NUMBER SOLD_TO_PARTY_NUMBER, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4, END_CUSTOMER_CITY END_CUSTOMER_CITY, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY, END_CUSTOMER_STATE END_CUSTOMER_STATE, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT, END_CUSTOMER_CONTACT_LAST_NAME END_CUSTOMER_CONTACT_LAST_NAME, END_CUSTOMER_CONTACT_FIRST_NAM END_CUSTOMER_CONTACT_FIRST_NAM, END_CUSTOMER_NAME END_CUSTOMER_NAME, IB_OWNER IB_OWNER, IB_CURRENT_LOCATION IB_CURRENT_LOCATION, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION, SOLD_TO_LOCATION_ADDRESS1 SOLD_TO_LOCATION_ADDRESS1, SOLD_TO_LOCATION_ADDRESS2 SOLD_TO_LOCATION_ADDRESS2, SOLD_TO_LOCATION_ADDRESS3 SOLD_TO_LOCATION_ADDRESS3, SOLD_TO_LOCATION_ADDRESS4 SOLD_TO_LOCATION_ADDRESS4, SOLD_TO_LOCATION_CITY SOLD_TO_LOCATION_CITY, SOLD_TO_LOCATION_POSTAL_CODE SOLD_TO_LOCATION_POSTAL_CODE, SOLD_TO_LOCATION_COUNTRY SOLD_TO_LOCATION_COUNTRY, SOLD_TO_LOCATION_STATE SOLD_TO_LOCATION_STATE, SOLD_TO_LOCATION_COUNTY SOLD_TO_LOCATION_COUNTY, SOLD_TO_LOCATION_PROVINCE SOLD_TO_LOCATION_PROVINCE, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4, DELIVER_TO_CITY DELIVER_TO_CITY, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_COUNTY DELIVER_TO_COUNTY, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE, DELIVER_TO_STATE DELIVER_TO_STATE, IB_OWNER_CODE IB_OWNER_CODE, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE, INST_ID INST_ID from "ONT"."OE_HEADER_ACKS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, ORDER_NUMBER ORDER_NUMBER
, ORDERED_DATE ORDERED_DATE
, ORG_ID ORG_ID
, CHANGE_DATE CHANGE_DATE
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACCOUNTING_RULE ACCOUNTING_RULE
, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG
, FIRST_ACK_CODE FIRST_ACK_CODE
, LAST_ACK_CODE LAST_ACK_CODE
, FIRST_ACK_DATE FIRST_ACK_DATE
, LAST_ACK_DATE LAST_ACK_DATE
, BUYER_SELLER_FLAG BUYER_SELLER_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, BOOKED_FLAG BOOKED_FLAG
, AGREEMENT_ID AGREEMENT_ID
, AGREEMENT AGREEMENT
, AGREEMENT_NAME AGREEMENT_NAME
, CONTEXT CONTEXT
, PRICE_LIST PRICE_LIST
, PRICE_LIST_ID PRICE_LIST_ID
, PRICING_DATE PRICING_DATE
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_FROM_ORG SHIP_FROM_ORG
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, SHIP_TO_ORG SHIP_TO_ORG
, SOLD_FROM_ORG SOLD_FROM_ORG
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_TO_ORG SOLD_TO_ORG
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CANCELLED_FLAG CANCELLED_FLAG
, CLOSED_FLAG CLOSED_FLAG
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CUST_PO_NUMBER CUST_PO_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, DELIVER_TO_CONTACT DELIVER_TO_CONTACT
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER
, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER
, DELIVER_TO_ORG DELIVER_TO_ORG
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, DEMAND_CLASS DEMAND_CLASS
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT
, ERROR_FLAG ERROR_FLAG
, EXPIRATION_DATE EXPIRATION_DATE
, FOB_POINT FOB_POINT
, FOB_POINT_CODE FOB_POINT_CODE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS FREIGHT_TERMS
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, HEADER_PO_CONTEXT HEADER_PO_CONTEXT
, INTERFACE_STATUS INTERFACE_STATUS
, INVOICE_ADDRESS_1 INVOICE_ADDRESS_1
, INVOICE_ADDRESS_2 INVOICE_ADDRESS_2
, INVOICE_ADDRESS_3 INVOICE_ADDRESS_3
, INVOICE_ADDRESS_4 INVOICE_ADDRESS_4
, INVOICE_CITY INVOICE_CITY
, INVOICE_COUNTRY INVOICE_COUNTRY
, INVOICE_COUNTY INVOICE_COUNTY
, INVOICE_CUSTOMER INVOICE_CUSTOMER
, INVOICE_CUSTOMER_NUMBER INVOICE_CUSTOMER_NUMBER
, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE
, INVOICE_PROVINCE_INT INVOICE_PROVINCE_INT
, INVOICE_SITE INVOICE_SITE
, INVOICE_SITE_CODE INVOICE_SITE_CODE
, INVOICE_STATE INVOICE_STATE
, INVOICE_TO_CONTACT INVOICE_TO_CONTACT
, INVOICE_TO_CONTACT_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, INVOICE_TO_ORG INVOICE_TO_ORG
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, INVOICE_TOLERANCE_ABOVE INVOICE_TOLERANCE_ABOVE
, INVOICE_TOLERANCE_BELOW INVOICE_TOLERANCE_BELOW
, INVOICING_RULE INVOICING_RULE
, INVOICING_RULE_ID INVOICING_RULE_ID
, OPEN_FLAG OPEN_FLAG
, OPERATION_CODE OPERATION_CODE
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, ORDER_SOURCE ORDER_SOURCE
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORDER_TYPE ORDER_TYPE
, ORDER_TYPE_ID ORDER_TYPE_ID
, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME
, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAYMENT_TERM PAYMENT_TERM
, PO_ATTRIBUTE_1 PO_ATTRIBUTE_1
, PO_ATTRIBUTE_2 PO_ATTRIBUTE_2
, PO_ATTRIBUTE_3 PO_ATTRIBUTE_3
, PO_ATTRIBUTE_4 PO_ATTRIBUTE_4
, PO_ATTRIBUTE_5 PO_ATTRIBUTE_5
, PO_ATTRIBUTE_6 PO_ATTRIBUTE_6
, PO_ATTRIBUTE_7 PO_ATTRIBUTE_7
, PO_ATTRIBUTE_8 PO_ATTRIBUTE_8
, PO_ATTRIBUTE_9 PO_ATTRIBUTE_9
, PO_ATTRIBUTE_10 PO_ATTRIBUTE_10
, PO_ATTRIBUTE_11 PO_ATTRIBUTE_11
, PO_ATTRIBUTE_12 PO_ATTRIBUTE_12
, PO_ATTRIBUTE_13 PO_ATTRIBUTE_13
, PO_ATTRIBUTE_14 PO_ATTRIBUTE_14
, PO_ATTRIBUTE_15 PO_ATTRIBUTE_15
, PO_REVISION_DATE PO_REVISION_DATE
, PROGRAM PROGRAM
, PROGRAM_APPLICATION PROGRAM_APPLICATION
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RELATED_PO_NUMBER RELATED_PO_NUMBER
, REMAINDER_ORDERS_ALLOWED REMAINDER_ORDERS_ALLOWED
, REQUEST_DATE REQUEST_DATE
, REQUEST_ID REQUEST_ID
, RETURN_REASON_CODE RETURN_REASON_CODE
, SALESREP_ID SALESREP_ID
, SALESREP SALESREP
, SHIP_TO_ADDRESS_1 SHIP_TO_ADDRESS_1
, SHIP_TO_ADDRESS_2 SHIP_TO_ADDRESS_2
, SHIP_TO_ADDRESS_3 SHIP_TO_ADDRESS_3
, SHIP_TO_ADDRESS_4 SHIP_TO_ADDRESS_4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_CONTACT SHIP_TO_CONTACT
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_COUNTY SHIP_TO_COUNTY
, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER
, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_PROVINCE SHIP_TO_PROVINCE
, SHIP_TO_SITE_INT SHIP_TO_SITE_INT
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, SHIPMENT_PRIORITY SHIPMENT_PRIORITY
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY_CODE_INT SHIPMENT_PRIORITY_CODE_INT
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, SHIPPING_METHOD SHIPPING_METHOD
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SOLD_TO_CONTACT SOLD_TO_CONTACT
, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, SUBMISSION_DATETIME SUBMISSION_DATETIME
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON TAX_EXEMPT_REASON
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_POINT TAX_POINT
, TAX_POINT_CODE TAX_POINT_CODE
, TRANSACTIONAL_CURR TRANSACTIONAL_CURR
, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, VERSION_NUMBER VERSION_NUMBER
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE
, SHIP_TO_EDI_LOCATION_CODE SHIP_TO_EDI_LOCATION_CODE
, SOLD_TO_EDI_LOCATION_CODE SOLD_TO_EDI_LOCATION_CODE
, BILL_TO_EDI_LOCATION_CODE BILL_TO_EDI_LOCATION_CODE
, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM
, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1
, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2
, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3
, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4
, SOLD_TO_CITY SOLD_TO_CITY
, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE
, SOLD_TO_COUNTRY SOLD_TO_COUNTRY
, SOLD_TO_STATE SOLD_TO_STATE
, SOLD_TO_COUNTY SOLD_TO_COUNTY
, SOLD_TO_PROVINCE SOLD_TO_PROVINCE
, SOLD_TO_CONTACT_LAST_NAME SOLD_TO_CONTACT_LAST_NAME
, SOLD_TO_CONTACT_FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME
, SHIP_FROM_ADDRESS_1 SHIP_FROM_ADDRESS_1
, SHIP_FROM_ADDRESS_2 SHIP_FROM_ADDRESS_2
, SHIP_FROM_ADDRESS_3 SHIP_FROM_ADDRESS_3
, SHIP_FROM_CITY SHIP_FROM_CITY
, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY
, SHIP_FROM_EDI_LOCATION_CODE SHIP_FROM_EDI_LOCATION_CODE
, SHIP_FROM_REGION1 SHIP_FROM_REGION1
, SHIP_FROM_REGION2 SHIP_FROM_REGION2
, SHIP_FROM_REGION3 SHIP_FROM_REGION3
, SHIP_FROM_ADDRESS_ID SHIP_FROM_ADDRESS_ID
, SOLD_TO_ADDRESS_ID SOLD_TO_ADDRESS_ID
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, INVOICE_ADDRESS_ID INVOICE_ADDRESS_ID
, SHIP_TO_ADDRESS_CODE SHIP_TO_ADDRESS_CODE
, TP_CONTEXT TP_CONTEXT
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, XML_MESSAGE_ID XML_MESSAGE_ID
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, INVOICE_CUSTOMER_ID INVOICE_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ACKNOWLEDGMENT_TYPE ACKNOWLEDGMENT_TYPE
, BLANKET_NUMBER BLANKET_NUMBER
, BOOKED_DATE BOOKED_DATE
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, CHECK_NUMBER CHECK_NUMBER
, CREDIT_CARD_CODE CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE
, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, SOLD_TO_PHONE_ID SOLD_TO_PHONE_ID
, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE
, SALES_DOCUMENT_NAME SALES_DOCUMENT_NAME
, QUOTE_NUMBER QUOTE_NUMBER
, QUOTE_DATE QUOTE_DATE
, USER_STATUS_CODE USER_STATUS_CODE
, SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID
, SUPPLIER_SIGNATURE SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE
, SOLD_TO_PARTY_NUMBER SOLD_TO_PARTY_NUMBER
, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY END_CUSTOMER_CITY
, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY
, END_CUSTOMER_STATE END_CUSTOMER_STATE
, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY
, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE
, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT
, END_CUSTOMER_CONTACT_LAST_NAME END_CUSTOMER_CONTACT_LAST_NAME
, END_CUSTOMER_CONTACT_FIRST_NAM END_CUSTOMER_CONTACT_FIRST_NAM
, END_CUSTOMER_NAME END_CUSTOMER_NAME
, IB_OWNER IB_OWNER
, IB_CURRENT_LOCATION IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION
, SOLD_TO_LOCATION_ADDRESS1 SOLD_TO_LOCATION_ADDRESS1
, SOLD_TO_LOCATION_ADDRESS2 SOLD_TO_LOCATION_ADDRESS2
, SOLD_TO_LOCATION_ADDRESS3 SOLD_TO_LOCATION_ADDRESS3
, SOLD_TO_LOCATION_ADDRESS4 SOLD_TO_LOCATION_ADDRESS4
, SOLD_TO_LOCATION_CITY SOLD_TO_LOCATION_CITY
, SOLD_TO_LOCATION_POSTAL_CODE SOLD_TO_LOCATION_POSTAL_CODE
, SOLD_TO_LOCATION_COUNTRY SOLD_TO_LOCATION_COUNTRY
, SOLD_TO_LOCATION_STATE SOLD_TO_LOCATION_STATE
, SOLD_TO_LOCATION_COUNTY SOLD_TO_LOCATION_COUNTY
, SOLD_TO_LOCATION_PROVINCE SOLD_TO_LOCATION_PROVINCE
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY DELIVER_TO_CITY
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_COUNTY DELIVER_TO_COUNTY
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE
, DELIVER_TO_STATE DELIVER_TO_STATE
, IB_OWNER_CODE IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE
, INST_ID INST_ID
FROM "ONT"."OE_HEADER_ACKS"