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) |
|
|
AEI-CARRIER-FLAG Element: All Flag | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
AEISET1 |
COMPANY CUSTOMER |
|
|
All trademarks and registered trademarks are the property of their
respective owners.