Customer Order Processing
The Customer Order Processing file contains customer order processing information for use in the Lawson Order Entry system.
REFERENCED BY
| AR09.1 | AR10.1 | AR301 | AR501 | AR550 | TX140 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
|---|---|---|---|---|---|---|---|---|
| OET-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
||||||
| OET-CUSTOMER Element: Customer | Alpha 9 (Right Justified) Customer number. |
|
||||||
| OET-INCOMPLETE-FL Element: Incomplete Fl | Alpha 1 Incomplete indicator for customer addition control. |
|
||||||
| OET-FREIGHT-CODE Element: Freight Code | Alpha 2 This field contains the freight code. This determines whether carrier and charges are allowed for the shipment. |
|
||||||
| OET-PK-PRIORITY Element: Pk Priority | Numeric 2 Pick priority assigned to this customer. Used by batch inventory allocation to determine which customers get first option on available inventory. |
|
||||||
| OET-CARRIER Element: Vendor | Alpha 9 (Right Justified) Carrier Vendor Number. Must be a valid vendor number in the Lawson Accounts Payable system. |
|
||||||
| OET-CIA-FL Element: Cia Fl | Alpha 1 Indicates whether the customer must pay cash in advance. Valid values are: N = No Y = Yes |
|
||||||
| OET-CIA-PCT Element: Cia Pct | 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 an order. |
|
||||||
| OET-ORD-DISC-CODE Element: Ord Disc 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. |
|
||||||
| OET-TERRITORY Element: Territory | Alpha 4 Sales Territory. |
|
||||||
| OET-SALESMAN-2 Element: SalesRep2 | Numeric 4 This field contains the code representing the second salesrep. This defaults from the order header. |
|
||||||
| OET-COMM-SPLIT Element: Comm Split | Percent 5.3 (Percent) This field contains the commission split. |
|
||||||
| OET-PRICE-LST Element: Price List | Alpha 14 Used to automatically price orders. Must be a valid price list in the Lawson Order Entry system. |
|
||||||
| OET-ACKNOW-FL Element: Acknow Fl | Alpha 1 Indicates whether the customer requires printed acknowledgments. Valid values are: N = No; acknowledgments not required Y = Yes; acknowledgments required |
|
||||||
| OET-BACK-ORD-FL Element: Back Ord Fl | Alpha 1 Indicates whether the customer accepts backorders. Valid values are: N = No; backorders not accepted Y = Yes; backorders accepted |
|
||||||
| OET-SHIP-COMP-FL Element: Ship Complete | Alpha 1 Indicates whether orders must be complete for shipment. Valid values are: N = No; partial shipments accepted Y = Yes; shipments must be complete |
|
||||||
| OET-PO-REQ-FL Element: PO Required | Alpha 1 Indicates whether the customer's purchase order number must be entered before releasing an order. N = No Y = Yes |
|
||||||
| OET-SUBSTITUTES-FL Element: All Flag | Alpha 1 |
|
||||||
| OET-DEF-SHIP-TO Element: Ship To | Numeric 4 Default ship-to location for the customer. |
|
||||||
| OET-DEF-LOCATION Element: Location | Alpha 5 Default ship-from location or warehouse for customer. |
|
||||||
| OET-DEF-METHOD Element: Def Method | Alpha 10 Default shipping method for the customer. |
|
||||||
| OET-CUSTOMER-CODE Element: Customer Code | Alpha 4 Customer code. This is a code used to classify customers for Sales Analysis. |
|
||||||
| OET-POD-REQ-FL Element: POD Required | Alpha 1 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. N = No Y = Yes |
|
||||||
| OET-GRACE-PER Element: Grace Period | Numeric 3 The number of grace days added to the POD creation date before the customer will be billed. |
|
||||||
| OET-SGL-ORD-LIM Element: Single Order Limit | Signed 13.0 Maximum single order amount for the customer. |
|
||||||
| OET-SGL-HOLD-CODE Single Order Hold Code | Alpha 4 Hold code to apply to a non-COD order 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 Element: COD Limit | Signed 13.0 Total value limit for COD orders. |
|
||||||
| OET-COD-HOLD-CODE Element: COD Hold Code | Alpha 4 This is the hold code applied to the order if it exceeds the COD order limit. |
|
||||||
| OET-ENT-CHECK-FL Order Entry Credit Check | Alpha 1 Entry check flag indicates whether credit checking is performed when orders are entered. N = No Y = Yes |
|
||||||
| OET-PRT-CHECK-FL Print Picking Credit Check | Alpha 1 Print check flag indicates whether credit checking is performed prior to printing picking lists. N = No Y = Yes |
|
||||||
| OET-AGE-CRED-PCT Element: Age Credit Percent | Percent 5.2 (Percent) Occurs 5 Times The percentage of credit limit allowed for this period. |
|
||||||
| OET-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. |
|
||||||
| OET-BRKN-CS-CHRG Element: Brkn Cs Chrg | Alpha 1 This flag determines if there is a charge if a broken case is required to satisfy an order in Order Entry. N = No Y = Yes |
|
||||||
| OET-CR-LIMIT-HOLD Credit Limit Hold Code | Alpha 4 Indicates whether a customer is on hold due to exceeding credit limit. |
|
||||||
| OET-OR-LIMIT-HOLD Order Limit Hold Code | Alpha 4 Indicates whether a customer is on hold due to exceeding the order limit. |
|
||||||
| OET-AGING-1 Element: Aging 1 | Derived The first occurrence of the customer static aging amount. |
|
||||||
| OET-AGING-2 Element: Aging 2 | Derived The second occurrence of the customer static aging amount. |
|
||||||
| OET-AGING-3 Element: Aging 3 | Derived The third occurrence of the customer static aging amount. |
|
||||||
| OET-AGING-4 Element: Aging 4 | Derived The fourth occurrence of the customer static aging amount. |
|
||||||
| OET-AGING-5 Element: Aging 5 | Derived The fifth occurrence of the customer static aging amount. |
|
||||||
| OET-AGE-PCT-1 Element: Aging Percent 1 | Derived The first occurrence of the age credit percentage. |
|
||||||
| OET-AGE-PCT-2 Element: Aging Percent 2 | Derived The second occurrence of the age credit percentage. |
|
||||||
| OET-AGE-PCT-3 Element: Aging Percent 3 | Derived The third occurrence of the age credit percentage. |
|
||||||
| OET-AGE-PCT-4 Element: Aging Percent 4 | Derived The fourth occurrence of the age credit percentage. |
|
||||||
| OET-AGE-PCT-5 Element: Aging Percent 5 | Derived The fifth occurrence of the age credit percentage. |
|
||||||
| OET-AGE-LIMIT-1 Element: Aging Limit 1 | Derived The first occurrence of the age credit percentage multiplied by the first occurrence of the static aging amount. |
|
||||||
| OET-AGE-LIMIT-2 Element: Aging Limit 2 | Derived The second occurrence of the age credit percentage multiplied by the second occurrence of the static aging amount. |
|
||||||
| OET-AGE-LIMIT-3 Element: Aging Limit 3 | Derived The third occurrence of the age credit percentage multiplied by the third occurrence of the static aging amount. |
|
||||||
| OET-AGE-LIMIT-4 Element: Aging Limit 4 | Derived The fourth occurrence of the age credit percentage multiplied by the fourth occurrence of the static aging amount. |
|
||||||
| OET-AGE-LIMIT-5 Element: Aging Limit 5 | Derived The fifth occurrence of the age credit percentage multiplied by the fifth occurrence of the static aging amount. |
|
||||||
| OET-LINE-ITEM-REQ Element: Line Item Required | Alpha 1 Indicates if line items are to be interfaced into Accounts Receivable for an invoice. Valid values are: N = Line items are not interfaced Y = Line items are interfaced |
|
||||||
| OET-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||
| OET-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||
| OET-FOB-CODE Element: Fob Code | Alpha 3 The user defined Free On Board Code. |
|
||||||
| OET-PORT-CD Element: Port Cd | Alpha 5 The Intrastat port code. Must be define in IN04.1 (Port Maintenance) |
|
||||||
| OET-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 |
|
||||||
| OET-ALLOW-RETURNS Element: All Flag | Alpha 1 " " Y = Yes N = No L = Limit |
|
||||||
| OET-ALLOW-RTN-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||
| OET-CARRIER-FLAG Element: All Flag | Alpha 1 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| OETSET1 |
COMPANY CUSTOMER |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP |
Required
| ||||||
| Arcustomer | ARCUSTOMER |
Required
| ||||||
| Cranalyst | CRANALYST |
Not Required
| ||||||
| Custdesc | CUSTDESC |
Required
| ||||||
| Holdcodes | HOLDCODES |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.