SETIDVENDOR_IDA=Add
D=Delete
I=Inactivate
U=Update
N=No
Y=Yes
SCR_VSR_ORIG_VW(SQL View) |
Index Back |
|---|---|
RFC Vendor Original View |
| SELECT A.SETID ,A.VENDOR_ID ,' ' ,A.CORPORATE_SETID ,A.CORPORATE_VENDOR ,A.VNDR_AFFILIATE ,A.INTERUNIT_VNDR_FLG FROM PS_VENDOR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | SCR_CHNG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Request for Change Type
A=Add D=Delete I=Inactivate U=Update |
| 4 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | CORPORATE_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Corporate Vendor |
| 6 | VNDR_AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Vendor Affiliate |
| 7 | INTERUNIT_VNDR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Vendor
N=No Y=Yes |