AP_BANK_SCHED(SQL Table) |
Index Back |
|---|---|
Bank Account Schedule ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 3 | SCHEDULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 4 | PYMNT_TR_SENT_DT | Date(10) | DATE | Payment Schedule Sent Date |
| 5 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 6 | CANCEL_DT | Date(10) | DATE | Date Cancelled |
| 7 | DISBURSED_DT | Date(10) | DATE | Disbursed Date Field |
| 8 | PYMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |
| 9 | CANCEL_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Action
C=Do Not Reissue/Close Liability H=Re-Open Voucher(s)/Put on Hold N=No Cancel Action P=Processed R=Re-Open Voucher(s)/Re-Issue S=Stale Dated Check W=Escheated |
| 10 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 11 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |