OECUST – Customer Order Processing

System
Accounts Receivable (AR)
Prefix
OET
Primary key
COMPANY, CUSTOMER
Fields
59
Updated by
6 programs
Referenced by
294 programs

OECUST is the Customer Order Processing table in Lawson Accounts Receivable (prefix OET). It is indexed by COMPANY, CUSTOMER (OETSET1). It is related 1:1 to ARCOMP, ARCUSTOMER, CRANALYST, CUSTDESC and HOLDCODES. It is updated by AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 and 286 more. The table has 59 fields, 1 index and 5 documented relations.

About OECUST

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

Fields (59)

Column = COBOL field name without the OET- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OET-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-INCOMPLETE-FL
INCOMPLETE_FL		Alpha 1Incomplete indicator for customer addition control.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-FREIGHT-CODE
FREIGHT_CODE		Alpha 2This 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
PK_PRIORITY		Numeric 2Pick 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
CARRIER		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
CIA_FL		Alpha 1Indicates 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
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
ORD_DISC_CODE		Alpha 4Order 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
TERRITORY		Alpha 4Sales Territory.AR501, AR550
#OET-SALESMAN-2
SALESMAN_2		Numeric 4This field contains the code representing the second salesrep. This defaults from the order header.AR10.1, AR501, AR550
#OET-COMM-SPLIT
COMM_SPLIT		Percent 5.3 (Percent)This field contains the commission split.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-PRICE-LST
PRICE_LST		Alpha 14Used 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
ACKNOW_FL		Alpha 1Indicates 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
BACK_ORD_FL		Alpha 1Indicates 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
SHIP_COMP_FL		Alpha 1Indicates 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
PO_REQ_FL		Alpha 1Indicates 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
SUBSTITUTES_FL		Alpha 1——
#OET-DEF-SHIP-TO
DEF_SHIP_TO		Numeric 4Default ship-to location for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-DEF-LOCATION
DEF_LOCATION		Alpha 5Default ship-from location or warehouse for customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-DEF-METHOD
DEF_METHOD		Alpha 10Default shipping method for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-CUSTOMER-CODE
CUSTOMER_CODE		Alpha 4Customer code. This is a code used to classify customers for Sales Analysis.AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-POD-REQ-FL
POD_REQ_FL		Alpha 1POD 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
GRACE_PER		Numeric 3The 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
SGL_ORD_LIM		Signed 13.0Maximum single order amount for the customer.AR10.1, AR501, AR550
#OET-SGL-HOLD-CODE
SGL_HOLD_CODE		Alpha 4Hold 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
COD_LIM		Signed 13.0Total value limit for COD orders.AR10.1, AR501, AR550
#OET-COD-HOLD-CODE
COD_HOLD_CODE		Alpha 4This is the hold code applied to the order if it exceeds the COD order limit.AR10.1, AR501, AR550
#OET-ENT-CHECK-FL
ENT_CHECK_FL		Alpha 1Entry check flag indicates whether credit checking is performed when orders are entered.
  • N No
  • Y Yes
AR10.1, AR501, AR550
#OET-PRT-CHECK-FL
PRT_CHECK_FL		Alpha 1Print 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
AGE_CRED_PCT		Percent 5.2 (Percent) Occurs 5 Times ×5The percentage of credit limit allowed for this period.AR10.1, AR501, AR550
#OET-AGE-HOLD-CD
AGE_HOLD_CD		Alpha 4 Occurs 5 Times ×5The 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
BRKN_CS_CHRG		Alpha 1This 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
CR_LIMIT_HOLD		Alpha 4Indicates whether a customer is on hold due to exceeding credit limit.AR10.1, AR501, AR550
#OET-OR-LIMIT-HOLD
OR_LIMIT_HOLD		Alpha 4Indicates whether a customer is on hold due to exceeding the order limit.AR10.1, AR501, AR550
#OET-AGING-1
AGING_1		DerivedThe first occurrence of the customer static aging amount.—
#OET-AGING-2
AGING_2		DerivedThe second occurrence of the customer static aging amount.—
#OET-AGING-3
AGING_3		DerivedThe third occurrence of the customer static aging amount.—
#OET-AGING-4
AGING_4		DerivedThe fourth occurrence of the customer static aging amount.—
#OET-AGING-5
AGING_5		DerivedThe fifth occurrence of the customer static aging amount.—
#OET-AGE-PCT-1
AGE_PCT_1		DerivedThe first occurrence of the age credit percentage.—
#OET-AGE-PCT-2
AGE_PCT_2		DerivedThe second occurrence of the age credit percentage.—
#OET-AGE-PCT-3
AGE_PCT_3		DerivedThe third occurrence of the age credit percentage.—
#OET-AGE-PCT-4
AGE_PCT_4		DerivedThe fourth occurrence of the age credit percentage.—
#OET-AGE-PCT-5
AGE_PCT_5		DerivedThe fifth occurrence of the age credit percentage.—
#OET-AGE-LIMIT-1
AGE_LIMIT_1		DerivedThe first occurrence of the age credit percentage multiplied by the first occurrence of the static aging amount.—
#OET-AGE-LIMIT-2
AGE_LIMIT_2		DerivedThe second occurrence of the age credit percentage multiplied by the second occurrence of the static aging amount.—
#OET-AGE-LIMIT-3
AGE_LIMIT_3		DerivedThe third occurrence of the age credit percentage multiplied by the third occurrence of the static aging amount.—
#OET-AGE-LIMIT-4
AGE_LIMIT_4		DerivedThe fourth occurrence of the age credit percentage multiplied by the fourth occurrence of the static aging amount.—
#OET-AGE-LIMIT-5
AGE_LIMIT_5		DerivedThe fifth occurrence of the age credit percentage multiplied by the fifth occurrence of the static aging amount.—
#OET-LINE-ITEM-REQ
LINE_ITEM_REQ		Alpha 1Indicates 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
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AR10.1
#OET-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AR10.1
#OET-FOB-CODE
FOB_CODE		Alpha 3The user defined Free On Board Code.AR10.1
#OET-PORT-CD
PORT_CD		Alpha 5The Intrastat port code. Must be define in IN04.1 (Port Maintenance)AR10.1
#OET-TAX-PRINT-CD
TAX_PRINT_CD		Alpha 1" " = Space
  • D Calc by line - print detail
  • P Price incl tax - print summary
  • S Calc by line - print summary
  • T Calc and print in summary
—
#OET-ALLOW-RETURNS
ALLOW_RETURNS		Alpha 1" "
  • Y Yes
  • N No
  • L Limit
AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-ALLOW-RTN-DATE
ALLOW_RTN_DATE		Numeric 8 (yyyymmdd)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
#OET-CARRIER-FLAG
CARRIER_FLAG		Alpha 1—AR10.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OETSET1
  1. COMPANY
  2. CUSTOMER
PrimaryAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTOMERCRANALYSTCUSTDESCHOLDCODESOECUST

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
OET-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
OET-COMPANY→ACM-COMPANY
OET-CUSTOMER→ACM-CUSTOMER
CranalystCRANALYSTNot Required
OET-COMPANY→CAN-COMPANY
ACM-CREDIT-ANLYST→CAN-CREDIT-ANLYST
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
OET-CUSTOMER→CUD-CUSTOMER
HoldcodesHOLDCODESNot Required
ACO-CUST-GROUP→HDD-CUST-GROUP
ACM-HOLD-CODE→HDD-HOLD-CODE

Programs

Updated by (6)

Referenced by (294)