|
Overview
Non-aggregates are transaction data that cannot be accumulated. Employee name or invoice date are examples of non-aggregates.
Field Descriptions
| • | 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. |
|