DW_NS_fulfillmentRequestItemException_F
This fact table contains the information for fulfillment request exception line item with exception type and exception reason.
Details
Module:
Key Columns
exceptionreason, fulfillmentrequest, itemline, exceptiontype
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| fulfillmentrequest | NUMBER | 38 | 0 | True | Fulfillment request identifier. | DW_NS_FULFILLMENT_REQUEST_LINES_F | transaction |
| itemline | NUMBER | 38 | 0 | True | Item Identifier. | DW_NS_FULFILLMENT_REQUEST_LINES_F | id |
| exceptiontype | NUMBER | 38 | 0 | True | Exception type. | DW_NS_FulfillmentExceptionType_D | key |
| exceptionreason | NUMBER | 38 | 0 | True | Exception reason. | DW_NS_fulfillmentExceptionReason_D | id |
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| exceptionquantity | NUMBER | Exception quantity. | |||||
| exceptioncomments | VARCHAR2 | 999 | Exception comments. |