Non-Aggregates Utilities>PM Report Designer

Overview

Non-aggregates are transaction data that cannot be accumulated. Employee name or invoice date are examples of non-aggregates.

BillDPEMult - DPE multiplier used for bill rate from labor transactions

BillOHMult - Overhead multiplier used for bill rate from labor transactions

BillPrMult - Profit multiplier used for bill rate from labor transactions

BillRate - Bill rate from labor transaction

BillStatus - Bill status from cost transactions. See List Management for possible values

ChargeOrgCode - Charged organization unit code from labor transaction

ChargeOrgLongName - Charged organization unit long name from labor transaction

ChargeOrgName -Charged organization unit name from labor transaction

ChargeOrgPath - Charged organization unit path from labor transaction

ClientCode - Client code assigned to project

ClientName - Client name assigned to project

CostRate - Cost rate from labor transactions. Is either the pay rate or job cost rate, depending on Global Settings

ExpenseCode - Expense code from non-labor transactions

ExpenseName - Expense code name from non-labor transactions

GLCode - General ledger base account code

GLName - General ledger base account name

HomeOrgCode - Employee home organization unit code from labor transaction

HomeOrgLongName - Employee home organization unit long name from labor transaction

HomeOrgName - Employee home organization unit name from labor transaction

HomeOrgPath - Employee home organization unit path from labor transaction

JCDPEMult - DPE multiplier used for job cost rate from labor transactions

JCOHMult - Overhead multiplier used for job cost rate from labor transactions

JCPrMult - Profit multiplier used for job cost rate from labor transactions

JobCostRate - Job cost rate from labor transactions

JobTitleCode - Job title code from labor transactions

JobTitleName - Job title from labor transactions

LaborCode - Labor code from labor transactions

LaborName - Labor code name from labor transactions

LineID - Transaction line item ID. If selected, every line item, including prior versions and reversals, will appear in dataset. This will prevent any grouping of data

MasterName - Master name. Can be employee, vendor, or client, depending on transaction type

MetricType - Metric type (see List Management for possible values)

OrgCode - Organization unit code assigned to project

OrgLongName - Organization unit long name assigned to project

OrgName - Organization unit name assigned to project

OrgPath - Organization path assigned to project

Periodcode - General Ledger period code

PEDate - Period End Date

PMComments - Project Management comments from transactions

PMTypecode - Project Management type code (see List Management for possible values)

PMTypename - Project Management type name (see List Management for possible values)

PMTypeOrder - Project Management type sort order (see List Management for possible values)

Principal - Principal assigned to the project

PrjAcct - Project accountant assigned to the project

PrjMgr - Project Manager

Source - Source of transaction; typically, the journal name

TimePEDate - Time Period End Date

TimePSDate - Time Period Start Date

TransCode - Transaction code; key transaction ID that varies by journal. Can be invoice number, check number, etc.

Transdate - Transaction Date; varies by journal. Can be invoice date, check date, work date, etc.

TransID - Transaction ID; system-generated ID that groups the transaction

UnitBill - Unit bill rate for non-labor transactions; cost rate with markup

UnitCost - Unit cost rate for non-labor transactions

UnitMarkup - Unit markup for non-labor transactions; markup can be multiplier, flat amount, or add-on.