REMIT_BUREMIT_IDID_SEQ_ITEMDRAFT_BUDRAFT_IDDefault Value: DR_REMIT_ITEM.DRAFT_CURRENCY
DR_REMIT_FEE_VW(SQL View) |
Index Back |
|---|---|
Draft Remittance Bank Fees |
| SELECT REMIT_BU ,REMIT_ID ,ID_SEQ_ITEM ,DRAFT_BU ,DRAFT_ID ,SUM(PAY_AMT) ,DRAFT_CURRENCY FROM PS_DR_REMIT_FEE GROUP BY REMIT_BU ,REMIT_ID ,ID_SEQ_ITEM ,DRAFT_BU ,DRAFT_ID ,DRAFT_CURRENCY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Remittance Business Unit |
| 2 | REMIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Remittance ID |
| 3 | ID_SEQ_ITEM |
Number(5,0) | INTEGER NOT NULL | Sequence control for ITEM |
| 4 | DRAFT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. |
| 5 | DRAFT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 6 | PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 7 | DRAFT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
Default Value: DR_REMIT_ITEM.DRAFT_CURRENCY |