OEICUST FILE
Cust Order Process Interface
The Customer Order Processing Interface file is used to interface customer
records from an external source. Records in this file have been interfaced
from an external source and will be added or changed in the Accounts
Receivable system via AR550 (Customer Interface).
UPDATED BY
AR550
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEI-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
AEI-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
AEI-FREIGHT-CODE Alpha 2
Freight Code This 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 Numeric 1
Freight Code Change Freight code change indicator. Valid
values are
0 = No change
1 = Change this field
AEI-PK-PRIORITY Numeric 2
Picking Priority Pick priority assigned to this
customer. Used by batch inventory
allocation to determine which customers
get first option on available inventory.
AEI-PK-PRIRITY-CHG Numeric 1
Picking Priority Picking priority change indicator.
Change Valid values are
0 = No change
1 = Change this field
AEI-CARRIER Alpha 9 (Right Justified)
Carrier Vendor Carrier Vendor Number. Must be a valid
Number vendor number in the Lawson Accounts
Payable system.
AEI-CARRIER-CHG Numeric 1
Carrier Vendor Carrier vendor number change indicator.
Number Change Valid values are
0 = No change
1 = Change this field
AEI-CIA-FL Alpha 1
Cash In Advance Flag Indicates 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 Percent 8.5 (Percent)
Cash In Advance If cash in advance is required, this
Percent field indicates the percentage of the
order amount required from the customer
before accepting the order.
AEI-CIA-PCT-CHG Numeric 1
Cash In Advance Cash in advance percentage change
Percent Change indicator. Valid values are
0 = No change
1 = Change this field
AEI-ORD-DISC-CODE Alpha 4
Order Discount Code Order 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 Numeric 1
Order Discount Code Order discount code change indicator.
Change Valid values are
0 = No change
1 = Change this field
AEI-COMM-SPLIT Percent 5.3 (Percent)
Commission Split This field contains the commission
Percentage split. This defaults from the Customer
Order Processing file.
AEI-COMM-SPLIT-CHG Numeric 1
Commission Split Commission split percentage change
Pct Change indicator. Valid values are
0 = No change
1 = Change this field
AEI-SALESMAN-2 Numeric 4
Sales Rep Number 2 This field contains the code
representing the second salesrep. This
defaults from the order header.
AEI-SALESMAN-2-CHG Numeric 1
Sales Rep Number 2 Sales rep 2 change indicator. Valid
Change values are
0 = No change
1 = Change this field
AEI-PRICE-LST Alpha 14
Price List Used to automatically price orders.
Must be a valid price list in the Lawson
Order Entry system.
AEI-ACKNOW-FL Alpha 1
Acknowledgment Indicates whether the customer requires
Required Flag printed acknowledgments. Valid values
are
N = Acknowledgments not required
Y = Acknowledgments required
AEI-BACK-ORD-FL Alpha 1
Backorders Allowed Indicates whether the customer accepts
Flag backorders. Valid values are
N = Backorders not accepted
Y = Backorders accepted
AEI-SHIP-COMP-FL Alpha 1
Ship Complete Flag Indicates whether orders must be
complete for shipment. Valid values are
N = Accepts partial shipments
Y = Does not accept partial shipments
AEI-PO-REQ-FL Alpha 1
Purchase Order Indicates whether the customer's
Required Flag purchase order number must be entered
before releasing an order. Valid values
are
N = PO number not required
Y = PO number required
AEI-DEF-SHIP-TO Numeric 4
Default Ship-to For Default ship-to location for the
Customer customer.
AEI-DEF-SHP-TO-CHG Numeric 1
Default Ship-to Default ship-to change indicator. Valid
Change values are
0 = No change
1 = Change this field
AEI-DEF-LOCATION Alpha 5
Default Location Default ship-from or warehouse for the
For Operator customer.
AEI-DEF-LOCTIN-CHG Numeric 1
Default Location Default location change indicator.
Change Valid values are
0 = No change
1 = Change this field
AEI-DEF-METHOD Alpha 10
Default Ship-to Default shipping method for the
Method customer.
AEI-DEF-METHOD-CHG Numeric 1
Default Ship-to Default shipping method change
Method Change indicator. Valid values are
0 = No change
1 = Change this field
AEI-CUSTOMER-CODE Alpha 4
Customer Code Customer code. This is a code used to
classify customers for Sales Analysis.
AEI-POD-REQ-FL Alpha 1
POD Required Flag POD 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 Numeric 3
Grace Period The number of grace days added to the
POD creation date before the customer
will be billed.
AEI-GRACE-PER-CHG Numeric 1
Grace Period Change Grace period change indicator. Valid
values are:
0 = No change
1 = Change this field
AEI-SGL-HOLD-CODE Alpha 4
Single Order Hold Hold code applied to a non-COD order
Code 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 Numeric 1
Single Order Hold Single order hold code change
Code Change indicator. Valid values are:
0 = No change
1 = Change this field
AEI-SGL-ORD-LIM Signed 13.0
Single Order Limit Maximum amount allowed for a single
order.
AEI-SGL-ORD-LM-CHG Numeric 1
Single Order Limit Single order limit change indicator.
Change Valid values are
0 = No change
1 = Change this field
AEI-COD-LIM Signed 13.0
COD Limit Total value limit for COD orders.
AEI-COM-LIM-CHG Numeric 1
COD Limit Change COD limit change indicator. Valid
values are
0 = No change
1 = Change this field
AEI-COD-HOLD-CODE Alpha 4
COD Hold Code Hold code applied to an order if it
exceeds the COD order limit.
AEI-COD-HOLD-CHG Numeric 1
COD Hold Code Change COD hold code change indicator. Valid
values are
0 = No change
1 = Change this field
AEI-ENT-CHECK-FL Alpha 1
Order Credit Check Indicates 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 Alpha 1
Picking List Credit Indicates whether credit checking is
Check performed prior to printing picking
lists. Valid values are
N = No credit checking performed
Y = Credit checking performed
AEI-AGE-CRED-PCT Percent 5.2 (Percent) Occurs 5 Times
Age Credit The percentage of the credit limit
Percentages allowed for this period.
AEI-AGE-CRED-CHG Numeric 1
Age Credit Aging credit percent change indicator.
Percentages Change Valid values are
0 = No change
1 = Change this field
AEI-AGE-HOLD-CD Alpha 4 Occurs 5 Times
Aging Hold Code The 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 Numeric 1
Aging Hold Code Aging hold code change indicator. Valid
Change values are
0 = No change
1 = Change this field
AEI-CR-HOLD-CODE Alpha 4
Credit Hold Code Indicates whether the customer was put
on credit hold. Valid values are:
AEI-CR-HOLD-CHG Numeric 1
Credit Hold Code Credit hold code change indicator.
Change Valid values are
0 = No change
1 = Change this field
AEI-BRKN-CS-CHRG Alpha 1
Broken Case Charge Determines 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 Alpha 4
Credit Limit Hold Indicates if a customer is on hold for
Code exceeding the credit limit.
AEI-CR-LIM-HLD-CHG Numeric 1
Credit Limit Hold Credit limit hold code change
Code Change indicator. Valid values are
0 = No change
1 = Change this field
AEI-OR-LIMIT-HOLD Alpha 4
Order Limit Hold Indicates if a customer is on hold for
Code exceeding the order limit.
AEI-OR-LIM-HLD-CHG Numeric 1
Order Limit Hold Order limit hold code. Valid values are
Code Change
0 = No change
1 = Change this field
AEI-LINE-ITEM-REQ Alpha 1
Line Items Required Indicates if line items are to be
produced for an invoice. Valid values
are:
N = Line items are not produced.
Y = Line items are produced.
OEICUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEISET1 COMPANY This path is used for record uniqueness. AR550
CUSTOMER
|
