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 |