SBI_PROCESS_CYCLESYSTEM_MAINTAINEDVENDOR_SETIDVENDOR_IDVNDR_LOCSBI_NUMA=Approved
U=Unapproved
Default Value: N
VCHR_SBI_R(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SBI_PROCESS_CYCLE |
Character(10) | VARCHAR2(10) NOT NULL | SBI Process Cycle ID |
| 2 | SYSTEM_MAINTAINED |
Character(1) | VARCHAR2(1) NOT NULL | System Maintained |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | SBI_NUM |
Character(40) | VARCHAR2(40) NOT NULL | SBI_num |
| 7 | PRINT_SBI | Character(1) | VARCHAR2(1) NOT NULL | Print SBI |
| 8 | SBI_APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SBI Approval Option
A=Approved U=Unapproved |
| 9 | SBI_PROCESS_KEY | Character(40) | VARCHAR2(40) NOT NULL | SBI Process Key |
| 10 | DELETE_AFTER_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Delete After Print
Default Value: N |
| 11 | CREATE_DATE | Date(10) | DATE | Creation Date |