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. |