File Name . . . . K_SUPLPUR
Library . . . . K3S_5DTA
Format Descr. . . Supplier purchases
Format Name . . . RK_SUPLPUR
File Type . . . . PF Unique Keys- N
Field Name FMT Start Lngth Dec Key Field Description
SA_COMP A 1 1 Company ID
SA_LOCN A 2 5 Location ID
SA_SUPL A 7 10 Supplier ID
SA_SUPLSUB A 17 10 Sub supplier ID
SA_BIRTH L 27 10 Supl purchases birth
SA_LASTUPD L 37 10 Supl purchases last
SA_YEAR P 47 4 0 Supl purchases year
SA_DOLR01 P 50 11 3 Dollars accum 01
SA_DOLR02 P 56 11 3 Dollars accum 02
SA_DOLR03 P 62 11 3 Dollars accum 03
SA_DOLR04 P 68 11 3 Dollars accum 04
SA_DOLR05 P 74 11 3 Dollars accum 05
SA_DOLR06 P 80 11 3 Dollars accum 06
SA_DOLR07 P 86 11 3 Dollars accum 07
SA_DOLR08 P 92 11 3 Dollars accum 08
SA_DOLR09 P 98 11 3 Dollars accum 09
SA_DOLR10 P 104 11 3 Dollars accum 10
SA_DOLR11 P 110 11 3 Dollars accum 11
SA_DOLR12 P 116 11 3 Dollars accum 12
SA_WGHT01 P 122 11 3 Weight accum 01
SA_WGHT02 P 128 11 3 Weight accum 02
SA_WGHT03 P 134 11 3 Weight accum 03
SA_WGHT04 P 140 11 3 Weight accum 04
SA_WGHT05 P 146 11 3 Weight accum 05
SA_WGHT06 P 152 11 3 Weight accum 06
SA_WGHT07 P 158 11 3 Weight accum 07
SA_WGHT08 P 164 11 3 Weight accum 08
SA_WGHT09 P 170 11 3 Weight accum 09
SA_WGHT10 P 176 11 3 Weight accum 10
SA_WGHT11 P 182 11 3 Weight accum 11
SA_WGHT12 P 188 11 3 Weight accum 12
SA_VOLM01 P 194 11 3 Volume accum 01
SA_VOLM02 P 200 11 3 Volume accum 02
SA_VOLM03 P 206 11 3 Volume accum 03
SA_VOLM04 P 212 11 3 Volume accum 04
SA_VOLM05 P 218 11 3 Volume accum 05
SA_VOLM06 P 224 11 3 Volume accum 06
SA_VOLM07 P 230 11 3 Volume accum 07
SA_VOLM08 P 236 11 3 Volume accum 08
SA_VOLM09 P 242 11 3 Volume accum 09
SA_VOLM10 P 248 11 3 Volume accum 10
SA_VOLM11 P 254 11 3 Volume accum 11
SA_VOLM12 P 260 11 3 Volume accum 12
SA_PURI01 P 266 7 0 Purch incre accum 01
SA_PURI02 P 270 7 0 Purch incre accum 02
SA_PURI03 P 274 7 0 Purch incre accum 03
SA_PURI04 P 278 7 0 Purch incre accum 04
SA_PURI05 P 282 7 0 Purch incre accum 05
SA_PURI06 P 286 7 0 Purch incre accum 06
SA_PURI07 P 290 7 0 Purch incre accum 07
SA_PURI08 P 294 7 0 Purch incre accum 08
SA_PURI09 P 298 7 0 Purch incre accum 09
SA_PURI10 P 302 7 0 Purch incre accum 10
SA_PURI11 P 306 7 0 Purch incre accum 11
SA_PURI12 P 310 7 0 Purch incre accum 12
SA_OTHR01 P 314 11 4 Other bracket accum 01
SA_OTHR02 P 320 11 4 Other bracket accum 02
SA_OTHR03 P 326 11 4 Other bracket accum 03
SA_OTHR04 P 332 11 4 Other bracket accum 04
SA_OTHR05 P 338 11 4 Other bracket accum 05
SA_OTHR06 P 344 11 4 Other bracket accum 06
SA_OTHR07 P 350 11 4 Other bracket accum 07
SA_OTHR08 P 356 11 4 Other bracket accum 08
SA_OTHR09 P 362 11 4 Other bracket accum 09
SA_OTHR10 P 368 11 4 Other bracket accum 10
SA_OTHR11 P 374 11 4 Other bracket accum 11
SA_OTHR12 P 380 11 4 Other bracket accum 12
SA_#POS01 P 386 5 0 Number of POs 01
SA_#POS02 P 389 5 0 Number of POs 02
SA_#POS03 P 392 5 0 Number of POs 03
SA_#POS04 P 395 5 0 Number of POs 04
SA_#POS05 P 398 5 0 Number of POs 05
SA_#POS06 P 401 5 0 Number of POs 06
SA_#POS07 P 404 5 0 Number of POs 07
SA_#POS08 P 407 5 0 Number of POs 08
SA_#POS09 P 410 5 0 Number of POs 09
SA_#POS10 P 413 5 0 Number of POs 10
SA_#POS11 P 416 5 0 Number of POs 11
SA_#POS12 P 419 5 0 Number of POs 12
K3S_5DTA - Main Database Files
- Database
- K_ADJTLOG - Buyer Adjustments Log
- K_ALLWORK - Work File All Locations
- K_AUTOADD - Automated Add Days
- K_AUTOLOG - Automated Add Days - Log Of Changes
- K_BSRVLOG - Buyer Group Service Level Table - Log Of Changes
- K_BTCHCMB - Combined PRODSED and PRODUCT
- K_BUYRALG - Night Job Totals For Select Agenda Tasks
- K_BUYRCHG - Buyer Group Change For Supplier
- K_BUYRFIL - Buyer Group End Period Filter
- K_BUYRFLG - Buyer Group PE Filter Log
- K_BUYRGRP - Buyer Group
- K_BUYRLOG - Buyer Group - Log Of Changes
- K_BUYRMET - Buyer Metrics File
- K_BUYRSOT - Buyer Group Suggested Order Totals
- K_BUYRSRV - Buyer Group Service Level Tables
- K_BUYWORK - Buyer Work
- K_CHNPROD - Chain Level Products
- K_COMPANY - Company Values
- K_COMPLOG - Company Log Of Changes
- K_CUSTBCH - Customer Usage Batch
- K_CUSTCOM - Customer Usage Comparison Report
- K_CUSTEXL - Customer Usage Total Batch for EXCEL use
- K_CUSTLOG - Log Of Customer Transactions
- K_CUSTOMR - Chain Customer Store For Location
- K_CUSTPRD - Customer Usage Products
- K_CUSTWRK - Customer Usage Transaction Work File
- K_CVOCLOG - Companies Variable Order Cycle – Log of Changes
- K_DBGTBL - Debug Table
- K_DEALALW - Deals Product Allowance Information
- K_DEALCST - Deals Customer Information
- K_DEALDET - Deals Product Information
- K_DEALENT - Deals Product Entry Template
- K_DEALHLD - Deal Hold Outs
- K_DEALLOG - Deals Log
- K_DEALPER - Deals Permanent
- K_DEALSUM - Deals Summary Information
- K_DEALWRK - Deals Product Allowance Work File
- K_DEALWZA - Deal Wizard Allowances
- K_DEALWZL - Deal Wizard Locations
- K_DEALWZP - Deal Wizard Product
- K_DEMDEXP - Demand Export
- K_DLYPROD - Daily Products Information Capture
- K_DEPLOG - Depletion Log
- K_DLYSVCE - Daily Capture of Service
- K_DPERLOG - Deals Permanent – Log of Changes
- K_DVTRSVG - Diverter Savings
- K_ERPXREF - ERP Product Cross Reference Table
- K_ERPXLOG - ERP Product Cross Reference Changes Log
- K_FINALOG - Daily Financial Log
- K_FRESH - Fresh Suppliers
- K_GPSLOCN - K3S Location Information
- K_GRP1SRV - Product Group Service Level Table
- K_GSRVLOG - Product Group Service Level – Log of Changes
- K_GUESTBK - Guest Book
- K_HASMAP - K3S Hub and Spoke Locations For Map
- K_HSTALTR - History for Alternate Source Transactions
- K_INTALTR - Interface for Alternate Source System
- K_INTCASE - Interface for Case Accumulation
- K_INTCSTI - Interface Customer Header
- K_INTCSTJ - Interface Customer Detail
- K_INTCUST - Interface for Customer Usage System
- K_INTDALY - Interface for Daily Demand Feed
- K_INTDEAL - Interface for Deals
- K_INTHLDD - Interface for Product Hold Out Records Daytime
- K_INTHOLD - Interface for Product Hold Out Requirements
- K_INTINPT - Interface for customer
- K_INTMFUB - Interface for Mass Update System
- K_INTORDB - Interface for Approved Orders – Header
- K_INTORDD - Interface for Approved Orders - Detail
- K_INTORDF - Best Practices Log
- K_INTORDL - Log of User Actions of Approved Orders
- K_INTPATH - Interface for Path of Replenishment
- K_INTPLVL - Interface for Product Bracket Level Cost
- K_INTPOCT - Interface for PO Controller
- K_INTPRDD - Interface for Products during the day
- K_INTPROD - Interface for Products
- K_INTREAD - Readiness Entry Upload Interface
- K_INTSDIS - Interface for Supplier Bracket Levels
- K_INTSFMU - Sales Entry Mobile Upload Interface
- K_INTSLFW - Sales Entry Upload Interface
- K_INTSLOG - Log of all K_INTSLFW processing
- K_INTSTOR - Store Interface File
- K_INTSUPL - Interface for Suppliers
- K_INTUTIL - Utility File Interface
- K_INVBUYR - Average Inventory Statistics For Buyers
- K_INVCOMP - Average Inventory Statistics For the Company
- K_INVLOCN - Average Inventory Statistics For Locations
- K_INVPROD - Average Inventory Statistics For Products
- K_INVRLOG - Inventory Ratio Log Entries
- K_INVSUPL - Average Inventory Statistics For Suppliers
- K_LCNWORK - Locations Work
- K_LOCATNS - Locations
- K_LOCNLOG - Locations – Log of Changes
- K_LOGALTR - Alternate Source Offerings
- K_LOGCLUL - Log Utility Column Update
- K_LOGPROD - Log Product Transactions
- K_LOGSFMU - Sales Entry Mobile Processing Log
- K_LOGSLFW - Sales Entry Log
- K_LVOCLOG - Locations Variable Order Cycle – Log of Changes
- K_MAILRCP - Automated e-mail recipients
- K_MFUBENT - Mass Update Batch Entries
- K_MFUBHED - Mass Update Batch Header
- K_NITECMB - Combined LOGPROD-PRODUCT-PRODSOQ
- K_NITELOG - K3S Night Job Log
- K_NITETOT - Night Job totals for tasks
- K_NOTELOG - Notes – Log of Changes
- K_NOTEPAD - Notes
- K_OBSOLET - Obsolete Products Independent locations
- K_ORDCYCL - Order Cycle Analysis
- K_PATHREP - Path of Replenishment
- K_PATHLOG - K3S Hub-Spoke Changes Log
- K_PERDPER - Period End Exceptions Performance
- K_PHEXLOG - Pdt Hst Exclusion Changes Log
- K_PHLDLOG - Product Hold Out - Log Of Changes
- K_PLNKLOG - Product Link – Log of Changes
- K_PLVLLOG - Product Bracket Level Costs – Log of Changes
- K_POLISTER - Joint view on K_PRODAPP, K_INTORDD, K_PRODLTM
- K_PRDDLTM - Product Lead Time Transactions During The Day
- K_PRDWORK - Work File Products
- K_PRHLDGN - Log of Hold Outs Groups
- K_PRODACT - Products to be Activated
- K_PRODAPP - Product Approved/Adjusted Orders
- K_PRODBRK - Product Breakpoint Levels
- K_PRODDLY - Product Delay Days
- K_PRODFLT - Product Filtered at Period End
- K_PRODFOR - Product Forecast Log
- K_PRODH52 - Product History - weekly
- K_PRODHIS - Product History (monthly and 13 – 4 weekly)
- K_PRODHLD - Product Hold Out Quantities
- K_PRODHXX - Product History Exclusions
- K_PRODLNK - Product Links
- K_PRODLOG - Products – Log of Changes
- K_PRODLTM - Product Lead Time Transactions
- K_PRODLVL - Products Bracket Level Costs
- K_PRODOVP - Product Overstocked Products
- K_PRODOVR - Product Overstock Transfer Requests
- K_PRODPND - Product Suggested Order Quantities
- K_PRODQRY - Products – ‘Selected Products Review’ QRY type
- K_PRODRST - Products with a Restricted Qty
- K_PRODSEB - Product Selected for Review – Batch Header
- K_PRODSED - Product Selected for Review – Batch Detail
- K_PRODSEZ - Product Seasonal Profiles
- K_PRODSOQ - Product Suggested Order Quantities
- K_PRODSPL - Products from Suppliers Performance Metrics
- K_PRODSRC - Product Change Source of Supplier
- K_PRODSRV - Product Service Level Target Exceptions
- K_PRODSTA - Product Summary Table
- K_PRODUCT - Products
- K_PRODWKD - Products Weekly Distribution
- K_PROWORK - Work File Products On Order
- K_PSRCLOG - Product Chg Srce of Supl Log
- K_PSRVLOG - Product Service Level – Log of Changes
- K_PURCHIS - Purchase History
- K_PWKDLOG - Product Weekly Distribution Log of Changes
- K_RANKPRD - Ranking Products for Reports
- K_RANKSPL - Ranking Suppliers for Reports
- K_READYE - Readiness Entry
- K_READYH - Readiness Header
- K_SALSFLB - Sales Entry Batch
- K_SALSFLW - Sales Entries
- K_SALSPON - Sales Entry POs
- K_SCDYLOG - Daily Schedule – Log of Changes
- K_SCHEDDY - Schedule Daily
- K_SCHEDPE - Schedule Period End
- K_SCPELOG - Period End Schedule – Log of Changes
- K_SLFWORK - Sales Entry Work File
- K_SLFWPCH - Sales Entry Patch Work File
- K_SLFXREF - Sales Entry Cross Reference
- K_SPLWORK - Work File Suppliers
- K_SSRVLOG - Supplier Srv Lvl changes log
- K_STOREJB - Store job log file
- K_SUP1LOG - Suplier/Product Group Service Log
- K_SUP1SRV - Supplier/Product Group Service
- K_SUPDLOG - Suppliers Discount Bracket – Log of Changes
- K_SUPLAPV - Supplier Approval Defaults
- K_SUPLCMB - Supplier Combined Suppliers
- K_SUPLDIS - Supplier Discount Brackets
- K_SUPLDLY - Supplier Log of Order Delays
- K_SUPLIER - Suppliers
- K_SUPLLOG - Suppliers – Log of Changes
- K_SUPLLST - Supplier Purchases Alternate Source
- K_SUPLLTM - Supplier Lead Time Transactions
- K_SUPLPND - Supplier Suggested Orders
- K_SUPLPER - Supplier Performance Metrics
- K_SUPLPUR - Supplier Purchases
- K_SUPLREC - Supplier receipts
- K_SUPLREJ - Supplier Rejected Alternate Source Records
- K_SUPLSOQ - Supplier Suggested Orders
- K_SUPLSRV - Supplier Service Level Table
- K_SUPLVOC - Supplier Variable Order Cycle
- K_SVOCLOG - Suppliers Variable Order Cycle – Log of Changes
- K_TABLCOD - Table of Codes
- K_TABLLOG - Table code – Log of Changes
- K_TCENLOG - Transfer Sys Cntrl Supl – Log of Changes
- K_TPRDLOG - Transfer Sys Prod Link – Log of Changes
- K_TRANCEN - Transfer Sys Cntrl Supl
- K_TRANCPY - Transfer Sys Copy Hist Log
- K_TRANPRD - Transfer Sys Prod Link
- K_TRANSPL - Transfer Sys Supl Link
- K_TSPLLOG
- K_USERLOG - User Preferences – Log of Changes
- K_USERMET - User Metrics File
- K_USRMETS - User Metrics Summary File
- K_USERPRF - User Preferences
- K_UTILCOL - K3S Utility Column Header
- K_UTILITY - K3S Utility File
- K_UTILLOG - K3S Utility File Log
- K_VAPXREF - Virtual and Actual Product Cross Reference
- K_WEEKDIS - Weekly Distribution Values
- K_WEEKSLE - Weekly Sales
- K_WRKOBSL - Work File for Obsolete Products all locations
