Cust Order Process Interface

The Customer Order Processing Interface file is used to interface customer records from an external source. Records in this file have been interfaced from an external source and will be added or changed in the Accounts Receivable system via AR550 (Customer Interface), and can be maintained in AR96 Interface Customer.
UPDATED BY

AR550

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AEI-COMPANY Element: Company	Numeric 4 The number representing an AR company.
AEI-CUSTOMER Element: Customer Number	Alpha 9 (Right Justified) This field contains the number that represents a customer.
AEI-FREIGHT-CODE Element: Freight Code	Alpha 2 This field contains the freight code. This is must be valid in the OE Freight Code file. This determines whether carrier and charge are allowed for the shipment.
AEI-FRGHT-CODE-CHG Element: Freight Code Change	Numeric 1 Freight code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-PK-PRIORITY Element: Picking Priority	Numeric 2 Pick priority assigned to this customer. Used by batch inventory allocation to determine which customers get first option on available inventory.
AEI-PK-PRIRITY-CHG Picking Priority Change	Numeric 1 Picking priority change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CARRIER Carrier Vendor Number	Alpha 9 (Right Justified) Carrier Vendor Number. Must be a valid vendor number in the Lawson Accounts Payable system.
AEI-CARRIER-CHG Carrier Vendor Number Change	Numeric 1 Carrier vendor number change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CIA-FL Element: Cash In Advance Flag	Alpha 1 Indicates whether the customer must pay cash in advance. Valid values are N = Cash in advance not required Y = Cash in advance required
AEI-CIA-PCT Cash In Advance Percent	Percent 8.5 (Percent) If cash in advance is required, this field indicates the percentage of the order amount required from the customer before accepting the order.
AEI-CIA-PCT-CHG Cash In Advance Percent Change	Numeric 1 Cash in advance percentage change indicator. Valid values are 0 = No change 1 = Change this field
AEI-ORD-DISC-CODE Element: Order Discount Code	Alpha 4 Order discount code used to assess discounts on customer orders. Must be a valid order discount code in the Lawson Order Entry system.
AEI-ORD-DS-CD-CHG Order Discount Code Change	Numeric 1 Order discount code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COMM-SPLIT Commission Split Percentage	Percent 5.3 (Percent) This field contains the commission split. This defaults from the Customer Order Processing file.
AEI-COMM-SPLIT-CHG Commission Split Pct Change	Numeric 1 Commission split percentage change indicator. Valid values are 0 = No change 1 = Change this field
AEI-SALESMAN-2 Element: Sales Rep Number 2	Numeric 4 This field contains the code representing the second salesrep. This defaults from the order header.
AEI-SALESMAN-2-CHG Sales Rep Number 2 Change	Numeric 1 Sales rep 2 change indicator. Valid values are 0 = No change 1 = Change this field
AEI-PRICE-LST Element: Price List	Alpha 14 Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system.
AEI-ACKNOW-FL Acknowledgment Required Flag	Alpha 1 Indicates whether the customer requires printed acknowledgments. Valid values are N = Acknowledgments not required Y = Acknowledgments required
AEI-BACK-ORD-FL Backorders Allowed Flag	Alpha 1 Indicates whether the customer accepts backorders. Valid values are N = Backorders not accepted Y = Backorders accepted
AEI-SHIP-COMP-FL Element: Ship Complete Flag	Alpha 1 Indicates whether orders must be complete for shipment. Valid values are N = Accepts partial shipments Y = Does not accept partial shipments
AEI-PO-REQ-FL Purchase Order Required Flag	Alpha 1 Indicates whether the customer's purchase order number must be entered before releasing an order. Valid values are N = PO number not required Y = PO number required
AEI-SUBSTITUTES-FL Element: All Flag	Alpha 1
AEI-DEF-SHIP-TO Default Ship-to For Customer	Numeric 4 Default ship-to location for the customer.
AEI-DEF-SHP-TO-CHG Default Ship-to Change	Numeric 1 Default ship-to change indicator. Valid values are 0 = No change 1 = Change this field
AEI-DEF-LOCATION Default Location For Operator	Alpha 5 Default ship-from or warehouse for the customer.
AEI-DEF-LOCTIN-CHG Default Location Change	Numeric 1 Default location change indicator. Valid values are 0 = No change 1 = Change this field
AEI-DEF-METHOD Default Ship-to Method	Alpha 10 Default shipping method for the customer.
AEI-DEF-METHOD-CHG Default Ship-to Method Change	Numeric 1 Default shipping method change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CUSTOMER-CODE Element: Customer Code	Alpha 4 Customer code. This is a code used to classify customers for Sales Analysis.
AEI-POD-REQ-FL Element: POD Required Flag	Alpha 1 POD required flag. Customer requires that a Proof of Delivery form accompany the shipment. The shipment will not be billed until POD is returned or the POD grace period expires. Valid values are: N = POD not required Y = POD required
AEI-GRACE-PER Element: Grace Period	Numeric 3 The number of grace days added to the POD creation date before the customer will be billed.
AEI-GRACE-PER-CHG Element: Grace Period Change	Numeric 1 Grace period change indicator. Valid values are: 0 = No change 1 = Change this field
AEI-SGL-HOLD-CODE Single Order Hold Code	Alpha 4 Hold code applied to a non-COD order when the order total amount exceeds single order limit. If the single order limit is greater than zero, then this field is required. If single order limit is equal to zero and a single order hold code is entered, then every non-COD order will be on hold.
AEI-SGL-HOLD-CHG Single Order Hold Code Change	Numeric 1 Single order hold code change indicator. Valid values are: 0 = No change 1 = Change this field
AEI-SGL-ORD-LIM Element: Single Order Limit	Signed 13.0
AEI-SGL-ORD-LM-CHG Single Order Limit Change	Numeric 1 Single order limit change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COD-LIM Element: COD Limit	Signed 13.0 Total value limit for COD orders.
AEI-COM-LIM-CHG Element: COD Limit Change	Numeric 1 COD limit change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COD-HOLD-CODE Element: COD Hold Code	Alpha 4 Hold code applied to an order if it exceeds the COD order limit.
AEI-COD-HOLD-CHG Element: COD Hold Code Change	Numeric 1 COD hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-ENT-CHECK-FL Element: Order Credit Check	Alpha 1 Indicates whether credit checking is performed when orders are entered. Valid values are N = No credit checking performed Y = Credit checking performed
AEI-PRT-CHECK-FL Picking List Credit Check	Alpha 1 Indicates whether credit checking is performed prior to printing picking lists. Valid values are N = No credit checking performed Y = Credit checking performed
AEI-AGE-CRED-PCT Age Credit Percentages	Percent 5.2 (Percent) Occurs 5 Times The percentage of the credit limit allowed for this period.
AEI-AGE-CRED-CHG Age Credit Percentages Change	Numeric 1 Aging credit percent change indicator. Valid values are 0 = No change 1 = Change this field
AEI-AGE-HOLD-CD Element: Aging Hold Code	Alpha 4 Occurs 5 Times The hold code applied to an order if it is added when the customer fails the credit check because of the aging period limit.
AEI-AGE-HOLD-CHG Aging Hold Code Change	Numeric 1 Aging hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CR-HOLD-CODE Element: Credit Hold Code	Alpha 4 Indicates whether the customer was put on credit hold. Valid values are:
AEI-CR-HOLD-CHG Credit Hold Code Change	Numeric 1 Credit hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-BRKN-CS-CHRG Element: Broken Case Charge	Alpha 1 Determines 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
AEI-CR-LIMIT-HOLD Credit Limit Hold Code	Alpha 4 Indicates if a customer is on hold for exceeding the credit limit.
AEI-CR-LIM-HLD-CHG Credit Limit Hold Code Change	Numeric 1 Credit limit hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-OR-LIMIT-HOLD Order Limit Hold Code	Alpha 4 Indicates if a customer is on hold for exceeding the order limit.
AEI-OR-LIM-HLD-CHG Order Limit Hold Code Change	Numeric 1 Order limit hold code. Valid values are 0 = No change 1 = Change this field
AEI-LINE-ITEM-REQ Element: Line Items Required	Alpha 1 Indicates if line items are to be produced for an invoice. Valid values are: N = Line items are not produced. Y = Line items are produced.
AEI-TAX-PRINT-CD Element: Tax Print Cd	Alpha 1 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
AEI-ALLOW-RETURNS Element: All Flag	Alpha 1
AEI-ALLOW-RTN-DATE Element: Date	Numeric 8 (yyyymmdd)

OEICUST FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.