K_PURCHIS - Purchase History

Nov 5, 2024

File Name . . . . K_PURCHIS
   Library . . . .   K3S_5DTA
 Format Descr. . . Purchase History
 Format Name . . . RK_PURCHIS
 File Type . . . . PF            Unique Keys-  N
             
 Field Name FMT Start Lngth Dec Key Field Description
 PS_COMP     A      1     1         Company ID
 PS_BUYR     A      2     5         Buy group ID
 PS_REGN     A      7     5         Region ID
 PS_LOCN     A     12     5         Location ID
 PS_PO       A     17    10         Purchase order ID
 PS_SUPL     A     27    10         Supplier ID
 PS_SUPLSUB  A     37    10         Sub supplier ID
 PS_SUPLUSR  A     47    10         Supplier user system
 PS_SUPLUSB  A     57    10         Supplier user sub
 PS_PROD     A     67    25         Product ID
 PS_PRODSEQ  A     92    40         Product sequence #
 PS_DESC1    A    132    40         Product description 1
 PS_DESC2    A    172    40         Product description 2
 PS_NDC_UPC  A    212    25         NDC/UPC code
 PS_MFG      A    237    25         Manufactor ID
 PS_UOM      A    262     4         Unit of measure
 PS_PACKSIZ  A    266    10         Pack /size
 PS_TIHI     A    276    10         Ti /hi
 PS_GROUP1   A    286    10         Group 1
 PS_GROUP2   A    296    10         Group 2
 PS_GROUP3   A    306    10         Group 3
 PS_GROUP4   A    316    10         Group 4
 PS_GROUP5   A    326    10         Group 5
 PS_WHSLOCN  A    336    10         Warehouse location
 PS_BIRTH    L    346    10         Purch hst birth date
 PS_LASTUPD  L    356    10         Purch hst last update
 PS_LEADTM   P    366     3   0     Lead time in days
 PS_LEADTMO  P    368     3   0     Lead time orders
 PS_OPOINTU  P    370     7   0     Order point units
 PS_OPOINTD  P    374     3   0     Order point days
 PS_ORUPTOU  P    376     7   0     Order up to units
 PS_ORUPTOD  P    380     3   0     Order up to days
 PS_COSTREG  P    382    11   4     Product cost regular
 PS_COSTDIV  P    388     5   0     Product cost divisor
 PS_COSTEAC  P    391    13   6     Product cost each
 PS_COSTORD  P    398    11   4     Product cost orders
 PS_COSTLST  P    404    11   4     Product cost last
 PS_COSTLDT  L    410    10         Product cost last chg
 PS_SALES    P    420    11   4     Product sales price
 PS_QTYOHND  P    426     7   0     Quantity on hand
 PS_QTYOORD  P    430     7   0     Quantity on order
 PS_QTYBACK  P    434     7   0     Quantity back ordered
 PS_QTYHOLD  P    438     7   0     Quantity hold out
 PS_QTYPEND  P    442     7   0     Quantity transfer pend
 PS_QTYBALN  P    446     7   0     Quantity balance
 PS_PROMQTY  P    450     7   0     Promotional quantity
 PS_PROMBEG  L    454    10         Promotional begin date            
 PS_PROMEND  L    464    10         Promotional end date
 PS_PTDDEM   P    474     7   0     Period to date demand
 PS_BUYSTAT  A    478     1         Buy grp status D,M,W
 PS_SYSSTAT  A    479     1         Sys status N,R,L,S
 PS_SOQSRVC  P    480     7   0     Suggested qty service
 PS_SOQNITE  P    484     7   0     Suggested qty night
 PS_SOQACT   P    488     7   0     Suggested qty actual
 PS_SOQOVRD  L    492    10         Suggested qty ovr-ride
 PS_FORCAST  P    502     9   2     Demand forecast
 PS_FORFREZ  L    507    10         Forecast freeze until
 PS_PROBDAT  L    517    10         On probation until
 PS_FORDEVP  P    527     3   1     Demand forecast DEV %
 PS_FORSERR  P    529     3   3     Demand forecast SERR
 PS_FORCHG   A    531     1         Source forecast chg
 PS_MINQTY   P    532     7   0     Minimum quantity
 PS_BUYMULT  P    536     7   0     Buy multiple
 PS_BUYMULO  P    540     7   0     Buy mult over-ride
 PS_CONVPAK  P    544     7   0     Convenience pack
 PS_DAYSOUT  P    548     3   0     Days out this period
 PS_DAYSUNT  P    550     3   0     Days out point units
 PS_INTRVAL  P    552     5   0     Econ ordr intrval days
 PS_OTIMFAC  P    555     3   0     Order time factor
 PS_DELAY    P    557     3   0     Product delay days
 PS_MAXDAYS  P    559     3   0     Maximum frw buy days
 PS_MAMINID  P    561     3   0     Manual minimum days
 PS_MAMAXID  P    563     3   0     Manual maximum days
 PS_MAMINIU  P    565     7   0     Manual minimum units
 PS_MAMAXIU  P    569     7   0     Manual maximum units
 PS_SSTFDAY  P    573     3   0     Safety stock days
 PS_FBXDAYS  P    575     3   0     ForBuy extra days
 PS_ADD_DAY  P    577     3   0     Add days order point
 PS_ANSALE$  P    579    13   2     Annual sales dollars
 PS_ANSALEU  P    586    13   2     Annual sales units
 PS_DEVTIMF  P    593     7   3     DEV time factor
 PS_SSTIMEF  P    597     9   3     SS time factor
 PS_SAFESUM  P    602    11   3     SS sum of components
 PS_VOLUME   P    608     7   3     Unit volume
 PS_VOLUMEO  P    612     7   3     Unit volume over-ride
 PS_VOLUMED  P    616     5   0     Volume divisor
 PS_VOLUMDO  P    619     5   0     Volume divisor ovrride
 PS_WEIGHT   P    622     7   3     Unit weight
 PS_WEIGHTO  P    626     7   3     Unit weight over-ride
 PS_WEIGHTD  P    630     5   0     Weight divisor
 PS_WEIGHDO  P    633     5   0     Weight divisor ovrride
 PS_PURINCR  P    636     7   0     Purchase increment
 PS_DISOTHR  P    640     9   4     Bracket build other
 PS_SEASONL  A    645    10         Seasonal profile ID
 PS_SVCELVL  P    655     3   1     Serv level target %
 PS_SVCEORD  P    657     3   1     Serv level orders %
 PS_SVCEPRV  P    659     5   2     Serv level prv perd %
 PS_FORCINT  P    662     3   0     Forecast interval
 PS_FORCPER  P    664     3   0     Forecast period
 PS_SOQSEQ#  P    666     5   0     Suggest order seq #
 PS_SOQRPER  P    669     3   1     SOQ rounding %
 PS_LONGTRN  P    671     3   2     Long term trend rate
 PS_DELTCNT  P    673     1   0     Delete count days
 PS_SPLTPER  P    674     1   0     Split code permanent
 PS_SPLTTMP  P    675     1   0     Split code temporary
 PS_ENDPER   P    676     1   0     End of period code
 PS_ENDPERS  P    677     1   0     End of period code sav
 PS_FBUYDAT  L    678    10         Forward bought date
 PS_LORDDAT  L    688    10         Last ordered date
 PS_LRCVDAT  L    698    10         Last received date
 PS_LSTXDAT  L    708    10         Last interface date
 PS_SELFBPI  P    718     5   3     Selct frd buy pri incr
 PS_SELFBDS  P    721     5   3     Selct frd buy discount
 PS_SELFBMD  P    724     5   3     Selct frd buy mnl days
 PS_SELFBXD  P    727     5   3     Selct frd buy xtr days
 PS_ACCSALE  P    730     7   0     Accumulated sales PTD
 PS_ACCOUTS  P    734     7   0     Accumulated outs PTD
 PS_RNKBUY$  P    738     7   0     Prod rank buyr dollars
 PS_RNKBUYU  P    742     7   0     Prod rank buyr units
 PS_RNKLOC$  P    746     7   0     Prod rank locn dollars
 PS_RNKLOCU  P    750     7   0     Prod rank locn units
 PS_RNKCOM$  P    754     7   0     Prod rank comp dollars
 PS_RNKCOMU  P    758     7   0     Prod rank comp units
 PS_RNKDATE  L    762    10         Prod rank last update
 PS_POQTYDV  P    772     5   0     PO qty divisor
 PS_POQTYUM  A    775     4         PO unit of measure
 PS_SOQSSO   P    779    13   3     SOQ specified stck out
 PS_SOQESO1  P    786    13   3     SOQ expected stck out1
 PS_SOQESO2  P    793    13   3     SOQ expected stck out2
 PS_SOQESO3  P    800    13   3     SOQ expected stck out3
 PS_SOQESO4  P    807    13   3     SOQ expected stck out4
 PS_SOQESO5  P    814    13   3     SOQ expected stck out5
 PS_SOQESO6  P    821    13   3     SOQ expected stck out6
 PS_DEAL     A    828     7         Current deal number
 PS_DEALBEG  L    835    10         Deal begin date
 PS_DEALEND  L    845    10         Deal end date
 PS_DEALALW  P    855     3   0     Deal buys allowed
 PS_DEALUSE  P    857     3   0     Deal buys used

---