[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_HEADERS_IFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_HEADERS_IFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
This is a multi-org table for sales order headers open interface. This table stores order header information that is imported from a feeder system into Oracle Order Management using Order Import.
For more information on Order Import refer to the Oracle Order Management Suite API's and Open Interfaces Manual.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Headers Interface
Category: BUSINESS_ENTITY ONT_SALES_ORDER
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_HEADERS_IFACE_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
|
| OE_HEADERS_IFACE_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_ID
|
| OE_HEADERS_IFACE_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYS_CUSTOMER_REF
|
| OE_HEADERS_IFACE_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SHIP_ADDRESS_REF
ORIG_BILL_ADDRESS_REF
ORIG_DELIVER_ADDRESS_REF
|
| OE_HEADERS_IFACE_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SHIP_TO_CONTACT_REF
BILL_TO_CONTACT_REF
DELIVER_TO_CONTACT_REF
|
| OE_HEADERS_IFACE_ALL_U1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
SOLD_TO_ORG_ID
SOLD_TO_ORG
CHANGE_SEQUENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_SOURCE_ID | NUMBER | Order source id | ||
| ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
| CHANGE_REQUEST_CODE | VARCHAR2 | (30) | Change request Code | |
| ORDER_SOURCE | VARCHAR2 | (240) | Order source | |
| ORG_ID | NUMBER | Org id | ||
| HEADER_ID | NUMBER | Header id | ||
| ORDER_NUMBER | NUMBER | Order number | ||
| VERSION_NUMBER | NUMBER | Version number | ||
| ORDERED_DATE | DATE | Ordered date | ||
| ORDER_TYPE_ID | NUMBER | Order type id | ||
| ORDER_TYPE | VARCHAR2 | (40) | Order type | |
| PRICE_LIST_ID | NUMBER | Price list id | ||
| PRICE_LIST | VARCHAR2 | (240) | Price list | |
| CONVERSION_RATE | NUMBER | Conversion rate | ||
| CONVERSION_RATE_DATE | DATE | Conversion rate date | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Conversion type code | |
| CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type | |
| TRANSACTIONAL_CURR_CODE | VARCHAR2 | (15) | Transactional currency code | |
| TRANSACTIONAL_CURR | VARCHAR2 | (80) | Transactional currency | |
| SALESREP_ID | NUMBER | Salesrep id | ||
| SALESREP | VARCHAR2 | (240) | Salesrep | |
| SALES_CHANNEL_CODE | VARCHAR2 | (30) | Sales channel code | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | Return reason code | |
| TAX_POINT_CODE | VARCHAR2 | (30) | Tax point code | |
| TAX_POINT | VARCHAR2 | (80) | Tax point | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax exempt flag | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exempt number | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code | |
| TAX_EXEMPT_REASON | VARCHAR2 | (80) | Tax exempt reason | |
| AGREEMENT_ID | NUMBER | Agreement id | ||
| AGREEMENT | VARCHAR2 | (240) | Agreement | |
| INVOICING_RULE_ID | NUMBER | Invoicing rule id used by AR for generating Invoice | ||
| INVOICING_RULE | VARCHAR2 | (30) | Invoicing rule used by AR for generating Invoice | |
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule id used by AR for generating Invoice | ||
| ACCOUNTING_RULE | VARCHAR2 | (30) | Accounting rule used by AR for generating Invoice | |
| PAYMENT_TERM_ID | NUMBER | Payment term id | ||
| PAYMENT_TERM | VARCHAR2 | (30) | Payment term | |
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class code | |
| DEMAND_CLASS | VARCHAR2 | (80) | Demand class | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority code | |
| SHIPMENT_PRIORITY | VARCHAR2 | (80) | Shipment priority | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method code | |
| SHIPPING_METHOD | VARCHAR2 | (80) | Shipping method | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight Carrier code | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms code | |
| FREIGHT_TERMS | VARCHAR2 | (80) | Freight terms | |
| FOB_POINT_CODE | VARCHAR2 | (30) | FOB point code | |
| FOB_POINT | VARCHAR2 | (80) | FOB point | |
| PARTIAL_SHIPMENTS_ALLOWED | VARCHAR2 | (1) | Partial shipments allowed | |
| SHIP_TOLERANCE_ABOVE | NUMBER | Over Shipment/Return Tolerance | ||
| SHIP_TOLERANCE_BELOW | NUMBER | Under Shipment/Return Tolerance | ||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping Instructions | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions | |
| ORDER_DATE_TYPE_CODE | VARCHAR2 | (30) | Order date type code | |
| EARLIEST_SCHEDULE_LIMIT | NUMBER | Earliest schedule limit | ||
| LATEST_SCHEDULE_LIMIT | NUMBER | Latest schedule limit | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer po number | |
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | Customer payment term id | ||
| CUSTOMER_PAYMENT_TERM | VARCHAR2 | (30) | Customer payment term | |
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Stores type of payment for orders (cash, check, credit) | |
| PAYMENT_AMOUNT | NUMBER | Stores amount of payment | ||
| CHECK_NUMBER | VARCHAR2 | (50) | Stores check number if payment type is Check | |
| CREDIT_CARD_CODE | VARCHAR2 | (80) | Stores credit card name if payment type is Credit Card | |
| CREDIT_CARD_HOLDER_NAME | VARCHAR2 | (80) | Stores credit card holder name if payment type is Credit Card | |
| CREDIT_CARD_NUMBER | VARCHAR2 | (80) | Stores credit card number if payment type is Credit Card | |
| CREDIT_CARD_EXPIRATION_DATE | DATE | Stores credit card expiration date if payment type is Credit Card | ||
| CREDIT_CARD_APPROVAL_CODE | VARCHAR2 | (80) | Stores credit card approval code if payment type is Credit Card | |
| SOLD_TO_ORG_ID | NUMBER | Sold to org id | ||
| SOLD_TO_ORG | VARCHAR2 | (360) | Sold to org | |
| SHIP_FROM_ORG_ID | NUMBER | Ship from org id | ||
| SHIP_FROM_ORG | VARCHAR2 | (240) | Ship from org | |
| SHIP_TO_ORG_ID | NUMBER | Ship to org id | ||
| SHIP_TO_ORG | VARCHAR2 | (240) | Ship to org | |
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| INVOICE_TO_ORG | VARCHAR2 | (240) | Invoice To Organization | |
| DELIVER_TO_ORG_ID | NUMBER | Deliver to organization id | ||
| DELIVER_TO_ORG | VARCHAR2 | (240) | Deliver to Organization | |
| DELIVER_TO_CUSTOMER_NUMBER | VARCHAR2 | (50) | Deliver to customer number | |
| DELIVER_TO_CUSTOMER | VARCHAR2 | (360) | Deliver to customer | |
| SOLD_TO_CONTACT_ID | NUMBER | Sold to contact id | ||
| SOLD_TO_CONTACT | VARCHAR2 | (360) | Sold to contact | |
| SHIP_TO_CONTACT_ID | NUMBER | Ship to contact id | ||
| SHIP_TO_CONTACT | VARCHAR2 | (360) | Ship to contact | |
| INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
| INVOICE_TO_CONTACT | VARCHAR2 | (360) | Invoice To Contact | |
| DELIVER_TO_CONTACT_ID | NUMBER | Deliver to contact id | ||
| DELIVER_TO_CONTACT | VARCHAR2 | (360) | Deliver to contact | |
| CUSTOMER_ID | NUMBER | Customer id | ||
| CUSTOMER_NAME | VARCHAR2 | (240) | Customer name | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer number | |
| SHIPMENT_PRIORITY_CODE_INT | VARCHAR2 | (30) | Shipment priority code int | |
| SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Ship to address1 | |
| SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Ship to address2 | |
| SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Ship to address3 | |
| SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Ship to address4 | |
| SHIP_TO_CITY | VARCHAR2 | (60) | Ship to city | |
| SHIP_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Ship to contact first name | |
| SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ship to contact last name | |
| SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship to county | |
| SHIP_TO_CUSTOMER | VARCHAR2 | (360) | Ship to customer | |
| SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (50) | Ship to customer number | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship to postal code | |
| SHIP_TO_PROVINCE | VARCHAR2 | (60) | Ship to province | |
| SHIP_TO_SITE_INT | VARCHAR2 | (30) | Ship to site int | |
| SHIP_TO_STATE | VARCHAR2 | (60) | Ship to state | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship to country | |
| INVOICE_ADDRESS1 | VARCHAR2 | (240) | Invoice To Address1 | |
| INVOICE_ADDRESS2 | VARCHAR2 | (240) | Invoice To Address2 | |
| INVOICE_ADDRESS3 | VARCHAR2 | (240) | Invoice To Address3 | |
| INVOICE_ADDRESS4 | VARCHAR2 | (240) | Invoice To Address4 | |
| INVOICE_CITY | VARCHAR2 | (60) | Invoice To City | |
| INVOICE_COUNTRY | VARCHAR2 | (60) | Invoice To Country | |
| INVOICE_COUNTY | VARCHAR2 | (60) | Invoice To County | |
| INVOICE_CUSTOMER | VARCHAR2 | (360) | Invoice To Customer Name | |
| INVOICE_CUSTOMER_NUMBER | VARCHAR2 | (50) | Invoice To Customer Number | |
| INVOICE_POSTAL_CODE | VARCHAR2 | (60) | Invoice To Postal Code | |
| INVOICE_PROVINCE_INT | VARCHAR2 | (60) | Invoice To Province | |
| INVOICE_SITE | VARCHAR2 | (30) | Invoice To Site | |
| INVOICE_SITE_CODE | VARCHAR2 | (30) | Invoice To Site Code | |
| INVOICE_STATE | VARCHAR2 | (60) | Invoice To State | |
| INVOICE_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Invoice To Contact First Name | |
| INVOICE_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Invoice To Contact Last Name | |
| ORDERED_BY_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Ordered by contact first name | |
| ORDERED_BY_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ordered by contact last name | |
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Drop ship flag | |
| BOOKED_FLAG | VARCHAR2 | (1) | Booked flag | |
| CLOSED_FLAG | VARCHAR2 | (1) | Closed flag | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Cancelled flag | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| HEADER_PO_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| PO_ATTRIBUTE_1 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_2 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_3 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_4 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_5 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_6 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_7 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_8 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_9 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_10 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_11 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_12 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_13 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_14 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_ATTRIBUTE_15 | VARCHAR2 | (240) | PO specific Descriptive Flexfield segment | |
| PO_REVISION_DATE | DATE | PO revision date | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program that last updated row. | ||
| PROGRAM_ID | NUMBER | Concurrent program that last updated row. | ||
| PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| REQUEST_DATE | DATE | Request date | ||
| SUBMISSION_DATETIME | DATE | Submission datetime | ||
| OPERATION_CODE | VARCHAR2 | (30) | Operation code | |
| ERROR_FLAG | VARCHAR2 | (1) | Error flag | |
| READY_FLAG | VARCHAR2 | (1) | Ready flag | |
| STATUS_FLAG | VARCHAR2 | (1) | Status flag | |
| FORCE_APPLY_FLAG | VARCHAR2 | (1) | Force apply flag | |
| INTERFACE_STATUS | VARCHAR2 | (1000) | Interface status | |
| CHANGE_REASON | VARCHAR2 | (30) | Change reasons | |
| CHANGE_COMMENTS | VARCHAR2 | (2000) | Change comments | |
| ORDER_CATEGORY | VARCHAR2 | (30) | Order category | |
| SOLD_FROM_ORG_ID | NUMBER | Sold from org id | ||
| SOLD_FROM_ORG | VARCHAR2 | (240) | Sold from org | |
| REJECTED_FLAG | VARCHAR2 | (1) | Rejected flag | |
| TP_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| CREDIT_CARD_APPROVAL_DATE | DATE | Credit card approval date | ||
| SALES_CHANNEL | VARCHAR2 | (80) | To derive sales compensation. | |
| CUSTOMER_PREFERENCE_SET_CODE | VARCHAR2 | (30) | Indicates whether items on the order must ship/arrive together | |
| PRICE_REQUEST_CODE | VARCHAR2 | (240) | Code identifies pricing transaction applied to Order Header interface | |
| ORIG_SYS_CUSTOMER_REF | VARCHAR2 | (50) | Pass this value if you are creating a new sold to customer. There should a record in oe_customer_info_iface_all for this reference | |
| ORIG_SHIP_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new ship to address. There should a record in oe_customer_info_iface_all for this reference | |
| ORIG_BILL_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new bill to address. There should a record in oe_customer_info_iface_all for this reference | |
| ORIG_DELIVER_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new deliver to address. There should a record in oe_customer_info_iface_all for this reference | |
| SOLD_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new sold to contact. There should a record in oe_customer_info_iface_all for this reference | |
| SHIP_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new ship to contact. There should a record in oe_customer_info_iface_all for this reference | |
| BILL_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new bill to contact. There should a record in oe_customer_info_iface_all for this reference | |
| DELIVER_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new deliver to contact. There should a record in oe_customer_info_iface_all for this reference | |
| DELIVER_TO_ADDRESS1 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS2 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS3 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS4 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_CITY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_COUNTY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_COUNTRY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_PROVINCE | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_POSTAL_CODE | VARCHAR2 | (60) | Delivery address | |
| BATCH_ID | NUMBER | Internal Batch Identifier for orders imported in BULK mode. | ||
| ATTRIBUTE_STATUS | VARCHAR2 | (2000) | Internal Batch Identifier for attributes that failedprocessing in BULK mode. | |
| XML_MESSAGE_ID | NUMBER | This is to store the unique id for each XML Message processed. This id will be used to get the Control Area Data which is stored in XML Gateway tables to send on the Outbound Message. | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | Id for the Ship to Customer | ||
| INVOICE_CUSTOMER_ID | NUMBER | Id for the Bill to Customer | ||
| DELIVER_TO_CUSTOMER_ID | NUMBER | Id for Deliver to Customer | ||
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | Number of accounting periods, across which revenue is recognized. | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| XML_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | This Code will determine the transaction that Inserted the data into the interface tables. | |
| BLANKET_NUMBER | NUMBER | Sales Agreement Number | ||
| PRICING_DATE | DATE | Pricing Date | ||
| SOLD_TO_PHONE_ID | NUMBER | Phone number of Sold to Customer | ||
| TRANSACTION_PHASE_CODE | VARCHAR2 | (30) | Indicates if Transaction is in negotitation or fulfillment phase | |
| SALES_DOCUMENT_NAME | VARCHAR2 | (240) | Stores Quote Name for Orders under negotiation. | |
| QUOTE_NUMBER | NUMBER | This is populated for Orders under negotiation | ||
| QUOTE_DATE | DATE | Populated using defaulting rules. | ||
| USER_STATUS_CODE | VARCHAR2 | (30) | User entered status | |
| SOLD_TO_SITE_USE_ID | NUMBER | Customer Location | ||
| SUPPLIER_SIGNATURE | VARCHAR2 | (240) | Supplier Name | |
| SUPPLIER_SIGNATURE_DATE | DATE | Date when supplier signed on the document. | ||
| CUSTOMER_SIGNATURE | VARCHAR2 | (240) | Customer Name | |
| CUSTOMER_SIGNATURE_DATE | DATE | Date when customer signed on the document | ||
| SOLD_TO_PARTY_ID | NUMBER | Party Id of the Sold To customer | ||
| SOLD_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Sold To customer contact | ||
| SHIP_TO_PARTY_ID | NUMBER | Party Id of the Ship To customer | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Ship To customer | ||
| SHIP_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Ship To customer | ||
| DELIVER_TO_PARTY_ID | NUMBER | Party Id of the Deliver To customer | ||
| DELIVER_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Deliver To customer | ||
| DELIVER_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Deliver To customer | ||
| INVOICE_TO_PARTY_ID | NUMBER | Party Id of the Bill To customer | ||
| INVOICE_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Bill To customer | ||
| INVOICE_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Bill To customer | ||
| SHIP_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Ship To customer | ||
| DELIVER_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Deliver To customer | ||
| INVOICE_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Bill To customer | ||
| SOLD_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Sold To customer | |
| SHIP_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Ship To customer | |
| INVOICE_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Bill To customer | |
| DELIVER_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Deliver To customer | |
| RESPONSE_FLAG | VARCHAR2 | (1) | Used to indicate,whether order import data is a response to a previous outbound electronic message. | |
| END_CUSTOMER_NAME | VARCHAR2 | (360) | End customer name | |
| END_CUSTOMER_NUMBER | VARCHAR2 | (50) | End customer number | |
| END_CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the end customer | |
| END_CUSTOMER_ID | NUMBER | Customer Id of the end customer | ||
| END_CUSTOMER_PARTY_ID | NUMBER | Party Id of the end customer | ||
| END_CUSTOMER_ORG_CONTACT_ID | NUMBER | Contact Id of the end customer | ||
| END_CUSTOMER_CONTACT_ID | NUMBER | Contact Id of the end customer contact | ||
| END_CUSTOMER_CONTACT | VARCHAR2 | (360) | Name of the end customer contact | |
| END_CUSTOMER_LOCATION | VARCHAR2 | (240) | Location of the end customer | |
| END_CUSTOMER_SITE_USE_ID | NUMBER | Site Use Id of the end customer | ||
| END_CUSTOMER_PARTY_SITE_ID | NUMBER | Party Site Id of the end customer | ||
| END_CUSTOMER_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the end customer | ||
| END_CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_CITY | VARCHAR2 | (60) | End customer city | |
| END_CUSTOMER_STATE | VARCHAR2 | (60) | End customer state | |
| END_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | End customer zip code | |
| END_CUSTOMER_COUNTRY | VARCHAR2 | (60) | End customer country | |
| END_CUSTOMER_PROVINCE | VARCHAR2 | (60) | End customer province | |
| END_CUSTOMER_COUNTY | VARCHAR2 | (60) | End customer county | |
| IB_OWNER | VARCHAR2 | (60) | Install Base Owner | |
| IB_CURRENT_LOCATION | VARCHAR2 | (60) | Install Base current location | |
| IB_INSTALLED_AT_LOCATION | VARCHAR2 | (60) | Installed at location | |
| SOLD_TO_LOCATION_ADDRESS1 | VARCHAR2 | (240) | Address for Sold To location | |
| SOLD_TO_LOCATION_ADDRESS2 | VARCHAR2 | (240) | Address for Sold To location | |
| SOLD_TO_LOCATION_ADDRESS3 | VARCHAR2 | (240) | Address for Sold To location | |
| SOLD_TO_LOCATION_ADDRESS4 | VARCHAR2 | (240) | Address for Sold To location | |
| SOLD_TO_LOCATION_CITY | VARCHAR2 | (60) | Sold To location city | |
| SOLD_TO_LOCATION_POSTAL_CODE | VARCHAR2 | (60) | Sold To location zip | |
| SOLD_TO_LOCATION_COUNTRY | VARCHAR2 | (60) | Sold To location country | |
| SOLD_TO_LOCATION_STATE | VARCHAR2 | (60) | Sold To location state | |
| SOLD_TO_LOCATION_COUNTY | VARCHAR2 | (60) | Sold To location county | |
| SOLD_TO_LOCATION_PROVINCE | VARCHAR2 | (60) | Sold To location province | |
| ORIG_SOLD_ADDRESS_REF | VARCHAR2 | (50) | Address reference pointing to the new address record in oe_customer_info_iface_all | |
| EXPIRATION_DATE | DATE | Expiration Date | ||
| ORDER_FIRMED_DATE | DATE | Demand firm date | ||
| DELIVER_TO_STATE | VARCHAR2 | (60) | Deliver To customer state | |
| IB_OWNER_CODE | VARCHAR2 | (30) | To capture IB Owner Information | |
| IB_INSTALLED_AT_LOCATION_CODE | VARCHAR2 | (30) | To capture IB Installed at Location information. | |
| IB_CURRENT_LOCATION_CODE | VARCHAR2 | (30) | To capture IB Current Location Information. | |
| INELIGIBLE_FOR_HVOP | VARCHAR2 | (1) | HVOP import process will use this column to flag orders not eligible for HVOP run so that such orders can be processed by Standard Order Import. | |
| INSTRUMENT_SECURITY_CODE | VARCHAR2 | (10) | Instrument Security Code | |
| INST_ID | NUMBER | used in RAC INSTANCE AFFINITY for context setting |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE
, ORDER_SOURCE
, ORG_ID
, HEADER_ID
, ORDER_NUMBER
, VERSION_NUMBER
, ORDERED_DATE
, ORDER_TYPE_ID
, ORDER_TYPE
, PRICE_LIST_ID
, PRICE_LIST
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, CONVERSION_TYPE_CODE
, CONVERSION_TYPE
, TRANSACTIONAL_CURR_CODE
, TRANSACTIONAL_CURR
, SALESREP_ID
, SALESREP
, SALES_CHANNEL_CODE
, RETURN_REASON_CODE
, TAX_POINT_CODE
, TAX_POINT
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON
, AGREEMENT_ID
, AGREEMENT
, INVOICING_RULE_ID
, INVOICING_RULE
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE
, PAYMENT_TERM_ID
, PAYMENT_TERM
, DEMAND_CLASS_CODE
, DEMAND_CLASS
, SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY
, SHIPPING_METHOD_CODE
, SHIPPING_METHOD
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_TERMS
, FOB_POINT_CODE
, FOB_POINT
, PARTIAL_SHIPMENTS_ALLOWED
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, ORDER_DATE_TYPE_CODE
, EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT
, CUSTOMER_PO_NUMBER
, CUSTOMER_PAYMENT_TERM_ID
, CUSTOMER_PAYMENT_TERM
, PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT
, CHECK_NUMBER
, CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE
, SOLD_TO_ORG_ID
, SOLD_TO_ORG
, SHIP_FROM_ORG_ID
, SHIP_FROM_ORG
, SHIP_TO_ORG_ID
, SHIP_TO_ORG
, INVOICE_TO_ORG_ID
, INVOICE_TO_ORG
, DELIVER_TO_ORG_ID
, DELIVER_TO_ORG
, DELIVER_TO_CUSTOMER_NUMBER
, DELIVER_TO_CUSTOMER
, SOLD_TO_CONTACT_ID
, SOLD_TO_CONTACT
, SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_CONTACT
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, SHIPMENT_PRIORITY_CODE_INT
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_COUNTY
, SHIP_TO_CUSTOMER
, SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_POSTAL_CODE
, SHIP_TO_PROVINCE
, SHIP_TO_SITE_INT
, SHIP_TO_STATE
, SHIP_TO_COUNTRY
, INVOICE_ADDRESS1
, INVOICE_ADDRESS2
, INVOICE_ADDRESS3
, INVOICE_ADDRESS4
, INVOICE_CITY
, INVOICE_COUNTRY
, INVOICE_COUNTY
, INVOICE_CUSTOMER
, INVOICE_CUSTOMER_NUMBER
, INVOICE_POSTAL_CODE
, INVOICE_PROVINCE_INT
, INVOICE_SITE
, INVOICE_SITE_CODE
, INVOICE_STATE
, INVOICE_TO_CONTACT_FIRST_NAME
, INVOICE_TO_CONTACT_LAST_NAME
, ORDERED_BY_CONTACT_FIRST_NAME
, ORDERED_BY_CONTACT_LAST_NAME
, DROP_SHIP_FLAG
, BOOKED_FLAG
, CLOSED_FLAG
, CANCELLED_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, HEADER_PO_CONTEXT
, PO_ATTRIBUTE_1
, PO_ATTRIBUTE_2
, PO_ATTRIBUTE_3
, PO_ATTRIBUTE_4
, PO_ATTRIBUTE_5
, PO_ATTRIBUTE_6
, PO_ATTRIBUTE_7
, PO_ATTRIBUTE_8
, PO_ATTRIBUTE_9
, PO_ATTRIBUTE_10
, PO_ATTRIBUTE_11
, PO_ATTRIBUTE_12
, PO_ATTRIBUTE_13
, PO_ATTRIBUTE_14
, PO_ATTRIBUTE_15
, PO_REVISION_DATE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, REQUEST_DATE
, SUBMISSION_DATETIME
, OPERATION_CODE
, ERROR_FLAG
, READY_FLAG
, STATUS_FLAG
, FORCE_APPLY_FLAG
, INTERFACE_STATUS
, CHANGE_REASON
, CHANGE_COMMENTS
, ORDER_CATEGORY
, SOLD_FROM_ORG_ID
, SOLD_FROM_ORG
, REJECTED_FLAG
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, CREDIT_CARD_APPROVAL_DATE
, SALES_CHANNEL
, CUSTOMER_PREFERENCE_SET_CODE
, PRICE_REQUEST_CODE
, ORIG_SYS_CUSTOMER_REF
, ORIG_SHIP_ADDRESS_REF
, ORIG_BILL_ADDRESS_REF
, ORIG_DELIVER_ADDRESS_REF
, SOLD_TO_CONTACT_REF
, SHIP_TO_CONTACT_REF
, BILL_TO_CONTACT_REF
, DELIVER_TO_CONTACT_REF
, DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY
, DELIVER_TO_COUNTY
, DELIVER_TO_COUNTRY
, DELIVER_TO_PROVINCE
, DELIVER_TO_POSTAL_CODE
, BATCH_ID
, ATTRIBUTE_STATUS
, XML_MESSAGE_ID
, SHIP_TO_CUSTOMER_ID
, INVOICE_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_ID
, ACCOUNTING_RULE_DURATION
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, XML_TRANSACTION_TYPE_CODE
, BLANKET_NUMBER
, PRICING_DATE
, SOLD_TO_PHONE_ID
, TRANSACTION_PHASE_CODE
, SALES_DOCUMENT_NAME
, QUOTE_NUMBER
, QUOTE_DATE
, USER_STATUS_CODE
, SOLD_TO_SITE_USE_ID
, SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE
, SOLD_TO_PARTY_ID
, SOLD_TO_ORG_CONTACT_ID
, SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_SITE_USE_ID
, DELIVER_TO_PARTY_ID
, DELIVER_TO_PARTY_SITE_ID
, DELIVER_TO_PARTY_SITE_USE_ID
, INVOICE_TO_PARTY_ID
, INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_SITE_USE_ID
, SHIP_TO_ORG_CONTACT_ID
, DELIVER_TO_ORG_CONTACT_ID
, INVOICE_TO_ORG_CONTACT_ID
, SOLD_TO_PARTY_NUMBER
, SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER
, RESPONSE_FLAG
, END_CUSTOMER_NAME
, END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID
, END_CUSTOMER_PARTY_ID
, END_CUSTOMER_ORG_CONTACT_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_CONTACT
, END_CUSTOMER_LOCATION
, END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_PARTY_SITE_USE_ID
, END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY
, END_CUSTOMER_STATE
, END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY
, END_CUSTOMER_PROVINCE
, END_CUSTOMER_COUNTY
, IB_OWNER
, IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION
, SOLD_TO_LOCATION_ADDRESS1
, SOLD_TO_LOCATION_ADDRESS2
, SOLD_TO_LOCATION_ADDRESS3
, SOLD_TO_LOCATION_ADDRESS4
, SOLD_TO_LOCATION_CITY
, SOLD_TO_LOCATION_POSTAL_CODE
, SOLD_TO_LOCATION_COUNTRY
, SOLD_TO_LOCATION_STATE
, SOLD_TO_LOCATION_COUNTY
, SOLD_TO_LOCATION_PROVINCE
, ORIG_SOLD_ADDRESS_REF
, EXPIRATION_DATE
, ORDER_FIRMED_DATE
, DELIVER_TO_STATE
, IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE
, INELIGIBLE_FOR_HVOP
, INSTRUMENT_SECURITY_CODE
, INST_ID
FROM ONT.OE_HEADERS_IFACE_ALL;
ONT.OE_HEADERS_IFACE_ALL does not reference any database object
ONT.OE_HEADERS_IFACE_ALL is referenced by following:
ONT
OE_HEADERS_IFACE_ALL#
|
|
|
|