Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
STCKCNTID | Stock Count ID |
String | 16 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
BINNMBR | Bin Number |
String | 22 | View | |
CAPTUREDQTY | Captured Qty |
Currency | 10 | View | |
COUNTEDQTY | Counted Qty |
Currency | 10 | View | |
COUNTDATE | Count Date |
Date | 4 | View | |
COUNTTIME | Count Time |
Time | 4 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
ITMTRKOP | Item Tracking Option 1. None |
Integer | 2 | View | |
IVIVINDX | IV IV Index |
Long Integer | 4 | View | |
Stock_Serial_Lot_Count | Stock Serial Lot Count |
Currency | 10 | View | |
STCKSRLLTVRNC | Stock Serial Lot Variance |
Currency | 10 | View | |
IVVARIDX | IV Variances Index |
Long Integer | 4 | View | |
VARIANCEQTY | Variance Qty |
Currency | 10 | View | |
VERIFIED | Verified |
Boolean | 2 | View | |
Temp_Allocated_Quantity | Temp Allocated Quantity |
Currency | 10 | View | |
ACTIVE | Active 0 = False, for inactive records |
Boolean | 2 | View | |
Reason_Code | Reason Code |
String | 16 | View |