Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECUST


                              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