K_DEALDET - Deals Product Information

Dec 21, 2024

File Name . . . . K_DEALDET                            
   Library . . . .   K3S_5DTA                           
 Format Descr. . . Deals Product Information            
 Format Name . . . RK_DEALDET                           
 File Type . . . . PF            Unique Keys-  N        
                                                        
 Field Name FMT Start Lngth Dec Key Field Description   
 DL_COMP     A      1     1         Company ID          
 DL_BUYR     A      2     5         Buy group ID        
 DL_LOCN     A      7     5         Location ID         
 DL_DEAL     A     12     7         Deal ID             
 DL_SUPL     A     19    10         Supplier ID         
 DL_SUPLSUB  A     29    10         Sub supplier ID     
 DL_SUPLUSR  A     39    10         Supplier user system
 DL_SUPLUSB  A     49    10         Supplier user sub   
 DL_PROD     A     59    25         Product ID          
 DL_PRODSEQ  A     84    40         Product sequence #  
 DL_BEGIN    L    124    10         Deal begin date     
 DL_END      L    134    10         Deal end date       
 DL_BIRTH    L    144    10         Deal birth date     
 DL_LASTUPD  L    154    10         Deal last update    
 DL_BUYUSED  P    164     3   0     Deal buys used      
 DL_DATING   L    166    10         Dating date         
 DL_DATXTRA  P    176     3   0     Dating extra days

---