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