Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    CXCP.1    DR100     IC141     IC142     IC28.1
IC83.1    MA180     MA43.9    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.3    MA67.1    MA67.2
MA70.1    MAI1.1    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    RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ35.1
RQ500     RQIB.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

UPDATED BY

WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

OTP-CREATE-PO        Alpha 1
Create Purchase      This field indicates whether or not the
Order Flag           order type can create a purchase order.
                     Y = Yes
                     N = No

OTP-DROPSHIP-FL      Alpha 1
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
Picking Option Flag  This 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
Pack Option 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
Immediate Order Flag This field indicates whether this order
                     is shipped immediately.
                     N = No
                     Y = Yes

OTP-PICK-LIST-FL     Alpha 1
Pick List Fl         This field indicates whether a pick
                     list should print for ship immediate
                     order types.
                     N = No
                     Y = Yes

OTP-PACK-LIST-FL     Alpha 1
Pack List Fl         This field indicates whether a pack
                     list should print for ship immediate
                     order types.
                     N = No
                     Y = Yes

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

OTP-INVC-TYPE        Alpha 4
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
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
Status               This field indicates the active status
                     of the order type.
                     A = Active
                     I = Inactive

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

OTP-RUSH-FL          Alpha 1
Rush Fl              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  CXCP.1
                                                                 DR100   IC141
                                                                 IC142   IC28.1
                                                                 IC83.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 ...

                         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