UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
VENDOR_ADDR
Contains all the vendor addresses.
This record is a child of VENDOR.
|
| ADDRESS_SEQ_NUM
| Address Sequence Number
| Example: 1
|
| KEY
| Type: number
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Represents the sequence in which multiple addresses are recorded.
|
| |
|
| .
|
| SETID
| SetID
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The only valid value at UD at this time is "UOD01".
|
| |
|
| .
|
| VENDOR_ID
| Vendor ID
| Example: 0000000001
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifier of the vendor.
|
| |
|
| .
|
| ADDRESS1
| Address Line 1
| Example: 222 S CHAPEL STREET
|
|
| Type: character
| Format: mixed
| Length: 55
| Decimals:
|
| | First line of the address.
|
| |
|
| .
|
| ADDRESS2
| Address Line 2
| Example: SUITE 401
|
|
| Type: character
| Format: mixed
| Length: 55
| Decimals:
|
| | Second line of the address.
|
| |
|
| .
|
| ADDRESS3
| Address Line 3
| Example: BUILDING A
|
|
| Type: character
| Format: mixed
| Length: 55
| Decimals:
|
| | Third line of the address.
|
| |
|
| .
|
| ADDRESS4
| Address Line 4
| Example: ROOM 19
|
|
| Type: character
| Format: mixed
| 55Length: 55
|
|
| | Fourth line of the address.
|
| |
|
| .
|
| CITY
| City
| Example: NEWARK
|
|
| Type: character
| Format: mixed
| Length: 30
| Decimals:
|
| | City or town of address.
|
| |
|
| .
|
| COUNTRY
| Country
| Example: USA
|
|
| Type: character
| Format: uppercase
| Length: 3
| Decimals:
|
| | Country portion of the address.
|
| |
|
| .
|
| COUNTY
| County
| Example: NEW CASTLE
|
|
| Type: character
| Format: mixed
| Length: 30
| Decimals:
|
| | County portion of the address.
|
| |
|
| .
|
| EFF_STATUS
| Status as of Effective Date
| Example: A
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Indicates whether the row of data is active or inactive.
|
| |
|
| .
|
| EMAILID
| Email ID
| Example:
|
|
| Type: character
| Format: lowercase
| Length: 70
| Decimals: 0
|
| | Email ID of the vendor.
|
| |
|
| .
|
| NAME1
| Name 1
| Example: VERIZON
|
|
| Type: character
| Format: lowercase
| Length: 40
| Decimals: 0
|
| | The first line of the vendor name.
|
| |
|
| .
|
| POSTAL
| Postal Code
| Example: 19716
|
|
| Type: character
| Format: custom
| Length: 12
| Decimals:
|
| | Zip code or equivalent.
|
| |
|
| .
|
| STATE
| State
| Example: DE
|
|
| Type: character
| Format: uppercase
| Length: 6
| Decimals:
|
| | State in an address.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| ADDR_FIELD1
| Address Field 1
|
| ADDR_FIELD2
| Address Field 2
|
| ADDR_FIELD3
| Address Field 3
|
| EFFDT
| Effective Date
|
| GEO_CODE
| Tax Vendor Geographical Code
|
| HOUSE_TYPE
| House Type
|
| IN_CITY_LIMIT
| In City Limit
|
| NAME2
| Name 2
|
| NUM1
| Number 1
|
| NUM2
| Number 2