ARIOECUST – Customer Order Processing Conv

System
Accounts Receivable (AR)
Prefix
AOE
Primary key
COMPANY, CUSTOMER
Fields
40
Updated by
2 programs
Referenced by
0 programs

ARIOECUST is the Customer Order Processing Conv table in Lawson Accounts Receivable (prefix AOE). It is indexed by COMPANY, CUSTOMER (AOESET1). It is updated by AR501 and AR98.3. The table has 40 fields, 1 index and 0 documented relations.

About ARIOECUST

No description in the Lawson data dictionary.

Fields (40)

Column = COBOL field name without the AOE- 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
#AOE-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR98.3
#AOE-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Required. Customer number.AR98.3
#AOE-FREIGHT-CODE
FREIGHT_CODE		Alpha 2This field contains the freight code. This determines whether carrier and charge are allowed for the shipment.AR98.3
#AOE-PK-PRIORITY
PK_PRIORITY		Numeric 2Used by batch inventory allocation to determine which customers get option on available inventory.AR98.3
#AOE-CARRIER
CARRIER		Alpha 9 (Right Justified)Carrier vendor number.AR98.3
#AOE-CIA-FL
CIA_FL		Alpha 1Indicates 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
CIA_PCT		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
ORD_DISC_CODE		Alpha 4Order discount code.AR98.3
#AOE-COMM-SPLIT
COMM_SPLIT		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
SALESMAN_2		Numeric 4This field contains the code representing the second salesrep.AR98.3
#AOE-PRICE-LST
PRICE_LST		Alpha 14Price list used to automatically price orders.AR98.3
#AOE-ACKNOW-FL
ACKNOW_FL		Alpha 1Indicates whether the customer needs printed acknowledgments. Valid values are:
  • N Acknowledgments not required
  • Y Acknowledgments required
AR98.3
#AOE-BACK-ORD-FL
BACK_ORD_FL		Alpha 1Indicates whether the customer accepts backorders. Valid values are:
  • N Backorders not accepted
  • Y Backorders accepted
AR98.3
#AOE-SHIP-COMP-FL
SHIP_COMP_FL		Alpha 1Indicates whether orders must be complete prior to shipment. Valid values are: shipments order shipments
  • N Customer accepts partial order
  • Y Customer does not accept partial
AR98.3
#AOE-PO-REQ-FL
PO_REQ_FL		Alpha 1Indicates 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
SUBSTITUTES_FL		Alpha 1——
#AOE-DEF-SHIP-TO
DEF_SHIP_TO		Numeric 4Default ship-to location.AR98.3
#AOE-DEF-LOCATION
DEF_LOCATION		Alpha 5Default ship-from location.AR98.3
#AOE-DEF-METHOD
DEF_METHOD		Alpha 10Default shipment method.AR98.3
#AOE-CUSTOMER-CODE
CUSTOMER_CODE		Alpha 4Customer code. This is a code used to classify customers for Sales Analysis.AR98.3
#AOE-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.AR98.3
#AOE-GRACE-PER
GRACE_PER		Numeric 3Grace 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
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 equals zero and single hold code is entered, then every non-COD order will be on hold.AR98.3
#AOE-SGL-ORD-LIM
SGL_ORD_LIM		Signed 13.0Maximum 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
COD_LIM		Signed 13.0Maximum 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
COD_HOLD_CODE		Alpha 4If 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
ENT_CHECK_FL		Alpha 1Indicates 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
PRT_CHECK_FL		Alpha 1Indicates 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_CRED_PCT		Percent 5.2 (Percent) Occurs 5 Times ×5If" 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
AGE_HOLD_CD		Alpha 4 Occurs 5 Times ×5If 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
CR_HOLD_CODE		Alpha 4This 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
BRKN_CS_CHRG		Alpha 1Determines 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
CR_LIMIT_HOLD		Alpha 4Indicates if a customer is on hold for exceeding the credit limit.AR98.3
#AOE-OR-LIMIT-HOLD
OR_LIMIT_HOLD		Alpha 4Indicated if a customer is on hold for exceeding the order limit.AR98.3
#AOE-CUSRET-INV-MET
CUSRET_INV_MET		Alpha 1Determines 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
LINE_ITEM_REQ		Alpha 1Indicated 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
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
—
#AOE-ALLOW-RETURNS
ALLOW_RETURNS		Alpha 1—AR98.3
#AOE-ALLOW-RTN-DATE
ALLOW_RTN_DATE		Numeric 8 (yyyymmdd)—AR98.3
#AOE-CARRIER-FLAG
CARRIER_FLAG		Alpha 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
AOESET1
  1. COMPANY
  2. CUSTOMER
PrimaryAR501, AR98.3

Programs

Updated by (2)