|
|
OECUST FILE
Customer Order Processing
The Customer Order Processing file contains customer order processing
information for use in the Lawson Order Entry system.
REFERENCED BY
AC551 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 AR08.1
AR210 AR219 AR48.1 AR48.3 BR10.1 BR11.1
BR120 BR121 BR122 BR123 BR15.1 BR151
BR152 BR155 BR156 BR16.1 BR16.2 BR210
BR211 BR215 BR220 BR251 BR252 BR253
BR420 BR450 BR51.1 BR51.2 BR52.1 BR52.2
BR521 BR53.1 BR55.2 BR91.1 BRIP.1 BRPI.1
CB06.2 IC02.1 IC28.1 IC531 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 PBIP.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 PR197 RQ10.1 RQ10.2 RQ10.3 RQIE.1
TX140 TX40.1 WH110 WH120 WH130 WH132
WH190 WH20.1 WH20.2 WH20.7 WH21.2 WH224
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 WO30.1
UPDATED BY
AR10.1 AR301 AR501 AR550
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OET-COMPANY Numeric 4 AR10.1 AR501
Element: Company Company number. AR550
OET-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Element: Customer NumbeCustomer number. AR550
OET-INCOMPLETE-FL Alpha 1 AR10.1 AR501
Element: Account Flag Incomplete indicator for customer AR550
addition control.
OET-FREIGHT-CODE Alpha 2 AR10.1 AR501
Element: Add On Cost CoThis field contains the freight code. AR550
This determines whether carrier and
charges are allowed for the shipment.
OET-PK-PRIORITY Numeric 2 AR10.1 AR501
Element: Picking PrioriPick priority assigned to this AR550
customer. Used by batch inventory
allocation to determine which customers
get first option on available inventory.
OET-CARRIER Alpha 9 (Right Justified) AR10.1 AR501
Element: Vendor ID Carrier Vendor Number. Must be a valid AR550
vendor number in the Lawson Accounts
Payable system.
OET-CIA-FL Alpha 1 AR10.1 AR501
Element: Cash In AdvancIndicates whether the customer must pay AR550
cash in advance. Valid values are:
N = No
Y = Yes
OET-CIA-PCT Percent 8.5 (Percent) AR10.1 AR501
Cash In Advance If cash in advance is required, this AR550
Percent field indicates the percentage of the
order amount required from the customer
before accepting an order.
OET-ORD-DISC-CODE Alpha 4 AR10.1 AR501
Accounts Receivable Order discount code used to assess AR550
Code discounts on customer orders. Must be a
valid order discount code in the Lawson
Order Entry system.
OET-TERRITORY Alpha 4 AR501
Element: Sales TerritorSales Territory.
OET-SALESMAN-2 Numeric 4 AR10.1 AR501
Element: SalesRep2 This field contains the code AR550
representing the second salesrep. This
defaults from the order header.
OET-COMM-SPLIT Percent 5.3 (Percent) AR10.1 AR501
Commission Split This field contains the commission AR550
Percentage split.
OET-PRICE-LST Alpha 14 AR10.1 AR501
Element: Price List Used to automatically price orders. AR550
Must be a valid price list in the Lawson
Order Entry system.
OET-ACKNOW-FL Alpha 1 AR10.1 AR501
Acknowledgement Indicates whether the customer requires AR550
Required Flag printed acknowledgments. Valid values
are:
N = No; acknowledgments not required
Y = Yes; acknowledgments required
OET-BACK-ORD-FL Alpha 1 AR10.1 AR501
Backorders Allowed Indicates whether the customer accepts AR550
Flag backorders. Valid values are:
N = No; backorders not accepted
Y = Yes; backorders accepted
OET-SHIP-COMP-FL Alpha 1 AR10.1 AR501
Element: Ship Complete Indicates whether orders must be AR550
complete for shipment. Valid values are:
N = No; partial shipments accepted
Y = Yes; shipments must be complete
OET-PO-REQ-FL Alpha 1 AR10.1 AR501
Element: PO Required Indicates whether the customer's AR550
purchase order number must be entered
before releasing an order.
N = No
Y = Yes
OET-DEF-SHIP-TO Numeric 4 AR10.1 AR501
Element: Ship-to Code Default ship-to location for the AR550
customer.
OET-DEF-LOCATION Alpha 5 AR10.1 AR501
Element: Location Code Default ship-from location or warehouse AR550
for customer.
OET-DEF-METHOD Alpha 10 AR10.1 AR501
Element: Opt Method Default shipping method for the AR550
customer.
OET-CUSTOMER-CODE Alpha 4 AR10.1 AR501
Element: Customer Code Customer code. This is a code used to AR550
classify customers for Sales Analysis.
OET-POD-REQ-FL Alpha 1 AR10.1 AR501
Element: POD Required POD required flag. Customer requires AR550
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.
N = No
Y = Yes
OET-GRACE-PER Numeric 3 AR10.1 AR501
Element: Grace Period The number of grace days added to the AR550
POD creation date before the customer
will be billed.
OET-SGL-ORD-LIM Signed 13.0 AR10.1 AR501
Element: Single Order LMaximum single order amount for the AR550
customer.
OET-SGL-HOLD-CODE Alpha 4 AR10.1 AR501
Single Order Hold Hold code to apply to a non-COD order AR550
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 is equal to zero and a single
order hold code is entered, then every
non-COD order will be on hold.
OET-COD-LIM Signed 13.0 AR10.1 AR501
Element: COD Limit Total value limit for COD orders. AR550
OET-COD-HOLD-CODE Alpha 4 AR10.1 AR501
Element: COD Hold Code This is the hold code applied to the AR550
order if it exceeds the COD order limit.
OET-ENT-CHECK-FL Alpha 1 AR10.1 AR501
Order Entry Credit Entry check flag indicates whether AR550
Check credit checking is performed when orders
are entered.
N = No
Y = Yes
OET-PRT-CHECK-FL Alpha 1 AR10.1 AR501
Print Picking Print check flag indicates whether AR550
Credit Check credit checking is performed prior to
printing picking lists.
N = No
Y = Yes
OET-AGE-CRED-PCT Percent 5.2 (Percent) Occurs 5 Times AR10.1 AR501
Element: Age Credit PerThe percentage of credit limit allowed AR550
for this period.
OET-AGE-HOLD-CD Alpha 4 Occurs 5 Times AR10.1 AR501
Element: Aging Hold CodThe hold code applied to an order if it AR550
is added when the customer fails the
credit check because of the aging period
limit.
OET-BRKN-CS-CHRG Alpha 1 AR10.1 AR501
Element: Broken Case ChThis flag determines if there is a AR550
charge if a broken case is required to
satisfy an order in Order Entry.
N = No
Y = Yes
OET-CR-LIMIT-HOLD Alpha 4 AR10.1 AR501
Credit Limit Hold Indicates whether a customer is on hold AR550
Code due to exceeding credit limit.
OET-OR-LIMIT-HOLD Alpha 4 AR10.1 AR501
Order Limit Hold Indicates whether a customer is on hold AR550
Code due to exceeding the order limit.
OET-AGING-1 Derived
Element: Aging 1 The first occurrence of the customer
static aging amount.
OET-AGING-2 Derived
Element: Aging 2 The second occurrence of the customer
static aging amount.
OET-AGING-3 Derived
Element: Aging 3 The third occurrence of the customer
static aging amount.
OET-AGING-4 Derived
Element: Aging 4 The fourth occurrence of the customer
static aging amount.
OET-AGING-5 Derived
Element: Aging 5 The fifth occurrence of the customer
static aging amount.
OET-AGE-PCT-1 Derived
Element: Aging Percent The first occurrence of the age credit
percentage.
OET-AGE-PCT-2 Derived
Element: Aging Percent The second occurrence of the age credit
percentage.
OET-AGE-PCT-3 Derived
Element: Aging Percent The third occurrence of the age credit
percentage.
OET-AGE-PCT-4 Derived
Element: Aging Percent The fourth occurrence of the age credit
percentage.
OET-AGE-PCT-5 Derived
Element: Aging Percent The fifth occurrence of the age credit
percentage.
OET-AGE-LIMIT-1 Derived
Element: Aging Limit 1 The first occurrence of the age credit
percentage multiplied by the first
occurrence of the static aging amount.
OET-AGE-LIMIT-2 Derived
Element: Aging Limit 2 The second occurrence of the age credit
percentage multiplied by the second
occurrence of the static aging amount.
OET-AGE-LIMIT-3 Derived
Element: Aging Limit 3 The third occurrence of the age credit
percentage multiplied by the third
occurrence of the static aging amount.
OET-AGE-LIMIT-4 Derived
Element: Aging Limit 4 The fourth occurrence of the age credit
percentage multiplied by the fourth
occurrence of the static aging amount.
OET-AGE-LIMIT-5 Derived
Element: Aging Limit 5 The fifth occurrence of the age credit
percentage multiplied by the fifth
occurrence of the static aging amount.
OET-LINE-ITEM-REQ Alpha 1 AR10.1 AR501
Element: Line Item RequIndicates if line items are to be AR550
interfaced into Accounts Receivable for
an invoice. Valid values are:
N = Line items are not interfaced
Y = Line items are interfaced
OET-VENDOR Alpha 9 (Right Justified) AR10.1
Element: Vendor ID The vendor's identification code.
OET-PURCH-FR-LOC Alpha 4 AR10.1
Purchase From The vendor's purchase from location.
Location Code
OET-FOB-CODE Alpha 3 AR10.1
Element: Shipping Term The user defined Free On Board Code.
OET-PORT-CD Alpha 5 AR10.1
Element: Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
OET-TAX-PRINT-CD Alpha 1 AR10.1 AR501
Element: Tax Print Cd D = Calc by line - print detail AR550
P = Price incl tax - print summary
S = Calc by line - print summary
T = Calc and print in summary
" " = Space
OECUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OETSET1 COMPANY This is the primary path used to access AC551 AP125
CUSTOMER records. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR08.1
AR10.1 AR10.5
AR210 AR219
AR301 AR48.1
AR48.3 AR501
AR550 BR10.1
BR11.1 BR120
...
OECUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OET-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
OET-COMPANY -> ACM-COMPANY
OET-CUSTOMER -> ACM-CUSTOMER
Cranalyst CRANALYST Not Required
OET-COMPANY -> CAN-COMPANY
ACM-CREDIT-ANLYST -> CAN-CREDIT-ANLYST
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
OET-CUSTOMER -> CUD-CUSTOMER
Holdcodes HOLDCODES Not Required
ACO-CUST-GROUP -> HDD-CUST-GROUP
ACM-HOLD-CODE -> HDD-HOLD-CODE
|
