PV_ITM_VNDR_IMG

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 LINEID Number(10,0) DECIMAL(10) NOT NULL SAC_AW test header record id
6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 1

7 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
8 FILE_NAME1 Character(80) VARCHAR2(80) NOT NULL Medium Image Name
9 FILE_NAME2 Character(80) VARCHAR2(80) NOT NULL Small Image Name
10 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
11 URL_1 Character(254) VARCHAR2(254) NOT NULL URL #1
12 URL_2 Character(254) VARCHAR2(254) NOT NULL URL #2