DW_WSH_SERIAL_NUMBERS_D

This table stores serial numbers after Ship Confirm is done

Details

Module: Inventory Management

Key Columns

DELIVERY_DETAIL_ID, FM_SERIAL_NUMBER

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.    

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