PJO_PRICING_INTG_DEBUG

This table is a debug table to check the input and output from pricing engine.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CURRENT_RUN_ID	NUMBER		18	Yes	CURRENT_RUN_ID *****	Active
SOURCE_TRANSACTION_ID	NUMBER		18	Yes	SOURCE_TRANSACTION_ID *****	Active
PROJECT_TYPE_ID	NUMBER		18	Yes	PROJECT_TYPE_ID *****	Active
PROJECT_ID	NUMBER		18	Yes	PROJECT_ID *****	Active
TASK_ID	NUMBER		18	Yes	TASK_ID *****	Active
INCURRED_BY_ORG_ID	NUMBER		18		INCURRED_BY_ORG_ID *****	Active
OVERRIDE_TO_ORG_ID	NUMBER		18		OVERRIDE_TO_ORG_ID *****	Active
EXPENDITURE_BU_ID	NUMBER		18		EXPENDITURE_BU_ID *****	Active
EXPENDITURE_TYPE_ID	NUMBER		18		EXPENDITURE_TYPE_ID *****	Active
TRANSACTION_DATE	DATE			Yes	TRANSACTION_DATE *****	Active
PERSON_ID	NUMBER		18		PERSON_ID *****	Active
PERSON_JOB_ID	NUMBER		18		PERSON_JOB_ID *****	Active
NL_RES_ORGANIZATION_ID	NUMBER		18		NL_RES_ORGANIZATION_ID *****	Active
NON_LABOR_RESOURCE_ID	NUMBER		18		NON_LABOR_RESOURCE_ID *****	Active
QUANTITY	NUMBER				QUANTITY *****	Active
RESOURCE_CLASS_TYPE	VARCHAR2	30			RESOURCE_CLASS_TYPE *****	Active
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	20			SYSTEM_LINKAGE_FUNCTION *****	Active
CALC_RAW_COST_FLAG	VARCHAR2	1		Yes	CALC_RAW_COST_FLAG *****	Active
CALC_IND_COST_FLAG	VARCHAR2	1		Yes	CALC_IND_COST_FLAG *****	Active
CALC_REVENUE_FLAG	VARCHAR2	1		Yes	CALC_REVENUE_FLAG *****	Active
COST_CALCULATION_STATUS	VARCHAR2	1		Yes	COST_CALCULATION_STATUS *****	Active
REV_CALCULATION_STATUS	VARCHAR2	1		Yes	REV_CALCULATION_STATUS *****	Active
COST_REJECTION_CODE	VARCHAR2	30			COST_REJECTION_CODE *****	Active
COST_REJECTION_TYPE	VARCHAR2	1			COST_REJECTION_TYPE *****	Active
REVENUE_REJECTION_CODE	VARCHAR2	30			REVENUE_REJECTION_CODE *****	Active
REVENUE_REJECTION_TYPE	VARCHAR2	1			REVENUE_REJECTION_TYPE *****	Active
PROJ_MAPPED_JOB_ID	NUMBER		18		PROJ_MAPPED_JOB_ID *****	Active
COST_RATE_MULTIPLIER	NUMBER				COST_RATE_MULTIPLIER *****	Active
COMP_DETAILS_ID	NUMBER		18		COMP_DETAILS_ID *****	Active
ORG_SCHEDULE_RULE_ID	NUMBER		18		ORG_SCHEDULE_RULE_ID *****	Active
OT_PROJECT_ID	NUMBER		18		OT_PROJECT_ID *****	Active
OT_TASK_ID	NUMBER		18		OT_TASK_ID *****	Active
COST_RATE_SCH_TYPE	VARCHAR2	30			COST_RATE_SCH_TYPE *****	Active
RATE_SCHEDULE_NAME	VARCHAR2	30			RATE_SCHEDULE_NAME *****	Active
RATE_SCHEDULE_TYPE	VARCHAR2	30			RATE_SCHEDULE_TYPE *****	Active
COMP_RULE_SET_NAME	VARCHAR2	30			COMP_RULE_SET_NAME *****	Active
COSTING_METHOD	VARCHAR2	30			COSTING_METHOD *****	Active
OVERRIDE_TYPE	VARCHAR2	30			OVERRIDE_TYPE *****	Active
RATE_SCHEDULE_ID	NUMBER		18		RATE_SCHEDULE_ID *****	Active
RATE_SCHEDULE_LINE_ID	NUMBER		18		RATE_SCHEDULE_LINE_ID *****	Active
DENOM_RAW_COST	NUMBER				DENOM_RAW_COST *****	Active
RAW_COST_RATE	NUMBER				RAW_COST_RATE *****	Active
EXP_TYPE_COST_RATE_FLAG	VARCHAR2	1			EXP_TYPE_COST_RATE_FLAG *****	Active
COST_MARKUP_PERCNT	NUMBER				COST_MARKUP_PERCNT *****	Active
IND_AMT_DISPLAY_METHOD	VARCHAR2	1			IND_AMT_DISPLAY_METHOD *****	Active
COST_IND_RATE_SCH_ID	NUMBER		18		COST_IND_RATE_SCH_ID *****	Active
IND_SCH_NAME	VARCHAR2	30			IND_SCH_NAME *****	Active
IND_RATE_SCH_TYPE	VARCHAR2	1			IND_RATE_SCH_TYPE *****	Active
COST_IND_SCH_FIXED_DATE	DATE				COST_IND_SCH_FIXED_DATE *****	Active
IND_STRUCTURE_NAME	VARCHAR2	30			IND_STRUCTURE_NAME *****	Active
IND_RATE_SCH_REVISION_ID	NUMBER		18		IND_RATE_SCH_REVISION_ID *****	Active
COST_BASE	VARCHAR2	30			COST_BASE *****	Active
IND_COMPILED_SET_ID	NUMBER		18		IND_COMPILED_SET_ID *****	Active
COMPILED_MULTIPLIER	NUMBER				COMPILED_MULTIPLIER *****	Active
IND_COST_RATE	NUMBER				IND_COST_RATE *****	Active
DENOM_BURDENED_COST	NUMBER				DENOM_BURDENED_COST *****	Active
PJO_TRANSACTION_TYPE	VARCHAR2	30			PJO_TRANSACTION_TYPE *****	Active
RATE_BASED_FLAG	VARCHAR2	1			RATE_BASED_FLAG *****	Active
PLANNING_CURRENCY_CODE	VARCHAR2	15			PLANNING_CURRENCY_CODE *****	Active
OVERRIDE_CURRENCY_CODE	VARCHAR2	15			OVERRIDE_CURRENCY_CODE *****	Active
PLANNING_RAW_COST	NUMBER				PLANNING_RAW_COST *****	Active
PLANNING_RAW_COST_RATE	NUMBER				PLANNING_RAW_COST_RATE *****	Active
PLANNING_BURDENED_COST	NUMBER				PLANNING_BURDENED_COST *****	Active
PLANNING_IND_COST_RATE	NUMBER				PLANNING_IND_COST_RATE *****	Active
PLANNING_REVENUE_AMOUNT	NUMBER				PLANNING_REVENUE_AMOUNT *****	Active
PLANNING_REVENUE_RATE	NUMBER				PLANNING_REVENUE_RATE *****	Active
UNIT_OF_MEASURE	VARCHAR2	30			UNIT_OF_MEASURE *****	Active
RES_ASSIGNMENT_ID	NUMBER		18		RES_ASSIGNMENT_ID *****	Active
RES_CLASS_MARKUP_PERCNT	NUMBER				RES_CLASS_MARKUP_PERCNT *****	Active
TXN_COST_FOR_REVENUE	NUMBER				TXN_COST_FOR_REVENUE *****	Active
REVENUE_AMOUNT	NUMBER				REVENUE_AMOUNT *****	Active
REVENUE_MARKUP_PERCNT	NUMBER				REVENUE_MARKUP_PERCNT *****	Active
REVENUE_AMOUNT_RATE	NUMBER				REVENUE_AMOUNT_RATE *****	Active
REVENUE_CURRENCY_CODE	VARCHAR2	15			REVENUE_CURRENCY_CODE *****	Active
DENOM_CURRENCY_CODE	VARCHAR2	15			DENOM_CURRENCY_CODE *****	Active
ACCT_CURRENCY_CODE	VARCHAR2	15			ACCT_CURRENCY_CODE *****	Active
ACCT_RATE_DATE	DATE				ACCT_RATE_DATE *****	Active
ACCT_RATE_TYPE	VARCHAR2	30			ACCT_RATE_TYPE *****	Active
ACCT_RAW_COST	NUMBER				ACCT_RAW_COST *****	Active
ACCT_BURDENED_COST	NUMBER				ACCT_BURDENED_COST *****	Active
ACCT_COST_EXCH_RATE	NUMBER				ACCT_COST_EXCH_RATE *****	Active
PROJECT_CURRENCY_CODE	VARCHAR2	15			PROJECT_CURRENCY_CODE *****	Active
PROJECT_RATE_DATE	DATE				PROJECT_RATE_DATE *****	Active
PROJECT_REV_RATE_DATE	DATE				PROJECT_REV_RATE_DATE *****	Active
PROJECT_RATE_TYPE	VARCHAR2	30			PROJECT_RATE_TYPE *****	Active
PROJECT_REV_RATE_TYPE	VARCHAR2	30			PROJECT_REV_RATE_TYPE *****	Active
PROJECT_RAW_COST	NUMBER				PROJECT_RAW_COST *****	Active
PROJECT_BURDENED_COST	NUMBER				PROJECT_BURDENED_COST *****	Active
PROJECT_REV_AMOUNT	NUMBER				PROJECT_REV_AMOUNT *****	Active
PROJECT_COST_EXCH_RATE	NUMBER				PROJECT_COST_EXCH_RATE *****	Active
PROJECT_REV_EXCH_RATE	NUMBER				PROJECT_REV_EXCH_RATE *****	Active
PROJFUNC_CURRENCY_CODE	VARCHAR2	15			PROJFUNC_CURRENCY_CODE *****	Active
PROJFUNC_RATE_DATE	DATE				PROJFUNC_RATE_DATE *****	Active
PROJFUNC_REV_RATE_DATE	DATE				PROJFUNC_REV_RATE_DATE *****	Active
PROJFUNC_RATE_TYPE	VARCHAR2	30			PROJFUNC_RATE_TYPE *****	Active
PROJFUNC_REV_RATE_TYPE	VARCHAR2	30			PROJFUNC_REV_RATE_TYPE *****	Active
PROJFUNC_RAW_COST	NUMBER				PROJFUNC_RAW_COST *****	Active
PROJFUNC_REV_AMOUNT	NUMBER				PROJFUNC_REV_AMOUNT *****	Active
PROJFUNC_BURDENED_COST	NUMBER				PROJFUNC_BURDENED_COST *****	Active
PROJFUNC_COST_EXCH_RATE	NUMBER				PROJFUNC_COST_EXCH_RATE *****	Active
PROJFUNC_REV_EXCH_RATE	NUMBER				PROJFUNC_REV_EXCH_RATE *****	Active
INVENTORY_ITEM_ID	NUMBER		18		INVENTORY_ITEM_ID *****	Active
MFC_COST_TYPE_ID	NUMBER		18		MFC_COST_TYPE_ID *****	Active
MFC_COST_SOURCE	VARCHAR2	30			MFC_COST_SOURCE *****	Active
ITEM_CATEGORY_ID	NUMBER		18		ITEM_CATEGORY_ID *****	Active
PROCESS_GROUP_ID	NUMBER		18		PROCESS_GROUP_ID *****	Active
BURDEN_COST_FLAG	VARCHAR2	1			BURDEN_COST_FLAG *****	Active
LABOR_MULTIPLIER_NAME	VARCHAR2	30			LABOR_MULTIPLIER_NAME *****	Active
ACCT_EXCH_ROUNDING_LIMIT	NUMBER				ACCT_EXCH_ROUNDING_LIMIT *****	Active
MSG_TOKEN_NAME1	VARCHAR2	30			MSG_TOKEN_NAME1 *****	Active
MSG_TOKEN_NAME2	VARCHAR2	30			MSG_TOKEN_NAME2 *****	Active
MSG_TOKEN_NAME3	VARCHAR2	30			MSG_TOKEN_NAME3 *****	Active
MSG_TOKEN_VALUE1	VARCHAR2	30			MSG_TOKEN_VALUE1 *****	Active
MSG_TOKEN_VALUE2	VARCHAR2	30			MSG_TOKEN_VALUE2 *****	Active
MSG_TOKEN_VALUE3	VARCHAR2	30			MSG_TOKEN_VALUE3 *****	Active
GL_DATE	DATE				GL_DATE *****	Active
INPUT_OUTPUT_MODE	VARCHAR2	30			INPUT_OUTPUT_MODE *****	Active
PLANNING_RATE_DATE	DATE				Planning rate date.
PLANNING_RATE_TYPE	VARCHAR2	30			Planning rate type.
REV_RATE_SCHEDULE_ID	NUMBER		18		Identifier of Revenue Rate Schedule
IMPORT_COST_ACC_FLAG	VARCHAR2	3			Indicator of a transaction is externally accounted or not.
PLANNING_EXCH_RATE	NUMBER				Planning exchange rate. This column is used to convert the cost/revenue amount into planning currency.
PROJECT_ROLE_ID	NUMBER		18		Unique identifier of the project role.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJO_PRICING_INTG_DEBUG	pjf_projects_all_b	PROJECT_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PJO_PRICING_INTG_DEBUG_N2	Non Unique	FUSION_TS_TX_IDX	CURRENT_RUN_ID, INPUT_OUTPUT_MODE	Active
PJO_PRICING_INTG_DEBUG_N3	Non Unique	FUSION_TS_TX_IDX	CURRENT_RUN_ID, SOURCE_TRANSACTION_ID	Active
PJO_PRICING_INTG_DEBUG_N4	Non Unique	FUSION_TS_TX_IDX	CURRENT_RUN_ID, RES_ASSIGNMENT_ID	Active