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