DW_WSH_SERIAL_NUMBERS_D

This table stores serial numbers after Ship Confirm is done

Details

Module: Inventory Management

Key Columns

FM_SERIAL_NUMBER, DELIVERY_DETAIL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DELIVERY_DETAIL_ID NUMBER 38 0 True Delivery Detail Id which has serial numbers associated to it    
FM_SERIAL_NUMBER VARCHAR2 128   True Start serial number in the range.    
SOURCE_RECORD_ID VARCHAR2 256     System identifier    
TO_SERIAL_NUMBER VARCHAR2 128     End serial number in the range.    
QUANTITY NUMBER       Total Number of serial Numbers between FM_SERIAL_NUMBER to TO_SERIAL_NUMBER