Ga naar inhoud

Table Istorie_OutDetails

Purpose

Field definitions in table Istorie_OutDetails

No. Used Name Type Reqd. Description
1 AVIZNO VARCHAR(50) Y
2 ARTCODE VARCHAR(50) Y
3 QTYASKED DOUBLE Y
4 QTY DOUBLE Y
5 N AMBALAJ VARCHAR(20) N No longer used.
6 COMMENTS VARCHAR(100) N
7 OLDAMB VARCHAR(20) N
8 N COLOR VARCHAR(50) N No longer used.
9 INVOICENO VARCHAR(50) N
10 STOCKCODE VARCHAR(50) N
11 ROWNO INT Y
12 PCNAME VARCHAR(50) N
13 FILLDATE TIMESTAMP N
14 QTYCF DOUBLE N
15 DATACF TIMESTAMP N
16 LSBFILE VARCHAR(50) N
17 FILLTIME VARCHAR(20) N
18 BPOINTS VARCHAR(20) N
19 QTYSOFT DOUBLE N
20 UNITVALUE DOUBLE N
21 CURENCY VARCHAR(50) N
22 TotalValue DOUBLE N
23 TCurency VARCHAR(50) N
24 PICKEDBY VARCHAR(50) N
25 MODIFYQTY DOUBLE N
26 MODIFY VARCHAR(1) N
27 TIMECF VARCHAR(20) N
28 LSBDATE TIMESTAMP N
29 LSBTIME VARCHAR(20) N
30 CHECKEDQTY DOUBLE N
31 CHECKEDBY VARCHAR(50) N
32 CHECKEDDATE TIMESTAMP N
33 CHECKEDTIME VARCHAR(20) N
34 PICKEDBY2 VARCHAR(50) N
35 COLNO INT N
36 COLQTY INT N
37 COLDATE VARCHAR(20) N
38 TransactionType VARCHAR(50) N
39 TransitLocation VARCHAR(50) N
40 ID INT N
41 RecordClosed VARCHAR(1) N
42 OriginalImpRow VARCHAR(250) N
43 MasterQTY NUMERIC(0,18) N
44 Grouped VARCHAR(50) N
45 CGROUPID VARCHAR(50) N
46 UnitQTY NUMERIC(0,18) N
47 RealMasterQTY NUMERIC(0,18) N
48 PickingLocation VARCHAR(50) N
49 SugestedLocation VARCHAR(50) N

Indexes