DW_PJC_EXP_ITEMS_EN

This table stores the smallest categorized expenditure units charged to projects and tasks.

Details

Module: Project Costing

Key Columns

EXPENDITURE_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENDITURE_ITEM_ID NUMBER 38 0 True The system-generated number that uniquely identifies the expenditure item    
SOURCE_RECORD_ID VARCHAR2 64     System Generated    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 64     Subledger Linkage Header Entity ID    
ACCT_BURDENED_COST NUMBER       Burdened Cost in Functional Currency    
ACCT_CURRENCY_CODE VARCHAR2 16     Account currency code of the transaction    
ACCT_EXCHANGE_RATE NUMBER       Functional Exchange Rate for the Transaction    
ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER       Rounding limit for imported transaction    
ACCT_RATE_DATE DATE       Functional Rate date for the Transaction    
ACCT_RATE_DATE_TYPE VARCHAR2 16     ACCT_RATE_DATE_TYPE    
ACCT_RATE_TYPE VARCHAR2 32     Functional rate type for the transaction    
ACCT_RAW_COST NUMBER       Raw cost in Functional Currency    
ACCT_TP_EXCHANGE_RATE NUMBER       Exchange rate used to convert the transfer price from the transaction currency to the provider functional currency    
ACCT_TP_RATE_DATE DATE       Rate date used to convert the transfer price from the transaction currency to the functional currency.    
ACCT_TP_RATE_TYPE VARCHAR2 32     Rate type used to convert the transfer price from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price    
ACCT_TRANSFER_PRICE NUMBER       Transfer price in functional currency of the provider operating unit    
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER 38 0   The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item.    
ADJUSTMENT_STATUS VARCHAR2 32     ADJUSTMENT_STATUS    
ADJUSTMENT_TYPE VARCHAR2 256     Adjustment Type Code    
ATTRIBUTE_CATEGORY VARCHAR2 32     Descriptive Flexfield: structure definition of the user descriptive flexfield.    
BILL_BY_COST_CODE VARCHAR2 32     BILL_BY_COST_CODE    
BILL_HOLD_FLAG VARCHAR2 16     Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'.    
BILL_TRANS_CURRENCY_CODE VARCHAR2 16     Bill transaction currency code for the expenditure item for accrued revenue and bill amounts    
BILLABLE_FLAG VARCHAR2 16     Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls.    
BURDEN_COST_RATE NUMBER       The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ).    
BURDEN_SUM_DEST_RUN_ID NUMBER 38 0   Burden summarization run id. Id will identify all the expenditure items created by burden component summarization process. This is used to identify all the Cost distribution lines summarized together to create expenditure item    
CAPITAL_EVENT_ID NUMBER 38 0   Capital Event Identifier to which the expenditure item is assigned.    
CAPITALIZABLE_FLAG VARCHAR2 16     A separate flag for capitalizable as separate from billable, since capital projects can now be billed.    
CAPITALIZATION_DIST_FLAG VARCHAR2 16     CAPITALIZATION_DIST_FLAG    
CC_BL_DISTRIBUTED_CODE VARCHAR2 16     Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process    
CC_CROSS_CHARGE_CODE VARCHAR2 16     Indicates the method of cross charge processing that will be or has been performed on an Expenditure Item.    
CC_CROSS_CHARGE_TYPE VARCHAR2 16     Cross Charge Type    
CC_MARKUP_BASE_CODE VARCHAR2 16     Audit column.to help derive how transfer price wsa calculated. Basis used to calculate the transfer price.    
CC_PROCESSED_FLAG VARCHAR2 16     CC_PROCESSED_FLAG    
CC_PRVDR_COST_RECLASS_CODE VARCHAR2 16     Indicates if the cost for the expenditure item is reclassified for intercompany billing    
CC_PRVDR_ORGANIZATION_ID NUMBER 38 0   Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overridden by the client extension to derive provider organization    
CC_RECVR_ORGANIZATION_ID NUMBER 38 0   Identifier of the receiver organization. This may be different than the project organization, if it is overridden by the client extension to derive receiver organization    
CC_REJECTION_CODE VARCHAR2 32     Code indicating rejection reason encountered while processing cross charge    
CONTEXT_CATEGORY VARCHAR2 64     CONTEXT_CATEGORY    
CONTRACT_ID NUMBER 38 0   Unique Identifier of the contract.    
CONTRACT_LINE_ID NUMBER 38 0   Unique Identifier of the contract line.    
CONVERTED_FLAG VARCHAR2 16     Flag set to 'Y' if the item is converted. If the item is converted, no adjustments to the item's revenue or cost are allowed. Adjustments allowed are 'Edit Comments', 'Bill Hold', 'One-Time Billing Hold', and 'Release Bill Hold'    
COST_DIST_WARNING_CODE VARCHAR2 32     During funds check if the transaction passes in advisory mode then this column will be updated with the apropriate warning.    
COST_IND_COMPILED_SET_ID NUMBER 38 0   The identifier of the compiled set that is used to calculate the cost amount of the expenditure item    
COST_JOB_ID NUMBER 38 0   Costing Job ID    
COST_SCHEDULE_ID NUMBER 38 0   Cost rate schedule identifier.    
COST_SCHEDULE_LINE_ID NUMBER 38 0   Cost rate schedule line identifier.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
DENOM_BURDENED_COST NUMBER       Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost    
DENOM_CURRENCY_CODE VARCHAR2 16     Transaction Currency code of the transaction    
DENOM_RAW_COST NUMBER       The total raw cost of the expenditure item in transaction currency Raw cost = (quantity * cost rate) This value should always equal the sum of the items raw cost distribution lines    
DENOM_TP_CURRENCY_CODE VARCHAR2 16     Transaction currency code of the transfer price    
DENOM_TRANSFER_PRICE NUMBER       Transfer price in the transaction currency    
DOC_ENTRY_ID NUMBER 38 0   Projects-relates sub-categorication of the document type that is creating this transaction.    
DOC_REF_ID1 VARCHAR2 512     Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number.    
DOC_REF_ID2 VARCHAR2 512     Source Document Reference 2. In the case of sales order issue transactions, this is the sales order number.    
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 32     The supplier cost interface process uses this column to indicate the transaction type of the distribution. Valid values are as follows: Payables, Purchasing, or Receiving.    
DOCUMENT_ID NUMBER 38 0   Projects-related categorization of the document type that is creating this transaction.    
DOCUMENT_TYPE VARCHAR2 32     The supplier cost interface process uses this column to indicate the transaction type. Valid values are as follows: Payables, Purchasing, or Receiving.    
EXP_GROUP_ID NUMBER 38 0   EXP_GROUP_ID    
EXPENDITURE_ENDING_DATE DATE       EXPENDITURE_ENDING_DATE    
EXPENDITURE_ITEM_DATE DATE       The date on which the work occurred    
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0   EXPENDITURE_ORGANIZATION_ID for the Exp item which holds the value NVL(OVERRIDE_TO_ORGANIZATION_ID,INCURRED_BY_ORGANIZATION_ID)    
EXPENDITURE_TYPE_ID NUMBER 38 0   Identifier of the expenditure type    
EXT_OVRD_BILL_RATE NUMBER       The rate at which the expenditure item is to be billed on an external or interproject contract.    
EXT_OVRD_BILL_RATE_CURR_CODE VARCHAR2 16     The currency of the external bill rate for the expenditure item.    
EXT_OVRD_BILL_RATE_SOURCE_NAME VARCHAR2 256     The name of the external source from where the external bill rate originates.    
EXT_OVRD_BILL_RATE_SOURCE_REF VARCHAR2 32     The unique identifier of the external bill rate in the external source.    
HCM_ASSIGNMENT_ID NUMBER 38 0   HCM_ASSIGNMENT_ID    
HISTORICAL_FLAG VARCHAR2 16     Historical Flag    
IC_BILL_BY_COST_CODE VARCHAR2 16     IC_BILL_BY_COST_CODE    
IC_BILL_HOLD_FLAG VARCHAR2 16     IC_BILL_HOLD_FLAG    
IC_BILLABLE_FLAG VARCHAR2 16     Flag that indicates if transaction is eligible for Intercompany billing.    
IC_INVOICED_FLAG VARCHAR2 16     IC_INVOICED_FLAG    
IC_INVOICED_PERCENTAGE NUMBER       IC_INVOICED_PERCENTAGE    
IC_LEDGER_CURR_INV_AMT NUMBER       IC_LEDGER_CURR_INV_AMT    
IC_LEDGER_CURR_REV_AMT NUMBER       IC_LEDGER_CURR_REV_AMT    
IC_OVRD_BILL_RATE NUMBER       The rate at which the expenditure item is to be billed on an itercompany contract.    
IC_OVRD_BILL_RATE_CURR_CODE VARCHAR2 16     The currency of the intercompany bill rate for the expenditure item.    
IC_OVRD_BILL_RATE_SOURCE_NAME VARCHAR2 256     The name of the external source from where the intercompany bill rate originates.    
IC_OVRD_BILL_RATE_SOURCE_REF VARCHAR2 32     The unique identifier of the intercompany bill rate in the external source.    
IC_PROJECT_CURR_INV_AMT NUMBER       IC_PROJECT_CURR_INV_AMT    
IC_PROJECT_CURR_REV_AMT NUMBER       IC_PROJECT_CURR_REV_AMT    
IC_RBS_ELEMENT_ID NUMBER 38 0   IC_RBS_ELEMENT_ID    
IC_REV_RECOG_PERCENTAGE NUMBER       IC_REV_RECOG_PERCENTAGE    
IC_REVENUE_HOLD_FLAG VARCHAR2 16     IC_REVENUE_HOLD_FLAG    
IC_REVENUE_RECOGNIZED_FLAG VARCHAR2 16     IC_REVENUE_RECOGNIZED_FLAG    
IC_TP_AMT_TYPE_CODE VARCHAR2 32     IC_TP_AMT_TYPE_CODE    
IC_TP_BASE_CODE VARCHAR2 32     IC_TP_BASE_CODE    
INCURRED_BY_ORGANIZATION_ID NUMBER 38 0   INCURRED_BY_ORGANIZATION_ID    
INCURRED_BY_PERSON_ID NUMBER 38 0   INCURRED_BY_PERSON_ID    
INV_EXCLUDE_FLAG VARCHAR2 16     INV_EXCLUDE_FLAG    
INVENTORY_ITEM_ID NUMBER 38 0   Inventory item identifier    
INVOICE_EXCEPTION_FLAG VARCHAR2 16     INVOICE_EXCEPTION_FLAG    
INVOICED_FLAG VARCHAR2 16     INVOICED_FLAG    
INVOICED_PERCENTAGE NUMBER       INVOICED_PERCENTAGE    
JOB_DEFINITION_NAME VARCHAR2 128     Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.    
JOB_DEFINITION_PACKAGE VARCHAR2 128     Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.    
LABOR_COST_MULTIPLIER_NAME VARCHAR2 32     The labor cost multiplier specified for a premium labor expenditure item in order to determine the premium labor cost. Cost = (cost rate*quantity*LCM). This is populated by the timecard entry forms or the Overtime Calculation program    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATE_LOGIN VARCHAR2 64     Who column: indicates the session login associated to the user who last updated the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
LEDGER_CURR_INV_AMT NUMBER       LEDGER_CURR_INV_AMT    
LEDGER_CURR_REV_AMT NUMBER       LEDGER_CURR_REV_AMT    
MANUAL_FLAG VARCHAR2 16     MANUAL_FLAG    
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 16     Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice    
NON_LABOR_RESOURCE_ID NUMBER 38 0   Identifier of the non labor resource.    
NON_LABOR_RESOURCE_ORG_ID NUMBER 38 0   The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items    
OBJECT_VERSION_NUMBER NUMBER 38 0   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.    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
ORIG_TRANSACTION_REFERENCE VARCHAR2 128     Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import.    
ORIGINAL_DIST_ID NUMBER 38 0   Source Transaction Distribution Reference which is the identifier used to retrieve the account for the inventory and receipt costs imported into Project Costing. For example, in the case of miscellaneous issue to project transactions, this is the offset account identifier.    
ORIGINAL_HEADER_ID NUMBER 38 0   ORIGINAL_HEADER_ID    
ORIGINAL_LINE_NUMBER NUMBER 38 0   ORIGINAL_LINE_NUMBER    
OVERRIDE_TO_ORGANIZATION_ID NUMBER 38 0   The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables    
PARENT_DIST_ID NUMBER 38 0   PARENT_DIST_ID    
PARENT_HEADER_ID NUMBER 38 0   PARENT_HEADER_ID    
PARENT_LINE_NUMBER NUMBER 38 0   PARENT_LINE_NUMBER    
PERIOD_ACCRUAL_FLAG VARCHAR2 16     PERIOD_ACCRUAL_FLAG    
PERSON_JOB_ID NUMBER 38 0   The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts.    
PERSON_TYPE VARCHAR2 32     Identifies the type of person - employee or contingent worker.    
PROJACCT_TRANSFER_PRICE NUMBER       Transfer price in the functional currency of cross charged project (receiver operating unit)    
PROJECT_BURDENED_COST NUMBER       Burdened cost in project currency.    
PROJECT_CURR_INV_AMT NUMBER       PROJECT_CURR_INV_AMT    
PROJECT_CURR_REV_AMT NUMBER       PROJECT_CURR_REV_AMT    
PROJECT_CURRENCY_CODE VARCHAR2 16     Project Currency Code of the Transaction    
PROJECT_EXCHANGE_RATE NUMBER       Project Exchange Rate for Transaction    
PROJECT_ID NUMBER 38 0   The project_id of the event that the expenditure item is FIFO marked by    
PROJECT_RATE_DATE DATE       Project Rate date for the Transaction    
PROJECT_RATE_DATE_TYPE VARCHAR2 16     PROJECT_RATE_DATE_TYPE    
PROJECT_RATE_TYPE VARCHAR2 32     Project Rate Type for the Transaction    
PROJECT_RAW_COST NUMBER       Raw cost in project currency.    
PROJECT_TP_EXCHANGE_RATE NUMBER       Exchange rate used to convert transfer price from the transaction currency to the project currency.    
PROJECT_TP_RATE_DATE DATE       Rate date used to convert transfer price from the transaction currency to the project currency.    
PROJECT_TP_RATE_TYPE VARCHAR2 32     Rate type used to convert transfer price from the transaction currency to the project currency.    
PROJECT_TRANSFER_PRICE NUMBER       Transfer price in project currency.    
PROJECT_UNIT_ID NUMBER 38 0   PROJECT_UNIT_ID    
PROJFUNC_BURDENED_COST NUMBER       The burden cost in project functional currency    
PROJFUNC_COST_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_COST_RATE_DATE DATE       Rate date used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_COST_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_CURRENCY_CODE VARCHAR2 16     Project functional currency code.    
PROJFUNC_RATE_DATE_TYPE VARCHAR2 16     PROJFUNC_RATE_DATE_TYPE    
PROJFUNC_RAW_COST NUMBER       Raw cost in project Functional Currency    
PROJFUNC_TP_EXCHANGE_RATE NUMBER       Exchange rate used to convert transfer price from the transaction currency to the project functional currency.    
PROJFUNC_TP_RATE_DATE DATE       Rate date used to convert transfer price from the transaction currency to the project functional currency.    
PROJFUNC_TP_RATE_TYPE VARCHAR2 32     Rate type used to convert transfer price from the transaction currency to the project functional currency.    
PROJFUNC_TRANSFER_PRICE NUMBER       Transfer price in project functional currency.    
PRVDR_ACCRUAL_DATE DATE       Provider operating unit accounting date for transactions included in a reversing expenditure batch.    
PRVDR_LEGAL_ENTITY_ID NUMBER 38 0   PRVDR_LEGAL_ENTITY_ID    
QUANTITY NUMBER       The number of units of the work performed    
RAW_COST_RATE NUMBER       The raw cost rate used to cost the item    
RBS_ELEMENT_ID NUMBER 38 0   RBS_ELEMENT_ID    
RECEIPT_CURRENCY_AMOUNT NUMBER       Receipt currency amount of the transaction    
RECEIPT_CURRENCY_CODE VARCHAR2 16     Receipt currency code of the transaction    
RECEIPT_EXCHANGE_RATE NUMBER       Receipt exchange rate for the transaction    
RECVR_ACCRUAL_DATE DATE       Receiver operating unit accounting date for transactions included in a reversing expenditure batch.    
RECVR_ORG_ID NUMBER 38 0   Receiver Operating Unit Identifier    
REFERENCE_ID1 NUMBER 38 0   Source Document Reference Identifier 1. In the case of sales order issue transactions, this is the fulfillment line ID.    
REFERENCE_ID2 NUMBER 38 0   Source Document Reference Identifier 2. In the case of work order resource transactions, this is the labor resource instance record identifier.    
REFERENCE_ID3 NUMBER 38 0   Source Document Reference Identifier 3. In the case of work order resource transactions, this is the equipment resource instance record identifier.    
REQUEST_ID NUMBER 38 0   Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.    
REV_EXCLUDE_FLAG VARCHAR2 16     REV_EXCLUDE_FLAG    
REVENUE_EXCEPTION_FLAG VARCHAR2 16     REVENUE_EXCEPTION_FLAG    
REVENUE_HOLD_FLAG VARCHAR2 16     REVENUE_HOLD_FLAG    
REVENUE_RECOG_PERCENTAGE NUMBER       REVENUE_RECOG_PERCENTAGE    
REVENUE_RECOGNIZED_FLAG VARCHAR2 16     REVENUE_RECOGNIZED_FLAG    
SOURCE_EXPENDITURE_ITEM_ID NUMBER 38 0   Only populated for related items created in PA's Labor Extensions. This number is the identifier of the source expenditure item to which this item is related    
SRC_SYSTEM_LINKAGE_FUNCTION VARCHAR2 32     The system linkage of the source expenditure items which were summarized to create separate burden transaction.    
SYSTEM_LINKAGE_FUNCTION VARCHAR2 16     The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type    
TASK_ID NUMBER 38 0   The identifier of the task to which the expenditure item is charged    
TP_AMT_TYPE_CODE VARCHAR2 32     Cross charge classification.    
TP_BASE_AMOUNT NUMBER       Audit column. Base amount used to derive the transfer price, held in transfer price transaction currency    
TP_BILL_MARKUP_PERCENTAGE NUMBER       Audit column. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule    
TP_BILL_RATE NUMBER       Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule    
TP_IND_COMPILED_SET_ID NUMBER 38 0   Identifier of the compiled set used to calculate the Transfer Price using a burden schedule    
TP_JOB_ID NUMBER 38 0   Borrowed/Lent Job ID    
TP_RULE_PERCENTAGE NUMBER       Audit column. Percentage applied to the calculated transfer price from the rule definition    
TP_SCHEDULE_LINE_PERCENTAGE NUMBER       Audit column. Percentage applied to the calculated transfer price from the schedule line    
TRANSACTION_SOURCE_ID NUMBER 38 0   TRANSACTION_SOURCE_ID    
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER 38 0   The identifier of the expenditure item from which this expenditure item originated. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task    
TXN_ACCUM_HEADER_ID NUMBER 38 0   TXN_ACCUM_HEADER_ID    
UNIT_OF_MEASURE VARCHAR2 32     Base unit of measure    
VENDOR_ID NUMBER 38 0   This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the    
WORK_TYPE_ID NUMBER 38 0   Identifier for a work type assigned to the transaction.    
BUDGETARY_CONTROL_VAL_STATUS VARCHAR2 32     Budgetary control validation status at the transaction level.    
CMR_ACCOUNTING_EVENT_ID NUMBER 38 0   Receiving Accounting Event ID    
CMR_EVENT_COST_ID NUMBER 38 0   Receiving Cost Event ID    
CMR_EXP_ADJUSTMENT_FLAG VARCHAR2 16     Receiving Cost Adjustment Type Code    
CMR_TRANSACTION_TYPE_CODE VARCHAR2 64     Receiving Transaction Type Code    
CREATION_SOURCE VARCHAR2 32     The source from which the cost transaction was created, for example, FBDI, ADFdi, and so on.    
DOC_REF_ID3 VARCHAR2 512     Source Document Reference 3.    
DOC_REF_ID4 VARCHAR2 128     Source Document Reference 4.    
DOC_REF_ID5 VARCHAR2 128     Source Document Reference 5.    
EXPENDITURE_COMMENT VARCHAR2 256     The free text comment entered for an expenditure item to further describe work done.    
FUNDING_ALLOCATION_ID NUMBER 38 0   Specifies the name of the project funding source.    
INV_ASSET_CATEGORY_ID NUMBER 38 0   Asset Category ID    
LD_ORIG_TRANSACTION_REFERENCE VARCHAR2 128     Unique identifier of this record in the originating payroll system.    
ORIGINAL_DIST_ID2 NUMBER 38 0   Peer Source Transaction Distribution Reference which is the identifier used to retrieve the counterpart account of the source transaction distribution reference. For example, in the case of miscellaneous issue to project transactions, this is the inventory valuation account identifier.    
PO_CATEGORY_ID NUMBER 38 0   PO Category ID    
REFERENCE_ID4 NUMBER 38 0   Source Document Reference Identifier 4.    
REFERENCE_ID5 NUMBER 38 0   Source Document Reference Identifier 5.    
XCC_BTC_STATUS VARCHAR2 16     Budgetary control distribution status indicating if the burden transaction cost process will pick up a separate line burden transaction.