CST_I_INV_TRANSACTIONS_I_GT
This table is used to temporarily store a subset of data from CST_I_INV_TRANSACTIONS table to support internal processing within the Cost Processor
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
CST_I_INV_TRANSACTIONS_I_GT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Reference Information from an External system (external to Cost Management). | |
DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Reference to the distributed order orchestration (DOO) fulfillment line identifier. | ||
PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item Description for purchase orders where purchase is made for non inventory items. | ||
PO_ITEM_DESCRIPTION_TYPE | VARCHAR2 | 30 | Indicates the type of purchase in case purchase is made for non-inventory item based on a description. Valid values are GOODS or SERVICES. | ||
TRANSACTION_AMOUNT | NUMBER | Transaction Amount in purchase order currency. Applicable for fixed price lines. | |||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 15 | Purchase order currency for the amount column. Applicable for fixed price lines. | ||
TRANSFER_PROJECT_ID | NUMBER | 18 | Transfer Project identifier used in project transfer transactions. | ||
TRANSFER_TASK_ID | NUMBER | 18 | Transfer Task identifier used in project transfer transactions. | ||
DS_SOURCE_LINE_ID | NUMBER | 18 | Based on Flow Type(ASN OR INVOICE) either Shipment Line Id or Transaction Event Id will be stored | ||
REFERENCE_DELIVERY_ID | NUMBER | 18 | Referenced delivery id identifier for RMA. | ||
FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document header. | ||
FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the fiscal document. | ||
FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document line. | ||
REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document header. | ||
REF_FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document line. | ||
REF_FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the reference fiscal document. | ||
FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document schedule. | ||
REF_FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document schedule. | ||
EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system | |
BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization | |
INVENTORY_ORG_ID | NUMBER | 18 | Yes | Surrogate key that identifies Inventory Organization | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate key that identifies Inventory Item | |
TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Yes | 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 | |
INV_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Transaction source type identifier including custom source types. | |
TRANSACTION_ACTION_ID | NUMBER | 18 | Yes | Surrogate key that identifies the transaction action | |
TRANSACTION_TYPE_ID | NUMBER | 18 | Yes | Surrogate key that identifies the transaction type | |
TRANSACTION_DATE | DATE | Yes | Transaction date when the quantity movement is tracked. | ||
TRANSACTION_CREATION_DATE | DATE | Yes | Date on which the Transaction was created | ||
TRANSACTION_TIMEZONE_CODE | VARCHAR2 | 50 | Timezone code based on transaction date | ||
TRANSACTION_QTY | NUMBER | Yes | Transaction Quantity in transaction unit of measure. | ||
TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | Transaction unit of measure code | |
PRIMARY_QTY | NUMBER | Yes | Transaction Quantity in Primary unit of measure | ||
PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | Primary unit of measure of the item. | |
SECONDARY_TRANSACTION_QTY | NUMBER | Transaction Quantity in Secondary unit of measure | |||
SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Inventory Items secondary UOM Code | ||
SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code where the item is stored. | ||
LOCATOR_ID | NUMBER | 18 | Surrogate key that identifies inventory locator | ||
PARENT_TRANSACTION_ID | NUMBER | 18 | OBSOLETE: Parent Transaction identifier | ||
TRANSACTION_REASON_ID | NUMBER | 18 | Surrogate key that identifies the transaction reason | ||
TRANSFER_TRANSACTION_ID | NUMBER | 18 | Transaction id of the opposing transfer transaction | ||
ORIGINAL_TRANSACTION_TEMP_ID | NUMBER | 18 | Transaction Temp Id that was generated when the Inventory transaction was saved. | ||
TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Transfer opposing inventory organization id | ||
TRANSFER_SUBINVENTORY_CODE | VARCHAR2 | 10 | Transfer transaction opposing subinventory | ||
TRANSFER_LOCATOR_ID | NUMBER | 18 | Transfer transaction opposing locator id | ||
TRANSFER_PERCENTAGE | NUMBER | OBSOLETE: Percentage of value to attribute to transfer costs in an Inter-Org transfer | |||
TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others. | ||
EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction | ||
FOB_POINT | NUMBER | 1 | OBSOLETE: Indicates the 'Free on board' point and determines the point of transfer of liability/ownership. | ||
INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | OBSOLETE: Indicates whether the transaction is eligible for inter company invoicing or not | ||
PRICING_OPTION | NUMBER | 18 | OBSOLETE: Surrogate key that identifies Pricing Option | ||
INTERFACE_BATCH_NUMBER | VARCHAR2 | 50 | Batch Number of External Systems interface run. Added to facilitate source system to identify which transactions were sent in which run on the source system. | ||
INTERFACE_BATCH_NAME | VARCHAR2 | 250 | Batch Name of External Systems interface run. | ||
TRANSACTION_STATUS | VARCHAR2 | 5 | Preprocessing status of the transaction. Valid values are 'P' - Pending, and 'E' - Error | ||
RCV_TRANSACTION_ID | NUMBER | 18 | Single column FK: identifies the Receiving transaction of this interfaced transaction. | ||
PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: identifies the PO distribution of this interfaced transaction. | ||
WSH_DELIVERY_DETAIL_ID | NUMBER | 18 | Single column FK: identifies the Shipment delivery detail of the interfaced transaction. This column actually stores the DELIVERY_ID from Fusion Logistics. | ||
DOO_FULLFILL_LINE_ID | NUMBER | 18 | Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO). | ||
CODE_COMBINATION_ID | NUMBER | 18 | Single column FK: identifies the Code combination of the account entered by the users while creating the transactions (Misc. Transactions). | ||
WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying a work order in manufacturing. | ||
SUPPLY_TYPE | VARCHAR2 | 30 | The various supply types are "Assembly Pull", "Operation Pull", "Push", and Phantom. This list will have to be seeded as lookups with the type "EGP_WIP_SUP_TYPE". | ||
WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying a operation within a work order. | ||
WORK_CENTER_ID | NUMBER | 18 | Surrogate ID identifying Work Center where the operation is executed. | ||
WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying a work order operation transaction that created this material transactions. | ||
TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | This Transaction's Source Document Type | ||
TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | This Transaction's Source Document Number | ||
TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | This Transaction's Source Document's Reference Document Type | ||
TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | This Transaction's Source Document's Reference Document Number | ||
TRANSACTION_REFERENCE | VARCHAR2 | 240 | Source system transaction reference | ||
FROM_GRADE_CODE | VARCHAR2 | 150 | Grade of an item before the grade change | ||
TO_GRADE_CODE | VARCHAR2 | 150 | Grade of an item after the grade change | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
PJC_PROJECT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_TASK_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | DFF Column used by Standardized Project Cost Collection Widget | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Surrogate key that identifies the organization | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | DFF Context Column used by Standardized Project Cost Collection Widget | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_CONTRACT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
INTERNAL_PROFIT_TRACKING | VARCHAR2 | 1 | OBSOLETE: Internal Profit Tracking (Used by internal processes) | ||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Tax Determinant: Default taxation country code. | ||
FIRST_PTY_REG_ID | NUMBER | 18 | Tax Determinant: First Party Tax Registration ID for the transaction. | ||
THIRD_PTY_REG_ID | NUMBER | 18 | Tax Determinant: Third Party Tax Registration ID for the transaction. | ||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Tax Determinant: The final discharge location identifier. | ||
DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Tax Determinant: Document Fiscal Classification code. | ||
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Tax Determinant: Transaction business category code. | ||
USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | Tax Determinant: User defined fiscal classification code. | ||
TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Tax Determinant: The number of the Fiscal Document. | ||
TAX_INVOICE_DATE | DATE | Tax Determinant: Date of the Fiscal Document. | |||
PROD_FC_CATEG_ID | NUMBER | 18 | Tax Determinant : Category ID, used to store the internal ID for Product Fiscal Classification. | ||
PRODUCT_CATEGORY | VARCHAR2 | 240 | Tax Determinant: Product category code of the transaction line. | ||
INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Tax Determinant: Intended Use Classification Identifier. | ||
PRODUCT_TYPE | VARCHAR2 | 240 | Tax Determinant: Product type code of the inventory item. Possible values are GOODS and SERVICES. | ||
ASSESSABLE_VALUE | NUMBER | Tax Determinant: Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. | |||
TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Tax Determinant: Tax Classification Code. | ||
SHIP_FROM_LOCATION_ID | NUMBER | 18 | Tax Determinant: Ship from location identifier. | ||
EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 80 | Tax Determinant: Tax exemption certificate number. | ||
EXEMPT_REASON_CODE | VARCHAR2 | 30 | Tax Determinant: Tax exemption reason code. | ||
TRX_WAYBILL_NUMBER | VARCHAR2 | 50 | Tax Determinant: Waybill or airbill number. | ||
PORT_OF_DISCHARGE | VARCHAR2 | 150 | Port of discharge for the sales order shipment. | ||
PORT_OF_LOADING | VARCHAR2 | 150 | Port of loading for the sales order shipment. | ||
DELIVERY_TYPE | VARCHAR2 | 30 | Delivery type of the sales order shipment - STANDARD, CONSOLIDATED | ||
DELIVERY_DETAIL_ID | NUMBER | 18 | Single column FK: identifies the Shipment delivery detail id of the interfaced transaction. | ||
TRADE_AGREEMENT_PTR_ID | NUMBER | 18 | Identifies the primary trade relationship of the SFO agreement. | ||
TRADE_AGREEMENT_FTR_ID | NUMBER | 18 | Identifies the financial trade relationship of this trade event | ||
TRADE_AGREEMENT_TYPE | VARCHAR2 | 20 | To be used by the accounting template instead of transaction_flow_type. Populate this for all SFO related physical transactions (even when we do not explicitly call SFO) | ||
TRADE_AGREEMENT_NUMBER | VARCHAR2 | 100 | Required for interorg shipment, SO Issue, RMA receipt to identify that it is SFO related. All these cases call SFO to figure it out. | ||
SUCCESSOR_INVENTORY_ORG_ID | NUMBER | 18 | Required for SO Issue, interorg shipment, TO shipment to provide as a source in SLA because accounting of this hits Trade Intransit. | ||
SUCCESSOR_BUSINESS_UNIT_ID | NUMBER | 18 | Required for SO Issue, interorg shipment, TO shipment to provide as a source in SLA because accounting of this hits Trade Intransit. | ||
PRIOR_INVENTORY_ORG_ID | NUMBER | 18 | Required for direct interorg receipt to provide as a source in SLA because accounting of this hits Trade Intransit (as there is no receiving involved here). | ||
PRIOR_BUSINESS_UNIT_ID | NUMBER | 18 | Required for direct interorg receipt to provide as a source in SLA because accounting of this hits Trade Intransit (as there is no receiving involved here). | ||
TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Required for all transfer order transactions. | ||
TRANSFER_ORDER_DISTRIBUTION_ID | NUMBER | 18 | Required for transfer order related receipts. Where it does not come from the interface, qty preprocessor will derive it based on ascending order of distribution id (to keep it in sync with how Inventory derives it). | ||
ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | This column is populated only for transactions involving consigned material, with the original deliver transaction identifier in Receiving. | ||
ORIGINAL_RECEIPT_INV_ORG_ID | NUMBER | 18 | The Inventory organization where the original receipt of consigned goods was received. | ||
OWNER_TYPE | NUMBER | 18 | This is the party that transfers the ownership to the org where the ownership change happens. Values: 1 is SUPPLIER, 2 is INVENTORY_ORG, null is for non-consigned scenario | ||
OWNING_ENTITY_ID | NUMBER | 18 | Identifies the party who currently owns the goods. | ||
TRANSFER_TO_REGULAR_TXN_ID | NUMBER | 18 | Identifies the transfer to regular transaction that is being returned. This is only populated to transfer to consigned transactions. | ||
CURRENCY_CONVERSION_RATE | NUMBER | The conversion rate from the entered currency on the purchase order to the functional currency of the Bill to business unit on the purchase order. This is relevant only for supplier consigned ownership change transactions. | |||
OWNER_NAME | VARCHAR2 | 30 | For consigned transactions this column stores the supplier number in case an external supplier is involved. For internal consigned functionality this column stores the inventory org information. | ||
ORIGINAL_RECEIPT_NUMBER | VARCHAR2 | 50 | This column stores the receipt number of the transaction along with the Inventory Org code of org where goods are first received. | ||
TRANSACTION_INTERFACE_LINE_NUM | VARCHAR2 | 30 | Identifies the inventory transaction entered via the SAAS interface. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
TRANSACTION_INTERFACE_ID | NUMBER | 18 | Transaction Identifier from INV_TRANSACTIONS_INTERFACE | ||
SOURCE_SALES_ORDER_NUMBER | VARCHAR2 | 150 | Sales order number from shipping | ||
SOURCE_SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | Sales order line number from shipping | ||
SOURCE_SO_SHIPMENT_NUMBER | VARCHAR2 | 20 | Sales order shipment number from shipping | ||
SALES_ORDER_SOURCE_SYSTEM | VARCHAR2 | 90 | Identify the source system for Sales order | ||
RECEIPT_ADVICE_NUMBER | VARCHAR2 | 80 | Receipt advice identification number | ||
RECEIPT_ADVICE_LINE_NUMBER | VARCHAR2 | 80 | Receipt advice line identification number | ||
REFERENCED_SO_NUMBER | VARCHAR2 | 80 | Sales order document number on return transactions. | ||
REFERENCED_SO_LINE_NUMBER | VARCHAR2 | 80 | Sales order document line number on return transactions | ||
INV_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier and every transfer order related transaction must have this. | ||
INV_TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Surrogate key that identifies Transfer Order distribution | ||
INV_TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | Surrogate key that identifies the transfer order header | ||
ORIGINAL_TO_SHIPMENT_TXN_ID | NUMBER | 18 | For return shipment transactions, this references the original forward flow transaction id. | ||
MANUAL_RECEIPT_REQD_FLAG | VARCHAR2 | 1 | Flag to denote Manual receipt is created or not for transfer to expense destination | ||
REFERENCE_DOO_FULLFILL_LINE_ID | NUMBER | 18 | Surrogate key that identifies referenced fulfilment line | ||
CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying a work order in costing. | ||
CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying a work order operation in costing. | ||
CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Surrogate ID identifying the manufacturing operation transaction creating the material transaction. | ||
SHIPPING_INV_ORG_ID | NUMBER | 18 | Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows. | ||
SHIPPING_BU_ID | NUMBER | 18 | Profit Center Business Unit of Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows. | ||
RETURN_INV_ORG_ID | NUMBER | 18 | Inventory org of return receipt. | ||
RETURN_BU_ID | NUMBER | 18 | Profit Center Business Unit of Inventory Org where the return receipt. | ||
REFERENCED_RETURN_FLAG | VARCHAR2 | 1 | Possible values Y/N/NULL. Mainly used for referenced RMA. Y means return is a referenced return N means it is unreferenced NULL means that it is a pre-R13 return flow. | ||
SIMPLE_PROC_FLAG | VARCHAR2 | 5 | Whether the Dropship Delivery is for Simple Procurement (Y) or for Global Procurement flow (N). | ||
CONSUMPTION_UNIT_PRICE | NUMBER | Transfer to owned transaction unit price | |||
WO_OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced on a process manufacturing work order. Valid values exist in the lookup ORA_WIS_WD_OUTPUT_MATERIAL. | ||
PRIMARY_PRODUCT_FLAG | VARCHAR2 | 1 | Indicates whether this is the primary output for the work order. Valid values are Y or N. | ||
WO_COST_ALLOCATION_BASIS | VARCHAR2 | 30 | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS. | ||
INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||
TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
WMS_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is WMS reconciliation. | ||
SUPPLIER_RETURN_HEADER_ID | NUMBER | 18 | Unique identifier for supplier return header. | ||
SUPPLIER_RETURN_LINE_ID | NUMBER | 18 | Unique identifier for supplier return line. | ||
RECALL_HEADER_ID | NUMBER | 18 | Unique identifier for recall header. | ||
RECALL_LINE_ID | NUMBER | 18 | Unique identifier for recall line. | ||
PARENT_ID | NUMBER | 18 | This column identifies source and resultant transaction group for lot merge, translate and split flows. | ||
SOURCE_LOT_FLAG | VARCHAR2 | 3 | To identify source transactions for lot merge, translate and split flows. Values: (Y) for Source transaction, (N) for resultant transaction and null in case of other flows. | ||
TXN_COST_CALLBACK_FLAG | VARCHAR2 | 1 | Interface the transaction cost to financial orchestration system or not. | ||
REF_RCV_TRANSACTION_ID | NUMBER | 18 | This column identifies the receiving transaction identifier for Shipment and Receipt transactions in the Internal Material Transfers forward and return flows. | ||
ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the material transactions are performed. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_I_INV_TRANSACTIONS_I_GT_N1 | Non Unique | DOO_FULLFILL_LINE_ID |
CST_I_INV_TRANSACTIONS_I_GT_U1 | Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |