OEICUST

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), and can be maintained in AR96 Interface Customer.
UPDATED BY
AR550

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEI-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AEI-CUSTOMER
Element: Customer Number
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AEI-FREIGHT-CODE
Element: Freight Code
Alpha 2
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
Element: Freight Code Change
Numeric 1
Freight code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-PK-PRIORITY
Element: Picking Priority
Numeric 2
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
Picking Priority
Change
Numeric 1
Picking priority change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CARRIER
Carrier Vendor
Number
Alpha 9 (Right Justified)
Carrier Vendor Number. Must be a valid vendor number in the Lawson Accounts Payable system.
AEI-CARRIER-CHG
Carrier Vendor
Number Change
Numeric 1
Carrier vendor number change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CIA-FL
Element: Cash In Advance Flag
Alpha 1
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
Cash In Advance
Percent
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
Cash In Advance
Percent Change
Numeric 1
Cash in advance percentage change indicator. Valid values are 0 = No change 1 = Change this field
AEI-ORD-DISC-CODE
Element: Order Discount Code
Alpha 4
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
Order Discount Code
Change
Numeric 1
Order discount code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COMM-SPLIT
Commission Split
Percentage
Percent 5.3 (Percent)
This field contains the commission split. This defaults from the Customer Order Processing file.
AEI-COMM-SPLIT-CHG
Commission Split
Pct Change
Numeric 1
Commission split percentage change indicator. Valid values are 0 = No change 1 = Change this field
AEI-SALESMAN-2
Element: Sales Rep Number 2
Numeric 4
This field contains the code representing the second salesrep. This defaults from the order header.
AEI-SALESMAN-2-CHG
Sales Rep Number 2
Change
Numeric 1
Sales rep 2 change indicator. Valid values are 0 = No change 1 = Change this field
AEI-PRICE-LST
Element: Price List
Alpha 14
Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system.
AEI-ACKNOW-FL
Acknowledgment
Required Flag
Alpha 1
Indicates whether the customer requires printed acknowledgments. Valid values are N = Acknowledgments not required Y = Acknowledgments required
AEI-BACK-ORD-FL
Backorders Allowed
Flag
Alpha 1
Indicates whether the customer accepts backorders. Valid values are N = Backorders not accepted Y = Backorders accepted
AEI-SHIP-COMP-FL
Element: Ship Complete Flag
Alpha 1
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
Purchase Order
Required Flag
Alpha 1
Indicates 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
Element: All Flag
Alpha 1
AEI-DEF-SHIP-TO
Default Ship-to For
Customer
Numeric 4
Default ship-to location for the customer.
AEI-DEF-SHP-TO-CHG
Default Ship-to
Change
Numeric 1
Default ship-to change indicator. Valid values are 0 = No change 1 = Change this field
AEI-DEF-LOCATION
Default Location
For Operator
Alpha 5
Default ship-from or warehouse for the customer.
AEI-DEF-LOCTIN-CHG
Default Location
Change
Numeric 1
Default location change indicator. Valid values are 0 = No change 1 = Change this field
AEI-DEF-METHOD
Default Ship-to
Method
Alpha 10
Default shipping method for the customer.
AEI-DEF-METHOD-CHG
Default Ship-to
Method Change
Numeric 1
Default shipping method change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CUSTOMER-CODE
Element: Customer Code
Alpha 4
Customer code. This is a code used to classify customers for Sales Analysis.
AEI-POD-REQ-FL
Element: POD Required Flag
Alpha 1
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
Element: Grace Period
Numeric 3
The number of grace days added to the POD creation date before the customer will be billed.
AEI-GRACE-PER-CHG
Element: Grace Period Change
Numeric 1
Grace period change indicator. Valid values are: 0 = No change 1 = Change this field
AEI-SGL-HOLD-CODE
Single Order Hold
Code
Alpha 4
Hold 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
Single Order Hold
Code Change
Numeric 1
Single order hold code change indicator. Valid values are: 0 = No change 1 = Change this field
AEI-SGL-ORD-LIM
Element: Single Order Limit
Signed 13.0
AEI-SGL-ORD-LM-CHG
Single Order Limit
Change
Numeric 1
Single order limit change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COD-LIM
Element: COD Limit
Signed 13.0
Total value limit for COD orders.
AEI-COM-LIM-CHG
Element: COD Limit Change
Numeric 1
COD limit change indicator. Valid values are 0 = No change 1 = Change this field
AEI-COD-HOLD-CODE
Element: COD Hold Code
Alpha 4
Hold code applied to an order if it exceeds the COD order limit.
AEI-COD-HOLD-CHG
Element: COD Hold Code Change
Numeric 1
COD hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-ENT-CHECK-FL
Element: Order Credit Check
Alpha 1
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
Picking List Credit
Check
Alpha 1
Indicates 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 Credit
Percentages
Percent 5.2 (Percent) Occurs 5 Times
The percentage of the credit limit allowed for this period.
AEI-AGE-CRED-CHG
Age Credit
Percentages Change
Numeric 1
Aging credit percent change indicator. Valid values are 0 = No change 1 = Change this field
AEI-AGE-HOLD-CD
Element: Aging Hold Code
Alpha 4 Occurs 5 Times
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
Aging Hold Code
Change
Numeric 1
Aging hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-CR-HOLD-CODE
Element: Credit Hold Code
Alpha 4
Indicates whether the customer was put on credit hold. Valid values are:
AEI-CR-HOLD-CHG
Credit Hold Code
Change
Numeric 1
Credit hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-BRKN-CS-CHRG
Element: Broken Case Charge
Alpha 1
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
Credit Limit Hold
Code
Alpha 4
Indicates if a customer is on hold for exceeding the credit limit.
AEI-CR-LIM-HLD-CHG
Credit Limit Hold
Code Change
Numeric 1
Credit limit hold code change indicator. Valid values are 0 = No change 1 = Change this field
AEI-OR-LIMIT-HOLD
Order Limit Hold
Code
Alpha 4
Indicates if a customer is on hold for exceeding the order limit.
AEI-OR-LIM-HLD-CHG
Order Limit Hold
Code Change
Numeric 1
Order limit hold code. Valid values are 0 = No change 1 = Change this field
AEI-LINE-ITEM-REQ
Element: Line Items Required
Alpha 1
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.
AEI-TAX-PRINT-CD
Element: Tax Print Cd
Alpha 1

D = Calc by line - print detail
P = Price incl tax - print summary
S = Calc by line - print summary
T = Calc and print in summary
" " = Space
AEI-ALLOW-RETURNS
Element: All Flag
Alpha 1
AEI-ALLOW-RTN-DATE
Element: Date
Numeric 8 (yyyymmdd)
AEI-CARRIER-FLAG
Element: All Flag
Alpha 1


OEICUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEISET1 COMPANY
CUSTOMER
AR550


File created: Thu Jun 09 02:09:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.