1. Tables and Views for SCM
  2. CST_PJC_TXN_XFACE_GT

CST_PJC_TXN_XFACE_GT

This is the GT table you use for importing transactions from external sources into Oracle Projects.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_SOURCE_ID NUMBER 18 Identifier of the Transaction Source. Active
TRANSACTION_SOURCE_CODE VARCHAR2 30 Transaction Source Code. Active
ACCOUNTING_STATUS_CODE VARCHAR2 5 The status of the distribution line as the cost information is transferred to another application. Active
DOCUMENT_ID NUMBER 18 Identifier for the Projects-related categorization of the document type that is creating this transaction. Active
DOCUMENT_NAME VARCHAR2 240 Projects-related categorization of the document type that is creating this transaction. Active
DOC_ENTRY_ID NUMBER 18 Identifier of Projects-related categorization of the document type that is creating this transaction. Active
PARENT_REVERSAL_ID NUMBER 18 Parent Reversal Identifier. Active
REVERSAL_FLAG VARCHAR2 1 Flag that indicates if the distribution line is reversed by another distribution line. Active
PERSON_JOB_ID NUMBER 18 Person Job Identifier. Active
DOC_ENTRY_NAME VARCHAR2 240 Name of the Document Entry. Active
EXPENDITURE_TYPE_ID NUMBER 18 Identifier of the Expenditure Type. Active
BURDEN_SUM_DEST_RUN_ID NUMBER 18 Burden Component Summarization Destination Run Identifier. Active
PROJFUNC_BURDENED_COST NUMBER Amount of the burdened cost in project functional currency. Active
PROJFUNC_RAW_COST NUMBER Raw cost amount in project functional currency. Active
PRVDR_ACCRUAL_DATE DATE Provider Accrual Date. Active
RECVR_ACCRUAL_DATE DATE Receiver Accrual Date. Active
TXN_ACCUM_HEADER_ID NUMBER 18 Accum Header Identifier. Active
COST_IND_COMPILED_SET_ID NUMBER 18 The system-generated number that uniquely identifies the costing compiled set. Active
LABOR_COST_MULTIPLIER_NAME VARCHAR2 20 Name of the labor cost multiplier. Active
BATCH_NAME VARCHAR2 200 User-entered name for a grouping of expenditures in the interface table. For one transaction source, all items with the same BATCH_NAME are imported into Oracle Projects in the same expenditure group, if processed together. Active
EXPENDITURE_ITEM_DATE DATE Date on which the transaction occurred. Active
EXPENDITURE_ENDING_DATE DATE The date of the last day in the expenditure week. PA uses this value to group transactions into expenditures. All items must be dated on or before their EXPENDITURE_ENDING_DATE. Active
PRVDR_PA_DATE DATE Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date. Active
PRVDR_PA_PERIOD_NAME VARCHAR2 20 Name used to determine the correct project accounting period in the provider operating unit. Active
RECVR_PA_DATE DATE Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date. Active
RECVR_PA_PERIOD_NAME VARCHAR2 20 Name used to determine the correct project accounting period in the receiver operating unit. Active
GL_DATE DATE GL_DATE to be copied to PA_COST_DISTRIBUTION_LINES.GL_DATE for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source. This date is used to derive the PA_DATE on CDLs. Active
PRVDR_GL_PERIOD_NAME VARCHAR2 20 Name of the correct general ledger accounting period in the provider operating unit. Active
RECVR_GL_DATE DATE Date used to determine the correct general ledger accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. Active
RECVR_GL_PERIOD_NAME VARCHAR2 20 Name of the correct general ledger accounting period in the receiver operating unit. Active
NON_LABOR_RESOURCE_ID NUMBER 18 Identifier of the Non-labor resource utilized when incurring the transaction charge. Active
NON_LABOR_RESOURCE_ORG_ID NUMBER 18 Non-Labor Resource Organization Identifier. Active
QUANTITY NUMBER Yes Number of units for the transaction. This column is defined with a precision of '2' in order to maintain consistency with PA's expenditure entry forms which round expenditure item quantities to '2' decimal places when saved to the database. Active
EXPENDITURE_COMMENT VARCHAR2 240 User-entered free text comment to describe the transaction. Active
PROCESS_GROUP_ID NUMBER 18 Process Group Identifier. Active
EI_CREATION_FLAG VARCHAR2 1 Expenditure Item Creation Flag. Active
TRANSACTION_STATUS_CODE VARCHAR2 2 System-defined status of the transaction as it is loaded into PA. Active
ORIG_TRANSACTION_REFERENCE VARCHAR2 120 User-entered value used to identify the transaction in an external system from which the imported item originated. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
RAW_COST_RATE NUMBER The cost rate used to calculate the transaction's raw cost amount. PA loads this cost rate for transactions identified by a 'Costed' transaction source. PA performs no validation on this value, and it is used only for reporting purposes. Active
INTERFACE_ID NUMBER 18 System-generated number that identifies all the transactions processed by a given concurrent request. Active
UNMATCHED_NEGATIVE_TXN_FLAG VARCHAR2 1 Flag used to identify certain adjustments (transactions with negative quantities) as summary-level adjustments for which there is no single matching item in PA to reverse. When this flag is 'Y', PA does not execute the matching value. Active
EXPENDITURE_ITEM_ID NUMBER 18 The system-generated number that uniquely identifies the expenditure item. Active
CDL_LINE_NUM NUMBER 18 Line Number of the Cost Distribution Line. Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
CONVERTED_FLAG VARCHAR2 1 Flag that indicates if the transaction is converted from legacy applications and should be marked as converted. Transactions marked as converted have restrictions around what type of adjustments can be performed on them. Active
BURDENED_COST_RATE NUMBER Burden cost rate used to calculate burden cost. Active
SYSTEM_LINKAGE VARCHAR2 30 System Linkage or Expenditure Type Class of the transaction. Active
USER_TRANSACTION_SOURCE VARCHAR2 240 The descriptive name of the transaction source. Active
RECEIPT_CURRENCY_AMOUNT NUMBER Receipt currency amount of the transaction. Active
RECEIPT_CURRENCY_CODE VARCHAR2 15 Receipt currency code of the transaction. Active
RECEIPT_EXCHANGE_RATE NUMBER Receipt exchange rate for the transaction. Active
COMP_DETAILS_ID NUMBER 18 The identifier of the labor costing override. Active
ORG_LABOR_SCH_RULE_ID NUMBER 18 Organization Labor Schedule Rule Identifier. Active
DENOM_CURRENCY_CODE VARCHAR2 15 Transaction currency code of the transaction Active
DENOM_RAW_COST NUMBER Raw cost in Transaction currency. Active
DENOM_BURDENED_COST NUMBER Burdened cost in Transaction currency. Active
ACCT_CURRENCY_CODE VARCHAR2 15 Functional Currency Code. Active
ACCT_RATE_DATE DATE Functional conversion rate date for the transaction. Active
ACCT_RATE_TYPE VARCHAR2 30 Functional conversion rate type for the transaction. Active
ACCT_EXCHANGE_RATE NUMBER Functional exchange rate for the transaction. Active
ACCT_RAW_COST NUMBER Raw cost in functional currency. Active
ACCT_BURDENED_COST NUMBER Burdened cost in Functional currency. Active
ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER Rounding limit for imported transactions. Active
PROJECT_CURRENCY_CODE VARCHAR2 15 Project currency code of the transaction. Active
PROJECT_RATE_DATE DATE Project rate date for the transaction. Active
PROJECT_RATE_TYPE VARCHAR2 30 Project rate type for the transaction. Active
PROJECT_EXCHANGE_RATE NUMBER Project exchange rate for the transaction. Active
ORIG_EXP_TXN_REFERENCE1 VARCHAR2 60 Expenditure Identifier in external system(system reference). For Oracle Payables, invoice ID should be populated into this field. Active
ORIG_EXP_TXN_REFERENCE2 VARCHAR2 60 Additional column provided to group transactions into expenditures. Active
ORIG_EXP_TXN_REFERENCE3 VARCHAR2 60 Additional column provided to group transactions into expenditures. Active
ORIG_USER_EXP_TXN_REFERENCE VARCHAR2 60 Expenditure Identifier in external system(user reference). For Oracle Payables, invoice number should be populated into this field. Active
REVERSED_ORIG_TXN_REFERENCE VARCHAR2 120 Value used to identify the transaction being reversed in the external system from which the imported item originated. Active
BILLABLE_FLAG VARCHAR2 1 Flag that indicates if the item can accrue revenue. Active
CAPITALIZABLE_FLAG VARCHAR2 1 Flag that indicates if a project-related item is eligible for capitalization. Active
PROJFUNC_CURRENCY_CODE VARCHAR2 15 Project functional currency code. Active
PROJFUNC_COST_RATE_TYPE VARCHAR2 30 Rate type used to convert costs from transaction currency to project functional currency. Active
PROJFUNC_COST_RATE_DATE DATE Rate date used to convert costs from the transaction currency to the project currency. Active
PROJFUNC_COST_EXCHANGE_RATE NUMBER Exchange rate used to convert costs from the transaction currency to the project functional currency. Active
PROJECT_RAW_COST NUMBER Raw cost in project currency. Active
PROJECT_BURDENED_COST NUMBER Burdened cost in project currency. Active
HCM_ASSIGNMENT_ID NUMBER 18 The HCM assignment for which the transaction was created. Active
WORK_TYPE_ID NUMBER 18 Work Type Identifier. Active
ACCRUAL_FLAG VARCHAR2 1 Indicates whether the imported transaction is automatically reversed in the next accounting period. Active
PROJECT_ID NUMBER 18 Project Identifier. Active
TASK_ID NUMBER 18 Task Identifier. Active
PERSON_ID NUMBER 18 Person Identifier. Active
VENDOR_ID NUMBER 18 Vendor Identifier. Active
ORGANIZATION_ID NUMBER 18 Organization Identifier. Active
OVERRIDE_TO_ORGANIZATION_ID NUMBER 18 Override to Organization Identifier. Active
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier. Active
UNIT_OF_MEASURE VARCHAR2 30 Base unit of measure. Active
PERSON_TYPE VARCHAR2 30 Type of person who incurred the expenditure. Active
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER 18 The supplier cost interface process uses this column to create an adjusting expenditure item copies the value to the PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID column. Active
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER 18 Transferred From Expenditure Item Identifier. Active
SOURCE_EXP_ITEM_ID NUMBER 18 Source Expenditure Item Identifier. Active
DOCUMENT_TYPE VARCHAR2 30 The supplier cost interface process uses this column to indicate the transaction type and copies the value to the PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_TYPE column. Valid values are as follows: Payables, Purchasing, or Receiving. Active
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 30 The supplier cost interface process uses this column to indicate the transaction type of the distribution and copies the value to the PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE column. Valid values are as follows: Payables, Purchase. Active
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Indicates whether items are accrued upon receipt. Active
SI_ASSETS_ADDITION_FLAG VARCHAR2 1 This column indicates the status of the cost distribution line in relation to Oracle Assets. It only applies to supplier cost expenditure items. Valid values are as follows : Y - The distribution line is interfaced to Oracle Assets. N - The d Active
SC_XFER_CODE VARCHAR2 1 The supplier cost interface process uses this column to indicate the GL transfer status code in another application for the distribution line. Active
ADJUSTED_TXN_INTERFACE_ID NUMBER 18 The supplier cost interface process uses this column to indicate the transaction interface identifier of an adjusted expenditure item. Active
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 1 The supplier cost interface process uses this column to indicate that the item is a net-zero expenditure item. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CONTEXT_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. Active
RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE10 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE3 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE4 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE5 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE6 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE7 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE8 VARCHAR2 150 Reserved for Projects - future functionality. Active
RESERVED_ATTRIBUTE9 VARCHAR2 150 Reserved for Projects - future functionality. Active
USER_DEF_ATTRIBUTE1 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE2 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE3 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE4 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE5 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE6 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE7 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE8 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE9 VARCHAR2 150 User defined attributes for Cost Collection. Active
USER_DEF_ATTRIBUTE10 VARCHAR2 150 User defined attributes for Cost Collection. Active
PROJECT_UNIT_ID NUMBER 18 Project Unit Identifier. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ACCT_EVENT_ID NUMBER 18 Identifier of Accounting Event. Active
ACCT_SOURCE_CODE VARCHAR2 10 Code used to identify accounting transactions, which are not migrated to SLA. Active
ALLOW_CC_FLAG VARCHAR2 1 This flag determines if Cross Charge processing is allowed or not.For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. For external third party import, this flag should be populated while interfacing the data into PATI. Active
CDL_LINE_NUM_REVERSED NUMBER 18 For a reversing CDL the adjustment API should populate it with the line number of the original CDL. (Add to XDF). Active
COST_SCHEDULE_ID NUMBER 18 Cost Rate Schedule Identifier. Active
COST_SCHEDULE_LINE_ID NUMBER 18 Cost Rate Schedule Line Identifier. Active
DERIVATIONS_FLAG VARCHAR2 1 Flag that indicates if Derivations module of the Import and Process was successful for the transaction. Active
ERROR_GROUP VARCHAR2 30 Indicates the processing stage that resulted in the error. Values correspond to the lookup type PJC_TI_STAGE (1.Pre-Processing Client Extension 2.Post-Processing Client Extension 3.Validation 4.Derivation 5.Additional Transaction Creation 6.Costing 7.Accounting 8.Commitment Control). Active
ORIG_HISTORICAL_FLAG VARCHAR2 1 For a reversing EI it should be populated with the historical_flag of the original EI. For a reversing cdl it should be populated with the historical_flag on the same EI. This has to be done by the Adjustment API while creating the adjustment records in PATI. Active
VALIDATIONS_FLAG VARCHAR2 1 Flag that indicates if Validations module of the Import and Process was successful for the transaction. Active
COST_JOB_ID NUMBER 18 Cost Job Identifier. Active
RECVR_ORG_ID NUMBER 18 Receiver Organization Identifier. Active
CDL_LINE_TYPE VARCHAR2 1 The type of the cost distribution line. Active
CDL_PARENT_LINE_NUM NUMBER 18 Cost Distribution Line Parent Link Number. Active
ACCT_RATE_DATE_TYPE VARCHAR2 4 Provider Ledger Currency Conversion Date Type. Active
PROJECT_RATE_DATE_TYPE VARCHAR2 4 Project Currency Conversion Date Type. Active
PROJFUNC_RATE_DATE_TYPE VARCHAR2 4 Receiver Ledger Currency Conversion Date Type. Active
RAW_COST_CR_CCID NUMBER 18 The ledger account that receives the credit amount for the raw cost of the cost distribution. Active
RAW_COST_DR_CCID NUMBER 18 The ledger account that receives the debit amount for the raw cost of the cost distribution. Active
RAW_LINE_NUM_REVERSED NUMBER 18 The distribution line number that is reversed by this distribution line. Active
ORIGINAL_HEADER_ID NUMBER 18 Header level value that aids in locating the source transaction in the source application. Active
ORIGINAL_LINE_NUMBER NUMBER 18 Line level value that aids in locating the source transaction in the source application. Active
ORIGINAL_DIST_ID NUMBER 18 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. Active
PARENT_HEADER_ID NUMBER 18 Header level value that aids in locating the parent of the source transaction in the source application. Active
PARENT_LINE_NUMBER NUMBER 18 Line level value that aids in locating the parent of the source transaction in the source application. Active
PARENT_DIST_ID NUMBER 18 Distribution level value that aids in locating the parent of the source transaction in the source application. Active
BATCH_DESCRIPTION VARCHAR2 250 Batch description for grouping of expenditures. Active
BATCH_ENDING_DATE DATE Batch ending date for grouping of expenditures. Active
BILL_HOLD_FLAG VARCHAR2 1 Flag that indicates if item will be held from invoicing. Upon entry, it is nullable. Active
REVENUE_HOLD_FLAG VARCHAR2 1 This column indicates whether the item will be on hold for revenue processing or not. Upon entry, it is nullable. Active
CONTRACT_ID NUMBER 18 Unique identifier of the contract. Active
CONTRACT_LINE_ID NUMBER 18 Unique identifier of the contract Line. Active
FUNDING_ALLOCATION_ID NUMBER 18 Specifies the name of the project funding override. Active
PRBS_ELEMENT_ID NUMBER 18 Planning resource breakdown structure element identifier of the planning resource that the transaction maps to. Active
PRBS_TXN_ACCUM_HEADER_ID NUMBER 18 Unique identifier for the transaction attributes that are used for mapping and deriving a planning resource breakdown structure element. Active
BUDGET_CCID NUMBER 18 Budget account used for budget checking raw cost. Active
BUDGETARY_CONTROL_VAL_STATUS VARCHAR2 30 Budgetary control validation status at the distribution level. Active
DATA_SET_ID NUMBER 18 Identifies data for a particular budgetary control request. Active
BUDGET_PERIOD_ID NUMBER 18 Identifier of Budget Period for which the funding is made. Active
PLANNED_FLAG VARCHAR2 1 Identifier whether the transaction amount is palnned or not. Active
BACKING_HEADER_ID1 NUMBER 18 Backing Header Identifier One. Active
BACKING_DIST_ID1 NUMBER 18 Backing Distribution Identifier One. Active
BACKING_DIST_ID2 NUMBER 18 Backing Distribution Identifier Two. Active
BACKING_DIST_ID3 NUMBER 18 Backing Distribution Identifier Three. Active
BACKING_AMOUNT NUMBER Backing Distribution Amount. Active
RATE_OVERRIDE_ID NUMBER 18 Identifier of rate_override_id from pjf_rate_overrides table. Active
CMR_ACCOUNTING_EVENT_ID NUMBER 18 Receiving Accounting Event Identifier. Active
CMR_EVENT_COST_ID NUMBER 18 Receiving Cost Event Identifier. Active
CMR_EXP_ADJUSTMENT_FLAG VARCHAR2 1 Receiving Cost Adjustment Type Code. Active
INV_ASSET_CATEGORY_ID NUMBER 18 Asset Category Identifier. Active
PO_CATEGORY_ID NUMBER 18 Purchase Order Category Identifier. Active
CMR_TRANSACTION_TYPE_CODE VARCHAR2 40 Receiving Transaction Type Code. Active
CMR_TRANSACTION_DATE DATE The date when the receiving transaction was created. Active
ORIGINAL_DIST_ID2 NUMBER 18 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. Active
DOC_REF_ID1 VARCHAR2 240 Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number. Active
DOC_REF_ID2 VARCHAR2 240 Source Document Reference 2. In the case of sales order issue transactions, this is the sales order number. Active
DOC_REF_ID3 VARCHAR2 240 Source Document Reference 3.
DOC_REF_ID4 VARCHAR2 120 Source Document Reference 4.
DOC_REF_ID5 VARCHAR2 120 Source Document Reference 5.
REFERENCE_ID1 NUMBER 18 Source Document Reference Identifier 1. In the case of sales order issue transactions, this is the fulfillment line ID. Active
REFERENCE_ID2 NUMBER 18 Source Document Reference Identifier 2. In the case of work order resource transactions, this is the labor resource instance record identifier.
REFERENCE_ID3 NUMBER 18 Source Document Reference Identifier 3. In the case of work order resource transactions, this is the equipment resource instance record identifier.
REFERENCE_ID4 NUMBER 18 Source Document Reference Identifier 4.
REFERENCE_ID5 NUMBER 18 Source Document Reference Identifier 5.
INVENTORY_ORG_ID NUMBER 18 Indicates The Inventory Org To Which The Item Belongs. Active
DISTRIBUTION_ID NUMBER 18 Identifier to the source transaction distribution header record in cst_cost_distributions table.
BASE_TXN_TYPE_ID NUMBER 18 Base Transaction type identifier.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Source transaction source type identifier.
BASE_TXN_ACTION_ID NUMBER 18 Source transaction action identifier.
SOURCE_TXN_QUANTITY NUMBER Source document transaction quantity.
BACKING_HEADER_ID2 NUMBER 18 Backing Header Identifier Two stores the purchase order header identifier.
BACKING_DIST_ID4 NUMBER 18 Backing Distribution Identifier Four stores purchase order line location identifier.
BACKING_LEDGER_CURR_AMT NUMBER Backing amount in ledger currency.
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier.
EVENT_TYPE_CODE VARCHAR2 30 Identifies the SLA event type as defined in cst cost distributions.
BC_FLAG VARCHAR2 1 Budgetary control enabled flag. Y - Budget Control enabled transaction. N/NULL - Not enabled.
EA_FLAG VARCHAR2 1 Encumbrance Accounting Flag indicator. Y - encumbrance enabled transaction. X - Might be applicable or not. N/NULL - Not enabled.