Type

Fixed?

Description

ADJUSTMENT_REASON

N

This is a free text field that is required when a price is entered.  It appears as part of the description in the FAR_TXN table with the Dr/Cr memo type transaction. This field is located on the Price Adjustments (ORD001H) screen.

DISCOUNT_CATEGORY

N

The category under which the discount falls. For example, Student. This code is located on the Discount Maintenance (ORD100) screen.

EFT_END_REASON

N

The end reasons are manually entered when the end date is entered for an EFT. This is typically used on a reoccurring payment. This field displays if you select “Direct Debit” for the Auto Pay Method on the Show Full Line Item Detail (ORD001_LineItemPricint) screen.

FILE_TYPE_CODE

N

Describes the type of related file for a product. For example, a Microsoft Word document or a Bitmap image. This field is located on the Product Maintenance > Relationships > Related Files screen.

FIXED_PERCENT

N

The shipping charge definition. For example, a fixed rate or a percentage. This field is located on the Shipping Charges Maintenance > By Schedule screen.

LINE_STATUS_REASON

N

User-defined code that identifies the reason for the line item status being changed. This code is located on the Line Item Details screen. See “Showing the Line Item Details” section for more information.

ORDER_METHOD

N

User-defined code that identifies how the order was placed. For example, Web, Mail, Phone, Fax, Walk-In. This code is located on the Order Entry screen in the Additional Order Information section. See the “Adding Additional Order Information” section for more information.

ORDSTS_REASON

N

User-defined code that identifies the reason for the order status being changed. This code is located on the Order Entry screen in the Additional Order Information section. See the “Adding Additional Order Information” section for more information.

PRODUCT_CATEGORY

N

The category used for searching from the Web. This field is located on the Product Maintenance > Relationships > Categories and Keywords screen.

PRODUCT_STATUS

N

The status of the product, which determines whether the product can be seen on the Order Entry screen. For example, Active, Cancelled, or Discontinued. This field is located on the Product Maintenance screen.

PYMT_STATUS_REASON

N

REVENUE_REGOGNITION

Y

This field displays on the Cancellation and Refunds (FAR003a) screen.

• None: refunds the entire amount to the customer.

• Recognize All: recognizes the entire amount in revenue and does not refund the customer. From the Cancellation and Refunds screen, this option is the default.

• Prorate: refunds only the remaining amount of the order to the customer.

• Amount Paid: recognizes all the amount paid by customer: sum(Far_Txn.BASE_AMOUNT ) times -1 where Far_Txn.TYPE_CODE in (‘1’,’2’,’3’). If a membership or subscription order is being cancelled that has a payment schedule, this option is the default.

SHIP_VIA

N

The name of the entity used to ship the order. For example, UPS, USPS, or FedEx. This field is located on the Product Maintenance > Shipping Charges screen.

TAX_CATEGORY

N

The tax category that controls how taxes are charged. Allows segregation of the tax records. For example, Sales Tax, Sub Tax, or VAT. This field is located on the Sales Tax Maintenance screen.

TAX_LEVEL

N

The calculation method of the sales tax. For example, City tax or State tax. The Calculation Method field displays on the Sales Tax Maintenance screen.

UNIT_OF_MEASURE

N

The measuring unit used for Inventoried Products. For example, pounds, ounces, or units.

VAT_CATEGORY

N

The category of the VAT tax. For example, 10%, 17.5%, or 5%. This code is located on the  VAT Tax Maintenance (ORD198) screen.