|
|
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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL01.1
BL201 CXCP.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 PO136 PO190 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 RQ10.1 RQ10.2 RQ10.3 RQ11.1
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
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
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 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)
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 Fl 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: Pick Fl 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
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: Invc 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: 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 Warehouse.
OTP-ACTIVE-STATUS Alpha 1
Element: Active Status This field indicates the active status
of the order type.
A = Active
I = Inactive
OTP-USED-FL Alpha 1 BL120 BL122
Element: Used Fl 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
WH20.7
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL01.1
BL120 BL122
BL130 BL20.1
BL20.3 BL201
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
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
|
