ORDERTYPE – Order Type

System
OE (OE)
Prefix
OTP
Primary key
COMPANY, ORDER-TYPE
Fields
16
Updated by
1 program
Referenced by
234 programs

ORDERTYPE is the Order Type table in Lawson OE (prefix OTP). It is indexed by COMPANY, ORDER-TYPE (OTPSET1). It is related 1:1 to OEINVCTYPE, OECOMPANY and WHPROCTYPE. It is updated by WH20.7 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 226 more. The table has 16 fields, 1 index and 3 documented relations.

About ORDERTYPE

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.

Fields (16)

Column = COBOL field name without the OTP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OTP-COMPANY PK
COMPANY		Numeric 4This field contains the company number.—
OTP-ORDER-TYPE PK
ORDER_TYPE		Alpha 2This field contains the order type, which determines how the order is processed. Order types are established in OE51.1 (Order Type).—
OTP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description of the order type.—
OTP-CREATE-PO
CREATE_PO		Alpha 1This field indicates whether or not the order type can create a purchase order.
  • Y Yes
  • N No
—
OTP-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This 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
PICK_FL		Alpha 1This 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
PACK_FL		Alpha 1This 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
IMMEDIATE_FL		Alpha 1This field indicates whether this order is shipped immediately.
  • N No
  • Y Yes
—
OTP-PICK-LIST-FL
PICK_LIST_FL		Alpha 1This field indicates whether a pick list should print for ship immediate order types.
  • N No
  • Y Yes
—
OTP-PACK-LIST-FL
PACK_LIST_FL		Alpha 1This field indicates whether a pack list should print for ship immediate order types.
  • N No
  • Y Yes
—
OTP-INVOICE-FL
INVOICE_FL		Alpha 1This field indicates whether an invoice should print for ship immediate order types.
  • N No
  • Y Yes
—
OTP-INVC-TYPE
INVC_TYPE		Alpha 4This 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
PROCESS_TYPE		Alpha 2This 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
ACTIVE_STATUS		Alpha 1This field indicates the active status of the order type.
  • A Active
  • I Inactive
—
OTP-USED-FL
USED_FL		Alpha 1This field indicates whether the order type has been used.
  • Y Yes
  • N No
WH20.7
OTP-RUSH-FL
RUSH_FL		Alpha 1The 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
—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OTPSET1COMPANY, ORDER-TYPEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Invoice TypeOEINVCTYPERequiredOTP-COMPANY → OIN-COMPANY, OTP-INVC-TYPE → OIN-INVC-TYPE
OecompanyOECOMPANYRequiredOTP-COMPANY → OEC-COMPANY
WhproctypeWHPROCTYPERequiredOTP-COMPANY → WPT-COMPANY, OTP-PROCESS-TYPE → WPT-PROCESS-TYPE

Programs

Updated by (1)

Referenced by (234)