CUSRELATION

N

The classification of the customer relationship. For example, Author, Co-Sponsor, Product Manager, Speaker, Sponsor, Staff, or Vendor.

The Relationship Type field displays on the Related Customers screen.

The Option 1 field is used to create a product relationship between the product and the constituent. Enter "CUS001I-APPEARANCE" in this field in order for the code to be an option from the Relationship Type drop-down on the Related Customers screen.

FULFILL_STATUS

Y

The status of the product within the order. The Fulfill Status field displays on the Line Item Details screen in Order Entry.

LINE_STATUS

Y

The status of the line item in the order. For example, Active, Cancelled, or Proforma. The Line Status field displays on the Line Item Details screen in Order Entry.

The Option 1 field determines whether or not FAR670 will recognize the order line. Enter "RevenueRecognition" in this field if you want FAR670 to process the transaction. In the base application, only line status codes of "A" have "REVRECOGNITION" in the Option 1 column. This was executed for organizations that customize order entry to use different line status codes.

Option 3 identifies whether order lines with the line status defined by the code should be included in invoices.

MONTHLY_NTH

Y

The following codes are delivered with base and cannot be changed:

·       First

·       Fourth

·       Second

·       Third

MONTHLY_NTH_DAY

Y

The following codes are delivered with base and cannot be changed:

·       Friday

·       Monday

·       Saturday

·       Sunday

·       Thursday

·       Tuesday

·       Wednesday

PRODUCT_CLASS

N

This allows you to classify the Facility product more specifically. For example, you use this to label the Facility product as a Rental. The Product Class field displays on the General Setup screen in Product Maintenance.

PRODUCT_TYPE

Y

This is used for Facility Product Maintenance. The product type can be set to Fees, Food Service, or Room Reservation. The Product Type field displays on the General Setup screen in Product Maintenance.

RATE

N

The established rate code determines the pricing for the rate structure. For example, Standard or Replacement. The Rate Code field displays on the Rates and Pricing screen.

REVENUE_RECOG_METHOD

Y

Controls how revenue recognition for the order will be handled. For example, On Invoice, On Specific Date, or At Year End (refers to the fiscal year end). Run FAR670 to recognize the revenue. The Recognition Method field displays on the General Ledger Accounts screen.

ROOM_RESERVATION_STATUS

N

The status of the room reservation. This is used to specify if a room is Internal, Confirmed, On Hold, etc. Additional statuses may be configured. The Room Reservation Status field displays on the Facility Room Reservation screen.