K_DEALHLD - Deal Hold Outs

Nov 5, 2024

File Name . . . . K_DEALHLD
  Library . . . .   K3S_5DTA
Format Descr. . . Inventory level by Supplier
Format Name . . . RK_DEALHLD
File Type . . . . PF            Unique Keys-  N

Field Name FMT Start Lngth Dec Key Field Description
DH_COMP     A      1     1         Company ID              
DH_BUYR     A      2     5         Buy group ID            
DH_LOCN     A      7     5         Location ID             
DH_SUPL     A     12    10         Supplier ID             
DH_SUPLSUB  A     22    10         Sub supplier ID         
DH_SUPLUSR  A     32    10         Supplier user system    
DH_SUPLUSB  A     42    10         Supplier user sub       
DH_PROD     A     52    25         Product ID              
DH_PRODSEQ  A     77    40         Product sequence #      
DH_DEAL     A    117     7         Deal ID                 
DH_DEALREF  A    124    10         Deal reference ID      
DH_BIRTH    L    134    10         Deal allow birth       
DH_LASTUPD  L    144    10         Deal allow last        
DH_BEGIN    L    154    10         Deal begin date        
DH_END      L    164    10         Deal end date          
DH_TYPE     A    174     2         Deal type              
DH_APPLY    A    176     1         Bill/Off/Auto code     
DH_EXCLUDE  P    177     1   0     FB exclude flag        
DH_FACTTYP  A    178     1         Factor type $,D,%      
DH_FACTVAL  P    179     9   4     Factor value           
DH_UNIT     P    184     5   0     Unit for dollars            
DH_UNITPRO  P    187     1   0     Unit protect flag           
DH_MINQTY   P    188     7   0     Minimum quantity            
DH_DATING   L    192    10         Dating date                 
DH_DATXTRA  P    202     3   0     Dating extra days           
DH_BUYALOW  P    204     3   0     Deal buys allowed           
DH_NOTE     A    206   100         Note                        
DH_PROCFLG  P    306     1   0     Processed flag              
DH_ERROR    P    307     1   0     Error flag                  
DH_EFFECTV  L    308    10         Deal Effective date  

---