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 |