Non-Aggregates

Top  Previous  Next

Module:  Utilities    

Applet:  PM Report Designer

 


Description: 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.