ADJUSTMENT

N

The type of adjustment. For example, Damaged or Misplaced. The Adjustment Type field displays on the Inventory Adjustment screen.

COST_METHOD

Y

This indicates how costing of inventory is done.

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

·       Calculated Average Cost

·       Manual Average Cost

The Cost Method field displays on the General Setup screen in Product Maintenance.

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 currently not being used for this type.

DATE_FORMAT

Y

Allows you to select the date format the file you are uploading uses.

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

·       DD/MM/YYYY Format

·       DD-MMM-YYYY Format

·       DDMMYYYY Format

·       DD-MM-YYYY Format

·       MM/DD/YYYY Format

·       MMDDYYYY Format

·       MM-DD-YYYY Format

·       MMYYYY Format

·       MMyy Format

·       MM/yy Format

·       MM/yyyy Format

·       YYYYMMDD Format

The Date Format Code field displays on the Shipping Import Mapping tab of the Warehouse Definition screen.

DELIMITER

Y

This field is required if the selected File Format Code is “Delimited”. Select the punctuation type to be the delimiter in the mapping file.

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

·       Delimited by (,)

·       Delimited by (|)

·       Delimited by (tab)

·       Delimited by (~)

The Delimiter Code field displays on the Shipping Import Mapping tab of the Warehouse Definition screen.

ENCLOSED_BY

Y

This field is required if the selected File Format Code is “Delimited”. Select the punctuation type by which to enclose the mapping records. For example, comma or double-quotes.

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

·       Enclosed by (,)

·       Enclosed by (")

The Enclosed By Code field displays on the Shipping Import Mapping tab of the Warehouse Definition screen.

EVENT

Y

This is currently not being used.

FILE_FORMAT

Y

Allows you to select the format of the file you are mapping to. For example, Delimited or Fixed.

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

·       Delimited

·       Fixed

The File Format field displays on the Shipping Import Mapping tab of the Warehouse Definition screen.

FREE_SHIPPING_QUAL_TYPE

Y

As of 7.5.2, indicate the type of free shipping qualification. For more information on free shipping, please see Free Shipping Setup Overview.

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

·       Coupon

·       Free Shipping

·       Market Code

FULFILL_STATUS

Y

The status of the product within the order.

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

·       L - Packing Slip Printed

·       N - Not Fulfilled

·       P - Pre-shipped

·       R - Returned

·       S - Shipped

·       TSO - Terminate Standing Order

For more information about each fulfill status, please see Inventoried Product Orders.

The Fulfill Status field displays on the Line Item Details screen.

The Option 1 field is currently not being used for this type.

INV610

Y

This displays the valid field attributes that can be used in a shipping export file which is generated by the INV610 batch process.

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

·       Order Number

·       Order Line Number

·       Tracking Number

·       Ship Via Code

·       Ship Master Customer Id

·       Ship Sub Customer Id

·       Ship Date

·       Order Qty

The Field Name Code field displays on the Shipping Import Mapping tab of the Warehouse Definition screen.

LINE_STATUS

Y

The status of the line item on the order. For example, Active, Back-Ordered, Cancelled, Held, Proforma, or Returned. The Line Status field displays on the Line Item Details screen.

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.

PLACEMENT

Y

Determines where the related link will display on the Inventoried Product Detail page on the web.

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

·       Additional Information

The Placement field displays on the Related Links screen.

PRODUCT_CLASS

N

Used to identify the class of product. For example, a book, button, CD ROM, clothing, consulting, file, kit, manual, membership, print on demand, shirt, or video. The Product Class field displays on the General Setup screen in Product Maintenance.

As of 7.5.0, unique icons can be defined for each PRODUCT_CLASS code to display in your online store, as shown below. These icons will display on the Product Listing, Product Detail, and Event Calendar pages in e-Business. For more information, please see Configuring Categorical Iconography.

The Option 1 field is currently not being used for this type.

Option 2 identifies a second level of search category for the product class that is used in faceted search on the web.

PRODUCT_TYPE

Y

The type of product. The options available change depending on the selection made here.

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

·       Individual Product

·       Standing Order Product

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.

RECORD_STATUS

Y

Used by the INV610 batch process to set the record status in the INV610_UPLOAD table.

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

·       Invalid

·       Valid

·       Processed

The Record Status Code field displays on the Maintain INV610_Upload (INV610_UPLOAD) screen.

REVENUE_RECOG_METHOD

Y

Controls how revenue recognition for the order will be handled. Run FAR670 to recognize the revenue.

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

·       On Invoice

·       On Specific Date

·       At Year End

The Recognition Method field displays on the General Ledger Accounts screen.

TXN_TYPE

Y

The filter by which you can search for types of inventory transactions.

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

·       Inventory Adjustment

·       Internal Usage

·       Inventory Receipt

·       Shipping

·       Inventory Transfer

·       Transfer In

·       Transfer Out

The Txn Type field displays on the Inventory History screen.

URL_TYPE

N

User-defined system type used to categorize related links on the Inventoried Product Detail page on the web. The URL Type field displays on the Related Links screen.

WEB_SHIPPING_MESSAGE

N

It is a user-defined message that gives information to the purchaser about shipping (e.g., Usually ships in 2-4 days).

The message displays as an option from the Web Shipping Message drop-down on the eBusiness Control screen. See Defining an Inventoried Product to Display on the Web for more information.