File Field Descriptions

Description: This section contains all the files used within K3S-Replenish® XXX_5DTA and all their respective field names. For XXX_5WEB files click here: 5WEB File Field Descriptions
  1. K_ADJTLOG - Buyer Adjustments Log
  2. K_AUTOADD  -  Automated Add Days
  3. K_AUTOLOG  -  Automated Add Days – Log of Changes
  4. K_BSRVLOG  -  Buy Group Service Level Table – Log of Changes
  5. K_BUYRCHG  -  Buy Group Change for Supplier
  6. K_BUYRFLG  -  Buy Group PE Filter Log
  7. K_BUYRGRP  -  Buy Group
  8. K_BUYRALG - Night Job Totals For Select Agenda Tasks
  9. K_BUYRLOG  -  Buy Group – Log of Changes
  10. K_BUYRMET - Buyer Metrics File
  11. K_BUYRSOT  -  Buy Group Suggested Order Totals
  12. K_BUYRSRV  -  Buy Group Service Level Tables
  13. K_CHNPROD  -  Chain Level Products  
  14. K_COMPANY  -  Company Values  
  15. K_COMPLOG  -  Company – Log of Changes  
  16. K_CUSTBCH  -  Customer Usage Batch  
  17. K_CUSTCOM  -  Customer Usage Comparison Report  
  18. K_CUSTEXL  -  Customer Usage Total Batch for EXCEL use  
  19. K_CUSTPRD  -  Customer Usage Products  
  20. K_CUSTWRK  -  Customer Usage Transaction Work File  
  21. K_CVOCLOG  -  Companies Variable Order Cycle – Log of Changes  
  22. K_DEALALW  -  Deals Product Allowance Information  
  23. K_DEALCST  -  Deals Customer Information  
  24. K_DEALDET  -  Deals Product Information  
  25. K_DEALENT  -  Deals Product Entry Template  
  26. K_DEALLOG  -  Deals Log   
  27. K_DEALPER  -  Deals Permanent 
  28. K_DEALSUM  -  Deals Summary Information  
  29. K_DEALWRK  -  Deals Product Allowance Work File  
  30. K_DLYPROD  -  Daily Products Information Capture  
  31. K_DLYSVCE  -  Daily Capture of Service  
  32. K_DPERLOG  -  Deals Permanent – Log of Changes  
  33. K_DVTRSVG - Diverter Savings
  34. K_GRP1SRV  -  Product Group Service Level Table  
  35. K_GSRVLOG  -  Product Group Service Level – Log of Changes  
  36. K_GUESTBK  -  Guest Book  
  37. K_HSTALTR  -  History for Alternate Source Transactions 
  38. K_INTALTR  -  Interface for Alternate Source System  
  39. K_INTCASE  -  Interface for Case Accumulation   
  40. K_INTCSTI  -  Interface Customer Header   
  41. K_INTCSTJ  -  Interface Customer Detail
  42. K_INTCUST  -  Interface for Customer Usage System  
  43. K_INTDALY  -  Interface for Daily Demand Feed  
  44. K_INTDEAL  -  Interface for Deals  
  45. K_INTHOLD - Interface for Product Hold Out Requirements
  46. K_INTINPT  -  Interface for Customer  
  47. K_INTORDB  -  Interface for Approved Orders – Header  
  48. K_INTORDD  -  Interface for Approved Orders - Detail  
  49. K_INTPLVL - Interface for Product Bracket Level Cost
  50. K_INTPRDD  -  Interface for Products During the Day   
  51. K_INTPROD  -  Interface for Products  
  52. K_INTSUPL  -  Interface for Suppliers
  53. K_INVBUYR - Average Inventory Statistics For Buyers
  54. K_INVCOMP - Average Inventory Statistics For the Company
  55. K_INVLOCN - Average Inventory Statistics For Locations
  56. K_INVPROD - Average Inventory Statistics For Products
  57. K_INVRLOG - Inventory Ratio Log Entries
  58. K_INVSUPL - Average Inventory Statistics For Suppliers
  59. K_LOCATNS  -  Locations  
  60. K_LOCNLOG  -  Locations – Log of Changes  
  61. K_LOGALTR  -  Alternate Source Offerings  
  62. K_LOGPROD  -  Log Product Transactions  
  63. K_LVOCLOG  -  Locations Variable Order Cycle – Log of Changes  
  64. K_MAILRCP  -  Automated E-mail Recipients  
  65. K_NITELOG  -  K3S Night Job Log  
  66. K_NITETOT - Night Job totals for tasks
  67. K_NOTELOG  -  Notes – Log of Changes  
  68. K_NOTEPAD  -  Notes  
  69. K_OBSOLET  -  Obsolete Products Independent locations  
  70. K_ORDCYCL  -  Order Cycle Analysis  
  71. K_PERDPER  -  Period End Exceptions Performance  
  72. K_PHEXLOG  -  Pdt Hst Exclusion Changes Log  
  73. K_PHLDLOG - Product Hold Out - Log Of Changes
  74. K_PLNKLOG  -  Product Link – Log of Changes  
  75. K_PLVLLOG  -  Product Bracket Level Costs – Log of Changes  
  76. K_PRODACT  -  Products to be Activated  
  77. K_PRODAPP  -  Product Approved/Adjusted Orders  
  78. K_PRODBRK  -  Product Breakpoint Levels  
  79. K_PRODDLY  -  Product Delay Days  
  80. K_PRODFLT  -  Product Filtered at Period End  
  81. K_PRODFOR  -  Product Forecast Log  
  82. K_PRODHXX  -  Product History Exclusions  
  83. K_PRODHIS  -  Product History (monthly and 13 – 4 weekly)   
  84. K_PRODHLD  -  Product Hold Out Quantities  
  85. K_PRODH52  -  Product History -  Weekly   
  86. K_PRODLNK  -  Product Links   
  87. K_PRODLOG  -  Products – Log of Changes   
  88. K_PRODLTM  -  Product Lead Time Transactions   
  89. K_PRODLVL  -  Products Bracket Level Costs   
  90. K_PRODOVP  -  Product Overstocked Products   
  91. K_PRODOVR  -  Product Overstock Transfer Requests   
  92. K_PRODPND  -  Product Suggested Order Quantities   
  93. K_PRODQRY  -  Products – ‘Selected Products Review’ QRY Type   
  94. K_PRODRST  -  Products with a Restricted Qty   
  95. K_PRODSEB  -  Product Selected for Review – Batch Header   
  96. K_PRODSED  -  Product Selected for Review – Batch Detail   
  97. K_PRODSEZ  -  Product Seasonal Profiles   
  98. K_PRODSOQ  -  Product Suggested Order Quantities
  99. K_PRODSPL - Products From Suppliers Performance Metrics
  100. K_PRODSRC - Product Change Source of Supplier  
  101. K_PRODSRV  -  Product Service Level Target Exceptions   
  102. K_PRODUCT  -  Products   
  103. K_PRODWKD  -  Products Weekly Distribution   
  104. K_PSRCLOG  -  Product Chg Srce of Supl Log   
  105. K_PSRVLOG  -  Product Service Level – Log of Changes   
  106. K_PURCHIS  -  Purchase History   
  107. K_PWKDLOG  -  Product Weekly Distribution Log of Changes   
  108. K_RANKPRD  -  Ranking Products for Reports   
  109. K_RANKSPL  -  Ranking Suppliers for Reports   
  110. K_SCDYLOG  -  Daily Schedule – Log of Changes   
  111. K_SCHEDDY  -  Schedule Daily   
  112. K_SCHEDPE  -  Schedule Period End   
  113. K_SCPELOG  -  Period End Schedule – Log of Changes   
  114. K_SSRVLOG  -  Supplier Srv Lvl Changes Log   
  115. K_STOREJB  -  Store Job Log File   
  116. K_STRPROD  -  Store Level Products
  117. K_SUP1LOG - Suplier/Product Group Service Log
  118. K_SUP1SRV - Supplier/Product Group Service    
  119. K_SUPDLOG  -  Suppliers Discount Bracket – Log of Changes   
  120. K_SUPLAPV  -  Supplier Approval Defaults   
  121. K_SUPLCMB  -  Supplier Combined Suppliers   
  122. K_SUPLDIS  -  Supplier Discount Brackets   
  123. K_SUPLDLY  -  Supplier Log of Order Delays   
  124. K_SUPLIER  -  Suppliers   
  125. K_SUPLLOG  -  Suppliers – Log of Changes   
  126. K_SUPLLST  -  Supplier Purchases Alternate Source   
  127. K_SUPLLTM  -  Supplier Lead Time Transactions  
  128. K_SUPLPND  -  Supplier Suggested Orders
  129. K_SUPLPER - Supplier Performance Metrics    
  130. K_SUPLPUR  -  Supplier Purchases   
  131. K_SUPLREC  -  Supplier Receipts   
  132. K_SUPLREJ  -  Supplier Rejected Alternate Source Records   
  133. K_SUPLSOQ  -  Supplier Suggested Orders   
  134. K_SUPLSRV  -  Supplier Service Level Table   
  135. K_SUPLVOC  -  Supplier Variable Order Cycle   
  136. K_SVOCLOG  -  Suppliers Variable Order Cycle – Log of Changes
  137. K_TABLCOD - Table of Codes   
  138. K_TABLLOG  -  Table code – Log of Changes   
  139. K_TCENLOG  -  Transfer Sys Cntrl Supl – Log of Changes   
  140. K_TPRDLOG  -  Transfer Sys Prod Link – Log of Changes   
  141. K_TRANCEN  -  Transfer Sys Cntrl Supl   
  142. K_TRANCPY  -  Transfer Sys Copy Hist Log   
  143. K_TRANPRD  -  Transfer Sys Prod Link   
  144. K_TRANSPL  -  Transfer Sys Supl Link   
  145. K_TSPLLOG  -  Transfer Sys Supl Link – Log of Changes   
  146. K_USERLOG  -  User Preferences – Log of Changes
  147. K_USERMET - User Metrics File
  148. K_USRMETS - User Metrics Summary File
  149. K_USERPRF  -  User Preferences   
  150. K_WEEKDIS  -  Weekly Distribution Values   
  151. K_WRKOBSL  -  Work File for Obsolete Products All Locations   

Subpages (151): View All
Comments