K_SUPLSOQ - Supplier Suggested Orders

Nov 5, 2024

File Name . . . . K_SUPLSOQ
   Library . . . .   K3S_5DTA
 Format Descr. . . Supplier suggested orders
 Format Name . . . RK_SUPLSOQ
 File Type . . . . PF            Unique Keys-  N

 Field Name FMT Start Lngth Dec Key Field Description
 SO_COMP     A      1     1         Company ID
 SO_LOCN     A      2     5         Location ID
 SO_BUYR     A      7     5         Buy group ID
 SO_SUPL     A     12    10         Supplier ID
 SO_SUPLSUB  A     22    10         Sub supplier ID
 SO_NAME     A     32    40         Supplier name
 SO_DISPSEQ  A     72    20         Display sequence
 SO_SOQSEQ#  P     92     5   0     Suggest order seq #
 SO_ORDBUSY  P     95     1   0     Order busy flag
 SO_LCKUSER  A     96    10         User who locked order
 SO_LCKTIME  T    106     8         Time order was locked
 SO_SOQTYPE  A    114     2         Suggest order type
 SO_PO#      A    116    10         Purchase order #
 SO_BRKOTHR  A    126     8         Bracket build other
 SO_BIRTH    L    134    10         Supl SOQ birth date
 SO_GROUP    A    144    10         Supplier product group
 SO_ALTSRCE  P    154     1   0     Alternate source order
 SO_TEMPORY  P    155     1   0     Temporary record flag
 SO_ORDATE   L    156    10         Last order date
 SO_RVDATE   L    166    10         Last review date
 SO_EXPDELV  L    176    10         Expected delivery date
 SO_FXCFRQ   P    186     1   0     Fixed cycle frequency
 SO_FXCDAY   P    187     1   0     Fixed cycle day of wk
 SO_FXCLST   L    188    10         Fixed cycle last
 SO_FXCNXT   L    198    10         Fixed cycle next
 SO_HEADCST  P    208     7   2     Order header cost
 SO_LEADTMQ  P    212     3   0     Lead time quoted
 SO_LEADTMO  P    214     3   0     Lead time orders
 SO_LEADTMV  P    216     3   1     Lead time variance %
 SO_ORCYCLE  P    218     3   0     Order cycle in days
 SO_SERVICE  P    220     3   1     Serv level target %
 SO_MAXDAYS  P    222     3   0     Maximum frw buy days
 SO_ADD_DAY  P    224     3   0     Add days order point
 SO_PRECISE  P    226     1   0     Precise order flag
 SO_AUTOPO   P    227     1   0     Auto PO flag
 SO_POTYPE   A    228     1         PO type
 SO_RECALC   P    229     1   0     Re-calculate components
 SO_CUR1LEV  P    230     1   0     Disc current level
 SO_CUR1TYP  P    231     1   0     Disc current 1st type
 SO_CUR1VAL  P    232     7   0     Disc current 1st value
 SO_CUR1UNT  P    236     1   0     Disc current 1st unit
 SO_CUR2TYP  P    237     1   0     Disc current 2nd type
 SO_CUR2VAL  P    238     7   0     Disc current 2nd value
 SO_CUR2UNT  P    242     1   0     Disc current 2nd unit
 SO_CURRATE  P    243     3   1     Disc current rate %
 SO_CURSAVG  P    245     5   0     Disc current savings
 SO_NXT1LEV  P    248     1   0     Disc next level
 SO_NXT1TYP  P    249     1   0     Disc next 1st type
 SO_NXT1VAL  P    250     7   0     Disc next 1st value
 SO_NXT1UNT  P    254     1   0     Disc next 1st unit
 SO_NXT2TYP  P    255     1   0     Disc next 2nd type
 SO_NXT2VAL  P    256     7   0     Disc next 2nd value
 SO_NXT2UNT  P    260     1   0     Disc next 2nd unit
 SO_NXTRATE  P    261     3   1     Disc next rate %
 SO_NXTSAVG  P    263     5   0     Disc next savings
 SO_CHKREVU  P    266     5   0     RV products reviewed
 SO_CHKSOQ   P    269     5   0     SQ SOQ for product
 SO_CHKOPNT  P    272     5   0     OP order point
 SO_CHKSERV  P    275     5   0     SV service level
 SO_CHKOVER  P    278     5   0     OV over stocked
 SO_CHK6MON  P    281     5   0     SX over 6 month supply
 SO_CHKDISC  P    284     5   0     DS discontinued
 SO_CHKMANL  P    287     5   0     MN manual product
 SO_CHKNEW   P    290     5   0     NW new product
 SO_CHKWATC  P    293     5   0     WA watch product
 SO_CHKDEAL  P    296     5   0     DL deal exists
 SO_CHKFBUY  P    299     5   0     FB forward bought
 SO_CHKFBFL  P    302     5   0     FT forward buy filter
 SO_CHKBACK  P    305     5   0     BK back orders exist
 SO_CHKCONT  P    308     5   0     CT contracts exist
 SO_CHKREMI  P    311     5   0     RM reminders exist
 SO_CHKFREZ  P    314     5   0     FZ forecast freeze
 SO_CHKPROB  P    317     5   0     PR probation period
 SO_CHKCHG   P    320     5   0     CG changes re-calc ord
 SO_CHKALTS  P    323     5   0     AS alt source pending
 SO_CHKUSR1  P    326     5   0     U1 user defined 1
 SO_CHKUSR2  P    329     5   0     U2 user defined 2
 SO_CHKUSR3  P    332     5   0     U3 user defined 3
 SO_CHKUSR4  P    335     5   0     U4 user defined 4
 SO_REPLREG  P    338    13   4     Replen suggest regular
 SO_REPLNET  P    345    13   4     Replen suggest net cst
 SO_REPLWGT  P    352    13   3     Replen suggest weight
 SO_REPLVOL  P    359    13   3     Replen suggest volume
 SO_REPLPQT  P    366    13   4     Replen suggest pur inc
 SO_REPLOTH  P    373    13   4     Replen suggest other
 SO_REPLUN7  P    380    13   4     Replen suggest unit 7
 SO_REPLUN8  P    387    13   4     Replen suggest unit 8
 SO_REPLUN9  P    394    13   4     Replen suggest unit 9
 SO_ACTUREG  P    401    13   4     Actual suggest regular
 SO_ACTUNET  P    408    13   4     Actual suggest net cst
 SO_ACTUWGT  P    415    13   3     Actual suggest weight
 SO_ACTUVOL  P    422    13   3     Actual suggest volume
 SO_ACTUPQT  P    429    13   4     Actual suggest pur inc
 SO_ACTUOTH  P    436    13   4     Actual suggest other
 SO_ACTUUN7  P    443    13   4     Actual suggest unit 7
 SO_ACTUUN8  P    450    13   4     Actual suggest unit 8
 SO_ACTUUN9  P    457    13   4     Actual suggest unit 9
 SO_JOINT    P    464     3   0     Joint order delay days
 SO_JOINTEX  P    466     5   2     Joint extra days
 SO_REBLDOP  P    469     1   0     Rebuild discount level
 SO_SPL1TYP  A    470     3         Split 1st type
 SO_SPL1PRT  A    473     3         Split 1st part
 SO_SPL2TYP  A    476     3         Split 2nd type
 SO_SPL2PRT  A    479     3         Split 2nd part
 SO_DSPTOT1  P    482     1   0     Order total unit 1st
 SO_DSPTOT2  P    483     1   0     Order total unit 2nd
 SO_REBATE   P    484     3   1     Rebate factor %
 SO_CASHDSC  P    486     3   1     Cash discount %
 SO_PREFSEQ  P    488     3   0     Preference sequence
 SO_REQSPLT  P    490     1   0     Required split flag
 SO_REPCARY  P    491     3   1     Replenish carry rate %
 SO_CMBLOCN  A    493     5         Combined location ID
 SO_CMBSUPL  A    498    10         Combined supplier ID
 SO_CMBSUB   A    508    10         Combined sub supplier
 SO_USER     A    518    10         User ID
 SO_USERA1   A    528     1         User defined alpha 1
 SO_USERA2   A    529     3         User defined alpha 2
 SO_USERA3   A    532    10         User defined alpha 3
 SO_USERN1   P    542     5   0     User defined number 1
 SO_USERN2   P    545     7   2     User defined number 2
 SO_USERN3   P    549    11   4     User defined number 3
 SO_ZIPCODE  A    555    10         Zip code
 SO_SND_PO1  A    565    40         Email PO address 1
 SO_SND_PO2  A    605    40         Email PO address 2

---