SUM_TEMPLATE_IDPrompt Table: BI_SUM_TEMPLATE
A=Active
I=Inactive
Default Value: A
Prompt Table: BI_SUM_ID_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
BI_SUM_TEMPLATE(SQL Table) |
Index Back |
|---|---|
Summarization Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SUM_TEMPLATE_ID |
Character(16) | VARCHAR2(16) NOT NULL |
Summarization Template ID
Prompt Table: BI_SUM_TEMPLATE |
| 2 | STATUS_BI | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Active I=Inactive Default Value: A |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | SUM_CFG_ID | Character(16) | VARCHAR2(16) NOT NULL |
Summarization Configuration ID
Prompt Table: BI_SUM_ID_VW |
| 6 | SUM_QTY_UOM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Summarize & Display Qty & UOM
Y/N Table Edit Default Value: N |
| 7 | INCLUDE_LN_NTE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Line Notes
Y/N Table Edit Default Value: N |
| 8 | SUMMARIZED_NOTE | Character(254) | VARCHAR2(254) NOT NULL | Summarized Note |
| 9 | SUM_IVC_LINE_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Summarize Invoice Line Text |
| 10 | SORT_IVC_LINE_TEXT | Character(160) | VARCHAR2(160) NOT NULL | Sort Invoice Line Text |
| 11 | SELECT_PARM1 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 1 |
| 12 | SELECT_PARM2 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 2 |
| 13 | BLD_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Bld Clause1 |
| 14 | BLD_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Bld Clause2 |
| 15 | BLD_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Bld Clause3 |
| 16 | BLD_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Bld Clause4 |
| 17 | BLD_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Bld Clause5 |
| 18 | GROUP_HEADER_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | Group Header Text |
| 19 | GROUP_HEADER_TEXT2 | Character(254) | VARCHAR2(254) NOT NULL | Group Header Text |
| 20 | GROUP_DETAIL_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | Group Detail Text |
| 21 | GROUP_DETAIL_TEXT2 | Character(254) | VARCHAR2(254) NOT NULL | Group Detail Text |
| 22 | GROUP_DETAIL_TEXT3 | Character(254) | VARCHAR2(254) NOT NULL | Group Detail Text |
| 23 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 24 | 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. |
| 25 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |