PROJECT OBJECT (JSON)

Field Path Path DataType Allows Null Is Optional Description

ProjectId

/ProjectId

UID

N

N

The unique id that identifies a single project

ProjectName

/ProjectName

string

Y

N

The name of the project

Code

/Code

string

Y

N

The project's Code field (Note: This field has a max length of 8 characters to support legacy standards)

CreateDate

/CreateDate

datetime

N

N

The date in which the project was created (Or the date the user says the project was created)

ModifiedDate

/ModifiedDate

datetime

N

N

The date in which the project was last modified

BidDate

/BidDate

datetime

Y

N

The Bid Date for the project

GoodUntilDate

/GoodUntilDate

datetime

Y

N

The GoodUntil Date for the project

JobRef

/JobRef

string

Y

N

The project's Job Reference number

ProjectAddressId

/ProjectAddressId

UID

N

N

The AddressId that corresponds to the Project's Jobsite address (Look up in the AddressRepository)

FreightSellOverride

/FreightSellOverride

decimal

Y

N

If not null, then the value in this field overrides the calculated Freight Sell from the items in the project

InstallationSellOverride

/InstallationSellOverride

decimal

Y

N

If not null, then the value in this field overrides the calculated Installation Sell from the items in the project

FreightTaxable

/FreightTaxable

boolean

N

N

Determines if Freight is taxable on the project (Note: Only items which are taxable apply)

InstallationTaxable

/InstallationTaxable

boolean

N

N

Determines if Installation is taxable on the project (Note: Only items which are taxable apply)

LockSell

/LockSell

boolean

N

N

Determines if the project's Sell is locked (which usualy indicates that the project's bid has been accepted, so the sell price should not change)

SalesTaxPercent

/SalesTaxPercent

decimal

N

N

The Sales Tax Precentage for the project

SalesTaxOverride

/SalesTaxOverride

decimal

Y

N

If not null, then the value in this field overrides the calculated Sales Tax total for the project

MarketingCategory

/MarketingCategory

decimal

Y

N

The project's Marketing Category

ReadOnly

/ReadOnly

boolean

N

N

Determines if the project is set to ReadOnly (Only the owner and admins can make edits)

PasswordProtected

/PasswordProtected

boolean

N

N

Determines if the project has a password set (The password is needed to open the project)

CustomFilter

/CustomFilter

string

Y

N

A value defined by the User to tag a project with special search criteria

Memo

/Memo

string

Y

N

A project's Memo text (This information does not appear on any reports. So it is often used for Project Management or other such text which a customer should not see)

CustomColumn1Name

/CustomColumn1Name

string

Y

Y

This is the name given to the first custom column (Values found in the SubLineItems)

CustomColumn2Name

/CustomColumn2Name

string

Y

Y

This is the name given to the second custom column (Values found in the SubLineItems)

CustomColumn3Name

/CustomColumn3Name

string

Y

Y

This is the name given to the third custom column (Values found in the SubLineItems)

CustomColumn4Name

/CustomColumn4Name

string

Y

Y

This is the name given to the fourth custom column (Values found in the SubLineItems)

CustomColumn5Name

/CustomColumn5Name

string

Y

Y

This is the name given to the fifth custom column (Values found in the SubLineItems)

CustomColumn6Name

/CustomColumn6Name

string

Y

Y

This is the name given to the sixth custom column (Values found in the SubLineItems)

PriceLevel

/PriceLevel

string

Y

Y

The field used for Custom Pricing based on a specified Pricing Level

Warehouse

/Warehouse

string

Y

Y

The field used for Custom Pricing based on warehouse location

MergedProject

/MergedProject

boolean

N

Y

Indicates if project was created as a result of a Multi-Project Merge

SodexoTaxID

/SodexoTaxID

string

Y

Y

Sodexo Only Field

SodexoAENo

/SodexoAENo

string

Y

Y

Sodexo Only Field

SodexoInvoiceNo

/SodexoInvoiceNo

string

Y

Y

Sodexo Only Field

SodexoBillingOption

/SodexoBillingOption

string

Y

Y

Sodexo Only Field

SodexoPIGroup

/SodexoPIGroup

string

Y

Y

Sodexo Only Field

SodexoClientPONo

/SodexoClientPONo

string

Y

Y

Sodexo Only Field

Contacts

/Contacts

array

N

N

An array containing the project's Contacts

Customers

/Customers

array

N

N

An array containing the project's Customers

Vendors

/Vendors

array

N

N

An array containing the vendor information for the items in the project

PurchaseOrders

/PurchaseOrders

array

N

N

An array containing the purchase order information for the items in the project

FreightData

/FreightData

array

N

N

An array containing the freight data for the items in the project

LineItems

/LineItems

array

N

N

An array containing the items in the project

AddressRepository

/AddressRepository

array

N

N

An array containing all of the addresses referenced in the project

Totals

/Totals

array

N

N

An array containing the totals for the project

ContactType

/Contacts[]/ContactType

string

N

N

The description of the Contact

ContactAddressId

/Contacts[]/ContactAddressId

UID

N

N

The AddressId that corresponds to the Contact's address (Look up in the AddressRepository)

ExportId

/Contacts[]/ExportId

string

Y

N

Special Id assigned by the user for the Contact

CustomerId

/Customers[]/CustomerId

UID

N

N

The unique id that identifies a single customer (In the project)

CustomerAddressId

/Customers[]/CustomerAddressId

UID

N

N

The AddressId that corresponds to the Customer's address (Look up in the AddressRepository)

CustomerSpecificSalesTax

/Customers[]/CustomerSpecificSalesTax

decimal

Y

N

Sales Tax Precentage used by this Customer (Used for Customer Specific Pricing)

CustomerSpecificMarkup

/Customers[]/CustomerSpecificMarkup

decimal

Y

N

Default Markup used by this Customer (Used for Customer Specific Pricing)

ExportId

/Customers[]/ExportId

string

Y

N

Special Id assigned by the user for the Customer

VendorId

/Vendors[]/VendorId

UID

N

N

The unique id that indentifies a single vendor (In the project)

Name

/Vendors[]/Name

string

Y

N

The name of the Vendor

ShortName

/Vendors[]/ShortName

string

Y

N

The short name of the Vendor (Most often used for display in the program)

CatalogVendorId

/Vendors[]/CatalogVendorId

UID

Y

N

The unique id that identifies a distinct Vendor in the Catalog

VendorAddressId

/Vendors[]/VendorAddressId

UID

N

N

The AddressId that corresponds to the Vendor's main address (Look up in the AddressRepository)

RepAddressId

/Vendors[]/RepAddressId

UID

Y

N

The AddressId that corresponds to the Vendor's Rep's address (Look up in the AddressRepository)

AgentAddressId

/Vendors[]/AgentAddressId

UID

Y

N

The AddressId that corresponds to the Vendor's Service Agent's address (Look up in the AddressRepository)

PrimeSpec

/Vendors[]/PrimeSpec

string

Y

N

The Vendor's PrimeSpec

Terms

/Vendors[]/Terms

string

Y

N

The Vendor's Terms

GoodUntilDate

/Vendors[]/GoodUntilDate

datetime

Y

N

The Vendor's Good Util Date

FreeFreight

/Vendors[]/FreeFreight

boolean

N

N

Determines if the Vendor pays the freight costs

POEmail

/Vendors[]/POEmail

string

Y

N

The email address where POs should be sent

ExportId

/Vendors[]/ExportId

string

Y

N

Special Id assigned by the user for the Vendor

PurchaseOrderId

/PurchaseOrder[]/PurchaseOrderId

UID

N

N

The unique id that indentifies a single Purchase Order (In the project)

VendorId

/PurchaseOrder[]/VendorId

UID

N

N

The VendorId that corresponds to the Purchase Order's Vendor (Look up in Vendors)

PONumber

/PurchaseOrder[]/PONumber

string

Y

N

The PO Number

MailToAddressId

/PurchaseOrder[]/MailToAddressId

UID

Y

N

The AddressId that corresponds to the Purchase Order's Mail To Address (Look up in the AddressRepository)

ShipToAddressId

/PurchaseOrder[]/ShipToAddressId

UID

Y

N

The AddressId that corresponds to the Purchase Order's Ship To Address (Look up in the AddressRepository)

BillToAddressId

/PurchaseOrder[]/BillToAddressId

UID

Y

N

The AddressId that corresponds to the Purchase Order's Bill To Address (Look up in the AddressRepository)

BuyerAddressId

/PurchaseOrder[]/BuyerAddressId

UID

Y

N

The AddressId that corresponds to the Purchase Order's Buyer Address (Look up in the AddressRepository)

CreateDate

/PurchaseOrder[]/CreateDate

datetime

Y

N

The date the Purchase Order was created

EditDate

/PurchaseOrder[]/EditDate

datetime

Y

N

The date the Purchase Order was last edited

FreightBilling

/PurchaseOrder[]/FreightBilling

string

Y

N

The Purchase Order's Freight Billing

PreferredCarrier

/PurchaseOrder[]/PreferredCarrier

string

Y

N

The Purchase Order's Preffered Carrier

ShippingInstructions

/PurchaseOrder[]/ShippingInstructions

string

Y

N

The Purchase Order's Shipping Instructions

Terms

/PurchaseOrder[]/Terms

string

Y

N

The Purchase Order's Terms

Status

/PurchaseOrder[]/Status

string

Y

N

The Purchase Order's Status

Instructions

/PurchaseOrder[]/Instructions

string

Y

N

The Purchase Order's Instructions

Notes

/PurchaseOrder[]/Notes

string

Y

N

The Purchase Order's Notes

FOBPoint

/PurchaseOrder[]/FOBPoint

string

Y

N

The Purchase Order's FOB Point

RequiredDate

/PurchaseOrder[]/RequiredDate

datetime

Y

N

The date that the Purchase Order's delivery is required

ShipDate

/PurchaseOrder[]/ShipDate

datetime

Y

N

The date that the Purchase Order is shipped

ReceivedDate

/PurchaseOrder[]/ReceivedDate

datetime

Y

N

The date that the Purchase Order's delivery was received

POSentDate

/PurchaseOrder[]/POSentDate

datetime

Y

N

The date that the Purchase Order's was sent to the Vendor

FreightDataId

/FreightData[]/FreightDataId

UID

N

N

The unique id that indentifies a single price of Freight Data (In the project)

EstimatorCode

/FreightData[]/EstimatorCode

int

N

N

The code that describes which Estimator was used to estimate Freight

EstimatorDescription

/FreightData[]/EstimatorDescription

string

Y

N

The description of EstimatorCode

ConfirmationNumber

/FreightData[]/ConfirmationNumber

string

Y

N

The confirmation number provided by the Estimator

AccessorialsCode

/FreightData[]/AccessorialsCode

int

N

N

The code that describes which Accessorial Charges are applied to the Freight

AccessorialsDescription

/FreightData[]/AccessorialsDescription

string

Y

N

The description of AccessorialsCode

ItemNumber

/LineItems[]/ItemNumber

string

Y

N

The LineItem's Item Number

Category

/LineItems[]/Category

string

Y

N

The LineItem's Category

MergedProjectName

/LineItems[]/MergedProjectName

string

Y

Y

The name of the project this item came from (Only used on Merged Projects)

MergedProjectMarketingCategory

/LineItems[]/MergedProjectMarketingCategory

string

Y

Y

The marketing category of the project this item came from (Only used on Merged Projects)

MergedProjectCustomFilter

/LineItems[]/MergedProjectCustomFilter

string

Y

Y

The custom filter of the project this item came from (Only used on Merged Projects)

MergedProjectJobRefNumber

/LineItems[]/MergedProjectJobRefNumber

string

Y

Y

The job reference number of the project this item came from (Only used on Merged Projects)

MergedProjectCode

/LineItems[]/MergedProjectCode

string

Y

Y

The project code of the project this item came from (Only used on Merged Projects)

MergedProjectCustomers

/LineItems[]/MergedProjectCustomers

string

Y

Y

The customers of the project this item came from (Only used on Merged Projects)

SubLineItems

/LineItems[]/SubLineItems

array

N

N

An array containing the SubLineItems for the LineItem

ItemTypeCode

/LineItems[]/SubLineItems[]/ItemTypeCode

int

N

N

The code that describes what type of item the SubLineItem is

ItemTypeDescription

/LineItems[]/SubLineItems[]/ItemTypeDescription

string

Y

N

The description of ItemTypeCode

VendorId

/LineItems[]/SubLineItems[]/VendorId

UID

Y

N

The VendorId that corresponds to the SubLineItem's Vendor (Look up in Vendors)

PurchaseOrderId

/LineItems[]/SubLineItems[]/PurchaseOrderId

UID

Y

N

The PurchaseOrderId that corresponds to the SubLineItem's Purchase Order (Look up in PurchaseOrders)

FreightDataId

/LineItems[]/SubLineItems[]/FreightDataId

UID

Y

N

The FreightDataId that corresponds to the SubLineItem's Freight Data (Look up in FreightData)

Quantity

/LineItems[]/SubLineItems[]/Quantity

int

N

N

The SubLineItem's Quantity

Model

/LineItems[]/SubLineItems[]/Model

string

Y

N

The SubLineItem's Model

StockModel

/LineItems[]/SubLineItems[]/StockModel

string

Y

N

The SubLineItem's Stock Model

AltStockModel

/LineItems[]/SubLineItems[]/AltStockModel

string

Y

N

The SubLineItem's Alternate Stock Model

AltModel

/LineItems[]/SubLineItems[]/AltModel

string

Y

N

The SubLineItem's Alternate Model

CatalogProdId

/LineItems[]/SubLineItems[]/CatalogProdId

UID

Y

N

The unique id that identifies a distinct product in the Catalog

CustomItem

/LineItems[]/SubLineItems[]/CustomItem

boolean

N

N

Indicates if the SubLineItem was created as a Custom Item

FromConfiguration

/LineItems[]/SubLineItems[]/FromConfiguration

boolean

N

N

Indicates if the SubLineItem was added using the configuration

StockItem

/LineItems[]/SubLineItems[]/StockItem

boolean

N

N

Indicates if the SubLineItem is a Stock Item

Spec

/LineItems[]/SubLineItems[]/Spec

string

Y

N

The SubLineItem's Spec

Notes

/LineItems[]/SubLineItems[]/Notes

string

Y

N

The SubLineItem's Notes

StatusCode

/LineItems[]/SubLineItems[]/StatusCode

int

N

N

The SubLineItem's Status

StatusDescription

/LineItems[]/SubLineItems[]/StatusDescription

string

Y

N

The description of StatusCode

SellingUnit

/LineItems[]/SubLineItems[]/SellingUnit

string

Y

N

The SubLineItem's SellingUnit

UnitsPerCase

/LineItems[]/SubLineItems[]/UnitsPerCase

int

N

N

The SubLineItem's number of units per case

SpecialCode

/LineItems[]/SubLineItems[]/SpecialCode

int

N

N

The Special considerations for the SubLineItem (Note: These values can affect Net and Sell prices)

SpecialDescription

/LineItems[]/SubLineItems[]/SpecialDescription

string

Y

N

The description for SpecialCode

CallForPricing

/LineItems[]/SubLineItems[]/CallForPricing

boolean

N

N

Indicates if the User needs to contact the Manufacturer for pricing on the item

SellPrice

/LineItems[]/SubLineItems[]/SellPrice

decimal

N

N

The SubLineItem's merchandise sell price

FreightSell

/LineItems[]/SubLineItems[]/FreightSell

decimal

N

N

The SubLineItem's freight sell price

InstallationSell

/LineItems[]/SubLineItems[]/InstallationSell

decimal

N

N

The SubLineItem's installation sell price

NetPrice

/LineItems[]/SubLineItems[]/NetPrice

decimal

N

N

The SubLineItem's merchandise net price

FreightNet

/LineItems[]/SubLineItems[]/FreightNet

decimal

N

N

The SubLineItem's freight net price

InstallationNet

/LineItems[]/SubLineItems[]/InstallationNet

decimal

N

N

The SubLineItem's installation net price

Discount

/LineItems[]/SubLineItems[]/Discount

string

Y

N

The SubLineItem's merchandise discount (Compound)

ListPrice

/LineItems[]/SubLineItems[]/ListPrice

decimal

N

N

The SubLineItem's merchandise list price

IsNetPricedItem

/LineItems[]/SubLineItems[]/IsNetPricedItem

boolean

N

N

Indicates if the SubLineItem is net priced

Taxable

/LineItems[]/SubLineItems[]/Taxable

boolean

N

N

Indicates if the SubLineItem is taxable

Rebate

/LineItems[]/SubLineItems[]/Rebate

decimal

N

N

The SubLineItem's Rebate

CashDiscount

/LineItems[]/SubLineItems[]/CashDiscount

decimal

N

N

The SubLineItem's Cash Discount

FreightClass

/LineItems[]/SubLineItems[]/FreightClass

string

Y

N

The SubLineItem's Freight Class

Weight

/LineItems[]/SubLineItems[]/Weight

decimal

N

N

The SubLineItem's Weight

Cube

/LineItems[]/SubLineItems[]/Cube

decimal

N

N

The SubLineItem's Cube

Width

/LineItems[]/SubLineItems[]/Width

decimal

N

N

The SubLineItem's Width

Depth

/LineItems[]/SubLineItems[]/Depth

decimal

N

N

The SubLineItem's Depth

Height

/LineItems[]/SubLineItems[]/Height

decimal

N

N

The SubLineItem's Height

SerialNbr

/LineItems[]/SubLineItems[]/SerialNbr

string

Y

N

The SubLineItem's Serial Number

GTIN

/LineItems[]/SubLineItems[]/GTIN

string

Y

N

The SubLineItem's GTIN

ShipFromAddressId

/LineItems[]/SubLineItems[]/ShipFromAddressId

UID

Y

N

The AddressId that corresponds to the SubLineItem's ShipFrom Address

SpecRemarks

/LineItems[]/SubLineItems[]/SpecRemarks

string

Y

N

The SubLineItem's SpecRemarks

Prime

/LineItems[]/SubLineItems[]/Prime

string

Y

N

The SubLineItem's Prime (MAFSI field)

Equal1

/LineItems[]/SubLineItems[]/Equal1

string

Y

N

The SubLineItem's Equal1 (MAFSI field)

Equal2

/LineItems[]/SubLineItems[]/Equal2

string

Y

N

The SubLineItem's Equal2 (MAFSI field)

Alt

/LineItems[]/SubLineItems[]/Alt

string

Y

N

The SubLineItem's Alt (MAFSI field)

CustomColumn1

/LineItems[]/SubLineItems[]/CustomColumn1

string

Y

Y

The SubLineItem's value for CustomColumn1 (Note: See CustomColumn1Name in the project to give this value context)

CustomColumn2

/LineItems[]/SubLineItems[]/CustomColumn2

string

Y

Y

The SubLineItem's value for CustomColumn2 (Note: See CustomColumn2Name in the project to give this value context)

CustomColumn3

/LineItems[]/SubLineItems[]/CustomColumn3

string

Y

Y

The SubLineItem's value for CustomColumn3 (Note: See CustomColumn3Name in the project to give this value context)

CustomColumn4

/LineItems[]/SubLineItems[]/CustomColumn4

string

Y

Y

The SubLineItem's value for CustomColumn4 (Note: See CustomColumn4Name in the project to give this value context)

CustomColumn5

/LineItems[]/SubLineItems[]/CustomColumn5

string

Y

Y

The SubLineItem's value for CustomColumn5 (Note: See CustomColumn5Name in the project to give this value context)

CustomColumn6

/LineItems[]/SubLineItems[]/CustomColumn6

string

Y

Y

The SubLineItem's value for CustomColumn6 (Note: See CustomColumn6Name in the project to give this value context)

AccessoryCategory

/LineItems[]/SubLineItems[]/AccessoryCategory

string

Y

Y

The SubLineItem's Category (This only applies to Accessories)

QuantityOverride

/LineItems[]/SubLineItems[]/QuantityOverride

string

Y

Y

The value to display instead of Quantity for this SubLineItem (for instance, if you don’t know the exact amount, custom text could be used instead)

SurchargeAccessoryPercent

/LineItems[]/SubLineItems[]/SurchargeAccessoryPercent

decimal

Y

Y

If not null (and present), this indicates that the item is a Surcharge Accessory, the value is the percentage that should be used to calcualte the pricing for this item

CustomerSpecificPricings

/LineItems[]/SubLineItems[]/CustomerSpecificPricings

array

N

N

An array containing the pricing values that should be used when dealing with Customer Specific Pricing

ElectricalUtilityGrids

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids

array

N

N

An array containing the Electrical Utility information for the SubLineItem

PlumbingUtilityGrids

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids

array

N

N

An array containing the Plumbing Utility information for the SubLineItem

GasSteamUtilityGrids

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids

array

N

N

An array containing the Gas/Steam Utility information for the SubLineItem

HvacUtilityGrids

/LineItems[]/SubLineItems[]/HvacUtilityGrids

array

N

N

An array containing the HVAC Utility information for the SubLineItem

CustomerId

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/CustomerId

UID

N

N

The CustomerId that identifies which Customer these pricing fields apply to

CallForPricing

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/CallForPricing

boolean

N

N

Indicates if the User needs to contact the Manufacturer for item pricing for the Customer

SellPrice

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/SellPrice

decimal

N

N

The merchandise sell price for the Customer

NetPrice

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/NetPrice

decimal

N

N

The merchandise net price for the Customer

Discount

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/Discount

decimal

N

N

The merchandise discount (Compound) for the Customer

ListPrice

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/ListPrice

decimal

N

N

The merchandise list price for the Customer

IsNetPricedItem

/LineItems[]/SubLineItems[]/CustomerSpecificPricings[]/IsNetPricedItem

boolean

N

N

Indicates if the item is net priced for the Customer

Amps

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/Amps

string

Y

N

The ElectricalUtilityGrid's Amps

KW

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/KW

string

Y

N

The ElectricalUtilityGrid's KW

HP

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/HP

string

Y

N

The ElectricalUtilityGrid's HP

MCA

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/MCA

string

Y

N

The ElectricalUtilityGrid's MCA

MOCP

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/MOCP

string

Y

N

The ElectricalUtilityGrid's MOCP

Voltage

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/Voltage

string

Y

N

The ElectricalUtilityGrid's Voltage

Cycle

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/Cycle

string

Y

N

The ElectricalUtilityGrid's Cycle

NEMA

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/NEMA

string

Y

N

The ElectricalUtilityGrid's NEMA

Remarks

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/Remarks

string

Y

N

The ElectricalUtilityGrid's Remarks

Phase

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/Phase

string

Y

N

The ElectricalUtilityGrid's Phase

ConnectionType

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/ConnectionType

string

Y

N

The ElectricalUtilityGrid's Connection Type

ConnectionHeight

/LineItems[]/SubLineItems[]/ElectricalUtilityGrids[]/ConnectionHeight

string

Y

N

The ElectricalUtilityGrid's Connection Height

HotWaterSize

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/HotWaterSize

string

Y

N

The PlumbingUtilityGrid's Hot Water Size

HotWaterGPH

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/HotWaterGPH

string

Y

N

The PlumbingUtilityGrid's Hot Water GPH

ColdWaterSize

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/ColdWaterSize

string

Y

N

The PlumbingUtilityGrid's Cold Water Size

Remarks

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/Remarks

string

Y

N

The PlumbingUtilityGrid's Remarks

CondenserWaterInlet

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/CondenserWaterInlet

string

Y

N

The PlumbingUtilityGrid's Condenser Water Inlet

CondenserWaterOutlet

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/CondenserWaterOutlet

string

Y

N

The PlumbingUtilityGrid's Condenser Water Outlet

FilteredWaterSize

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/FilteredWaterSize

string

Y

N

The PlumbingUtilityGrid's Filtered Water Size

DirectWasteSize

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/DirectWasteSize

string

Y

N

The PlumbingUtilityGrid's Direct Waste Size

WaterRemarks

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/WaterRemarks

string

Y

N

The PlumbingUtilityGrid's Water Remarks

WasteRemarks

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/WasteRemarks

string

Y

N

The PlumbingUtilityGrid's Waste Remarks

HotWaterConnectionHeight

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/HotWaterConnectionHeight

string

Y

N

The PlumbingUtilityGrid's Hot Water Connection Height

ColdWaterConnectionHeight

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/ColdWaterConnectionHeight

string

Y

N

The PlumbingUtilityGrid's Cold Water Connection Height

FilteredWaterConnectionHeight

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/FilteredWaterConnectionHeight

string

Y

N

The PlumbingUtilityGrid's Filtered Water Connection Height

DirectWasteConnectionHeight

/LineItems[]/SubLineItems[]/PlumbingUtilityGrids[]/DirectWasteConnectionHeight

string

Y

N

The PlumbingUtilityGrid's Direct Waste Connection Height

GasSize

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasSize

string

Y

N

The GasSteamUtilityGrid's Gas Size

SteamInletSize

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamInletSize

string

Y

N

The GasSteamUtilityGrid's Steam Inlet Size

SteamInletLBPerHr

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamInletLBPerHr

string

Y

N

The GasSteamUtilityGrid's Steam Inlet Lb Per Hour

SteamReturnSize

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamReturnSize

string

Y

N

The GasSteamUtilityGrid's Steam Return Size

GasMBTU

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasMBTU

string

Y

N

The GasSteamUtilityGrid's Gas MBTU

GasKW

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasKW

string

Y

N

The GasSteamUtilityGrid's Gas KW

GasRemarks

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasRemarks

string

Y

N

The GasSteamUtilityGrid's Gas Remarks

SteamRemarks

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamRemarks

string

Y

N

The GasSteamUtilityGrid's Steam Remarks

SteamPSIGMin

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamPSIGMin

string

Y

N

The GasSteamUtilityGrid's Steam PSIG Min

SteamPSIGMax

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamPSIGMax

string

Y

N

The GasSteamUtilityGrid's Steam PSIG Max

GasConnectionHeight

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasConnectionHeight

string

Y

N

The GasSteamUtilityGrid's Gas Connection Height

SteamConnectionHeight

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/SteamConnectionHeight

string

Y

N

The GasSteamUtilityGrid's Steam Connection Height

GasType

/LineItems[]/SubLineItems[]/GasSteamUtilityGrids[]/GasType

string

Y

N

The GasSteamUtilityGrid's Gas Type

ExhaustCFM

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/ExhaustCFM

string

Y

N

The HvacUtilityGrid's Exhaust CFM

ExhaustSPWG

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/ExhaustSPWG

string

Y

N

The HvacUtilityGrid's Exhaust SPWG

MakeupCFM

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/MakeupCFM

string

Y

N

The HvacUtilityGrid's Makeup CFM

MakeupSPWG

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/MakeupSPWG

string

Y

N

The HvacUtilityGrid's Makeup SPWG

Remarks

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/Remarks

string

Y

N

The HvacUtilityGrid's Remarks

ExhaustVentWidth

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/ExhaustVentWidth

string

Y

N

The HvacUtilityGrid's Exhaust Vent Width

ExhaustVentDepth

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/ExhaustVentDepth

string

Y

N

The HvacUtilityGrid's Exhaust Vent Depth

ExhaustVentDiameter

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/ExhaustVentDiameter

string

Y

N

The HvacUtilityGrid's Exhaust Vent Diameter

MakeupVentWidth

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/MakeupVentWidth

string

Y

N

The HvacUtilityGrid's Makeup Vent Width

MakeupVentDepth

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/MakeupVentDepth

string

Y

N

The HvacUtilityGrid's Makeup Vent Depth

MakeupVentDiameter

/LineItems[]/SubLineItems[]/HvacUtilityGrids[]/MakeupVentDiameter

string

Y

N

The HvacUtilityGrid's Makeup Vent Diameter

AddressId

/AddressRepository[]/AddressId

UID

N

N

The unique id that indentifies a single Address (In the project)

Name

/AddressRepository[]/Name

string

Y

N

The company name

FirstName

/AddressRepository[]/FirstName

string

Y

N

The first name

LastName

/AddressRepository[]/LastName

string

Y

N

The last name

MiddleName

/AddressRepository[]/MiddleName

string

Y

N

The middle name

Title

/AddressRepository[]/Title

string

Y

N

The title

Prefix

/AddressRepository[]/Prefix

string

Y

N

The prefix

Suffix

/AddressRepository[]/Suffix

string

Y

N

The suffix

Address1

/AddressRepository[]/Address1

string

Y

N

The first address line

Address2

/AddressRepository[]/Address2

string

Y

N

The second address line

City

/AddressRepository[]/City

string

Y

N

The city

State

/AddressRepository[]/State

string

Y

N

The state

Zip

/AddressRepository[]/Zip

string

Y

N

The zip (or Postal Code)

Country

/AddressRepository[]/Country

string

Y

N

The country

PhoneCompany

/AddressRepository[]/PhoneCompany

string

Y

N

The phone number for the company

PhoneTollFree

/AddressRepository[]/PhoneTollFree

string

Y

N

The toll free phone number for the company

PhoneContact

/AddressRepository[]/PhoneContact

string

Y

N

The phone number for the person

PhoneCell

/AddressRepository[]/PhoneCell

string

Y

N

The cell phone number for the person

PhoneFax

/AddressRepository[]/PhoneFax

string

Y

N

The fax phone number for the company/person

PhoneCompanyExt

/AddressRepository[]/PhoneCompanyExt

string

Y

N

The extension for the company's phone number

PhoneContactExt

/AddressRepository[]/PhoneContactExt

string

Y

N

The extension for the person's phone number

Website

/AddressRepository[]/Website

string

Y

N

The company's website url

Email

/AddressRepository[]/Email

string

Y

N

The person's email

CustomerId

/Totals[]/CustomerId

UID

Y

N

The CustomerId for the Customer that these totals apply to. If this field is null, then the totals apply to all customers that don't have a Total assigned to it

MerchandiseSell

/Totals[]/MerchandiseSell

decimal

N

N

The calculated Merchandise Sell Total

MerchandiseMarkup

/Totals[]/MerchandiseMarkup

decimal

N

N

The calculated Merchandise Markup Total

MerchandiseNet

/Totals[]/MerchandiseNet

decimal

N

N

The calculated Merchandise Net Total

FreightSell

/Totals[]/FreightSell

decimal

N

N

The calculated Freight Sell Total

FreightMarkup

/Totals[]/FreightMarkup

decimal

Y

N

The calculated Freight Markup Total. If this field is null, then the Freight Sell is assigned from the Project's FreightSellOverride field

FreightNet

/Totals[]/FreightNet

decimal

N

N

The calculated Freight Net Total

InstallationSell

/Totals[]/InstallationSell

decimal

N

N

The calculated Installation Sell Total

InstallationMarkup

/Totals[]/InstallationMarkup

decimal

Y

N

The calculated Installation Markup Total. If this field is null, then the Installation Sell is assigned from the Project's InstallationSellOverride field

InstallationNet

/Totals[]/InstallationNet

decimal

N

N

The calculated Installation Net Total

GrossProfitPercent

/Totals[]/GrossProfitPercent

decimal

N

N

The calculated Gross Profit Percentage

GrossProfitAmount

/Totals[]/GrossProfitAmount

decimal

N

N

The calculated Gross Profit Amount

SalesTaxTotal

/Totals[]/SalesTaxTotal

decimal

N

N

The calculated Sales Tax Total

SalesTaxPercentage

/Totals[]/SalesTaxPercentage

decimal

N

N

The Sales Tax Percentage used to calculate the SalesTax. If this field is null, then the SalesTaxTotal is assigned from the Project's SalesTaxOverride field

GrandSellTotal

/Totals[]/GrandSellTotal

decimal

N

N

The calculated Project Grand Sell Total

AdditionalTotals

/Totals[]/AdditionalTotals

array

N

N

An array of additional totals that apply to the Project

FieldName

/Totals[]/AdditionalTotals[]/FieldName

string

Y

N

The name of the Additional Total

Sell

/Totals[]/AdditionalTotals[]/Sell

decimal

Y

N

The Sell Price of the Additional Total. If this field is null, then the Sell is not used for this Additional Total

Markup

/Totals[]/AdditionalTotals[]/Markup

decimal

Y

N

The Markup of the Additional Total. If this field is null, then the Markup is not used for this Additional Total

Net

/Totals[]/AdditionalTotals[]/Net

decimal

Y

N

The Net Price of the Additional Total. If this field is null, then the Net is not used for this Additional Total

IsTaxable

/Totals[]/AdditionalTotals[]/IsTaxable

boolean

N

N

Indicates if the Additional Total is taxable

AppliesToCode

/Totals[]/AdditionalTotals[]/AppliesToCode

int

N

N

The code that defines which SubTotals are used to calculate the Sell Price for the additional total when the Net is null and Markup is not

AppliesToDescription

/Totals[]/AdditionalTotals[]/AppliesToDescription

string

Y

N

The description of AppliesToCode







Generic Export
MASTER - Mprjcode - short identifier for Projectcreateddate - legacy Project creation dateprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number fromprojectprjfax - company fax numbertotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight taxsalesperson - First and Last name of Project Salespersonconsultant - Name and Company Name of Project Consultantbiddate - formatted legacy Project bid dateeditdate - formatted legacy date when Project was last edited
DETAIL - Dlinenbr- item number, provides index for line items (0, 1, 2, etc)sublinenbr - provides index for subline items (00, 10, 20, etc)vendornbr - AQ vendor numbervendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tablemodel - subline item model numberhidemodel - "*" if subline item model is hidden, empty if notaltmodel - alt model only applicable to V6baseoracc - "B" for base subline item, "O" for acc subline itemXXXX - ?taxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkup - project freight markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)weight - Weight (of a single item)frtclass - Freight Classcube - Case cube (single item)normaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - spec
CLIENT - Cusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Number800 - Company (800) Phone Numberfax - Company fax number
FL EXPORT
MASTER - Mprjcode - short identifier for Projecteditdate4year - edit date displayed as 4 digit yearprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number form projectprjfax - company fax numberowner - owner was used in AQnet6, but is no longer neededtotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight tax
DETAIL - Dlinenbr- item number, provides index for line items sublinenbr2char - 2 character sub line index if index is 0-99; else returns "##"vendornbrflr- AQ vendor number if there is one, if not returns "0" vendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username from Vendor tablemodel - subline item model numberhidemodel - "*" if model is hidden or empty otherwisestockmodel - stock model numberbaseoracc - "B" for base subline item, "O" for acc subline itemtaxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitymarkupflr - 4 digit decimal to denote sub line item markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemweight - Weight (of a single item)frtclass - Freight Classcubeflr - Case cube (single item) displayed in 3 digitscategory - Category (only on the BaseItem)spec - specventostock - sub line item vendor to stockvendorpack - Packed By. if selling unit is not “case” or “cs” then is in the format <VenToStock><space><SellingUnit> lineindex - line item index
CLIENT - Cusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Number800 - Company (800) Phone Numberfax - Company fax number

FLPO EXPORT

MASTER - Mprjcode - short identifier for Projecteditdate4year - edit date displayed as 4 digit yearprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number form projectprjfax - company fax numberowner - owner was used in AQnet6, but is no longer neededtotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight taxtaxgroup -clientno -jobno -
CLIENT - Cusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Number800 - Company (800) Phone Numberfax - Company fax number
VENDOR(PO) - Pvendornbrflr - uses AQ vendor number if available vendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tableterms - purchase order terms fieldfrtbilling - purchase order freight billingshipvia - denotes preferred shipping carriershipdate - ShipDate is actually repurposed to required date fobpoint - Freight On Board point. “Destination” and “Factory” are default values.shiptocompany - destination company nameshiptoaddress1 - destination address 1shiptoaddress2 - destination address 2shiptocity - destination cityshiptostate - destination stateshiptozip - destination zipbilltocompany - billed company namebilltoaddress1 - billing address1billtoaddress2 - billing address2billtocity - billing citybilltostate - billing statebilltozip - billing zipvendorname - vendor name from SQLAddress tablevendoraddress1 - vendor address 1vendoraddress2 - vendor address 2vendorcity - vendor cityvendorstate - vendor statevendorzip - vendor zipponumber - purchase order numberprintdate - date PO was printedinstructions - instructions for purchase order
DETAIL - Dlinenbr- provides index for line items sublinenbr2char - 2 character sub line index if index is 0-99; else returns "##"vendornbrflr- AQ vendor number if there is one, if not returns "0" vendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tablemodel - subline item model numberhidemodel - “*” is the item’s model is hidden, empty otherwisestockmodel - stock model numberbaseoracc - "B" for base subline item, "O" for acc subline itemtaxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkupflr - 4 digit decimal to denote sub line item markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemweight - Weight (of a single item)frtclass - Freight Classcubeflr - Case cube (single item) displayed in 3 digitsnormaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - spec
FL Export Both*
*Exports both the FLR and FLR(PO) exports
FACTS EXPORT
Master - Mprjcode - short identifier for Projecteditdate - date project was last editedprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate - state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number form projectprjfax - company fax numbertotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight tax
CLIENT - Cusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Number800 - Company (800) Phone Numberfax - Company fax number
DETAIL - Dlinenbr- provides index for line items sublinenbr - provides index for subline itemsvendornbr - AQ vendor numbervendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tablemodel - subline item model numberhidemodel - “*” is the item’s model is hidden, empty otherwisealtmodel - only applicable to V6baseoracc - "B" for base subline item, "O" for acc subline itemXXXX - ?taxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkup - project freight markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemweight - Weight (of a single item)frtclass - Freight Classcube - Case cube (single item)normaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - spec
FACTS2 EXPORT - Similar to Facts, except include comments/spares/etc.
Master - Mprjcode - short identifier for Projecteditdate - date project was last editedprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number form projectprjfax - company fax numbertotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight tax
CLIENT - Cusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Number800 - Company (800) Phone Numberfax - Company fax number
DETAIL - Dlinenbr- item number, provides index for line items sublinenbr - provides index for subline itemsvendornbr - AQ vendor numbervendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tablemodel - subline item model numberhidemodel - “*” if the item’s model is hidden, empty otherwisealtmodel - only applicable to V6baseoracc - "B" for base subline item, "O" for acc subline itemXXXX - ?taxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkup - project freight markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemweight - Weight (of a single item)frtclass - Freight Classcube - Case cube (single item)normaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - spec
FACTSDOS - Similar to FACTS FactsDOS is broken into two files: .PM and .PD
PDFilelinenbr- item number, provides index for line items sublinenbr2char - displays subline index number less than 100 (else, "##")model - subline item model numbervendornick - provides vendor short name or vendor display short namesellprice - Merchandise Sell Price (of a single item)listprice - subline item List Pricediscount - cash discount netprice - Merchandise Net Price (of a single item)qty - direct quantitymarkup - project freight markupsellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemtaxable - "Y" for taxable item, "N" for not taxableweight - Weight (of a single item)spec - spec#eof# - end of filestream
PMFileprjcode - short identifier for Projectprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate - state from projectprjzip - zip from projectbiddate - formatted legacy Project bid dateeditdate - date project was last editedtotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellinstall - sum of all Sub Line Items Sell Install PriceN - N markupfrt - "Y" if default freight > 0 "N" if not taxfrt - "Y" if freight is taxable > 0 "N" if not N - Nmarkupinstall - "Y" id default installation markup > 0, "N" if nottaxinstall - "Y" if installation is taxable > 0 "N" if notowner - owner was used in AQnet6, but is no longer needed#eof# - end of filestream

SODEXO (MARRIOT)
MASTER - Mprjcode - short identifier for Projectcreateddate - legacy Project creation dateprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from projectprj800 - company (800) phone number form projectprjfax - company fax numberowner - owner was used in AQnet6, but is no longer neededtotallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight taxtaxgroup - project tax groupclientno - client number fieldjobno - job number fieldsalesperson - First and Last name of Project Salesperson
PO Master - Pvendornumber -vendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tableterms - purchase order terms fieldfrtbilling - purchase order freight billingshipvia - denotes preferred shipping carriershipdate - ShipDate is actually repurposed to required date fobpoint - Freight On Board point. default values for this field are “Destination” and “Factory” shiptocontact - Name of destination contact shiptoaddress1 - destination address 1shiptoaddress2 - destination address 2shiptocity - destination cityshiptostate - destination stateshiptozip - destination zipbilltocontact - billing contact usernamebilltoaddress1 - billing address1billtoaddress2 - billing address2billtocity - billing citybilltostate - billing statebilltozip - billing zipvendorcontact - vendor username or blankvendoraddress1 - vendor address 1vendoraddress2 - vendor address 2vendorcity - vendor cityvendorstate - vendor statevendorzip - vendor zipponumber - purchase order numberpoprintdatesodexo - purchase order print date from either po print date field or todays dateinstructions - shipping instructions for purchase order

PO DETAIL - Dlinenbr- item number, provides index for line items sublinenbr - provides index for subline itemsvendornbr - AQ vendor numbervendornick - provides vendor short name or vendor display short namevendorname - vendor name from SQLAddress tablevendorusername - username form Vendor tablemodel - subline item model numberhidemodel - "*" if hidden, empty otherwisestockmodel -baseoracc - "B" for base subline item, "O" for acc subline itemXXXX - ?taxable - "Y" for taxable item, "N" for not taxablesellunit - subline item selling unit ("ea" is default)qty - direct quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkup - project freight markupnetprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation net price of a single itemweight4 - four digit subline item weightfrtclass - Freight Classcube - Case cube (single item)normaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - spec
SagePro (3 files: PC, PD, and PM)
1) PCprjcode - short identifier for Projectusername - UserNamecompany - Company nameaddress1 - Client Address 1address2 - Client Address 2city - Citystate - Statezip - Zipphone - Company Phone Numbercontactname - client first and last name
2) PD prjcode - short identifier for Projectsbtcustomerid - client username for each client in projectlinenbr- item number, provides index for line items sublinenbr - provides index for subline itemsbaseoraccsbt - "B" if base main subline item, "A" for accessoryvendorusername - username form Vendor tablevendorsbtprefix - vendor prefix, if availablesbtmodel - identifier comprised of vendor prefix and either model number and project code if model is empty ?sbtmodel2 - same as sbtmodel, but used to identify custom items ?sbtcategory - line item category if item is main subline item, spec if item is sublineitemweight4 - four digit subline item weighttaxrate - project sales taxqty1 - subline quantity, if specified ("1" by default)listprice - subline item List Pricediscount - cash discount netprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellfrt - Freight Sell Price (of a single item)netinstall - Installation net price of a single itemsellinstall - Installation Sell Price (of a single item)taxable - "Y" for taxable item, "N" for not taxablerebate - item rebatecashdiscount - item cash discountsbtspec - specsellunit - subline item selling unit ("ea" is default)vendorpack - Packed By. if selling unit is not “case” or “cs” then is in the format <VenToStock><space><SellingUnit> gridrownbr - simulates subline number (PD) from Legacy
3) PMprjcode - short identifier for Projectusername - UserNameprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from projectprjaddress2 - Address 2 from projectprjcity - city from projectprjstate -state from projectprjzip - zip from projectprjphone - company phone from project
TRX EXPORT
M - "Master" fieldsprjcode - short identifier for Projectcreateddate - formatted legacy Project creation dateprjcompany - Company Name (in the case of SQLProject’s SQLAddress, this is the Project’s Name)prjaddress1 - Address 1 from Projectprjaddress2 - Address 2 from Projectprjcity - City from Project prjstate - State from Project prjzip - Zip code from Projectprjphone - Company Phone from Projectprjstate - State from Projectprj800 - Company (800) phone numberprjfax - Company Fax number totallistmerch - sum of all Sub Line Items List Pricetotalnetmerch - sum of all Sub Line Items Net Pricetotalnetfrt - sum of all Sub Line Items Net Freight Pricetotalnetinstall - sum of all Sub Line Items Net Install Pricetotalsellmerch - sum of all Sub Line Items Sell Merchandise Pricetotalsellfrt - sum of all Sub Line Items Sell Freight Pricetotalsellinstall - sum of all Sub Line Items Sell Install Pricetotaltax - total tax for the Project including sales tax, install tax, and freight taxsalesperson - First and Last name of Project Salespersonconsultant - Name and Company Name of Project Consultantbiddate - formatted legacy Project bid dateeditdate - formatted legacy date when Project was last edited
D - "Detail" fieldslinenbr - The Number the user actually sees in the Spreadsheetsublinenbr - Provides Order For SubLineItems vendornbr - Vendor Number, if valid and > 0vendornick - SQLVendor.VendorNickName - Vendor Nickname if exists, otherwise VendorShortName, otherwise VendorNamevendorname - Vendor Name vendorusername - UserName (aka ExportId)model - Model Number hidemodel - indicates if the model should be hidden by "*"altmodel - Unusedbaseoracc - B if Base Item, O if AccessoryXXXX - Unusedtaxable - Taxable (Y or N)sellunit - Selling Unitqty - Quantitypriceswitch - O = ByOther, W = ByOwner, D = Deleted, E = Existing, T = Future, I = Included, L = Lease, N = NIC, C = NoCharge, S = SeeAbove, P = Spare, F = TBD, <Blank> = Nonemarkup - Markup (1.0 = 100%)netprice - Merchandise Net Price (of a single item)sellprice - Merchandise Sell Price (of a single item)sellfrt - Freight Sell Price (of a single item)netfrt - Freight Net Price (of a single item)sellinstall - Installation Sell Price (of a single item)netinstall - Installation Net Price (of a single item)weight - Weight (of a single item)frtclass - Freight Classcube - Case Cube (of a single item)normaloruser - U if UserItem, T is Not-UserItemcategory - Category (only on the BaseItem)spec - Spec voltage - Voltage (only the first non-empty value)phase - Phase (only the first non-empty value)listprice - Merchandise List Price (of a single item)cutsheet - Cutsheet Name vendorpack - Packed By. if selling unit is not “case” or “cs” then is in the format <VenToStock><space><SellingUnit> ventostock - Number of Packed Byspicture - Picture Name
C -"Client" fieldsusername - UserNamecompany - Company Nameaddress1 - Address 1address2 - Address 2city - City state - State zip - Zipphone - Company Phone Number800 - Company 800 Phone Numberfax – Company Fax Number