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.3 (Conversion Customer Order Entry).
UPDATED BY

AR501

AR98.3

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AOE-COMPANY Element: Company	Numeric 4 The number representing an AR company.	AR98.3
AOE-CUSTOMER Element: Customer	Alpha 9 (Right Justified) Required. Customer number.	AR98.3
AOE-FREIGHT-CODE Element: FreightCode	Alpha 2 This field contains the freight code. This determines whether carrier and charge are allowed for the shipment.	AR98.3
AOE-PK-PRIORITY Element: Picking Priority	Numeric 2 Used by batch inventory allocation to determine which customers get option on available inventory.	AR98.3
AOE-CARRIER Carrier Vendor Number	Alpha 9 (Right Justified) Carrier vendor number.	AR98.3
AOE-CIA-FL Element: Cash In Advance	Alpha 1 Indicates whether customers must pay cash in advance. Valid values are: N = Cash in advance not required Y = Cash in advance required	AR98.3
AOE-CIA-PCT Cash In Advance Percent	Percent 8.5 (Percent) Percent of order amount required from the customer before order acceptance. This must be entered if "Y" has been entered in the Cash in Advance field.	AR98.3
AOE-ORD-DISC-CODE Element: Order Discount Code	Alpha 4 Order discount code.	AR98.3
AOE-COMM-SPLIT Commission Split Percentage	Percent 5.3 (Percent) This field contains the commission percent of the total order value to be used as the basis for the second sales representative's commission.	AR98.3
AOE-SALESMAN-2 Element: SalesRep 2	Numeric 4 This field contains the code representing the second salesrep.	AR98.3
AOE-PRICE-LST Element: Price List	Alpha 14 Price list used to automatically price orders.	AR98.3
AOE-ACKNOW-FL Acknowledgement Required	Alpha 1 Indicates whether the customer needs printed acknowledgments. Valid values are: N = Acknowledgments not required Y = Acknowledgments required	AR98.3
AOE-BACK-ORD-FL Element: Backorders Allowed	Alpha 1 Indicates whether the customer accepts backorders. Valid values are: N = Backorders not accepted Y = Backorders accepted	AR98.3
AOE-SHIP-COMP-FL Element: Ship Complete	Alpha 1 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	AR98.3
AOE-PO-REQ-FL Element: PO Required	Alpha 1 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	AR98.3
AOE-SUBSTITUTES-FL Element: All Flag	Alpha 1
AOE-DEF-SHIP-TO Default Ship-to for Location	Numeric 4 Default ship-to location.	AR98.3
AOE-DEF-LOCATION Default Ship-from Location	Alpha 5 Default ship-from location.	AR98.3
AOE-DEF-METHOD Default Shipment Method	Alpha 10 Default shipment method.	AR98.3
AOE-CUSTOMER-CODE Element: Customer Code	Alpha 4 Customer code. This is a code used to classify customers for Sales Analysis.	AR98.3
AOE-POD-REQ-FL Element: POD Required	Alpha 1 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.	AR98.3
AOE-GRACE-PER Element: Grace Period	Numeric 3 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.	AR98.3
AOE-SGL-HOLD-CODE Single Order Hold Code	Alpha 4 Hold code to apply to a non-COD order 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.	AR98.3
AOE-SGL-ORD-LIM Element: Single Order Limit	Signed 13.0 Maximum single order amount for the customer. If blank, the single order limit defined for the customer default code will default.	AR98.3
AOE-COD-LIM Element: COD Limit	Signed 13.0 Maximum amount to limit COD orders for this customer. If left blank, the COD order limit defined in the customer default code defaults.	AR98.3
AOE-COD-HOLD-CODE Element: COD Hold Code	Alpha 4 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.	AR98.3
AOE-ENT-CHECK-FL Element: Order Credit Check	Alpha 1 Indicates 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	AR98.3
AOE-PRT-CHECK-FL Picking List Credit Check	Alpha 1 Indicates whether to perform a credit 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	AR98.3
AOE-AGE-CRED-PCT Age Credit Percentages	Percent 5.2 (Percent) Occurs 5 Times If" Y" is selected for the credit check 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.	AR98.3
AOE-AGE-HOLD-CD Element: Aging Hold Code	Alpha 4 Occurs 5 Times If 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.	AR98.3
AOE-CR-HOLD-CODE Element: Credit Hold Code	Alpha 4 This 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 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	AR98.3
AOE-CR-LIMIT-HOLD Credit Limit Hold Code	Alpha 4 Indicates if a customer is on hold for exceeding the credit limit.	AR98.3
AOE-OR-LIMIT-HOLD Order Limit Hold Code	Alpha 4 Indicated if a customer is on hold for exceeding the order limit.	AR98.3
AOE-CUSRET-INV-MET Return Invoicing Method	Alpha 1 Determines the invoicing method for 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 Element: Line Items Required	Alpha 1 Indicated if line items are produced for an invoice. Valid values are: N = Line items are not produced. Y = Line items are produced.	AR98.3
AOE-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
AOE-ALLOW-RETURNS Element: All Flag	Alpha 1	AR98.3
AOE-ALLOW-RTN-DATE Element: Date	Numeric 8 (yyyymmdd)	AR98.3
AOE-CARRIER-FLAG Element: All Flag	Alpha 1

ARIOECUST FILE INDEX

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