ARIOECUST FILE
Customer Order Processing Conv
The Customer Order Processing Conversion file is used to convert customer
records from an external source. Records in this file have been converted from
an external source and will be loaded into the Accounts Receivable system via
AR501 (Customer Conversion).
Field data converted into this file may be accessed and maintained in AR98
(Conversion Customer Maintenance).
UPDATED BY
AR501 AR98.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOE-COMPANY Numeric 4 AR98.3
Company Required. The customer company number.
AOE-CUSTOMER Alpha 9 (Right Justified) AR98.3
Customer Required. Customer number.
AOE-FREIGHT-CODE Alpha 2 AR98.3
FreightCode This field contains the freight code.
This determines whether carrier and
charge are allowed for the shipment.
AOE-PK-PRIORITY Numeric 2 AR98.3
Picking Priority Used by batch inventory allocation to
determine which customers get option on
available inventory.
AOE-CARRIER Alpha 9 (Right Justified) AR98.3
Carrier Vendor Carrier vendor number.
Number
AOE-CIA-FL Alpha 1 AR98.3
Cash In Advance Indicates whether customers must pay
cash in advance. Valid values are:
N = Cash in advance not required
Y = Cash in advance required
AOE-CIA-PCT Percent 8.5 (Percent) AR98.3
Cash In Advance Percent of order amount required from
Percent the customer before order acceptance.
This must be entered if "Y" has been
entered in the Cash in Advance field.
AOE-ORD-DISC-CODE Alpha 4 AR98.3
Order Discount Code Order discount code.
AOE-COMM-SPLIT Percent 5.3 (Percent) AR98.3
Commission Split This field contains the commission
Percentage percent of the total order value to be
used as the basis for the second sales
representative's commission.
AOE-SALESMAN-2 Numeric 4 AR98.3
SalesRep 2 This field contains the code
representing the second salesrep.
AOE-PRICE-LST Alpha 14 AR98.3
Price List Price list used to automatically price
orders.
AOE-ACKNOW-FL Alpha 1 AR98.3
Acknowledgement Indicates whether the customer needs
Required printed acknowledgments. Valid values
are:
N = Acknowledgments not required
Y = Acknowledgments required
AOE-BACK-ORD-FL Alpha 1 AR98.3
Backorders Allowed Indicates whether the customer accepts
backorders. Valid values are:
N = Backorders not accepted
Y = Backorders accepted
AOE-SHIP-COMP-FL Alpha 1 AR98.3
Ship Complete Indicates whether orders must be
complete prior to shipment. Valid values
are:
N = Customer accepts partial order
shipments
Y = Customer does not accept partial
order shipments
AOE-PO-REQ-FL Alpha 1 AR98.3
PO Required Indicates 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
AOE-DEF-SHIP-TO Numeric 4 AR98.3
Default Ship-to for Default ship-to location.
Location
AOE-DEF-LOCATION Alpha 5 AR98.3
Default Ship-from Default ship-from location.
Location
AOE-DEF-METHOD Alpha 10 AR98.3
Default Shipment Default shipment method.
Method
AOE-CUSTOMER-CODE Alpha 4 AR98.3
Customer Code Customer code. This is a code used to
classify customers for Sales Analysis.
AOE-POD-REQ-FL Alpha 1 AR98.3
POD Required POD 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.
AOE-GRACE-PER Numeric 3 AR98.3
Grace Period Grace 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.
AOE-SGL-HOLD-CODE Alpha 4 AR98.3
Single Order Hold Hold code to apply to a non-COD order
Code 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.
AOE-SGL-ORD-LIM Signed 13.0 AR98.3
Single Order Limit Maximum single order amount for the
customer. If blank, the single order
limit defined for the customer default
code will default.
AOE-COD-LIM Signed 13.0 AR98.3
COD Limit Maximum amount to limit COD orders for
this customer. If left blank, the COD
order limit defined in the customer
default code defaults.
AOE-COD-HOLD-CODE Alpha 4 AR98.3
COD Hold Code If 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.
AOE-ENT-CHECK-FL Alpha 1 AR98.3
Order Credit Check Indicates 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
AOE-PRT-CHECK-FL Alpha 1 AR98.3
Picking List Credit Indicates whether to perform a credit
Check 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
AOE-AGE-CRED-PCT Percent 5.2 (Percent) Occurs 5 Times AR98.3
Age Credit If" Y" is selected for the credit check
Percentages 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.
AOE-AGE-HOLD-CD Alpha 4 Occurs 5 Times AR98.3
Aging Hold Code If 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.
AOE-CR-HOLD-CODE Alpha 4
Credit Hold Code This 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 Alpha 1 AR98.3
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
AOE-CR-LIMIT-HOLD Alpha 4 AR98.3
Credit Limit Hold Indicates if a customer is on hold for
Code exceeding the credit limit.
AOE-OR-LIMIT-HOLD Alpha 4 AR98.3
Order Limit Hold Indicated if a customer is on hold for
Code exceeding the order limit.
AOE-CUSRET-INV-MET Alpha 1
Return Invoicing Determines the invoicing method for
Method 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 Alpha 1 AR98.3
Line Items Required Indicated if line items are produced
for an invoice. Valid values are:
N = Line items are not produced.
Y = Line items are produced.
ARIOECUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOESET1 COMPANY The path is used to keep the records AR501 AR98.3
CUSTOMER unique.
|
