K_INTCSTJ - Interface Customer Detail

Nov 5, 2024

File Name . . . . K_INTCSTJ                            
   Library . . . .   K3S_5DTA                           
 Format Descr. . . Interface customer detail            
 Format Name . . . RK_INTCSTJ                           
 File Type . . . . PF            Unique Keys-  N        
                                                        
 Field Name FMT Start Lngth Dec Key Field Description   
 IJ_COMP     A      1     1         Company ID          
 IJ_BIRTH    L      2    10         Interface birth date
 IJ_BATCH#   P     12     3   0     Batch #             
 IJ_SUPL     A     14    10         Supplier ID         
 IJ_SUPLSUB  A     24    10         Sub supplier ID     
 IJ_PROD     A     34    25         Product ID          
 IJ_QTYOHND  P     59     7   0     Quantity on hand    
 IJ_NOTACTV  P     63     1   0     Not active K_PRODUCT
 IJ_BUYR     A     64     5         Buy group ID        
 IJ_LOCN     A     69     5         Location ID 


Possible codes for field IJ_NOTACTV:

0 = Inventory recieved; product is setup for re-order in K3S Store level files 
1 = Inventory received; product is NOT setup for re-order in K3S Store level files  
2 = No inveintory recieved; create a record of 0 quantity on hand (Red Zero)
3 = Inventory received but product is in delete count mode
4 = Inventory of zero on hand received (Regular Zero)
5 = Negative inventory received; assume zero on hand 

---