VNDR_AUD_INQ_VW(SQL View) |
Index Back |
|---|---|
Supplier Audit InquiryView created for Supplier Audit Inquiry |
| SELECT A.SETID , A.VENDOR_ID , A.OPRID , A.IDX_VAL_KEY , A.DATETIME_STAMP , A.GROUP_ID , A.GROUP_NAME , A.ACTION_CODE , A.RECNAME , A.FIELDNAME , A.LBLTEXT , A.ORIG_VALUE , A.CHGD_VALUE , A.REASON_CD , A.COMMENT1 , A.OCCURSLEVEL , A.PROCESS_INSTANCE , A.KEY1 , A.KEY2 , A.KEY3 , A.KEY4 , A.KEY5 , A.KEY6 , A.KEY7 , A.KEY8 , A.KEY9 , A.KEY10 , A.KEY11 , A.KEY12 , A.KEY13 , A.KEY14 , A.KEY15 FROM PS_VNDR_AUDIT_SUMM A , PS_VENDOR B , PSOPRDEFN C WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.VENDOR_ID = 'ZZZZZzzzzz' AND A.OPRID = C.OPRID AND C.OPRID = 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ' |
| # | 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | IDX_VAL_KEY |
Number(30,0) | DECIMAL(30) NOT NULL | AutoGenerated Index Value key |
| 5 | DATETIME_STAMP |
DateTime(26) | TIMESTAMP | DateTime Stamp |
| 6 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 7 | GROUP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Group Name |
| 8 | ACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Action Code
ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 11 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 12 | ORIG_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Original Value |
| 13 | CHGD_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Changed Value |
| 14 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 15 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 16 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 18 | KEY1 | Character(65) | VARCHAR2(65) NOT NULL | First Key |
| 19 | KEY2 | Character(65) | VARCHAR2(65) NOT NULL | Second Key |
| 20 | KEY3 | Character(65) | VARCHAR2(65) NOT NULL | Third Key |
| 21 | KEY4 | Character(65) | VARCHAR2(65) NOT NULL | Fourth Key |
| 22 | KEY5 | Character(65) | VARCHAR2(65) NOT NULL | Fifth Key |
| 23 | KEY6 | Character(65) | VARCHAR2(65) NOT NULL | Sixth Key |
| 24 | KEY7 | Character(65) | VARCHAR2(65) NOT NULL | Seventh Key |
| 25 | KEY8 | Character(65) | VARCHAR2(65) NOT NULL | Eighth Key |
| 26 | KEY9 | Character(65) | VARCHAR2(65) NOT NULL | Ninth Key |
| 27 | KEY10 | Character(65) | VARCHAR2(65) NOT NULL | Tenth Key |
| 28 | KEY11 | Character(65) | VARCHAR2(65) NOT NULL | Eleventh Key |
| 29 | KEY12 | Character(65) | VARCHAR2(65) NOT NULL | Twelfth Key |
| 30 | KEY13 | Character(65) | VARCHAR2(65) NOT NULL | Thirteenth Key |
| 31 | KEY14 | Character(65) | VARCHAR2(65) NOT NULL | Fourteenth Key |
| 32 | KEY15 | Character(65) | VARCHAR2(65) NOT NULL | Fifteenth Key |