Purchasing Field Mapping

The following fields are mapped from Lucity to FE when using the FE Purchase Request integration. Lucity sends Purchase Request records including Purchase Request (Parent) and the Items under it to the Finance Enterprise Purchase Request module.

Note: Lucity forms are customizable; therefore, field placement shown on forms below may vary. More information about Lucity Web Form Design Mode.

Lucity Purchase Request form

fe field map luc purch req

Lucity > Purchase Request mapped to: Finance Enterprise > Purchase Request

Purchase Request # : PR

Status : Status

Note: Status options in Lucity are hard-coded to options that also exist in FE to facilitate field mapping and systems integration.

Requested Date : Date

Logged In User : Requested By

Note: The Requested By field in FE will show the Lucity user who created the record and is an authorized CS user, or the designated CS Fallback User.

Finance Vendor ID : Vendor ID

Account # : Cust / Order #

Required Date : Required Date

Expected Date : Expected Date

FE Purchase Request screen

fe field map fe purch req

Lucity also sends Purchase Request > Items to the FE Purchase Request Items screen.

Lucity Purchase Request Items form

fe field map luc purch req items

Lucity > Purchase Request > Items mapped to: Finance Enterprise > Purchase Request Items

CS Product ID : Product ID

Quantity : Quantity

Unit Price : Unit Price

Product Description : Item Description

CS General Ledger : GL Lookup

CS General Key : GL Org Key Lookup

CS General Object : GL Object Lookup

CS Job Ledger : JL Lookup

CS Job Key : JL Key Lookup

CS Job Object : JL Object Lookup

Fixed Asset : Fixed Asset

The Fixed Asset/Fixed Asset fields are checkboxes that when set to TRUE in Lucity will also get set to TRUE in FE.

FE Purchase Request Items screen

fe field map fe purch req item

Note: Field mapping for the Purchase Request integration is customizable. Contact CentralSquare Support to configure this integration.