K3S_5DTA - Main Database Files

K_LVOCLOG - Locations Variable Order Cycle – Log of Changes

File Name . . . . K_LVOCLOG                             
   Library . . . .   K3S_5DTA                            
 Format Descr. . . Locn var orcy Log of Changes          
 Format Name . . . RK_LVOCLOG                            
 File Type . . . . PF            Unique Keys-  N         
                                                         
 Field Name FMT Start Lngth Dec Key Field Description    
 VL_COMP     A      1     1         Company ID           
 VL_LOCN     A      2     5         Location ID          
 VL_CHGTYPE  A      7     1         Change type          
 VL_BIRTH    L      8    10         Var orc log birth    
 VL_BIRTHTM  T     18     8         Var orc birth time   
 VL_USER     A     26    10         User who made change 
 VL_WORKSTN  A     36    10         Workstation used     
 VL_PROGRAM  A     46    10         Program causing change
 VL_RECTYPE  A     56     1         Record types          
 VL_ORCYC01  P     57     3   0     Order cycle days 01   
 VL_ORCYC02  P     59     3   0     Order cycle days 02   
 VL_ORCYC03  P     61     3   0     Order cycle days 03   
 VL_ORCYC04  P     63     3   0     Order cycle days 04   
 VL_ORCYC05  P     65     3   0     Order cycle days 05   
 VL_ORCYC06  P     67     3   0     Order cycle days 06   
 VL_ORCYC07  P     69     3   0     Order cycle days 07   
 VL_ORCYC08  P     71     3   0     Order cycle days 08   
 VL_ORCYC09  P     73     3   0     Order cycle days 09   
 VL_ORCYC10  P     75     3   0     Order cycle days 10   
 VL_ORCYC11  P     77     3   0     Order cycle days 11   
 VL_ORCYC12  P     79     3   0     Order cycle days 12   
 VL_ORCYC13  P     81     3   0     Order cycle days 13   
 VL_ORCYC14  P     83     3   0     Order cycle days 14   
 VL_ORCYC15  P     85     3   0     Order cycle days 15   
 VL_ORCYC16  P     87     3   0     Order cycle days 16   
 VL_ORCYC17  P     89     3   0     Order cycle days 17   
 VL_ORCYC18  P     91     3   0     Order cycle days 18   
 VL_ORCYC19  P     93     3   0     Order cycle days 19   
 VL_ORCYC20  P     95     3   0     Order cycle days 20   
 VL_ORCYC21  P     97     3   0     Order cycle days 21   
 VL_ORCYC22  P     99     3   0     Order cycle days 22   
 VL_ORCYC23  P    101     3   0     Order cycle days 23   
 VL_ORCYC24  P    103     3   0     Order cycle days 24   
 VL_ORCYC25  P    105     3   0     Order cycle days 25   
 VL_ORCYC26  P    107     3   0     Order cycle days 26   
 VL_ORCYC27  P    109     3   0     Order cycle days 27   
 VL_ORCYC28  P    111     3   0     Order cycle days 28   
 VL_ORCYC29  P    113     3   0     Order cycle days 29   
 VL_ORCYC30  P    115     3   0     Order cycle days 30   
 VL_ORCYC31  P    117     3   0     Order cycle days 31   
 VL_ORCYC32  P    119     3   0     Order cycle days 32   
 VL_ORCYC33  P    121     3   0     Order cycle days 33   
 VL_ORCYC34  P    123     3   0     Order cycle days 34   
 VL_ORCYC35  P    125     3   0     Order cycle days 35   
 VL_ORCYC36  P    127     3   0     Order cycle days 36   
 VL_ORCYC37  P    129     3   0     Order cycle days 37   
 VL_ORCYC38  P    131     3   0     Order cycle days 38   
 VL_ORCYC39  P    133     3   0     Order cycle days 39   
 VL_ORCYC40  P    135     3   0     Order cycle days 40   
 VL_ORCYC41  P    137     3   0     Order cycle days 41   
 VL_ORCYC42  P    139     3   0     Order cycle days 42   
 VL_ORCYC43  P    141     3   0     Order cycle days 43   
 VL_ORCYC44  P    143     3   0     Order cycle days 44   
 VL_ORCYC45  P    145     3   0     Order cycle days 45   
 VL_ORCYC46  P    147     3   0     Order cycle days 46   
 VL_ORCYC47  P    149     3   0     Order cycle days 47   
 VL_ORCYC48  P    151     3   0     Order cycle days 48   
 VL_ORCYC49  P    153     3   0     Order cycle days 49   
 VL_ORCYC50  P    155     3   0     Order cycle days 50   
 VL_ORCYC51  P    157     3   0     Order cycle days 51   
 VL_ORCYC52  P    159     3   0     Order cycle days 52   
 VL_LEADUSE  P    161     1   0     Lead time use flag    
 VL_LEADT01  P    162     3   0     Lead time orders 01   
 VL_LEADT02  P    164     3   0     Lead time orders 02   
 VL_LEADT03  P    166     3   0     Lead time orders 03   
 VL_LEADT04  P    168     3   0     Lead time orders 04   
 VL_LEADT05  P    170     3   0     Lead time orders 05   
 VL_LEADT06  P    172     3   0     Lead time orders 06   
 VL_LEADT07  P    174     3   0     Lead time orders 07   
 VL_LEADT08  P    176     3   0     Lead time orders 08   
 VL_LEADT09  P    178     3   0     Lead time orders 09   
 VL_LEADT10  P    180     3   0     Lead time orders 10   
 VL_LEADT11  P    182     3   0     Lead time orders 11   
 VL_LEADT12  P    184     3   0     Lead time orders 12   
 VL_LEADT13  P    186     3   0     Lead time orders 13   
 VL_LEADT14  P    188     3   0     Lead time orders 14   
 VL_LEADT15  P    190     3   0     Lead time orders 15   
 VL_LEADT16  P    192     3   0     Lead time orders 16   
 VL_LEADT17  P    194     3   0     Lead time orders 17   
 VL_LEADT18  P    196     3   0     Lead time orders 18   
 VL_LEADT19  P    198     3   0     Lead time orders 19   
 VL_LEADT20  P    200     3   0     Lead time orders 20   
 VL_LEADT21  P    202     3   0     Lead time orders 21   
 VL_LEADT22  P    204     3   0     Lead time orders 22   
 VL_LEADT23  P    206     3   0     Lead time orders 23   
 VL_LEADT24  P    208     3   0     Lead time orders 24   
 VL_LEADT25  P    210     3   0     Lead time orders 25   
 VL_LEADT26  P    212     3   0     Lead time orders 26   
 VL_LEADT27  P    214     3   0     Lead time orders 27   
 VL_LEADT28  P    216     3   0     Lead time orders 28   
 VL_LEADT29  P    218     3   0     Lead time orders 29   
 VL_LEADT30  P    220     3   0     Lead time orders 30   
 VL_LEADT31  P    222     3   0     Lead time orders 31   
 VL_LEADT32  P    224     3   0     Lead time orders 32   
 VL_LEADT33  P    226     3   0     Lead time orders 33   
 VL_LEADT34  P    228     3   0     Lead time orders 34   
 VL_LEADT35  P    230     3   0     Lead time orders 35   
 VL_LEADT36  P    232     3   0     Lead time orders 36   
 VL_LEADT37  P    234     3   0     Lead time orders 37   
 VL_LEADT38  P    236     3   0     Lead time orders 38   
 VL_LEADT39  P    238     3   0     Lead time orders 39   
 VL_LEADT40  P    240     3   0     Lead time orders 40   
 VL_LEADT41  P    242     3   0     Lead time orders 41   
 VL_LEADT42  P    244     3   0     Lead time orders 42   
 VL_LEADT43  P    246     3   0     Lead time orders 43   
 VL_LEADT44  P    248     3   0     Lead time orders 44   
 VL_LEADT45  P    250     3   0     Lead time orders 45   
 VL_LEADT46  P    252     3   0     Lead time orders 46   
 VL_LEADT47  P    254     3   0     Lead time orders 47   
 VL_LEADT48  P    256     3   0     Lead time orders 48   
 VL_LEADT49  P    258     3   0     Lead time orders 49   
 VL_LEADT50  P    260     3   0     Lead time orders 50   
 VL_LEADT51  P    262     3   0     Lead time orders 51   
 VL_LEADT52  P    264     3   0     Lead time orders 52   
 VL_LEADV01  P    266     3   1     Lead time var % 01    
 VL_LEADV02  P    268     3   1     Lead time var % 02    
 VL_LEADV03  P    270     3   1     Lead time var % 03    
 VL_LEADV04  P    272     3   1     Lead time var % 04    
 VL_LEADV05  P    274     3   1     Lead time var % 05    
 VL_LEADV06  P    276     3   1     Lead time var % 06    
 VL_LEADV07  P    278     3   1     Lead time var % 07    
 VL_LEADV08  P    280     3   1     Lead time var % 08    
 VL_LEADV09  P    282     3   1     Lead time var % 09    
 VL_LEADV10  P    284     3   1     Lead time var % 10    
 VL_LEADV11  P    286     3   1     Lead time var % 11   
 VL_LEADV12  P    288     3   1     Lead time var % 12    
 VL_LEADV13  P    290     3   1     Lead time var % 13     
 VL_LEADV14  P    292     3   1     Lead time var % 14    
 VL_LEADV15  P    294     3   1     Lead time var % 15    
 VL_LEADV16  P    296     3   1     Lead time var % 16    
 VL_LEADV17  P    298     3   1     Lead time var % 17    
 VL_LEADV18  P    300     3   1     Lead time var % 18    
 VL_LEADV19  P    302     3   1     Lead time var % 19    
 VL_LEADV20  P    304     3   1     Lead time var % 20    
 VL_LEADV21  P    306     3   1     Lead time var % 21    
 VL_LEADV22  P    308     3   1     Lead time var % 22    
 VL_LEADV23  P    310     3   1     Lead time var % 23    
 VL_LEADV24  P    312     3   1     Lead time var % 24    
 VL_LEADV25  P    314     3   1     Lead time var % 25    
 VL_LEADV26  P    316     3   1     Lead time var % 26    
 VL_LEADV27  P    318     3   1     Lead time var % 27    
 VL_LEADV28  P    320     3   1     Lead time var % 28    
 VL_LEADV29  P    322     3   1     Lead time var % 29    
 VL_LEADV30  P    324     3   1     Lead time var % 30    
 VL_LEADV31  P    326     3   1     Lead time var % 31    
 VL_LEADV32  P    328     3   1     Lead time var % 32    
 VL_LEADV33  P    330     3   1     Lead time var % 33    
 VL_LEADV34  P    332     3   1     Lead time var % 34    
 VL_LEADV35  P    334     3   1     Lead time var % 35    
 VL_LEADV36  P    336     3   1     Lead time var % 36    
 VL_LEADV37  P    338     3   1     Lead time var % 37    
 VL_LEADV38  P    340     3   1     Lead time var % 38    
 VL_LEADV39  P    342     3   1     Lead time var % 39    
 VL_LEADV40  P    344     3   1     Lead time var % 40    
 VL_LEADV41  P    346     3   1     Lead time var % 41    
 VL_LEADV42  P    348     3   1     Lead time var % 42    
 VL_LEADV43  P    350     3   1     Lead time var % 43    
 VL_LEADV44  P    352     3   1     Lead time var % 44    
 VL_LEADV45  P    354     3   1     Lead time var % 45    
 VL_LEADV46  P    356     3   1     Lead time var % 46    
 VL_LEADV47  P    358     3   1     Lead time var % 47    
 VL_LEADV48  P    360     3   1     Lead time var % 48    
 VL_LEADV49  P    362     3   1     Lead time var % 49    
 VL_LEADV50  P    364     3   1     Lead time var % 50    
 VL_LEADV51  P    366     3   1     Lead time var % 51    
 VL_LEADV52  P    368     3   1     Lead time var % 52    
 VL_DOWMAP   P    370     1   0     Day of week map flag  
 VL_DOWPER1  P    371     5   2     Day of week % 1=Sun   
 VL_DOWPER2  P    374     5   2     Day of week % 2=Mon   
 VL_DOWPER3  P    377     5   2     Day of week % 3=Tue   
 VL_DOWPER4  P    380     5   2     Day of week % 4=Wed   
 VL_DOWPER5  P    383     5   2     Day of week % 5=Thu   
 VL_DOWPER6  P    386     5   2     Day of week % 6=Fri   
 VL_DOWPER7  P    389     5   2     Day of week % 7=Sat   
 VL_SSTPER1  P    392     5   2     Safety stock % 1=Sun  
 VL_SSTPER2  P    395     5   2     Safety stock % 2=Mon  
 VL_SSTPER3  P    398     5   2     Safety stock % 3=Tue  
 VL_SSTPER4  P    401     5   2     Safety stock % 4=Wed  
 VL_SSTPER5  P    404     5   2     Safety stock % 5=Thu  
 VL_SSTPER6  P    407     5   2     Safety stock % 6=Fri  
 VL_SSTPER7  P    410     5   2     Safety stock % 7=Sat