CSE_INTG_TXNS_DEBUG
The transactions payload passed on to the capture api is persisted here for debugging putposes.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CSE_INTG_TXNS_DEBUG_PK |
DEBUG_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| DEBUG_TXN_ID | NUMBER | 18 | Yes | The uniquely generated system identifier that identifies the transaction and can be used the related entities like the product instances, charges, and documents. | ||
| SRC_SYSTEM_TYPE | VARCHAR2 | 30 | The source system type. It could be an internal system or external system. | |||
| SRC_SYSTEM_CODE | VARCHAR2 | 30 | The code that identifies the source system. | |||
| SRC_SYSTEM_ID | NUMBER | The identifier of the source system. | ||||
| SRC_TRANSACTION_TYPE | VARCHAR2 | 240 | The free format source transaction type that can be processed in product genealogy. | |||
| SRC_TRANSACTION_TYPE_ID | VARCHAR2 | 30 | The source system transaction type identifier. It could be a code in one system and id in another. | |||
| SRC_TRANSACTION_ID | NUMBER | The unique transaction identifier as recorded in the source system. | ||||
| SRC_TRANSACTION_DATE | DATE | The date when the transaction is performed in the source system. | ||||
| SRC_TRANSACTION_QUANTITY | NUMBER | The transaction quantity as performed in the source system. | ||||
| SRC_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure in which the source transaction quantity was transacted. | |||
| SECONDARY_QUANTITY | NUMBER | This is the secondary quantity captured when the item supports dual units of measure. | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure. | |||
| RELATED_TRANSACTION_ID | NUMBER | The transaction identifier that is related to this current transaction. | ||||
| ITEM_NUMBER | VARCHAR2 | 300 | The item number for which the transaction is performed. | |||
| ITEM_ID | NUMBER | The item identifier for which the transaction is performed. | ||||
| ITEM_REVISION | VARCHAR2 | 18 | The item revision for which the transaction is performed. | |||
| ORGANIZATION_CODE | VARCHAR2 | 18 | The organization code in which the transactions is performed. | |||
| ORGANIZATION_ID | NUMBER | The organization identifier in which the transactions is performed. | ||||
| SUBINVENTORY_CODE | VARCHAR2 | 30 | The subinventory that is involved in the transaction. | |||
| LOCATOR_ID | NUMBER | The inventory locator that is involved in the transaction. | ||||
| SUPPLIER_NAME | VARCHAR2 | 240 | The supplier for which the transaction is performed. | |||
| SUPPLIER_ID | NUMBER | The identifier of the supplier for which the transaction is performed. | ||||
| SUPPLIER_SITE | VARCHAR2 | 240 | The supplier site that is involved in the transaction. | |||
| SUPPLIER_SITE_ID | NUMBER | The identifier of the supplier site that is involved in the transaction. | ||||
| SOLD_BY_BUSINESS_UNIT_ID | NUMBER | 18 | The identifier of the business unit that sold the asset to the customer. | |||
| CUSTOMER_NAME | VARCHAR2 | 240 | The customer to which the asset is shipped to. | |||
| CUSTOMER_ID | NUMBER | The identifier of the customer to which the asset is shipped to. | ||||
| CUSTOMER_SITE_PARTY_ID | NUMBER | The party site of the customer in which the asset is transacting. | ||||
| CUSTOMER_SITE_ID | NUMBER | The party site identifier of the customer in which the asset is transacting. | ||||
| CUSTOMER_SHIP_TO_LOC | NUMBER | The customer location to which the asset is shipped to. | ||||
| CUSTOMER_BILLING_PARTY_ID | NUMBER | The identifier of the billing party to which the asset is sold to. | ||||
| CUSTOMER_BILLING_PARTY_SITE_ID | NUMBER | The party site identifier of the billing party to which the asset is sold to. | ||||
| CUSTOMER_ACCOUNT_ID | NUMBER | The account identifier of the customer. | ||||
| CUSTOMER_ACCOUNT_SITE_ID | NUMBER | The site of the customer account. | ||||
| CUSTOMER_ACCOUNT_SITE_USE_ID | NUMBER | The identifier of the site use of the customer account. | ||||
| SHIPMENT_DATE | DATE | The date when the asset was shipped to the customer. | ||||
| INSTALLED_DATE | DATE | The date when the asset was installed. | ||||
| IN_SERVICE_DATE | DATE | The date when the asset was placed in service. | ||||
| PURCHASE_DATE | DATE | The date when the asset was purchased from the supplier. | ||||
| ORIGINATION_DATE | DATE | The date when the asset originated. | ||||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | The last work order number reference which was used in building this asset. | |||
| WORK_ORDER_ID | NUMBER | The identifier of the last work order reference which was used in building this asset. | ||||
| WORK_ORDER_OPERATION_SEQ_NUM | NUMBER | The operation sequence number of the work order. | ||||
| WORK_ORDER_OPERATION_ID | NUMBER | The operation identifier of the work order. | ||||
| WORK_CENTER_CODE | VARCHAR2 | 30 | The work center where the asset is located. | |||
| WORK_CENTER_ID | NUMBER | The identifier of the work center where the asset is located. | ||||
| WORK_METHOD_CODE | VARCHAR2 | 30 | The work method of the work order where the asset is transacted. | |||
| SALES_ORDER_SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | The source system type of the sales order. | |||
| SALES_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | The source system of the sales order where the order was captured. | |||
| SALES_ORDER_NUMBER | VARCHAR2 | 120 | The sales order number on which the asset is/is to be fulfilled. | |||
| SALES_ORDER_ID | NUMBER | The identifier of the sales order on which the asset is/is to be fulfilled. | ||||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The line number of the sales order on which the asset is/is to be fulfilled. | |||
| SALES_ORDER_LINE_ID | NUMBER | The identifier of the sales order on which the asset is/is to be fulfilled. | ||||
| PARENT_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The parent line number of the sales order line on which the asset is/is to be fulfilled. | |||
| PARENT_ORDER_LINE_ID | NUMBER | 18 | The parent line identifier of the sales order line on which the asset is/is to be fulfilled. | |||
| FULFILL_LINE_ID | NUMBER | 18 | The fulfillment line identifier of the sales order line on which the asset is/is to be fulfilled. | |||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | The parent fulfillment line identifier of the fulfillment line on which the asset is/is to be fulfilled. | |||
| SHIPMENT_ID | NUMBER | 18 | The shipment identifier that tracks the shipment of the asset. | |||
| SELF_INDEX | NUMBER | The pregenerated transaction identifier to be used in the processing. | ||||
| COMPONENT_SEQUENCE_ID_PATH | VARCHAR2 | 4000 | The bills of material component sequence path identifier. | |||
| LOGICAL_FLAG | VARCHAR2 | 1 | Flag indicating whether this transaction represents a logical txn. | |||
| ACTION_CODE | VARCHAR2 | 100 | Action code interpreted from the sales order line to be processed to Installed Base. | |||
| ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | The sub type code as understood by the distributed orchestration module. | |||
| CUSTOMER_ASSET_START_DATE | TIMESTAMP | The start date of the customer asset. | ||||
| CUSTOMER_ASSET_END_DATE | TIMESTAMP | The end date of the customer asset. | ||||
| LOCATION_TYPE | VARCHAR2 | 30 | The type of the location to be processed for this transaction. | |||
| LOCATION_ID | NUMBER | 18 | The location identifier foreign key and it is contextual to the location type. | |||
| EXTERNAL_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | The external system packing unit to be passed on from WMS/Logistics. | |||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | The root parent fulfillment line identifier. | |||
| ROOT_PARENT_LINE_ID | NUMBER | 18 | The root parent order line identifier. | |||
| ROOT_PARENT_ITEM_ID | NUMBER | 18 | The item identified at the root parent. | |||
| ROOT_PARENT_ITEM_TYPE_CODE | VARCHAR2 | 30 | The item type code of the item at the root parent. | |||
| ROOT_PARENT_CONFIG_ITEM_ID | NUMBER | 18 | The config item identified at the root parent order line. | |||
| ROOT_PARENT_SR_CONTROL | NUMBER | 18 | The serial control policy on the item at the root parent order line. | |||
| ROOT_PARENT_CONFIG_SR_CONTROL | NUMBER | 18 | The serial control policy on the config item at the root parent order line. | |||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Project context category. This is the project's dff segment. | |||
| PJC_PROJECT_ID | NUMBER | 18 | The project identifier captured by PDSC. | |||
| PJC_TASK_ID | NUMBER | 18 | The project task identifier captured by PDSC. | |||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | The project expenditure type captured by PDSC. | |||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Date when the expenditure is to be booked in the project. | ||||
| PJC_ORGANIZATION_ID | NUMBER | 18 | The project organization identifier captured by PDSC. | |||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | The billable flag at the project level. | |||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | The capitalizable flag at the project. | |||
| PJC_WORK_TYPE_ID | NUMBER | 18 | The type of project work identifier. | |||
| PJC_CONTRACT_ID | NUMBER | 18 | The project contract identifier. | |||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | The line identifier of the project contract. | |||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | The funding allocation identifier. | |||
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Attribute reserved for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | User defined attribute for project costing. | |||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | The code for the country where the lot or serial originated from. | |||
| SHIPMENT_NUMBER | VARCHAR2 | 30 | The shipment number that is used as the handle in the movement of products from one organization to another using an intransit stop. | |||
| CONFIGURATOR_PATH | VARCHAR2 | 2000 | Configurator runtime representation of the Inventory Item Id path to the component. Path format is "." Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>]. | |||
| CONFIG_HEADER_ID | NUMBER | 18 | Header identifier of the configuration. | |||
| CONFIG_REVISION_NUMBER | NUMBER | 18 | Revision number of the configuration. | |||
| INV_PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | Active | ||
| INV_TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | Active | ||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | |||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | |||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | |||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | |||
| TXN_GROUP_ID | NUMBER | 18 | The transaction group identifier that is used by the inventory transaction processor to group transaction that are involved in the lot splits, merges, and translations. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_INTG_TXNS_DEBUG_U01 | Unique | Default | DEBUG_TXN_ID |