1. Tables and Views for SCM
  2. DOO_FULFILL_LINE_DETAILS

DOO_FULFILL_LINE_DETAILS

This table would contain information on details of the Fulfill Line with respect to the Billing and revenue schedules

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

DOO_FULFILL_LINE_DETAILS_PK

FULFILL_LINE_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TASK_TYPE VARCHAR2 50 A task classification that assigns default attributes to tasks and controls task processing.
FULFILL_LINE_DETAIL_ID NUMBER 18 Yes Unique identifier of the fulfillment line detail record.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
FULFILL_LINE_ID NUMBER 18 Reference to the unique identifier of a fulfillment line
BILLING_TRANSACTION_NUMBER VARCHAR2 30 Unique number for supplier invoice.
BILLING_TRANSACTION_DATE DATE The date that appears on a customer invoice. This date is used to calculate the invoice due date, according to the customer's payment terms.
BILLING_TRANSACTION_AMOUNT NUMBER Bank Charge Amount.
WAYBILL_NUMBER VARCHAR2 30 Waybill (Non-negotiable document describing the contract for transporting cargo) or airbill number for the shipment.
BILL_OF_LADING_NUMBER VARCHAR2 120 A carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address.
TRACKING_NUMBER VARCHAR2 120 Unique identification provided by carriers to track the shipment during transportation.
QUANTITY NUMBER Quantity of goods/services that was fulfilled by supplier.
STATUS_ASOF_DATE DATE The date the transaction occurred.
STATUS VARCHAR2 30 State or condition of a fulfillment line.
DELIVERY_NAME VARCHAR2 120 A separately identifiable collection of goods or materials to be carried under the terms of a single bill of lading.
RMA_RECEIPT_NUMBER VARCHAR2 50 Receipt header number sent by the receiving system.
RMA_RECEIPT_LINE_NUMBER VARCHAR2 50 Line number of the receipt sent by the receiving system.
RMA_RECEIPT_DATE DATE Actual Receipt Date sent by the receiving fulfillment system.
RMA_RECEIPT_TRANSACTION_ID NUMBER 18 Unique Transaction Identifier in Receiving
CUSTOMER_TRX_LINE_ID NUMBER 18 Unique identifier for the Billing Line
TRADE_COMPLIANCE_TYPE_CODE VARCHAR2 30 Contains the native type code from Global Trade Management
AVAILABILITY_SHIP_DATE TIMESTAMP In case of exception, this date would store the available to ship date for each supply detail line sent to DOO.
EXCEPTION_FLAG VARCHAR2 1 Flag sent when available to ship date for a supply order detail line is past the need by date or supply is unavailable for the fulfillment line
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.
REFERENCE_FLINE_DETAIL_ID NUMBER 18 Used by change mgmt to associate the change order's fline details id with the original order's fline details id.
DELTA_TYPE NUMBER 18 Internal column used by change processing framework for tracking type of change like update, cancel..etc
MODIFIED_FLAG VARCHAR2 1 Indicates that the row has been modified in the version currently submitted
ACTUAL_DELIVERY_DATE TIMESTAMP The actual date when the item is delivered.
TRADE_COMPLIANCE_RESULT_CODE VARCHAR2 30 Result of trade compliance screening
TRADE_COMPLIANCE_CODE VARCHAR2 30 Trade compliance code for screening result
TRADE_COMPLIANCE_EXPLANATION VARCHAR2 1000 Explanation for trade compliance screening result
PENDING_SHIPMENT_QUANTITY NUMBER OBSOLETE: Pending or unshipped quantity line that shipping sends to order management after it ships the line. Order management uses the value to determine whether to split the fulfillment line. Obsolete
SHIPMENT_REQUESTED_QUANTITY NUMBER Requested quantity for the shipment in the shipment advice that inventory management sends to order management. In the context of the shipment tolerance, the flow splits the fulfillment line according to the requested quantity
SECONDARY_QUANTITY NUMBER Shipped, received, or delivered quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item.

Foreign Keys

Table Foreign Table Foreign Key Column
DOO_FULFILL_LINE_DETAILS doo_fulfill_lines_all FULFILL_LINE_ID
doo_fulfill_line_details_eff_b doo_fulfill_line_details FULFILL_LINE_DETAIL_ID

Indexes

Index Uniqueness Tablespace Columns
DOO_FULFILL_LINE_DETAILS_FK1 Non Unique Default FULFILL_LINE_ID, TASK_TYPE
DOO_FULFILL_LINE_DETAILS_N1 Non Unique Default REFERENCE_FLINE_DETAIL_ID
DOO_FULFILL_LINE_DETAILS_N2 Non Unique Default BILLING_TRANSACTION_DATE
DOO_FULFILL_LINE_DETAILS_N3 Non Unique Default RMA_RECEIPT_TRANSACTION_ID, STATUS, TASK_TYPE
DOO_FULFILL_LINE_DETAILS_PK Unique Default FULFILL_LINE_DETAIL_ID