DBA Data[Home] [Help] [Dependency Information]

TABLE: ONT.OE_HEADER_ACKS

Object Details
Object Name: OE_HEADER_ACKS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_HEADER_ACKS
Subobject Name:
Status: VALID


This is the acknowledgment table for Order Management sales order headers. This table contains sales order header information and is populated by both EDI and XML transactions when acknowledgments are required.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Header Acknowledgments
Category: BUSINESS_ENTITY ONT_SALES_ORDER


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_HEADER_ACKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORIG_SYS_DOCUMENT_REF
OE_HEADER_ACKS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnHEADER_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

Header id
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Original system document reference
ORDER_NUMBER NUMBER

Order number
ORDERED_DATE DATE

Ordered date
ORG_ID NUMBER

Org id
CHANGE_DATE DATE

Change date
CHANGE_SEQUENCE VARCHAR2 (50)
Change sequence
ACCOUNTING_RULE_ID NUMBER

Accounting id rule used by AR for generating Invoice
ACCOUNTING_RULE VARCHAR2 (30)
Accounting rule used by AR for generating Invoice
ACKNOWLEDGMENT_FLAG VARCHAR2 (1)
Acknowledgment flag
FIRST_ACK_CODE VARCHAR2 (30)
Code used when first acknowledged
LAST_ACK_CODE VARCHAR2 (30)
Code used when last acknowledged
FIRST_ACK_DATE DATE

Date first acknowledged
LAST_ACK_DATE DATE

Date last acknowledged
BUYER_SELLER_FLAG VARCHAR2 (1)
Buyer seller flag
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
BOOKED_FLAG VARCHAR2 (1)
Booked flag
AGREEMENT_ID NUMBER

Agreement id
AGREEMENT VARCHAR2 (240)
Agreement
AGREEMENT_NAME VARCHAR2 (30)
Agreement name
CONTEXT VARCHAR2 (30)
Descriptive Flex-field segment
PRICE_LIST VARCHAR2 (240)
Price list
PRICE_LIST_ID NUMBER

Price list id
PRICING_DATE DATE

Pricing date
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
SOLD_FROM_ORG VARCHAR2 (240)
Sold from org
SOLD_FROM_ORG_ID NUMBER

Sold from org id
SOLD_TO_ORG VARCHAR2 (360)
Sold to org
SOLD_TO_ORG_ID NUMBER

Sold to org id
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
CANCELLED_FLAG VARCHAR2 (1)
Cancelled flag
CLOSED_FLAG VARCHAR2 (1)
Closed flag
CONVERSION_RATE NUMBER

Conversion rate
CONVERSION_RATE_DATE DATE

Conversion rate date
CONVERSION_TYPE VARCHAR2 (30)
Conversion type
CONVERSION_TYPE_CODE VARCHAR2 (30)
Conversion type code
CUST_PO_NUMBER VARCHAR2 (50)
Customer PO number
CUSTOMER_ID NUMBER

Customer id
CUSTOMER_NAME VARCHAR2 (360)
Customer name
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
DELIVER_TO_CONTACT VARCHAR2 (330)
Deliver to contact
DELIVER_TO_CONTACT_ID NUMBER

Deliver to contact id
DELIVER_TO_CUSTOMER VARCHAR2 (360)
Deliver to customer
DELIVER_TO_CUSTOMER_NUMBER VARCHAR2 (50)
Deliver to customer number
DELIVER_TO_ORG VARCHAR2 (240)
Deliver to org
DELIVER_TO_ORG_ID NUMBER

Deliver to org id
DEMAND_CLASS VARCHAR2 (80)
Demand class
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand class code
EARLIEST_SCHEDULE_LIMIT NUMBER

Earliest schedule limit
LATEST_SCHEDULE_LIMIT NUMBER

Latest schedule limit
ERROR_FLAG VARCHAR2 (1)
Error flag
EXPIRATION_DATE DATE

Expiration date
FOB_POINT VARCHAR2 (240)
FOB point
FOB_POINT_CODE VARCHAR2 (30)
FOB point code
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight Carrier code
FREIGHT_TERMS VARCHAR2 (80)
Freight terms
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight terms code
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.
HEADER_PO_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
INTERFACE_STATUS VARCHAR2 (1000)
Interface status
INVOICE_ADDRESS_1 VARCHAR2 (240)
Invoice To Address1
INVOICE_ADDRESS_2 VARCHAR2 (240)
Invoice To Address2
INVOICE_ADDRESS_3 VARCHAR2 (240)
Invoice To Address3
INVOICE_ADDRESS_4 VARCHAR2 (240)
Invoice To Address4
INVOICE_CITY VARCHAR2 (240)
Invoice To City
INVOICE_COUNTRY VARCHAR2 (240)
Invoice To Country
INVOICE_COUNTY VARCHAR2 (240)
Invoice To County
INVOICE_CUSTOMER VARCHAR2 (360)
Invoice To Customer
INVOICE_CUSTOMER_NUMBER VARCHAR2 (50)
Invoice To Customer Number
INVOICE_POSTAL_CODE VARCHAR2 (240)
Invoice To Postal Code
INVOICE_PROVINCE_INT VARCHAR2 (240)
Invoice To Province
INVOICE_SITE VARCHAR2 (30)
Invoice To Site
INVOICE_SITE_CODE VARCHAR2 (240)
Invoice To Site Code
INVOICE_STATE VARCHAR2 (240)
Invoice To State
INVOICE_TO_CONTACT VARCHAR2 (330)
Invoice To Contact
INVOICE_TO_CONTACT_FIRST_NAME VARCHAR2 (240)
Invoice To Contact First Name
INVOICE_TO_CONTACT_ID NUMBER

Invoice To Contact ID
INVOICE_TO_CONTACT_LAST_NAME VARCHAR2 (240)
Invoice To Contact Last Name
INVOICE_TO_ORG VARCHAR2 (240)
Invoice To Organization
INVOICE_TO_ORG_ID NUMBER

Invoice To Organization ID
INVOICE_TOLERANCE_ABOVE NUMBER

Invoice Tolerance Above
INVOICE_TOLERANCE_BELOW NUMBER

Invoice Tolerance Below
INVOICING_RULE VARCHAR2 (30)
Invoicing rule used by AR for generating Invoice
INVOICING_RULE_ID NUMBER

Invoicing id rule used by AR for generating Invoice
OPEN_FLAG VARCHAR2 (1)
Open flag
OPERATION_CODE VARCHAR2 (30)
Operation code
ORDER_DATE_TYPE_CODE VARCHAR2 (30)
Order date type code
ORDER_SOURCE VARCHAR2 (240)
Order source
ORDER_SOURCE_ID NUMBER

Order source id
ORDER_TYPE VARCHAR2 (30)
Order type
ORDER_TYPE_ID NUMBER

Order type id
ORDERED_BY_CONTACT_FIRST_NAME VARCHAR2 (150)
Ordered by contact first name
ORDERED_BY_CONTACT_LAST_NAME VARCHAR2 (150)
Ordered by contact last name
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions
PARTIAL_SHIPMENTS_ALLOWED VARCHAR2 (1)
Partial shipments allowed
PAYMENT_TERM_ID NUMBER

Payment term id
PAYMENT_TERM VARCHAR2 (30)
Payment term
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
PROGRAM VARCHAR2 (30)
Program
PROGRAM_APPLICATION VARCHAR2 (30)
Program application
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
RELATED_PO_NUMBER VARCHAR2 (50)
Related po number
REMAINDER_ORDERS_ALLOWED VARCHAR2 (1)
Remainder orders allowed
REQUEST_DATE DATE

Request date
REQUEST_ID NUMBER

Concurrent request that last changed row
RETURN_REASON_CODE VARCHAR2 (30)
Return reason code
SALESREP_ID NUMBER

Salesrep id
SALESREP VARCHAR2 (240)
Salesrep
SHIP_TO_ADDRESS_1 VARCHAR2 (240)
Ship to address 1
SHIP_TO_ADDRESS_2 VARCHAR2 (240)
Ship to address 2
SHIP_TO_ADDRESS_3 VARCHAR2 (240)
Ship to address 3
SHIP_TO_ADDRESS_4 VARCHAR2 (240)
Ship to address 4
SHIP_TO_CITY VARCHAR2 (240)
Ship to city
SHIP_TO_CONTACT VARCHAR2 (330)
Ship to contact
SHIP_TO_CONTACT_FIRST_NAME VARCHAR2 (240)
Ship to contact first name
SHIP_TO_CONTACT_ID NUMBER

Ship to contact id
SHIP_TO_CONTACT_LAST_NAME VARCHAR2 (240)
Ship to contact last name
SHIP_TO_COUNTRY VARCHAR2 (240)
Ship to country
SHIP_TO_COUNTY VARCHAR2 (240)
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 (240)
Ship to postal code
SHIP_TO_PROVINCE VARCHAR2 (240)
Ship to province
SHIP_TO_SITE_INT VARCHAR2 (30)
Ship to site int
SHIP_TO_STATE VARCHAR2 (240)
Ship to state
SHIP_TOLERANCE_ABOVE NUMBER

Over Shipment/Return Tolerance
SHIP_TOLERANCE_BELOW NUMBER

Under Shipment/Return Tolerance
SHIPMENT_PRIORITY VARCHAR2 (80)
Shipment priority
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Shipment priority code
SHIPMENT_PRIORITY_CODE_INT VARCHAR2 (30)
Shipment priority code int
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions
SHIPPING_METHOD VARCHAR2 (80)
Shipping method
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method code
SOLD_TO_CONTACT VARCHAR2 (330)
Sold to contact
SOLD_TO_CONTACT_ID NUMBER

Sold to contact id
SOURCE_DOCUMENT_ID NUMBER

Source document id
SOURCE_DOCUMENT_TYPE_ID NUMBER

Source document type id
SUBMISSION_DATETIME DATE

Submission datetime
TAX_EXEMPT_FLAG VARCHAR2 (30)
Tax exempt flag
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Tax exempt number
TAX_EXEMPT_REASON VARCHAR2 (80)
Tax exempt reason
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax exempt reason code
TAX_POINT VARCHAR2 (80)
Tax point
TAX_POINT_CODE VARCHAR2 (30)
Tax point code
TRANSACTIONAL_CURR VARCHAR2 (80)
Transactional curr
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Transactional curr code
VERSION_NUMBER NUMBER

Version number
CUSTOMER_PAYMENT_TERM_ID NUMBER

Customer payment term id
DROP_SHIP_FLAG VARCHAR2 (1)
Drop ship flag
ORDER_CATEGORY_CODE VARCHAR2 (30)
Order category code
SHIP_TO_EDI_LOCATION_CODE VARCHAR2 (40)
EDI location code for ship to site.
SOLD_TO_EDI_LOCATION_CODE VARCHAR2 (40)
EDI location code for sold to site.
BILL_TO_EDI_LOCATION_CODE VARCHAR2 (40)
EDI location code for bill to site.
CUSTOMER_PAYMENT_TERM VARCHAR2 (30)
Customer payment term.
SOLD_TO_ADDRESS1 VARCHAR2 (240)
Sold to address1
SOLD_TO_ADDRESS2 VARCHAR2 (240)
Sold to address2
SOLD_TO_ADDRESS3 VARCHAR2 (240)
Sold to address3
SOLD_TO_ADDRESS4 VARCHAR2 (240)
Sold to address4
SOLD_TO_CITY VARCHAR2 (240)
Sold to city
SOLD_TO_POSTAL_CODE VARCHAR2 (240)
Sold to postal codes.
SOLD_TO_COUNTRY VARCHAR2 (240)
Sold to country.
SOLD_TO_STATE VARCHAR2 (240)
Sold to state.
SOLD_TO_COUNTY VARCHAR2 (240)
Sold to county.
SOLD_TO_PROVINCE VARCHAR2 (240)
Sold to province
SOLD_TO_CONTACT_LAST_NAME VARCHAR2 (240)
Sold to contact last name.
SOLD_TO_CONTACT_FIRST_NAME VARCHAR2 (240)
Sold to contact first name.
SHIP_FROM_ADDRESS_1 VARCHAR2 (240)
Address Line1 for the Ship From Address
SHIP_FROM_ADDRESS_2 VARCHAR2 (240)
Address Line2 for the Ship From Address
SHIP_FROM_ADDRESS_3 VARCHAR2 (240)
Address Line3 for the Ship from Address
SHIP_FROM_CITY VARCHAR2 (60)
City for the Ship From Address
SHIP_FROM_POSTAL_CODE VARCHAR2 (60)
Postal Code for the Ship from Address
SHIP_FROM_COUNTRY VARCHAR2 (60)
Country for the Ship From Address
SHIP_FROM_EDI_LOCATION_CODE VARCHAR2 (40)
EDI Location Code for the Ship From Address
SHIP_FROM_REGION1 VARCHAR2 (240)
Region 1 for the Ship From Address
SHIP_FROM_REGION2 VARCHAR2 (240)
Region 2 for the Ship From Address
SHIP_FROM_REGION3 VARCHAR2 (240)
Region 3 for the Ship From Address
SHIP_FROM_ADDRESS_ID NUMBER

Internal Address ID for the Ship From Address
SOLD_TO_ADDRESS_ID NUMBER

Internal Address ID
SHIP_TO_ADDRESS_ID NUMBER

Internal Address ID for the Ship To Address
INVOICE_ADDRESS_ID NUMBER

Internal Address ID for the Bill to Address
SHIP_TO_ADDRESS_CODE VARCHAR2 (240)
Address Code for the Ship To
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
XML_MESSAGE_ID NUMBER

his 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 the 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
ACKNOWLEDGMENT_TYPE VARCHAR2 (30)
The type of acknowledgement this data represents (3A4,3A6..)
BLANKET_NUMBER NUMBER

Reference to Sales Agreement
BOOKED_DATE DATE

Indicates the date when the order was booked
FLOW_STATUS_CODE VARCHAR2 (30)
Workflow status for the header
CREDIT_CARD_APPROVAL_DATE DATE

The date on which credit card authorization was taken.
PAYMENT_TYPE_CODE VARCHAR2 (30)
Stores the type of payment. Possible values for now: COMMITMENT, CREDIT_CARD or Null. Null is equivalent to COMMITMENT.
PAYMENT_AMOUNT NUMBER

Stores amount of payment written on check,or amount due for other instruments. This column is for informational purpose only.
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
CUSTOMER_PREFERENCE_SET_CODE VARCHAR2 (30)
Indicates whether items on the order must ship/arrive together
SALES_CHANNEL_CODE VARCHAR2 (30)
Sales channel through which order was placed
SOLD_TO_PHONE_ID NUMBER

Phone number for 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_NUMBER VARCHAR2 (30)
Unique identifier for the Sold To Party
SHIP_TO_PARTY_NUMBER VARCHAR2 (30)
Unique identifier for the Ship To Party
INVOICE_TO_PARTY_NUMBER VARCHAR2 (30)
Unique identifier for the Invoice To Party
DELIVER_TO_PARTY_NUMBER VARCHAR2 (30)
Unique identifier for the Deliver To Party
END_CUSTOMER_NUMBER VARCHAR2 (50)
Unique identifier for the End Customer
END_CUSTOMER_PARTY_NUMBER VARCHAR2 (30)
Unique identifier for the End Customer Party
END_CUSTOMER_ID NUMBER

End Customer Id
END_CUSTOMER_CONTACT_ID NUMBER

End Customer Contact Id
END_CUSTOMER_SITE_USE_ID NUMBER

End Customer Site Org Id
END_CUSTOMER_ADDRESS1 VARCHAR2 (240)
Address Line 1 of End Customer Location
END_CUSTOMER_ADDRESS2 VARCHAR2 (240)
Address Line 2 of End Customer Location
END_CUSTOMER_ADDRESS3 VARCHAR2 (240)
Address Line 3 of End Customer Location
END_CUSTOMER_ADDRESS4 VARCHAR2 (240)
Address Line 4 of End Customer Location
END_CUSTOMER_CITY VARCHAR2 (60)
City of End Customer Location
END_CUSTOMER_POSTAL_CODE VARCHAR2 (60)
Postal Code of End Customer Location
END_CUSTOMER_COUNTRY VARCHAR2 (60)
Country of End Customer Location
END_CUSTOMER_STATE VARCHAR2 (60)
State of End Customer Location
END_CUSTOMER_COUNTY VARCHAR2 (60)
County of End Customer Location
END_CUSTOMER_PROVINCE VARCHAR2 (60)
Province of End Customer Location
END_CUSTOMER_CONTACT VARCHAR2 (360)
End Customer Contact Name
END_CUSTOMER_CONTACT_LAST_NAME VARCHAR2 (240)
End Customer Contact Last Name
END_CUSTOMER_CONTACT_FIRST_NAM VARCHAR2 (240)
End Customer Contact First Name
END_CUSTOMER_NAME VARCHAR2 (360)
End Customer Name
IB_OWNER VARCHAR2 (60)
Default Owner
IB_CURRENT_LOCATION VARCHAR2 (60)
Default Current Location
IB_INSTALLED_AT_LOCATION VARCHAR2 (60)
Default Installed At Location
SOLD_TO_LOCATION_ADDRESS1 VARCHAR2 (240)
Address Line 1 of Customer Location
SOLD_TO_LOCATION_ADDRESS2 VARCHAR2 (240)
Address Line 2 of Customer Location
SOLD_TO_LOCATION_ADDRESS3 VARCHAR2 (240)
Address Line 3 of Customer Location
SOLD_TO_LOCATION_ADDRESS4 VARCHAR2 (240)
Address Line 4 of Customer Location
SOLD_TO_LOCATION_CITY VARCHAR2 (60)
City of Customer Location
SOLD_TO_LOCATION_POSTAL_CODE VARCHAR2 (60)
Postal Code of Customer Location
SOLD_TO_LOCATION_COUNTRY VARCHAR2 (60)
Country of Customer Location
SOLD_TO_LOCATION_STATE VARCHAR2 (60)
State of Customer Location
SOLD_TO_LOCATION_COUNTY VARCHAR2 (60)
County of Customer Location
SOLD_TO_LOCATION_PROVINCE VARCHAR2 (60)
Province of Customer Location
ORDER_FIRMED_DATE DATE

Not used
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_COUNTRY VARCHAR2 (60)
Delivery address
DELIVER_TO_COUNTY VARCHAR2 (60)
Delivery address
DELIVER_TO_POSTAL_CODE VARCHAR2 (60)
Delivery address
DELIVER_TO_PROVINCE VARCHAR2 (60)
Delivery address
DELIVER_TO_STATE VARCHAR2 (60)
Delivery address
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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HEADER_ID
,      ORIG_SYS_DOCUMENT_REF
,      ORDER_NUMBER
,      ORDERED_DATE
,      ORG_ID
,      CHANGE_DATE
,      CHANGE_SEQUENCE
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE
,      ACKNOWLEDGMENT_FLAG
,      FIRST_ACK_CODE
,      LAST_ACK_CODE
,      FIRST_ACK_DATE
,      LAST_ACK_DATE
,      BUYER_SELLER_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      BOOKED_FLAG
,      AGREEMENT_ID
,      AGREEMENT
,      AGREEMENT_NAME
,      CONTEXT
,      PRICE_LIST
,      PRICE_LIST_ID
,      PRICING_DATE
,      SHIP_FROM_ORG_ID
,      SHIP_FROM_ORG
,      SHIP_TO_ORG_ID
,      SHIP_TO_ORG
,      SOLD_FROM_ORG
,      SOLD_FROM_ORG_ID
,      SOLD_TO_ORG
,      SOLD_TO_ORG_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CANCELLED_FLAG
,      CLOSED_FLAG
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      CONVERSION_TYPE
,      CONVERSION_TYPE_CODE
,      CUST_PO_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      DELIVER_TO_CONTACT
,      DELIVER_TO_CONTACT_ID
,      DELIVER_TO_CUSTOMER
,      DELIVER_TO_CUSTOMER_NUMBER
,      DELIVER_TO_ORG
,      DELIVER_TO_ORG_ID
,      DEMAND_CLASS
,      DEMAND_CLASS_CODE
,      EARLIEST_SCHEDULE_LIMIT
,      LATEST_SCHEDULE_LIMIT
,      ERROR_FLAG
,      EXPIRATION_DATE
,      FOB_POINT
,      FOB_POINT_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS
,      FREIGHT_TERMS_CODE
,      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
,      HEADER_PO_CONTEXT
,      INTERFACE_STATUS
,      INVOICE_ADDRESS_1
,      INVOICE_ADDRESS_2
,      INVOICE_ADDRESS_3
,      INVOICE_ADDRESS_4
,      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
,      INVOICE_TO_CONTACT_FIRST_NAME
,      INVOICE_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_LAST_NAME
,      INVOICE_TO_ORG
,      INVOICE_TO_ORG_ID
,      INVOICE_TOLERANCE_ABOVE
,      INVOICE_TOLERANCE_BELOW
,      INVOICING_RULE
,      INVOICING_RULE_ID
,      OPEN_FLAG
,      OPERATION_CODE
,      ORDER_DATE_TYPE_CODE
,      ORDER_SOURCE
,      ORDER_SOURCE_ID
,      ORDER_TYPE
,      ORDER_TYPE_ID
,      ORDERED_BY_CONTACT_FIRST_NAME
,      ORDERED_BY_CONTACT_LAST_NAME
,      PACKING_INSTRUCTIONS
,      PARTIAL_SHIPMENTS_ALLOWED
,      PAYMENT_TERM_ID
,      PAYMENT_TERM
,      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
,      PROGRAM
,      PROGRAM_APPLICATION
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RELATED_PO_NUMBER
,      REMAINDER_ORDERS_ALLOWED
,      REQUEST_DATE
,      REQUEST_ID
,      RETURN_REASON_CODE
,      SALESREP_ID
,      SALESREP
,      SHIP_TO_ADDRESS_1
,      SHIP_TO_ADDRESS_2
,      SHIP_TO_ADDRESS_3
,      SHIP_TO_ADDRESS_4
,      SHIP_TO_CITY
,      SHIP_TO_CONTACT
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_CONTACT_LAST_NAME
,      SHIP_TO_COUNTRY
,      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_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      SHIPMENT_PRIORITY
,      SHIPMENT_PRIORITY_CODE
,      SHIPMENT_PRIORITY_CODE_INT
,      SHIPPING_INSTRUCTIONS
,      SHIPPING_METHOD
,      SHIPPING_METHOD_CODE
,      SOLD_TO_CONTACT
,      SOLD_TO_CONTACT_ID
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      SUBMISSION_DATETIME
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON
,      TAX_EXEMPT_REASON_CODE
,      TAX_POINT
,      TAX_POINT_CODE
,      TRANSACTIONAL_CURR
,      TRANSACTIONAL_CURR_CODE
,      VERSION_NUMBER
,      CUSTOMER_PAYMENT_TERM_ID
,      DROP_SHIP_FLAG
,      ORDER_CATEGORY_CODE
,      SHIP_TO_EDI_LOCATION_CODE
,      SOLD_TO_EDI_LOCATION_CODE
,      BILL_TO_EDI_LOCATION_CODE
,      CUSTOMER_PAYMENT_TERM
,      SOLD_TO_ADDRESS1
,      SOLD_TO_ADDRESS2
,      SOLD_TO_ADDRESS3
,      SOLD_TO_ADDRESS4
,      SOLD_TO_CITY
,      SOLD_TO_POSTAL_CODE
,      SOLD_TO_COUNTRY
,      SOLD_TO_STATE
,      SOLD_TO_COUNTY
,      SOLD_TO_PROVINCE
,      SOLD_TO_CONTACT_LAST_NAME
,      SOLD_TO_CONTACT_FIRST_NAME
,      SHIP_FROM_ADDRESS_1
,      SHIP_FROM_ADDRESS_2
,      SHIP_FROM_ADDRESS_3
,      SHIP_FROM_CITY
,      SHIP_FROM_POSTAL_CODE
,      SHIP_FROM_COUNTRY
,      SHIP_FROM_EDI_LOCATION_CODE
,      SHIP_FROM_REGION1
,      SHIP_FROM_REGION2
,      SHIP_FROM_REGION3
,      SHIP_FROM_ADDRESS_ID
,      SOLD_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      INVOICE_ADDRESS_ID
,      SHIP_TO_ADDRESS_CODE
,      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
,      XML_MESSAGE_ID
,      SHIP_TO_CUSTOMER_ID
,      INVOICE_CUSTOMER_ID
,      DELIVER_TO_CUSTOMER_ID
,      ACCOUNTING_RULE_DURATION
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ACKNOWLEDGMENT_TYPE
,      BLANKET_NUMBER
,      BOOKED_DATE
,      FLOW_STATUS_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      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
,      CUSTOMER_PREFERENCE_SET_CODE
,      SALES_CHANNEL_CODE
,      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_NUMBER
,      SHIP_TO_PARTY_NUMBER
,      INVOICE_TO_PARTY_NUMBER
,      DELIVER_TO_PARTY_NUMBER
,      END_CUSTOMER_NUMBER
,      END_CUSTOMER_PARTY_NUMBER
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      END_CUSTOMER_ADDRESS1
,      END_CUSTOMER_ADDRESS2
,      END_CUSTOMER_ADDRESS3
,      END_CUSTOMER_ADDRESS4
,      END_CUSTOMER_CITY
,      END_CUSTOMER_POSTAL_CODE
,      END_CUSTOMER_COUNTRY
,      END_CUSTOMER_STATE
,      END_CUSTOMER_COUNTY
,      END_CUSTOMER_PROVINCE
,      END_CUSTOMER_CONTACT
,      END_CUSTOMER_CONTACT_LAST_NAME
,      END_CUSTOMER_CONTACT_FIRST_NAM
,      END_CUSTOMER_NAME
,      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
,      ORDER_FIRMED_DATE
,      DELIVER_TO_ADDRESS1
,      DELIVER_TO_ADDRESS2
,      DELIVER_TO_ADDRESS3
,      DELIVER_TO_ADDRESS4
,      DELIVER_TO_CITY
,      DELIVER_TO_COUNTRY
,      DELIVER_TO_COUNTY
,      DELIVER_TO_POSTAL_CODE
,      DELIVER_TO_PROVINCE
,      DELIVER_TO_STATE
,      IB_OWNER_CODE
,      IB_INSTALLED_AT_LOCATION_CODE
,      IB_CURRENT_LOCATION_CODE
FROM ONT.OE_HEADER_ACKS;

Dependencies

[top of page]

ONT.OE_HEADER_ACKS does not reference any database object

ONT.OE_HEADER_ACKS is referenced by following:

SchemaAPPS
SynonymOE_HEADER_ACKS