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
BL01.1 BL201 CXCP.1 DR100 IC141 IC142
IC83.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1 WH110
WH120 WH130 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
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
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 BL01.1 BL201
ORDER-TYPE CXCP.1 DR100
IC141 IC142
IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
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
|
