[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_AR_TRX_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_AR_TRX_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
ECE_AR_TRX_HEADERS contains customer invoice header data to support
the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_HEADERS is based primarily on data stored in RA_ADDRESSES,
RA_CUSTOMERS, RA_CONTACTS, RA_CUSTOMER_TRX, RA_TERMS, and
RA_TERMS_LINE in Oracle Receivables.
ECE_AR_TRX_HEADERS contains the customer, remit-to, ship-to, bill-to,
and sold-to information. In addition, it contains invoice header and payment
terms data.
All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in ECE_AR_TRX_HEADERS is purged after the data is written to
the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_AR_TRX_HEADERS table to its corresponding extension table
ECE_AR_TRX_HEADERS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_AR_TRX_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 COMMUNICATION_METHOD
TRANSACTION_ID
|
| ECE_AR_TRX_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_RECORD_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Communication Method | |
| TP_TEST_FLAG | VARCHAR2 | (1) | Trading Partner Test Flag | |
| TP_DOCUMENT_ID | VARCHAR2 | (6) | Yes | Trading Partner Document ID |
| DOCUMENT_TYPE | VARCHAR2 | (20) | Document Type | |
| TP_DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | Trading Partner Document Purpose Code | |
| TP_DOCUMENT_CODE | VARCHAR2 | (20) | Trading Partner Document Code | |
| TP_TRANSLATOR_CODE | VARCHAR2 | (30) | Trading Partner Translator Code | |
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Trading Partner Location Code | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Trading Partner Reference 1 | |
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Trading Partner Reference 2 | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| RUN_ID | NUMBER | (22) | Transaction Run ID | |
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Header Flexfield Context | |
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Flexfield 1 | |
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Flexfield 2 | |
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Flexfield 3 | |
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Flexfield 4 | |
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Flexfield 5 | |
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Flexfield 6 | |
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Flexfield 7 | |
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Flexfield 8 | |
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Flexfield 9 | |
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Flexfield 10 | |
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Flexfield 11 | |
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Flexfield 12 | |
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Flexfield 13 | |
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Flexfield 14 | |
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Flexfield 15 | |
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Detail Flexfield Context | |
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 1 | |
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 2 | |
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 3 | |
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 4 | |
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 5 | |
| BILL_TO_CUSTOMER_CODE_INT | VARCHAR2 | (240) | Bill To Code (Internal) | |
| BILL_TO_CUSTOMER_CODE_EXT | VARCHAR2 | (35) | Bill To Code (Ext) | |
| BILL_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Bill To Customer Name | |
| BILL_TO_ADDRESS1 | VARCHAR2 | (240) | Bill To Address 1 | |
| BILL_TO_ADDRESS2 | VARCHAR2 | (240) | Bill To Address 2 | |
| BILL_TO_ADDRESS3 | VARCHAR2 | (240) | Bill To Address 3 | |
| BILL_TO_ADDRESS4 | VARCHAR2 | (240) | Bill To Address 4 | |
| BILL_TO_CITY | VARCHAR2 | (60) | Bill To City | |
| BILL_TO_POSTAL_CODE | VARCHAR2 | (60) | Bill To Postal Code | |
| BILL_TO_COUNTRY | VARCHAR2 | (60) | Bill To Country (Internal) | |
| BILL_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Bill To Country (Ext) | |
| BILL_TO_STATE | VARCHAR2 | (60) | Bill To State (Internal) | |
| BILL_TO_STATE_EXT1 | VARCHAR2 | (80) | Bill To State (Ext) | |
| BILL_TO_PROVINCE | VARCHAR2 | (60) | Bill To Province (Internal) | |
| BILL_TO_PROVINCE_EXT1 | VARCHAR2 | (80) | Bill To Province (Ext) | |
| BILL_TO_COUNTY | VARCHAR2 | (60) | Bill To County | |
| BILL_TO_CUSTOMER_SIC_CODE | VARCHAR2 | (30) | Bill To Customer SIC Code | |
| BILL_TO_CUSTOMER_SALES_CHANNEL | VARCHAR2 | (30) | Bill To Customer Sales Channel | |
| BILL_TO_CONTACT_LAST_NAME | VARCHAR2 | (50) | Bill To Contact Last Name | |
| BILL_TO_CONTACT_FIRST_NAME | VARCHAR2 | (40) | Bill To Contact First Name | |
| BILL_TO_CONTACT_JOB_TITLE | VARCHAR2 | (50) | Bill To Contact Job Title | |
| BILL_TO_CUSTOMER_ATT_CATEGORY | VARCHAR2 | (30) | Bill To Customer Flexfield Context | |
| BILL_TO_CUSTOMER_ATTRIBUTE1 | VARCHAR2 | (150) | Bill To Customer Flexfield 1 | |
| BILL_TO_CUSTOMER_ATTRIBUTE2 | VARCHAR2 | (150) | Bill To Customer Flexfield 2 | |
| BILL_TO_CUSTOMER_ATTRIBUTE3 | VARCHAR2 | (150) | Bill To Customer Flexfield 3 | |
| BILL_TO_CUSTOMER_ATTRIBUTE4 | VARCHAR2 | (150) | Bill To Customer Flexfield 4 | |
| BILL_TO_CUSTOMER_ATTRIBUTE5 | VARCHAR2 | (150) | Bill To Customer Flexfield 5 | |
| BILL_TO_CUSTOMER_ATTRIBUTE6 | VARCHAR2 | (150) | Bill To Customer Flexfield 6 | |
| BILL_TO_CUSTOMER_ATTRIBUTE7 | VARCHAR2 | (150) | Bill To Customer Flexfield 7 | |
| BILL_TO_CUSTOMER_ATTRIBUTE8 | VARCHAR2 | (150) | Bill To Customer Flexfield 8 | |
| BILL_TO_CUSTOMER_ATTRIBUTE9 | VARCHAR2 | (150) | Bill To Customer Flexfield 9 | |
| BILL_TO_CUSTOMER_ATTRIBUTE10 | VARCHAR2 | (150) | Bill To Customer Flexfield 10 | |
| BILL_TO_CUSTOMER_ATTRIBUTE11 | VARCHAR2 | (150) | Bill To Customer Flexfield 11 | |
| BILL_TO_CUSTOMER_ATTRIBUTE12 | VARCHAR2 | (150) | Bill To Customer Flexfield 12 | |
| BILL_TO_CUSTOMER_ATTRIBUTE13 | VARCHAR2 | (150) | Bill To Customer Flexfield 13 | |
| BILL_TO_CUSTOMER_ATTRIBUTE14 | VARCHAR2 | (150) | Bill To Customer Flexfield 14 | |
| BILL_TO_CUSTOMER_ATTRIBUTE15 | VARCHAR2 | (150) | Bill To Customer Flexfield 15 | |
| BILL_TO_SITE_ATT_CATEGORY | VARCHAR2 | (30) | Bill To Site Flexfield Context | |
| BILL_TO_SITE_ATTRIBUTE1 | VARCHAR2 | (150) | Bill To Site Flexfield 1 | |
| BILL_TO_SITE_ATTRIBUTE2 | VARCHAR2 | (150) | Bill To Site Flexfield 2 | |
| BILL_TO_SITE_ATTRIBUTE3 | VARCHAR2 | (150) | Bill To Site Flexfield 3 | |
| BILL_TO_SITE_ATTRIBUTE4 | VARCHAR2 | (150) | Bill To Site Flexfield 4 | |
| BILL_TO_SITE_ATTRIBUTE5 | VARCHAR2 | (150) | Bill To Site Flexfield 5 | |
| BILL_TO_SITE_ATTRIBUTE6 | VARCHAR2 | (150) | Bill To Site Flexfield 6 | |
| BILL_TO_SITE_ATTRIBUTE7 | VARCHAR2 | (150) | Bill To Site Flexfield 7 | |
| BILL_TO_SITE_ATTRIBUTE8 | VARCHAR2 | (150) | Bill To Site Flexfield 8 | |
| BILL_TO_SITE_ATTRIBUTE9 | VARCHAR2 | (150) | Bill To Site Flexfield 9 | |
| BILL_TO_SITE_ATTRIBUTE10 | VARCHAR2 | (150) | Bill To Site Flexfield 10 | |
| BILL_TO_SITE_ATTRIBUTE11 | VARCHAR2 | (150) | Bill To Site Flexfield 11 | |
| BILL_TO_SITE_ATTRIBUTE12 | VARCHAR2 | (150) | Bill To Site Flexfield 12 | |
| BILL_TO_SITE_ATTRIBUTE13 | VARCHAR2 | (150) | Bill To Site Flexfield 13 | |
| BILL_TO_SITE_ATTRIBUTE14 | VARCHAR2 | (150) | Bill To Site Flexfield 14 | |
| BILL_TO_SITE_ATTRIBUTE15 | VARCHAR2 | (150) | Bill To Site Flexfield 15 | |
| SHIP_TO_CUSTOMER_CODE_INT | VARCHAR2 | (240) | Ship To Code (Internal) | |
| SHIP_TO_CUSTOMER_CODE_EXT | VARCHAR2 | (80) | Ship To Code (External) | |
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Ship To Customer Name | |
| SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Ship To Address 1 | |
| SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Ship To Address 2 | |
| SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Ship To Address 3 | |
| SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Ship To Address 4 | |
| SHIP_TO_CITY | VARCHAR2 | (60) | Ship To City | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship To Postal Code | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship To Country (Internal) | |
| SHIP_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Ship To Country (Ext) | |
| SHIP_TO_STATE | VARCHAR2 | (60) | Ship To State (Internal) | |
| SHIP_TO_STATE_EXT1 | VARCHAR2 | (80) | Ship To State (Ext) | |
| SHIP_TO_PROVINCE | VARCHAR2 | (60) | Ship To Province (Internal) | |
| SHIP_TO_PROVINCE_EXT1 | VARCHAR2 | (80) | Ship To Province (Ext) | |
| SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship To County | |
| SHIP_TO_CUSTOMER_SIC_CODE | VARCHAR2 | (30) | Ship To Customer SIC Code | |
| SHIP_TO_CUSTOMER_SALES_CHANNEL | VARCHAR2 | (30) | Ship To Customer Sales Channel | |
| SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (50) | Ship To Contact Last Name | |
| SHIP_TO_CONTACT_FIRST_NAME | VARCHAR2 | (40) | Ship To Contact First Name | |
| SHIP_TO_CONTACT_JOB_TITLE | VARCHAR2 | (50) | Ship To Contact Job Title | |
| SOLD_TO_CUSTOMER_CODE_INT | VARCHAR2 | (240) | Sold To Code (Internal) | |
| SOLD_TO_CUSTOMER_CODE_EXT | VARCHAR2 | (35) | Sold To Code (Ext) | |
| SOLD_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Sold To Customer Name | |
| SOLD_TO_ADDRESS1 | VARCHAR2 | (240) | Sold To Address 1 | |
| SOLD_TO_ADDRESS2 | VARCHAR2 | (240) | Sold To Address 2 | |
| SOLD_TO_ADDRESS3 | VARCHAR2 | (240) | Sold To Address 3 | |
| SOLD_TO_ADDRESS4 | VARCHAR2 | (240) | Sold To Address 4 | |
| SOLD_TO_CITY | VARCHAR2 | (60) | Sold To City | |
| SOLD_TO_POSTAL_CODE | VARCHAR2 | (60) | Sold To Postal Code | |
| SOLD_TO_COUNTRY | VARCHAR2 | (60) | Sold To Country (Internal) | |
| SOLD_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Sold To Country (Ext) | |
| SOLD_TO_STATE | VARCHAR2 | (60) | Sold To State (Internal) | |
| SOLD_TO_STATE_EXT1 | VARCHAR2 | (80) | Sold To State (Ext) | |
| SOLD_TO_PROVINCE | VARCHAR2 | (60) | Sold To Province (Internal) | |
| SOLD_TO_PROVINCE_EXT1 | VARCHAR2 | (80) | Sold To Province (Ext) | |
| SOLD_TO_COUNTY | VARCHAR2 | (60) | Sold To County | |
| SOLD_TO_CUSTOMER_SIC_CODE | VARCHAR2 | (30) | Sold To Customer SIC Code | |
| SOLD_TO_CUSTOMER_SALES_CHANNEL | VARCHAR2 | (30) | Sold To Customer Sales Channel | |
| SOLD_TO_CONTACT_LAST_NAME | VARCHAR2 | (50) | Sold To Contact Last Name | |
| SOLD_TO_CONTACT_FIRST_NAME | VARCHAR2 | (40) | Sold To Contact First Name | |
| SOLD_TO_CONTACT_JOB_TITLE | VARCHAR2 | (50) | Sold To Contact Job Title | |
| REMIT_TO_CODE_INT | VARCHAR2 | (240) | Remit To Code (Internal) | |
| REMIT_TO_CODE_EXT | VARCHAR2 | (35) | Remit To Code (Ext) | |
| REMIT_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Remit To Customer Name | |
| REMIT_TO_ADDRESS1 | VARCHAR2 | (240) | Remit To Address 1 | |
| REMIT_TO_ADDRESS2 | VARCHAR2 | (240) | Remit To Address 2 | |
| REMIT_TO_ADDRESS3 | VARCHAR2 | (240) | Remit To Address 3 | |
| REMIT_TO_ADDRESS4 | VARCHAR2 | (240) | Remit To Address 4 | |
| REMIT_TO_CITY | VARCHAR2 | (60) | Remit To City | |
| REMIT_TO_POSTAL_CODE | VARCHAR2 | (60) | Remit To Postal Code | |
| REMIT_TO_COUNTRY | VARCHAR2 | (60) | Remit To Country (Internal) | |
| REMIT_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Remit To Country (Ext) | |
| REMIT_TO_STATE | VARCHAR2 | (60) | Remit To State (Internal) | |
| REMIT_TO_STATE_EXT1 | VARCHAR2 | (80) | Remit To State (Ext) | |
| REMIT_TO_PROVINCE | VARCHAR2 | (60) | Remit To Province (Internal) | |
| REMIT_TO_PROVINCE_EXT1 | VARCHAR2 | (80) | Remit To Province (Ext) | |
| REMIT_TO_COUNTY | VARCHAR2 | (60) | Remit To County | |
| TRANSACTION_NUMBER | VARCHAR2 | (20) | Transaction Number | |
| CREDITED_INVOICE_NUMBER | VARCHAR2 | (20) | Credited Invoice Number | |
| REFERENCE_INVOICE_NUMBER | VARCHAR2 | (20) | Reference Invoice Number | |
| PARENT_INVOICE_NUMBER | VARCHAR2 | (20) | Parent Invoice Number | |
| SHIPMENT_DATE | DATE | Shipment Date | ||
| PURCHASE_ORDER_NUMBER | VARCHAR2 | (50) | Purchase Order Number | |
| CREATION_DATE | DATE | Creation Date | ||
| PURCHASE_ORDER_REVISION_NUMBER | VARCHAR2 | (50) | Purchase Order Revision Number | |
| COMMITMENT_START_DATE | DATE | Commitment Start Date | ||
| PURCHASE_ORDER_DATE | DATE | Purchase Order Date | ||
| COMMITMENT_END_DATE | DATE | Commitment End Date | ||
| INV_TRANSACTION_DATE | DATE | Transaction Date | ||
| LAST_UPDATE_DATE | DATE | Last Update Date | ||
| DUE_DATE | DATE | Due Date | ||
| TOTAL_AMOUNT_DUE | NUMBER | Total Amount Due | ||
| AMOUNT_TAX_DUE | NUMBER | Amount Tax Due | ||
| AMOUNT_FREIGHT_DUE | NUMBER | Amount Freight Due | ||
| AMOUNT_LINE_ITEMS_DUE | NUMBER | Amount Line Items Due | ||
| AMOUNT_CHARGES_DUE | NUMBER | Amount Charges Due | ||
| CREDIT_MEMO_REASON | VARCHAR2 | (30) | Credit Memo Reason | |
| TRANSMISSION_LEAD_DAYS | NUMBER | Transmission Lead Days | ||
| TRANSACTION_SOURCE | VARCHAR2 | (50) | Transaction Source | |
| INSTALLMENT_NUMBER | NUMBER | Installment Number | ||
| MAXIMUM_INSTALLMENT_NUMBER | NUMBER | Maximum Installment Number | ||
| SHIPMENT_WAYBILL_NUMBER | VARCHAR2 | (50) | Shipment Waybill Number | |
| SHIP_VIA | VARCHAR2 | (30) | Ship Via (Internal) | |
| SHIP_VIA_EXT1 | VARCHAR2 | (80) | Ship Via 1 (Ext) | |
| SHIP_VIA_EXT2 | VARCHAR2 | (80) | Ship Via 2 (Ext) | |
| SHIP_VIA_EXT3 | VARCHAR2 | (80) | Ship Via 3 (Ext) | |
| SHIP_VIA_EXT4 | VARCHAR2 | (80) | Ship Via 4 (Ext) | |
| SHIP_VIA_EXT5 | VARCHAR2 | (80) | Ship Via 5 (Ext) | |
| SHIPMENT_FOB_POINT | VARCHAR2 | (30) | Shipment FOB (Internal) | |
| SHIPMENT_FOB_POINT_EXT1 | VARCHAR2 | (80) | Shipment FOB Point 1 (Ext) | |
| SHIPMENT_FOB_POINT_EXT2 | VARCHAR2 | (80) | Shipment FOB Point 2 (Ext) | |
| SHIPMENT_FOB_POINT_EXT3 | VARCHAR2 | (80) | Shipment FOB Point 3 (Ext) | |
| SHIPMENT_FOB_POINT_EXT4 | VARCHAR2 | (80) | Shipment FOB Point 4 (Ext) | |
| SHIPMENT_FOB_POINT_EXT5 | VARCHAR2 | (80) | Shipment FOB Point 5 (Ext) | |
| SHIP_FROM_CODE_INT | VARCHAR2 | (3) | Ship From Code (Internal) | |
| SHIP_FROM_CODE_EXT | VARCHAR2 | (80) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| CURRENCY_CODE_EXT1 | VARCHAR2 | (80) | Currency Code (Ext) | |
| CURRENCY_EXCHANGE_RATE | NUMBER | Currency Exchange Rate | ||
| BASE_CURRENCY_CODE | VARCHAR2 | (15) | Base Currency Code | |
| BASE_CURRENCY_CODE_EXT1 | VARCHAR2 | (80) | Base Currency Code (Ext) | |
| PAYMENT_TERM_NAME | VARCHAR2 | (40) | Payment Term Name (Internal) | |
| PAYMENT_TERM_NAME_EXT1 | VARCHAR2 | (80) | Payment Term Name 1 (Ext) | |
| PAYMENT_TERM_NAME_EXT2 | VARCHAR2 | (80) | Payment Term Name 2 (Ext) | |
| PAYMENT_TERM_NAME_EXT3 | VARCHAR2 | (80) | Payment Term Name 3 (Ext) | |
| PAYMENT_TERM_NAME_EXT4 | VARCHAR2 | (80) | Payment Term Name 4 (Ext) | |
| PAYMENT_TERM_NAME_EXT5 | VARCHAR2 | (80) | Payment Term Name 5 (Ext) | |
| TERM_DUE_PERCENT | NUMBER | Term Due Percent | ||
| TERM_DUE_DATE | DATE | Term Due Date | ||
| TERM_DUE_DAYS | NUMBER | Term Due Days | ||
| TERM_DUE_DAY_OF_MONTH | NUMBER | Term Due Day of Month | ||
| TERM_DUE_CUTOFF_DAY | NUMBER | Term Due Cutoff Day | ||
| TERM_DUE_MONTHS_FORWARD | NUMBER | Term Due Months Forward | ||
| DISCOUNT_PERCENT1 | NUMBER | Discount 1 Percent | ||
| DISCOUNT_DAYS1 | NUMBER | Discount 1 Days | ||
| DISCOUNT_DATE1 | DATE | Discount 1 Date | ||
| DISCOUNT_DAY_OF_MONTH1 | NUMBER | Discount 1 Day of Month | ||
| DISCOUNT_MONTHS_FORWARD1 | NUMBER | Discount 1 Months Forward | ||
| DISCOUNT_PERCENT2 | NUMBER | Discount 2 Percent | ||
| DISCOUNT_DAYS2 | NUMBER | Discount 2 Days | ||
| DISCOUNT_DATE2 | DATE | Discount 2 Date | ||
| DISCOUNT_DAY_OF_MONTH2 | NUMBER | Discount 2 Day of Month | ||
| DISCOUNT_MONTHS_FORWARD2 | NUMBER | Discount 2 Months Forward | ||
| DISCOUNT_PERCENT3 | NUMBER | Discount 3 Percent | ||
| DISCOUNT_DAYS3 | NUMBER | Discount 3 Days | ||
| DISCOUNT_DATE3 | DATE | Discount 3 Date | ||
| DISCOUNT_DAY_OF_MONTH3 | NUMBER | Discount 3 Day of Month | ||
| DISCOUNT_MONTHS_FORWARD3 | NUMBER | Discount 3 Months Forward | ||
| PRIMARY_SALESREP_NAME | VARCHAR2 | (240) | Primary Salesrep Name | |
| COMMENTS | VARCHAR2 | (240) | Comments | |
| BILL_TO_CUSTOMER_LOCATION | VARCHAR2 | (40) | Bill To Customer Location | |
| BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Bill To Customer Number | |
| SHIP_TO_CUSTOMER_LOCATION | VARCHAR2 | (40) | Ship To Location | |
| SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Ship To Customer Number | |
| SOLD_TO_CUSTOMER_LOCATION | VARCHAR2 | (40) | Sold To Location | |
| SOLD_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Sold To Customer Number | |
| TRANSACTION_ID | NUMBER | (15) | Yes | Transaction ID |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier that links the transaction base table to its asociated extension table. | ||
| BILL_TO_TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Bill To Trading Partner Reference 1 | |
| BILL_TO_TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Bill To Trading Partner Reference 2 | |
| SHIP_TO_TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Ship To Trading Partner Reference 1 | |
| SHIP_TO_TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Ship To Trading Partner Reference 2 | |
| SOLD_TO_TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Sold To Trading Partner Reference 1 | |
| SOLD_TO_TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Sold To Trading Partner Reference 2 | |
| REMIT_TO_TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Remit To Trading Partner Reference 1 | |
| REMIT_TO_TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Remit To Trading Partner Reference 2 | |
| INVOICE_NAME | VARCHAR2 | (20) | Invoice Name (Internal) | |
| INVOICE_NAME_EXT1 | VARCHAR2 | (80) | Invoice Name 1 (Ext) | |
| INVOICE_NAME_EXT2 | VARCHAR2 | (80) | Invoice Name 2 (Ext) | |
| INVOICE_NAME_EXT3 | VARCHAR2 | (80) | Invoice Name 3 (Ext) | |
| INVOICE_NAME_EXT4 | VARCHAR2 | (80) | Invoice Name 4 (Ext) | |
| INVOICE_NAME_EXT5 | VARCHAR2 | (80) | Invoice Name 5 (Ext) | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| DOCUMENT_STANDARD | VARCHAR2 | (30) | EDI Document Standard | |
| MAP_ID | NUMBER | Map ID | ||
| GROSS_WEIGHT | NUMBER | (25) | Gross Weight | |
| NET_WEIGHT | NUMBER | (25) | Net Weight | |
| VOLUME | NUMBER | (25) | Volume | |
| WEIGHT_UOM_CODE_INT | VARCHAR2 | (3) | Internal Uom Code for Weight | |
| WEIGHT_UOM_CODE_EXT1 | VARCHAR2 | (3) | External UOM code for Weights | |
| WEIGHT_UOM_CODE_EXT2 | VARCHAR2 | (3) | External UOM Code for Weights | |
| WEIGHT_UOM_CODE_EXT3 | VARCHAR2 | (3) | External UOM Code for Weights | |
| WEIGHT_UOM_CODE_EXT4 | VARCHAR2 | (3) | External UOM code for Weights | |
| WEIGHT_UOM_CODE_EXT5 | VARCHAR2 | (3) | External UOM Code for Weights | |
| VOLUME_UOM_CODE_INT | VARCHAR2 | (3) | Internal UOM code for Volume | |
| VOLUME_UOM_CODE_EXT1 | VARCHAR2 | (3) | External UOM code for Volume | |
| VOLUME_UOM_CODE_EXT2 | VARCHAR2 | (3) | External UOM code for Volume | |
| VOLUME_UOM_CODE_EXT3 | VARCHAR2 | (3) | External UOM Code for Volume | |
| VOLUME_UOM_CODE_EXT4 | VARCHAR2 | (3) | External UOM code for Volume | |
| VOLUME_UOM_CODE_EXT5 | VARCHAR2 | (3) | External UOM Code for Volume | |
| SHIPMENT_NUMBER | VARCHAR2 | (30) | Sales order Shipment Number | |
| BOOKING_NUMBER | VARCHAR2 | (30) | Delivery Booking Number | |
| BILL_OF_LADING_NUMBER | VARCHAR2 | (30) | Bill of Lading Number | |
| RECEIVABLES_CHARGES_REMAINING | NUMBER | (25) | Invoice related Receivables Charges Remaining | |
| SHIP_FROM_CODE_EXT1 | VARCHAR2 | (80) | Ship From Code (Ext) | |
| SHIP_FROM_CODE_EXT2 | VARCHAR2 | (80) | Ship From Code (Ext) | |
| SHIP_FROM_CODE_EXT3 | VARCHAR2 | (80) | Ship From Code (Ext) | |
| SHIP_FROM_CODE_EXT4 | VARCHAR2 | (80) | Ship From Code (Ext) | |
| SHIP_FROM_CODE_EXT5 | VARCHAR2 | (80) | Ship From Code (Ext) |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TP_TEST_FLAG
, TP_DOCUMENT_ID
, DOCUMENT_TYPE
, TP_DOCUMENT_PURPOSE_CODE
, TP_DOCUMENT_CODE
, TP_TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT
, TP_DESCRIPTION
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, TRANSACTION_DATE
, RUN_ID
, TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5
, BILL_TO_CUSTOMER_CODE_INT
, BILL_TO_CUSTOMER_CODE_EXT
, BILL_TO_CUSTOMER_NAME
, BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4
, BILL_TO_CITY
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY
, BILL_TO_COUNTRY_EXT1
, BILL_TO_STATE
, BILL_TO_STATE_EXT1
, BILL_TO_PROVINCE
, BILL_TO_PROVINCE_EXT1
, BILL_TO_COUNTY
, BILL_TO_CUSTOMER_SIC_CODE
, BILL_TO_CUSTOMER_SALES_CHANNEL
, BILL_TO_CONTACT_LAST_NAME
, BILL_TO_CONTACT_FIRST_NAME
, BILL_TO_CONTACT_JOB_TITLE
, BILL_TO_CUSTOMER_ATT_CATEGORY
, BILL_TO_CUSTOMER_ATTRIBUTE1
, BILL_TO_CUSTOMER_ATTRIBUTE2
, BILL_TO_CUSTOMER_ATTRIBUTE3
, BILL_TO_CUSTOMER_ATTRIBUTE4
, BILL_TO_CUSTOMER_ATTRIBUTE5
, BILL_TO_CUSTOMER_ATTRIBUTE6
, BILL_TO_CUSTOMER_ATTRIBUTE7
, BILL_TO_CUSTOMER_ATTRIBUTE8
, BILL_TO_CUSTOMER_ATTRIBUTE9
, BILL_TO_CUSTOMER_ATTRIBUTE10
, BILL_TO_CUSTOMER_ATTRIBUTE11
, BILL_TO_CUSTOMER_ATTRIBUTE12
, BILL_TO_CUSTOMER_ATTRIBUTE13
, BILL_TO_CUSTOMER_ATTRIBUTE14
, BILL_TO_CUSTOMER_ATTRIBUTE15
, BILL_TO_SITE_ATT_CATEGORY
, BILL_TO_SITE_ATTRIBUTE1
, BILL_TO_SITE_ATTRIBUTE2
, BILL_TO_SITE_ATTRIBUTE3
, BILL_TO_SITE_ATTRIBUTE4
, BILL_TO_SITE_ATTRIBUTE5
, BILL_TO_SITE_ATTRIBUTE6
, BILL_TO_SITE_ATTRIBUTE7
, BILL_TO_SITE_ATTRIBUTE8
, BILL_TO_SITE_ATTRIBUTE9
, BILL_TO_SITE_ATTRIBUTE10
, BILL_TO_SITE_ATTRIBUTE11
, BILL_TO_SITE_ATTRIBUTE12
, BILL_TO_SITE_ATTRIBUTE13
, BILL_TO_SITE_ATTRIBUTE14
, BILL_TO_SITE_ATTRIBUTE15
, SHIP_TO_CUSTOMER_CODE_INT
, SHIP_TO_CUSTOMER_CODE_EXT
, SHIP_TO_CUSTOMER_NAME
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, SHIP_TO_COUNTRY_EXT1
, SHIP_TO_STATE
, SHIP_TO_STATE_EXT1
, SHIP_TO_PROVINCE
, SHIP_TO_PROVINCE_EXT1
, SHIP_TO_COUNTY
, SHIP_TO_CUSTOMER_SIC_CODE
, SHIP_TO_CUSTOMER_SALES_CHANNEL
, SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_JOB_TITLE
, SOLD_TO_CUSTOMER_CODE_INT
, SOLD_TO_CUSTOMER_CODE_EXT
, SOLD_TO_CUSTOMER_NAME
, SOLD_TO_ADDRESS1
, SOLD_TO_ADDRESS2
, SOLD_TO_ADDRESS3
, SOLD_TO_ADDRESS4
, SOLD_TO_CITY
, SOLD_TO_POSTAL_CODE
, SOLD_TO_COUNTRY
, SOLD_TO_COUNTRY_EXT1
, SOLD_TO_STATE
, SOLD_TO_STATE_EXT1
, SOLD_TO_PROVINCE
, SOLD_TO_PROVINCE_EXT1
, SOLD_TO_COUNTY
, SOLD_TO_CUSTOMER_SIC_CODE
, SOLD_TO_CUSTOMER_SALES_CHANNEL
, SOLD_TO_CONTACT_LAST_NAME
, SOLD_TO_CONTACT_FIRST_NAME
, SOLD_TO_CONTACT_JOB_TITLE
, REMIT_TO_CODE_INT
, REMIT_TO_CODE_EXT
, REMIT_TO_CUSTOMER_NAME
, REMIT_TO_ADDRESS1
, REMIT_TO_ADDRESS2
, REMIT_TO_ADDRESS3
, REMIT_TO_ADDRESS4
, REMIT_TO_CITY
, REMIT_TO_POSTAL_CODE
, REMIT_TO_COUNTRY
, REMIT_TO_COUNTRY_EXT1
, REMIT_TO_STATE
, REMIT_TO_STATE_EXT1
, REMIT_TO_PROVINCE
, REMIT_TO_PROVINCE_EXT1
, REMIT_TO_COUNTY
, TRANSACTION_NUMBER
, CREDITED_INVOICE_NUMBER
, REFERENCE_INVOICE_NUMBER
, PARENT_INVOICE_NUMBER
, SHIPMENT_DATE
, PURCHASE_ORDER_NUMBER
, CREATION_DATE
, PURCHASE_ORDER_REVISION_NUMBER
, COMMITMENT_START_DATE
, PURCHASE_ORDER_DATE
, COMMITMENT_END_DATE
, INV_TRANSACTION_DATE
, LAST_UPDATE_DATE
, DUE_DATE
, TOTAL_AMOUNT_DUE
, AMOUNT_TAX_DUE
, AMOUNT_FREIGHT_DUE
, AMOUNT_LINE_ITEMS_DUE
, AMOUNT_CHARGES_DUE
, CREDIT_MEMO_REASON
, TRANSMISSION_LEAD_DAYS
, TRANSACTION_SOURCE
, INSTALLMENT_NUMBER
, MAXIMUM_INSTALLMENT_NUMBER
, SHIPMENT_WAYBILL_NUMBER
, SHIP_VIA
, SHIP_VIA_EXT1
, SHIP_VIA_EXT2
, SHIP_VIA_EXT3
, SHIP_VIA_EXT4
, SHIP_VIA_EXT5
, SHIPMENT_FOB_POINT
, SHIPMENT_FOB_POINT_EXT1
, SHIPMENT_FOB_POINT_EXT2
, SHIPMENT_FOB_POINT_EXT3
, SHIPMENT_FOB_POINT_EXT4
, SHIPMENT_FOB_POINT_EXT5
, SHIP_FROM_CODE_INT
, SHIP_FROM_CODE_EXT
, CURRENCY_CODE
, CURRENCY_CODE_EXT1
, CURRENCY_EXCHANGE_RATE
, BASE_CURRENCY_CODE
, BASE_CURRENCY_CODE_EXT1
, PAYMENT_TERM_NAME
, PAYMENT_TERM_NAME_EXT1
, PAYMENT_TERM_NAME_EXT2
, PAYMENT_TERM_NAME_EXT3
, PAYMENT_TERM_NAME_EXT4
, PAYMENT_TERM_NAME_EXT5
, TERM_DUE_PERCENT
, TERM_DUE_DATE
, TERM_DUE_DAYS
, TERM_DUE_DAY_OF_MONTH
, TERM_DUE_CUTOFF_DAY
, TERM_DUE_MONTHS_FORWARD
, DISCOUNT_PERCENT1
, DISCOUNT_DAYS1
, DISCOUNT_DATE1
, DISCOUNT_DAY_OF_MONTH1
, DISCOUNT_MONTHS_FORWARD1
, DISCOUNT_PERCENT2
, DISCOUNT_DAYS2
, DISCOUNT_DATE2
, DISCOUNT_DAY_OF_MONTH2
, DISCOUNT_MONTHS_FORWARD2
, DISCOUNT_PERCENT3
, DISCOUNT_DAYS3
, DISCOUNT_DATE3
, DISCOUNT_DAY_OF_MONTH3
, DISCOUNT_MONTHS_FORWARD3
, PRIMARY_SALESREP_NAME
, COMMENTS
, BILL_TO_CUSTOMER_LOCATION
, BILL_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_LOCATION
, SHIP_TO_CUSTOMER_NUMBER
, SOLD_TO_CUSTOMER_LOCATION
, SOLD_TO_CUSTOMER_NUMBER
, TRANSACTION_ID
, TRANSACTION_RECORD_ID
, BILL_TO_TP_REFERENCE_EXT1
, BILL_TO_TP_REFERENCE_EXT2
, SHIP_TO_TP_REFERENCE_EXT1
, SHIP_TO_TP_REFERENCE_EXT2
, SOLD_TO_TP_REFERENCE_EXT1
, SOLD_TO_TP_REFERENCE_EXT2
, REMIT_TO_TP_REFERENCE_EXT1
, REMIT_TO_TP_REFERENCE_EXT2
, INVOICE_NAME
, INVOICE_NAME_EXT1
, INVOICE_NAME_EXT2
, INVOICE_NAME_EXT3
, INVOICE_NAME_EXT4
, INVOICE_NAME_EXT5
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DOCUMENT_STANDARD
, MAP_ID
, GROSS_WEIGHT
, NET_WEIGHT
, VOLUME
, WEIGHT_UOM_CODE_INT
, WEIGHT_UOM_CODE_EXT1
, WEIGHT_UOM_CODE_EXT2
, WEIGHT_UOM_CODE_EXT3
, WEIGHT_UOM_CODE_EXT4
, WEIGHT_UOM_CODE_EXT5
, VOLUME_UOM_CODE_INT
, VOLUME_UOM_CODE_EXT1
, VOLUME_UOM_CODE_EXT2
, VOLUME_UOM_CODE_EXT3
, VOLUME_UOM_CODE_EXT4
, VOLUME_UOM_CODE_EXT5
, SHIPMENT_NUMBER
, BOOKING_NUMBER
, BILL_OF_LADING_NUMBER
, RECEIVABLES_CHARGES_REMAINING
, SHIP_FROM_CODE_EXT1
, SHIP_FROM_CODE_EXT2
, SHIP_FROM_CODE_EXT3
, SHIP_FROM_CODE_EXT4
, SHIP_FROM_CODE_EXT5
FROM EC.ECE_AR_TRX_HEADERS;
EC.ECE_AR_TRX_HEADERS does not reference any database object
EC.ECE_AR_TRX_HEADERS is referenced by following:
EC
ECE_AR_TRX_HEADERS#
|
|
|
|