AP_PENDAPPL_TMP(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 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 4 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 5 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 8 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 9 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 10 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 11 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 12 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 13 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 14 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 15 | BASE_CURRENCY_BNK | Character(3) | VARCHAR2(3) NOT NULL | The base currency of the subject bank general ledger business unit. |
| 16 | CUR_RT_TYPE_BNK | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 17 | BNK_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange spot rate is stored either as |
| 18 | BNK_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange spot rate is store |
| 19 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 20 | PREPAID_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prepaid Status
A=Applied B=Pending Application C=Pending Unapply D=Pending Change F=Fully Applied I=Inactive P=Available Prepayment R=Restricted U=Unapplied X=Cancelled |
| 21 | PREPAID_APPLIED_BU |
Character(5) | VARCHAR2(5) NOT NULL | Applied Business Unit |
| 22 | PREPAID_APPL_VCHR |
Character(8) | VARCHAR2(8) NOT NULL | Applied Voucher ID |
| 23 | PREPAID_APPL_PYMNT |
Number(5,0) | INTEGER NOT NULL | Applied Payment Count |
| 24 | ORIG_PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Original Payment Count |
| 25 | DSCNT_DUE_DT | Date(10) | DATE | Discount Due Date |
| 26 | DSCNT_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Discount Amount |
| 27 | PAID_AMT_DSCNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount on Paid Amount |
| 28 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 29 | WTHD_ADDTL_GROSS | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Additional Withheld Gross Amt |