|
|
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 BL120 BL130 BL20.1 BL20.3 BL201
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL940 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC141 IC142 IC83.1 OE251 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE53.1 OE80.1 OE830 OE90.1 OE950 PO31.1
RQ10.1 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ35.1 RQ500 RQ961 WH130 WH132 WH190
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140 WO20.1
WO30.1 WO32.1 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
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 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE51.1 OE510 OE810 OE920 OE960 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTP-COMPANY Numeric 4 OE51.1 OE960
Company This field contains the company number.
OTP-ORDER-TYPE Alpha 2 OE51.1 OE960
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) OE51.1 OE53.1
Description This field contains the description of OE960
the order type.
OTP-CREATE-PO Alpha 1 OE51.1 OE960
Create Purchase This field indicates whether or not the
Order order type can create a purchase order.
Y = Yes
N = No
OTP-DROPSHIP-FL Alpha 1 OE51.1 OE960
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 OE960
Pick 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 OE960
Pack 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 OE960
Immediate Flag This field indicates whether this order
is shipped immediately.
N = No
Y = Yes
OTP-PICK-LIST-FL Alpha 1 OE51.1 OE960
Pick List 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 OE960
Pack List 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 OE960
Invoice 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
Invoice Type This field contains the invoice type OE960
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
Process Type This field contains the process type OE960
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 OE960
Active Status This field indicates the active status
of the order type.
A = Active
I = Inactive
OTP-USED-FL Alpha 1 BL92.1 OE10.1
Used Flag This field indicates whether the order OE10.2 OE10.3
type has been used. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE51.1 OE510
OE810 OE920
OE960 WH20.7
OTP-RUSH-FL Alpha 1 OE51.1
Rush 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 BL01.1 BL120
ORDER-TYPE BL130 BL20.1
BL20.3 BL201
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.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
|