BL141 - Base List Worksheet Update This program takes released worksheet price bases and updates these work bases into an existing base or creates a new base. The worksheet price base effective date must be greater than the system date and the worksheet price must not be zero to allow updating the base. The worksheet(s) processed by this program continue to remain on file and can be reprinted. Unwanted worksheets can be purged by running BL340 (Base List Worksheet Purge). Updated Files CKPOINT - Used to control program restart logic. OEBASE - Item price base records are created and updated by this program. OEBPAUDIT - Audits of changes to base records are stored in this file. OEWKSHEET - Worksheet parameters direct the update of the base records. Status is updated. Referenced Files APCOMPANY - Used in the vendor Master edit routine. APCPYVND - Used in the vendor Master edit routine. APHLDINV - Used in the vendor Master edit routine. APVENCLASS - Used in the vendor Master edit routine. APVENGROUP - Used in the vendor Master edit routine. APVENMAST - Used to validate vendor selection. ICCOMPANY - Used to validate the Inventory Control company. ICLOCATION - Used to validate inventory locations. ITEMMAST - Used to validate item numbers. OECOMPANY - Used to validate the Billing company. OEWKPRICE - Stores worksheet prices by item. Source for new prices being updated into the item price base. INVOKED Programs IFCC |