OEICUST – Cust Order Process Interface

System
Accounts Receivable (AR)
Prefix
AEI
Primary key
COMPANY, CUSTOMER
Fields
59
Updated by
1 program
Referenced by
0 programs

OEICUST is the Cust Order Process Interface table in Lawson Accounts Receivable (prefix AEI). It is indexed by COMPANY, CUSTOMER (AEISET1). It is updated by AR550. The table has 59 fields, 1 index and 0 documented relations.

About OEICUST

No description in the Lawson data dictionary.

Fields (59)

Column = COBOL field name without the AEI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AEI-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.—
AEI-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.—
AEI-FREIGHT-CODE
FREIGHT_CODE		Alpha 2This field contains the freight code. This is must be valid in the OE Freight Code file. This determines whether carrier and charge are allowed for the shipment.—
AEI-FRGHT-CODE-CHG
FRGHT_CODE_CHG		Numeric 1Freight code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-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.—
AEI-PK-PRIRITY-CHG
PK_PRIRITY_CHG		Numeric 1Picking priority change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-CARRIER
CARRIER		Alpha 9 (Right Justified)Carrier Vendor Number. Must be a valid vendor number in the Lawson Accounts Payable system.—
AEI-CARRIER-CHG
CARRIER_CHG		Numeric 1Carrier vendor number change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-CIA-FL
CIA_FL		Alpha 1Indicates whether the customer must pay cash in advance. Valid values are
  • N Cash in advance not required
  • Y Cash in advance required
—
AEI-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 the order.—
AEI-CIA-PCT-CHG
CIA_PCT_CHG		Numeric 1Cash in advance percentage change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-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.—
AEI-ORD-DS-CD-CHG
ORD_DS_CD_CHG		Numeric 1Order discount code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-COMM-SPLIT
COMM_SPLIT		Percent 5.3 (Percent)This field contains the commission split. This defaults from the Customer Order Processing file.—
AEI-COMM-SPLIT-CHG
COMM_SPLIT_CHG		Numeric 1Commission split percentage change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-SALESMAN-2
SALESMAN_2		Numeric 4This field contains the code representing the second salesrep. This defaults from the order header.—
AEI-SALESMAN-2-CHG
SALESMAN_2_CHG		Numeric 1Sales rep 2 change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-PRICE-LST
PRICE_LST		Alpha 14Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system.—
AEI-ACKNOW-FL
ACKNOW_FL		Alpha 1Indicates whether the customer requires printed acknowledgments. Valid values are
  • N Acknowledgments not required
  • Y Acknowledgments required
—
AEI-BACK-ORD-FL
BACK_ORD_FL		Alpha 1Indicates whether the customer accepts backorders. Valid values are
  • N Backorders not accepted
  • Y Backorders accepted
—
AEI-SHIP-COMP-FL
SHIP_COMP_FL		Alpha 1Indicates whether orders must be complete for shipment. Valid values are
  • N Accepts partial shipments
  • Y Does not accept partial shipments
—
AEI-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 PO number not required
  • Y PO number required
—
AEI-SUBSTITUTES-FL
SUBSTITUTES_FL		Alpha 1——
AEI-DEF-SHIP-TO
DEF_SHIP_TO		Numeric 4Default ship-to location for the customer.—
AEI-DEF-SHP-TO-CHG
DEF_SHP_TO_CHG		Numeric 1Default ship-to change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-DEF-LOCATION
DEF_LOCATION		Alpha 5Default ship-from or warehouse for the customer.—
AEI-DEF-LOCTIN-CHG
DEF_LOCTIN_CHG		Numeric 1Default location change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-DEF-METHOD
DEF_METHOD		Alpha 10Default shipping method for the customer.—
AEI-DEF-METHOD-CHG
DEF_METHOD_CHG		Numeric 1Default shipping method change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-CUSTOMER-CODE
CUSTOMER_CODE		Alpha 4Customer code. This is a code used to classify customers for Sales Analysis.—
AEI-POD-REQ-FL
POD_REQ_FL		Alpha 1POD required flag. Customer requires that a Proof of Delivery form accompany the shipment. The shipment will not be billed until POD is returned or the POD grace period expires. Valid values are:
  • N POD not required
  • Y POD required
—
AEI-GRACE-PER
GRACE_PER		Numeric 3The number of grace days added to the POD creation date before the customer will be billed.—
AEI-GRACE-PER-CHG
GRACE_PER_CHG		Numeric 1Grace period change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
AEI-SGL-HOLD-CODE
SGL_HOLD_CODE		Alpha 4Hold code applied to a non-COD order when the order total amount exceeds single order limit. If the single order limit is greater than zero, then this field is required. If single order limit is equal to zero and a single order hold code is entered, then every non-COD order will be on hold.—
AEI-SGL-HOLD-CHG
SGL_HOLD_CHG		Numeric 1Single order hold code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
AEI-SGL-ORD-LIM
SGL_ORD_LIM		Signed 13.0——
AEI-SGL-ORD-LM-CHG
SGL_ORD_LM_CHG		Numeric 1Single order limit change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-COD-LIM
COD_LIM		Signed 13.0Total value limit for COD orders.—
AEI-COM-LIM-CHG
COM_LIM_CHG		Numeric 1COD limit change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-COD-HOLD-CODE
COD_HOLD_CODE		Alpha 4Hold code applied to an order if it exceeds the COD order limit.—
AEI-COD-HOLD-CHG
COD_HOLD_CHG		Numeric 1COD hold code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-ENT-CHECK-FL
ENT_CHECK_FL		Alpha 1Indicates whether credit checking is performed when orders are entered. Valid values are
  • N No credit checking performed
  • Y Credit checking performed
—
AEI-PRT-CHECK-FL
PRT_CHECK_FL		Alpha 1Indicates whether credit checking is performed prior to printing picking lists. Valid values are
  • N No credit checking performed
  • Y Credit checking performed
—
AEI-AGE-CRED-PCT
AGE_CRED_PCT		Percent 5.2 (Percent) Occurs 5 Times ×5The percentage of the credit limit allowed for this period.—
AEI-AGE-CRED-CHG
AGE_CRED_CHG		Numeric 1Aging credit percent change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-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.—
AEI-AGE-HOLD-CHG
AGE_HOLD_CHG		Numeric 1Aging hold code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-CR-HOLD-CODE
CR_HOLD_CODE		Alpha 4Indicates whether the customer was put on credit hold. Valid values are:—
AEI-CR-HOLD-CHG
CR_HOLD_CHG		Numeric 1Credit hold code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-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
—
AEI-CR-LIMIT-HOLD
CR_LIMIT_HOLD		Alpha 4Indicates if a customer is on hold for exceeding the credit limit.—
AEI-CR-LIM-HLD-CHG
CR_LIM_HLD_CHG		Numeric 1Credit limit hold code change indicator. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-OR-LIMIT-HOLD
OR_LIMIT_HOLD		Alpha 4Indicates if a customer is on hold for exceeding the order limit.—
AEI-OR-LIM-HLD-CHG
OR_LIM_HLD_CHG		Numeric 1Order limit hold code. Valid values are
  • 0 No change
  • 1 Change this field
—
AEI-LINE-ITEM-REQ
LINE_ITEM_REQ		Alpha 1Indicates if line items are to be produced for an invoice. Valid values are:
  • N Line items are not produced.
  • Y Line items are produced.
—
AEI-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
—
AEI-ALLOW-RETURNS
ALLOW_RETURNS		Alpha 1——
AEI-ALLOW-RTN-DATE
ALLOW_RTN_DATE		Numeric 8 (yyyymmdd)——
AEI-CARRIER-FLAG
CARRIER_FLAG		Alpha 1——

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AEISET1COMPANY, CUSTOMERPrimaryAR550

Programs

Updated by (1)