DOO_FS_FULFILL_LINE_DTLS_INT
Fulfillment related details sent back by fulfillment systems such as Shipping, Billing, Receiving, Trade Compliance, etc.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
DOO_FS_FLINE_DTLS_INT_PK |
FULFILL_LINE_DTL_IF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FULFILL_LINE_DTL_IF_ID | NUMBER | 18 | Yes | Unique internal identifier for a fulfillment detail interface record, generated by sequence. | |
| FULFILLMENT_SYSTEM_RESPONSE_ID | VARCHAR2 | 50 | Unique identifier that fulfillment system may send and can be used to correlate the response relayed back to the fulfillment system. | ||
| FULFILL_LINE_INTERFACE_KEY | VARCHAR2 | 120 | An identifier that distinguishes a fulfillment line record from another one for a given fulfillment system response identifier. | ||
| FULFILL_LINE_DTL_INTERFACE_KEY | VARCHAR2 | 50 | An identifier that distinguishes a fulfillment detail record from another one for a given fulfillment line within a fulfillment system response identifier. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Unique identifier of a data set pertaining to fulfillment system responses to one or more fulfillment system requests. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| 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. | |
| TASK_TYPE_CODE | VARCHAR2 | 50 | Classifies the fulfillment details based on task type e.g., Shipment, DOO_Procurement, Invoice, Return etc. | ||
| STATUS_CODE | VARCHAR2 | 30 | State or condition of a fulfillment activity on a fulfillment line. | ||
| ACTUAL_DELIVERY_DATE | TIMESTAMP | The actual date when the item is delivered. | |||
| TRADE_COMPLIANCE_TYPE_CODE | VARCHAR2 | 30 | The type of trade compliance policy that the application references when it verifies a line. | ||
| TRADE_CONTROL_CODE | VARCHAR2 | 30 | Code that clarifies the factors, such as firearms conventions, that the application used when it verified the trade compliance. | ||
| TRADE_COMPLIANCE_COMMENTS | VARCHAR2 | 1000 | Remark for trade compliance screening result. | ||
| TRADE_COMPLIANCE_RESULT_CODE | VARCHAR2 | 30 | Result of trade compliance screening for the given compliance type. | ||
| RMA_RECEIPT_TRANSACTION_ID | NUMBER | 18 | Refers to the unique identifier of the Receipt created in the Receiving module of Inventory Management. | ||
| STATUS_AS_OF_DATE | DATE | The date the transaction occurred. | |||
| BILLING_TRANSACTION_NUMBER | VARCHAR2 | 30 | Unique number for an invoice issued to the customer. | ||
| DELIVERY_NAME | VARCHAR2 | 120 | A separately identifiable collection of goods or materials to be carried under the terms of a single bill of lading. | ||
| 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. | |||
| CUSTOMER_TRANSACTION_LINE_ID | NUMBER | 18 | Unique identifier for the Billing Line. | ||
| BILLING_TRANSACTION_AMOUNT | NUMBER | Amount that appears on the customer invoice for a fulfillment line. | |||
| RMA_RECEIPT_DATE | DATE | Actual Receipt Date sent by the receiving fulfillment system. | |||
| RMA_RECEIPT_LINE_NUMBER | VARCHAR2 | 50 | Line number of the receipt sent by the receiving system. | ||
| WAYBILL_NUMBER | VARCHAR2 | 30 | Waybill (Non-negotiable document describing the contract for transporting cargo) or airbill number for the shipment. | ||
| RMA_RECEIPT_NUMBER | VARCHAR2 | 50 | Receipt header number sent by the receiving system. | ||
| 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 the ordered item that was processed by the fulfillment system. | |||
| SUPPLY_EXCEPTION_FLAG | VARCHAR2 | 1 | Indicates a supply exception such as a delay or no availability. | ||
| NET_RECEIVED_QUANTITY | NUMBER | Total quantity returned by the customer. | |||
| PARTIALLY_FULFILLED_FLAG | VARCHAR2 | 1 | Applicable to implicit splits for models and shipment sets. Indicates whether the fulfillment system has completed the fulfillment activity for this line but not for one or more other lines that belong to the same model or shipment set. | ||
| SUPPLY_AVAILABILITY_DATE | TIMESTAMP | Date when goods are expected to be available for shipment to the customer. | |||
| ORDERED_UOM_CODE | VARCHAR2 | 3 | Unit of measure code in which the ordered quantity is expressed. | ||
| TRANSACTIONAL_CURRENCY_CODE | VARCHAR2 | 1000 | Currency in which the amounts and prices are expressed. | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | Identifies the source used to insert data in this interface table. For example, ORA_FS_RESPONSE_FBDI and ORA_FS_RESPONSE_API for data imported using file and API respectively. | ||
| 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. | |||
| FULFILL_LINE_ID | NUMBER | 18 | Unique Identifier for a fulfillment line |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| DOO_FS_FLINE_DTLS_INT_PK | Unique | Default | FULFILL_LINE_DTL_IF_ID | |
| DOO_FS_FLINE_DTL_INT_N1 | Non Unique | Default | INTERFACE_SOURCE_CODE, LOAD_REQUEST_ID, FULFILL_LINE_INTERFACE_KEY, FULFILL_LINE_DTL_INTERFACE_KEY | Obsolete |
| DOO_FS_FLINE_DTL_INT_N2 | Non Unique | Default | FULFILL_LINE_ID, FULFILL_LINE_INTERFACE_KEY |