VIEW: ONT.OE_HEADERS_IFACE_ALL#

Source

View Text - Preformatted

select ORDER_SOURCE_ID ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, CHANGE_SEQUENCE CHANGE_SEQUENCE, CHANGE_REQUEST_CODE CHANGE_REQUEST_CODE, ORDER_SOURCE ORDER_SOURCE, ORG_ID ORG_ID, HEADER_ID HEADER_ID, ORDER_NUMBER ORDER_NUMBER, VERSION_NUMBER VERSION_NUMBER, ORDERED_DATE ORDERED_DATE, ORDER_TYPE_ID ORDER_TYPE_ID, ORDER_TYPE ORDER_TYPE, PRICE_LIST_ID PRICE_LIST_ID, PRICE_LIST PRICE_LIST, CONVERSION_RATE CONVERSION_RATE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_TYPE CONVERSION_TYPE, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE, TRANSACTIONAL_CURR TRANSACTIONAL_CURR, SALESREP_ID SALESREP_ID, SALESREP SALESREP, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, RETURN_REASON_CODE RETURN_REASON_CODE, TAX_POINT_CODE TAX_POINT_CODE, TAX_POINT TAX_POINT, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_EXEMPT_REASON TAX_EXEMPT_REASON, AGREEMENT_ID AGREEMENT_ID, AGREEMENT AGREEMENT, INVOICING_RULE_ID INVOICING_RULE_ID, INVOICING_RULE INVOICING_RULE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACCOUNTING_RULE ACCOUNTING_RULE, PAYMENT_TERM_ID PAYMENT_TERM_ID, PAYMENT_TERM PAYMENT_TERM, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, DEMAND_CLASS DEMAND_CLASS, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPMENT_PRIORITY SHIPMENT_PRIORITY, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SHIPPING_METHOD SHIPPING_METHOD, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FREIGHT_TERMS FREIGHT_TERMS, FOB_POINT_CODE FOB_POINT_CODE, FOB_POINT FOB_POINT, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM, 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, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, SOLD_TO_ORG SOLD_TO_ORG, 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, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, INVOICE_TO_ORG INVOICE_TO_ORG, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, DELIVER_TO_ORG DELIVER_TO_ORG, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID, SOLD_TO_CONTACT SOLD_TO_CONTACT, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIP_TO_CONTACT SHIP_TO_CONTACT, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INVOICE_TO_CONTACT INVOICE_TO_CONTACT, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, DELIVER_TO_CONTACT DELIVER_TO_CONTACT, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, SHIPMENT_PRIORITY_CODE_INT SHIPMENT_PRIORITY_CODE_INT, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, 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_TO_COUNTRY SHIP_TO_COUNTRY, INVOICE_ADDRESS1 INVOICE_ADDRESS1, INVOICE_ADDRESS2 INVOICE_ADDRESS2, INVOICE_ADDRESS3 INVOICE_ADDRESS3, INVOICE_ADDRESS4 INVOICE_ADDRESS4, 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_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME, DROP_SHIP_FLAG DROP_SHIP_FLAG, BOOKED_FLAG BOOKED_FLAG, CLOSED_FLAG CLOSED_FLAG, CANCELLED_FLAG CANCELLED_FLAG, CONTEXT CONTEXT, 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, HEADER_PO_CONTEXT HEADER_PO_CONTEXT, 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, 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, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, REQUEST_DATE REQUEST_DATE, SUBMISSION_DATETIME SUBMISSION_DATETIME, OPERATION_CODE OPERATION_CODE, ERROR_FLAG ERROR_FLAG, READY_FLAG READY_FLAG, STATUS_FLAG STATUS_FLAG, FORCE_APPLY_FLAG FORCE_APPLY_FLAG, INTERFACE_STATUS INTERFACE_STATUS, CHANGE_REASON CHANGE_REASON, CHANGE_COMMENTS CHANGE_COMMENTS, ORDER_CATEGORY ORDER_CATEGORY, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_FROM_ORG SOLD_FROM_ORG, REJECTED_FLAG REJECTED_FLAG, 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, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE, SALES_CHANNEL SALES_CHANNEL, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE, PRICE_REQUEST_CODE PRICE_REQUEST_CODE, ORIG_SYS_CUSTOMER_REF ORIG_SYS_CUSTOMER_REF, ORIG_SHIP_ADDRESS_REF ORIG_SHIP_ADDRESS_REF, ORIG_BILL_ADDRESS_REF ORIG_BILL_ADDRESS_REF, ORIG_DELIVER_ADDRESS_REF ORIG_DELIVER_ADDRESS_REF, SOLD_TO_CONTACT_REF SOLD_TO_CONTACT_REF, SHIP_TO_CONTACT_REF SHIP_TO_CONTACT_REF, BILL_TO_CONTACT_REF BILL_TO_CONTACT_REF, DELIVER_TO_CONTACT_REF DELIVER_TO_CONTACT_REF, 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_COUNTY DELIVER_TO_COUNTY, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, BATCH_ID BATCH_ID, ATTRIBUTE_STATUS ATTRIBUTE_STATUS, 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, XML_TRANSACTION_TYPE_CODE XML_TRANSACTION_TYPE_CODE, BLANKET_NUMBER BLANKET_NUMBER, PRICING_DATE PRICING_DATE, 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_ID SOLD_TO_PARTY_ID, SOLD_TO_ORG_CONTACT_ID SOLD_TO_ORG_CONTACT_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_SITE_USE_ID SHIP_TO_PARTY_SITE_USE_ID, DELIVER_TO_PARTY_ID DELIVER_TO_PARTY_ID, DELIVER_TO_PARTY_SITE_ID DELIVER_TO_PARTY_SITE_ID, DELIVER_TO_PARTY_SITE_USE_ID DELIVER_TO_PARTY_SITE_USE_ID, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_SITE_USE_ID INVOICE_TO_PARTY_SITE_USE_ID, SHIP_TO_ORG_CONTACT_ID SHIP_TO_ORG_CONTACT_ID, DELIVER_TO_ORG_CONTACT_ID DELIVER_TO_ORG_CONTACT_ID, INVOICE_TO_ORG_CONTACT_ID INVOICE_TO_ORG_CONTACT_ID, 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, RESPONSE_FLAG RESPONSE_FLAG, END_CUSTOMER_NAME END_CUSTOMER_NAME, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID, END_CUSTOMER_ORG_CONTACT_ID END_CUSTOMER_ORG_CONTACT_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT, END_CUSTOMER_LOCATION END_CUSTOMER_LOCATION, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID, END_CUSTOMER_PARTY_SITE_USE_ID END_CUSTOMER_PARTY_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_STATE END_CUSTOMER_STATE, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY, 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, ORIG_SOLD_ADDRESS_REF ORIG_SOLD_ADDRESS_REF, EXPIRATION_DATE EXPIRATION_DATE, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, 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, INELIGIBLE_FOR_HVOP INELIGIBLE_FOR_HVOP, INSTRUMENT_SECURITY_CODE INSTRUMENT_SECURITY_CODE, INST_ID INST_ID from "ONT"."OE_HEADERS_IFACE_ALL"

View Text - HTML Formatted

SELECT ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE CHANGE_REQUEST_CODE
, ORDER_SOURCE ORDER_SOURCE
, ORG_ID ORG_ID
, HEADER_ID HEADER_ID
, ORDER_NUMBER ORDER_NUMBER
, VERSION_NUMBER VERSION_NUMBER
, ORDERED_DATE ORDERED_DATE
, ORDER_TYPE_ID ORDER_TYPE_ID
, ORDER_TYPE ORDER_TYPE
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE_LIST PRICE_LIST
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_TYPE CONVERSION_TYPE
, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, TRANSACTIONAL_CURR TRANSACTIONAL_CURR
, SALESREP_ID SALESREP_ID
, SALESREP SALESREP
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, RETURN_REASON_CODE RETURN_REASON_CODE
, TAX_POINT_CODE TAX_POINT_CODE
, TAX_POINT TAX_POINT
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON TAX_EXEMPT_REASON
, AGREEMENT_ID AGREEMENT_ID
, AGREEMENT AGREEMENT
, INVOICING_RULE_ID INVOICING_RULE_ID
, INVOICING_RULE INVOICING_RULE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACCOUNTING_RULE ACCOUNTING_RULE
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAYMENT_TERM PAYMENT_TERM
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, DEMAND_CLASS DEMAND_CLASS
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY SHIPMENT_PRIORITY
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SHIPPING_METHOD SHIPPING_METHOD
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FREIGHT_TERMS FREIGHT_TERMS
, FOB_POINT_CODE FOB_POINT_CODE
, FOB_POINT FOB_POINT
, PARTIAL_SHIPMENTS_ALLOWED PARTIAL_SHIPMENTS_ALLOWED
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, EARLIEST_SCHEDULE_LIMIT EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT LATEST_SCHEDULE_LIMIT
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM
, 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
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, SOLD_TO_ORG SOLD_TO_ORG
, 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
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, INVOICE_TO_ORG INVOICE_TO_ORG
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, DELIVER_TO_ORG DELIVER_TO_ORG
, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER
, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER
, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, SOLD_TO_CONTACT SOLD_TO_CONTACT
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT SHIP_TO_CONTACT
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT INVOICE_TO_CONTACT
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, DELIVER_TO_CONTACT DELIVER_TO_CONTACT
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, SHIPMENT_PRIORITY_CODE_INT SHIPMENT_PRIORITY_CODE_INT
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, 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_TO_COUNTRY SHIP_TO_COUNTRY
, INVOICE_ADDRESS1 INVOICE_ADDRESS1
, INVOICE_ADDRESS2 INVOICE_ADDRESS2
, INVOICE_ADDRESS3 INVOICE_ADDRESS3
, INVOICE_ADDRESS4 INVOICE_ADDRESS4
, 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_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME
, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, BOOKED_FLAG BOOKED_FLAG
, CLOSED_FLAG CLOSED_FLAG
, CANCELLED_FLAG CANCELLED_FLAG
, CONTEXT CONTEXT
, 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
, HEADER_PO_CONTEXT HEADER_PO_CONTEXT
, 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
, 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
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, REQUEST_DATE REQUEST_DATE
, SUBMISSION_DATETIME SUBMISSION_DATETIME
, OPERATION_CODE OPERATION_CODE
, ERROR_FLAG ERROR_FLAG
, READY_FLAG READY_FLAG
, STATUS_FLAG STATUS_FLAG
, FORCE_APPLY_FLAG FORCE_APPLY_FLAG
, INTERFACE_STATUS INTERFACE_STATUS
, CHANGE_REASON CHANGE_REASON
, CHANGE_COMMENTS CHANGE_COMMENTS
, ORDER_CATEGORY ORDER_CATEGORY
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_FROM_ORG SOLD_FROM_ORG
, REJECTED_FLAG REJECTED_FLAG
, 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
, CREDIT_CARD_APPROVAL_DATE CREDIT_CARD_APPROVAL_DATE
, SALES_CHANNEL SALES_CHANNEL
, CUSTOMER_PREFERENCE_SET_CODE CUSTOMER_PREFERENCE_SET_CODE
, PRICE_REQUEST_CODE PRICE_REQUEST_CODE
, ORIG_SYS_CUSTOMER_REF ORIG_SYS_CUSTOMER_REF
, ORIG_SHIP_ADDRESS_REF ORIG_SHIP_ADDRESS_REF
, ORIG_BILL_ADDRESS_REF ORIG_BILL_ADDRESS_REF
, ORIG_DELIVER_ADDRESS_REF ORIG_DELIVER_ADDRESS_REF
, SOLD_TO_CONTACT_REF SOLD_TO_CONTACT_REF
, SHIP_TO_CONTACT_REF SHIP_TO_CONTACT_REF
, BILL_TO_CONTACT_REF BILL_TO_CONTACT_REF
, DELIVER_TO_CONTACT_REF DELIVER_TO_CONTACT_REF
, 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_COUNTY DELIVER_TO_COUNTY
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, BATCH_ID BATCH_ID
, ATTRIBUTE_STATUS ATTRIBUTE_STATUS
, 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
, XML_TRANSACTION_TYPE_CODE XML_TRANSACTION_TYPE_CODE
, BLANKET_NUMBER BLANKET_NUMBER
, PRICING_DATE PRICING_DATE
, 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_ID SOLD_TO_PARTY_ID
, SOLD_TO_ORG_CONTACT_ID SOLD_TO_ORG_CONTACT_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_SITE_USE_ID SHIP_TO_PARTY_SITE_USE_ID
, DELIVER_TO_PARTY_ID DELIVER_TO_PARTY_ID
, DELIVER_TO_PARTY_SITE_ID DELIVER_TO_PARTY_SITE_ID
, DELIVER_TO_PARTY_SITE_USE_ID DELIVER_TO_PARTY_SITE_USE_ID
, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_SITE_USE_ID INVOICE_TO_PARTY_SITE_USE_ID
, SHIP_TO_ORG_CONTACT_ID SHIP_TO_ORG_CONTACT_ID
, DELIVER_TO_ORG_CONTACT_ID DELIVER_TO_ORG_CONTACT_ID
, INVOICE_TO_ORG_CONTACT_ID INVOICE_TO_ORG_CONTACT_ID
, 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
, RESPONSE_FLAG RESPONSE_FLAG
, END_CUSTOMER_NAME END_CUSTOMER_NAME
, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID
, END_CUSTOMER_ORG_CONTACT_ID END_CUSTOMER_ORG_CONTACT_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT
, END_CUSTOMER_LOCATION END_CUSTOMER_LOCATION
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_PARTY_SITE_USE_ID END_CUSTOMER_PARTY_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_STATE END_CUSTOMER_STATE
, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY
, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE
, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY
, 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
, ORIG_SOLD_ADDRESS_REF ORIG_SOLD_ADDRESS_REF
, EXPIRATION_DATE EXPIRATION_DATE
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, 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
, INELIGIBLE_FOR_HVOP INELIGIBLE_FOR_HVOP
, INSTRUMENT_SECURITY_CODE INSTRUMENT_SECURITY_CODE
, INST_ID INST_ID
FROM "ONT"."OE_HEADERS_IFACE_ALL"