For Quickbooks Advanced Reporting Consultants:
Table | Field Name | Description |
---|---|---|
Account | Time Created | TimeCreated |
Account | Time Modified | TimeModified |
Account | Name | Name |
Account | Full Name | FullName |
Account | Active | IsActive |
Account | Parent List ID | ParentListID |
Account | Parent Full Name | ParentFullName |
Account | Sub Level | Sublevel |
Account | Account Number | AccountNumber |
Account | Description | Desc |
Account | Balance | Balance |
Account | Currency List ID | CurrencyListID |
Account | Currency Full Name | CurrencyFullName |
Account | Class List ID | ClassListID |
Account | Class Full Name | ClassFullName |
Account | Online | IsOnline |
Account | Reimbursed | IsReimbursed |
Account | Reimbursed Account List ID | ReimbursedAccountListID |
Account | Reimbursed Account Full Name | ReimbursedAccountFullName |
Account | Balance Adjustment Exchange Rate | BalanceAdjustmentExchangeRate |
Account | Balance Home Amount | BalanceHomeAmount |
Class | Time Created | Timestamp on the class creation |
Class | Time Modified | Timestamp on the class modification |
Class | Name | Unique full name given to each class |
Class | Full Name | Unique full name given to each class |
Class | Active | Verifies if the class is in active state |
Class | Parent List ID | Parent id of this child item |
Class | Parent Full Name | Full name of the parent class |
Class | Sub Level | Integer showing what sub level this class is at |
Currency | Time Created | Timestamp on the currency creation |
Currency | Time Modified | Timestamp on the currency modification |
Currency | Name | Unique full name given to each currency |
Currency | Is Active | Verifies if the currency is in active state |
Currency | Currency Code | Unique code associated with the actual currency |
Currency | Thousand Separator | Character to separate every thousand in the currency field |
Currency | Decimal Places | Specifies how many decimal places the currency needs to be rounded to |
Currency | Decimal Separator | Character to separate every decimal in the currency field |
Currency | Is User Defined Currency | Currency full name that this customer is referencing |
Currency | Exchange Rate | Value of current currency used converted to desired currency |
Currency | As Of Date | Date to specify the exchange rate |
Currency | Gain Loss Account List ID | Account ID associated with this currency for posting gain or loss |
Currency | Gain Loss Account Full Name | Account name associated with this currency for posting gain or loss |
Customer | Customer.Active | Flag to check if the customer is active and make it visible on the UI |
Customer | Customer.Balance | Open balance of the customer |
Customer | Customer.Balance Home Amount | Balance in home country currency of this customer |
Customer | Customer.Bill Address 1 | Billing address 1 for the customer |
Customer | Customer.Bill Address 2 | Billing address 2 for the customer |
Customer | Customer.Bill Address 3 | Billing address 3 for the customer |
Customer | Customer.Bill Address 4 | Billing address 4 for the customer |
Customer | Customer.Bill Address 5 | Billing address 5 for the customer |
Customer | Customer.Bill Address Block 1 | Billing address block 1 for the customer |
Customer | Customer.Bill Address Block 2 | Billing address block 2 for the customer |
Customer | Customer.Bill Address Block 3 | Billing address block 3 for the customer |
Customer | Customer.Bill Address Block 4 | Billing address block 4 for the customer |
Customer | Customer.Bill Address Block 5 | Billing address block 5 for the customer |
Customer | Customer.Bill Address City | Billing address city for the customer |
Customer | Customer.Bill Address Country | Billing address country for the customer |
Customer | Customer.Bill Address Postal Code | Billing address zipcode for the customer |
Customer | Customer.Bill Address State | Billing address state for the customer |
Customer | Customer.Class Full Name | Total credit remaining in the customer's home currency |
Customer | Customer.Class List ID | Customer that’s relevant to the line id of the transaction |
Customer | Customer.Company Name | Message to the customer for a particular transaction |
Customer | Customer.Credit Limit | Confirms whether this transaction is taxable or not |
Customer | Customer.Currency Full Name | Flag if the discount is applied to the line of transaction |
Customer | Customer.Currency List ID | Refers to the the invoice due date |
Customer | Customer.Customer List ID | Estimated amount while creating an estimate |
Customer | Customer.Customer Type Full Name | true if charge/credit/billable/time has been put onto an invoice transaction |
Customer | Customer.Customer Type List ID | Flag to check if entire quantity is received for an order |
Customer | Customer.First Name | First Name of this customer |
Customer | Customer.Full Name | Full name for the customer |
Customer | Customer.Job Description | Job description of the job of this customer |
Customer | Customer.Job End Date | Job end date of this customer |
Customer | Customer.Job Projected End Date | Projected Job end date of this customer |
Customer | Customer.Job Start Date | Job start date of this customer eg: start date of remodelling for this customer |
Customer | Customer.Job Title | Job title of this customer |
Customer | Customer.Job Type Full Name | Full name of the job type that this customer is referencing |
Customer | Customer.Job Type List ID | Identifier of job type that this customer is referencing |
Customer | Customer.Last Name | Last name of this customer |
Customer | Customer.Middle Name | Middle name of this customer |
Customer | Customer.Name | Name for the customer |
Customer | Customer.Parent Full Name | Full name of the parent customer |
Customer | Customer.Parent List ID | Parent id of this customer |
Customer | Customer.Preferred Delivery Method | PreferredDeliveryMethod that this customer has requested |
Customer | Customer.Preferred Payment Method Full Name | Preferred payment method full name that this customer is referencing |
Customer | Customer.Preferred Payment Method List ID | Preferred payment method id that this customer is referencing |
Customer | Customer.Price Level Full Name | Price level full name that this customer is referencing |
Customer | Customer.Price Level List ID | Price level identifier that this customer is referencing |
Customer | Customer.Sales Rep Full Name | Sales rep full name that this customer is referencing |
Customer | Customer.Sales Rep List ID | Sales rep id that this customer is referencing |
Customer | Customer.Sales Tax Code Full Name | Sales tax code full name that this customer is referencing |
Customer | Customer.Sales Tax Code List ID | Sales tax code id that this customer is referencing |
Customer | Customer.Salutation | Salutation of this customer |
Customer | Customer.Sub Level | Numerical value of where the customer belongs in the hiearchical structure |
Customer | Customer.Terms Full Name | Terms full name that this customer is referencing |
Customer | Customer.Terms List ID | Terms identifier that this customer is referencing |
Customer | Customer.Time Created | Time created for the customer |
Customer | Customer.Time Modified | Time modified for the customer |
Customer Additional Contact | List ID | Customer's additional contact's list id |
Customer Additional Contact | Customer Full Name | Customer's additional contact's full name |
Customer Additional Contact | Salutation | Customer's additional contact's salutation |
Customer Additional Contact | First Name | Customer's additional contact's first name |
Customer Additional Contact | Middle Name | Customer's additional contact's middle name |
Customer Additional Contact | Last Name | Customer's additional contact's last name |
Customer Additional Contact | Job Title | Customer's additional contact's job title |
Customer Additional Contact | Contact Type | Customer's additional contact's type |
Customer Message | Time Created | Timestamp on the customer message creation |
Customer Message | Time Modified | Timestamp on the customer message modification |
Customer Message | Name | Unique full name given to each customer message |
Customer Message | Is Active | Verifies if the customer message is in active state |
Customer Note | Note List ID | ID of a specific customer note for an existing customer |
Customer Note | Customer Full Name | Full name of the customer associated with a particular note |
Customer Note | Date | Date when the customer note was created |
Customer Primary Contact | List ID | Customer's primary contact's list id |
Customer Primary Contact | Customer Full Name | Customer's primary contact's full name |
Customer Primary Contact | Salutation | Customer's primary contact's salutation |
Customer Primary Contact | First Name | Customer's primary contact's first name |
Customer Primary Contact | Middle Name | Customer's primary contact's middle name |
Customer Primary Contact | Last Name | Customer's primary contact's last name |
Customer Primary Contact | Job Title | Customer's primary contact's job title |
Customer Primary Contact | Contact Type | Customer's primary contact's type |
Customer Secondary Contact | List ID | Customer's secondary contact's list id |
Customer Secondary Contact | Customer Full Name | Customer's secondary contact's full name |
Customer Secondary Contact | Salutation | Customer's secondary contact's salutation |
Customer Secondary Contact | First Name | Customer's secondary contact's first name |
Customer Secondary Contact | Middle Name | Customer's secondary contact's middle name |
Customer Secondary Contact | Last Name | Customer's secondary contact's last name |
Customer Secondary Contact | Job Title | Customer's primary contact's job title |
Customer Secondary Contact | Contact Type | Customer's secondary contact's type |
Customer To Do | List ID | Customer to do list id |
Customer To Do | Time Created | Timestamp on the Customer to do creation |
Customer To Do | Time Modified | Timestamp on the customer to do modification |
Customer To Do | Name | Unique full name given to each customer to do |
Customer To Do | Priority | Priority given to each to do eg: low |
Customer To Do | Notes | Details associated with each to do |
Customer To Do | Is Active | Verifies if the customer message is in active state |
Customer To Do | Is Done | Flag to check the status of the current to do |
Customer To Do | Status | Status of the current to do, eg: active, done, inactive |
Customer To Do | Reminder Date | Due date for the current to do |
Customer Type | Time Created | Timestamp on the customer type creation |
Customer Type | Time Modified | Timestamp on the customer type modification |
Customer Type | Name | Unique name given to each customer type: eg Wholesale, retailer |
Customer Type | Full Name | Unique full name given to each customer type |
Customer Type | Is Active | Verifies if the customer type is in active state |
Customer Type | Parent List ID | Parent ID of customer type child item |
Customer Type | Parent Full Name | Parent name of the customer type child |
Customer Type | Sublevel | Numerical value of where the field belongs in the hiearchical structure |
Employee | Account Number | Job description of the job of this customer |
Employee | Active | Flag to check if the item is active or inactive |
Employee | Alt Phone | Alternate phone number of the employee |
Employee | Birth Date | Birth date of the employee |
Employee | Company Name | Company name of the employee that is being referred to |
Employee | Email address of the empployee | |
Employee | Employee Address 1 | Line 1 of the employee address |
Employee | Employee Address 2 | Line 2 of the employee address |
Employee | Employee Address 3 | Line 3 of the employee address |
Employee | Employee Address 4 | Line 4 of the employee address |
Employee | Employee Address City | City on the employee address |
Employee | Employee Address Country | Country on the employee address |
Employee | Employee Address Postal Code | Zipcodeon the employee address |
Employee | Employee Address State | State on the employee address |
Employee | Employee List ID | Employee id where the particular employee is referenced |
Employee | Employee Type | Type of employee in the employee table |
Employee | Fax | Fax number of the employee |
Employee | First Name | First Name of the employee |
Employee | Gender | Gender of the employee |
Employee | Hired Date | Hiring date of the employee |
Employee | Initials | Initials of the employee |
Employee | IsSalesRepActive | Flag to check if a particular employee who is a sales representative is active or not |
Employee | Last Name | Last Name of the employee |
Employee | Middle Name | Middle Name of the employee |
Employee | Mobile | Cell phone number of the employee |
Employee | Name | Display Name of the employee |
Employee | Notes | Notes on an employee |
Employee | Pager | Pager number of the employee |
Employee | Pager PIN | Pager pin number of the employee |
Employee | Phone | Home phone of the employee |
Employee | Released Date | Date when the employee was released |
Employee | Employee.SalesRepInitial | Initials of the employee sales representative |
Employee | Employee.Salutation | Projected Job end date of this customer |
Employee | Employee.Sick Hours Accrual Period | Time period specifying when the sick hours were accrued for an employee |
Employee | Employee.Sick Hours Accrual Start Date | Date when the sick hours start getting accrued for an employee |
Employee | Employee.Sick Hours Accrued | Total number of sick hours accrued during a pay period for an employee |
Employee | Employee.Sick Hours Available | Number of sick hours available for an employee |
Employee | Employee.Sick Hours Is Resetting Hours Each New Year | Flag to check if the sick hours are getting reset after every year |
Employee | Employee.Sick Hours Maximum | Refers to the maximum number of sick hours an employee can accumulate |
Employee | Employee.Sick Hours Used | Number of sick hours used up by the employee |
Employee | Employee.Time Created | Creation time of the employee |
Employee | Employee.Time Modified | Modification time of an employee |
Employee | Employee.Title | Title of the employee |
Employee | Employee.Vacation Hours Accrual Period | Time period specifying when the vacation hours were accrued for an employee |
Employee | Employee.Vacation Hours Accrual Start Date | Date when the vacation hours start getting accrued for an employee |
Employee | Employee.Vacation Hours Accrued | Total number of vacation hours accrued during a pay period for an employee |
Employee | Employee.Vacation Hours Available | Number of vacation hours available for an employee |
Employee | Employee.Vacation Hours Maximum | Refers to the maximum number of vacation hours an employee can accumulate |
Employee | Employee.Vacation Hours Used | Number of vacation hours used up by the employee |
Employee | Employee.Vacation Is Resetting Hours Each New Year | Flag to check if the vacation hours are getting reset after every year |
Employee Additional Contact | List ID | Vendor's other contact's list id |
Employee Additional Contact | Employee Full Name | Employee's additional contact's full name |
Employee Additional Contact | Salutation | Employee's additional contact's salutation |
Employee Additional Contact | First Name | Employee's additional contact's first name |
Employee Additional Contact | Middle Name | Employee's additional contact's middle name |
Employee Additional Contact | Last Name | Employee's additional contact's last name |
Employee Additional Contact | Job Title | Employee's additional contact's job title |
Employee Additional Contact | Contact Type | Employee's additional contact's type |
Employee Earnings | Rate | Edlist that represents the employee pay rate |
Employee To Do | List ID | Employee to do list id |
Employee To Do | Time Created | Timestamp on the Employee to do creation |
Employee To Do | TimeModified | Timestamp on the Employee to do modification |
Employee To Do | Name | Unique full name given to each Employee to do |
Employee To Do | Priority | Priority given to each to do eg: low |
Employee To Do | Notes | Details associated with each to do |
Employee To Do | Active | Verifies if the vendor Employee is in active state |
Employee To Do | Done | Flag to check the status of the current to do |
Employee To Do | Status | Status of the current to do, eg: active, done, inactive |
Employee To Do | Reminder Date | Due date for the current to do |
Inventory Site | Inventory Site List ID | ID list of the inventory site |
Inventory Site | Time Created | Timestamp on the inventory site creation |
Inventory Site | Time Modified | Timestamp on the inventory site modification |
Inventory Site | Name | Name of the inventory site |
Inventory Site | Full Name | Full name of the inventory site |
Inventory Site | Active | Flag to check if the inventory site is active or not |
Inventory Site | Parent Site List ID | Parent id of the inventory site |
Inventory Site | Parent Site Full Name | Parent full name of the inventory site |
Inventory Site | Sub Level | Numerical value of where the site belongs in the hiearchical structure |
Inventory Site | Site Description | Text about site description of an inventory site |
Inventory Site | Contact | Contact person on the inventory site |
Inventory Site | Phone | Phone info of the contact person on the inventory site |
Inventory Site | Fax | Fax info of the contact person on the inventory site |
Inventory Site | Email info of the contact person on the inventory site | |
Inventory Site | Site Address 1 | Address line 1 of the inventory site |
Inventory Site | Site Address 2 | Address line 2 of the inventory site |
Inventory Site | Site Address 3 | Address line 3 of the inventory site |
Inventory Site | Site Address 4 | Address line 4 of the inventory site |
Inventory Site | Site Address 5 | Address line 5 of the inventory site |
Inventory Site | Site Address City | City of the inventory site |
Inventory Site | Site Address State | State of the inventory site |
Inventory Site | Site Address Postal Code | Zipcode of the inventory site |
Inventory Site | Site Address Country | Country of the inventory site |
Inventory Site | Site Address Block 1 | Address block 1 of the inventory site |
Inventory Site | Site Address Block 2 | Address block 2 of the inventory site |
Inventory Site | Site Address Block 3 | Address block 3 of the inventory site |
Inventory Site | Site Address Block 4 | Address block 4 of the inventory site |
Inventory Site | Site Address Block 5 | Address block 5 of the inventory site |
Inventory Site Location | Inventory Site Location List ID | List of the inventory site location |
Inventory Site Location | Time Created | Timestamp on the inventory site location creation |
Inventory Site Location | Time Modified | Timestamp on the inventory site location modification |
Inventory Site Location | Name | Name of the inventory site location |
Inventory Site Location | Full Name | Full Name of the inventory site location |
Inventory Site Location | Active | Flag to check if the inventory site location is active or not |
Inventory Site Location | Parent Site List ID | Parent id of the inventory site location |
Inventory Site Location | Parent Site Full Name | Parent Name of the inventory site location |
Inventory Site Location | Sub Level | Numerical value of where the site location belongs in the hiearchical structure |
Inventory Site Location | Site Description | Text about site description of an inventory site location |
Inventory Site Location | Contact | Contact person on the inventory site location |
Inventory Site Location | Phone | Phone info of the contact person on the inventory site location |
Inventory Site Location | Fax | Fax info of the contact person on the inventory site location |
Inventory Site Location | Email info of the contact person on the inventory site location | |
Inventory Site Location | Site Address 1 | Address line 1 of the inventory site location |
Inventory Site Location | Site Address 2 | Address line 2 of the inventory site location |
Inventory Site Location | Site Address 3 | Address line 3 of the inventory site location |
Inventory Site Location | Site Address 4 | Address line 4 of the inventory site location |
Inventory Site Location | Site Address 5 | Address line 5 of the inventory site location |
Inventory Site Location | Site Address City | City of the inventory site location |
Inventory Site Location | Site Address State | State of the inventory site location |
Inventory Site Location | Site Address Postal Code | Zipcode of the inventory site location |
Inventory Site Location | Site Address Country | Country of the inventory site location |
Inventory Site Location | Site Address Block 1 | Address block 1 of the inventory site location |
Inventory Site Location | Site Address Block 2 | Address block 2 of the inventory site location |
Inventory Site Location | Site Address Block 3 | Address block 3 of the inventory site location |
Inventory Site Location | Site Address Block 4 | Address block 4 of the inventory site location |
Inventory Site Location | Site Address Block 5 | Address block 5 of the inventory site location |
Inventory Site Location | Inventory Site Location Full Name | Full name of the inventory site location as referenced in the item site location table |
Item | Account Full Name | Name of the account that this item is referencing |
Item | Account List ID | ID of the account that this item is referencing |
Item | Active | Flag to check if the item is active or inactive, where ACTIVE=1 and INACTIVE=0 |
Item | Asset Account Full Name | Name of asset account that this item is referencing |
Item | Asset Account List ID | ID for the asset account that this item is referencing |
Item | Asset Description | Description of fixed asset item |
Item | Asset Number | Unique asset number for the item |
Item | Average Cost | Current average cost based on all purchases for that item |
Item | Bar Code Value | Bar code of the item |
Item | Build Point | Number assigned to remind when to build |
Item | Class Full Name | Full name of the class |
Item | Class List ID | Class ID where the item references |
Item | COGS Account Full Name | Name of the cost of good sold account that this item is referencing |
Item | COGS Account List ID | ID for the cost of goods sold account that this item is referencing |
Item | Deposit To Account Full Name | Name of deposit account this item is referencing |
Item | Deposit To Account List ID | ID of deposit account this item is referencing |
Item | Discount Item List ID | ID of the discounted item |
Item | Discount Rate | Rate of the discount on an item ($$) |
Item | Discount Rate Percent | Rate of the discount on an item (%) |
Item | Expense Account Full Name | Name of the expense account for this item |
Item | Expense Account List ID | ID of the expense account for this item |
Item | Fixed Asset Item List ID | ID of this fixed asset item |
Item | Fixed Asset Sales Date | Sales date of the fixed asset item |
Item | Fixed Asset Sales Description | Sales description of the fixed asset item |
Item | Fixed Asset Sales Expense | Sales expense of the fixed asset item |
Item | Fixed Asset Sales Price | Sales price of the fixed asset item |
Item | Full Name | Full name of the item |
Item | Income Account Full Name | Name of an income account that this item is referencing |
Item | Income Account List ID | ID of an income account that this item is referencing |
Item | Inventory Assembly Item List ID | ID of the assembly itself |
Item | Inventory Item List ID | Identifier for an inventory type item in an item list |
Item | Item Description | Text in Item description field |
Item | Item List ID | Identifier for an item in item list |
Item | Item Type | Type of item such as service, non-inventory, assembly |
Item | Location | Location of item |
Item | Manufacturer Part Number | Manufacturing part number of that item |
Item | Name | Display Name of the item |
Item | Non Inventory Item List ID | ID of the non-inventory item |
Item | Notes | Notes section for the item |
Item | Other Item Charge List ID | ID of the Other Charge item |
Item | Parent Full Name | Full name of the parent item |
Item | Parent List ID | Parent ID of the child item |
Item | Payment Item List ID | ID of payment item this item is referencing |
Item | Payment Method Full Name | Name of payment method this item is referencing |
Item | Payment Method List ID | ID of payment method this item is referencing |
Item | Pending Assembly Quantity | Numerical value assigned to quantity for assembly item on pending billed transactions |
Item | Preferred Vendor Full Name | Name of the preferred vendor that this item is referencing |
Item | Preferred Vendor List ID | ID for the preferred vendor that this item is referencing |
Item | Purchase Cost | Purchase cost of an item from a vendor |
Item | Purchase Description | Text for purchase description of an item |
Item | Quantity On Hand | Current quantity on hand of this item |
Item | Quantity On Order | Current Quantity on purchase order for item |
Item | Quantity On Sales Order | Current Quantity on sales order for item |
Item | Reorder Point | Number assigned to remind when to reorder |
Item | Sales Description | Text for sales description of an item |
Item | Sales Price | Sales price of the item |
Item | Sales Price Percent | Percentage of mark up over cost for an item |
Item | Sales Tax Code Full Name | Name of the sales tax code that this item is referencing |
Item | Sales Tax Code List ID | ID of the sales tax code that this item is referencing |
Item | Serial Number | Serial number of the item |
Item | Sub Level | Numerical value of where the item belongs in the hiearchical structure |
Item | Subtotal Item List ID | ID of the subtotal of this item |
Item | Time Created | Creation time of the item |
Item | Time Modified | Modification time of an item |
Item | Unit Of Measure Set Full Name | Name of the unit of measure that this item is referencing |
Item | Unit Of Measure Set List ID | ID of the unit of measure that this item is referencing |
Item | Value On Hand Amount | Current valued dollar ($) amount on hand for this item |
Item | Vendor Or Payee Name | Vendor or payee name of the fixed asset item |
Item | Warranty Expiry Date | Expiration date of the warranty for the item |
Item Group Component | Item Group Full Name | Full name of a specific group having multiple items |
Item Group Component | Item Type | Item type of an item which is part of a specific group having multiple items |
Item Group Component | Item List ID | ID of an item which is part of a specific group having multiple items |
Item Group Component | Item Full Name | Full name of an item which is part of a specific group having multiple items |
Item Group Component | Quantity | Quantity of an item which is part of a specific group having multiple items |
Item Group Component | Unit Of Measure Unit List ID | List ID of unit of measure of an item which is part of a specific group having multiple items |
Item Group Component | Unit Of Measure Unit Full Name | Full name of unit of measure of an item which is part of a specific group having multiple items |
Item History | Average Cost | Average cost of the item as referenced in the item history table |
Item History | Item Full Name | Full name of the item in the item history table |
Item History | Item List ID | Identifier for an item in item history list |
Item History | Quantity On Hand | Quantity on hand for an item as referenced in the item history table |
Item History | Time Created | Creation time of the item as referenced in the item history table |
Item History | Time Modified | Modification time of an item as referenced in the item history table |
Item History | Txn Date | Transaction date of the transaction as referenced in the item history table |
Item History | Txn ID | Transaction id of the transaction in the item history table |
Item History | Value On Hand | Value of the item on hand as referenced in the item history table |
Item Inventory Assembly Component | Item Inventory Assembly Full Name | Full name of an inventory assembly item |
Item Inventory Assembly Component | Item Type | Specifies the item type of an inventory assembly item |
Item Inventory Assembly Component | Item List ID | ID of a specific inventory assembly item |
Item Inventory Assembly Component | Item Full Name | Full name of an item which is part of inventory assembly item |
Item Inventory Assembly Component | Quantity | Quantity of an inventory assembly item |
Item Inventory Assembly Component | Unit Of Measure Unit List ID | ID of the Unit of measure for a specific inventory assembly item |
Item Inventory Assembly Component | Unit Of Measure Unit Full Name | Name of the Unit of measure for a specific inventory assembly item |
Item Sales Tax | Item Sales Tax List ID | Id of the item sales tax list |
Item Sales Tax | Time Created | Timestamp of a specific sales tax item creation |
Item Sales Tax | Time Modified | Timestamp of a specific sales tax item modification |
Item Sales Tax | Name | Name of a specific sales tax item |
Item Sales Tax | Active | Flag to check if a specific sales tax item is active or not |
Item Sales Tax | Item Description | Description of an item under with type as sales tax item |
Item Sales Tax | Tax Rate | Tax rate of an item under with type as sales tax item |
Item Sales Tax | Tax Vendor List ID | Tax agency (vendor that tax is collected for) of an item under with type as sales tax item |
Item Sales Tax | Tax Vendor Full Name | Full name of the tax agency for an item for which tax is being collected |
Item Sales Tax | Notes | Notes for a sales tax item |
Item Site | List ID | List of the item site |
Item Site | Time Created | Timestamp on the inventory site creation |
Item Site | Time Modified | Timestamp on the inventory site modification |
Item Site | Inventory Assembly Item List ID | List of the inventory assembly item |
Item Site | Item Inventory Assembly Full Name | Full name of the inventory assembly item |
Item Site | ItemInventoryFullName | Full name of the inventory non-assembly item |
Item Site | Inventory Site Full Name | Full name of the inventory site |
Item Site | Reorder Level | Number assigned to remind when to reorder at the item site |
Item Site | Quantity On Hand | Quantity on hand for an item at the item site |
Item Site | Quantity On Purchase Orders | Quantity of item on purchase order at item site |
Item Site | Quantity On Sales Orders | Quantity of item on sales order at item site |
Item Site | Reorder Inventory Quantity | Quantity for reordering to replenish the inventory at the item site |
Item Site | Reorder Assembly Quantity | Quantity for reordering to replenish assembly item at the item site |
Item Site Location | List ID | Edlist of the item site location |
Item Site Location | Time Created | Timestamp on the item site location creation |
Item Site Location | Time Modified | Timestamp on the item site location modification |
Item Site Location | Inventory Assembly Item List ID | Edlist of the inventory assembly item as referenced in the item site location table |
Item Site Location | Item Inventory Assembly Full Name | Full name of the inventory assembly item as referenced in the item site location table |
Item Site Location | ItemInventoryFullName | Full name of the inventory item as referenced in the item site location table |
Item Site Location | Inventory Site List ID | Edlist of the inventory site as referenced in the item site location table |
Item Site Location | Inventory Site Full Name | Full name of the inventory site as referenced in the item site location table |
Item Site Location | Inventory Site Location Full Name | Full name of the inventory site location as referenced in the item site location table |
Item Site Location | Reorder Level | Number assigned to remind when to reorder at the item site location |
Item Site Location | Quantity On Hand | Quantity on hand for an item at the item site location |
Item Site Location | Quantity On Purchase Orders | Quantity of item on purchase order at item site location |
Item Site Location | Quantity On Sales Orders | Quantity of item on sales order at item site location |
Item Site Location | Default Purchase Bin List ID | Refers to the list id of the default bin the purchase is to be made from |
Item Site Location | Default Purchase Bin Full Name | Refers to the full name of the default bin the purchase is to be made from |
Item Site Location | Default Sales Bin List ID | Refers to the list id of the default bin the sales is to be made from |
Item Site Location | Default Sales Bin Full Name | Refers to the full name of the default bin the sales is to be made from |
Item Site Location | Reorder Inventory Quantity | Number assigned to remind when to reorder inventory item at the item site location |
Item Site Location | Reorder Assembly Quantity | Number assigned to remind when to reorder assembly item at the item site location |
Item Unit Of Measure Set | Time Created | Timestamp on the unit of measure set creation |
Item Unit Of Measure Set | Time Modified | Timestamp on the unit of measure set modification |
Item Unit Of Measure Set | Name | Customer specified name for a unit of measure set |
Item Unit Of Measure Set | Active | Flag to check if the specific unit of measure set is active or not |
Item Unit Of Measure Set | Unit Of Measure Type | Name for a specific unit of measure type eg: count, length, weight |
Item Unit Of Measure Unit | Name | Name of a specific unit of measure |
Item Unit Of Measure Unit | Abbreviation | Abbreviation of a specific unit of measure |
Item Unit Of Measure Unit | Base Unit | Flag to check of the specific unit of measure set is a base unit or not |
Item Unit Of Measure Unit | Purchase Default Unit | Flag to check if the unit of measure set has default unit set for purchases |
Item Unit Of Measure Unit | Sales Default Unit | Flag to check if the unit of measure set has default unit set for sales |
Item Unit Of Measure Unit | Shipping Default Unit | Flag to check if the unit of measure set has default unit set for shipping |
Job Type | Time Created | Timestamp on the job type creation |
Job Type | Time Modified | Timestamp on the job type modification |
Job Type | Name | Name for a specific job type |
Job Type | Full Name | Full name for a specific job type |
Job Type | Active | Flag to check if a particular job type is active or not |
Job Type | Parent List ID | Parent id of the specific job type |
Job Type | Parent Full Name | Parent full name of the specific job type |
Job Type | Sub Level | Numerical value of where the job type belongs in the hiearchical structure |
Lead | Lead List ID | Unique ID given to each lead in the lead list |
Lead | Time Created | Timestamp on the lead creation |
Lead | Time Modified | Timestamp on the lead modification |
Lead | Full Name | Full name of the inventory assembly item |
Lead | Company Name | Company name that is associated to a particular lead |
Lead | Active | Verifies if the lead is in active state |
Lead | Status | Full name of the inventory non-assembly item |
Lead | Main Phone | Main phone number on the lead |
Lead Additional Contact | ListID | List id of the of the additional contact on the lead |
Lead Additional Contact | Lead Full Name | Full name of the of the additional contact on the lead |
Lead Additional Contact | Salutation | Salutation of the of the additional contact on the lead |
Lead Additional Contact | First Name | First name of the of the additional contact on the lead |
Lead Additional Contact | Middle Name | Middle name of the of the additional contact on the lead |
Lead Additional Contact | Last Name | Last name of the of the additional contact on the lead |
Lead Additional Contact | Job Title | Job title of the of the additional contact on the lead |
Lead Additional Contact | Contact Type | Contact type of the of the additional contact on the lead |
Other Name | Account Number | Account number of the other name |
Other Name | Other Name Address Country | Country on the other address |
Other Name | Active | Flag to check if the other name is active and make it visible on the UI |
Other Name | Alt Contact | Alternate Contact name of the other name |
Other Name | Alt Phone | Alternate phone number of the other name |
Other Name | Company Name | Company name of the other name |
Other Name | Contact | Contact name of the other name |
Other Name | Email of the other name | |
Other Name | Fax | Fax number of the other name |
Other Name | First Name | First name of the other name |
Other Name | Initials | Initials of the other name |
Other Name | Last Name | Last name of the other name |
Other Name | Middle Name | Middle name of the other name |
Other Name | Mobile | Cell phone number of the other name |
Other Name | Name | Name of other name edlist |
Other Name | Non Employee Pay Period End Date | ????????? |
Other Name | Notes | Notes for the other name |
Other Name | Open Date | ????????? |
Other Name | Other List ID | Identifier for the other name in the other name list |
Other Name | Other Name Address 1 | Line 1 of the other address |
Other Name | Other Name Address 2 | Line 2 of the other address |
Other Name | Other Name Address 3 | Line 3 of the other address |
Other Name | Other Name Address 4 | Line 4 of the other address |
Other Name | Other Name Address 5 | Line 5 of the other address |
Other Name | Other Name Address Block 1 | Block 1 of the other address |
Other Name | Other Name Address Block 2 | Block 2 of the other address |
Other Name | Other Name Address Block 3 | Block 3 of the other address |
Other Name | Other Name Address Block 4 | Block 4 of the other address |
Other Name | Other Name Address Block 5 | Block 5 of the other address |
Other Name | Other Name Address City | City on the other address |
Other Name | Other Name Address Postal Code | Zipcodeon the other address |
Other Name | Other Name Address State | State on the other address |
Other Name | Pager | Pager number of the other name |
Other Name | Pager PIN | Pagerpin number of the other name |
Other Name | Phone | Home phone number of the other name |
Other Name | Sales Rep List ID | Identifier of this other name in the sales rep list |
Other Name | Time Created | Time created for the other list |
Other Name | Time Modified | Modified time for the other list |
Other Name | Title | Title of the other name |
Other Name | Salutation | Salutation of the other name |
Other Name | IsSalesRepActive | Flag to check if a particular sales representative in th other name table is active or not |
Other Name | SalesRepInitial | Initials of the other sales representative |
Other Name | Other List ID | Identifier for the other name in the other name list |
Other Name Additional Contact | List ID | Vendor's other contact's list id |
Other Name Additional Contact | Other Full Name | Vendor's other contact's full name |
Other Name Additional Contact | Salutation | Vendor's other contact's salutation |
Other Name Additional Contact | First Name | Vendor's other contact's first name |
Other Name Additional Contact | Middle Name | Vendor's other contact's middle name |
Other Name Additional Contact | Last Name | Vendor's other contact's last name |
Other Name Additional Contact | Job Title | Vendor's other contact's job title |
Other Name Additional Contact | Contact Type | Vendor's other contact's type |
Price Level | Price Level List ID | ID of the price level list |
Price Level | Time Created | Timestamp on the pricelevel edlist creation |
Price Level | Time Modified | Timestamp on the pricelevel edlist modification |
Price Level | Name | Name of a customer defined price level |
Price Level | Price Level Type | Price level type of a specific price level |
Price Level | Price Level Fixed Percentage | Percentage to be set if the customer needs to increase or decrease sales price |
Price Level | Active | Flag to check if the price level is active or not |
Price Level | Currency List ID | Currency list that the specific price level is referencing |
Price Level | Currency Full Name | Currency full name that the specific price level is referencing |
Price Level | Round Offset | Specifies upto what decimal the price level should be rounded |
Price Level | Round To Amount | Specifies upto what dollar amount the price level should be rounded |
Price Level | Rounding Method Type | Specifies what rounding type is used, eg: user defined, decimal |
Price Level Item | Price Level Full Name | Full name of a specific price level item |
Sales Rep | Time Created | Timestamp on the new sales representative creation |
Sales Rep | Time Modified | Timestamp on the sales representative modification |
Sales Rep | Initial | Initials of a particular sales rep |
Sales Rep | Active | Flag to check if a sales rep is active or not |
Sales Rep | Sales Rep Entity List ID | ID of the sales rep list |
Sales Rep | Sales Rep Entity Full Name | Full name of a particular sales rep entity |
Sales Rep | Sales Rep Entity Type | Specifies the type of sales rep eg: vendor, employee, other name |
Serial Number | ID | Serial number id for an item |
Serial Number | Name | Serial number name for an item |
Serial Number | Remaining Quantity | Integer showing the remaining quantity of an item with a particular serial number |
Serial Number | Item Full Name | Full name of an item with a particular serial number |
Serial Number | Item Type | Item type of an item with a particular serial number |
Serial Number | Inventory Site List ID | Edlist of the inventory site which has an item with a particular serial number |
Serial Number | Inventory Site Full Name | Full name of the inventory site which has an item with a particular serial number |
Serial Number | Inventory Site Location List ID | Edlist of the inventory site location which has an item with a particular serial number |
Serial Number | Inventory Site Location Full Name | Full name of the inventory site location which has an item with a particular serial number |
Ship To | Name | Name of the multiple ship to record for a customer |
Ship To | Address 1 | Address line 1 of the multiple ship to record for a customer |
Ship To | Address 2 | Address line 2 of the multiple ship to record for a customer |
Ship To | Address 3 | Address line 3 of the multiple ship to record for a customer |
Ship To | Address 4 | Address line 4 of the multiple ship to record for a customer |
Ship To | Address 5 | Address line 5 of the multiple ship to record for a customer |
Ship To | City | City of the multiple ship to record for a customer |
Ship To | State | State of the multiple ship to record for a customer |
Ship To | Postal Code | Zip code of the multiple ship to record for a customer |
Ship To | Country | Country of the multiple ship to record for a customer |
Ship To | Block Address 1 | Non-parsible address line 1 which is to be stored in a block address line 1 |
Ship To | Block Address 2 | Non-parsible address line 2 which is to be stored in a block address line 2 |
Ship To | Default Ship To | Flag to choose default ship to address to be associated with the customer |
Ship To | Block Address 3 | Non-parsible address line 3 which is to be stored in a block address line 3 |
Ship To | Block Address 4 | Non-parsible address line 4 which is to be stored in a block address line 4 |
Ship To | Block Address 5 | Non-parsible address line 5 which is to be stored in a block address line 5 |
Shipping Method | Time Created | Timestamp on the shipping method edlist object creation |
Shipping Method | Time Modified | Timestamp on the shipping method edlist modification |
Shipping Method | Name | Unique full name given to each shipping method |
Shipping Method | Active | Verifies if the shipping method is in active state |
Term | Active | Verifies if the term is in active state |
Term | Day Of Month Due | Specifies up to which date of the month for net due in the payment terms |
Term | Discount Day Of Month | Specifies the date of the month for which discount is given if the amount is paid by then |
Term | Discount Pct | Discount percentage associated with the payment terms |
Term | Due Next Month Days | Specifies the number of days in the month of the due date |
Term | Name | Unique full name given to each term |
Term | Standard Discount Days | Integer for the number of days if you need to avail the discount (Std term type) |
Term | Standard Due Days | Integer for the number of days that this term specifies a payment is due |
Term | Time Created | Timestamp on the terms edlist object creation |
Term | Time Modified | Timestamp on the terms edlist modification |
Term | Type | Integer to determine if it’s a date driven or standard term |
Transaction | Address 1 | Line 1 of the address on a trasaction |
Transaction | Address 2 | Line 2 of the address on a trasaction |
Transaction | Address 3 | Line 3 of the address on a trasaction |
Transaction | Address 4 | Line 4 of the address on a trasaction |
Transaction | Address 5 | Line 5 of the address on a trasaction |
Transaction | Address Block 1 | Address block 1 on the transaction |
Transaction | Address Block 2 | Address block 2 on the transaction |
Transaction | Address Block 3 | Address block 3 on the transaction |
Transaction | Address Block 4 | Address block 4 on the transaction |
Transaction | Address Block 5 | Address block 5 on the transaction |
Transaction | Address City | City on the address on a trasaction |
Transaction | Address Country | Country on the address on a trasaction |
Transaction | Address Postal Code | Zip code on the address on a trasaction |
Transaction | Address State | State on the address on a trasaction |
Transaction | Amount | Amount (without sign) for transactions (includes all transaction types) |
Transaction | Amount with Sign | Amount (with sign) for only posting transactions |
Transaction | Amount Due In Home Currency | (Multi-currency) Home currency value for that transaction |
Transaction | Applied Discount | Flag if the discount is applied or not for account |
Transaction | Applied To Txn Amount | Actual amount that is applied to the transaction |
Transaction | Applied To Txn Date | Only valid for ReceivePayment Transactions. Shows the date on which discounts were applied to the payment. |
Transaction | Applied To Txn ID | Identifier to transaction that is being paid |
Transaction | Applied To Txn Ref Number | User entered ID attached to the transaction being paid |
Transaction | Applied To Txn Type | Type of transaction that is being paid |
Transaction | Ar Ap | Flag to check payment status of Accounts Receivable/Accounts Payable account |
Transaction | Balance Remaining | Current balance remaining on a transaction |
Transaction | Balance Remaining In Home Currency | Current balance remaining on a transaction in home country currency |
Transaction | Bank Account Type | Type of bank account such as checking , savings, etc |
Transaction | Bank Ref Name | Bank nickname |
Transaction | Begin Balance | Flag to check if there is non-zero beginning balance, where YES=1 and NO=0 |
Transaction | Bill Address 1 | Billing address 1 for the transaction |
Transaction | Bill Address 2 | Billing address 2 for the transaction |
Transaction | Bill Address 3 | Billing address 3 for the transaction |
Transaction | Bill Address 4 | Billing address 4 for the transaction |
Transaction | Bill Address 5 | Billing address 5 for the transaction |
Transaction | Bill Address Block 1 | Billing address block 1 for the transaction |
Transaction | Bill Address Block 2 | Billing address block 2 for the transaction |
Transaction | Bill Address Block 3 | Billing address block 3 for the transaction |
Transaction | Bill Address Block 4 | Billing address block 4 for the transaction |
Transaction | Bill Address Block 5 | Billing address block 5 for the transaction |
Transaction | Bill Address City | Billing address city for the transaction |
Transaction | Bill Address Country | Billing address country for the transaction |
Transaction | Bill Address Postal Code | Billing address zip code for the transaction |
Transaction | Bill Address State | Billing address state for the transaction |
Transaction | Billed | Flag to check if the customer has been billed, where YES=1 and NO=0 |
Transaction | Billed Date | Date when the transaction is billed |
Transaction | Build | Flag to check if the assembly is built or not, where YES=1 and NO=0 |
Transaction | Check Number | Unique number for check |
Transaction | Class List ID | Used for reference if you track class (enabled by preference) - can be per line or header. |
Transaction | COGS Amount | Number of Items Sold multiplied by the Average Cost of Item |
Transaction | Cost | Cost of an item |
Transaction | Credit Amount In Home Currency | (Multi-currency) The credit amount in home currency |
Transaction | CreditRemainingInHomeCurrency | Total credit remaining in the customer's home currency |
Transaction | Customer List ID | Customer ID that’s in the transaction |
Transaction | Customer Msg List ID | ID for the message to the customer for a particular transaction |
Transaction | Customer Sales Tax Code List ID | ID that confirms whether this transaction is taxable or not |
Transaction | Debit Or Credit | Distinguishes between debit or credit amount type |
Transaction | Delivery Date | Delivery date for the items in a transaction |
Transaction | Deposited | Shows YES=1 or NO=0 depending on if the payment went to an "undeposited funds" account and it has since been deposited |
Transaction | Discount | Flag if the discount is applied to the line of transaction |
Transaction | Due Date | Invoice due date |
Transaction | Employee List ID | IDs of all employees |
Transaction | End Balance | Ending balance on the transaction |
Transaction | Estimate Amount | Estimated amount while creating an estimate. Available on Charge, Sales Receipt, Credit Memo, Invoie, Sales Order, and Purchase Order. |
Transaction | Exchange Rate | Current exchange rate between currencies |
Transaction | Expected Date | Date you expect to receive an item |
Transaction | FOB | Free on board specifying at what point the seller transfers ownership of the goods to the buyer |
Transaction | Fully Invoiced | Shows if charge/credit/billable time has been put onto an invoice transaction, where 1=YES and 0=NO |
Transaction | Fully Received | Flag to check if entire quantity is received for an order, where 1=YES and 0=NO |
Transaction | Gain Loss Target | (Multi-currency) An adjustment on rate based on currency exchange |
Transaction | Inventory Site List ID | Site ID of the inventory for the item |
Transaction | Inventory Site Location List ID | Location ID for the Site of the inventory for the item |
Transaction | Invoiced | Shows if charge/credit/billable/time has been added to an invoice transaction, where YES=1 and NO=0 |
Transaction | Invoiced Quantity | Quantity on Sales Order |
Transaction | Item From Estimate | Origin of item is from estimate, where 1=YES and 0=NO |
Transaction | Item From Sales Order | Origin of item is from sales order, where 1=YES and 0=NO |
Transaction | Item List ID | List of item ids |
Transaction | Item List ID | List of Item IDs |
Transaction | Item Sales Tax List ID | Sales tax associated with a particular item |
Transaction | Last Auditable Action | Audit table record of the most recent change to a transaction |
Transaction | Liability Account List ID | IDs of all liabilities |
Transaction | Line Item Name Type | Used to distinguish beween vendor, customer, other |
Transaction | Linked Txn ID | Identifier for the link between Invoice ID and Receive Payment |
Transaction | Linked Txn Line ID | Identifier for the link between trasaction line IDs at the line level |
Transaction | Linked Txn Type | Type of link between different transactions |
Transaction | Manufacturer Part Number | ID the vendor uses to identify an item |
Transaction | Markup Amount | Amount of markup over cost |
Transaction | Markup Rate | Shows the mark up rate of an item over cost |
Transaction | Markup Rate Percent | Percentage of mark up of item over cost |
Transaction | Memo | Notes that can be added to a transaction |
Transaction | Open Amount | Open amount on a transaction |
Transaction | Open Balance Amount | Open balance that is still there on a transaction |
Transaction | Open Quantity | Quantity that is still un-delivered from a transaction |
Transaction | Opening Balance | Amount of open AR or AP which has not yet applied/paid |
Transaction | Other List ID | IDs for list of things other an employees or customers or vendors |
Transaction | Paid | Shows if the transaction is fully paid where 1= YES and 0= NO |
Transaction | Payment Method List ID | Unique ID of the payment type used for that transaction |
Transaction | Payment Txn Line ID | Identifier for line item for payment transaction |
Transaction | Pending | Flag (0= NO, 1=YES) to check the status of estimate if it's in pending state |
Transaction | PO Number | Purchase order number |
Transaction | PoNum | Purchase Order number |
Transaction | Print Items In Group | Flag if you need to print all items in the group, where YES=1 and NO=0 |
Transaction | Purchase | Any type of purchase such as bill or check |
Transaction | Quantity | Quantity on a line item |
Transaction | Quantity Can Build | Number of assemblies that can be built with current inventory |
Transaction | Quantity On Hand | Number of items in an inventory |
Transaction | Quantity On Sales Order | Number of items on a Sales Order |
Transaction | Rate | Employee current pay rate |
Transaction | Rate Percent | Set percentage instead of the actual amount on an entity, such as Item or Employee |
Transaction | Received Quantity | Quantity received in a shipment |
Transaction | Reconcile Date | Date when you reconcile data with the bank |
Transaction | Refunded | Flag if the amount is refunded/credited to the customer, where YES=1 and NO=0 |
Transaction | Reimbursed Type | Type of reimbursement like creditmemo |
Transaction | Sales Order Number | Unique ID on Sales order associated with an invoice |
Transaction | Sales Order Quantity | Quantity on the sales order form |
Transaction | Sales Rep List ID | Sales rep ID associated with this transaction |
Transaction | Sales Tax Code List ID | List of IDs of all sales tax codes |
Transaction | Sales Tax Percentage | Tax percentage while creating a transaction |
Transaction | Sales Tax Total | Total sales tax applied to transaction |
Transaction | Serial Or Lot Numbers List | IDs of all serial numbers or lot numbers for all items |
Transaction | Service Date | Date that a service was renderered |
Transaction | Ship Address 1 | Shipping address 1 for the transaction |
Transaction | Ship Address 2 | Shipping address 2 for the transaction |
Transaction | Ship Address 3 | Shipping address 3 for the transaction |
Transaction | Ship Address 4 | Shipping address 4 for the transaction |
Transaction | Ship Address 5 | Shipping address 5 for the transaction |
Transaction | Ship Address Block 1 | Shipping address block 1 for the transaction |
Transaction | Ship Address Block 2 | Shipping address block 2 for the transaction |
Transaction | Ship Address Block 3 | Shipping address block 3 for the transaction |
Transaction | Ship Address Block 4 | Shipping address block 4 for the transaction |
Transaction | Ship Address Block 5 | Shipping address block 5 for the transaction |
Transaction | Ship Address City | Shipping address city for the transaction |
Transaction | Ship Address Country | Shipping address country for the transaction |
Transaction | Ship Address Postal Code | Shipping address zip code for the transaction |
Transaction | Ship Address State | Shipping address state for the transaction |
Transaction | Ship Date | Shipping date of the item |
Transaction | Ship Method List ID | An ID for a shipment method with the transaction, ie Fedex or UPS |
Transaction | Ship To Entity List ID | List of "Ship To" addresses |
Transaction | Sub Total | Sub total of the line items added in the transaction |
Transaction | Target Type | Shows the target type, such as if it's Is this an item or a service etc |
Transaction | Tax Code List ID | IDs for list of tax codes |
Transaction | Tax Included | Flag to check if the tax is included in the price of the object, where YES=1 and NO=0. Valid only for purchase order. |
Transaction | Terms List ID | Payment terms (ie Net 30) |
Transaction | To Be Emailed | Shows if the trasaction details are to be emailed, where 1= YES and 0= NO |
Transaction | To Be Printed | Shows if the trasaction details are to be printed, where 1= YES and 0= NO |
Transaction | Total Amount | Total amount on a transaction |
Transaction | Total Amount In Home Currency | Total amount calculated in the customer's home currency |
Transaction | Trans Tax | Flag to check if this transaction is taxable, where YES=1 and NO=0 |
Transaction | Transaction Date | Date of the transaction. Better to use Txn Date. |
Transaction | Transaction Line Order | Used for the order of the line items in an invoice |
Transaction | Transaction Name Type | Type of transaction eg invoice, payment etc. |
Transaction | Txn Date | Date of transaction in MM/DD/YYYY format |
Transaction | Txn ID | Unique ID of the transaction |
Transaction | Txn Line ID | Unique transaction ID associated with each transaction |
Transaction | Txn Line Type | Type of entity on a particular line item on a transaction |
Transaction | Txn Type | Type of transaction: Purchase Order, Invoice, Estimate etc. |
Transaction | Unbilled Quantity | Amount the customer hasn't been billed for to date |
Transaction | Unit Of Measure Unit List ID | List of unit of measure type eg: count, length, weight |
Transaction | Unit Price | Unit price of a single item |
Transaction | Unused Payment | Overpayment by the customer that can be used to pay other invoice later. |
Transaction | Value Adjustment | Adjusted value on an item within transaction |
Transaction | Vendor Address 1 | Line 1 of the vendor address |
Transaction | Vendor Address 2 | Line 2 of the vendor address |
Transaction | Vendor Address 3 | Line 3 of the vendor address |
Transaction | Vendor Address 4 | Line 4 of the vendor address |
Transaction | Vendor Address 5 | Line 5 of the vendor address |
Transaction | Vendor Address Block 1 | Block 1 of the vendor address |
Transaction | Vendor Address Block 2 | Block 2 of the vendor address |
Transaction | Vendor Address Block 3 | Block 3 of the vendor address |
Transaction | Vendor Address Block 4 | Block 4 of the vendor address |
Transaction | Vendor Address Block 5 | Block 5 of the vendor address |
Transaction | Vendor Address City | City on the vendor address |
Transaction | Vendor Address Country | Country on the vendor address |
Transaction | Vendor Address Postal Code | Zip code on the vendor address |
Transaction | Vendor Address State | State on the vendor address |
Transaction | Vendor List ID | List of vendor IDs |
Transaction | Vendor Message | Message from the shipper to the vendor |
Transaction | Account Full Name | Financial/ledger account relevant for accounting |
Transaction | Employee List ID | Ids of all employees |
Transactions | Transactions.Account List ID | Transactions.AccountListID |
Transactions | Other List ID | List of names of things other an employees or customers or vendors |
Transactions | Transactions.Customer List ID | Customer that’s associated with the line ID of the transaction |
Transactions | Transactions.Class List ID | Reference to the user tracking class when enabled by preference - can be per line or txn |
Transactions | Transactions.Customer Msg List ID | Specifies the customer message edlist |
Transactions | Ship Method List ID | Shipping method id which is on a transaction |
Transactions | Transactions. Inventory Site Location List ID | Location ID of the Site of the inventory for the item |
Transactions | Transactions.Unit Of Measure Unit List ID | List of unit of measure type eg: count, length, weight |
Transactions | Transactions.Txn Date | Transaction date for a particular transaction |
Transactions | Day | |
Transactions | Month | |
Transactions | Month Year | |
Transactions | Period | |
Transactions | Period ID | |
Transactions | Quarter | |
Transactions | Quarter ID | |
Transactions | Quarter Year | |
Transactions | Week | |
Transactions | Year | |
Unit Of Measure Unit | Unit Of Measure Set List ID | List of unit of measure set eg: count, length, weight |
Unit Of Measure Unit | Unit Of Measure Set Full Name | Full name of unit of measure set |
Unit Of Measure Unit | Name | Name of unit of measure |
Unit Of Measure Unit | Abbreviation | Abbreviation of unit of measure |
Unit Of Measure Unit | Conversion Ratio | Specifies the conversion ratio for a name under unit of measure to its default conversion |
Unit Of Measure Unit | Base Unit | Flag to check if an entity under unit of measure is a base unit or not |
Unit Of Measure Unit | Purchase Default Unit | Flag to check if the unit of measure set has default unit set for purchases |
Unit Of Measure Unit | Sales Default Unit | Flag to check if the unit of measure set has default unit set for sales |
Unit Of Measure Unit | Shipping Default Unit | Flag to check if the unit of measure set has default unit set for shipping |
Vendor | Vendor.Account Number | Account number of the vendor for a transaction |
Vendor | Vendor.Active | Flag to check if the vendor is active and make it visible on the UI |
Vendor | Vendor.Balance | Balance on unpaid purchases for this vendor |
Vendor | Vendor.Balance Home Amount | Balance in home country currency of this vendor |
Vendor | Vendor.Class Full Name | Full name of the class for the vendor |
Vendor | Vendor.Class List ID | Class id where the vendor references |
Vendor | Vendor.Company Name | Company name of the vendor |
Vendor | Vendor.Credit Limit | Credit limit of the vendor |
Vendor | Vendor.Currency Full Name | Currency full name that this vendor is referencing |
Vendor | Vendor.Currency List ID | Currency identifier that this vendor is referencing |
Vendor | Vendor.First Name | Vendor's first name |
Vendor | Vendor.IsSalesRepActive | Flag to check if a particular sales representative for a vendor is active or not |
Vendor | Vendor.Job Title | Vendor's job title |
Vendor | Vendor.Last Name | Vendor's last name |
Vendor | Vendor.Middle Name | Vendor'smiddle name |
Vendor | Vendor.Name | Name for the vendor |
Vendor | Vendor.Name On Check | Name on the check for the vendor for a transaction |
Vendor | Vendor.Sales Rep Full Name | Sales rep full name that this vendor is referencing |
Vendor | Vendor.Sales Rep List ID | Sales rep id that this vendor is referencing |
Vendor | Vendor.SalesRepInitial | Initials of the vendor sales representative |
Vendor | Vendor.Salutation | Salutation of the vendor |
Vendor | Vendor.Ship Address 1 | Line 1 of the vendor's shipping address |
Vendor | Vendor.Ship Address 2 | Line 2 of the vendor's shipping address |
Vendor | Vendor.Ship Address 3 | Line 3 of the vendor's shipping address |
Vendor | Vendor.Ship Address 4 | Line 4 of the vendor's shipping address |
Vendor | Vendor.Ship Address 5 | Line 5 of the vendor's shipping address |
Vendor | Vendor.Ship Address Block 1 | Vendor's shipping address block 1 |
Vendor | Vendor.Ship Address Block 2 | Vendor's shipping address block 2 |
Vendor | Vendor.Ship Address Block 3 | Vendor's shipping address block 3 |
Vendor | Vendor.Ship Address Block 4 | Vendor's shipping address block 4 |
Vendor | Vendor.Ship Address Block 5 | Vendor's shipping address block 5 |
Vendor | Vendor.Ship Address City | City of the vendor's shipping address |
Vendor | Vendor.Ship Address Country | Country of the vendor's shipping address |
Vendor | Vendor.Ship Address Postal Code | Zipcode of the vendor's shipping address |
Vendor | Vendor.Ship Address State | State of the vendor's shipping address |
Vendor | Vendor.Terms Full Name | Terms full name that this vendor is referencing |
Vendor | Vendor.Terms List ID | Terms identifier that this vendor is referencing |
Vendor | Vendor.Time Created | Time created for the vendor |
Vendor | Vendor.Time Modified | Time modified for the vendor |
Vendor | Vendor.Vendor Address 1 | Line 1 of the vendor address |
Vendor | Vendor.Vendor Address 2 | Line 2 of the vendor address |
Vendor | Vendor.Vendor Address 3 | Line 3 of the vendor address |
Vendor | Vendor.Vendor Address 4 | Line 4 of the vendor address |
Vendor | Vendor.Vendor Address 5 | Line 5 of the vendor address |
Vendor | Vendor.Vendor Address Block 1 | Vendor Address block 1 |
Vendor | Vendor.Vendor Address Block 2 | Vendor Address block 2 |
Vendor | Vendor.Vendor Address Block 3 | Vendor Address block 3 |
Vendor | Vendor.Vendor Address Block 4 | Vendor Address block 4 |
Vendor | Vendor.Vendor Address Block 5 | Vendor Address block 5 |
Vendor | Vendor.Vendor Address City | City on the vendor address |
Vendor | Vendor.Vendor Address Country | Country on the employee address |
Vendor | Vendor.Vendor Address Postal Code | Zipcodeon the employee address |
Vendor | Vendor.Vendor Address State | State on the employee address |
Vendor | Vendor.Vendor Eligible For 1099 | Flag to check if the vendor is eligible for 1099 |
Vendor | Vendor.Vendor List ID | Identifier of this vendor |
Vendor | Vendor.Vendor Type Full Name | Vendor type full name that this vendor is referencing |
Vendor | Vendor.Vendor Type List ID | Vendor type identifier that this vendor is referencing |
Vendor Additional Contact | List ID | Vendor's secondary contact's list ID |
Vendor Additional Contact | Vendor Full Name | Vendor's secondary contact's full name |
Vendor Additional Contact | Salutation | Vendor's secondary contact's salutation |
Vendor Additional Contact | First Name | Vendor's secondary contact's first name |
Vendor Additional Contact | Middle Name | Vendor's secondary contact's middle name |
Vendor Additional Contact | Last Name | Vendor's secondary contact's last name |
Vendor Additional Contact | Job Title | Vendor's secondary contact's job title |
Vendor Additional Contact | Contact Type | Vendor's secondary contact's type |
Vendor Primary Contact | List ID | Vendor's primary contact's list id |
Vendor Primary Contact | Vendor Full Name | Vendor's primary contact's full name |
Vendor Primary Contact | Salutation | Vendor's primary contact's salutation |
Vendor Primary Contact | First Name | Vendor's primary contact's first name |
Vendor Primary Contact | Middle Name | Vendor's primary contact's middle name |
Vendor Primary Contact | Last Name | Vendor's primary contact's last name |
Vendor Primary Contact | Job Title | Vendor's primary contact's job title |
Vendor Primary Contact | Contact Type | Vendor's primary contact's type |
Vendor Secondary Contact | List ID | Vendor's secondary contact's list id |
Vendor Secondary Contact | Vendor Full Name | Vendor's secondary contact's full name |
Vendor Secondary Contact | Salutation | Vendor's secondary contact's salutation |
Vendor Secondary Contact | First Name | Vendor's secondary contact's first name |
Vendor Secondary Contact | Middle Name | Vendor's secondary contact's middle name |
Vendor Secondary Contact | Last Name | Vendor's secondary contact's last name |
Vendor Secondary Contact | Job Title | Vendor's secondary contact's job title |
Vendor Secondary Contact | Contact Type | Vendor's secondary contact's type |
Vendor To Do | List ID | Vendor to do list id |
Vendor To Do | Time Created | Timestamp on the vendor to do creation |
Vendor To Do | Time Modified | Timestamp on the vendor to do modification |
Vendor To Do | Name | Unique full name given to each vendor to do |
Vendor To Do | Priority | Priority given to each to do eg: low |
Vendor To Do | Notes | Details associated with each to do |
Vendor To Do | Active | Verifies if the vendor message is in active state |
Vendor To Do | Done | Flag to check the status of the current to do |
Vendor To Do | Status | Status of the current to do, eg: active, done, inactive |
Vendor To Do | Reminder Date | Due date for the current to do |
Vendor Type | Time Created | Timestamp on the vendor type creation |
Vendor Type | Time Modified | Timestamp on the vendor type modification |
Vendor Type | Name | Name of the vendor type |
Vendor Type | Full Name | Full name of the vendor type |
Vendor Type | Active | Flag to check if the vendor type is active or not |
Vendor Type | Parent List ID | Parent id of the vendor type |
Vendor Type | Parent Full Name | Parent full name of the vendor type |
Vendor Type | Sub Level | Numerical value of where the vendor type belongs in the hiearchical structure |
VendorNote | Note List ID | ID of a specific vendor note for an existing customer |
VendorNote | Vendor Full Name | Full name of the vendor associated with a particular note |
VendorNote | Date | Date when the vendor note was created |