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