AP_USF_VNDR_AET

(SQL Table)
Index Back

USF Vendor State Record

Bug 20033081 - added PYMNT_CNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
3 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix
4 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
9 VNDR_USF_ORGIN Character(1) VARCHAR2(1) NOT NULL Vendor Origin
A=Automatic
F=Federal
M=Manual
10 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12 USF_EXTRACT_CD Character(1) VARCHAR2(1) NOT NULL Extract Code
1=Delete send DUNS and CAGE
2=New - send complete record
3=Update - send complete record
4=Expired send DUNS and CAGE
A=Active
E=Expired
13 VNDR_CCR_STATUS Character(1) VARCHAR2(1) NOT NULL SAM Status of a Vendor
A=Active
E=Expired
U=Unregistered
X=Exempt
14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
15 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
16 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
17 WTHD_FLG Character(1) VARCHAR2(1) NOT NULL Withhold if missing
N=Don't withholding
Y=Withholdeable
18 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
19 TRADING_PARTNER Character(6) VARCHAR2(6) NOT NULL Trading Partner Code
20 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
21 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator