PJO_EXCEL_EXPORT_OPTIONS
This table is used in customizing the excel layouts.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJO_EXCEL_EXPORT_OPTIONS_PK |
EXCEL_EXPORT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXCEL_EXPORT_ID | NUMBER | Yes | EXCEL_EXPORT_ID ***** | ||
| PC_CON_RR | VARCHAR2 | 1 | PC_CON_RR | ||
| PLC_CON_RR | VARCHAR2 | 1 | PLC_CON_RR | ||
| PC_CON_CR | VARCHAR2 | 1 | PC_CON_CR | ||
| PLC_CON_CR | VARCHAR2 | 1 | PLC_CON_CR | ||
| MAR_TOTAL_COMM | VARCHAR2 | 1 | MAR_TOTAL_COMM | ||
| MARGIN_ETC | VARCHAR2 | 1 | MARGIN_ETC | ||
| MARGIN_EAC | VARCHAR2 | 1 | MARGIN_EAC | ||
| MAR_PERC_TOTAL_COMM | VARCHAR2 | 1 | MAR_PERC_TOTAL_COMM | ||
| MAR_PERC_ACT_AMT | VARCHAR2 | 1 | MAR_PERC_ACT_AMT | ||
| MAR_PERC_ETC | VARCHAR2 | 1 | MAR_PERC_ETC | ||
| MAR_PERC_EAC | VARCHAR2 | 1 | MAR_PERC_EAC | ||
| MARGIN_PRCT_BUD | VARCHAR2 | 1 | MARGIN_PRCT_BUD | ||
| MARGIN_PERC_ETC | VARCHAR2 | 1 | MARGIN_PERC_ETC | ||
| MARGIN_PERC_EAC | VARCHAR2 | 1 | MARGIN_PERC_EAC | ||
| PLANNING_OPTION_ID | NUMBER | Yes | PLANNING_OPTION_ID ***** | ||
| FLAGGED_FOR_DELETION | VARCHAR2 | 1 | Yes | FLAGGED_FOR_DELETION ***** | |
| CHANGED | VARCHAR2 | 1 | Yes | CHANGED ***** | |
| ERRORS | VARCHAR2 | 1 | Yes | ERRORS ***** | |
| STATUS | VARCHAR2 | 1 | Yes | STATUS ***** | |
| TASK_NUMBER | VARCHAR2 | 1 | Yes | TASK_NUMBER ***** | |
| TASK_NAME | VARCHAR2 | 1 | Yes | TASK_NAME ***** | |
| PLANNING_RESOURCE | VARCHAR2 | 1 | Yes | PLANNING_RESOURCE ***** | |
| UNIT_OF_MEASURE | VARCHAR2 | 1 | Yes | UNIT_OF_MEASURE ***** | |
| PLANNING_CURRENCY | VARCHAR2 | 1 | Yes | PLANNING_CURRENCY ***** | |
| FROM_DATE | VARCHAR2 | 1 | Yes | FROM_DATE ***** | |
| TILL_DATE | VARCHAR2 | 1 | Yes | TILL_DATE ***** | |
| PERIOD | VARCHAR2 | 1 | Yes | PERIOD ***** | |
| PERIODIC_FROM_DATE | VARCHAR2 | 1 | Yes | PERIODIC_FROM_DATE ***** | |
| PERIODIC_TO_DATE | VARCHAR2 | 1 | Yes | PERIODIC_TO_DATE ***** | |
| RESOURCE_CLASS | VARCHAR2 | 1 | Yes | RESOURCE_CLASS ***** | |
| SPREAD_CURVE | VARCHAR2 | 1 | Yes | SPREAD_CURVE ***** | |
| ORG_BSLN_BUD_QTY | VARCHAR2 | 1 | Yes | ORG_BSLN_BUD_QTY ***** | |
| CUR_BSLN_BUD_QTY | VARCHAR2 | 1 | Yes | CUR_BSLN_BUD_QTY ***** | |
| RC_TOTAL | VARCHAR2 | 1 | Yes | RC_TOTAL ***** | |
| RC_STAND_RATE | VARCHAR2 | 1 | Yes | RC_STAND_RATE ***** | |
| RC_EFFCT_RATE | VARCHAR2 | 1 | Yes | RC_EFFCT_RATE ***** | |
| RC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_ORG_BSLN_BUD ***** | |
| RC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_CUR_BSLN_BUD ***** | |
| BC_TOTAL | VARCHAR2 | 1 | Yes | BC_TOTAL ***** | |
| BC_STAND_RATE | VARCHAR2 | 1 | Yes | BC_STAND_RATE ***** | |
| BC_EFFCT_RATE | VARCHAR2 | 1 | Yes | BC_EFFCT_RATE ***** | |
| BC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_ORG_BSLN_BUD ***** | |
| BC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_CUR_BSLN_BUD ***** | |
| BC_STAND_MULT | VARCHAR2 | 1 | Yes | BC_STAND_MULT ***** | |
| BC_EFFECT_MULT | VARCHAR2 | 1 | Yes | BC_EFFECT_MULT ***** | |
| PC_CON_CR_DATE_TYPE | VARCHAR2 | 1 | Yes | PC_CON_CR_DATE_TYPE ***** | |
| PC_CON_CR_TYPE | VARCHAR2 | 1 | Yes | PC_CON_CR_TYPE ***** | |
| PC_CON_CR_DATE | VARCHAR2 | 1 | Yes | PC_CON_CR_DATE ***** | |
| PLC_CON_CR_DATE_TYPE | VARCHAR2 | 1 | Yes | PLC_CON_CR_DATE_TYPE ***** | |
| PLC_CON_CR_TYPE | VARCHAR2 | 1 | Yes | PLC_CON_CR_TYPE ***** | |
| PLC_CON_CR_DATE | VARCHAR2 | 1 | Yes | PLC_CON_CR_DATE ***** | |
| RC_PC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_PC_ORG_BSLN_BUD ***** | |
| RC_PC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_PC_CUR_BSLN_BUD ***** | |
| RC_PC_TOTAL | VARCHAR2 | 1 | Yes | RC_PC_TOTAL ***** | |
| RC_PLC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_PLC_ORG_BSLN_BUD ***** | |
| RC_PLC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | RC_PLC_CUR_BSLN_BUD ***** | |
| RC_PLC_TOTAL | VARCHAR2 | 1 | Yes | RC_PLC_TOTAL ***** | |
| BC_PC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_PC_ORG_BSLN_BUD ***** | |
| BC_PC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_PC_CUR_BSLN_BUD ***** | |
| BC_PC_TOTAL | VARCHAR2 | 1 | Yes | BC_PC_TOTAL ***** | |
| BC_PLC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_PLC_ORG_BSLN_BUD ***** | |
| BC_PLC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | BC_PLC_CUR_BSLN_BUD ***** | |
| BC_PLC_TOTAL | VARCHAR2 | 1 | Yes | BC_PLC_TOTAL ***** | |
| TOT_QTY | VARCHAR2 | 1 | Yes | TOT_QTY ***** | |
| REV_TOTAL | VARCHAR2 | 1 | Yes | REV_TOTAL ***** | |
| REV_STD_RATE | VARCHAR2 | 1 | Yes | REV_STD_RATE ***** | |
| REV_EFFCT_RATE | VARCHAR2 | 1 | Yes | REV_EFFCT_RATE ***** | |
| REV_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_ORG_BSLN_BUD ***** | |
| REV_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_CUR_BSLN_BUD ***** | |
| PC_CON_RR_DATE_TYPE | VARCHAR2 | 1 | Yes | PC_CON_RR_DATE_TYPE ***** | |
| PC_CON_RR_DATE | VARCHAR2 | 1 | Yes | PC_CON_RR_DATE ***** | |
| PC_CON_RR_TYPE | VARCHAR2 | 1 | Yes | PC_CON_RR_TYPE ***** | |
| PLC_CON_RR_DATE_TYPE | VARCHAR2 | 1 | Yes | PLC_CON_RR_DATE_TYPE ***** | |
| PLC_CON_RR_DATE | VARCHAR2 | 1 | Yes | PLC_CON_RR_DATE ***** | |
| PLC_CON_RR_TYPE | VARCHAR2 | 1 | Yes | PLC_CON_RR_TYPE ***** | |
| REV_PC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_PC_ORG_BSLN_BUD ***** | |
| REV_PC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_PC_CUR_BSLN_BUD ***** | |
| REV_PC_TOTAL | VARCHAR2 | 1 | Yes | REV_PC_TOTAL ***** | |
| REV_PLC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_PLC_ORG_BSLN_BUD ***** | |
| REV_PLC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | REV_PLC_CUR_BSLN_BUD ***** | |
| REV_PLC_TOTAL | VARCHAR2 | 1 | Yes | REV_PLC_TOTAL ***** | |
| MARGIN_BUDGET | VARCHAR2 | 1 | Yes | MARGIN_BUDGET ***** | |
| MARG_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | MARG_ORG_BSLN_BUD ***** | |
| MARG_CURR_BSLN_BUD | VARCHAR2 | 1 | Yes | MARG_CURR_BSLN_BUD ***** | |
| MARG_PERC_BUD | VARCHAR2 | 1 | Yes | MARG_PERC_BUD ***** | |
| MARG_PERC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | MARG_PERC_ORG_BSLN_BUD ***** | |
| MARG_PERC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | MARG_PERC_CUR_BSLN_BUD ***** | |
| MAR_PC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | MAR_PC_ORG_BSLN_BUD ***** | |
| MAR_PC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | MAR_PC_CUR_BSLN_BUD ***** | |
| MAR_PC_TOTAL | VARCHAR2 | 1 | Yes | MAR_PC_TOTAL ***** | |
| MAR_PLC_ORG_BSLN_BUD | VARCHAR2 | 1 | Yes | MAR_PLC_ORG_BSLN_BUD ***** | |
| MAR_PLC_CUR_BSLN_BUD | VARCHAR2 | 1 | Yes | MAR_PLC_CUR_BSLN_BUD ***** | |
| MAR_PLC_TOTAL | VARCHAR2 | 1 | Yes | MAR_PLC_TOTAL ***** | |
| QTY_COMM_REQ | VARCHAR2 | 1 | Yes | QTY_COMM_REQ ***** | |
| QTY_COMM_PO | VARCHAR2 | 1 | Yes | QTY_COMM_PO ***** | |
| QTY_COMM_SUPP_INV | VARCHAR2 | 1 | Yes | QTY_COMM_SUPP_INV ***** | |
| QTY_COMM_EXT_COMM | VARCHAR2 | 1 | Yes | QTY_COMM_EXT_COMM ***** | |
| RC_COMM_REQ | VARCHAR2 | 1 | Yes | RC_COMM_REQ ***** | |
| RC_COMM_PO | VARCHAR2 | 1 | Yes | RC_COMM_PO ***** | |
| RC_COMM_SUPP_INV | VARCHAR2 | 1 | Yes | RC_COMM_SUPP_INV ***** | |
| RC_COMM_EXT_COMM | VARCHAR2 | 1 | Yes | RC_COMM_EXT_COMM ***** | |
| BC_COMM_REQ | VARCHAR2 | 1 | Yes | BC_COMM_REQ ***** | |
| BC_COMM_PO | VARCHAR2 | 1 | Yes | BC_COMM_PO ***** | |
| BC_COMM_SUPP_INV | VARCHAR2 | 1 | Yes | BC_COMM_SUPP_INV ***** | |
| BC_COMM_EXT_COMM | VARCHAR2 | 1 | Yes | BC_COMM_EXT_COMM ***** | |
| TOT_COMM_QTY | VARCHAR2 | 1 | Yes | TOT_COMM_QTY ***** | |
| ACT_AMT_QTY | VARCHAR2 | 1 | Yes | ACT_AMT_QTY ***** | |
| ETC_QTY | VARCHAR2 | 1 | Yes | ETC_QTY ***** | |
| EAC_QTY | VARCHAR2 | 1 | Yes | EAC_QTY ***** | |
| PREV_FRCST_QTY_ACT | VARCHAR2 | 1 | Yes | PREV_FRCST_QTY_ACT ***** | |
| PREV_FRCST_QTY_ETC | VARCHAR2 | 1 | Yes | PREV_FRCST_QTY_ETC ***** | |
| PREV_FRCST_QTY_EAC | VARCHAR2 | 1 | Yes | PREV_FRCST_QTY_EAC ***** | |
| TOT_COMM_RC | VARCHAR2 | 1 | Yes | TOT_COMM_RC ***** | |
| ACT_AMT_RC | VARCHAR2 | 1 | Yes | ACT_AMT_RC ***** | |
| ACT_AMT_BC | VARCHAR2 | 1 | Yes | ACT_AMT_BC ***** | |
| ETC_RC | VARCHAR2 | 1 | Yes | ETC_RC ***** | |
| EAC_RC | VARCHAR2 | 1 | Yes | EAC_RC ***** | |
| PREV_FRCST_RC_ACT | VARCHAR2 | 1 | Yes | PREV_FRCST_RC_ACT ***** | |
| PREV_FRCST_RC_ETC | VARCHAR2 | 1 | Yes | PREV_FRCST_RC_ETC ***** | |
| PREV_FRCST_RC_EAC | VARCHAR2 | 1 | Yes | PREV_FRCST_RC_EAC ***** | |
| TOT_COMM_BC | VARCHAR2 | 1 | Yes | TOT_COMM_BC ***** | |
| ETC_BC | VARCHAR2 | 1 | Yes | ETC_BC ***** | |
| EAC_BC | VARCHAR2 | 1 | Yes | EAC_BC ***** | |
| PREV_FRCST_BC_ACT | VARCHAR2 | 1 | Yes | PREV_FRCST_BC_ACT ***** | |
| PREV_FRCST_BC_ETC | VARCHAR2 | 1 | Yes | PREV_FRCST_BC_ETC ***** | |
| PREV_FRCST_BC_EAC | VARCHAR2 | 1 | Yes | PREV_FRCST_BC_EAC ***** | |
| RC_PC_TOT_COMM | VARCHAR2 | 1 | Yes | RC_PC_TOT_COMM ***** | |
| RC_PC_ACT_AMT | VARCHAR2 | 1 | Yes | RC_PC_ACT_AMT ***** | |
| RC_PC_ETC | VARCHAR2 | 1 | Yes | RC_PC_ETC ***** | |
| RC_PC_EAC | VARCHAR2 | 1 | Yes | RC_PC_EAC ***** | |
| RC_PLC_TOT_COMM | VARCHAR2 | 1 | Yes | RC_PLC_TOT_COMM ***** | |
| RC_PLC_ACT_AMT | VARCHAR2 | 1 | Yes | RC_PLC_ACT_AMT ***** | |
| RC_PLC_ETC | VARCHAR2 | 1 | Yes | RC_PLC_ETC ***** | |
| RC_PLC_EAC | VARCHAR2 | 1 | Yes | RC_PLC_EAC ***** | |
| BC_PC_TOT_COMM | VARCHAR2 | 1 | Yes | BC_PC_TOT_COMM ***** | |
| BC_PC_ACT_AMT | VARCHAR2 | 1 | Yes | BC_PC_ACT_AMT ***** | |
| BC_PC_ETC | VARCHAR2 | 1 | Yes | BC_PC_ETC ***** | |
| BC_PC_EAC | VARCHAR2 | 1 | Yes | BC_PC_EAC ***** | |
| BC_PLC_TOT_COMM | VARCHAR2 | 1 | Yes | BC_PLC_TOT_COMM ***** | |
| BC_PLC_ACT_AMT | VARCHAR2 | 1 | Yes | BC_PLC_ACT_AMT ***** | |
| BC_PLC_ETC | VARCHAR2 | 1 | Yes | BC_PLC_ETC ***** | |
| BC_PLC_EAC | VARCHAR2 | 1 | Yes | BC_PLC_EAC ***** | |
| RC_COMM_PC_REQ | VARCHAR2 | 1 | Yes | RC_COMM_PC_REQ ***** | |
| RC_COMM_PC_PO | VARCHAR2 | 1 | Yes | RC_COMM_PC_PO ***** | |
| RC_COMM_PC_SUP_INV | VARCHAR2 | 1 | Yes | RC_COMM_PC_SUP_INV ***** | |
| RC_COMM_PC_EXT_COMM | VARCHAR2 | 1 | Yes | RC_COMM_PC_EXT_COMM ***** | |
| RC_COMM_PLC_REQ | VARCHAR2 | 1 | Yes | RC_COMM_PLC_REQ ***** | |
| RC_COMM_PLC_PO | VARCHAR2 | 1 | Yes | RC_COMM_PLC_PO ***** | |
| RC_COMM_PLC_SUP_INV | VARCHAR2 | 1 | Yes | RC_COMM_PLC_SUP_INV ***** | |
| RC_COMM_PLC_EXT_COMM | VARCHAR2 | 1 | Yes | RC_COMM_PLC_EXT_COMM ***** | |
| BC_COMM_PC_REQ | VARCHAR2 | 1 | Yes | BC_COMM_PC_REQ ***** | |
| BC_COMM_PC_PO | VARCHAR2 | 1 | Yes | BC_COMM_PC_PO ***** | |
| BC_COMM_PC_SUP_INV | VARCHAR2 | 1 | Yes | BC_COMM_PC_SUP_INV ***** | |
| BC_COMM_PC_EXT_COMM | VARCHAR2 | 1 | Yes | BC_COMM_PC_EXT_COMM ***** | |
| BC_COMM_PLC_REQ | VARCHAR2 | 1 | Yes | BC_COMM_PLC_REQ ***** | |
| BC_COMM_PLC_PO | VARCHAR2 | 1 | Yes | BC_COMM_PLC_PO ***** | |
| BC_COMM_PLC_SUP_INV | VARCHAR2 | 1 | Yes | BC_COMM_PLC_SUP_INV ***** | |
| BC_COMM_PLC_EXT_COMM | VARCHAR2 | 1 | Yes | BC_COMM_PLC_EXT_COMM ***** | |
| PRV_FT_RC_PC_ACT_AMT | VARCHAR2 | 1 | Yes | PRV_FT_RC_PC_ACT_AMT ***** | |
| PRV_FRCST_RC_PC_ETC | VARCHAR2 | 1 | Yes | PRV_FRCST_RC_PC_ETC ***** | |
| PRV_FT_RC_PC_EAC | VARCHAR2 | 1 | Yes | PRV_FT_RC_PC_EAC ***** | |
| PRV_FT_RC_PLC_ACT_AMT | VARCHAR2 | 1 | Yes | PRV_FT_RC_PLC_ACT_AMT ***** | |
| PRV_FT_RC_PLC_ETC | VARCHAR2 | 1 | Yes | PRV_FT_RC_PLC_ETC ***** | |
| PRV_FT_RC_PLC_EAC | VARCHAR2 | 1 | Yes | PRV_FT_RC_PLC_EAC ***** | |
| PRV_FT_BC_PC_ACT_AMT | VARCHAR2 | 201 | Yes | PRV_FT_BC_PC_ACT_AMT ***** | |
| PRV_FT_BC_PC_ETC | VARCHAR2 | 1 | Yes | PRV_FT_BC_PC_ETC ***** | |
| PRV_FT_BC_PC_EAC | VARCHAR2 | 1 | Yes | PRV_FT_BC_PC_EAC ***** | |
| PRV_FT_BC_PLC_ACT_AMT | VARCHAR2 | 1 | Yes | PRV_FT_BC_PLC_ACT_AMT ***** | |
| PRV_FT_BC_PLC_ECT | VARCHAR2 | 1 | Yes | PRV_FT_BC_PLC_ECT ***** | |
| PRV_FT_BC_PLC_EAC | VARCHAR2 | 1 | Yes | PRV_FT_BC_PLC_EAC ***** | |
| REV_ACT_AMT | VARCHAR2 | 1 | Yes | REV_ACT_AMT ***** | |
| REV_ETC | VARCHAR2 | 1 | Yes | REV_ETC ***** | |
| REV_EAC | VARCHAR2 | 201 | Yes | REV_EAC ***** | |
| PRV_FCST_REV_ETC | VARCHAR2 | 1 | Yes | PRV_FCST_REV_ETC ***** | |
| PREV_FCST_REV_EAC | VARCHAR2 | 1 | Yes | PREV_FCST_REV_EAC ***** | |
| REV_PC_ETC | VARCHAR2 | 1 | Yes | REV_PC_ETC ***** | |
| REV_PC_EAC | VARCHAR2 | 1 | Yes | REV_PC_EAC ***** | |
| REV_PLC_ETC | VARCHAR2 | 1 | Yes | REV_PLC_ETC ***** | |
| REV_PLC_EAC | VARCHAR2 | 1 | Yes | REV_PLC_EAC ***** | |
| PRE_FCST_REV_PC_AA | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PC_AA ***** | |
| PRE_FCST_REV_PC_ETC | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PC_ETC ***** | |
| PRE_FCST_REV_PC_EAC | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PC_EAC ***** | |
| PRE_FCST_REV_PLC_AA | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PLC_AA ***** | |
| PRE_FCST_REV_PLC_ETC | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PLC_ETC ***** | |
| PRE_FCST_REV_PLC_EAC | VARCHAR2 | 1 | Yes | PRE_FCST_REV_PLC_EAC ***** | |
| MAR_TOT_COMM | VARCHAR2 | 1 | Yes | MAR_TOT_COMM ***** | |
| MAR_ACT_AMT | VARCHAR2 | 1 | Yes | MAR_ACT_AMT ***** | |
| MAR_ETC | VARCHAR2 | 1 | Yes | MAR_ETC ***** | |
| MAR_EAC | VARCHAR2 | 1 | Yes | MAR_EAC ***** | |
| PRV_FCST_MAR_ACT_AMT | VARCHAR2 | 1 | Yes | PRV_FCST_MAR_ACT_AMT ***** | |
| PRV_FCST_MAR_ETC | VARCHAR2 | 1 | Yes | PRV_FCST_MAR_ETC ***** | |
| PRV_FCST_MAR_EAC | VARCHAR2 | 1 | Yes | PRV_FCST_MAR_EAC ***** | |
| MAR_PER_TOT_COMM | VARCHAR2 | 1 | Yes | MAR_PER_TOT_COMM ***** | |
| MAR_PER_ACT_AMT | VARCHAR2 | 1 | Yes | MAR_PER_ACT_AMT ***** | |
| MAR_PER_ETC | VARCHAR2 | 1 | Yes | MAR_PER_ETC ***** | |
| MAR_PER_EAC | VARCHAR2 | 1 | Yes | MAR_PER_EAC ***** | |
| PRE_FCST_MAR_PER_AA | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PER_AA ***** | |
| PRE_FCST_MAR_PER_ETC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PER_ETC ***** | |
| PRE_FCST_MAR_PER_EAC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PER_EAC ***** | |
| MAR_PC_TOT_COMM | VARCHAR2 | 1 | Yes | MAR_PC_TOT_COMM ***** | |
| MAR_PC_ACT_AMT | VARCHAR2 | 1 | Yes | MAR_PC_ACT_AMT ***** | |
| MAR_PC_ETC | VARCHAR2 | 1 | Yes | MAR_PC_ETC ***** | |
| MAR_PC_EAC | VARCHAR2 | 1 | Yes | MAR_PC_EAC ***** | |
| MAR_PLC_TC | VARCHAR2 | 1 | Yes | MAR_PLC_TC ***** | |
| MAR_PLC_AA | VARCHAR2 | 1 | Yes | MAR_PLC_AA ***** | |
| MAR_PLC_ETC | VARCHAR2 | 1 | Yes | MAR_PLC_ETC ***** | |
| MAR_PLC_EAC | VARCHAR2 | 1 | Yes | MAR_PLC_EAC ***** | |
| PRE_FCST_MAR_PC_AA | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PC_AA ***** | |
| PRE_FCST_MAR_PC_ETC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PC_ETC ***** | |
| PRE_FCST_MAR_PC_EAC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PC_EAC ***** | |
| PRE_FCST_MAR_PLC_AA | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PLC_AA ***** | |
| PRE_FCST_MAR_PLC_ETC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PLC_ETC ***** | |
| PRE_FCST_MAR_PLC_EAC | VARCHAR2 | 1 | Yes | PRE_FCST_MAR_PLC_EAC ***** | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJO_EXCEL_EXPORT_OPTIONS | pjo_planning_options | PLANNING_OPTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_EXCEL_EXPORT_OPTIONS_U1 | Unique | Default | EXCEL_EXPORT_ID, ORA_SEED_SET1 |
| PJO_EXCEL_EXPORT_OPTIONS_U11 | Unique | Default | EXCEL_EXPORT_ID, ORA_SEED_SET2 |
| PJO_EXCEL_EXPORT_OPTIONS_U2 | Unique | Default | PLANNING_OPTION_ID, ORA_SEED_SET1 |
| PJO_EXCEL_EXPORT_OPTIONS_U21 | Unique | Default | PLANNING_OPTION_ID, ORA_SEED_SET2 |