VIEW: OE.SO_HEADERS_INTERFACE_ALL#

Source

View Text - Preformatted

select CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, 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, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORDER_NUMBER_SOURCE_ID ORDER_NUMBER_SOURCE_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, CUSTOMER_ID CUSTOMER_ID, ORDER_TYPE ORDER_TYPE, ORDER_TYPE_ID ORDER_TYPE_ID, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORDER_CATEGORY ORDER_CATEGORY, DATE_ORDERED DATE_ORDERED, CURRENCY_CODE CURRENCY_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, SALESREP_NAME SALESREP_NAME, SALESREP_ID SALESREP_ID, INVOICE_CUSTOMER INVOICE_CUSTOMER, INVOICE_CUSTOMER_ID INVOICE_CUSTOMER_ID, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID, INVOICE_ADDRESS_ID INVOICE_ADDRESS_ID, INVOICE_ADDRESS1 INVOICE_ADDRESS1, INVOICE_ADDRESS2 INVOICE_ADDRESS2, INVOICE_ADDRESS3 INVOICE_ADDRESS3, INVOICE_ADDRESS4 INVOICE_ADDRESS4, INVOICE_CITY INVOICE_CITY, INVOICE_STATE INVOICE_STATE, INVOICE_COUNTY INVOICE_COUNTY, INVOICE_COUNTRY INVOICE_COUNTRY, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_ADDRESS_ID SHIP_ADDRESS_ID, SHIP_ADDRESS1 SHIP_ADDRESS1, SHIP_ADDRESS2 SHIP_ADDRESS2, SHIP_ADDRESS3 SHIP_ADDRESS3, SHIP_ADDRESS4 SHIP_ADDRESS4, SHIP_CITY SHIP_CITY, SHIP_STATE SHIP_STATE, SHIP_COUNTY SHIP_COUNTY, SHIP_COUNTRY SHIP_COUNTRY, SHIP_POSTAL_CODE SHIP_POSTAL_CODE, PRICE_LIST_NAME PRICE_LIST_NAME, PRICE_LIST_ID PRICE_LIST_ID, TERMS_NAME TERMS_NAME, TERMS_ID TERMS_ID, CYCLE_ID CYCLE_ID, ENTERED_STATE_NAME ENTERED_STATE_NAME, ENTERED_STATE_ID ENTERED_STATE_ID, ENTERED_STATE_DATE ENTERED_STATE_DATE, COMPLETE_FLAG COMPLETE_FLAG, AGREEMENT_NAME AGREEMENT_NAME, AGREEMENT_ID AGREEMENT_ID, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, INVOICE_TO_CONTACT_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, DATE_SHIPPED DATE_SHIPPED, 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, ACCOUNTING_RULE ACCOUNTING_RULE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE INVOICING_RULE, INVOICING_RULE_ID INVOICING_RULE_ID, 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, INTERFACE_STATUS INTERFACE_STATUS, ERROR_FLAG ERROR_FLAG, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, OPERATION_CODE OPERATION_CODE, SALESREP_NUMBER SALESREP_NUMBER, APPLY_STANDARD_NOTES APPLY_STANDARD_NOTES, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, ORG_ID ORG_ID, REPORT_SUMMARY REPORT_SUMMARY from "OE"."SO_HEADERS_INTERFACE_ALL"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, 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
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORDER_NUMBER_SOURCE_ID ORDER_NUMBER_SOURCE_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, ORDER_TYPE ORDER_TYPE
, ORDER_TYPE_ID ORDER_TYPE_ID
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORDER_CATEGORY ORDER_CATEGORY
, DATE_ORDERED DATE_ORDERED
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, SALESREP_NAME SALESREP_NAME
, SALESREP_ID SALESREP_ID
, INVOICE_CUSTOMER INVOICE_CUSTOMER
, INVOICE_CUSTOMER_ID INVOICE_CUSTOMER_ID
, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, INVOICE_ADDRESS_ID INVOICE_ADDRESS_ID
, INVOICE_ADDRESS1 INVOICE_ADDRESS1
, INVOICE_ADDRESS2 INVOICE_ADDRESS2
, INVOICE_ADDRESS3 INVOICE_ADDRESS3
, INVOICE_ADDRESS4 INVOICE_ADDRESS4
, INVOICE_CITY INVOICE_CITY
, INVOICE_STATE INVOICE_STATE
, INVOICE_COUNTY INVOICE_COUNTY
, INVOICE_COUNTRY INVOICE_COUNTRY
, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_ADDRESS_ID SHIP_ADDRESS_ID
, SHIP_ADDRESS1 SHIP_ADDRESS1
, SHIP_ADDRESS2 SHIP_ADDRESS2
, SHIP_ADDRESS3 SHIP_ADDRESS3
, SHIP_ADDRESS4 SHIP_ADDRESS4
, SHIP_CITY SHIP_CITY
, SHIP_STATE SHIP_STATE
, SHIP_COUNTY SHIP_COUNTY
, SHIP_COUNTRY SHIP_COUNTRY
, SHIP_POSTAL_CODE SHIP_POSTAL_CODE
, PRICE_LIST_NAME PRICE_LIST_NAME
, PRICE_LIST_ID PRICE_LIST_ID
, TERMS_NAME TERMS_NAME
, TERMS_ID TERMS_ID
, CYCLE_ID CYCLE_ID
, ENTERED_STATE_NAME ENTERED_STATE_NAME
, ENTERED_STATE_ID ENTERED_STATE_ID
, ENTERED_STATE_DATE ENTERED_STATE_DATE
, COMPLETE_FLAG COMPLETE_FLAG
, AGREEMENT_NAME AGREEMENT_NAME
, AGREEMENT_ID AGREEMENT_ID
, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT
, ORDERED_BY_CONTACT_FIRST_NAME ORDERED_BY_CONTACT_FIRST_NAME
, ORDERED_BY_CONTACT_LAST_NAME ORDERED_BY_CONTACT_LAST_NAME
, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, INVOICE_TO_CONTACT_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, INVOICE_TO_CONTACT_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, DATE_SHIPPED DATE_SHIPPED
, 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
, ACCOUNTING_RULE ACCOUNTING_RULE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE INVOICING_RULE
, INVOICING_RULE_ID INVOICING_RULE_ID
, 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
, INTERFACE_STATUS INTERFACE_STATUS
, ERROR_FLAG ERROR_FLAG
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, OPERATION_CODE OPERATION_CODE
, SALESREP_NUMBER SALESREP_NUMBER
, APPLY_STANDARD_NOTES APPLY_STANDARD_NOTES
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, ORG_ID ORG_ID
, REPORT_SUMMARY REPORT_SUMMARY
FROM "OE"."SO_HEADERS_INTERFACE_ALL"