DR_REMIT_FEE

(SQL Table)
Index Back

Draft Remittance Bank Fees

# 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 ID_SEQ_NUM 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