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 |