PROCESS_INSTANCEA=Active
E=Expired
U=Unregistered
X=Exempt
N=Don't withholding
Y=Withholdeable
AP_CCR_VNDR_AET(SQL Table) |
Index Back |
|---|---|
CCR Supplier State Record |
| # | 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 | CCR_DUNS_PLUS4 | Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | CCR_EXTRACT_CD | Character(1) | VARCHAR2(1) NOT NULL | CCR Extract Code |
| 7 | VNDR_CCR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SAM Status of a Vendor
A=Active E=Expired U=Unregistered X=Exempt |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 10 | WTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding Y=Withholdeable |
| 11 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 12 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |