| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 3 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
|
| 4 |
IPAC_HDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
IPAC Header Sequence Number
|
| 5 |
IPAC_DTL_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
IPAC Detail Sequence Number
|
| 6 |
IPAC_PO_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
IPAC Purchase Order
|
| 7 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 8 |
IPAC_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 9 |
IPAC_DESCR_X66 |
Character(66) |
VARCHAR2(66) NOT NULL |
IPAC Description - Extra 66 ch
|
| 10 |
IPAC_LN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Line Amount
|