OE90.1 - Release Orders On Hold Use this form to display orders on hold for a specific customer. You can remove hold codes on an order-by-order basis. Updated Files COCOMP - Used to store component information when customer order line is for a kit item. COLINE - Used to store customer order line information. COLINEDTL - Used to store allocated details (lot, serial number, bin, unit of measure quantity) for a customer order line. COSGBLK - CUSTORDER - Primary file maintained by this program. Orders are released from credit hold using this form. HOLDCODES - Used to validate the hold code. If this is the first time the hold code is referenced, the used flag is set. ICCOMPANY - Used to validate the Inventory Control company. ICLOT - Used to obtain the lot expiration date. ICRECEIPTS - Used to record receipts of stock. ITEMLOC - Used to maintain and validate quantity, cost, and reordering information for an inventoried item at a stock location. ITSERIAL - Used to store serial numbers for serial number tracked items. OEAUDIT - Used to store audits of changes to released customer orders and order lines. OECREDOVR - Used to audit credit overrides. Records a customer's status at the time of the override and the user ID of the person who entered the override. POINTAOC - Used to pass add-on costs for purchase order items that are to be ordered from a vendor rather than filled from stock. POINTERFAC - Used to pass purchase order items that are to be ordered from a vendor rather than filled from stock. ROUTEDOC - Used to store total cubic feet, weight, and items for an order on a route. ROUTEHDR - Used to store total cubic feet, weight, and items for a route. ROUTESTOP - Used to store total cubic feet, weight, and items for a route stop. SOHDETAIL - Used to store stock-on-hand details. Lot, bin, and unit of measure quantities are kept on these records. WHDEMAND - Used to validate the Warehouse demand. WHDEMNDCMT - Contains comments for the demand records. Created from order comments or requisition comments. WHDEMNDHDR - Used to validate the Warehouse demand header. Referenced Files AGINGCODE - Used to validate Accounts Receivable aging code override information. ARCOMP - Used to validate the Accounts Receivable company. ARCUSTFLDS - Used to maintain and validate user-defined field information for each customer. ARCUSTGRP - Used to maintain and validate customer group records. ARCUSTOMER - Used to validate the Accounts Receivable customer. ARCUSTTOTS - Used to maintain and validate information on customers' inclusion process levels for invoicing. ARLOCKBOX - Used to maintain and validate lock box record information, including lock box addresses and default process level and cash code information for cash entry. ARPAYMENT - Used to maintain and validate detail payment records entered for a given batch. COMPONENT - Used to obtain Inventory Control definition of components for a kit item. CUSTDESC - Used to validate and maintain customer master records. GLCODES - Used in the General Ledger Account Edit routine. ICBIN - Used to validate Inventory Control bins. ICCATEGORY - Used to validate inventory and offset general ledger accounts used to post inventory transactions. INSTCTRYCD - Validates the Intrastat country code. ITEMMAST - Used to validate the Inventory Control item. KITITEM - Used to identify kit items. NATACCT - Used to maintain and validate national account records that identify payment relationships between customers. NATBALANCE - Used to maintain and validate summary information for a national account customer. Used in the Customer Edit routine. OECOMPANY - Used to validate the Billing company. OECUST - Used to maintain and validate customer order processing information. OEFRTCODE - Used to validate the freight code. If this is the first time the freight code is referenced, the used flag is set. OEPROCLEV - Used to maintain and validate information on the valid process levels for the Order Entry system. OEROUTE - Used to validate routes. OPERATOR - Used to maintain and validate operator or user ID records. ORDERTYPE - Used to validate the order type. If this is the first time the order type is referenced, the used flag is set. STATICCUST - Used to maintain and validate customer static aging amounts. WFSETUP - WHDEMNDCMT - Contains comments for the demand records. Created from order comments or requisition comments. WHPROCTYPE - Used to validate the Warehouse process type. OE90.2 - Release Order Lines On Hold With this form, you can display and release order lines that are on hold. Note: Removal of the profit margin hold code(s) that you defined using BL05.1 (Sales Class Accounts) creates an audit record for OE284 (Credit Overrides Report). Updated Files COLINE - Primary file maintained by this program. Order lines are released from credit hold using this screen. HOLDCODES - Used to validate the hold code. If this is the first time the hold code is referenced, the used flag is set. POINTAOC - Used to pass add-on costs for purchase order items that are to be ordered from a vendor rather than filled from stock. POINTERFAC - Used to pass purchase order items that are to be ordered from a vendor rather than filled from stock. ROUTEDOC - Used to store total cubic feet, weight, and items for an order on a route. ROUTEHDR - Used to store total cubic feet, weight, and items for a route. ROUTESTOP - Used to store total cubic feet, weight, and items for a route stop. WHDEMAND - Used to validate the Warehouse demand. WHDEMNDCMT - Contains comments for the demand records. Created from order comments or requisition comments. WHDEMNDHDR - Used to validate the Warehouse demand header. Referenced Files AGINGCODE - Used to validate Accounts Receivable aging code override information. ARCOMP - Used to validate the Accounts Receivable company. ARCUSTFLDS - Used to maintain and validate user-defined field information for each customer. ARCUSTGRP - Used to maintain and validate customer group records. ARCUSTOMER - Used to validate the Accounts Receivable customer. ARCUSTTOTS - Used to maintain and validate information on customers' inclusion process levels for invoicing. ARLOCKBOX - Used to maintain and validate lock box record information, including lock box addresses and default process level and cash code information for cash entry. ARPAYMENT - Used to maintain and validate detail payment records entered for a given batch. CUCONV - Used to access general ledger and currency information. CURELAT - Used to validate currency relationships. CUSTDESC - Used to validate and maintain customer master records. CUSTORDER - Stores a record for every order entered in the Order Entry system. GLSYSTEM - Used to validate the General Ledger company. ICCOMPANY - Used to validate the Inventory Control company. INSTCTRYCD - Validates the Intrastat country code. ITEMLOC - Used to maintain and validate quantity, cost, and reordering information for an inventoried item at a stock location. ITEMMAST - Used to validate the Inventory Control item. NATACCT - Used to maintain and validate national account records that identify payment relationships between customers. NATBALANCE - Used to maintain and validate summary information for a national account customer. OECOMPANY - Used to validate the Billing company. OECUST - Used to maintain and validate customer order processing information. OEPROCLEV - Used to maintain and validate information on the valid process levels for the Order Entry system. OEROUTE - Used to validate routes. OESLSACCT - Used to validate sales class accounts. OPERATOR - Used to maintain and validate operator or user ID records. STATICCUST - Used to maintain and validate customer static aging amounts. WHDEMNDCMT - Contains comments for the demand records. Created from order comments or requisition comments. WHPROCTYPE - Used to validate the Warehouse process type. INVOKED Programs IFSG |