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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OETSET1COMPANY, CUSTOMERPrimaryAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredOET-COMPANY → ACO-COMPANY
ArcustomerARCUSTOMERRequiredOET-COMPANY → ACM-COMPANY, OET-CUSTOMER → ACM-CUSTOMER
CranalystCRANALYSTNot RequiredOET-COMPANY → CAN-COMPANY, ACM-CREDIT-ANLYST → CAN-CREDIT-ANLYST
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, OET-CUSTOMER → CUD-CUSTOMER
HoldcodesHOLDCODESNot RequiredACO-CUST-GROUP → HDD-CUST-GROUP, ACM-HOLD-CODE → HDD-HOLD-CODE

Programs

Updated by (6)

Referenced by (294)