Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ORDERTYPE


                             ORDERTYPE FILE

                               Order Type

The Order Type file stores order type parameters.  The process type assigned
to an order type determines which shipment processing steps an order having
this order type must go through before invoicing.  An order type can also be
ship immediate, meaning that after being released, the order's inventory is
removed and an invoice is created immediately.

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL01.1    BL201     CXCP.1    IC28.1
IC83.1    MA180     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    OE116     OE251
OE53.1    OE80.1    OE81.1    OE90.1    OE90.2    PO100
PO101     PO122     PO131     PO20.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     POI3.1    POIE.1
POII.1    POIJ.1    RQ10.1    RQ10.2    RQ12.1    RQ13.1
RQ13.2    RQ35.1    RQ500     RQIF.1    WH110     WH120
WH130     WH132     WH190     WH21.1    WH21.2    WH21.3
WH21.4    WH210     WH22.1    WH222     WH25.1    WH25.2
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.1    WH33.2    WH33.3    WH33.4    WH33.5    WH33.6
WH33.8    WH33.9    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830     WO120     WO131
WO132     WO133     WO140     WO20.1    WO30.1    WO32.1
WO32.2    WO32.3    WO32.4    WO32.5    WO40.1    WO40.2
WO40.3    WO40.4    WO40.5    WO41.1    WO41.2    WO41.3
WO41.4    WO42.1    WO42.2    WO42.3    WO42.4    WO42.5
WO45.1    WOEX.1    WOSP.1

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
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     OE111     OE113     OE114     OE129     OE13.2
OE13.3    OE13.5    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE51.1
OE510     OE530     OE810     OE830     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OTP-COMPANY            Numeric 4                                 OE51.1
Element: Company       This field contains the company number.

OTP-ORDER-TYPE         Alpha 2                                   OE51.1
Element: Order Type CodThis field contains the order type,
                       which determines how the order is
                       processed.  Order types are established
                       in OE51.1 (Order Type).

OTP-DESCRIPTION        Alpha 30  (Lower Case)                    OE51.1  OE53.1
Element: Description   This field contains the description of
                       the order type.

OTP-CREATE-PO          Alpha 1                                   OE51.1
Element: All Flag      This field indicates whether or not the
                       order type can create a purchase order.
                       Y = Yes
                       N = No

OTP-DROPSHIP-FL        Alpha 1                                   OE51.1
Element: Dropship Flag This field indicates whether an order
                       placed using this order type is
                       dropshipped, or sent directly from the
                       vendor to the customer.  Only nonstock
                       and special items can be dropshipped.

                       A purchase order can be created
                       automatically using PO100 (PO
                       Interface).  After the purchase order is
                       processed and invoiced (no receivings
                       necessary), the order is available for
                       invoicing.  When OE129 (Daily Shipment
                       Journal) is run, the order's invoice is
                       created and can be sent to the customer.
                       N = No
                       Y = Yes

OTP-PICK-FL            Alpha 1
Element: Picking OptionThis field indicates if the order type
                       requires picking feedback.  If this
                       field is set to Yes, you can perform
                       feedback online or perform batch
                       feedback in the Lawson Warehouse system.
                       N = No
                       Y = Yes

OTP-PACK-FL            Alpha 1
Element: All Flag      This field indicates if the order type
                       requires packing feedback.  You can
                       perform packing feedback online or
                       perform batch feedback in he Lawson
                       Warehouse system.
                       N = No
                       Y = Yes

OTP-IMMEDIATE-FL       Alpha 1                                   OE51.1
Element: All Flag      This field indicates whether this order
                       is shipped immediately.
                       N = No
                       Y = Yes

OTP-PICK-LIST-FL       Alpha 1                                   OE51.1
Element: All Flag      This field indicates whether a pick
                       list should print for ship immediate
                       order types.
                       N = No
                       Y = Yes

OTP-PACK-LIST-FL       Alpha 1                                   OE51.1
Element: All Flag      This field indicates whether a pack
                       list should print for ship immediate
                       order types.
                       N = No
                       Y = Yes

OTP-INVOICE-FL         Alpha 1                                   OE51.1
Element: All Flag      This field indicates whether an invoice
                       should print for ship immediate order
                       types.
                       N = No
                       Y = Yes

OTP-INVC-TYPE          Alpha 4                                   OE114   OE51.1
Element: Invoice Type  This field contains the invoice type
                       that defaults when this order type is
                       used.  Invoice types are established in
                       BL06.1 (Invoice Type).

OTP-PROCESS-TYPE       Alpha 2                                   OE51.1  OE80.1
Element: Process Type  This field contains the process type
                       assigned to the order type.  Process
                       types determine which shipment
                       processing steps an order must go
                       through before invoicing.  You define
                       process types in the Lawson Warehouse
                       system.

OTP-ACTIVE-STATUS      Alpha 1                                   OE51.1
Element: Status        This field indicates the active status
                       of the order type.
                       A = Active
                       I = Inactive

OTP-USED-FL            Alpha 1                                   BL120   BL122
Element: Used          This field indicates whether the order    BL130   BL20.1
                       type has been used.                       BL20.3  BL21.2
                       Y = Yes                                   BL21.5  BL29.1
                       N = No                                    BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE51.1
                                                                 OE510   OE530
                                                                 OE810   OE830
                                                                 WH20.7

OTP-RUSH-FL            Alpha 1                                   OE51.1
Element: All Flag      The rush flag is used to mark document
                       demand records as 'rush' when demand is
                       created for orders that are for an order
                       type that this rush flag is Yes.
                       Y = Yes
                       N = No

                         ORDERTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OTPSET1   COMPANY                                                AP125   AP126
          ORDER-TYPE                                             AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL01.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL201   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 ...

                         ORDERTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Invoice Type   OEINVCTYPE   Required

                            OTP-COMPANY         -> OIN-COMPANY
                            OTP-INVC-TYPE       -> OIN-INVC-TYPE

Oecompany      OECOMPANY    Required

                            OTP-COMPANY         -> OEC-COMPANY

Whproctype     WHPROCTYPE   Required

                            OTP-COMPANY         -> WPT-COMPANY
                            OTP-PROCESS-TYPE    -> WPT-PROCESS-TYPE