PJC_EXP_ITEMS_ALL

ProjectsUsed in 8 subject areas98 reporting columns

Projects Costing (PJC) — transaction table (rows scoped across all operating units).

Primary key: EXPENDITURE_ITEM_ID

Columns

Column	Key	In reports	Description (inferred)
ACCT_BURDENED_COST		●	Account burdened cost.
ACCT_EXCHANGE_RATE		●	Account exchange rate.
ACCT_EXCHANGE_ROUNDING_LIMIT		●	Account exchange rounding limit.
ACCT_RATE_DATE		●	Account rate date.
ACCT_RATE_DATE_TYPE		●	Type of account rate date.
ACCT_RATE_TYPE		●	Type of account rate.
ACCT_RAW_COST		●	Account raw cost.
ACCT_TP_EXCHANGE_RATE		●	Account tp exchange rate.
ACCT_TP_RATE_DATE		●	Account tp rate date.
ACCT_TP_RATE_TYPE		●	Type of account tp rate.
ACCT_TRANSFER_PRICE		●	Account transfer price.
ADJUSTED_EXPENDITURE_ITEM_ID		●	Identifier for the adjusted expenditure item.
ADJUSTMENT_STATUS		●	Status of the adjustment.
ADJUSTMENT_TYPE		●	Type of adjustment.
BILLABLE_FLAG		●	Indicator (Y/N) for the billable.
BILL_HOLD_FLAG		●	Indicator (Y/N) for the bill hold.
BURDEN_COST_RATE		●	Burden cost rate.
CAPITALIZABLE_FLAG		●	Indicator (Y/N) for the capitalizable.
CAPITALIZATION_DIST_FLAG		●	Indicator (Y/N) for the capitalization distribution.
CC_BL_DISTRIBUTED_CODE		●	Code identifying the cc bl distributed.
CC_CROSS_CHARGE_CODE		●	Code identifying the cc cross charge.
CC_CROSS_CHARGE_TYPE		●	Type of cc cross charge.
CC_MARKUP_BASE_CODE		●	Code identifying the cc markup base.
CONVERTED_FLAG		●	Indicator (Y/N) for the converted.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
DENOM_BURDENED_COST		●	Denom burdened cost.
DENOM_CURRENCY_CODE		●	Currency code for the denom.
DENOM_RAW_COST		●	Denom raw cost.
DENOM_TRANSFER_PRICE		●	Denom transfer price.
EXPENDITURE_ENDING_DATE		●	Expenditure ending date.
EXPENDITURE_ITEM_DATE		●	Expenditure item date.
EXPENDITURE_ITEM_ID	PK	●	Identifier for the expenditure item.
IC_BILLABLE_FLAG		●	Indicator (Y/N) for the ic billable.
IC_BILL_BY_COST_CODE		●	Code identifying the ic bill by cost.
IC_BILL_HOLD_FLAG		●	Indicator (Y/N) for the ic bill hold.
IC_INVOICED_FLAG		●	Indicator (Y/N) for the ic invoiced.
IC_INVOICED_PERCENTAGE		●	Ic invoiced percentage.
IC_REVENUE_HOLD_FLAG		●	Indicator (Y/N) for the ic revenue hold.
IC_REVENUE_RECOGNIZED_FLAG		●	Indicator (Y/N) for the ic revenue recognized.
IC_REV_RECOG_PERCENTAGE		●	Ic rev recog percentage.
IC_TP_AMT_TYPE_CODE		●	Code identifying the ic tp amount type.
IC_TP_BASE_CODE		●	Code identifying the ic tp base.
INVOICED_FLAG		●	Indicator (Y/N) for the invoiced.
INVOICED_PERCENTAGE		●	Invoiced percentage.
INVOICE_EXCEPTION_FLAG		●	Indicator (Y/N) for the invoice exception.
INV_EXCLUDE_FLAG		●	Indicator (Y/N) for the inventory exclude.
LABOR_COST_MULTIPLIER_NAME		●	Name of the labor cost multiplier.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN		●	Session login of the user who last updated the row.
LEDGER_CURR_INV_AMT		●	Ledger currency inventory amount.
LEDGER_CURR_REV_AMT		●	Ledger currency rev amount.
NET_ZERO_ADJUSTMENT_FLAG		●	Indicator (Y/N) for the net zero adjustment.
ORIGINAL_DIST_ID		●	Identifier for the original distribution.
ORIGINAL_HEADER_ID		●	Identifier for the original header.
ORIGINAL_LINE_NUMBER		●	Original line number.
ORIG_TRANSACTION_REFERENCE		●	Orig transaction reference.
PARENT_DIST_ID		●	Identifier for the parent distribution.
PARENT_HEADER_ID		●	Identifier for the parent header.
PARENT_LINE_NUMBER		●	Parent line number.
PERIOD_ACCRUAL_FLAG		●	Indicator (Y/N) for the period accrual.
PERSON_TYPE		●	Type of person.
PROJECT_BURDENED_COST		●	Project burdened cost.
PROJECT_CURR_INV_AMT		●	Project currency inventory amount.
PROJECT_CURR_REV_AMT		●	Project currency rev amount.
PROJECT_EXCHANGE_RATE		●	Project exchange rate.
PROJECT_RATE_DATE		●	Project rate date.
PROJECT_RATE_DATE_TYPE		●	Type of project rate date.
PROJECT_RATE_TYPE		●	Type of project rate.
PROJECT_RAW_COST		●	Project raw cost.
PROJECT_TP_EXCHANGE_RATE		●	Project tp exchange rate.
PROJECT_TP_RATE_DATE		●	Project tp rate date.
PROJECT_TP_RATE_TYPE		●	Type of project tp rate.
PROJFUNC_BURDENED_COST		●	Projfunc burdened cost.
PROJFUNC_COST_EXCHANGE_RATE		●	Projfunc cost exchange rate.
PROJFUNC_COST_RATE_DATE		●	Projfunc cost rate date.
PROJFUNC_COST_RATE_TYPE		●	Type of projfunc cost rate.
PROJFUNC_RATE_DATE_TYPE		●	Type of projfunc rate date.
PROJFUNC_RAW_COST		●	Projfunc raw cost.
PROJFUNC_TRANSFER_PRICE		●	Projfunc transfer price.
PRVDR_ACCRUAL_DATE		●	Prvdr accrual date.
QUANTITY		●	Quantity.
RAW_COST_RATE		●	Raw cost rate.
RECVR_ACCRUAL_DATE		●	Recvr accrual date.
REVENUE_EXCEPTION_FLAG		●	Indicator (Y/N) for the revenue exception.
REVENUE_HOLD_FLAG		●	Indicator (Y/N) for the revenue hold.
REVENUE_RECOGNIZED_FLAG		●	Indicator (Y/N) for the revenue recognized.
REVENUE_RECOG_PERCENTAGE		●	Revenue recog percentage.
REV_EXCLUDE_FLAG		●	Indicator (Y/N) for the rev exclude.
SOURCE_EXPENDITURE_ITEM_ID		●	Identifier for the source expenditure item.
TP_AMT_TYPE_CODE		●	Code identifying the tp amount type.
TP_BILL_MARKUP_PERCENTAGE		●	Tp bill markup percentage.
TP_BILL_RATE		●	Tp bill rate.
TP_RULE_PERCENTAGE		●	Tp rule percentage.
TP_SCHEDULE_LINE_PERCENTAGE		●	Tp schedule line percentage.
TRANSFERRED_FROM_EXP_ITEM_ID		●	Identifier for the transferred from exp item.
UNIT_OF_MEASURE		●	Unit of measure.

5 reports read from this table

Change a column here and these are the reports that move with it — the blast radius for any change to PJC_EXP_ITEMS_ALL.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for PJC_EXP_ITEMS_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us