BI_ACCUM_TOT_VW(SQL View) |
Index Back |
|---|---|
Cum Billing Total Balance VW |
| select a.bal_accum_id, a.bi_currency_cd, a.base_currency, a.currency_cd_xeu, a.accum_key1_val, a.accum_key2_val, a.accum_key3_val, a.accum_key4_val, a.accum_key5_val, a.balance_type, a.effdt, a.accum_amt1_bal, a.accum_amt2_bal, a.accum_amt3_bal, a.accum_amt4_bal, a.accum_amt5_bal, a.accum_bse1_bal, a.accum_bse2_bal, a.accum_bse3_bal, a.accum_bse4_bal, a.accum_bse5_bal, a.accum_xeu1_bal, a.accum_xeu2_bal, a.accum_xeu3_bal, a.accum_xeu4_bal, a.accum_xeu5_bal, a.accum_qty_bal from PS_BI_ACCUM_BAL a where a.balance_type = 'T' and a.effdt = (select max(effdt) from PS_BI_ACCUM_BAL c where c.bal_accum_id = a.bal_accum_id and c.accum_key1_val = a.accum_key1_val and c.accum_key2_val = a.accum_key2_val and c.accum_key3_val = a.accum_key3_val and c.accum_key4_val = a.accum_key4_val and c.accum_key5_val = a.accum_key5_val and c.balance_type = 'T') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BAL_ACCUM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Balance Accumulation ID |
| 2 | BI_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 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. " |
| 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 |
| 10 | BALANCE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Balance Type
B=Beginning Cumulative Balance C=Cumulative Balance Ceiling I=Invoiced Cumulative Balance N=Uninvoiced Cumulative Balance T=Total Cumulative Balance |
| 11 | EFFDT |
Date(10) | DATE | Effective Date |
| 12 | ACCUM_AMT1_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 1 |
| 13 | ACCUM_AMT2_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 2 |
| 14 | ACCUM_AMT3_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 3 |
| 15 | ACCUM_AMT4_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 4 |
| 16 | ACCUM_AMT5_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 5 |
| 17 | ACCUM_BSE1_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 1 |
| 18 | ACCUM_BSE2_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 2 |
| 19 | ACCUM_BSE3_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 3 |
| 20 | ACCUM_BSE4_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 4 |
| 21 | ACCUM_BSE5_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 5 |
| 22 | ACCUM_XEU1_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 1 |
| 23 | ACCUM_XEU2_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 2 |
| 24 | ACCUM_XEU3_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 3 |
| 25 | ACCUM_XEU4_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 4 |
| 26 | ACCUM_XEU5_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cumulative Balance 5 |
| 27 | ACCUM_QTY_BAL | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Cumulative Quantity |