K_SUPLDLY - Supplier Log of Order Delays

Nov 5, 2024

File Name . . . . K_SUPLDLY
   Library . . . .   K3S_5DTA
 Format Descr. . . Supplier log of order delays
 Format Name . . . RK_SUPLDLY
 File Type . . . . PF            Unique Keys-  N

 Field Name FMT Start Lngth Dec Key Field Description
 SB_COMP     A      1     1         Company ID
 SB_LOCN     A      2     5         Location ID
 SB_BUYR     A      7     5         Buy group ID
 SB_SUPL     A     12    10         Supplier ID
 SB_SUPLSUB  A     22    10         Sub supplier ID
 SB_BIRTH    L     32    10         Supplier log birth
 SB_USER     A     42    10         User ID for supplier
 SB_SOQTYPE  A     52     2         Suggest order type
 SB_DELAY    P     54     1   0     Order delay days
 SB_SPECOUT  P     55    13   3     Specified stock out $
 SB_EXPOUT0  P     62    13   3     Exp out $ delay 0 days
 SB_EXPOUT1  P     69    13   3     Exp out $ delay 1 days
 SB_EXPOUT2  P     76    13   3     Exp out $ delay 2 days
 SB_EXPOUT3  P     83    13   3     Exp out $ delay 3 days
 SB_EXPOUT4  P     90    13   3     Exp out $ delay 4 days
 SB_EXPOUT5  P     97    13   3     Exp out $ delay 5 days
 SB_CSTOHND  P    104    15   6     On hand  $ at cost
 SB_CSTOORD  P    112    15   6     On order $ at cost
 SB_CSTBSUM  P    120    15   6     Back sum $ at cost
 SB_CSTBALN  P    128    15   6     Balance  $ at cost
 SB_ALTSRCE  P    136     1   0     Alternate source order
 SB_ORDATE   L    137    10         Last order date
 SB_FXCFRQ   P    147     1   0     Fixed cycle frequency
 SB_FXCDAY   P    148     1   0     Fixed cycle day of wk
 SB_FXCLST   L    149    10         Fixed cycle last
 SB_FXCNXT   L    159    10         Fixed cycle next
 SB_ORCYCLE  P    169     3   0     Order cycle in days
 SB_ADD_DAY  P    171     3   0     Add days order point
 SB_CUR1LEV  P    173     1   0     Disc current level
 SB_CUR1TYP  P    174     1   0     Disc current 1st type
 SB_CUR1VAL  P    175     7   0     Disc current 1st value
 SB_CUR1UNT  P    179     1   0     Disc current 1st unit
 SB_CUR2TYP  P    180     1   0     Disc current 2nd type
 SB_CUR2VAL  P    181     7   0     Disc current 2nd value
 SB_CUR2UNT  P    185     1   0     Disc current 2nd unit
 SB_CHKREVU  P    186     5   0     RV products reviewed
 SB_CHKSOQ   P    189     5   0     SQ SOQ for product
 SB_CHKOPNT  P    192     5   0     OP order point
 SB_CHKSERV  P    195     5   0     SV service level
 SB_CHKOVER  P    198     5   0     OV over stocked
 SB_CHK6MON  P    201     5   0     SX over 6 month supply
 SB_CHKDISC  P    204     5   0     DS discontinued
 SB_CHKMANL  P    207     5   0     MN manual product
 SB_CHKNEW   P    210     5   0     NW new product
 SB_CHKWATC  P    213     5   0     WA watch product
 SB_CHKDEAL  P    216     5   0     DL deal exists
 SB_CHKFBUY  P    219     5   0     FB forward bought
 SB_CHKFBFL  P    222     5   0     FT forward buy filter
 SB_CHKBACK  P    225     5   0     BK back orders exist
 SB_CHKCONT  P    228     5   0     CT contracts exist
 SB_CHKREMI  P    231     5   0     RE reminders exist
 SB_CHKFREZ  P    234     5   0     FZ forecast freeze
 SB_CHKPROB  P    237     5   0     PR probation period
 SB_CHKALTS  P    240     5   0     AS alt source pending
 SB_CHKUSR1  P    243     5   0     U1 user defined 1
 SB_CHKUSR2  P    246     5   0     U2 user defined 2
 SB_CHKUSR3  P    249     5   0     U3 user defined 3
 SB_CHKUSR4  P    252     5   0     U4 user defined 4
 SB_REPLREG  P    255    13   4     Replen suggest regular
 SB_REPLNET  P    262    13   4     Replen suggest net cst
 SB_REPLWGT  P    269    13   3     Replen suggest weight
 SB_REPLVOL  P    276    13   3     Replen suggest volume
 SB_REPLPQT  P    283    13   4     Replen suggest pur inc
 SB_REPLOTH  P    290    13   4     Replen suggest other
 SB_ACTUREG  P    297    13   4     Actual suggest regular
 SB_ACTUNET  P    304    13   4     Actual suggest net cst
 SB_ACTUWGT  P    311    13   3     Actual suggest weight
 SB_ACTUVOL  P    318    13   3     Actual suggest volume
 SB_ACTUPQT  P    325    13   4     Actual suggest pur inc
 SB_ACTUOTH  P    332    13   4     Actual suggest other
 SB_JOINTEX  P    339     5   2     Joint extra days
 SB_REBLDOP  P    342     1   0     Rebuild discount level

---