PO_ROLL_EXCEP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SEARCH_ID | Character(10) | VARCHAR2(10) NOT NULL | Search ID |
| 3 | ROLL_EXCEP | Character(3) | VARCHAR2(3) NOT NULL |
Rollover Exceptions
IPO=Invalid Budget Status - PO IVC=Invalid Budget Status-Voucher PR=BCM Error on PO,Rcpt part Vchr PV=Invalid Budget Status - PO&Vch PVR=BCM Error on PO,Vch, Part Rec RV=One Receipt Part Vouchered VR=BCM error in Vch, Part Receivd |
| 4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | RECEIPT_BU | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 6 | RECEIPT_ID | Character(10) | VARCHAR2(10) NOT NULL | Receipt ID |
| 7 | VOUCHER_BU | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 8 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | RECEIPT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Receipt Amount |
| 10 | VOUCHER_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Voucher Amount |