DR_REMIT_FEE(SQL Table) |
Index Back |
---|---|
Draft Remittance Bank Fees |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Remittance Business Unit | |
2 | Character(15) | VARCHAR2(15) NOT NULL | Remittance ID | |
3 | Number(5,0) | INTEGER NOT NULL | Sequence control for ITEM | |
4 | 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 | 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 | Number(5,0) | INTEGER NOT NULL |
Identification Sequence number
Default Value: 1 |
|
7 | 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. |
8 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Default Value: BUS_UNIT_TBL_AR.ENTRY_TYPE_FEES |
9 | ENTRY_REASON | Character(5) | VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table: AUTO_RSN_DR_VW |
10 | ENTRY_USE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the System Function or type of processing associated with an entry type. |
11 | PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
12 | 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 |