|
|
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
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 AR08.1 AR210 AR219 AR48.1 AR48.3
BL04.1 BL10.1 BL120 BL121 BL122 BL123
BL125 BL130 BL20.1 BL20.3 BL20.6 BL202
BL204 BL21.2 BL21.5 BL217 BL219 BL220
BL231 BL246 BL29.1 BL29.2 BL290 BL291
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL33.1 BL331 BL34.1 BL46.1 BL46.2
BL520 BL530 BL546 BL80.1 BL80.3 BL81.1
BL82.1 BL820 BL85.1 BL85.2 BL90.1 BL92.1
BR00.1 BR00.2 BR02.3 BR10.1 BR10.9 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR155 BR156 BR16.1 BR16.2 BR17.1
BR180 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.2 BR210 BR211 BR216
BR217 BR220 BR251 BR252 BR253 BR400
BR420 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR51.1 BR51.2 BR52.1 BR52.2 BR521 BR53.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 CB06.2
IC02.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 PO32.4
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 POID.1 POII.1 POIJ.1 PW110
RQ10.1 RQ10.2 TX40.1 WH110 WH120 WH130
WH132 WH190 WH20.1 WH20.2 WH20.7 WH21.2
WH224 WH226 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
UPDATED BY
AR09.1 AR10.1 AR120 AR301 AR501 AR550
BL02.1 BL802 PW550 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OET-COMPANY Numeric 4 AR09.1 AR10.1
Element: Company The number representing an AR company. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
OET-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer Customer number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
OET-INCOMPLETE-FL Alpha 1 AR09.1 AR10.1
Element: Incomplete Fl Incomplete indicator for customer AR301 AR501
addition control. AR550 BL02.1
BL802 PW550
TX140
OET-FREIGHT-CODE Alpha 2 AR09.1 AR10.1
Element: Freight Code This field contains the freight code. AR301 AR501
This determines whether carrier and AR550 BL02.1
charges are allowed for the shipment. BL802 PW550
TX140
OET-PK-PRIORITY Numeric 2 AR09.1 AR10.1
Element: Pk Priority Pick priority assigned to this AR301 AR501
customer. Used by batch inventory AR550 BL02.1
allocation to determine which customers BL802 PW550
get first option on available inventory. TX140
OET-CARRIER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Vendor Carrier Vendor Number. Must be a valid AR301 AR501
vendor number in the Lawson Accounts AR550 BL02.1
Payable system. BL802 PW550
TX140
OET-CIA-FL Alpha 1 AR09.1 AR10.1
Element: Cia Fl Indicates whether the customer must pay AR301 AR501
cash in advance. Valid values are: AR550 BL02.1
BL802 PW550
N = No TX140
Y = Yes
OET-CIA-PCT Percent 8.5 (Percent) AR09.1 AR10.1
Element: Cia Pct If cash in advance is required, this AR301 AR501
field indicates the percentage of the AR550 BL02.1
order amount required from the customer BL802 PW550
before accepting an order. TX140
OET-ORD-DISC-CODE Alpha 4 AR09.1 AR10.1
Element: Ord Disc Code Order discount code used to assess AR301 AR501
discounts on customer orders. Must be a AR550 BL02.1
valid order discount code in the Lawson BL802 PW550
Order Entry system. TX140
OET-TERRITORY Alpha 4 AR501
Element: Territory Sales 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) AR09.1 AR10.1
Element: Comm Split This field contains the commission AR301 AR501
split. AR550 BL02.1
BL802 PW550
TX140
OET-PRICE-LST Alpha 14 AR09.1 AR10.1
Element: Price List Used to automatically price orders. AR120 AR301
Must be a valid price list in the Lawson AR501 AR550
Order Entry system. BL02.1 BL802
PW550 TX140
OET-ACKNOW-FL Alpha 1 AR09.1 AR10.1
Element: Acknow Fl Indicates whether the customer requires AR301 AR501
printed acknowledgments. Valid values AR550 BL02.1
are: BL802 PW550
TX140
N = No; acknowledgments not required
Y = Yes; acknowledgments required
OET-BACK-ORD-FL Alpha 1 AR09.1 AR10.1
Element: Back Ord Fl Indicates whether the customer accepts AR301 AR501
backorders. Valid values are: AR550 BL02.1
BL802 PW550
N = No; backorders not accepted TX140
Y = Yes; backorders accepted
OET-SHIP-COMP-FL Alpha 1 AR09.1 AR10.1
Element: Ship Complete Indicates whether orders must be AR301 AR501
complete for shipment. Valid values are: AR550 BL02.1
BL802 PW550
TX140
N = No; partial shipments accepted
Y = Yes; shipments must be complete
OET-PO-REQ-FL Alpha 1 AR09.1 AR10.1
Element: PO Required Indicates whether the customer's AR301 AR501
purchase order number must be entered AR550 BL02.1
before releasing an order. BL802 PW550
N = No TX140
Y = Yes
OET-SUBSTITUTES-FL Alpha 1
Element: All Flag
OET-DEF-SHIP-TO Numeric 4 AR09.1 AR10.1
Element: Ship To Default ship-to location for the AR301 AR501
customer. AR550 BL02.1
BL802 PW550
TX140
OET-DEF-LOCATION Alpha 5 AR09.1 AR10.1
Element: Location Default ship-from location or warehouse AR301 AR501
for customer. AR550 BL02.1
BL802 PW550
TX140
OET-DEF-METHOD Alpha 10 AR09.1 AR10.1
Element: Def Method Default shipping method for the AR301 AR501
customer. AR550 BL02.1
BL802 PW550
TX140
OET-CUSTOMER-CODE Alpha 4 AR09.1 AR10.1
Element: Customer Code Customer code. This is a code used to AR120 AR301
classify customers for Sales Analysis. AR501 AR550
BL02.1 BL802
PW550 TX140
OET-POD-REQ-FL Alpha 1 AR09.1 AR10.1
Element: POD Required POD required flag. Customer requires AR301 AR501
that a Proof of Delivery form to AR550 BL02.1
accompany the shipment. The shipment BL802 PW550
will not be billed until POD is returned TX140
or the POD grace period expires.
N = No
Y = Yes
OET-GRACE-PER Numeric 3 AR09.1 AR10.1
Element: Grace Period The number of grace days added to the AR301 AR501
POD creation date before the customer AR550 BL02.1
will be billed. BL802 PW550
TX140
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: Brkn Cs Chrg This 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 AR120
Element: Line Item RequIndicates if line items are to be AR501 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 The vendor's identification code.
OET-PURCH-FR-LOC Alpha 4 AR10.1
Element: Purch Fr Loc The vendor's purchase from location.
OET-FOB-CODE Alpha 3 AR10.1
Element: Fob Code 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 AR09.1 AR10.1
Element: Tax Print Cd D = Calc by line - print detail AR301 AR501
P = Price incl tax - print summary AR550 BL02.1
S = Calc by line - print summary BL802 PW550
T = Calc and print in summary TX140
" " = Space
OECUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OETSET1 COMPANY AC56.1 AC560
CUSTOMER AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR08.1
AR09.1 AR10.1
AR10.5 AR120
AR210 AR219
AR301 AR48.1
AR48.3 AR501
...
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
|
