PYMNT_DTREMIT_VENDORBANK_ACCOUNT_NUMPYMNT_DFT_TMP1(SQL Table) |
Index Back |
|---|---|
Payment Draft Inquiry Temp1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PYMNT_DT |
Date(10) | DATE | Payment Date |
| 2 | REMIT_VENDOR |
Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 5 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 6 | PAID_CNT | Number(8,0) | INTEGER NOT NULL | Paid Count |