CSE_INTG_FLINES_DEBUG
The fulfillment lines that are interfaced to alm is persisted in this table for debugging any integration issues.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CSE_INTG_FLINES_DEBUG_PK |
DEBUG_FLINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEBUG_FLINE_ID | NUMBER | 18 | Yes | Debug Fulfill Line Identifier. The primary key of the table. | |
| DEBUG_BATCH | VARCHAR2 | 30 | A batch identifier to see how the group of flines are sent to alm. | ||
| FULFILL_LINE_ID | NUMBER | 18 | The fulfillment line identifier that identifies the sales order fulfillment. | ||
| FULFILL_LINE_NUMBER | NUMBER | 9 | Fulfillment Line Number. The user key to identify the order fulfillment record. | ||
| HEADER_ID | NUMBER | 18 | The header identifier of the sales order header. | ||
| LINE_ID | NUMBER | 18 | The line identifier of the sales order line. | ||
| LINE_TYPE_CODE | VARCHAR2 | 30 | The type of the order line. This denotes whether the sales order line type is a buy or return. | ||
| ACTION_CODE | VARCHAR2 | 30 | The action to be performed in installed base based on the type of sales order. | ||
| CATEGORY_CODE | VARCHAR2 | 30 | The category of the sales order line. This usually denotes whether the order is a sale or return. | ||
| SOURCE_LINE_ID | NUMBER | The source line identifier of the source order from a third party application where the order is captured and transferred to FOM. | |||
| SOURCE_LINE_NUMBER | VARCHAR2 | 100 | The source line number of the source order from a third party application where the order is captured and transferred to FOM. | ||
| SOURCE_ORDER_ID | VARCHAR2 | 50 | The source order identifier of the source order from a third party application where the order is captured and transferred to FOM. | ||
| SOURCE_ORDER_NUMBER | VARCHAR2 | 50 | The source order number of the source order from a third party application where the order is captured and transferred to FOM. | ||
| SOURCE_ORDER_SYSTEM | VARCHAR2 | 30 | The third party source system where the source order is captured. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | The product identifier of the product for which the sales order is captured. | ||
| ITEM_TYPE_CODE | VARCHAR2 | 30 | The type of item referenced in the sales order. | ||
| ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | A further breakdown of the item type as understood my order management to drive the processing down stream. | ||
| ORDERED_QTY | NUMBER | The quantity ordered in the sales order. | |||
| ORDERED_UOM | VARCHAR2 | 3 | The unit of measure on the ordered quantity. | ||
| FULFILLED_QTY | NUMBER | The quantity fulfilled in the sales order. | |||
| SHIPPED_QTY | NUMBER | The quantity shipped using this fulfillment line. | |||
| SHIPPED_UOM_CODE | VARCHAR2 | 3 | The unit of measure of the shipped quantity. | ||
| ORGANIZATION_ID | NUMBER | 18 | The validation organization identifier at the order line. | ||
| SOURCE_ORG_ID | NUMBER | 18 | The organization identifier where the sales order demand is to be fulfilled from. | ||
| FULFILL_ORG_ID | NUMBER | 18 | The organization identifier where this sales order will be fulfilled from. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | The billing customer identifier captured in the order. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | The bill to site use identification of the customer on the order. | ||
| BILL_TO_PARTY_ID | NUMBER | 18 | The billing party identifier on the order. | ||
| BILL_TO_PARTY_SITE_ID | NUMBER | 18 | The billing party site identifier on the saled order. | ||
| BILL_TO_CUST_ACCOUNT_ID | NUMBER | 18 | The billing customer account identifier on the sales order. | ||
| BILL_TO_CUST_ACC_SITE_ID | NUMBER | 18 | Bill to customer account site identifier at the sales order. | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | The ship to customer identifier. The ship to customer could be different than the customer on the order. | ||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | The site of the customer where the asset will be shipped to. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | The shipping party on the sales order where the asset will be shipped to. | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | The party site of the shipping party where the asset will be shipped to. | ||
| FULFILLMENT_DATE | DATE | Date when the sales order line is fulfilled. | |||
| ACTUAL_SHIP_DATE | DATE | The actual shipment date of the asset. | |||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | The parent fulfill line identifier when the sales order is a hierarchy based in the case of an ato, pto, or kit. | ||
| REFERENCE_FLINE_ID | NUMBER | 18 | When the fulfillment line splits, the reference fulfillment line identifier where it split from. | ||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | The root most fulfillment line identifier in the order tree. | ||
| SUBSTITUTE_ALLOWED_FLAG | VARCHAR2 | 1 | Flag indicating whether substitution is allowed in the downstream applications. | ||
| ORIGINAL_INVENTORY_ITEM_ID | NUMBER | 18 | When the item on the fulfillment line is substituted, the original item identifier is captured here. | ||
| CONFIG_INVENTORY_ITEM_ID | NUMBER | 18 | The inventory item identifier of the configured product that got created in the assemble to order flow. | ||
| ROOT_PARENT_ITEM_ID | NUMBER | 18 | The root parent identifier. Usually the model or the kit item in the hierarchy based orders. | ||
| ROOT_PARENT_ITEM_TYPE_CODE | VARCHAR2 | 30 | The root parent's item type code. | ||
| ROOT_PARENT_CONFIG_ITEM_ID | NUMBER | 18 | In a sub ato model use case, the root most ato's config item identifier. | ||
| PARENT_LINE_ID | NUMBER | 18 | The parent sales order line identifier. | ||
| ROOT_PARENT_LINE_ID | NUMBER | 18 | The root parent sales order line identifier in the case of a hierarchy based sales order. | ||
| REFERENCE_LINE_ID | NUMBER | 18 | The reference sales order line identifier in the case of a line split. | ||
| TRANSFORM_FROM_LINE_ID | NUMBER | 18 | The transform from sales order line identifier. | ||
| ORDER_TYPE_CODE | VARCHAR2 | 30 | The sales order type code. This is something that is captured at the sales order header. | ||
| SOLD_TO_PARTY_ID | NUMBER | 18 | The selling party on the sales order. This one has the account relationship. | ||
| SOLD_TO_CUSTOMER_ID | NUMBER | 18 | The customer account identifier for the sold to party. | ||
| SOLD_TO_PARTY_CONTACT_ID | NUMBER | 18 | The contact of the selling party. | ||
| SHIPMENT_ID | NUMBER | 18 | The shipment identifier from the shipping module in the case of a shipped fulfillment line. | ||
| COMPONENT_SEQUENCE_ID_PATH | VARCHAR2 | 4000 | This is the bill of material component id sequence path to locate the component in the item structure. | ||
| QUANTITY_PER_MODEL | NUMBER | The quantity per model for any models ordered with multiple quantities. | |||
| UNIT_QUANTITY | NUMBER | The unit quantity of the model in the case of multi quantity orders. | |||
| SHIPPABLE_FLAG | VARCHAR2 | 1 | The flag indicating whether the item on the sales order is shippable. | ||
| CUSTOMER_ASSET_END_DATE | TIMESTAMP | The end date of the customer asset for term licence flows. | |||
| ASSET_GROUP_NUMBER | VARCHAR2 | 30 | The group number. This is the alternate primary key for the group entity. | ||
| 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. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | 50 | User defined identifier for a purchase order. | ||
| 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_FLINES_DEBUG_U01 | Unique | Default | DEBUG_FLINE_ID |