DEPOSIT_BUDEPOSIT_IDPAYMENT_SEQ_NUMID_SEQ_NUMAR_PYMNT_ITEM(SQL View) |
Index Back |
|---|
| SELECT D.DEPOSIT_BU , D.DEPOSIT_ID , D.PAYMENT_SEQ_NUM , D.ID_SEQ_NUM , R.REF_QUALIFIER_CODE , R.FIELDNAME , D.REF_VALUE , D.REF_VALUE , D.PAY_AMT , D.ITEM_AMT , D.BAL_AMT , D.BAL_CURRENCY , D.PAY_AMT_BASE , D.CURRENCY_CD FROM PS_AR_FLD_REF_TBL R , PS_PAYMENT_ID_ITEM D WHERE R.REF_QUALIFIER_CODE = D.REF_QUALIFIER_CODE AND R.REF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPOSIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 2 | DEPOSIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 3 | PAYMENT_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 4 | ID_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Identification Sequence number |
| 5 | REF_QUALIFIER_CODE | Character(2) | VARCHAR2(2) NOT NULL | Reference Qualifier Code |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | REF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Reference |
| 8 | ITEM | Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 9 | PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 10 | ITEM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 11 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 12 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 13 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |