FILENAMEALCIPAC_HDR_SEQ_NUMIPAC_DTL_SEQ_NUMIPAC_SGL_SEQ_NUMR=Receiver SGL
S=Sender SGL
F=Federal
N=Non-Federal
1=Credit
2=Debit
IPAC_SGL_STG(SQL Table) |
Index Back |
|---|---|
Inbound IPAC SGL STGInbound IPAC SGL staging record populated by AP_INIPAC application engine processing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FILENAME |
Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 2 | ALC |
Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 3 | IPAC_HDR_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | IPAC Header Sequence Number |
| 4 | IPAC_DTL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | IPAC Detail Sequence Number |
| 5 | IPAC_SGL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | IPAC SGL Sequence Number |
| 6 | IPAC_SGL_ACCOUNT | Number(4,0) | SMALLINT NOT NULL | IPAC SGL Account Number |
| 7 | IPAC_SGL_SR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Sender/Receiver Flag
R=Receiver SGL S=Sender SGL |
| 8 | IPAC_SGL_FED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Federal Flag
F=Federal N=Non-Federal |
| 9 | IPAC_CR_DR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
IPAC Debit/Credit
1=Credit 2=Debit |
| 10 | IPAC_SGL_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | IPAC SGL Amount |