Penn Computing

University of Pennsylvania
Penn Computing << go backback
UPS_TRANS_CUSTOMS_INFO Table   Tables and Data Elements   Express Mail Home    Data Warehouse Home

UPS_TRANS_CUSTOMS_INFO Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
CUSTOMS_CARGO_CONTROL_DOC_NUM

Indexed - no
Format - varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_CARRIER_DATE

Indexed - no
Format - date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_CONTACT_NAME

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_CUSTOMS_NUMBER

Indexed - no
Format – varchar2(20)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_CYCLE_DATE

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_CYCLE_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_DECLARTION_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_DIRECT_SHIPMENT_DATE

Indexed - no
Format – date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_DUTY_AMOUNT

Indexed - no
Format – varchar2(17)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_EFT_DATE

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_ENTERED_CURRENCY_CODE

Indexed - no
Format – varchar2(3)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_ENTERED_VALUE

Indexed - no
Format – varchar2(17)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_ENTRY_DATE

Indexed - no
Format – date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_ENTRY_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_ENTRY_PORT

Indexed - no
Format – varchar2(4)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_EXCHANGE_RATE

Indexed - no
Format – varchar2(15)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_EXPORT_PLACE

Indexed - no
Format – varchar2(2)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_FOREIGN_TRADE_REF_NUM

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_JOB_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_MASTER_AIRBILL_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_OFFICE_NUMBER

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_EXPORT_DATE

Indexed - no
Format – date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_DATE

Indexed - no
Format – date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_DELIVERY_DATE

Indexed - no
Format – varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_IMPORT_DATE

Indexed - no
Format - date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_RELEASE_DATE

Indexed - no
Format - date
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_SHIPMENT_VALUE_AMOUNT

Indexed - no
Format - varchar2(17)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_TAX_ID

Indexed - no
Format – varchar2(14)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
CUSTOMS_TRANSPORT_MODE

Indexed - no
Format - varchar2(4)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
IMPORT_SHIPMENT_DESCRIPTION

Indexed - no
Format - varchar2(50)
May be null? Yes

This data element was not in use at the time of implementation, but may be utilized in the future.
TRANSACTION_CUSTOMS_ID

Indexed - yes
Format - number(12)
May be null? No

This data element was not in use at the time of implementation, but may be utilized in the future.

UPS_TRANS_CUSTOMS_INFO Table   Tables and Data Elements   Express Mail Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania