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 |