Order Class Maintenance Database Information

Data for Order Class Maintenance is stored in the oe-order-class table.

Field

Field

Field Name

Order Class

order-class

General Tab Fields

Field

Field Name

Short Description

short-desc

Detailed Description

detail-desc

Type

type

Used for Drop Ship Commission Orders

drop-ship-comm-order

Used for Aptean eCommerce

use-ecommerce

Print Pick Demands from Order Entry

oe-entry-print-pick

Express Return Orders

allow-express-returns

Ignore Margin Check

ignore-margin-check

Generate Invoice Numbers at Pick Demand Create

gen-inv-num-at-pick-create

Use for Internal Requisitions Only

internal-requisition

Ignore Credit Check

ignore-credit-check

Tax Calculated from the Shipping Warehouse

over-the-counter

Consolidate Transfer POs by Sales Order

transfer-po-cons

Calculate Price for Returns

calc-return-price

Single Pick Demand Printer Override

single-pt-printer-override

Point of Sale

point-of-sale

Override Pick Method

override-pick-method

Bypass Sales History Update

bypass-sales-history

Bypass DRP History Update

bypass-drp-history

Exclude Orders from Forecast Demand

exclude-forecast

Bypass DRP History Update For Special Orders Only

bypass-drp-special-history

Allow Drop Ship Order Voids

allow-drop-ship-order-voids

Orders Default As Freight Free

freight-free

Ignore Forecast Hold

ignore-forecast-hold

Skip Tax Calculation

skip-tax

Do not add freight charge at Pick Demand Confirm

no-freight-charge

Profitability Tab Fields

Field

Field Name

Profit Category Code Sales (Customer)

cust-profit-cat-code-sales

Profit Subcategory Code Sales (Customer)

cust-profit-subcat-code-sales

Profit Category Code Cost (Customer)

cust-profit-cat-code-cost

Profit Subcategory Code Cost (Customer)

cust-profit-subcat-code-cost

Profit Category Code Sales (Supplier)

supp-profit-cat-code-sales

Profit Subcategory Code Sales (Supplier)

supp-profit-subcat-code-sales

Profit Category Code Cost (Supplier)

supp-profit-cat-code-cost

Profit Subcategory Code Cost (Supplier)

supp-profit-subcat-code-cost

Profit Category Code Sales (Product)

prod-profit-cat-code-sales

Profit Subcategory Code Sales (Product)

prod-profit-subcat-code-sales

Profit Category Code Cost (Product)

prod-profit-cat-code-cost

Profit Subcategory Code Cost (Product)

prod-profit-subcat-code-cost

Options Tab Fields

Field

Field Name

Pricing Option

pricing-date

Price Change Reason Option

require-pc-reason

Shipper

shipper-override

Method

pick-method

Print Order Acknowledgments

auto-oa-send

Order Acknowledgment Form Name

ord-ack-form-name

Backorder Priority

backorder-priority

Print Invoices

prnt-inv-after-pt-conf

Invoice Date

invoice-date

Import Duplicate PO Number

imp-dup-po-num

Credit Card Authorization Basis

cc-auth-basis

PO Class

po-class

Supplier Consignment Transfer PO Class

po-class-consign

Prompt for Bookings Change Reason

prompt-book-reason

Default Bookings Change Reason

dflt-book-reason

Require Drop Ship PO

require-drop-ship-po

Default Drop Ship Class

default-ds-class

Default Special Order Class

default-so-class

Sales Order Entry Option

dflt-oe-option

Ignore Minimum/Multiple

ignore-min-mult

Minimum Option

order-min-option

Order Minimum

order-min

Can Generate Replacement Sales Order

gen-replace-order

Place Orders on Manual Hold

auto-manual-hold

Reason Code

auto-hold-reason-key

Do Not Send EDI ASN

skip-856

Do Not Send EDI Invoice

skip-810

Do Not Send EDI Order Acknowledgment

skip-855

Do Not Send Order Status

skip-870

Accounts Tab Fields

Field

Field Name

A/R

ar-acct-mask

Sales

sales-acct-mask

Sales Discount

sales-disc-acct-mask

Sales Charge

add-chrg-acct-mask

Sales Returns

sales-ret-acct-mask

Sales Returns Discount

sales-ret-disc-acct-mask

Inventory

inv-acct-mask

Cost of Goods Sold

cogs-acct-mask

Cost of Goods Sold Returns

cogs-ret-acct-mask

Returns Expense

exp-ret-acct-mask

Transfer Sale

transfer-sale-acct-mask

In Transit

in-transit-acct-mask

Ship and Debit

ship-debit-acct-mask

Ship and Debit Variance

ship-debit-var-acct-mask

Bill and Hold Clearing

bill-and-hold-clearing-mask

Bill and Hold Variance

bill-and-hold-variance-mask

VAT Accts Tab Fields

Field

Field Name

Output VAT

output-vat-mask

Output VAT Variance

output-vat-variance-mask