Customizable Quote Listing Line Level Report- Field Descriptions

Have more questions? Submit a request

This article provides descriptions for the fields available in the Customizable Quote Listing - Line Level Report. For more information about how to build this report, click here. Note: these fields are also applicable to any line-level quote report that has the "Customize" option available. For a full list of reports, click here. 

  • Field Name- the name of the field
  • Group- whether the field can be grouped
  • Split- whether the field can be split using the "Adjust Values" feature
  • Total- whether the field can be totaled
  • Field Descriptions- the description of the field

A column with an "N" represents "No", whereas a column with a "Y" represents "Yes."

Field Name Group Split Total Field Description
***** Row Break ***** N N N Inserts a row break between fields on the report
Active Y Y N Job active or inactive
Approved Project Percentage N N Y Percentage of parts specified that have been approved
Architect Y Y N Architect(s) working on the project
Base N N Y Total for the base column on the quote
Bid Date N Y N The date the quote is being bid on
Bid Date and Time N Y N The date and time the quote is being bid on
Bid Name Y Y N The name of the bid
Bid Time N Y N The time the quote is being bid on
BidBoard Y Y N Is the quote on the bid board?
BidMonth Y Y N Bid date - Year/Month
BidYear Y Y N Year of the bid date
Completion Date N Y N Date the project is slated for completion (estimate)
Contractor Y Y N Contractor(s) working on the project
Cost N N Y Total price from the factory in factory currency
Create Date N Y N Date quote created
Create User Y Y N User ID of the person who created the quote
CSR Y Y N CSR for the quote
Customer Assigned Commission N N Y Based on customer assignment:  Commission for the sell price
Customer Assigned Commission Percentage N N Y Based on customer assignment: Percentage of commission for the sell price
Customer Assigned Earnings N N Y Based on customer assignment: Commission + Overage + Profit
Customer Assigned Gross Profit Percentage N N Y Based on customer assignment: Percentage of total earnings for the sell price
Customer Assigned Overage N N Y Based on customer assignment: Overage for the sell price
Customer Assigned OverageSplit N N Y Based on customer assignment: Rep take of the overage on the order
Customer Assigned Price N N Y Based on customer assignment:  Sell price column value
Customer Assigned Profit N N Y Based on customer assignment:  Profit for the sell price
Customer Assigned To Y Y N Assigned Salesmen of the customer(s)
Customer Display ID Y Y N Customer ID (List)
Customer Invoiced N N Y Amount invoiced of customer orders
Customer Name Y Y N Customer Name (List)
Customer Notes Y Y N Notes specific to a Customer in a project.
Customer Win/Loss Status  Y Y N Customer's win or loss status
Customers Committed Y Y N Customers Committed to Win on Quote
DBID Y Y N OASIS Database ID
Electrical Contractor Awarded Y/N Y Y N Electrical contractor chosen on the job
Engineer Y Y N Engineer(s) working on the project
Expiration Date N Y N Date the quote expires
External Notes Y Y N External Notes from the project.
External Project Number Y Y N Place to denote the external website's identifier for this job
File Code Y Y N Manually entered code indicating where closed file is stored
Filed On N Y N Date the file code was entered.  Presumably when the job was filed.
FixtureType Y Y N Item fixture type
Followed By Y Y N Sales person(s) following the project
FollowUp Assignment Notes Y Y N Project customer followup assignments.
FollowUp Notes Y Y N Notes added for tracking the progress of the project.
General Contractor Awarded Y/N Y Y N General contractor chosen on the job
Gross Profit Percentage of all orders N N Y Percentage of total earnings for the sell price
Indirect Customer Assigned To Y Y N Assigned Salesmen of the indirect customer(s) of the job
Indirect Customers Y Y N Indirect customer(s) of the job
Level 1 N N Y Customer sell price - Level 1
Level 1 Commission N N Y Commission for the sell price - Level 1
Level 1 Commission Percentage N N Y Percentage of commission for the sell price - Level 1
Level 1 Earnings N N Y Commission + OverageSplit + Profit at Level 1
Level 1 Gross Profit Percentage N N Y Percentage of total earnings for the sell price - Level 1
Level 1 Net Price N N Y Lower price between Obase and Level 1
Level 1 OverageSplit N N Y Rep take of the overage on the order - Level 1
Level 1 Sell Overage N N Y Overage for the sell price - Level 1
Level 1 Sell Profit N N Y Profit for the sell price - Level 1
Level 2 N N Y Customer sell price - Level 2
Level 2 Commission N N Y Commission for the sell price - Level 2
Level 2 Commission Per Unit N N N Per Unit Commission for the sell price - Level 2
Level 2 Commission Percentage N N Y Percentage of commission for the sell price - Level 2
Level 2 Earnings N N Y Commission + OverageSplit + Profit at Level 2
Level 2 Gross Profit Percentage N N Y Percentage of total earnings for the sell price - Level 2
Level 2 Net Price N N Y Lower price between Obase and Level 2
Level 2 OverageSplit N N Y Rep take of the overage on the order - Level 2
Level 2 Sell Overage N N Y Overage for the sell price - Level 2
Level 2 Sell Profit N N Y Profit for the sell price - Level 2
Level 3 N N Y Customer sell price - Level 3
Level 3 Commission N N Y Commission for the sell price - Level 3
Level 3 Commission Per Unit N N N Per Unit Commission for the sell price - Level 3
Level 3 Commission Percentage N N Y Percentage of commission for the sell price - Level 3
Level 3 Earnings N N Y Commission + OverageSplit + Profit at Level 3
Level 3 Gross Profit Percentage N N Y Percentage of total earnings for the sell price - Level 3
Level 3 Net Price N N Y Lower price between Obase and Level 3
Level 3 OverageSplit N N Y Rep take of the overage on the order - Level 3
Level 3 Sell Overage N N Y Overage for the sell price - Level 3
Level 3 Sell Profit N N Y Profit for the sell price - Level 3
LineUID Y Y N Internal unique OASIS number identifying an individual quote line
Local Rep Y Y N Local representatives
Location City Y Y N City where project is located
Location State Y Y N State/province where project is located
Locked By Y Y N User who clicked on the "Locked" check box preventing nonadmin users from viewing or changing the project. 
Lot Price Order Y Y N Check box denoting that billing should be handled as a lot total and not show the customer individual unit prices.
Low Distributor Name Y Y N Low distributor working on the project
Low Distributor Y/N Y Y N Low distributor chosen for the project
Manufacturer (list) Y Y N Manufacturer or brand
Manufacturer ID (list) Y Y N Manufacturer or brand - ID
Manufacturer Quote Y Y N Manufacturer quote values on the quote
Mfg Product Type Y Y N Product Type on the Manufacturer
MfgPartNumber Y Y N Manufacturer's Part Number
OBase N N Y Total for the Obase column on the quote
Owner Y Y N Business or person who owns the job site
Parent Manufacturer (list) Y Y N Manufacturer or brand
Part Description Y Y N Catalog number description
PartNumber Y Y N Catalog Number
Per Unit Base N N N Per unit base column on the quote
Per Unit Cost N N N Price per unit from the factory in factory currency
Per Unit Level 1 N N N Per unit customer sell price - Level 1
Per Unit Level 1 Commission N N N Per Unit Commission for the sell price - Level 1
Per Unit Level 1 Commission N N N Per Unit Commission for the sell price - Level 1
Per Unit Level 1 Net Price N N N Per Unit lower ammount between Obase and Level 1 price
Per Unit Level 1 OverageSplit N N N Per unit rep take of the overage on the order - Level 1
Per Unit Level 1 Sell Overage N N N Per unit overage for the sell price - Level 1
Per Unit Level 1 Sell Profit N N N Per Unit Profit for the sell price - Level 1
Per Unit Level 2 N N N Per unit customer sell price - Level 2
Per Unit Level 2 Net Price N N N Per Unit lower ammount between Obase and Level 2 price
Per Unit Level 2 OverageSplit N N N Per unit rep take of the overage on the order - Level 2
Per Unit Level 2 Sell Overage N N N Per unit overage for the sell price - Level 2
Per Unit Level 2 Sell Profit N N N Per Unit Profit for the sell price - Level 2
Per Unit Level 3 N N N Per unit customer sell price - Level 3
Per Unit Level 3 Net Price N N N Per Unit lower ammount between Obase and Level 3 price
Per Unit Level 3 OverageSplit N N N Per unit rep take of the overage on the order - Level 3
Per Unit Level 3 Sell Overage N N N Per unit overage for the sell price - Level 3
Per Unit Level 3 Sell Profit N N N Per Unit Profit for the sell price - Level 3
Per Unit OBase N N N Per unit value for the Obase column on the quote
Per Unit Sell Commission N N N Per unit commission for the sell price
Per Unit Sell Earnings N N N Per unit: Commission + OverageSplit + Profit
Per Unit Sell Overage N N N Per unit overage for the sell price
Per Unit Sell OverageSplit N N N Per unit rep take of the overage on the order
Per Unit Sell Price N N N Sell price per unit
Per Unit Sell Profit N N N Per unit profit for the sell price
Phase ID N N N Behind the scenes ID for the phase in OASIS
Phase Name Y Y N Phase name of the quote
PO Commission N N Y Commission of all orders
PO Earnings N N Y Earnings of all orders
PO Entry Date N Y N Date the order(s) from this quote were entered.
PO Numbers Y Y N PO Number of all orders
PO Overage N N Y Overage of all orders
PO OverageSplit N N Y Overage split of all orders
PO Paid N N Y Amount paid of all orders
PO Profit N N Y Profit of all orders
PO Received N N Y Amount received of all orders
PO Sell N N Y Sell value of all orders
Product Type Y N N Product type established on the manufacturer part list
Project Y Y N Name of the related project
Project ID N N N Behind the scenes ID for the Project in OASIS
Project Name Y Y N Name of the related project including phase name
Quantity N N N Quantity quoted
Quote ID Y Y N Behind the scenes ID for the Quote in OASIS
Quote Internal Notes Y Y N Notes added to the project for internal use only
Quote Line Internal Note Y Y N Internal notes on a line
Quote Line Note Y Y N External notes on a line
Quote Locked Y Y N Checkbox that adjusts the settings of the quote preventing other nonadmin users from opening or viewing the quote
Quote Notes N Y N Notes from the external notes tab on the quote
Quote Number Y Y N Number assigned to the quote in OASIS
Quote Total Base N N Y Total for the base column on the quote
Quote Total Cost N N Y Total price from the factory in factory currency
Quote Total Customer Assigned Commission N N Y Based on customer assignment:  Commission for the sell price
Quote Total Customer Assigned Earnings N N Y Based on customer assignment: Commission + Overage + Profit
Quote Total Customer Assigned Overage N N Y Based on customer assignment: Overage for the sell price
Quote Total Customer Assigned Overage Split N N Y Based on customer assignment: Rep take of the overage on the order
Quote Total Customer Assigned Price N N Y Based on customer assignment:  Sell price column value
Quote Total Customer Assigned Profit N N Y Based on customer assignment:  Profit for the sell price
Quote Total Level 1 N N Y Total customer sell price - Level 1
Quote Total Level 1 Commission N N Y Total commission for the sell price - Level 1
Quote Total Level 1 Earnings N N Y Total Commission + OverageSplit + Profit at Level 1
Quote Total Level 1 OverageSplit N N Y Total rep take of the overage on the order - Level 1
Quote Total Level 1 Sell Overage N N Y Total overage for the sell price - Level 1
Quote Total Level 1 Sell Profit N N Y Total profit for the sell price - Level 1
Quote Total Level 2 N N Y Total customer sell price - Level 2
Quote Total Level 2 Commission N N Y Total commission for the sell price - Level 2
Quote Total Level 2 Earnings N N Y Total Commission + OverageSplit + Profit at Level 2
Quote Total Level 2 OverageSplit N N Y Total rep take of the overage on the order - Level 2
Quote Total Level 2 Sell Overage N N Y Total overage for the sell price - Level 2
Quote Total Level 2 Sell Profit N N Y Total profit for the sell price - Level 2
Quote Total Level 3 N N Y Total customer sell price - Level 3
Quote Total Level 3 Commission N N Y Total commission for the sell price - Level 3
Quote Total Level 3 Earnings N N Y Total Commission + OverageSplit + Profit at Level 3
Quote Total Level 3 OverageSplit N N Y Total rep take of the overage on the order - Level 3
Quote Total Level 3 Sell Overage N N Y Total overage for the sell price - Level 3
Quote Total Level 3 Sell Profit N N Y Total profit for the sell price - Level 3
Quote Total OBase N N Y Total for the Obase column on the quote
Quote Total Sell N N Y Total for the sell price column on the quote
Quote Total Sell Profit N N Y Total profit for the sell price on the quote
Quote Type Y Y N Denotes the type of quote
Quote Year Y Y N Year the quote was created
Quoted Customers Y Y N Customer(s) of the job
Quoter Y Y N Quoter for the project (orginator of pricing)
Rank Y Y N User set field denoting priority or importance of the quote to the company
Remarks N Y N Remarks manually entered on the quote Notes tab
Representative Y Y N Representative(s) of the job
Representative Splits Y Y N Representative splits on the general tab
Request for Approval Date N Y N Request for Approval Date
Resell Company Y Y N Resell Company ID
Sales Account Y Y N Sales account on the project
Sales Account(List) N Y N Sales account on the project (including %)
Sell N N Y Sell price column value
Sell Commission N N Y Commission for the sell price
Sell Commission Percentage N N Y Percentage of commission for the sell price
Sell Earnings N N Y Commission + OverageSplit + Profit
Sell Gross Profit Percentage N N Y Percentage of total earnings for the sell price
Sell Overage N N Y Overage for the sell price
Sell OverageSplit N N Y Rep take of the overage on the order
Sell Profit N N Y Profit for the sell price
Sell TerritoryEarnings N N Y Earnings for the sell price - territory take
Specification Registration Y Y N Is this project a specification to be registered with the manufacturer's for split agency credit?
Specification Status Y Y N Specification status
Specified Project Y Y N Were items represented by this company specified on the project
Specified Project Percentage N N Y Percentage of total parts on quote that were specified on the job
Specifier Assigned To Y Y N Assigned person to the specifier(s) of the job
Specifier Role Y Y N Specifier role list not including direct and indirect customer
Specifier Role(All) Y Y N Specifier role list including direct and indirect customer
Specifier_Agency Y Y N Agency list
Specifier_Architect Y Y N Architect list
Specifier_Contractor Y Y N Contractor list
Specifier_Designer Y Y N Designer list
Specifier_Distributor Y Y N Distributor list
Specifier_End Customer Y Y N End Customer list
Specifier_Engineer Y Y N Engineer list
Specifier_Lightfair 07 Y Y N Lightfair 07 list
Specifier_Manufacturer Y Y N Manufacturer list
Specifier_Owner Y Y N Owner list
Specifier_Pros-DIST Y Y N Pros-DIST list
Specifier_Pros-MFR Y Y N Pros-MFR list
Specifier_Pros-SA Y Y N Pros-SA list
Specifier_Pros-UKT Y Y N Pros-UKT list
Specifier_UKT Y Y N UKT list
Specifier_Vendor Y Y N Vendor list
Specifiers Y Y N Specifier list not including direct and indirect customer
Specifiers With Assigned To Y Y N Specifier list (including contact name) not including direct and indirect customer
Specifiers(All) Y Y N Specifier list including direct and indirect customer
Specifiers(All) With Assigned To Y Y N Specifier list (including contact name) including direct and indirect customer
Start Date N Y N Date user estimates the job will begin
Status Y Y N Quote status
Update Date N Y N Last date the project was updated
Update User Y Y N Last user to update the project
Valuation N N Y User estimated value of the job
Vendor Invoiced N N Y Amount invoiced of vendor orders
Vertical Market Y Y N User set field denoting the vertical market of the quote to the company
Winning Customer Y Y N Customer who is purchasing the job
Winning Customer ID Y Y N Customer who is purchasing the job - ID
Winning Indirect Customer Y Y N Winning Indirect Customer on the job
Workgroup Y Y N Workgroup the transaction is assigned to 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.