FS_ALLC_CUR_AET(SQL Table) |
Index Back |
---|---|
FS ALLC - base currency AET |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | 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. " |
3 | BASE_CURRENCY_POOL | Character(3) | VARCHAR2(3) NOT NULL | Ledger Base Currency |
4 | BASE_CURR_CD | Character(3) | VARCHAR2(3) NOT NULL | Baseline spend currency |
5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
6 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
7 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
8 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
9 | FIELDNAME_BASE_AMT | Character(18) | VARCHAR2(18) NOT NULL | Base Amount |
10 | FIELDNAME_BASE_CUR | Character(18) | VARCHAR2(18) NOT NULL | Base Currency |
11 | FIELDNAME_TARGET | Character(18) | VARCHAR2(18) NOT NULL | Allocations Target amount field |
12 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
13 | LEDGER_FOUND | Character(1) | VARCHAR2(1) NOT NULL | Ledger Found |
14 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
15 | LEDGER_PRIMARY | Character(10) | VARCHAR2(10) NOT NULL | Primary Ledger for a Group |
16 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
17 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
18 | RECNAME_TARGET | Character(15) | VARCHAR2(15) NOT NULL | Target Recname |