Penn Computing

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

UPS_TRANS_DUTIABLE Table - Data Element Index

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



Data element Definition
DUTIABLE_CLASS_NUMBER

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.
DUTIABLE_CUSTOMS_PROCEDURE_COD

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.
DUTIABLE_DOCUMENT_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.
DUTIABLE_DOCUMENT_TYPE

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.
DUTIABLE_DUTY_AMOUNT

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

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

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

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

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.
DUTIABLE_ENTRY_TYPE

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.
DUTIABLE_EXCISE_TAX_AMOUNT

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

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

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

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

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

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

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

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

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

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

Indexed - no
Format – number(5)
May be null? Yes

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

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

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

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

 This data element was not in use at the time of implementation, but may be utilized in the future.
DUTIABLE_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.
DUTIABLE_ORDER_IN_COUNCIL

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

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

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.
DUTIABLE_SPECIAL_IMPORT_TAX

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

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

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.
DUTIABLE_TARIFF_RATE

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

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

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

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

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.
DUTIABLE_TAX_VALUE_ AMOUNT

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

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

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

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

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.
TRANSACTION_DUTIABLE_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_DUTIABLE 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