VNDR_AUDIT_SM_H(SQL Table) |
Index Back |
|---|---|
Supplier Audit Archive |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | IDX_VAL_KEY |
Number(30,0) | DECIMAL(30) NOT NULL | AutoGenerated Index Value key |
| 7 | DATETIME_STAMP |
DateTime(26) | TIMESTAMP | DateTime Stamp |
| 8 | 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. |
| 9 | GROUP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Group Name |
| 10 | 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 |
| 11 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 13 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 14 | ORIG_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Original Value |
| 15 | CHGD_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Changed Value |
| 16 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 17 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 18 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 19 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 20 | KEY1 | Character(65) | VARCHAR2(65) NOT NULL | First Key |
| 21 | KEY2 | Character(65) | VARCHAR2(65) NOT NULL | Second Key |
| 22 | KEY3 | Character(65) | VARCHAR2(65) NOT NULL | Third Key |
| 23 | KEY4 | Character(65) | VARCHAR2(65) NOT NULL | Fourth Key |
| 24 | KEY5 | Character(65) | VARCHAR2(65) NOT NULL | Fifth Key |
| 25 | KEY6 | Character(65) | VARCHAR2(65) NOT NULL | Sixth Key |
| 26 | KEY7 | Character(65) | VARCHAR2(65) NOT NULL | Seventh Key |
| 27 | KEY8 | Character(65) | VARCHAR2(65) NOT NULL | Eighth Key |
| 28 | KEY9 | Character(65) | VARCHAR2(65) NOT NULL | Ninth Key |
| 29 | KEY10 | Character(65) | VARCHAR2(65) NOT NULL | Tenth Key |
| 30 | KEY11 | Character(65) | VARCHAR2(65) NOT NULL | Eleventh Key |
| 31 | KEY12 | Character(65) | VARCHAR2(65) NOT NULL | Twelfth Key |
| 32 | KEY13 | Character(65) | VARCHAR2(65) NOT NULL | Thirteenth Key |
| 33 | KEY14 | Character(65) | VARCHAR2(65) NOT NULL | Fourteenth Key |
| 34 | KEY15 | Character(65) | VARCHAR2(65) NOT NULL | Fifteenth Key |