BAL_ACCUM_IDPrompt Table: BI_ACCUM_ID
BI_CURRENCY_CDPrompt Table: CURRENCY_CD_TBL
BASE_CURRENCYPrompt Table: CURRENCY_CD_TBL
CURRENCY_CD_XEUPrompt Table: CURRENCY_CD_TBL
ACCUM_KEY1_VALACCUM_KEY2_VALACCUM_KEY3_VALACCUM_KEY4_VALACCUM_KEY5_VALBI_ACCUM_KEY(SQL Table) |
Index Back |
|---|---|
Cumulative Billing Keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BAL_ACCUM_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Balance Accumulation ID
Prompt Table: BI_ACCUM_ID |
| 2 | BI_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | 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. "
Prompt Table: CURRENCY_CD_TBL |
| 4 | CURRENCY_CD_XEU |
Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Prompt Table: CURRENCY_CD_TBL |
| 5 | ACCUM_KEY1_VAL |
Character(30) | VARCHAR2(30) NOT NULL | Accumulation Key 1 Value |
| 6 | ACCUM_KEY2_VAL |
Character(30) | VARCHAR2(30) NOT NULL | Accumulation Key 2 Value |
| 7 | ACCUM_KEY3_VAL |
Character(30) | VARCHAR2(30) NOT NULL | Accumulation Key 3 Value |
| 8 | ACCUM_KEY4_VAL |
Character(30) | VARCHAR2(30) NOT NULL | Accumulation Key 4 Value |
| 9 | ACCUM_KEY5_VAL |
Character(30) | VARCHAR2(30) NOT NULL | Accumulation Key 5 Value |