Customer Order Processing

The Customer Order Processing file contains customer order processing information for use in the Lawson Order Entry system.

REFERENCED BY

AP125	AP126	AP131	AP20.1	AP20.2	AP20.3
AP20.4	AP20.5	AP20.7	AP21.1	AP23.1	AP25.1
AP25.2	AP26.1	AP27.1	AP30.4	API1.1	API2.1
AR08.1	AR12.1	AR12.2	AR210	CB06.2	MA41.1
MA41.2	MA41.4	MA41.7	MA43.1	MA43.2	MA43.3
MA43.4	MA43.6	MA43.7	MAI1.1	PO136	PO190
PO300	PO520	POCP.1	POI3.1	POII.1	POIJ.1
TX40.1

UPDATED BY

AR09.1

AR10.1

AR301

AR501

AR550

TX140

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OET-COMPANY Element: Company	Numeric 4 The number representing an AR company.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-CUSTOMER Element: Customer	Alpha 9 (Right Justified) Customer number.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-INCOMPLETE-FL Element: Incomplete Fl	Alpha 1 Incomplete indicator for customer addition control.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-FREIGHT-CODE Element: Freight Code	Alpha 2 This field contains the freight code. This determines whether carrier and charges are allowed for the shipment.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-PK-PRIORITY Element: Pk Priority	Numeric 2 Pick priority assigned to this customer. Used by batch inventory allocation to determine which customers get first option on available inventory.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-CARRIER Element: Vendor	Alpha 9 (Right Justified) Carrier Vendor Number. Must be a valid vendor number in the Lawson Accounts Payable system.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-CIA-FL Element: Cia Fl	Alpha 1 Indicates whether the customer must pay cash in advance. Valid values are: N = No Y = Yes	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-CIA-PCT Element: Cia Pct	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 an order.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-ORD-DISC-CODE Element: Ord Disc 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.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-TERRITORY Element: Territory	Alpha 4 Sales Territory.	AR501 AR550
OET-SALESMAN-2 Element: SalesRep2	Numeric 4 This field contains the code representing the second salesrep. This defaults from the order header.	AR10.1 AR501 AR550
OET-COMM-SPLIT Element: Comm Split	Percent 5.3 (Percent) This field contains the commission split.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-PRICE-LST Element: Price List	Alpha 14 Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-ACKNOW-FL Element: Acknow Fl	Alpha 1 Indicates whether the customer requires printed acknowledgments. Valid values are: N = No; acknowledgments not required Y = Yes; acknowledgments required	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-BACK-ORD-FL Element: Back Ord Fl	Alpha 1 Indicates whether the customer accepts backorders. Valid values are: N = No; backorders not accepted Y = Yes; backorders accepted	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-SHIP-COMP-FL Element: Ship Complete	Alpha 1 Indicates whether orders must be complete for shipment. Valid values are: N = No; partial shipments accepted Y = Yes; shipments must be complete	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-PO-REQ-FL Element: PO Required	Alpha 1 Indicates whether the customer's purchase order number must be entered before releasing an order. N = No Y = Yes	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-SUBSTITUTES-FL Element: All Flag	Alpha 1
OET-DEF-SHIP-TO Element: Ship To	Numeric 4 Default ship-to location for the customer.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-DEF-LOCATION Element: Location	Alpha 5 Default ship-from location or warehouse for customer.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-DEF-METHOD Element: Def Method	Alpha 10 Default shipping method for the customer.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-CUSTOMER-CODE Element: Customer Code	Alpha 4 Customer code. This is a code used to classify customers for Sales Analysis.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-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. N = No Y = Yes	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-GRACE-PER Element: Grace Period	Numeric 3 The number of grace days added to the POD creation date before the customer will be billed.	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-SGL-ORD-LIM Element: Single Order Limit	Signed 13.0 Maximum single order amount for the customer.	AR10.1 AR501 AR550
OET-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 is equal to zero and a single order hold code is entered, then every non-COD order will be on hold.	AR10.1 AR501 AR550
OET-COD-LIM Element: COD Limit	Signed 13.0 Total value limit for COD orders.	AR10.1 AR501 AR550
OET-COD-HOLD-CODE Element: COD Hold Code	Alpha 4 This is the hold code applied to the order if it exceeds the COD order limit.	AR10.1 AR501 AR550
OET-ENT-CHECK-FL Order Entry Credit Check	Alpha 1 Entry check flag indicates whether credit checking is performed when orders are entered. N = No Y = Yes	AR10.1 AR501 AR550
OET-PRT-CHECK-FL Print Picking Credit Check	Alpha 1 Print check flag indicates whether credit checking is performed prior to printing picking lists. N = No Y = Yes	AR10.1 AR501 AR550
OET-AGE-CRED-PCT Element: Age Credit Percent	Percent 5.2 (Percent) Occurs 5 Times The percentage of credit limit allowed for this period.	AR10.1 AR501 AR550
OET-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.	AR10.1 AR501 AR550
OET-BRKN-CS-CHRG Element: Brkn Cs Chrg	Alpha 1 This flag determines if there is a charge if a broken case is required to satisfy an order in Order Entry. N = No Y = Yes	AR10.1 AR501 AR550
OET-CR-LIMIT-HOLD Credit Limit Hold Code	Alpha 4 Indicates whether a customer is on hold due to exceeding credit limit.	AR10.1 AR501 AR550
OET-OR-LIMIT-HOLD Order Limit Hold Code	Alpha 4 Indicates whether a customer is on hold due to exceeding the order limit.	AR10.1 AR501 AR550
OET-AGING-1 Element: Aging 1	Derived The first occurrence of the customer static aging amount.
OET-AGING-2 Element: Aging 2	Derived The second occurrence of the customer static aging amount.
OET-AGING-3 Element: Aging 3	Derived The third occurrence of the customer static aging amount.
OET-AGING-4 Element: Aging 4	Derived The fourth occurrence of the customer static aging amount.
OET-AGING-5 Element: Aging 5	Derived The fifth occurrence of the customer static aging amount.
OET-AGE-PCT-1 Element: Aging Percent 1	Derived The first occurrence of the age credit percentage.
OET-AGE-PCT-2 Element: Aging Percent 2	Derived The second occurrence of the age credit percentage.
OET-AGE-PCT-3 Element: Aging Percent 3	Derived The third occurrence of the age credit percentage.
OET-AGE-PCT-4 Element: Aging Percent 4	Derived The fourth occurrence of the age credit percentage.
OET-AGE-PCT-5 Element: Aging Percent 5	Derived The fifth occurrence of the age credit percentage.
OET-AGE-LIMIT-1 Element: Aging Limit 1	Derived The first occurrence of the age credit percentage multiplied by the first occurrence of the static aging amount.
OET-AGE-LIMIT-2 Element: Aging Limit 2	Derived The second occurrence of the age credit percentage multiplied by the second occurrence of the static aging amount.
OET-AGE-LIMIT-3 Element: Aging Limit 3	Derived The third occurrence of the age credit percentage multiplied by the third occurrence of the static aging amount.
OET-AGE-LIMIT-4 Element: Aging Limit 4	Derived The fourth occurrence of the age credit percentage multiplied by the fourth occurrence of the static aging amount.
OET-AGE-LIMIT-5 Element: Aging Limit 5	Derived The fifth occurrence of the age credit percentage multiplied by the fifth occurrence of the static aging amount.
OET-LINE-ITEM-REQ Element: Line Item Required	Alpha 1 Indicates if line items are to be interfaced into Accounts Receivable for an invoice. Valid values are: N = Line items are not interfaced Y = Line items are interfaced	AR10.1 AR501 AR550
OET-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor's identification code.	AR10.1
OET-PURCH-FR-LOC Element: Purch Fr Loc	Alpha 4 The vendor's purchase from location.	AR10.1
OET-FOB-CODE Element: Fob Code	Alpha 3 The user defined Free On Board Code.	AR10.1
OET-PORT-CD Element: Port Cd	Alpha 5 The Intrastat port code. Must be define in IN04.1 (Port Maintenance)	AR10.1
OET-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
OET-ALLOW-RETURNS Element: All Flag	Alpha 1 " " Y = Yes N = No L = Limit	AR09.1 AR10.1 AR301 AR501 AR550 TX140
OET-ALLOW-RTN-DATE Element: Date	Numeric 8 (yyyymmdd)	AR09.1 AR10.1 AR301 AR501 AR550 TX140

OECUST FILE INDEX

OECUST FILE RELATIONS

ONE TO ONE RELATIONS

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