IC142 - Replenishment by Requisition PO's Run this program to replenish an inventory location through a requisition interface with the Purchase Order system. After requisitions are created, you can review and release them in RQ10.1 (Requisition). To create purchase orders from requisitions use RQ20 (Buyer Requisition Review and PO Create). Before using this form you must set up requesters in RQ04.1 (Requesters). Define requesters based on the form ID followed by the requesting location. For example, to run this program for the Minneapolis (MPLS) location, set up IC142MPLS as a requester. This form selects all items assigned in IC12.1 to Reorder Document code R (Requisitions). To directly order Reorder Document code P (Purchase Order) items directly from the Purchase Order system, run IC140 (Vendor Reorder Advice). Updated Files ACCOMMIT - This file contains commitments not yet posted to the general ledger. ACCOMMITX - This file contains commitment details not yet posted to the general ledger. CKPOINT - Updated with restart information. COCOMP - The Demand Line Kit Components file contains the kit components that make up a line on a document. COLINEDTL - The Order Line Allocated Details file contains line allocation information created when the item is tracked by bin, lot, serial number, or multiple unit of measure. ICCOMPANY - Used to validate company number. ICLOCATION - Used to validate location name. ICLOT - The Lots with Expire Date/On Hold file stores the expiration dates and/or the hold flag for lots. ICRECEIPTS - The cost history file which is used for LIFO and FIFO costing. ITEMGROUP - This file enables companies to share Item Master records or to keep them separate by company. ITEMLOC - Used to obtain replenishment information. Also, updated with quantity reorder information. ITSERIAL - This file stores the valid serial numbers currently in stock and issued. MMDIST - This record holds an account number and possibly an activity code intended for a general ledger distribution of an inventory item. MMUAVAL - POLINE - Used in a Purchase Order common routine. PURCHORDER - Used in a Purchase Order common routine. REQHEADER - Primary file maintained by the program if reorder document type is a requisition. REQLINE - Detail file maintained by the program if the reorder document type is a requisition. ROUTEDOC - The Route Document file contains documents that are to be delivered along a route. ROUTEHDR - For all routes created, a header record is added to the Route Header file. ROUTESTOP - The Route Stop file contains records set up to identify the stops along a route. RQAPPROVE - This is the file of open approval records needing to be approved, created for each approval amount level that is less than the requisition total value. RQCOMMENTS - This file contains both the header and line comments for a requisition. SOHDETAIL - The Stock On Hand Detail File contains the detail quantities for an item at a location, if the item is controlled by bin or lot/sublot or multiple units of measure. TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and the tax types that define how the tax code is to be used. TXCOMPANY - The Tax Company file contains company information, as well as which tax system the company uses. TXTAXCODE - The Tax Code file contains all tax code information used to calculate tax transactions. TXTAXTABLE - Used in an Accounts Payable common routine. WHDEMAND - The Demand file contains all the records that the Warehouse system needs for processing demands. WHDEMNDCMT - The Demand Comment file contains comments on demand documents. WHDEMNDHDR - The Demand Header file contains document header records. Referenced Files ACACCTCAT - Used to validate account categories maintained in the Activity Management system. ACACTGRP - Highest reporting level in the Activity Management system. ACACTIVITY - Used to validate the activities maintained in the Activity Management system. ACCAL - Contains calendar information from the Activity Management system. ACCALX - Contains detail calendar information from the Activity Management system. AMASSET - Used to validate the asset numbers maintained in the Asset Management system. AMTEMPLATE - Used to validate the asset template numbers maintained in the Asset Management system. APACCRCODE - An invoice accrual code is used to link a general ledger invoice accrual account to an invoice. APCOMPANY - Used to validate an Accounts Payable system company. APCPYVND - The Vendor Company Codes file contains default codes assigned a vendor or alternate vendor location at the company level. APHLDINV - The Hold file contains records of vendors, invoices, and payments that are on hold. APVENCLASS - Used when editing. APVENGROUP - Used when editing. APVENLOC - Used to validate vendor alternate location. APVENMAST - Used to validate vendor. BUYER - Used to validate the buyer codes. COMPONENT - Contains the component items that make up a kit item. CUACCT - This file contains account numbers that variance amounts are posted to when a timing difference occurs between the beginning and the completion of a transaction. CUCONV - Used to obtain currency conversion information. CURELAT - Used to validate currency relationship. CUTABLE - This file defines currency tables. GLADDRESS - Used to obtain general ledger address information. GLCHART - Used to validate system account. GLCODES - Used in sub-system close common routine. GLINTCO - This file contains interzone and intercompany relationships. GLSYSTEM - Used to validate the General Ledger company. ICBIN - Used in an Inventory Control common routine. ICCATEGORY - Used in a Requisitions common routine. ICRPTGRP - Used to validate report group name. ITEMMAST - Used to print the item description. Also returns unit of measure conversion information. ITEMSUB - The Item Substitute file stores valid substitutes for an item. KITITEM - This file contains the valid kit or parent items for a kit or assembly. MAJORCL - Used to validate major class. MINORCL - Used to validate minor class. OEFRTCODE - This file contains freight codes that can be used in the Warehouse system. OEROUTE - This file contains all user-defined routes that are set up in the Warehouse system. ORDERTYPE - The Order Type file stores order type parameters. POCOMMENTS - This file contains all Purchase Order comments associated with both actual and standard Purchase Orders. POCOMPANY - Used to validate Purchase Order company. POITEMVEN - Used to obtain purchase order item vendor unit of measure information. POLOCCON - List of valid override contracts for a location. POQUOTES - Used to obtain Purchase Order vendor item quote cost. POVENDOR - This file is used by a Purchase Order common routine. REQUESTER - Used to validate requester name. RQACCTU - This is the list of valid accounting units that this requester can enter on a requisition. RQAPPCODE - Used to validate approval codes. RQLOC - Used to validate requesting locations. RQPURCHCLS - This file contains the list of valid purchasing major classes that a requester can enter items for on a requisition. RQTEMPLINE - This file contains the items on a requisition template. STCOMMCODE - This is a file of valid standard comment codes used to add comments to a purchase order. STPOLINE - Used to obtain standard purchase order line item information. STPURCHORD - Used to obtain standard order information. SYSTEMCODE - TXTAXRATE - The Tax Rate file stores tax rates in effect for a specific tax code. WFSETUP - WHPROCTYPE - The Shipment Process Type file contains process type records used for determining the steps a document is to take in the Warehouse system. INVOKED Programs ACAC IFCR IFSG IFCU IFAC IFAU SLSE SLSU IFCC IFOB IFRS |