DR_BY_BANK_TMP

(SQL Table)
Index Back

Draft Summary by Bank Temp Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
6 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
7 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.
8 DRAFT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment in the business unit's base currency. This field is maintained by the Draft Creation process.
9 DRAFT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.
10 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.
11 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
12 DRAFT_DUE_DT Date(10) DATE Draft Due Date
13 DAY_2 Character(2) VARCHAR2(2) NOT NULL