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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    CXCP.1    IC28.1
IC83.1    MA180     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    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    PO100     PO101
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.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    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    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ12.1    RQ13.1    RQ35.1    RQ500     RQIE.1
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

WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

OTP-ORDER-TYPE         Alpha 2
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)
Element: Description   This field contains the description of
                       the order type.

OTP-CREATE-PO          Alpha 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
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
Element: All Flag      This field indicates whether this order
                       is shipped immediately.
                       N = No
                       Y = Yes

OTP-PICK-LIST-FL       Alpha 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
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
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
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
Element: Order Type CodThis 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
Element: Status        This field indicates the active status
                       of the order type.
                       A = Active
                       I = Inactive

OTP-USED-FL            Alpha 1                                   WH20.7
Element: Used          This field indicates whether the order
                       type has been used.
                       Y = Yes
                       N = No

OTP-RUSH-FL            Alpha 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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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