|
|
OECUST FILE
Customer Order Processing
Customer Order Processing
REFERENCED BY
AC115 AC15.2 AC450 AR210 BL04.1 BL120
BL121 BL122 BL123 BL130 BL20.1 BL20.3
BL202 BL204 BL21.2 BL21.5 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
BL80.1 BL80.3 BL802 BL81.1 BL820 BL85.1
BL85.2 BL90.1 BL902 BL92.1 BL940 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE112 OE113 OE114 OE129 OE130 OE14.3
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE230 OE254 OE260 OE270 OE271
OE272 OE284 OE285 OE286 OE290 OE291
OE292 OE293 OE294 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE330
OE510 OE53.1 OE54.1 OE60.1 OE80.1 OE80.2
OE81.1 OE81.2 OE810 OE830 OE85.1 OE90.1
OE90.2 OE920 OE950 PBIP.1 SA03.1 SA100
SA252 SA254 SA256 SA261 SA271 SA281
SA291 SA300 SA80.2 SA90.2 SAA2.1 TX140
TX40.1 WH110 WH120 WH130 WH132 WH190
WH20.2 WH20.7 WH21.2 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
UPDATED BY
AR10.1 AR301 AR501 AR550 AR973 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OET-COMPANY Numeric 4 AR10.1 AR501
Company Company number. AR550 AR973
BL02.1
OET-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Customer Number Customer number. AR550 AR973
BL02.1
OET-CC-TYPE Alpha 2 AR10.1 AR501
Credit Card Type Credit card type for this customer. AR550 AR973
BL02.1
OET-CC-NUMBER Alpha 17 AR10.1 AR501
Credit Card Number Credit card number. AR550 AR973
BL02.1
OET-CC-EXP-DATE Numeric 6 AR10.1 AR501
Credit Card Credit card expiration date. AR550 AR973
Expiration Date BL02.1
OET-INCOMPLETE-FL Alpha 1 AR10.1 AR501
Incomplete Flag Incomplete indicator for customer AR550 AR973
addition control. BL02.1
OET-FREIGHT-CODE Alpha 2 AR10.1 AR501
Freight Code This field contains the freight code. AR550 AR973
This determines whether carrier and BL02.1
charges are allowed for the shipment.
OET-PK-PRIORITY Numeric 2 AR10.1 AR501
Picking Priority Pick priority assigned to this AR550 AR973
customer. Used by batch inventory BL02.1
allocation to determine which customers
get first option on available inventory.
OET-CARRIER Alpha 9 AR10.1 AR501
Carrier Vendor Carrier Vendor Number. Must be a valid AR550 AR973
Number vendor number in the Lawson Accounts BL02.1
Payable system.
OET-CIA-FL Alpha 1 AR10.1 AR501
Cash In Advance Flag Indicates whether the customer must pay AR550 AR973
cash in advance. Valid values are: BL02.1
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 AR973
Percent field indicates the percentage of the BL02.1
order amount required from the customer
before accepting an order.
OET-ORD-DISC-CODE Alpha 4 AR10.1 AR501
Order Discount Code Order discount code used to assess AR550 AR973
discounts on customer orders. Must be a BL02.1
valid order discount code in the Lawson
Order Entry system.
OET-TERRITORY Alpha 4 AR501
Sales Territory Sales Territory.
OET-SALESMAN-2 Numeric 4 AR10.1 AR501
SalesRep2 This field contains the code AR550 AR973
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 AR973
Percentage split. BL02.1
OET-PRICE-LST Alpha 14 AR10.1 AR501
Price List Used to automatically price orders. AR550 AR973
Must be a valid price list in the Lawson BL02.1
Order Entry system.
OET-ACKNOW-FL Alpha 1 AR10.1 AR501
Acknowledgment Indicates whether the customer requires AR550 AR973
Required Flag printed acknowledgments. Valid values BL02.1
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 AR973
Flag backorders. Valid values are: BL02.1
N = No; backorders not accepted
Y = Yes; backorders accepted
OET-SHIP-COMP-FL Alpha 1 AR10.1 AR501
Ship Complete Indicates whether orders must be AR550 AR973
complete for shipment. Valid values are: BL02.1
N = No; partial shipments accepted
Y = Yes; shipments must be complete
OET-PO-REQ-FL Alpha 1 AR10.1 AR501
PO Required Indicates whether the customer's AR550 AR973
purchase order number must be entered BL02.1
before releasing an order.
OET-DEF-SHIP-TO Numeric 4 AR10.1 AR501
Default Ship-to for Default ship-to location for the AR550 AR973
Customer customer. BL02.1
OET-DEF-LOCATION Alpha 5 AR10.1 AR501
Default Location Default ship-from location or warehouse AR550 AR973
for Operator for customer. BL02.1
OET-DEF-METHOD Alpha 10 AR10.1 AR501
Default Method for Default shipping method for the AR550 AR973
Ship-to customer. BL02.1
OET-CUSTOMER-CODE Alpha 4 AR10.1 AR501
Customer Code Customer code. This is a code used to AR550 AR973
classify customers for Sales Analysis. BL02.1
OET-POD-REQ-FL Alpha 1 AR10.1 AR501
POD Required POD required flag. Customer requires AR550 AR973
that a Proof of Delivery form to BL02.1
accompany the shipment. The shipment
will not be billed until POD is returned
or the POD grace period expires.
OET-GRACE-PER Numeric 3 AR10.1 AR501
Grace Period The number of grace days added to the AR550 AR973
POD creation date before the customer BL02.1
will be billed.
OET-SGL-ORD-LIM Signed 13.0 AR10.1 AR501
Single Order Limit Maximum single order amount for the AR550 AR973
customer.
OET-SGL-HOLD-CODE Alpha 4 AR10.1 AR501
Single Order Hold Hold code to apply to a non-COD order AR550 AR973
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
COD Limit Total value limit for COD orders. AR550 AR973
OET-COD-HOLD-CODE Alpha 4 AR10.1 AR501
COD Hold Code This is the hold code applied to the AR550 AR973
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 AR973
Check credit checking is performed when orders
are entered.
OET-PRT-CHECK-FL Alpha 1 AR10.1 AR501
Print Picking Print check flag indicates whether AR550 AR973
Credit Check credit checking is performed prior to
printing picking lists.
OET-AGE-CRED-PCT Percent 5.2 (Percent) Occurs 5 Times AR10.1 AR501
Age Credit Percent The percentage of credit limit allowed AR550 AR973
for this period.
OET-AGE-HOLD-CD Alpha 4 Occurs 5 Times AR10.1 AR501
Aging Hold Code The hold code applied to an order if it AR550 AR973
is added when the customer fails the
credit check because of the aging period
limit.
OET-BRKN-CS-CHRG Alpha 1 AR10.1 AR501
Broken Case Charge This flag determines if there is a AR550 AR973
charge if a broken case is required to
satisfy an order in Order Entry.
OET-CR-LIMIT-HOLD Alpha 4 AR10.1 AR501
Credit Limit Hold Indicates whether a customer is on hold AR550 AR973
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
Aging 1 The first occurrence of the customer
static aging amount.
OET-AGING-2 Derived
Aging 2 The second occurrence of the customer
static aging amount.
OET-AGING-3 Derived
Aging 3 The third occurrence of the customer
static aging amount.
OET-AGING-4 Derived
Aging 4 The fourth occurrence of the customer
static aging amount.
OET-AGING-5 Derived
Aging 5 The fifth occurrence of the customer
static aging amount.
OET-AGE-PCT-1 Derived
Aging Percent 1 The first occurrence of the age credit
percentage.
OET-AGE-PCT-2 Derived
Aging Percent 2 The second occurrence of the age credit
percentage.
OET-AGE-PCT-3 Derived
Aging Percent 3 The third occurrence of the age credit
percentage.
OET-AGE-PCT-4 Derived
Aging Percent 4 The fourth occurrence of the age credit
percentage.
OET-AGE-PCT-5 Derived
Aging Percent 5 The fifth occurrence of the age credit
percentage.
OET-AGE-LIMIT-1 Derived
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
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
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
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
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 AR501 AR550
Line Item 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
OECUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OETSET1 COMPANY This is the primary path used to access AC115 AC15.2
CUSTOMER records. AC450 AR10.1
AR210 AR301
AR501 AR550
BL02.1 BL02.2
BL04.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL202 BL204
BL21.2 BL21.5
BL220 BL231
BL246 BL29.1
BL29.2 BL290
BL291 BL31.1
...
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
|