CST_PJC_INVENTORY_TXNS_INF_GT
This table contains the inventory transactions information sent to projects via cost collection services.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PJC_ORGANIZATION_ID | NUMBER | 18 | PJC_ORGANIZATION_ID | |
| DISTRIBUTION_LINE_ID | NUMBER | 18 | DISTRIBUTION_LINE_ID | |
| EXPENDITURE_ORG_NAME | VARCHAR2 | 240 | EXPENDITURE_ORG_NAME | |
| PJC_EXPENDITURE_ITEM_DATE | DATE | Expenditure item Date | ||
| PJC_PROJECT_ID | NUMBER | 18 | project identifier | |
| PJC_TASK_ID | NUMBER | 18 | PJC_TASK_ID | |
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure Type | |
| PJC_WORK_TYPE_ID | NUMBER | 18 | Project work type identifier | |
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Billable flag | |
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Capitalization Flag | |
| PRIMARY_QUANTITY | NUMBER | PRIMARY_QUANTITY | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | primary unit of measure code | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier | |
| INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization Identifier | |
| TRANSACTION_DATE | DATE | Transaction Date | ||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 40 | Transaction Source Document type. Values are INV for misc inventory transactions | |
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | Transaction Source Document Number | |
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | Transaction reference document number | |
| ACCOUNTED_FLAG | VARCHAR2 | 1 | Accounted flag | |
| LEDGER_AMOUNT | NUMBER | Accounted amount in ledger currency | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Ledger currency code | |
| UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | 1 | Unmatched negative flag | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Costing Inventory transaction identifier | |
| LEDGER_RAW_COST | NUMBER | ledgerraw cost | ||
| RAW_COST_RATE | NUMBER | Raw cost rate | ||
| SRC_TXN_DIST_REFERENCE | NUMBER | 18 | Source transaction distribution reference | |
| SRC_TXN_HEADER_REFERENCE | NUMBER | 18 | Source transaction header reference | |
| SRC_TXN_PARENT_HDR_REF | NUMBER | 18 | source transaction parent header reference | |
| ORIGINAL_TXN_REFERENCE | NUMBER | 18 | Original Transaction Reference | |
| COST_ELEMENT_TYPE | VARCHAR2 | 30 | Cost Element Type | |
| COST_TRANSACTION_UOM | VARCHAR2 | 30 | Costing UnitOfMeasure Code | |
| ACCOUNTING_DATE | DATE | Accounting Date | ||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | 30 | Transaction Currency Code | |
| BASE_CURRENCY_CODE | VARCHAR2 | 30 | Base currency code | |
| BUSINESS_UNIT_NAME | VARCHAR2 | 240 | Business unit name | |
| PJC_CONTRACT_ID | NUMBER | 18 | Project contact identifier | |
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Project contract line identifier | |
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Funding allocation identifier | |
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Project context category | |
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Project Reserved Attribute 1 | |
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Project Reserved Attribute 2 | |
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Project Reserved Attribute 3 | |
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Project Reserved Attribute 4 | |
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Project Reserved Attribute 5 | |
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Project Reserved Attribute 6 | |
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Project Reserved Attribute 7 | |
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Project Reserved Attribute 8 | |
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Project Reserved Attribute 9 | |
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Project Reserved Attribute 10 | |
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Project user defined Attribute 1 | |
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Project user defined Attribute 2 | |
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Project user defined Attribute 3 | |
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Project user defined Attribute 4 | |
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Project user defined Attribute 5 | |
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Project user defined Attribute 6 | |
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Project user defined Attribute 7 | |
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Project user defined Attribute 8 | |
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Project user defined Attribute 9 | |
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Project user defined Attribute 10 | |
| REFERENCE_ID1 | NUMBER | 18 | Source Document Reference Identifier 1. In the case of sales order issue transactions, this is the fulfillment line ID. | |
| 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. | |
| PERSON_ID | NUMBER | 18 | The person identifier of the worker charged in the resource transaction. | |
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description for purchase orders where purchase is made for items not defined in Product Information Management. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS. |