QBAR DATA DICTIONARY

For Quickbooks Advanced Reporting Consultants:

 

Table
Field Name
Description
AccountTime CreatedTimeCreated
AccountTime ModifiedTimeModified
AccountNameName
AccountFull NameFullName
AccountActiveIsActive
AccountParent List IDParentListID
AccountParent Full NameParentFullName
AccountSub LevelSublevel
AccountAccount NumberAccountNumber
AccountDescriptionDesc
AccountBalanceBalance
AccountCurrency List IDCurrencyListID
AccountCurrency Full NameCurrencyFullName
AccountClass List IDClassListID
AccountClass Full NameClassFullName
AccountOnlineIsOnline
AccountReimbursedIsReimbursed
AccountReimbursed Account List IDReimbursedAccountListID
AccountReimbursed Account Full NameReimbursedAccountFullName
AccountBalance Adjustment Exchange RateBalanceAdjustmentExchangeRate
AccountBalance Home AmountBalanceHomeAmount
ClassTime CreatedTimestamp on the class creation
ClassTime ModifiedTimestamp on the class modification
ClassNameUnique full name given to each class
ClassFull NameUnique full name given to each class
ClassActiveVerifies if the class is in active state
ClassParent List IDParent id of this child item
ClassParent Full NameFull name of the parent class
ClassSub LevelInteger showing what sub level this class is at
CurrencyTime CreatedTimestamp on the currency creation
CurrencyTime ModifiedTimestamp on the currency modification
CurrencyNameUnique full name given to each currency
CurrencyIs ActiveVerifies if the currency is in active state
CurrencyCurrency CodeUnique code associated with the actual currency
CurrencyThousand SeparatorCharacter to separate every thousand in the currency field
CurrencyDecimal PlacesSpecifies how many decimal places the currency needs to be rounded to
CurrencyDecimal SeparatorCharacter to separate every decimal in the currency field
CurrencyIs User Defined CurrencyCurrency full name that this customer is referencing
CurrencyExchange RateValue of current currency used converted to desired currency
CurrencyAs Of DateDate to specify the exchange rate
CurrencyGain Loss Account List IDAccount ID associated with this currency for posting gain or loss
CurrencyGain Loss Account Full NameAccount name associated with this currency for posting gain or loss
CustomerCustomer.ActiveFlag to check if the customer is active and make it visible on the UI
CustomerCustomer.BalanceOpen balance of the customer
CustomerCustomer.Balance Home AmountBalance in home country currency of this customer
CustomerCustomer.Bill Address 1Billing address 1 for the customer
CustomerCustomer.Bill Address 2Billing address 2 for the customer
CustomerCustomer.Bill Address 3Billing address 3 for the customer
CustomerCustomer.Bill Address 4Billing address 4 for the customer
CustomerCustomer.Bill Address 5Billing address 5 for the customer
CustomerCustomer.Bill Address Block 1Billing address block 1 for the customer
CustomerCustomer.Bill Address Block 2Billing address block 2 for the customer
CustomerCustomer.Bill Address Block 3Billing address block 3 for the customer
CustomerCustomer.Bill Address Block 4Billing address block 4 for the customer
CustomerCustomer.Bill Address Block 5Billing address block 5 for the customer
CustomerCustomer.Bill Address CityBilling address city for the customer
CustomerCustomer.Bill Address CountryBilling address country for the customer
CustomerCustomer.Bill Address Postal CodeBilling address zipcode for the customer
CustomerCustomer.Bill Address StateBilling address state for the customer
CustomerCustomer.Class Full NameTotal credit remaining in the customer's home currency
CustomerCustomer.Class List IDCustomer that’s relevant to the line id of the transaction
CustomerCustomer.Company NameMessage to the customer for a particular transaction
CustomerCustomer.Credit LimitConfirms whether this transaction is taxable or not
CustomerCustomer.Currency Full NameFlag if the discount is applied to the line of transaction
CustomerCustomer.Currency List IDRefers to the the invoice due date
CustomerCustomer.Customer List IDEstimated amount while creating an estimate
CustomerCustomer.Customer Type Full Nametrue if charge/credit/billable/time has been put onto an invoice transaction
CustomerCustomer.Customer Type List IDFlag to check if entire quantity is received for an order
CustomerCustomer.First NameFirst Name of this customer
CustomerCustomer.Full NameFull name for the customer
CustomerCustomer.Job DescriptionJob description of the job of this customer
CustomerCustomer.Job End DateJob end date of this customer
CustomerCustomer.Job Projected End DateProjected Job end date of this customer
CustomerCustomer.Job Start DateJob start date of this customer eg: start date of remodelling for this customer
CustomerCustomer.Job TitleJob title of this customer
CustomerCustomer.Job Type Full NameFull name of the job type that this customer is referencing
CustomerCustomer.Job Type List IDIdentifier of job type that this customer is referencing
CustomerCustomer.Last NameLast name of this customer
CustomerCustomer.Middle NameMiddle name of this customer
CustomerCustomer.NameName for the customer
CustomerCustomer.Parent Full NameFull name of the parent customer
CustomerCustomer.Parent List IDParent id of this customer
CustomerCustomer.Preferred Delivery MethodPreferredDeliveryMethod that this customer has requested
CustomerCustomer.Preferred Payment Method Full NamePreferred payment method full name that this customer is referencing
CustomerCustomer.Preferred Payment Method List IDPreferred payment method id that this customer is referencing
CustomerCustomer.Price Level Full NamePrice level full name that this customer is referencing
CustomerCustomer.Price Level List IDPrice level identifier that this customer is referencing
CustomerCustomer.Sales Rep Full NameSales rep full name that this customer is referencing
CustomerCustomer.Sales Rep List IDSales rep id that this customer is referencing
CustomerCustomer.Sales Tax Code Full NameSales tax code full name that this customer is referencing
CustomerCustomer.Sales Tax Code List IDSales tax code id that this customer is referencing
CustomerCustomer.SalutationSalutation of this customer
CustomerCustomer.Sub LevelNumerical value of where the customer belongs in the hiearchical structure
CustomerCustomer.Terms Full NameTerms full name that this customer is referencing
CustomerCustomer.Terms List IDTerms identifier that this customer is referencing
CustomerCustomer.Time CreatedTime created for the customer
CustomerCustomer.Time ModifiedTime modified for the customer
Customer Additional ContactList IDCustomer's additional contact's list id
Customer Additional ContactCustomer Full NameCustomer's additional contact's full name
Customer Additional ContactSalutationCustomer's additional contact's salutation
Customer Additional ContactFirst NameCustomer's additional contact's first name
Customer Additional ContactMiddle NameCustomer's additional contact's middle name
Customer Additional ContactLast NameCustomer's additional contact's last name
Customer Additional ContactJob TitleCustomer's additional contact's job title
Customer Additional ContactContact TypeCustomer's additional contact's type
Customer MessageTime CreatedTimestamp on the customer message creation
Customer MessageTime ModifiedTimestamp on the customer message modification
Customer MessageNameUnique full name given to each customer message
Customer MessageIs ActiveVerifies if the customer message is in active state
Customer NoteNote List IDID of a specific customer note for an existing customer
Customer NoteCustomer Full NameFull name of the customer associated with a particular note
Customer NoteDateDate when the customer note was created
Customer Primary ContactList IDCustomer's primary contact's list id
Customer Primary ContactCustomer Full NameCustomer's primary contact's full name
Customer Primary ContactSalutationCustomer's primary contact's salutation
Customer Primary ContactFirst NameCustomer's primary contact's first name
Customer Primary ContactMiddle NameCustomer's primary contact's middle name
Customer Primary ContactLast NameCustomer's primary contact's last name
Customer Primary ContactJob TitleCustomer's primary contact's job title
Customer Primary ContactContact TypeCustomer's primary contact's type
Customer Secondary ContactList IDCustomer's secondary contact's list id
Customer Secondary ContactCustomer Full NameCustomer's secondary contact's full name
Customer Secondary ContactSalutationCustomer's secondary contact's salutation
Customer Secondary ContactFirst NameCustomer's secondary contact's first name
Customer Secondary ContactMiddle NameCustomer's secondary contact's middle name
Customer Secondary ContactLast NameCustomer's secondary contact's last name
Customer Secondary ContactJob TitleCustomer's primary contact's job title
Customer Secondary ContactContact TypeCustomer's secondary contact's type
Customer To DoList IDCustomer to do list id
Customer To DoTime CreatedTimestamp on the Customer to do creation
Customer To DoTime ModifiedTimestamp on the customer to do modification
Customer To DoNameUnique full name given to each customer to do
Customer To DoPriorityPriority given to each to do eg: low
Customer To DoNotesDetails associated with each to do
Customer To DoIs ActiveVerifies if the customer message is in active state
Customer To DoIs DoneFlag to check the status of the current to do
Customer To DoStatusStatus of the current to do, eg: active, done, inactive
Customer To DoReminder DateDue date for the current to do
Customer TypeTime CreatedTimestamp on the customer type creation
Customer TypeTime ModifiedTimestamp on the customer type modification
Customer TypeNameUnique name given to each customer type: eg Wholesale, retailer
Customer TypeFull NameUnique full name given to each customer type
Customer TypeIs ActiveVerifies if the customer type is in active state
Customer TypeParent List IDParent ID of customer type child item
Customer TypeParent Full NameParent name of the customer type child
Customer TypeSublevelNumerical value of where the field belongs in the hiearchical structure
EmployeeAccount NumberJob description of the job of this customer
EmployeeActiveFlag to check if the item is active or inactive
EmployeeAlt PhoneAlternate phone number of the employee
EmployeeBirth DateBirth date of the employee
EmployeeCompany NameCompany name of the employee that is being referred to
EmployeeEmailEmail address of the empployee
EmployeeEmployee Address 1Line 1 of the employee address
EmployeeEmployee Address 2Line 2 of the employee address
EmployeeEmployee Address 3Line 3 of the employee address
EmployeeEmployee Address 4Line 4 of the employee address
EmployeeEmployee Address CityCity on the employee address
EmployeeEmployee Address CountryCountry on the employee address
EmployeeEmployee Address Postal CodeZipcodeon the employee address
EmployeeEmployee Address StateState on the employee address
EmployeeEmployee List IDEmployee id where the particular employee is referenced
EmployeeEmployee TypeType of employee in the employee table
EmployeeFaxFax number of the employee
EmployeeFirst NameFirst Name of the employee
EmployeeGenderGender of the employee
EmployeeHired DateHiring date of the employee
EmployeeInitialsInitials of the employee
EmployeeIsSalesRepActiveFlag to check if a particular employee who is a sales representative is active or not
EmployeeLast NameLast Name of the employee
EmployeeMiddle NameMiddle Name of the employee
EmployeeMobileCell phone number of the employee
EmployeeNameDisplay Name of the employee
EmployeeNotesNotes on an employee
EmployeePagerPager number of the employee
EmployeePager PINPager pin number of the employee
EmployeePhoneHome phone of the employee
EmployeeReleased DateDate when the employee was released
EmployeeEmployee.SalesRepInitialInitials of the employee sales representative
EmployeeEmployee.SalutationProjected Job end date of this customer
EmployeeEmployee.Sick Hours Accrual PeriodTime period specifying when the sick hours were accrued for an employee
EmployeeEmployee.Sick Hours Accrual Start DateDate when the sick hours start getting accrued for an employee
EmployeeEmployee.Sick Hours AccruedTotal number of sick hours accrued during a pay period for an employee
EmployeeEmployee.Sick Hours AvailableNumber of sick hours available for an employee
EmployeeEmployee.Sick Hours Is Resetting Hours Each New YearFlag to check if the sick hours are getting reset after every year
EmployeeEmployee.Sick Hours MaximumRefers to the maximum number of sick hours an employee can accumulate
EmployeeEmployee.Sick Hours UsedNumber of sick hours used up by the employee
EmployeeEmployee.Time CreatedCreation time of the employee
EmployeeEmployee.Time ModifiedModification time of an employee
EmployeeEmployee.TitleTitle of the employee
EmployeeEmployee.Vacation Hours Accrual PeriodTime period specifying when the vacation hours were accrued for an employee
EmployeeEmployee.Vacation Hours Accrual Start DateDate when the vacation hours start getting accrued for an employee
EmployeeEmployee.Vacation Hours AccruedTotal number of vacation hours accrued during a pay period for an employee
EmployeeEmployee.Vacation Hours AvailableNumber of vacation hours available for an employee
EmployeeEmployee.Vacation Hours MaximumRefers to the maximum number of vacation hours an employee can accumulate
EmployeeEmployee.Vacation Hours UsedNumber of vacation hours used up by the employee
EmployeeEmployee.Vacation Is Resetting Hours Each New YearFlag to check if the vacation hours are getting reset after every year
Employee Additional ContactList IDVendor's other contact's list id
Employee Additional ContactEmployee Full NameEmployee's additional contact's full name
Employee Additional ContactSalutationEmployee's additional contact's salutation
Employee Additional ContactFirst NameEmployee's additional contact's first name
Employee Additional ContactMiddle NameEmployee's additional contact's middle name
Employee Additional ContactLast NameEmployee's additional contact's last name
Employee Additional ContactJob TitleEmployee's additional contact's job title
Employee Additional ContactContact TypeEmployee's additional contact's type
Employee EarningsRateEdlist that represents the employee pay rate
Employee To DoList IDEmployee to do list id
Employee To DoTime CreatedTimestamp on the Employee to do creation
Employee To DoTimeModifiedTimestamp on the Employee to do modification
Employee To DoNameUnique full name given to each Employee to do
Employee To DoPriorityPriority given to each to do eg: low
Employee To DoNotesDetails associated with each to do
Employee To DoActiveVerifies if the vendor Employee is in active state
Employee To DoDoneFlag to check the status of the current to do
Employee To DoStatusStatus of the current to do, eg: active, done, inactive
Employee To DoReminder DateDue date for the current to do
Inventory SiteInventory Site List IDID list of the inventory site
Inventory SiteTime CreatedTimestamp on the inventory site creation
Inventory SiteTime ModifiedTimestamp on the inventory site modification
Inventory SiteNameName of the inventory site
Inventory SiteFull NameFull name of the inventory site
Inventory SiteActiveFlag to check if the inventory site is active or not
Inventory SiteParent Site List IDParent id of the inventory site
Inventory SiteParent Site Full NameParent full name of the inventory site
Inventory SiteSub LevelNumerical value of where the site belongs in the hiearchical structure
Inventory SiteSite DescriptionText about site description of an inventory site
Inventory SiteContactContact person on the inventory site
Inventory SitePhonePhone info of the contact person on the inventory site
Inventory SiteFaxFax info of the contact person on the inventory site
Inventory SiteEmailEmail info of the contact person on the inventory site
Inventory SiteSite Address 1Address line 1 of the inventory site
Inventory SiteSite Address 2Address line 2 of the inventory site
Inventory SiteSite Address 3Address line 3 of the inventory site
Inventory SiteSite Address 4Address line 4 of the inventory site
Inventory SiteSite Address 5Address line 5 of the inventory site
Inventory SiteSite Address CityCity of the inventory site
Inventory SiteSite Address StateState of the inventory site
Inventory SiteSite Address Postal CodeZipcode of the inventory site
Inventory SiteSite Address CountryCountry of the inventory site
Inventory SiteSite Address Block 1Address block 1 of the inventory site
Inventory SiteSite Address Block 2Address block 2 of the inventory site
Inventory SiteSite Address Block 3Address block 3 of the inventory site
Inventory SiteSite Address Block 4Address block 4 of the inventory site
Inventory SiteSite Address Block 5Address block 5 of the inventory site
Inventory Site LocationInventory Site Location List IDList of the inventory site location
Inventory Site LocationTime CreatedTimestamp on the inventory site location creation
Inventory Site LocationTime ModifiedTimestamp on the inventory site location modification
Inventory Site LocationNameName of the inventory site location
Inventory Site LocationFull NameFull Name of the inventory site location
Inventory Site LocationActiveFlag to check if the inventory site location is active or not
Inventory Site LocationParent Site List IDParent id of the inventory site location
Inventory Site LocationParent Site Full NameParent Name of the inventory site location
Inventory Site LocationSub LevelNumerical value of where the site location belongs in the hiearchical structure
Inventory Site LocationSite DescriptionText about site description of an inventory site location
Inventory Site LocationContactContact person on the inventory site location
Inventory Site LocationPhonePhone info of the contact person on the inventory site location
Inventory Site LocationFaxFax info of the contact person on the inventory site location
Inventory Site LocationEmailEmail info of the contact person on the inventory site location
Inventory Site LocationSite Address 1Address line 1 of the inventory site location
Inventory Site LocationSite Address 2Address line 2 of the inventory site location
Inventory Site LocationSite Address 3Address line 3 of the inventory site location
Inventory Site LocationSite Address 4Address line 4 of the inventory site location
Inventory Site LocationSite Address 5Address line 5 of the inventory site location
Inventory Site LocationSite Address CityCity of the inventory site location
Inventory Site LocationSite Address StateState of the inventory site location
Inventory Site LocationSite Address Postal CodeZipcode of the inventory site location
Inventory Site LocationSite Address CountryCountry of the inventory site location
Inventory Site LocationSite Address Block 1Address block 1 of the inventory site location
Inventory Site LocationSite Address Block 2Address block 2 of the inventory site location
Inventory Site LocationSite Address Block 3Address block 3 of the inventory site location
Inventory Site LocationSite Address Block 4Address block 4 of the inventory site location
Inventory Site LocationSite Address Block 5Address block 5 of the inventory site location
Inventory Site LocationInventory Site Location Full NameFull name of the inventory site location as referenced in the item site location table
ItemAccount Full NameName of the account that this item is referencing
ItemAccount List IDID of the account that this item is referencing
ItemActiveFlag to check if the item is active or inactive, where ACTIVE=1 and INACTIVE=0
ItemAsset Account Full NameName of asset account that this item is referencing
ItemAsset Account List IDID for the asset account that this item is referencing
ItemAsset DescriptionDescription of fixed asset item
ItemAsset NumberUnique asset number for the item
ItemAverage CostCurrent average cost based on all purchases for that item
ItemBar Code ValueBar code of the item
ItemBuild PointNumber assigned to remind when to build
ItemClass Full NameFull name of the class
ItemClass List IDClass ID where the item references
ItemCOGS Account Full NameName of the cost of good sold account that this item is referencing
ItemCOGS Account List IDID for the cost of goods sold account that this item is referencing
ItemDeposit To Account Full NameName of deposit account this item is referencing
ItemDeposit To Account List IDID of deposit account this item is referencing
ItemDiscount Item List IDID of the discounted item
ItemDiscount RateRate of the discount on an item ($$)
ItemDiscount Rate PercentRate of the discount on an item (%)
ItemExpense Account Full NameName of the expense account for this item
ItemExpense Account List IDID of the expense account for this item
ItemFixed Asset Item List IDID of this fixed asset item
ItemFixed Asset Sales DateSales date of the fixed asset item
ItemFixed Asset Sales DescriptionSales description of the fixed asset item
ItemFixed Asset Sales ExpenseSales expense of the fixed asset item
ItemFixed Asset Sales PriceSales price of the fixed asset item
ItemFull NameFull name of the item
ItemIncome Account Full NameName of an income account that this item is referencing
ItemIncome Account List IDID of an income account that this item is referencing
ItemInventory Assembly Item List IDID of the assembly itself
ItemInventory Item List IDIdentifier for an inventory type item in an item list
ItemItem DescriptionText in Item description field
ItemItem List IDIdentifier for an item in item list
ItemItem TypeType of item such as service, non-inventory, assembly
ItemLocationLocation of item
ItemManufacturer Part NumberManufacturing part number of that item
ItemNameDisplay Name of the item
ItemNon Inventory Item List IDID of the non-inventory item
ItemNotesNotes section for the item
ItemOther Item Charge List IDID of the Other Charge item
ItemParent Full NameFull name of the parent item
ItemParent List IDParent ID of the child item
ItemPayment Item List IDID of payment item this item is referencing
ItemPayment Method Full NameName of payment method this item is referencing
ItemPayment Method List IDID of payment method this item is referencing
ItemPending Assembly QuantityNumerical value assigned to quantity for assembly item on pending billed transactions
ItemPreferred Vendor Full NameName of the preferred vendor that this item is referencing
ItemPreferred Vendor List IDID for the preferred vendor that this item is referencing
ItemPurchase CostPurchase cost of an item from a vendor
ItemPurchase DescriptionText for purchase description of an item
ItemQuantity On HandCurrent quantity on hand of this item
ItemQuantity On OrderCurrent Quantity on purchase order for item
ItemQuantity On Sales OrderCurrent Quantity on sales order for item
ItemReorder PointNumber assigned to remind when to reorder
ItemSales DescriptionText for sales description of an item
ItemSales PriceSales price of the item
ItemSales Price PercentPercentage of mark up over cost for an item
ItemSales Tax Code Full NameName of the sales tax code that this item is referencing
ItemSales Tax Code List IDID of the sales tax code that this item is referencing
ItemSerial NumberSerial number of the item
ItemSub LevelNumerical value of where the item belongs in the hiearchical structure
ItemSubtotal Item List IDID of the subtotal of this item
ItemTime CreatedCreation time of the item
ItemTime ModifiedModification time of an item
ItemUnit Of Measure Set Full NameName of the unit of measure that this item is referencing
ItemUnit Of Measure Set List IDID of the unit of measure that this item is referencing
ItemValue On Hand AmountCurrent valued dollar ($) amount on hand for this item
ItemVendor Or Payee NameVendor or payee name of the fixed asset item
ItemWarranty Expiry DateExpiration date of the warranty for the item
Item Group ComponentItem Group Full NameFull name of a specific group having multiple items
Item Group ComponentItem TypeItem type of an item which is part of a specific group having multiple items
Item Group ComponentItem List IDID of an item which is part of a specific group having multiple items
Item Group ComponentItem Full NameFull name of an item which is part of a specific group having multiple items
Item Group ComponentQuantityQuantity of an item which is part of a specific group having multiple items
Item Group ComponentUnit Of Measure Unit List IDList ID of unit of measure of an item which is part of a specific group having multiple items
Item Group ComponentUnit Of Measure Unit Full NameFull name of unit of measure of an item which is part of a specific group having multiple items
Item HistoryAverage CostAverage cost of the item as referenced in the item history table
Item HistoryItem Full NameFull name of the item in the item history table
Item HistoryItem List IDIdentifier for an item in item history list
Item HistoryQuantity On HandQuantity on hand for an item as referenced in the item history table
Item HistoryTime CreatedCreation time of the item as referenced in the item history table
Item HistoryTime ModifiedModification time of an item as referenced in the item history table
Item HistoryTxn DateTransaction date of the transaction as referenced in the item history table
Item HistoryTxn IDTransaction id of the transaction in the item history table
Item HistoryValue On HandValue of the item on hand as referenced in the item history table
Item Inventory Assembly ComponentItem Inventory Assembly Full NameFull name of an inventory assembly item
Item Inventory Assembly ComponentItem TypeSpecifies the item type of an inventory assembly item
Item Inventory Assembly ComponentItem List IDID of a specific inventory assembly item
Item Inventory Assembly ComponentItem Full NameFull name of an item which is part of inventory assembly item
Item Inventory Assembly ComponentQuantityQuantity of an inventory assembly item
Item Inventory Assembly ComponentUnit Of Measure Unit List IDID of the Unit of measure for a specific inventory assembly item
Item Inventory Assembly ComponentUnit Of Measure Unit Full NameName of the Unit of measure for a specific inventory assembly item
Item Sales Tax Item Sales Tax List IDId of the item sales tax list
Item Sales Tax Time CreatedTimestamp of a specific sales tax item creation
Item Sales Tax Time ModifiedTimestamp of a specific sales tax item modification
Item Sales Tax NameName of a specific sales tax item
Item Sales Tax ActiveFlag to check if a specific sales tax item is active or not
Item Sales Tax Item DescriptionDescription of an item under with type as sales tax item
Item Sales Tax Tax RateTax rate of an item under with type as sales tax item
Item Sales Tax Tax Vendor List IDTax agency (vendor that tax is collected for) of an item under with type as sales tax item
Item Sales Tax Tax Vendor Full NameFull name of the tax agency for an item for which tax is being collected
Item Sales Tax NotesNotes for a sales tax item
Item SiteList IDList of the item site
Item SiteTime CreatedTimestamp on the inventory site creation
Item SiteTime ModifiedTimestamp on the inventory site modification
Item SiteInventory Assembly Item List IDList of the inventory assembly item
Item SiteItem Inventory Assembly Full NameFull name of the inventory assembly item
Item SiteItemInventoryFullNameFull name of the inventory non-assembly item
Item SiteInventory Site Full NameFull name of the inventory site
Item SiteReorder LevelNumber assigned to remind when to reorder at the item site
Item SiteQuantity On HandQuantity on hand for an item at the item site
Item SiteQuantity On Purchase OrdersQuantity of item on purchase order at item site
Item SiteQuantity On Sales OrdersQuantity of item on sales order at item site
Item SiteReorder Inventory QuantityQuantity for reordering to replenish the inventory at the item site
Item SiteReorder Assembly QuantityQuantity for reordering to replenish assembly item at the item site
Item Site LocationList IDEdlist of the item site location
Item Site LocationTime CreatedTimestamp on the item site location creation
Item Site LocationTime ModifiedTimestamp on the item site location modification
Item Site LocationInventory Assembly Item List IDEdlist of the inventory assembly item as referenced in the item site location table
Item Site LocationItem Inventory Assembly Full NameFull name of the inventory assembly item as referenced in the item site location table
Item Site LocationItemInventoryFullNameFull name of the inventory item as referenced in the item site location table
Item Site LocationInventory Site List IDEdlist of the inventory site as referenced in the item site location table
Item Site LocationInventory Site Full NameFull name of the inventory site as referenced in the item site location table
Item Site LocationInventory Site Location Full NameFull name of the inventory site location as referenced in the item site location table
Item Site LocationReorder LevelNumber assigned to remind when to reorder at the item site location
Item Site LocationQuantity On HandQuantity on hand for an item at the item site location
Item Site LocationQuantity On Purchase OrdersQuantity of item on purchase order at item site location
Item Site LocationQuantity On Sales OrdersQuantity of item on sales order at item site location
Item Site LocationDefault Purchase Bin List IDRefers to the list id of the default bin the purchase is to be made from
Item Site LocationDefault Purchase Bin Full NameRefers to the full name of the default bin the purchase is to be made from
Item Site LocationDefault Sales Bin List IDRefers to the list id of the default bin the sales is to be made from
Item Site LocationDefault Sales Bin Full NameRefers to the full name of the default bin the sales is to be made from
Item Site LocationReorder Inventory QuantityNumber assigned to remind when to reorder inventory item at the item site location
Item Site LocationReorder Assembly QuantityNumber assigned to remind when to reorder assembly item at the item site location
Item Unit Of Measure SetTime CreatedTimestamp on the unit of measure set creation
Item Unit Of Measure SetTime ModifiedTimestamp on the unit of measure set modification
Item Unit Of Measure SetNameCustomer specified name for a unit of measure set
Item Unit Of Measure SetActiveFlag to check if the specific unit of measure set is active or not
Item Unit Of Measure SetUnit Of Measure TypeName for a specific unit of measure type eg: count, length, weight
Item Unit Of Measure UnitNameName of a specific unit of measure
Item Unit Of Measure UnitAbbreviationAbbreviation of a specific unit of measure
Item Unit Of Measure UnitBase UnitFlag to check of the specific unit of measure set is a base unit or not
Item Unit Of Measure UnitPurchase Default UnitFlag to check if the unit of measure set has default unit set for purchases
Item Unit Of Measure UnitSales Default UnitFlag to check if the unit of measure set has default unit set for sales
Item Unit Of Measure UnitShipping Default UnitFlag to check if the unit of measure set has default unit set for shipping
Job TypeTime CreatedTimestamp on the job type creation
Job TypeTime ModifiedTimestamp on the job type modification
Job TypeNameName for a specific job type
Job TypeFull NameFull name for a specific job type
Job TypeActiveFlag to check if a particular job type is active or not
Job TypeParent List IDParent id of the specific job type
Job TypeParent Full NameParent full name of the specific job type
Job TypeSub LevelNumerical value of where the job type belongs in the hiearchical structure
LeadLead List IDUnique ID given to each lead in the lead list
LeadTime CreatedTimestamp on the lead creation
LeadTime ModifiedTimestamp on the lead modification
LeadFull NameFull name of the inventory assembly item
LeadCompany NameCompany name that is associated to a particular lead
LeadActiveVerifies if the lead is in active state
LeadStatusFull name of the inventory non-assembly item
LeadMain PhoneMain phone number on the lead
Lead Additional ContactListIDList id of the of the additional contact on the lead
Lead Additional ContactLead Full NameFull name of the of the additional contact on the lead
Lead Additional ContactSalutationSalutation of the of the additional contact on the lead
Lead Additional ContactFirst NameFirst name of the of the additional contact on the lead
Lead Additional ContactMiddle NameMiddle name of the of the additional contact on the lead
Lead Additional ContactLast NameLast name of the of the additional contact on the lead
Lead Additional ContactJob TitleJob title of the of the additional contact on the lead
Lead Additional ContactContact TypeContact type of the of the additional contact on the lead
Other NameAccount NumberAccount number of the other name
Other NameOther Name Address CountryCountry on the other address
Other NameActiveFlag to check if the other name is active and make it visible on the UI
Other NameAlt ContactAlternate Contact name of the other name
Other NameAlt PhoneAlternate phone number of the other name
Other NameCompany NameCompany name of the other name
Other NameContactContact name of the other name
Other NameEmailEmail of the other name
Other NameFaxFax number of the other name
Other NameFirst NameFirst name of the other name
Other NameInitialsInitials of the other name
Other NameLast NameLast name of the other name
Other NameMiddle NameMiddle name of the other name
Other NameMobileCell phone number of the other name
Other NameNameName of other name edlist
Other NameNon Employee Pay Period End Date?????????
Other NameNotesNotes for the other name
Other NameOpen Date?????????
Other NameOther List IDIdentifier for the other name in the other name list
Other NameOther Name Address 1Line 1 of the other address
Other NameOther Name Address 2Line 2 of the other address
Other NameOther Name Address 3Line 3 of the other address
Other NameOther Name Address 4Line 4 of the other address
Other NameOther Name Address 5Line 5 of the other address
Other NameOther Name Address Block 1Block 1 of the other address
Other NameOther Name Address Block 2Block 2 of the other address
Other NameOther Name Address Block 3Block 3 of the other address
Other NameOther Name Address Block 4Block 4 of the other address
Other NameOther Name Address Block 5Block 5 of the other address
Other NameOther Name Address CityCity on the other address
Other NameOther Name Address Postal CodeZipcodeon the other address
Other NameOther Name Address StateState on the other address
Other NamePagerPager number of the other name
Other NamePager PINPagerpin number of the other name
Other NamePhoneHome phone number of the other name
Other NameSales Rep List IDIdentifier of this other name in the sales rep list
Other NameTime CreatedTime created for the other list
Other NameTime ModifiedModified time for the other list
Other NameTitleTitle of the other name
Other NameSalutationSalutation of the other name
Other NameIsSalesRepActiveFlag to check if a particular sales representative in th other name table is active or not
Other NameSalesRepInitialInitials of the other sales representative
Other NameOther List IDIdentifier for the other name in the other name list
Other Name Additional ContactList IDVendor's other contact's list id
Other Name Additional ContactOther Full NameVendor's other contact's full name
Other Name Additional ContactSalutationVendor's other contact's salutation
Other Name Additional ContactFirst NameVendor's other contact's first name
Other Name Additional ContactMiddle NameVendor's other contact's middle name
Other Name Additional ContactLast NameVendor's other contact's last name
Other Name Additional ContactJob TitleVendor's other contact's job title
Other Name Additional ContactContact TypeVendor's other contact's type
Price LevelPrice Level List IDID of the price level list
Price LevelTime CreatedTimestamp on the pricelevel edlist creation
Price LevelTime ModifiedTimestamp on the pricelevel edlist modification
Price LevelNameName of a customer defined price level
Price LevelPrice Level TypePrice level type of a specific price level
Price LevelPrice Level Fixed PercentagePercentage to be set if the customer needs to increase or decrease sales price
Price LevelActiveFlag to check if the price level is active or not
Price LevelCurrency List IDCurrency list that the specific price level is referencing
Price LevelCurrency Full NameCurrency full name that the specific price level is referencing
Price LevelRound OffsetSpecifies upto what decimal the price level should be rounded
Price LevelRound To AmountSpecifies upto what dollar amount the price level should be rounded
Price LevelRounding Method TypeSpecifies what rounding type is used, eg: user defined, decimal
Price Level ItemPrice Level Full NameFull name of a specific price level item
Sales RepTime CreatedTimestamp on the new sales representative creation
Sales RepTime ModifiedTimestamp on the sales representative modification
Sales RepInitialInitials of a particular sales rep
Sales RepActiveFlag to check if a sales rep is active or not
Sales RepSales Rep Entity List IDID of the sales rep list
Sales RepSales Rep Entity Full NameFull name of a particular sales rep entity
Sales RepSales Rep Entity TypeSpecifies the type of sales rep eg: vendor, employee, other name
Serial NumberIDSerial number id for an item
Serial NumberNameSerial number name for an item
Serial NumberRemaining QuantityInteger showing the remaining quantity of an item with a particular serial number
Serial NumberItem Full NameFull name of an item with a particular serial number
Serial NumberItem TypeItem type of an item with a particular serial number
Serial NumberInventory Site List IDEdlist of the inventory site which has an item with a particular serial number
Serial NumberInventory Site Full NameFull name of the inventory site which has an item with a particular serial number
Serial NumberInventory Site Location List IDEdlist of the inventory site location which has an item with a particular serial number
Serial NumberInventory Site Location Full NameFull name of the inventory site location which has an item with a particular serial number
Ship ToNameName of the multiple ship to record for a customer
Ship ToAddress 1Address line 1 of the multiple ship to record for a customer
Ship ToAddress 2Address line 2 of the multiple ship to record for a customer
Ship ToAddress 3Address line 3 of the multiple ship to record for a customer
Ship ToAddress 4Address line 4 of the multiple ship to record for a customer
Ship ToAddress 5Address line 5 of the multiple ship to record for a customer
Ship ToCityCity of the multiple ship to record for a customer
Ship ToStateState of the multiple ship to record for a customer
Ship ToPostal CodeZip code of the multiple ship to record for a customer
Ship ToCountryCountry of the multiple ship to record for a customer
Ship ToBlock Address 1Non-parsible address line 1 which is to be stored in a block address line 1
Ship ToBlock Address 2Non-parsible address line 2 which is to be stored in a block address line 2
Ship ToDefault Ship ToFlag to choose default ship to address to be associated with the customer
Ship ToBlock Address 3Non-parsible address line 3 which is to be stored in a block address line 3
Ship ToBlock Address 4Non-parsible address line 4 which is to be stored in a block address line 4
Ship ToBlock Address 5Non-parsible address line 5 which is to be stored in a block address line 5
Shipping MethodTime CreatedTimestamp on the shipping method edlist object creation
Shipping MethodTime ModifiedTimestamp on the shipping method edlist modification
Shipping MethodNameUnique full name given to each shipping method
Shipping MethodActiveVerifies if the shipping method is in active state
TermActiveVerifies if the term is in active state
TermDay Of Month DueSpecifies up to which date of the month for net due in the payment terms
TermDiscount Day Of MonthSpecifies the date of the month for which discount is given if the amount is paid by then
TermDiscount PctDiscount percentage associated with the payment terms
TermDue Next Month DaysSpecifies the number of days in the month of the due date
TermNameUnique full name given to each term
TermStandard Discount DaysInteger for the number of days if you need to avail the discount (Std term type)
TermStandard Due DaysInteger for the number of days that this term specifies a payment is due
TermTime CreatedTimestamp on the terms edlist object creation
TermTime ModifiedTimestamp on the terms edlist modification
TermTypeInteger to determine if it’s a date driven or standard term
TransactionAddress 1Line 1 of the address on a trasaction
TransactionAddress 2Line 2 of the address on a trasaction
TransactionAddress 3Line 3 of the address on a trasaction
TransactionAddress 4Line 4 of the address on a trasaction
TransactionAddress 5Line 5 of the address on a trasaction
TransactionAddress Block 1Address block 1 on the transaction
TransactionAddress Block 2Address block 2 on the transaction
TransactionAddress Block 3Address block 3 on the transaction
TransactionAddress Block 4Address block 4 on the transaction
TransactionAddress Block 5Address block 5 on the transaction
TransactionAddress CityCity on the address on a trasaction
TransactionAddress CountryCountry on the address on a trasaction
TransactionAddress Postal CodeZip code on the address on a trasaction
TransactionAddress StateState on the address on a trasaction
TransactionAmountAmount (without sign) for transactions (includes all transaction types)
TransactionAmount with SignAmount (with sign) for only posting transactions
TransactionAmount Due In Home Currency(Multi-currency) Home currency value for that transaction
TransactionApplied DiscountFlag if the discount is applied or not for account
TransactionApplied To Txn AmountActual amount that is applied to the transaction
TransactionApplied To Txn Date Only valid for ReceivePayment Transactions. Shows the date on which discounts were applied to the payment.
TransactionApplied To Txn IDIdentifier to transaction that is being paid
TransactionApplied To Txn Ref NumberUser entered ID attached to the transaction being paid
TransactionApplied To Txn TypeType of transaction that is being paid
TransactionAr ApFlag to check payment status of Accounts Receivable/Accounts Payable account
TransactionBalance RemainingCurrent balance remaining on a transaction
TransactionBalance Remaining In Home CurrencyCurrent balance remaining on a transaction in home country currency
TransactionBank Account TypeType of bank account such as checking , savings, etc
TransactionBank Ref NameBank nickname
TransactionBegin BalanceFlag to check if there is non-zero beginning balance, where YES=1 and NO=0
TransactionBill Address 1Billing address 1 for the transaction
TransactionBill Address 2Billing address 2 for the transaction
TransactionBill Address 3Billing address 3 for the transaction
TransactionBill Address 4Billing address 4 for the transaction
TransactionBill Address 5Billing address 5 for the transaction
TransactionBill Address Block 1Billing address block 1 for the transaction
TransactionBill Address Block 2Billing address block 2 for the transaction
TransactionBill Address Block 3Billing address block 3 for the transaction
TransactionBill Address Block 4Billing address block 4 for the transaction
TransactionBill Address Block 5Billing address block 5 for the transaction
TransactionBill Address CityBilling address city for the transaction
TransactionBill Address CountryBilling address country for the transaction
TransactionBill Address Postal CodeBilling address zip code for the transaction
TransactionBill Address StateBilling address state for the transaction
TransactionBilledFlag to check if the customer has been billed, where YES=1 and NO=0
TransactionBilled DateDate when the transaction is billed
TransactionBuildFlag to check if the assembly is built or not, where YES=1 and NO=0
TransactionCheck NumberUnique number for check
TransactionClass List IDUsed for reference if you track class (enabled by preference) - can be per line or header.
TransactionCOGS AmountNumber of Items Sold multiplied by the Average Cost of Item
TransactionCostCost of an item
TransactionCredit Amount In Home Currency(Multi-currency) The credit amount in home currency
TransactionCreditRemainingInHomeCurrencyTotal credit remaining in the customer's home currency
TransactionCustomer List IDCustomer ID that’s in the transaction
TransactionCustomer Msg List IDID for the message to the customer for a particular transaction
TransactionCustomer Sales Tax Code List IDID that confirms whether this transaction is taxable or not
TransactionDebit Or CreditDistinguishes between debit or credit amount type
TransactionDelivery DateDelivery date for the items in a transaction
TransactionDepositedShows YES=1 or NO=0 depending on if the payment went to an "undeposited funds" account and it has since been deposited
TransactionDiscountFlag if the discount is applied to the line of transaction
TransactionDue DateInvoice due date
TransactionEmployee List IDIDs of all employees
TransactionEnd BalanceEnding balance on the transaction
TransactionEstimate AmountEstimated amount while creating an estimate. Available on Charge, Sales Receipt, Credit Memo, Invoie, Sales Order, and Purchase Order.
TransactionExchange RateCurrent exchange rate between currencies
TransactionExpected DateDate you expect to receive an item
TransactionFOBFree on board specifying at what point the seller transfers ownership of the goods to the buyer
TransactionFully InvoicedShows if charge/credit/billable time has been put onto an invoice transaction, where 1=YES and 0=NO
TransactionFully ReceivedFlag to check if entire quantity is received for an order, where 1=YES and 0=NO
TransactionGain Loss Target(Multi-currency) An adjustment on rate based on currency exchange
TransactionInventory Site List IDSite ID of the inventory for the item
TransactionInventory Site Location List IDLocation ID for the Site of the inventory for the item
TransactionInvoicedShows if charge/credit/billable/time has been added to an invoice transaction, where YES=1 and NO=0
TransactionInvoiced QuantityQuantity on Sales Order
TransactionItem From EstimateOrigin of item is from estimate, where 1=YES and 0=NO
TransactionItem From Sales OrderOrigin of item is from sales order, where 1=YES and 0=NO
TransactionItem List IDList of item ids
TransactionItem List IDList of Item IDs
TransactionItem Sales Tax List IDSales tax associated with a particular item
TransactionLast Auditable ActionAudit table record of the most recent change to a transaction
TransactionLiability Account List IDIDs of all liabilities
TransactionLine Item Name TypeUsed to distinguish beween vendor, customer, other
TransactionLinked Txn IDIdentifier for the link between Invoice ID and Receive Payment
TransactionLinked Txn Line IDIdentifier for the link between trasaction line IDs at the line level
TransactionLinked Txn TypeType of link between different transactions
TransactionManufacturer Part NumberID the vendor uses to identify an item
TransactionMarkup AmountAmount of markup over cost
TransactionMarkup RateShows the mark up rate of an item over cost
TransactionMarkup Rate PercentPercentage of mark up of item over cost
TransactionMemoNotes that can be added to a transaction
TransactionOpen AmountOpen amount on a transaction
TransactionOpen Balance AmountOpen balance that is still there on a transaction
TransactionOpen QuantityQuantity that is still un-delivered from a transaction
TransactionOpening BalanceAmount of open AR or AP which has not yet applied/paid
TransactionOther List IDIDs for list of things other an employees or customers or vendors
TransactionPaidShows if the transaction is fully paid where 1= YES and 0= NO
TransactionPayment Method List IDUnique ID of the payment type used for that transaction
TransactionPayment Txn Line IDIdentifier for line item for payment transaction
TransactionPendingFlag (0= NO, 1=YES) to check the status of estimate if it's in pending state
TransactionPO NumberPurchase order number
TransactionPoNumPurchase Order number
TransactionPrint Items In GroupFlag if you need to print all items in the group, where YES=1 and NO=0
TransactionPurchaseAny type of purchase such as bill or check
TransactionQuantityQuantity on a line item
TransactionQuantity Can BuildNumber of assemblies that can be built with current inventory
TransactionQuantity On HandNumber of items in an inventory
TransactionQuantity On Sales OrderNumber of items on a Sales Order
TransactionRateEmployee current pay rate
TransactionRate PercentSet percentage instead of the actual amount on an entity, such as Item or Employee
TransactionReceived QuantityQuantity received in a shipment
TransactionReconcile DateDate when you reconcile data with the bank
TransactionRefundedFlag if the amount is refunded/credited to the customer, where YES=1 and NO=0
TransactionReimbursed TypeType of reimbursement like creditmemo
TransactionSales Order NumberUnique ID on Sales order associated with an invoice
TransactionSales Order QuantityQuantity on the sales order form
TransactionSales Rep List IDSales rep ID associated with this transaction
TransactionSales Tax Code List IDList of IDs of all sales tax codes
TransactionSales Tax PercentageTax percentage while creating a transaction
TransactionSales Tax TotalTotal sales tax applied to transaction
TransactionSerial Or Lot Numbers ListIDs of all serial numbers or lot numbers for all items
TransactionService DateDate that a service was renderered
TransactionShip Address 1Shipping address 1 for the transaction
TransactionShip Address 2Shipping address 2 for the transaction
TransactionShip Address 3Shipping address 3 for the transaction
TransactionShip Address 4Shipping address 4 for the transaction
TransactionShip Address 5Shipping address 5 for the transaction
TransactionShip Address Block 1Shipping address block 1 for the transaction
TransactionShip Address Block 2Shipping address block 2 for the transaction
TransactionShip Address Block 3Shipping address block 3 for the transaction
TransactionShip Address Block 4Shipping address block 4 for the transaction
TransactionShip Address Block 5Shipping address block 5 for the transaction
TransactionShip Address CityShipping address city for the transaction
TransactionShip Address CountryShipping address country for the transaction
TransactionShip Address Postal CodeShipping address zip code for the transaction
TransactionShip Address StateShipping address state for the transaction
TransactionShip DateShipping date of the item
TransactionShip Method List IDAn ID for a shipment method with the transaction, ie Fedex or UPS
TransactionShip To Entity List IDList of "Ship To" addresses
TransactionSub TotalSub total of the line items added in the transaction
TransactionTarget TypeShows the target type, such as if it's Is this an item or a service etc
TransactionTax Code List IDIDs for list of tax codes
TransactionTax IncludedFlag to check if the tax is included in the price of the object, where YES=1 and NO=0. Valid only for purchase order.
TransactionTerms List IDPayment terms (ie Net 30)
TransactionTo Be EmailedShows if the trasaction details are to be emailed, where 1= YES and 0= NO
TransactionTo Be PrintedShows if the trasaction details are to be printed, where 1= YES and 0= NO
TransactionTotal AmountTotal amount on a transaction
TransactionTotal Amount In Home CurrencyTotal amount calculated in the customer's home currency
TransactionTrans TaxFlag to check if this transaction is taxable, where YES=1 and NO=0
TransactionTransaction DateDate of the transaction. Better to use Txn Date.
TransactionTransaction Line OrderUsed for the order of the line items in an invoice
TransactionTransaction Name TypeType of transaction eg invoice, payment etc.
TransactionTxn DateDate of transaction in MM/DD/YYYY format
TransactionTxn IDUnique ID of the transaction
TransactionTxn Line IDUnique transaction ID associated with each transaction
TransactionTxn Line TypeType of entity on a particular line item on a transaction
TransactionTxn TypeType of transaction: Purchase Order, Invoice, Estimate etc.
TransactionUnbilled QuantityAmount the customer hasn't been billed for to date
TransactionUnit Of Measure Unit List IDList of unit of measure type eg: count, length, weight
TransactionUnit PriceUnit price of a single item
TransactionUnused PaymentOverpayment by the customer that can be used to pay other invoice later.
TransactionValue AdjustmentAdjusted value on an item within transaction
TransactionVendor Address 1Line 1 of the vendor address
TransactionVendor Address 2Line 2 of the vendor address
TransactionVendor Address 3Line 3 of the vendor address
TransactionVendor Address 4Line 4 of the vendor address
TransactionVendor Address 5Line 5 of the vendor address
TransactionVendor Address Block 1Block 1 of the vendor address
TransactionVendor Address Block 2Block 2 of the vendor address
TransactionVendor Address Block 3Block 3 of the vendor address
TransactionVendor Address Block 4Block 4 of the vendor address
TransactionVendor Address Block 5Block 5 of the vendor address
TransactionVendor Address CityCity on the vendor address
TransactionVendor Address CountryCountry on the vendor address
TransactionVendor Address Postal CodeZip code on the vendor address
TransactionVendor Address StateState on the vendor address
TransactionVendor List IDList of vendor IDs
TransactionVendor MessageMessage from the shipper to the vendor
TransactionAccount Full NameFinancial/ledger account relevant for accounting
TransactionEmployee List IDIds of all employees
TransactionsTransactions.Account List IDTransactions.AccountListID
TransactionsOther List IDList of names of things other an employees or customers or vendors
TransactionsTransactions.Customer List IDCustomer that’s associated with the line ID of the transaction
TransactionsTransactions.Class List IDReference to the user tracking class when enabled by preference - can be per line or txn
TransactionsTransactions.Customer Msg List IDSpecifies the customer message edlist
TransactionsShip Method List IDShipping method id which is on a transaction
TransactionsTransactions. Inventory Site Location List IDLocation ID of the Site of the inventory for the item
TransactionsTransactions.Unit Of Measure Unit List IDList of unit of measure type eg: count, length, weight
TransactionsTransactions.Txn DateTransaction date for a particular transaction
TransactionsDay
TransactionsMonth
TransactionsMonth Year
TransactionsPeriod
TransactionsPeriod ID
TransactionsQuarter
TransactionsQuarter ID
TransactionsQuarter Year
TransactionsWeek
TransactionsYear
Unit Of Measure UnitUnit Of Measure Set List IDList of unit of measure set eg: count, length, weight
Unit Of Measure UnitUnit Of Measure Set Full NameFull name of unit of measure set
Unit Of Measure UnitNameName of unit of measure
Unit Of Measure UnitAbbreviationAbbreviation of unit of measure
Unit Of Measure UnitConversion RatioSpecifies the conversion ratio for a name under unit of measure to its default conversion
Unit Of Measure UnitBase UnitFlag to check if an entity under unit of measure is a base unit or not
Unit Of Measure UnitPurchase Default UnitFlag to check if the unit of measure set has default unit set for purchases
Unit Of Measure UnitSales Default UnitFlag to check if the unit of measure set has default unit set for sales
Unit Of Measure UnitShipping Default UnitFlag to check if the unit of measure set has default unit set for shipping
VendorVendor.Account NumberAccount number of the vendor for a transaction
VendorVendor.ActiveFlag to check if the vendor is active and make it visible on the UI
VendorVendor.BalanceBalance on unpaid purchases for this vendor
VendorVendor.Balance Home AmountBalance in home country currency of this vendor
VendorVendor.Class Full NameFull name of the class for the vendor
VendorVendor.Class List IDClass id where the vendor references
VendorVendor.Company NameCompany name of the vendor
VendorVendor.Credit LimitCredit limit of the vendor
VendorVendor.Currency Full NameCurrency full name that this vendor is referencing
VendorVendor.Currency List IDCurrency identifier that this vendor is referencing
VendorVendor.First NameVendor's first name
VendorVendor.IsSalesRepActiveFlag to check if a particular sales representative for a vendor is active or not
VendorVendor.Job TitleVendor's job title
VendorVendor.Last NameVendor's last name
VendorVendor.Middle NameVendor'smiddle name
VendorVendor.NameName for the vendor
VendorVendor.Name On CheckName on the check for the vendor for a transaction
VendorVendor.Sales Rep Full NameSales rep full name that this vendor is referencing
VendorVendor.Sales Rep List IDSales rep id that this vendor is referencing
VendorVendor.SalesRepInitialInitials of the vendor sales representative
VendorVendor.SalutationSalutation of the vendor
VendorVendor.Ship Address 1Line 1 of the vendor's shipping address
VendorVendor.Ship Address 2Line 2 of the vendor's shipping address
VendorVendor.Ship Address 3Line 3 of the vendor's shipping address
VendorVendor.Ship Address 4Line 4 of the vendor's shipping address
VendorVendor.Ship Address 5Line 5 of the vendor's shipping address
VendorVendor.Ship Address Block 1Vendor's shipping address block 1
VendorVendor.Ship Address Block 2Vendor's shipping address block 2
VendorVendor.Ship Address Block 3Vendor's shipping address block 3
VendorVendor.Ship Address Block 4Vendor's shipping address block 4
VendorVendor.Ship Address Block 5Vendor's shipping address block 5
VendorVendor.Ship Address CityCity of the vendor's shipping address
VendorVendor.Ship Address CountryCountry of the vendor's shipping address
VendorVendor.Ship Address Postal CodeZipcode of the vendor's shipping address
VendorVendor.Ship Address StateState of the vendor's shipping address
VendorVendor.Terms Full NameTerms full name that this vendor is referencing
VendorVendor.Terms List IDTerms identifier that this vendor is referencing
VendorVendor.Time CreatedTime created for the vendor
VendorVendor.Time ModifiedTime modified for the vendor
VendorVendor.Vendor Address 1Line 1 of the vendor address
VendorVendor.Vendor Address 2Line 2 of the vendor address
VendorVendor.Vendor Address 3Line 3 of the vendor address
VendorVendor.Vendor Address 4Line 4 of the vendor address
VendorVendor.Vendor Address 5Line 5 of the vendor address
VendorVendor.Vendor Address Block 1Vendor Address block 1
VendorVendor.Vendor Address Block 2Vendor Address block 2
VendorVendor.Vendor Address Block 3Vendor Address block 3
VendorVendor.Vendor Address Block 4Vendor Address block 4
VendorVendor.Vendor Address Block 5Vendor Address block 5
VendorVendor.Vendor Address CityCity on the vendor address
VendorVendor.Vendor Address CountryCountry on the employee address
VendorVendor.Vendor Address Postal CodeZipcodeon the employee address
VendorVendor.Vendor Address StateState on the employee address
VendorVendor.Vendor Eligible For 1099Flag to check if the vendor is eligible for 1099
VendorVendor.Vendor List IDIdentifier of this vendor
VendorVendor.Vendor Type Full NameVendor type full name that this vendor is referencing
VendorVendor.Vendor Type List IDVendor type identifier that this vendor is referencing
Vendor Additional ContactList IDVendor's secondary contact's list ID
Vendor Additional ContactVendor Full NameVendor's secondary contact's full name
Vendor Additional ContactSalutationVendor's secondary contact's salutation
Vendor Additional ContactFirst NameVendor's secondary contact's first name
Vendor Additional ContactMiddle NameVendor's secondary contact's middle name
Vendor Additional ContactLast NameVendor's secondary contact's last name
Vendor Additional ContactJob TitleVendor's secondary contact's job title
Vendor Additional ContactContact TypeVendor's secondary contact's type
Vendor Primary ContactList IDVendor's primary contact's list id
Vendor Primary ContactVendor Full NameVendor's primary contact's full name
Vendor Primary ContactSalutationVendor's primary contact's salutation
Vendor Primary ContactFirst NameVendor's primary contact's first name
Vendor Primary ContactMiddle NameVendor's primary contact's middle name
Vendor Primary ContactLast NameVendor's primary contact's last name
Vendor Primary ContactJob TitleVendor's primary contact's job title
Vendor Primary ContactContact TypeVendor's primary contact's type
Vendor Secondary ContactList IDVendor's secondary contact's list id
Vendor Secondary ContactVendor Full NameVendor's secondary contact's full name
Vendor Secondary ContactSalutationVendor's secondary contact's salutation
Vendor Secondary ContactFirst NameVendor's secondary contact's first name
Vendor Secondary ContactMiddle NameVendor's secondary contact's middle name
Vendor Secondary ContactLast NameVendor's secondary contact's last name
Vendor Secondary ContactJob TitleVendor's secondary contact's job title
Vendor Secondary ContactContact TypeVendor's secondary contact's type
Vendor To DoList IDVendor to do list id
Vendor To DoTime CreatedTimestamp on the vendor to do creation
Vendor To DoTime ModifiedTimestamp on the vendor to do modification
Vendor To DoNameUnique full name given to each vendor to do
Vendor To DoPriorityPriority given to each to do eg: low
Vendor To DoNotesDetails associated with each to do
Vendor To DoActiveVerifies if the vendor message is in active state
Vendor To DoDoneFlag to check the status of the current to do
Vendor To DoStatusStatus of the current to do, eg: active, done, inactive
Vendor To DoReminder DateDue date for the current to do
Vendor TypeTime CreatedTimestamp on the vendor type creation
Vendor TypeTime ModifiedTimestamp on the vendor type modification
Vendor TypeNameName of the vendor type
Vendor TypeFull NameFull name of the vendor type
Vendor TypeActiveFlag to check if the vendor type is active or not
Vendor TypeParent List IDParent id of the vendor type
Vendor TypeParent Full NameParent full name of the vendor type
Vendor TypeSub LevelNumerical value of where the vendor type belongs in the hiearchical structure
VendorNoteNote List IDID of a specific vendor note for an existing customer
VendorNoteVendor Full NameFull name of the vendor associated with a particular note
VendorNoteDateDate when the vendor note was created
Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published. Required fields are marked *



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022