OECUST

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OETSET1 COMPANY
CUSTOMER
...
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 AR09.1
AR10.1 AR10.5
AR12.1 AR12.2
AR210 AR301
AR501 AR550
CB06.2 MA41.1


OECUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OET-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
OET-COMPANY->ACM-COMPANY
OET-CUSTOMER->ACM-CUSTOMER
Cranalyst CRANALYST Not Required
OET-COMPANY->CAN-COMPANY
ACM-CREDIT-ANLYST->CAN-CREDIT-ANLYST
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
OET-CUSTOMER->CUD-CUSTOMER
Holdcodes HOLDCODES Not Required
ACO-CUST-GROUP->HDD-CUST-GROUP
ACM-HOLD-CODE->HDD-HOLD-CODE

File created: Wed Jun 08 20:47:57 2016

Home
Contact Us



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