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 This column is for Oracle Internal use only. 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
CREATION_DATE TIMESTAMP Creation date of the row.