K_SUPLIER - Suppliers

Nov 5, 2024

File Name . . . . K_SUPLIER
   Library . . . .   K3S_5DTA
 Format Descr. . . Suppliers
 Format Name . . . RK_SUPLIER
 File Type . . . . PF            Unique Keys-  N

 Field Name FMT Start Lngth Dec Key Field Description
 SP_COMP     A      1     1         Company ID
 SP_BUYR     A      2     5         Buy group ID
 SP_REGN     A      7     5         Region ID
 SP_LOCN     A     12     5         Location ID
 SP_SUPL     A     17    10         Supplier ID
 SP_SUPLSUB  A     27    10         Sub supplier ID
 SP_ALTSRCE  P     37     1   0     Altr source supplier
 SP_TEMPORY  P     38     1   0     Temporary record flag
 SP_NAME     A     39    40         Supplier name
 SP_DISPSEQ  A     79    20         Display sequence
 SP_GROUP1   A     99    10         Supplier group 1
 SP_GROUP2   A    109    10         Supplier group 2
 SP_GROUP3   A    119    10         Supplier group 3
 SP_GROUP4   A    129    10         Supplier group 4
 SP_GROUP5   A    139    10         Supplier group 5
 SP_BIRTH    L    149    10         Supplier birth date
 SP_LASTUPD  L    159    10         Supplier last update
 SP_ORDATE   L    169    10         Last order date
 SP_RVDATE   L    179    10         Last review date
 SP_FXCFRQ   P    189     1   0     Fixed cycle frequency
 SP_FXCDAY   P    190     1   0     Fixed cycle day of wk
 SP_FXCLST   L    191    10         Fixed cycle last
 SP_FXCNXT   L    201    10         Fixed cycle next
 SP_HEADCST  P    211     7   2     Order header cost
 SP_LINECST  P    215     5   2     Order line cost
 SP_LEADTMQ  P    218     3   0     Lead time quoted
 SP_LEADTMO  P    220     3   0     Lead time orders
 SP_LEADTMV  P    222     3   1     Lead time variance %
 SP_LEADTMS  P    224     3   3     Lead time smooth err
 SP_LEADTMT  P    226     3   3     Lead time tracking
 SP_ORCYCLE  P    228     3   0     Order cycle in days
 SP_SERVICE  P    230     3   1     Serv level target %
 SP_SVCEPRV  P    232     5   2     Serv level prv perd %
 SP_SOQSEQ#  P    235     5   0     Suggest order seq #
 SP_RNKBUY$  P    238     7   0     Supl rank buyr dollars
 SP_RNKBUYU  P    242     7   0     Supl rank buyr units
 SP_RNKLOC$  P    246     7   0     Supl rank locn dollars
 SP_RNKLOCU  P    250     7   0     Supl rank locn units
 SP_RNKCOM$  P    254     7   0     Supl rank comp dollars
 SP_RNKCOMU  P    258     7   0     Supl rank comp units
 SP_RNKDATE  L    262    10         Supl rank last update
 SP_MAXDAYS  P    272     3   0     Maximum frw buy days
 SP_ADD_DAY  P    274     3   0     Add days order point
 SP_PRECISE  P    276     1   0     Precise order flag
 SP_AUTOPO   P    277     1   0     Auto PO flag
 SP_POTYPE   A    278     1         PO type default
 SP_DISCBKT  P    279     1   0     Discount bracket level
 SP_BRKOTHR  A    280     8         Bracket build other
 SP_ACTPROD  P    288     5   0     Number active products
 SP_RECALC   P    291     1   0     Re-calculate components
 SP_CONVPKP  P    292     3   1     Convenience pack %
 SP_DSPTOT1  P    294     1   0     Order total unit 1st
 SP_DSPTOT2  P    295     1   0     Order total unit 2nd
 SP_PROCALT  P    296     1   0     Process alt srce flag
 SP_REBATE   P    297     3   1     Rebate factor %
 SP_CASHDSC  P    299     3   1     Cash discount %
 SP_PREFSEQ  P    301     3   0     Preference sequence
 SP_REQSPLT  P    303     1   0     Required split flag
 SP_REPCARY  P    304     3   1     Replenish carry rate %
 SP_SPLTYPE  A    306     3         Order split type
 SP_SPLUNIT  P    309     1   0     Order split unit
 SP_SPLVALU  P    310     7   0     Order split value
 SP_COMFLAG  P    314     1   0     Combined supplier flag
 SP_COMSUPL  A    315    10         Combined supplier ID
 SP_COMSUB   A    325    10         Combined sub supplier
 SP_EXCLEAD  P    335     1   0     Exclude LT forecasting
 SP_CMBTYPE  P    336     1   0     Comb supl prod seq typ
 SP_HIDEORD  P    337     1   0     Hide suggested order?
 SP_USERA1   A    338     1         User defined alpha 1
 SP_USERA2   A    339     3         User defined alpha 2
 SP_USERA3   A    342    10         User defined alpha 3
 SP_USERN1   P    352     5   0     User defined number 1
 SP_USERN2   P    355     7   2     User defined number 2
 SP_USERN3   P    359    11   4     User defined number 3
 SP_ZIPCODE  A    365    10         Zip code
 SP_SND_PO1  A    375    40         Email PO address 1
 SP_SND_PO2  A    415    40         Email PO address 2

---