CMR_PJC_EXP_DST_PO_TXNS_INF_GT
This table stores all pending expense destination purchass order transactions associated with Project attributes
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
ACCOUNTING_EVENT_ID | NUMBER | 18 | Accounting Event Identifier and maps to {CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID} | |
EVENT_COST_ID | NUMBER | 18 | Event Cost Identifier and references cmr_rcv_event_costs table. | |
CMR_SUB_LEDGER_ID | NUMBER | 18 | Receipt accounting distribution Identifier and references to cmr_rcv_distributions. | |
BUSINESS_UNIT_ID | NUMBER | 18 | Profit center business Unit Identifier of accounted transactions. | |
EVENT_TYPE_CODE | VARCHAR2 | 40 | Event Type Code identifier and mapped column in XLA. | |
DOCUMENT_ENTRY_CODE | VARCHAR2 | 50 | Event Cost Source or event cost source type | |
FUND_RESERVATION_STATUS | VARCHAR2 | 30 | Fund reservation status returned by budgetary control engine. | |
SOURCE_DOC_QTY | NUMBER | accounted quantity in Source document unit of measure | ||
SOURCE_DOC_UOM_CODE | VARCHAR2 | 25 | Source Document unit of measure code. This is Purchase Order unit of measure. | |
LEDGER_RAW_COST | NUMBER | Accounted amount in Ledger currency | ||
LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Ledger Currency Code of purchase order transaction. | |
TRANSACTION_RAW_COST | NUMBER | Transaction unit cost in transaction currency | ||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code in Purchase Order currency. | |
RAW_COST_RATE | NUMBER | Accounted unit amount in ledger currency | ||
CURRENCY_CONVERSION_DATE | DATE | Indicates currency conversion date from PO currency to Ledger Currency. | ||
CURRENCY_CONVERSION_RATE | NUMBER | Indicates currency conversion rate from PO currency to Ledger Currency. | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 40 | Indicates currency conversion type from PO currency to Ledger Currency. | |
GL_DATE | DATE | Accounted Date on purchase order transactions. | ||
TRANSACTION_DATE | DATE | Purchase order put away and expense adjustment transaction's date. | ||
SUPPLIER_ID | NUMBER | 18 | Vendor Identifier - {References PO_VENDORS.vendor_id} | |
INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization identifier defined on Purchase Order Schedule. | |
TXN_SOURCE_DOC_TYPE | VARCHAR2 | 40 | Transaction Source Document Type. Value will be RCV | |
TRANSACTION_NUMBER | VARCHAR2 | 50 | Stores receipt number for purchase order transactions and PO number or invoice number for expense adjustment transaction | |
INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | |
ITEM_DESCRIPTION | VARCHAR2 | 240 | Item Description defined on Purchase Order line. | |
ACCOUNTED_FLAG | VARCHAR2 | 1 | Accounting Status of the Purchase Order transactions. | |
ORIGINAL_TXN_REFERENCE | NUMBER | 18 | Transaction Original reference identifier and passed to Projects. | |
SOURCE_TXN_DIST_REF | NUMBER | 18 | Source Transaction Distribution Reference. Maps to CMR_RCV_DSITRIBUTIONS table. | |
SOURCE_TXN_PARENT_HEADER_REF | NUMBER | 18 | Purchase Order header Identifier for purchasing flows | |
SOURCE_TXN_PARENT_LINE_REF | NUMBER | 18 | Source transaction parent line reference - Purchase order line identifier | |
SOURCE_TXN_PARENT_DIST_REF | NUMBER | 18 | Source Transaction parent dist reference - Purchase Order Distribution Identifier | |
PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order schedule identifier | |
REVERSED_ORIGINAL_TXN_REF | NUMBER | 18 | Parent Receiving Transaction Identifier | |
PARENT_TRANSACTION_ID | NUMBER | 18 | Parent transaction identifier of purchase order put away transactions. | |
SOURCE_TXN_HEADER_REF | NUMBER | 18 | Receiving transaction identifier | |
FULL_RETURN_FLAG | VARCHAR2 | 1 | Full transaction return Flag - OBSOLTED Column and not used. | |
EXP_RETRO_PRICE_FLAG | VARCHAR2 | 1 | Indicates if expense adjustment event belongs to price change or not | |
BU_NAME | VARCHAR2 | 240 | Business Unit Name - OBSOLTED Column and not used. | |
EXPENDITURE_ORG_NAME | VARCHAR2 | 240 | Expenditure Organization Name defined on Purchase Orders. | |
RETURN_INDICATOR_FLAG | VARCHAR2 | 1 | Return Flag Indicator - OBSOLOTED column and not used by projects | |
PJC_PROJECT_ID | NUMBER | 18 | Project Identifier defined purchase order document. | |
PJC_TASK_ID | NUMBER | 18 | Project Task identifier defined purchase order document. | |
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | project Expenditure Type Identifier defined purchase order document. | |
PJC_EXPENDITURE_ITEM_DATE | DATE | Project Expenditure Item Date defined purchase order document. | ||
PJC_ORGANIZATION_ID | NUMBER | 18 | Project organization identifier defined on purchase order | |
PJC_WORK_TYPE_ID | NUMBER | 18 | project Work Type Identifier defined on purchase order. | |
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Project Billable Flag defined purchase order document. | |
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | project Capitalization Flag defined purchase order document | |
PJC_CONTRACT_ID | NUMBER | 18 | project contract identifier defined purchase order document | |
PJC_CONTRACT_LINE_ID | NUMBER | 18 | project contact line identifier defined purchase order document | |
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Project funding allocation identifier defined purchase order document | |
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Project Context category defined purchase order document | |
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Project Reserved Attribute 2 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Project Reserved Attribute 2 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Project Reserved Attribute 3 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Project Reserved Attribute 4 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Project Reserved Attribute 5 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Project Reserved Attribute 6 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Project Reserved Attribute 7 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Project Reserved Attribute 8 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Project Reserved Attribute 9 defined purchase order document | |
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Project Reserved Attribute 10 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Project user defined Attribute 1 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Project user defined Attribute 2 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Project user defined Attribute 3 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Project user defined Attribute 4 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Project user defined Attribute 5 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Project user defined Attribute 6 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Project user defined Attribute 7 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Project user defined Attribute 8 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Project user defined Attribute 9 defined purchase order document | |
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Project user defined Attribute 10 defined purchase order document |