Penn Computing

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

UPS_TRANSACTION_ADDRESS Table - Data Element Index

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

 



Data element Definition
ADDRESS_LINE1

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

Contains the street address of the individual identified by associated ADDRESS_TYPE.
ADDRESS_LINE2

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

Contains additional address information of the individual identified by associated ADDRESS_TYPE.
ADDRESS_TYPE

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

Denotes whether the address information relates to the shipper or receiver of a shipment.
CITY

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

Denotes the city of the individual identified by the associated ADDRESS_TYPE.
COMPANY_NAME

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

Denotes the company name of the individual identified by the associated ADDRESS_TYPE.
COUNTRY

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

Denotes the country of the individual identified by the associated ADDRESS_TYPE.
NAME

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

Denotes the name of the individual identified by the associated ADDRESS_TYPE.
POSTAL

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

Denotes the zip code of the individual identified by the associated ADDRESS_TYPE.
STATE

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

Denotes the state of the individual identified by the associated ADDRESS_TYPE.
TRANSACTION_ADDRESS_ID

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

Unique identifier of each address 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.

UPS_TRANSACTION_ADDRESS 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