K_INTORDL - Log of User Actions of Approved Orders

Nov 5, 2024

File Name . . . . K_INTORDL                             
   Library . . . .   K3S_5DTA                            
 Format Descr. . . Log of User Actions of Approved Orders           
 Format Name . . . RK_INTORDL                            
 File Type . . . . PF            Unique Keys-  N         
                                                         
 Field Name FMT Start Lngth Dec Key Field Description    
 AL_COMP     A      1     1         Company ID           
 AL_LOCN     A      2     5         Location ID          
 AL_BUYR     A      7     5         Buy group ID         
 AL_SUPL     A     12    10         Supplier ID           
 AL_SUPLSUB  A     22    10         Sub supplier ID       
 AL_PO#      A     32    10         PO number             
 AL_BIRTH    L     42    10         Order header birth   
 AL_LASTUPD  L     52    10         Order header last    
 AL_DOLRUP   P     62    11   0     Adjusted Dollar UP 
 AL_DOLRDW   P     68    11   0     Adjusted Dollar Down 
 AL_DAYLATE  P     74     5   0     Days due before placing order 
 AL_ACTUREG  P     77     9   0     PO Regular Price
 AL_ACTUNET  P     82     9   0     PO Net Cost
 AL_ACTWGHT  P     87     9   0     PO Weight
 AL_ACTUVOL  P     92     9   0     PO Volume
 AL_ACTUPQT  P     97     9   0     PO Purchase Increase
 AL_ACTUOTH  P    102     9   0     PO Other Costs
 AL_ACTUUN7  P    107     9   0     PO Unit 7
 AL_ACTUUN8  P    112     9   0     PO Unit 8
 AL_ACTUUN9  P    117     9   0     PO Unit 9
 AL_IGNORE   A    122     1         0=Active - 1 = Purged
 AL_RECEIVE  A    123     1         0=Pending - 1 = Received 
 AL_AGEOLD   P    124     3   0     Nbr Days Recvd. After Expected

 AL_RECEIVE Status Legend
 0 = Open Order
 1 = Fully Received
 2 = Partial Received
 3 = Partial & Over Received
 4 = Over Received
 5 = Late For Receiving
 6 = PO Adjusted After Approval In K3S 
 8 = PO Placed Outside of K3S
 9 = Placed Today
 C = All Items Cut From Order / PO Cancelled
 I = Ignore PO Status Check

 AL_AGEOLD Status Legend
 -999 = Not Received Yet 
 =0   = Arrived On Expected Date
 >0   = Days Arrived After Expected Date
 <0   = Days Arrived Before Expected Date
 
AL_IGNORE is used to hide or display a PO. 
1=hide
0=display
The users can change this value

---