| Data element |
Definition |
| ACCOUNT_COUNTRY
Indexed - no
Format - varchar2(5)
May be null? Yes
|
Denotes the IATA code associated with the account number. |
| ACCOUNT_CUST_REF_NUMBER
Indexed - no
Format – varchar2(25)
May be null? Yes
|
Denotes the customer reference number associated with the account the charge is billed to (for consolidated payment plans only).
|
| ACCOUNT_NUMBER
Indexed - no
Format – varchar2(15)
May be null? Yes
|
Denotes the shipper number associated with the charge.
Denotes the UPS Freight customer number the file is representative of.
|
| ACCOUNT_STORE_NUMBER
Indexed - no
Format – varchar2(10)
May be null? Yes
|
Denotes the store number associated with the account the charge is billed to (for consolidated payment plans only). |
| ACCOUNT_TAX_ID
Indexed - no
Format – varchar2(25)
May be null? Yes
|
Denotes the account's tax ID number stored with UPS. If the account does not have a stored Tax ID number, this field will be blank. |
| ALTERNATE_INVOICE_AMOUNT
Indexed - no
Format – varchar2(25)
May be null? Yes
|
Denotes the invoice amount in the local currency (for countries with dual currencies). |
| ALTERNATE_INVOICE_CURRENCYCODE
Indexed - no
Format – varchar2(10)
May be null? Yes
|
Denotes the currency represented in Alternate Invoice Amount. |
| ALTERNATE_INVOICE_NUMBER
Indexed - no
Format – varchar2(15)
May be null? Yes
|
Denotes the alternate invoice number. |
| BILL_OPTION_CODE
Indexed - no
Format – varchar2(5)
May be null? Yes
|
Denotes the options available for billing i.e., third party, freight collect, prepaid, etc. |
| CHARGE_CATEGORY_CODE
Indexed - no
Format – varchar2(10)
May be null? Yes
|
Defines whether a transaction is a shipment, return, miscellaneous charge, or post delivery adjustment. |
| CHARGE_CATEGORY_DETAIL_CODE
Indexed - no
Format – varchar2(10)
May be null? Yes
|
Provides a greater level of detail related to the CHARGE_CATEGORY_CODE. |
| CHARGE_DATA_CAPTURE_SOURCE
Indexed - no
Format – varchar2(10)
May be null? Yes
|
Defines what UPS product was utilized to create a shipment, such as internet shipping, Worldship, Campus Ship, etc. |
| CURRENCY_VARIANCE_AMOUNT
Indexed - no
Format – varchar2(25)
May be null? Yes
|
Denotes the tax variance amount converted to the alternate currency (for countries with dual currencies). |
| EXCHANGE_RATE
Indexed - no
Format – varchar2(20)
May be null? Yes
|
Denotes the exchange rate used to convert the invoice amount to the local currency (for countries with dual currencies). |
| EXTRACT_DATE
Indexed - no
Format – date
May be null? Yes
|
Denotes the date that shipment details and amounts were fed to the General Ledger and the Data Warehouse. |
| INVOICE_AMOUNT
Indexed - no
Format – number(12,2)
May be null? Yes
|
Denotes the total amount of the invoice. |
| INVOICE_CURRENCY_CODE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the currency type associated with monetary amounts within the file. |
| INVOICE_DATE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the date of the invoice. |
| INVOICE_DUE_DATE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the date the payment for the invoice is due to UPS. |
| INVOICE_LEVEL_CHARGE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the BOLLO charge (Italy only). |
| INVOICE_NUMBER
Indexed - yes
Format – number(12)
May be null? Yes
|
Denotes the invoice number of the invoice the charge would appear on. |
| INVOICE_TYPE_CODE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes that the invoice is either an export or domestic service invoice.
Denotes that the invoice is an import service invoice.
|
| INVOICE_TYPE_DETAIL_CODE
Indexed - no
Format – number(12)
May be null? Yes
|
Provides a greater level of detail for the INVOICE_TYPE_CODE. |
| LEAD_SHIPMENT_NUMBER
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the lead shipment number for the shipment. This number is used to associate all shipment charges together. |
| PAYER_ROLE_CODE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the role of the Account responsible for the charges, i.e. shipper, receiver, etc. |
| PICKUP_RECORD_NUMBER
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the pickup record number for the service rendered by UPS. In instances when there is no pickup number, this field is left blank. |
| RECIPIENT_NUMBER
Indexed - no
Format – number(12)
May be null? Yes
|
CPP Number - Denotes the CPP consolidated payment plan (may include multiple accounts).
Shipper Number - Denotes the account number the file is representative of.
UPS Freight Bill-To Customer Number -Denotes the UPS Freight customer number the file is representative of.
|
| SHIPMENT_REFERENCE_NUMBER1
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the first reference number applied by the customer to assist in identifying the shipment. |
| SHIPMENT_REFERENCE_NUMBER2
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the second reference number applied by the customer to assist in identifying the shipment. |
| TAX_VARIANCE_AMOUNT
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the tax variance amount at the invoice level. |
| TRANSACTION_CUSTOMS_ID
Indexed - yes
Format – number(12)
May be null? Yes
|
Denotes the number assigned to the shipment by customs. |
| TRANSACTION_DATE
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the date the service was rendered by UPS. |
| TRANSACTION_MASTER_ID
Indexed - yes
Format – number(12)
May be null? No
|
A sequence of numbers used to uniquely identify a transaction. |
| WORLD_EASE_NUMBER
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the lead shipment number for a World Ease consolidation. This field will be blank for all other movements. |
| XML_BILL_FILE_VERSION
Indexed - no
Format – number(12)
May be null? Yes
|
Denotes the version of UPS Billing Data File. |
