[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_HEADER_ACKS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ONT.OE_HEADER_ACKS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows information about the acknowledgements for Order Headers.
| 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 | |
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | Number of accounting periods, across which revenue is recognized. | |
| 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 | |
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | Customer payment term id | ||
| 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 | |
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Drop ship flag | |
| 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 | ||
| SOLD_TO_PHONE_ID | NUMBER | Phone number for Sold to Customer | ||
| 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 | |
| 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 | |
| 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 identifier | ||
| 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 | |
| ORDER_CATEGORY_CODE | VARCHAR2 | (30) | Order category 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 Address 1 | |
| INVOICE_ADDRESS_2 | VARCHAR2 | (240) | Invoice To Address 2 | |
| INVOICE_ADDRESS_3 | VARCHAR2 | (240) | Invoice To Address 3 | |
| INVOICE_ADDRESS_4 | VARCHAR2 | (240) | Invoice To Address 4 | |
| 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 First 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 | ||
| TRANSACTION_METHOD | CHAR | (1) | Always "E" | |
| TEST_INDICATOR | VARCHAR2 | (1) | Yes | EDI Test Flag |
| DOCUMENT_ID | VARCHAR2 | (6) | Yes | EDI Document ID |
| TP_TRANSLATOR_CODE | VARCHAR2 | (30) | EDI Translator Code | |
| TP_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Trading Partner Reference 1 (Ext) | |
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Trading Partner Reference 2 (Ext) | |
| DOCUMENT_STANDARD | VARCHAR2 | (30) | EDI Document Standard | |
| ECE_TP_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield Context | |
| ECE_TP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_DETL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield Context | |
| ECE_TP_DETL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_DETL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_DETL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_DETL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| ECE_TP_DETL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
| SHIP_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI location code for ship to site | |
| SOLD_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | Stores the EDI location code. It should be unique for a customer. The column accepts free-form text. | |
| 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 code | |
| 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 last name | |
| TRANSACTION_DATE | DATE | Current Date | ||
| DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | EDI Document Type |
| DOCUMENT_PURPOSE_CODE | CHAR | (2) | Set to "OR" | |
| DOCUMENT_CODE | VARCHAR2 | (50) | Document code | |
| SHIP_FROM_ADDRESS_1 | VARCHAR2 | (240) | Address Line 1 for the Ship From Address | |
| SHIP_FROM_ADDRESS_2 | VARCHAR2 | (240) | Address Line 2 for the Ship From Address | |
| SHIP_FROM_ADDRESS_3 | VARCHAR2 | (240) | Address Line 3 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_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_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code 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) | Trading Partner Context | |
| 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 | 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. | ||
| BLANKET_NUMBER | NUMBER | Reference to Blanket Sales Agreement | ||
| BOOKED_DATE | DATE | Indicates the date when the order was booked | ||
| FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status code 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 | |
| QUOTE_DATE | DATE | Populated using defaulting rules | ||
| QUOTE_NUMBER | NUMBER | This is populated for Orders under negotiation | ||
| SALES_DOCUMENT_NAME | VARCHAR2 | (240) | Quote Name for Orders under negotiation | |
| TRANSACTION_PHASE_CODE | VARCHAR2 | (30) | Indicates if Transaction is in negotitation or fulfillment phase | |
| 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_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_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of End Customer Location | |
| END_CUSTOMER_COUNTRY | VARCHAR2 | (60) | Country 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_INSTALLED_AT_LOCATION | VARCHAR2 | (60) | Default Installed At Location | |
| IB_CURRENT_LOCATION | VARCHAR2 | (60) | Default Current 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_STATE | VARCHAR2 | (60) | State 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_PROVINCE | VARCHAR2 | (60) | Province of Customer Location | |
| SOLD_TO_LOCATION_COUNTY | VARCHAR2 | (60) | County 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 | |
| END_CUSTOMER_CITY | VARCHAR2 | (60) | City of End Customer Location | |
| IB_OWNER_CODE | VARCHAR2 | (30) | Ib Owner Code | |
| IB_CURRENT_LOCATION_CODE | VARCHAR2 | (30) | Ib Current Location Code | |
| IB_INSTALLED_AT_LOCATION_CODE | VARCHAR2 | (30) | Ib Installed At Location Code |
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
, ACCOUNTING_RULE_DURATION
, 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
, CUSTOMER_PAYMENT_TERM_ID
, PRICE_LIST
, PRICE_LIST_ID
, PRICING_DATE
, SHIP_FROM_ORG_ID
, SHIP_FROM_ORG
, SHIP_TO_ORG_ID
, SHIP_TO_ORG
, DROP_SHIP_FLAG
, SOLD_FROM_ORG
, SOLD_FROM_ORG_ID
, SOLD_TO_ORG
, SOLD_TO_ORG_ID
, SOLD_TO_PHONE_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, 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
, ORDER_CATEGORY_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
, TRANSACTION_METHOD
, TEST_INDICATOR
, DOCUMENT_ID
, TP_TRANSLATOR_CODE
, TP_LOCATION_CODE
, TP_DESCRIPTION
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, DOCUMENT_STANDARD
, ECE_TP_ATTRIBUTE_CATEGORY
, ECE_TP_ATTRIBUTE1
, ECE_TP_ATTRIBUTE2
, ECE_TP_ATTRIBUTE3
, ECE_TP_ATTRIBUTE4
, ECE_TP_ATTRIBUTE5
, ECE_TP_ATTRIBUTE6
, ECE_TP_ATTRIBUTE7
, ECE_TP_ATTRIBUTE8
, ECE_TP_ATTRIBUTE9
, ECE_TP_ATTRIBUTE10
, ECE_TP_ATTRIBUTE11
, ECE_TP_ATTRIBUTE12
, ECE_TP_ATTRIBUTE13
, ECE_TP_ATTRIBUTE14
, ECE_TP_ATTRIBUTE15
, ECE_TP_DETL_ATTRIBUTE_CATEGORY
, ECE_TP_DETL_ATTRIBUTE1
, ECE_TP_DETL_ATTRIBUTE2
, ECE_TP_DETL_ATTRIBUTE3
, ECE_TP_DETL_ATTRIBUTE4
, ECE_TP_DETL_ATTRIBUTE5
, 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
, TRANSACTION_DATE
, DOCUMENT_TYPE
, DOCUMENT_PURPOSE_CODE
, DOCUMENT_CODE
, SHIP_FROM_ADDRESS_1
, SHIP_FROM_ADDRESS_2
, SHIP_FROM_ADDRESS_3
, SHIP_FROM_CITY
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_FROM_REGION1
, SHIP_FROM_REGION2
, SHIP_FROM_REGION3
, SHIP_FROM_EDI_LOCATION_CODE
, 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
, 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
, QUOTE_DATE
, QUOTE_NUMBER
, SALES_DOCUMENT_NAME
, TRANSACTION_PHASE_CODE
, 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_STATE
, END_CUSTOMER_COUNTY
, END_CUSTOMER_PROVINCE
, END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY
, END_CUSTOMER_CONTACT
, END_CUSTOMER_CONTACT_LAST_NAME
, END_CUSTOMER_CONTACT_FIRST_NAM
, END_CUSTOMER_NAME
, IB_OWNER
, IB_INSTALLED_AT_LOCATION
, IB_CURRENT_LOCATION
, SOLD_TO_LOCATION_ADDRESS1
, SOLD_TO_LOCATION_ADDRESS2
, SOLD_TO_LOCATION_ADDRESS3
, SOLD_TO_LOCATION_ADDRESS4
, SOLD_TO_LOCATION_CITY
, SOLD_TO_LOCATION_STATE
, SOLD_TO_LOCATION_POSTAL_CODE
, SOLD_TO_LOCATION_COUNTRY
, SOLD_TO_LOCATION_PROVINCE
, SOLD_TO_LOCATION_COUNTY
, 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
, END_CUSTOMER_CITY
, IB_OWNER_CODE
, IB_CURRENT_LOCATION_CODE
, IB_INSTALLED_AT_LOCATION_CODE
FROM APPS.OE_HEADER_ACKS_V;
APPS
ECE_TP_DETAILS
ECE_TP_HEADERS
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_SITES
HZ_CUST_SITE_USES_ALL
HZ_PARTIES
OE_HEADER_ACKS
APPS.OE_HEADER_ACKS_V is not referenced by any database object
|
|
|
|