Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIOECUST


                             ARIOECUST FILE

                     Customer Order Processing Conv

The Customer Order Processing Conversion file is used to convert customer
records from an external source. Records in this file have been converted from
an external source and will be loaded into the Accounts Receivable system via
AR501 (Customer Conversion).

Field data converted into this file may be accessed and maintained in AR98
(Conversion Customer Maintenance).

UPDATED BY

AR501     AR98.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AOE-COMPANY            Numeric 4                                 AR98.3
Element: Company       Required. The customer company number.

AOE-CUSTOMER           Alpha 9  (Right Justified)                AR98.3
Element: Customer      Required. Customer number.

AOE-FREIGHT-CODE       Alpha 2                                   AR98.3
Element: FreightCode   This field contains the freight code.
                       This determines whether carrier and
                       charge are allowed for the shipment.

AOE-PK-PRIORITY        Numeric 2                                 AR98.3
Element: Picking PrioriUsed by batch inventory allocation to
                       determine which customers get option on
                       available inventory.

AOE-CARRIER            Alpha 9  (Right Justified)                AR98.3
Carrier Vendor         Carrier vendor number.
Number

AOE-CIA-FL             Alpha 1                                   AR98.3
Element: Cash In AdvancIndicates whether customers must pay
                       cash in advance. Valid values are:

                       N = Cash in advance not required
                       Y = Cash in advance required

AOE-CIA-PCT            Percent 8.5  (Percent)                    AR98.3
Cash In Advance        Percent of order amount required from
Percent                the customer before order acceptance.
                       This must be entered if "Y" has been
                       entered in the Cash in Advance field.

AOE-ORD-DISC-CODE      Alpha 4                                   AR98.3
Element: Order DiscountOrder discount code.

AOE-COMM-SPLIT         Percent 5.3  (Percent)                    AR98.3
Commission Split       This field contains the commission
Percentage             percent of the total order value to be
                       used as the basis for the second sales
                       representative's commission.

AOE-SALESMAN-2         Numeric 4                                 AR98.3
Element: SalesRep 2    This field contains the code
                       representing the second salesrep.

AOE-PRICE-LST          Alpha 14                                  AR98.3
Element: Price List    Price list used to automatically price
                       orders.

AOE-ACKNOW-FL          Alpha 1                                   AR98.3
Acknowledgement        Indicates whether the customer needs
Required               printed acknowledgments. Valid values
                       are:

                       N = Acknowledgments not required
                       Y = Acknowledgments required

AOE-BACK-ORD-FL        Alpha 1                                   AR98.3
Element: Backorders AllIndicates whether the customer accepts
                       backorders. Valid values are:

                       N = Backorders not accepted
                       Y = Backorders accepted

AOE-SHIP-COMP-FL       Alpha 1                                   AR98.3
Element: Ship Complete Indicates whether orders must be
                       complete prior to shipment. Valid values
                       are:

                       N = Customer accepts partial order
                       shipments
                       Y = Customer does not accept partial
                       order shipments

AOE-PO-REQ-FL          Alpha 1                                   AR98.3
Element: PO Required   Indicates whether the customer's
                       purchase order number must be entered
                       before releasing an order. Valid values
                       are:

                       N = Purchase order number not required
                       Y = Purchase order number required

AOE-DEF-SHIP-TO        Numeric 4                                 AR98.3
Default Ship-to for    Default ship-to location.
Location

AOE-DEF-LOCATION       Alpha 5                                   AR98.3
Default Ship-from      Default ship-from location.
Location

AOE-DEF-METHOD         Alpha 10                                  AR98.3
Default Shipment       Default shipment method.
Method

AOE-CUSTOMER-CODE      Alpha 4                                   AR98.3
Element: Customer Code Customer code. This is a code used to
                       classify customers for Sales Analysis.

AOE-POD-REQ-FL         Alpha 1                                   AR98.3
Element: POD Required  POD required flag. Customer requires
                       that a Proof of Delivery form to
                       accompany the shipment. The shipment
                       will not be billed until POD is returned
                       or the POD grace period expires.

AOE-GRACE-PER          Numeric 3                                 AR98.3
Element: Grace Period  Grace days to be added to POD creation
                       date before the customer will be billed.
                       This may be entered if "Y" is selected
                       in the POD Required field. If left
                       blank, the grace period defined for the
                       customer default code will default or no
                       grace days are used.

AOE-SGL-HOLD-CODE      Alpha 4                                   AR98.3
Single Order Hold      Hold code to apply to a non-COD order
Code                   when the order total amount exceeds the
                       single order limit. If the single order
                       limit is greater than zero, then this
                       field is required. If the single order
                       limit equals zero and single hold code
                       is entered, then every non-COD order
                       will be on hold.

AOE-SGL-ORD-LIM        Signed 13.0                               AR98.3
Element: Single Order LMaximum single order amount for the
                       customer. If blank, the single order
                       limit defined for the customer default
                       code will default.

AOE-COD-LIM            Signed 13.0                               AR98.3
Element: COD Limit     Maximum amount to limit COD orders for
                       this customer. If left blank, the COD
                       order limit defined in the customer
                       default code defaults.

AOE-COD-HOLD-CODE      Alpha 4                                   AR98.3
Element: COD Hold Code If a COD order limit is defined, select
                       the hold code to be placed on orders
                       that exceed the limit. If blank, the COD
                       hold code defined for the customer
                       default code defaults.

AOE-ENT-CHECK-FL       Alpha 1                                   AR98.3
Element: Order Credit CIndicates whether to perform a credit
                       check before accepting an order for the
                       customer. If left blank, the credit
                       check entry option defined for the
                       customer default code defaults. Valid
                       values are:

                       N = No credit checking performed
                       Y = Credit checking performed

AOE-PRT-CHECK-FL       Alpha 1                                   AR98.3
Picking List Credit    Indicates whether to perform a credit
Check                  check before printing picking lists for
                       the customer. If left blank, the credit
                       check option defined for the customer
                       default code defaults. Valid values are:


                       N = No credit check performed
                       Y = Credit check performed

AOE-AGE-CRED-PCT       Percent 5.2  (Percent) Occurs 5 Times     AR98.3
Age Credit             If" Y" is selected for the credit check
Percentages            entry or credit check print fields,
                       define the percentage of the customer's
                       credit limit that is allowed in the
                       current, first, second, third, and
                       fourth aging periods. If a percentage is
                       defined for a period, you must also
                       select a corresponding age hold code. If
                       left blank, the age credit percentages
                       defined for the customer default code
                       will default.

AOE-AGE-HOLD-CD        Alpha 4 Occurs 5 Times                    AR98.3
Element: Aging Hold CodIf age credit percentages are defined,
                       select the hold codes to be placed on
                       orders when the customer fails the
                       credit check because of the aging period
                       limits.

AOE-CR-HOLD-CODE       Alpha 4
Element: Credit Hold CoThis indicates whether or not the
                       customer was put on credit hold. Valid
                       values are:

                       N = Not put on hold
                       Y = Credit hold on customer

AOE-BRKN-CS-CHRG       Alpha 1                                   AR98.3
Element: Broken Case ChDetermines if there is a charge if a
                       broken case is required to satisfy an
                       order in Order Entry. Valid values are:

                       N = No broken case charge
                       Y = Broken case charge

AOE-CR-LIMIT-HOLD      Alpha 4                                   AR98.3
Credit Limit Hold      Indicates if a customer is on hold for
Code                   exceeding the credit limit.

AOE-OR-LIMIT-HOLD      Alpha 4                                   AR98.3
Order Limit Hold       Indicated if a customer is on hold for
Code                   exceeding the order limit.

AOE-CUSRET-INV-MET     Alpha 1
Return Invoicing       Determines the invoicing method for
Method                 replacement of good returned by the
                       customer.  Customers can be shipped
                       replacement goods at no charge, or they
                       can be credited for the returned goods.
                       This value can be defaulted from the
                       company or customer level.

AOE-LINE-ITEM-REQ      Alpha 1                                   AR98.3
Element: Line Items ReqIndicated if line items are produced
                       for an invoice. Valid values are:

                       N = Line items are not produced.
                       Y = Line items are produced.

AOE-TAX-PRINT-CD       Alpha 1                                   AR98.3
Element: Tax Print Cd  D = Calc by line - print detail
                       P = Price incl tax - print summary
                       S = Calc by line - print summary
                       T = Calc and print in summary
                       " " = Space

                         ARIOECUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AOESET1   COMPANY       The path is used to keep the records     AR501   AR98.3
          CUSTOMER      unique.