# 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

exceptiontype, exceptionreason, fulfillmentrequest, itemline

## Columns

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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.