eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: EC.ECE_AR_TRX_HEADERS#

Source

View Text - Preformatted


select COMMUNICATION_METHOD COMMUNICATION_METHOD, TP_TEST_FLAG TP_TEST_FLAG, TP_DOCUMENT_ID TP_DOCUMENT_ID, DOCUMENT_TYPE DOCUMENT_TYPE, TP_DOCUMENT_PURPOSE_CODE TP_DOCUMENT_PURPOSE_CODE, TP_DOCUMENT_CODE TP_DOCUMENT_CODE, TP_TRANSLATOR_CODE TP_TRANSLATOR_CODE, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT, TP_DESCRIPTION TP_DESCRIPTION, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2, TRANSACTION_DATE TRANSACTION_DATE, RUN_ID RUN_ID, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5, BILL_TO_CUSTOMER_CODE_INT BILL_TO_CUSTOMER_CODE_INT, BILL_TO_CUSTOMER_CODE_EXT BILL_TO_CUSTOMER_CODE_EXT, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4, BILL_TO_CITY BILL_TO_CITY, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE, BILL_TO_COUNTRY BILL_TO_COUNTRY, BILL_TO_COUNTRY_EXT1 BILL_TO_COUNTRY_EXT1, BILL_TO_STATE BILL_TO_STATE, BILL_TO_STATE_EXT1 BILL_TO_STATE_EXT1, BILL_TO_PROVINCE BILL_TO_PROVINCE, BILL_TO_PROVINCE_EXT1 BILL_TO_PROVINCE_EXT1, BILL_TO_COUNTY BILL_TO_COUNTY, BILL_TO_CUSTOMER_SIC_CODE BILL_TO_CUSTOMER_SIC_CODE, BILL_TO_CUSTOMER_SALES_CHANNEL BILL_TO_CUSTOMER_SALES_CHANNEL, BILL_TO_CONTACT_LAST_NAME BILL_TO_CONTACT_LAST_NAME, BILL_TO_CONTACT_FIRST_NAME BILL_TO_CONTACT_FIRST_NAME, BILL_TO_CONTACT_JOB_TITLE BILL_TO_CONTACT_JOB_TITLE, BILL_TO_CUSTOMER_ATT_CATEGORY BILL_TO_CUSTOMER_ATT_CATEGORY, BILL_TO_CUSTOMER_ATTRIBUTE1 BILL_TO_CUSTOMER_ATTRIBUTE1, BILL_TO_CUSTOMER_ATTRIBUTE2 BILL_TO_CUSTOMER_ATTRIBUTE2, BILL_TO_CUSTOMER_ATTRIBUTE3 BILL_TO_CUSTOMER_ATTRIBUTE3, BILL_TO_CUSTOMER_ATTRIBUTE4 BILL_TO_CUSTOMER_ATTRIBUTE4, BILL_TO_CUSTOMER_ATTRIBUTE5 BILL_TO_CUSTOMER_ATTRIBUTE5, BILL_TO_CUSTOMER_ATTRIBUTE6 BILL_TO_CUSTOMER_ATTRIBUTE6, BILL_TO_CUSTOMER_ATTRIBUTE7 BILL_TO_CUSTOMER_ATTRIBUTE7, BILL_TO_CUSTOMER_ATTRIBUTE8 BILL_TO_CUSTOMER_ATTRIBUTE8, BILL_TO_CUSTOMER_ATTRIBUTE9 BILL_TO_CUSTOMER_ATTRIBUTE9, BILL_TO_CUSTOMER_ATTRIBUTE10 BILL_TO_CUSTOMER_ATTRIBUTE10, BILL_TO_CUSTOMER_ATTRIBUTE11 BILL_TO_CUSTOMER_ATTRIBUTE11, BILL_TO_CUSTOMER_ATTRIBUTE12 BILL_TO_CUSTOMER_ATTRIBUTE12, BILL_TO_CUSTOMER_ATTRIBUTE13 BILL_TO_CUSTOMER_ATTRIBUTE13, BILL_TO_CUSTOMER_ATTRIBUTE14 BILL_TO_CUSTOMER_ATTRIBUTE14, BILL_TO_CUSTOMER_ATTRIBUTE15 BILL_TO_CUSTOMER_ATTRIBUTE15, BILL_TO_SITE_ATT_CATEGORY BILL_TO_SITE_ATT_CATEGORY, BILL_TO_SITE_ATTRIBUTE1 BILL_TO_SITE_ATTRIBUTE1, BILL_TO_SITE_ATTRIBUTE2 BILL_TO_SITE_ATTRIBUTE2, BILL_TO_SITE_ATTRIBUTE3 BILL_TO_SITE_ATTRIBUTE3, BILL_TO_SITE_ATTRIBUTE4 BILL_TO_SITE_ATTRIBUTE4, BILL_TO_SITE_ATTRIBUTE5 BILL_TO_SITE_ATTRIBUTE5, BILL_TO_SITE_ATTRIBUTE6 BILL_TO_SITE_ATTRIBUTE6, BILL_TO_SITE_ATTRIBUTE7 BILL_TO_SITE_ATTRIBUTE7, BILL_TO_SITE_ATTRIBUTE8 BILL_TO_SITE_ATTRIBUTE8, BILL_TO_SITE_ATTRIBUTE9 BILL_TO_SITE_ATTRIBUTE9, BILL_TO_SITE_ATTRIBUTE10 BILL_TO_SITE_ATTRIBUTE10, BILL_TO_SITE_ATTRIBUTE11 BILL_TO_SITE_ATTRIBUTE11, BILL_TO_SITE_ATTRIBUTE12 BILL_TO_SITE_ATTRIBUTE12, BILL_TO_SITE_ATTRIBUTE13 BILL_TO_SITE_ATTRIBUTE13, BILL_TO_SITE_ATTRIBUTE14 BILL_TO_SITE_ATTRIBUTE14, BILL_TO_SITE_ATTRIBUTE15 BILL_TO_SITE_ATTRIBUTE15, SHIP_TO_CUSTOMER_CODE_INT SHIP_TO_CUSTOMER_CODE_INT, SHIP_TO_CUSTOMER_CODE_EXT SHIP_TO_CUSTOMER_CODE_EXT, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_COUNTRY_EXT1 SHIP_TO_COUNTRY_EXT1, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TO_STATE_EXT1 SHIP_TO_STATE_EXT1, SHIP_TO_PROVINCE SHIP_TO_PROVINCE, SHIP_TO_PROVINCE_EXT1 SHIP_TO_PROVINCE_EXT1, SHIP_TO_COUNTY SHIP_TO_COUNTY, SHIP_TO_CUSTOMER_SIC_CODE SHIP_TO_CUSTOMER_SIC_CODE, SHIP_TO_CUSTOMER_SALES_CHANNEL SHIP_TO_CUSTOMER_SALES_CHANNEL, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE, SOLD_TO_CUSTOMER_CODE_INT SOLD_TO_CUSTOMER_CODE_INT, SOLD_TO_CUSTOMER_CODE_EXT SOLD_TO_CUSTOMER_CODE_EXT, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4, SOLD_TO_CITY SOLD_TO_CITY, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE, SOLD_TO_COUNTRY SOLD_TO_COUNTRY, SOLD_TO_COUNTRY_EXT1 SOLD_TO_COUNTRY_EXT1, SOLD_TO_STATE SOLD_TO_STATE, SOLD_TO_STATE_EXT1 SOLD_TO_STATE_EXT1, SOLD_TO_PROVINCE SOLD_TO_PROVINCE, SOLD_TO_PROVINCE_EXT1 SOLD_TO_PROVINCE_EXT1, SOLD_TO_COUNTY SOLD_TO_COUNTY, SOLD_TO_CUSTOMER_SIC_CODE SOLD_TO_CUSTOMER_SIC_CODE, SOLD_TO_CUSTOMER_SALES_CHANNEL SOLD_TO_CUSTOMER_SALES_CHANNEL, SOLD_TO_CONTACT_LAST_NAME SOLD_TO_CONTACT_LAST_NAME, SOLD_TO_CONTACT_FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME, SOLD_TO_CONTACT_JOB_TITLE SOLD_TO_CONTACT_JOB_TITLE, REMIT_TO_CODE_INT REMIT_TO_CODE_INT, REMIT_TO_CODE_EXT REMIT_TO_CODE_EXT, REMIT_TO_CUSTOMER_NAME REMIT_TO_CUSTOMER_NAME, REMIT_TO_ADDRESS1 REMIT_TO_ADDRESS1, REMIT_TO_ADDRESS2 REMIT_TO_ADDRESS2, REMIT_TO_ADDRESS3 REMIT_TO_ADDRESS3, REMIT_TO_ADDRESS4 REMIT_TO_ADDRESS4, REMIT_TO_CITY REMIT_TO_CITY, REMIT_TO_POSTAL_CODE REMIT_TO_POSTAL_CODE, REMIT_TO_COUNTRY REMIT_TO_COUNTRY, REMIT_TO_COUNTRY_EXT1 REMIT_TO_COUNTRY_EXT1, REMIT_TO_STATE REMIT_TO_STATE, REMIT_TO_STATE_EXT1 REMIT_TO_STATE_EXT1, REMIT_TO_PROVINCE REMIT_TO_PROVINCE, REMIT_TO_PROVINCE_EXT1 REMIT_TO_PROVINCE_EXT1, REMIT_TO_COUNTY REMIT_TO_COUNTY, TRANSACTION_NUMBER TRANSACTION_NUMBER, CREDITED_INVOICE_NUMBER CREDITED_INVOICE_NUMBER, REFERENCE_INVOICE_NUMBER REFERENCE_INVOICE_NUMBER, PARENT_INVOICE_NUMBER PARENT_INVOICE_NUMBER, SHIPMENT_DATE SHIPMENT_DATE, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER, CREATION_DATE CREATION_DATE, PURCHASE_ORDER_REVISION_NUMBER PURCHASE_ORDER_REVISION_NUMBER, COMMITMENT_START_DATE COMMITMENT_START_DATE, PURCHASE_ORDER_DATE PURCHASE_ORDER_DATE, COMMITMENT_END_DATE COMMITMENT_END_DATE, INV_TRANSACTION_DATE INV_TRANSACTION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DUE_DATE DUE_DATE, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE, AMOUNT_TAX_DUE AMOUNT_TAX_DUE, AMOUNT_FREIGHT_DUE AMOUNT_FREIGHT_DUE, AMOUNT_LINE_ITEMS_DUE AMOUNT_LINE_ITEMS_DUE, AMOUNT_CHARGES_DUE AMOUNT_CHARGES_DUE, CREDIT_MEMO_REASON CREDIT_MEMO_REASON, TRANSMISSION_LEAD_DAYS TRANSMISSION_LEAD_DAYS, TRANSACTION_SOURCE TRANSACTION_SOURCE, INSTALLMENT_NUMBER INSTALLMENT_NUMBER, MAXIMUM_INSTALLMENT_NUMBER MAXIMUM_INSTALLMENT_NUMBER, SHIPMENT_WAYBILL_NUMBER SHIPMENT_WAYBILL_NUMBER, SHIP_VIA SHIP_VIA, SHIP_VIA_EXT1 SHIP_VIA_EXT1, SHIP_VIA_EXT2 SHIP_VIA_EXT2, SHIP_VIA_EXT3 SHIP_VIA_EXT3, SHIP_VIA_EXT4 SHIP_VIA_EXT4, SHIP_VIA_EXT5 SHIP_VIA_EXT5, SHIPMENT_FOB_POINT SHIPMENT_FOB_POINT, SHIPMENT_FOB_POINT_EXT1 SHIPMENT_FOB_POINT_EXT1, SHIPMENT_FOB_POINT_EXT2 SHIPMENT_FOB_POINT_EXT2, SHIPMENT_FOB_POINT_EXT3 SHIPMENT_FOB_POINT_EXT3, SHIPMENT_FOB_POINT_EXT4 SHIPMENT_FOB_POINT_EXT4, SHIPMENT_FOB_POINT_EXT5 SHIPMENT_FOB_POINT_EXT5, SHIP_FROM_CODE_INT SHIP_FROM_CODE_INT, SHIP_FROM_CODE_EXT SHIP_FROM_CODE_EXT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE, BASE_CURRENCY_CODE BASE_CURRENCY_CODE, BASE_CURRENCY_CODE_EXT1 BASE_CURRENCY_CODE_EXT1, PAYMENT_TERM_NAME PAYMENT_TERM_NAME, PAYMENT_TERM_NAME_EXT1 PAYMENT_TERM_NAME_EXT1, PAYMENT_TERM_NAME_EXT2 PAYMENT_TERM_NAME_EXT2, PAYMENT_TERM_NAME_EXT3 PAYMENT_TERM_NAME_EXT3, PAYMENT_TERM_NAME_EXT4 PAYMENT_TERM_NAME_EXT4, PAYMENT_TERM_NAME_EXT5 PAYMENT_TERM_NAME_EXT5, TERM_DUE_PERCENT TERM_DUE_PERCENT, TERM_DUE_DATE TERM_DUE_DATE, TERM_DUE_DAYS TERM_DUE_DAYS, TERM_DUE_DAY_OF_MONTH TERM_DUE_DAY_OF_MONTH, TERM_DUE_CUTOFF_DAY TERM_DUE_CUTOFF_DAY, TERM_DUE_MONTHS_FORWARD TERM_DUE_MONTHS_FORWARD, DISCOUNT_PERCENT1 DISCOUNT_PERCENT1, DISCOUNT_DAYS1 DISCOUNT_DAYS1, DISCOUNT_DATE1 DISCOUNT_DATE1, DISCOUNT_DAY_OF_MONTH1 DISCOUNT_DAY_OF_MONTH1, DISCOUNT_MONTHS_FORWARD1 DISCOUNT_MONTHS_FORWARD1, DISCOUNT_PERCENT2 DISCOUNT_PERCENT2, DISCOUNT_DAYS2 DISCOUNT_DAYS2, DISCOUNT_DATE2 DISCOUNT_DATE2, DISCOUNT_DAY_OF_MONTH2 DISCOUNT_DAY_OF_MONTH2, DISCOUNT_MONTHS_FORWARD2 DISCOUNT_MONTHS_FORWARD2, DISCOUNT_PERCENT3 DISCOUNT_PERCENT3, DISCOUNT_DAYS3 DISCOUNT_DAYS3, DISCOUNT_DATE3 DISCOUNT_DATE3, DISCOUNT_DAY_OF_MONTH3 DISCOUNT_DAY_OF_MONTH3, DISCOUNT_MONTHS_FORWARD3 DISCOUNT_MONTHS_FORWARD3, PRIMARY_SALESREP_NAME PRIMARY_SALESREP_NAME, COMMENTS COMMENTS, BILL_TO_CUSTOMER_LOCATION BILL_TO_CUSTOMER_LOCATION, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER, SHIP_TO_CUSTOMER_LOCATION SHIP_TO_CUSTOMER_LOCATION, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER, SOLD_TO_CUSTOMER_LOCATION SOLD_TO_CUSTOMER_LOCATION, SOLD_TO_CUSTOMER_NUMBER SOLD_TO_CUSTOMER_NUMBER, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, BILL_TO_TP_REFERENCE_EXT1 BILL_TO_TP_REFERENCE_EXT1, BILL_TO_TP_REFERENCE_EXT2 BILL_TO_TP_REFERENCE_EXT2, SHIP_TO_TP_REFERENCE_EXT1 SHIP_TO_TP_REFERENCE_EXT1, SHIP_TO_TP_REFERENCE_EXT2 SHIP_TO_TP_REFERENCE_EXT2, SOLD_TO_TP_REFERENCE_EXT1 SOLD_TO_TP_REFERENCE_EXT1, SOLD_TO_TP_REFERENCE_EXT2 SOLD_TO_TP_REFERENCE_EXT2, REMIT_TO_TP_REFERENCE_EXT1 REMIT_TO_TP_REFERENCE_EXT1, REMIT_TO_TP_REFERENCE_EXT2 REMIT_TO_TP_REFERENCE_EXT2, INVOICE_NAME INVOICE_NAME, INVOICE_NAME_EXT1 INVOICE_NAME_EXT1, INVOICE_NAME_EXT2 INVOICE_NAME_EXT2, INVOICE_NAME_EXT3 INVOICE_NAME_EXT3, INVOICE_NAME_EXT4 INVOICE_NAME_EXT4, INVOICE_NAME_EXT5 INVOICE_NAME_EXT5, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DOCUMENT_STANDARD DOCUMENT_STANDARD, MAP_ID MAP_ID, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, VOLUME VOLUME, WEIGHT_UOM_CODE_INT WEIGHT_UOM_CODE_INT, WEIGHT_UOM_CODE_EXT1 WEIGHT_UOM_CODE_EXT1, WEIGHT_UOM_CODE_EXT2 WEIGHT_UOM_CODE_EXT2, WEIGHT_UOM_CODE_EXT3 WEIGHT_UOM_CODE_EXT3, WEIGHT_UOM_CODE_EXT4 WEIGHT_UOM_CODE_EXT4, WEIGHT_UOM_CODE_EXT5 WEIGHT_UOM_CODE_EXT5, VOLUME_UOM_CODE_INT VOLUME_UOM_CODE_INT, VOLUME_UOM_CODE_EXT1 VOLUME_UOM_CODE_EXT1, VOLUME_UOM_CODE_EXT2 VOLUME_UOM_CODE_EXT2, VOLUME_UOM_CODE_EXT3 VOLUME_UOM_CODE_EXT3, VOLUME_UOM_CODE_EXT4 VOLUME_UOM_CODE_EXT4, VOLUME_UOM_CODE_EXT5 VOLUME_UOM_CODE_EXT5, SHIPMENT_NUMBER SHIPMENT_NUMBER, BOOKING_NUMBER BOOKING_NUMBER, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER, RECEIVABLES_CHARGES_REMAINING RECEIVABLES_CHARGES_REMAINING, SHIP_FROM_CODE_EXT1 SHIP_FROM_CODE_EXT1, SHIP_FROM_CODE_EXT2 SHIP_FROM_CODE_EXT2, SHIP_FROM_CODE_EXT3 SHIP_FROM_CODE_EXT3, SHIP_FROM_CODE_EXT4 SHIP_FROM_CODE_EXT4, SHIP_FROM_CODE_EXT5 SHIP_FROM_CODE_EXT5 from "EC"."ECE_AR_TRX_HEADERS"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, TP_TEST_FLAG TP_TEST_FLAG
, TP_DOCUMENT_ID TP_DOCUMENT_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, TP_DOCUMENT_PURPOSE_CODE TP_DOCUMENT_PURPOSE_CODE
, TP_DOCUMENT_CODE TP_DOCUMENT_CODE
, TP_TRANSLATOR_CODE TP_TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, TP_DESCRIPTION TP_DESCRIPTION
, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, TRANSACTION_DATE TRANSACTION_DATE
, RUN_ID RUN_ID
, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5
, BILL_TO_CUSTOMER_CODE_INT BILL_TO_CUSTOMER_CODE_INT
, BILL_TO_CUSTOMER_CODE_EXT BILL_TO_CUSTOMER_CODE_EXT
, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4
, BILL_TO_CITY BILL_TO_CITY
, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY BILL_TO_COUNTRY
, BILL_TO_COUNTRY_EXT1 BILL_TO_COUNTRY_EXT1
, BILL_TO_STATE BILL_TO_STATE
, BILL_TO_STATE_EXT1 BILL_TO_STATE_EXT1
, BILL_TO_PROVINCE BILL_TO_PROVINCE
, BILL_TO_PROVINCE_EXT1 BILL_TO_PROVINCE_EXT1
, BILL_TO_COUNTY BILL_TO_COUNTY
, BILL_TO_CUSTOMER_SIC_CODE BILL_TO_CUSTOMER_SIC_CODE
, BILL_TO_CUSTOMER_SALES_CHANNEL BILL_TO_CUSTOMER_SALES_CHANNEL
, BILL_TO_CONTACT_LAST_NAME BILL_TO_CONTACT_LAST_NAME
, BILL_TO_CONTACT_FIRST_NAME BILL_TO_CONTACT_FIRST_NAME
, BILL_TO_CONTACT_JOB_TITLE BILL_TO_CONTACT_JOB_TITLE
, BILL_TO_CUSTOMER_ATT_CATEGORY BILL_TO_CUSTOMER_ATT_CATEGORY
, BILL_TO_CUSTOMER_ATTRIBUTE1 BILL_TO_CUSTOMER_ATTRIBUTE1
, BILL_TO_CUSTOMER_ATTRIBUTE2 BILL_TO_CUSTOMER_ATTRIBUTE2
, BILL_TO_CUSTOMER_ATTRIBUTE3 BILL_TO_CUSTOMER_ATTRIBUTE3
, BILL_TO_CUSTOMER_ATTRIBUTE4 BILL_TO_CUSTOMER_ATTRIBUTE4
, BILL_TO_CUSTOMER_ATTRIBUTE5 BILL_TO_CUSTOMER_ATTRIBUTE5
, BILL_TO_CUSTOMER_ATTRIBUTE6 BILL_TO_CUSTOMER_ATTRIBUTE6
, BILL_TO_CUSTOMER_ATTRIBUTE7 BILL_TO_CUSTOMER_ATTRIBUTE7
, BILL_TO_CUSTOMER_ATTRIBUTE8 BILL_TO_CUSTOMER_ATTRIBUTE8
, BILL_TO_CUSTOMER_ATTRIBUTE9 BILL_TO_CUSTOMER_ATTRIBUTE9
, BILL_TO_CUSTOMER_ATTRIBUTE10 BILL_TO_CUSTOMER_ATTRIBUTE10
, BILL_TO_CUSTOMER_ATTRIBUTE11 BILL_TO_CUSTOMER_ATTRIBUTE11
, BILL_TO_CUSTOMER_ATTRIBUTE12 BILL_TO_CUSTOMER_ATTRIBUTE12
, BILL_TO_CUSTOMER_ATTRIBUTE13 BILL_TO_CUSTOMER_ATTRIBUTE13
, BILL_TO_CUSTOMER_ATTRIBUTE14 BILL_TO_CUSTOMER_ATTRIBUTE14
, BILL_TO_CUSTOMER_ATTRIBUTE15 BILL_TO_CUSTOMER_ATTRIBUTE15
, BILL_TO_SITE_ATT_CATEGORY BILL_TO_SITE_ATT_CATEGORY
, BILL_TO_SITE_ATTRIBUTE1 BILL_TO_SITE_ATTRIBUTE1
, BILL_TO_SITE_ATTRIBUTE2 BILL_TO_SITE_ATTRIBUTE2
, BILL_TO_SITE_ATTRIBUTE3 BILL_TO_SITE_ATTRIBUTE3
, BILL_TO_SITE_ATTRIBUTE4 BILL_TO_SITE_ATTRIBUTE4
, BILL_TO_SITE_ATTRIBUTE5 BILL_TO_SITE_ATTRIBUTE5
, BILL_TO_SITE_ATTRIBUTE6 BILL_TO_SITE_ATTRIBUTE6
, BILL_TO_SITE_ATTRIBUTE7 BILL_TO_SITE_ATTRIBUTE7
, BILL_TO_SITE_ATTRIBUTE8 BILL_TO_SITE_ATTRIBUTE8
, BILL_TO_SITE_ATTRIBUTE9 BILL_TO_SITE_ATTRIBUTE9
, BILL_TO_SITE_ATTRIBUTE10 BILL_TO_SITE_ATTRIBUTE10
, BILL_TO_SITE_ATTRIBUTE11 BILL_TO_SITE_ATTRIBUTE11
, BILL_TO_SITE_ATTRIBUTE12 BILL_TO_SITE_ATTRIBUTE12
, BILL_TO_SITE_ATTRIBUTE13 BILL_TO_SITE_ATTRIBUTE13
, BILL_TO_SITE_ATTRIBUTE14 BILL_TO_SITE_ATTRIBUTE14
, BILL_TO_SITE_ATTRIBUTE15 BILL_TO_SITE_ATTRIBUTE15
, SHIP_TO_CUSTOMER_CODE_INT SHIP_TO_CUSTOMER_CODE_INT
, SHIP_TO_CUSTOMER_CODE_EXT SHIP_TO_CUSTOMER_CODE_EXT
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_COUNTRY_EXT1 SHIP_TO_COUNTRY_EXT1
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TO_STATE_EXT1 SHIP_TO_STATE_EXT1
, SHIP_TO_PROVINCE SHIP_TO_PROVINCE
, SHIP_TO_PROVINCE_EXT1 SHIP_TO_PROVINCE_EXT1
, SHIP_TO_COUNTY SHIP_TO_COUNTY
, SHIP_TO_CUSTOMER_SIC_CODE SHIP_TO_CUSTOMER_SIC_CODE
, SHIP_TO_CUSTOMER_SALES_CHANNEL SHIP_TO_CUSTOMER_SALES_CHANNEL
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE
, SOLD_TO_CUSTOMER_CODE_INT SOLD_TO_CUSTOMER_CODE_INT
, SOLD_TO_CUSTOMER_CODE_EXT SOLD_TO_CUSTOMER_CODE_EXT
, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME
, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1
, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2
, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3
, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4
, SOLD_TO_CITY SOLD_TO_CITY
, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE
, SOLD_TO_COUNTRY SOLD_TO_COUNTRY
, SOLD_TO_COUNTRY_EXT1 SOLD_TO_COUNTRY_EXT1
, SOLD_TO_STATE SOLD_TO_STATE
, SOLD_TO_STATE_EXT1 SOLD_TO_STATE_EXT1
, SOLD_TO_PROVINCE SOLD_TO_PROVINCE
, SOLD_TO_PROVINCE_EXT1 SOLD_TO_PROVINCE_EXT1
, SOLD_TO_COUNTY SOLD_TO_COUNTY
, SOLD_TO_CUSTOMER_SIC_CODE SOLD_TO_CUSTOMER_SIC_CODE
, SOLD_TO_CUSTOMER_SALES_CHANNEL SOLD_TO_CUSTOMER_SALES_CHANNEL
, SOLD_TO_CONTACT_LAST_NAME SOLD_TO_CONTACT_LAST_NAME
, SOLD_TO_CONTACT_FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME
, SOLD_TO_CONTACT_JOB_TITLE SOLD_TO_CONTACT_JOB_TITLE
, REMIT_TO_CODE_INT REMIT_TO_CODE_INT
, REMIT_TO_CODE_EXT REMIT_TO_CODE_EXT
, REMIT_TO_CUSTOMER_NAME REMIT_TO_CUSTOMER_NAME
, REMIT_TO_ADDRESS1 REMIT_TO_ADDRESS1
, REMIT_TO_ADDRESS2 REMIT_TO_ADDRESS2
, REMIT_TO_ADDRESS3 REMIT_TO_ADDRESS3
, REMIT_TO_ADDRESS4 REMIT_TO_ADDRESS4
, REMIT_TO_CITY REMIT_TO_CITY
, REMIT_TO_POSTAL_CODE REMIT_TO_POSTAL_CODE
, REMIT_TO_COUNTRY REMIT_TO_COUNTRY
, REMIT_TO_COUNTRY_EXT1 REMIT_TO_COUNTRY_EXT1
, REMIT_TO_STATE REMIT_TO_STATE
, REMIT_TO_STATE_EXT1 REMIT_TO_STATE_EXT1
, REMIT_TO_PROVINCE REMIT_TO_PROVINCE
, REMIT_TO_PROVINCE_EXT1 REMIT_TO_PROVINCE_EXT1
, REMIT_TO_COUNTY REMIT_TO_COUNTY
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, CREDITED_INVOICE_NUMBER CREDITED_INVOICE_NUMBER
, REFERENCE_INVOICE_NUMBER REFERENCE_INVOICE_NUMBER
, PARENT_INVOICE_NUMBER PARENT_INVOICE_NUMBER
, SHIPMENT_DATE SHIPMENT_DATE
, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER
, CREATION_DATE CREATION_DATE
, PURCHASE_ORDER_REVISION_NUMBER PURCHASE_ORDER_REVISION_NUMBER
, COMMITMENT_START_DATE COMMITMENT_START_DATE
, PURCHASE_ORDER_DATE PURCHASE_ORDER_DATE
, COMMITMENT_END_DATE COMMITMENT_END_DATE
, INV_TRANSACTION_DATE INV_TRANSACTION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DUE_DATE DUE_DATE
, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE
, AMOUNT_TAX_DUE AMOUNT_TAX_DUE
, AMOUNT_FREIGHT_DUE AMOUNT_FREIGHT_DUE
, AMOUNT_LINE_ITEMS_DUE AMOUNT_LINE_ITEMS_DUE
, AMOUNT_CHARGES_DUE AMOUNT_CHARGES_DUE
, CREDIT_MEMO_REASON CREDIT_MEMO_REASON
, TRANSMISSION_LEAD_DAYS TRANSMISSION_LEAD_DAYS
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, INSTALLMENT_NUMBER INSTALLMENT_NUMBER
, MAXIMUM_INSTALLMENT_NUMBER MAXIMUM_INSTALLMENT_NUMBER
, SHIPMENT_WAYBILL_NUMBER SHIPMENT_WAYBILL_NUMBER
, SHIP_VIA SHIP_VIA
, SHIP_VIA_EXT1 SHIP_VIA_EXT1
, SHIP_VIA_EXT2 SHIP_VIA_EXT2
, SHIP_VIA_EXT3 SHIP_VIA_EXT3
, SHIP_VIA_EXT4 SHIP_VIA_EXT4
, SHIP_VIA_EXT5 SHIP_VIA_EXT5
, SHIPMENT_FOB_POINT SHIPMENT_FOB_POINT
, SHIPMENT_FOB_POINT_EXT1 SHIPMENT_FOB_POINT_EXT1
, SHIPMENT_FOB_POINT_EXT2 SHIPMENT_FOB_POINT_EXT2
, SHIPMENT_FOB_POINT_EXT3 SHIPMENT_FOB_POINT_EXT3
, SHIPMENT_FOB_POINT_EXT4 SHIPMENT_FOB_POINT_EXT4
, SHIPMENT_FOB_POINT_EXT5 SHIPMENT_FOB_POINT_EXT5
, SHIP_FROM_CODE_INT SHIP_FROM_CODE_INT
, SHIP_FROM_CODE_EXT SHIP_FROM_CODE_EXT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1
, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE
, BASE_CURRENCY_CODE BASE_CURRENCY_CODE
, BASE_CURRENCY_CODE_EXT1 BASE_CURRENCY_CODE_EXT1
, PAYMENT_TERM_NAME PAYMENT_TERM_NAME
, PAYMENT_TERM_NAME_EXT1 PAYMENT_TERM_NAME_EXT1
, PAYMENT_TERM_NAME_EXT2 PAYMENT_TERM_NAME_EXT2
, PAYMENT_TERM_NAME_EXT3 PAYMENT_TERM_NAME_EXT3
, PAYMENT_TERM_NAME_EXT4 PAYMENT_TERM_NAME_EXT4
, PAYMENT_TERM_NAME_EXT5 PAYMENT_TERM_NAME_EXT5
, TERM_DUE_PERCENT TERM_DUE_PERCENT
, TERM_DUE_DATE TERM_DUE_DATE
, TERM_DUE_DAYS TERM_DUE_DAYS
, TERM_DUE_DAY_OF_MONTH TERM_DUE_DAY_OF_MONTH
, TERM_DUE_CUTOFF_DAY TERM_DUE_CUTOFF_DAY
, TERM_DUE_MONTHS_FORWARD TERM_DUE_MONTHS_FORWARD
, DISCOUNT_PERCENT1 DISCOUNT_PERCENT1
, DISCOUNT_DAYS1 DISCOUNT_DAYS1
, DISCOUNT_DATE1 DISCOUNT_DATE1
, DISCOUNT_DAY_OF_MONTH1 DISCOUNT_DAY_OF_MONTH1
, DISCOUNT_MONTHS_FORWARD1 DISCOUNT_MONTHS_FORWARD1
, DISCOUNT_PERCENT2 DISCOUNT_PERCENT2
, DISCOUNT_DAYS2 DISCOUNT_DAYS2
, DISCOUNT_DATE2 DISCOUNT_DATE2
, DISCOUNT_DAY_OF_MONTH2 DISCOUNT_DAY_OF_MONTH2
, DISCOUNT_MONTHS_FORWARD2 DISCOUNT_MONTHS_FORWARD2
, DISCOUNT_PERCENT3 DISCOUNT_PERCENT3
, DISCOUNT_DAYS3 DISCOUNT_DAYS3
, DISCOUNT_DATE3 DISCOUNT_DATE3
, DISCOUNT_DAY_OF_MONTH3 DISCOUNT_DAY_OF_MONTH3
, DISCOUNT_MONTHS_FORWARD3 DISCOUNT_MONTHS_FORWARD3
, PRIMARY_SALESREP_NAME PRIMARY_SALESREP_NAME
, COMMENTS COMMENTS
, BILL_TO_CUSTOMER_LOCATION BILL_TO_CUSTOMER_LOCATION
, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_LOCATION SHIP_TO_CUSTOMER_LOCATION
, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, SOLD_TO_CUSTOMER_LOCATION SOLD_TO_CUSTOMER_LOCATION
, SOLD_TO_CUSTOMER_NUMBER SOLD_TO_CUSTOMER_NUMBER
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, BILL_TO_TP_REFERENCE_EXT1 BILL_TO_TP_REFERENCE_EXT1
, BILL_TO_TP_REFERENCE_EXT2 BILL_TO_TP_REFERENCE_EXT2
, SHIP_TO_TP_REFERENCE_EXT1 SHIP_TO_TP_REFERENCE_EXT1
, SHIP_TO_TP_REFERENCE_EXT2 SHIP_TO_TP_REFERENCE_EXT2
, SOLD_TO_TP_REFERENCE_EXT1 SOLD_TO_TP_REFERENCE_EXT1
, SOLD_TO_TP_REFERENCE_EXT2 SOLD_TO_TP_REFERENCE_EXT2
, REMIT_TO_TP_REFERENCE_EXT1 REMIT_TO_TP_REFERENCE_EXT1
, REMIT_TO_TP_REFERENCE_EXT2 REMIT_TO_TP_REFERENCE_EXT2
, INVOICE_NAME INVOICE_NAME
, INVOICE_NAME_EXT1 INVOICE_NAME_EXT1
, INVOICE_NAME_EXT2 INVOICE_NAME_EXT2
, INVOICE_NAME_EXT3 INVOICE_NAME_EXT3
, INVOICE_NAME_EXT4 INVOICE_NAME_EXT4
, INVOICE_NAME_EXT5 INVOICE_NAME_EXT5
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DOCUMENT_STANDARD DOCUMENT_STANDARD
, MAP_ID MAP_ID
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, VOLUME VOLUME
, WEIGHT_UOM_CODE_INT WEIGHT_UOM_CODE_INT
, WEIGHT_UOM_CODE_EXT1 WEIGHT_UOM_CODE_EXT1
, WEIGHT_UOM_CODE_EXT2 WEIGHT_UOM_CODE_EXT2
, WEIGHT_UOM_CODE_EXT3 WEIGHT_UOM_CODE_EXT3
, WEIGHT_UOM_CODE_EXT4 WEIGHT_UOM_CODE_EXT4
, WEIGHT_UOM_CODE_EXT5 WEIGHT_UOM_CODE_EXT5
, VOLUME_UOM_CODE_INT VOLUME_UOM_CODE_INT
, VOLUME_UOM_CODE_EXT1 VOLUME_UOM_CODE_EXT1
, VOLUME_UOM_CODE_EXT2 VOLUME_UOM_CODE_EXT2
, VOLUME_UOM_CODE_EXT3 VOLUME_UOM_CODE_EXT3
, VOLUME_UOM_CODE_EXT4 VOLUME_UOM_CODE_EXT4
, VOLUME_UOM_CODE_EXT5 VOLUME_UOM_CODE_EXT5
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, BOOKING_NUMBER BOOKING_NUMBER
, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER
, RECEIVABLES_CHARGES_REMAINING RECEIVABLES_CHARGES_REMAINING
, SHIP_FROM_CODE_EXT1 SHIP_FROM_CODE_EXT1
, SHIP_FROM_CODE_EXT2 SHIP_FROM_CODE_EXT2
, SHIP_FROM_CODE_EXT3 SHIP_FROM_CODE_EXT3
, SHIP_FROM_CODE_EXT4 SHIP_FROM_CODE_EXT4
, SHIP_FROM_CODE_EXT5 SHIP_FROM_CODE_EXT5
FROM "EC"."ECE_AR_TRX_HEADERS"