BI_ACCUM_ID(SQL Table) |
Index Back |
|---|---|
Cumulative Balancing Defn |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | ACCUM_KEY1 | Character(18) | VARCHAR2(18) NOT NULL |
Balance Accumulation Key 1
Prompt Table: BI_ACCUM_FC_VW |
| 5 | ACCUM_KEY2 | Character(18) | VARCHAR2(18) NOT NULL |
Balance Accumulation Key 2
Prompt Table: BI_ACCUM_FC_VW |
| 6 | ACCUM_KEY3 | Character(18) | VARCHAR2(18) NOT NULL |
Balance Accumulation Key 3
Prompt Table: BI_ACCUM_FC_VW |
| 7 | ACCUM_KEY4 | Character(18) | VARCHAR2(18) NOT NULL |
Balance Accumulation Key 4
Prompt Table: BI_ACCUM_FC_VW |
| 8 | ACCUM_KEY5 | Character(18) | VARCHAR2(18) NOT NULL |
Balance Accumulation Key 5
Prompt Table: BI_ACCUM_FC_VW |
| 9 | ACCUM_AMT1 | Character(18) | VARCHAR2(18) NOT NULL |
Accumulation Amount Field 1
Prompt Table: BI_ACCUM_FS_VW |
| 10 | ACCUM_AMT2 | Character(18) | VARCHAR2(18) NOT NULL |
Accumulation Amount Field 2
Prompt Table: BI_ACCUM_FS_VW |
| 11 | ACCUM_AMT3 | Character(18) | VARCHAR2(18) NOT NULL |
Accumulation Amount Field 3
Prompt Table: BI_ACCUM_FS_VW |
| 12 | ACCUM_AMT4 | Character(18) | VARCHAR2(18) NOT NULL |
Accumulation Amount Field 4
Prompt Table: BI_ACCUM_FS_VW |
| 13 | ACCUM_AMT5 | Character(18) | VARCHAR2(18) NOT NULL |
Accumulation Amount Field 5
Prompt Table: BI_ACCUM_FS_VW |
| 14 | ACCUM_QTY | Character(1) | VARCHAR2(1) NOT NULL |
Accumulate Quantity
Y/N Table Edit Default Value: Y |
| 15 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 16 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 17 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 18 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |