Material Setup Fields

The fields described below have special functions. For a complete list of available fields, see the Lucity Data Dictionary.

ID Fields

Material**	Serves as the user-defined, unique ID for the item that will be used to complete work.
Material Text*	Identifies the item by its common name.
Material Rec #	Indicates the unique, system-generated ID for the Material Setup record.
Material Status	Describes the material's current operational condition (e.g., operational, non-operational, etc.) using a user-defined code-description field.
Active Material	Indicates whether this item is currently an option for users to select as a Resource on a Work Order or PM.
Special ID	Enables users to assign an alternate identifier for the material.

* Required.
* Must be unique.

General Fields

Make	Identifies the brand or manufacturer of the material.
Model	Identifies the manufacturer's identifying name or number for the material.

Departmental Fields

Department	Identifies the organizational unit, if any, that is associated with this Material by default. For example, road salt might be associated with the Street Department's Maintenance Division.
Division
Sub-Division
Area
Sub-Area

Account Fields

Account #	Indicates the reference number for the general account billed, by default, when the material is used. When a user adds this Material as a Resource on a Work Order or PM, this value is carried over to the Account # field on the Work Order or PM record. If this field is left blank and this Material is used on a Material Kit, the Kit's Account # value will populate to this field on a Work Order or PM record. Note: Future changes to these fields on the Material Kit will not copy to the Material going forward. The system can be configured to handle account numbers in various formats. The format dictates how users complete this field. More information about Account Number formats
Proj No- Acct	Indicates the reference number for a specific project account that should be billed, by default, when the material is used. When a user adds this Material as a Resource on a Work Order or PM, this value is carried over to the Proj No - Acct field on the Work Order or PM record. If this field is left blank and this Material is used on a Material Kit, the Kit's Proj No - Acct value will populate to this field on a Work Order or PM record. Note: Future changes to these fields on the Material Kit will not copy to the Material going forward. An agency can configure Lucity to handle project numbers in various formats. The configuration determines how users complete this field. More information about Project Account Number formats
Journal Entry Import	Directs the system to export a journal entry for this material resource from Lucity into the Ledger of an integrated financial system. This field only applies to agencies that integrate Lucity with an outside financial software such as Finance Enterprise. More information about the Finance Enterprise integrations.
Eden Item ID *	Identifies the item by its unique Eden parts number. This field is used in conjunction with the Lucity > Eden Inventory Integration.
Eden Warehouse *	Indicates the warehouse in the Eden system where this material is disbursed by from default. This field is read-only and used in conjunction with the Lucity > Eden Inventory Integration.

Cost Fields

Unit Cost

Indicates the default amount charged for the material per unit.

If the Material is not linked to a Part record, when you add this Material as a Resource on a Work Order or PM, this value is carried over to the Default Unit Cost field on the Work Order or PM resource record.
If the Material is linked to a Part record, when you add this Material as a Resource on a Work Order or PM, this value is carried over to the Unit Cost Esimate field on the Work Order or PM resource record.

Unit of Measure

Identifies how this item is measured for a Work Order Task (e.g., pounds, rolls, feet, meters, etc.).

Warranty Fields

Warranty Length (days)	Indicates the duration of the warranty in days. The system uses this value, along with the Work Order Asset's Completion Date to calculate the warranty's Expiration Date.
Warranty Distance (miles)	Specifies the number of miles covered under warranty. This value is used to complete the warranty's Mileage Coverage field.
Warranty Vendor Code	Identifies the vendor that supplies the warranty. This value is used to complete the warranty's Manuf Code field.

Linking Fields

CS Product ID

Identifies a product in the Finance Enterprise system that is linked to this Material. This field must be populated manually or synced in order to enable FE Stores integration.

More information on FE Products/Materials integration.

CS Warehouse ID

Identifies a warehouse in the Finance Enterprise system where the CS Product linked to this Material is located.

If a CS Warehouse ID is defined on an Equipment Resource on the same Work Order Task, that value will override this value on the Work Order's Material Resource.

More information on FE Stores Order integration.

CS Integration Fields

The following fields relate to records in CentralSquare's Finance Enterprise (FE) system. More information about the Finance Enterprise integration.

Note: In certain Lucity modules, these fields may require specific values or combinations based on FE Ledger configuration.

CS General Ledger	Identifies a General Ledger (GL) record in FE.
CS General Key	Identifies a GL Key record in FE.
CS General Object	Identifies a GL Object record in FE.
CS Job Ledger	Identifies Job Ledger (JL) record in FE.
CS Job Key	Identifies a JL Key record in FE.
CS Job Object	Identifies a JL Object record in FE.

CS Fixed Asset

Identifies a Fixed Asset in the Finance Enterprise (FE) system.

Important: This field supports manual entry but will only validate against Fixed Asset records in FE when selecting a value from the lookup.
Note: This field is only used in inventory modules.