UPS_TRANSACTION_MISC_DETAILS Table


			<< go back

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

Data element	Definition
TRANSACTION_MISC_ID Indexed - yes Format - number(12) May be null? No	Unique identifier of each line of miscellaneous detail contained within a transaction.
TRANSACTION_MASTER_ID Indexed - yes Format – number(12) May be null? Yes	A sequence of numbers used to uniquely identify a transaction.
TYPE_CODE Indexed - no Format – varchar2(5) May be null? Yes	Denotes that the invoice is either an export or domestic service invoice.
TYPE_DETAIL_CODE Indexed - no Format – varchar2(35) May be null? Yes	Further defines the export or domestic service.
TYPE_DETAIL_VALUE Indexed - no Format – varchar2(10) May be null? Yes	This field is not used for current version of the UPS Billing Data File and has been included for future expansion purposes.
LINE_TEXT Indexed - no Format – varchar2(50) May be null? Yes	Textual description of miscellaneous transaction detail.

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