Category_Comment Accounts
Category Comment
string Category_Order Accounts
Category Order
integer Category_Description Accounts
Category Description
string Category_ID Accounts
Category ID
integer Category_Modified Accounts
Category Modified
datetime Category_Created Accounts
Category Created
datetime Description Accounts
Description
string ReportingGroupId Accounts
Reporting Group Id
integer UnallocatedAccount Accounts
Unallocated Account
integer IsTaxLocked Accounts
Is Tax Locked
integer AccountType Accounts
Account Type
float HasActivity Accounts
Has Activity
float DefaultTaxTypeId Accounts
Default Tax Type Id
float AnalysisTypeId Analysis Category
Analysis Type Id
string Description Analysis Category
Description
string Date Bank Transactions
Date
datetime BankAccountId Bank Transactions confidencial
Bank Account Id
string Type Bank Transactions
Type
string SelectionId Bank Transactions
Selection Id
string SelectionName Bank Transactions
Selection Name
string SelectionIsObfuscated Bank Transactions
Selection Is Obfuscated
integer DocumentNumber Bank Transactions
Document Number
string Payee Bank Transactions confidencial
Payee
string Reference Bank Transactions
Reference
string Description Bank Transactions
Description
string TaxTypeId Bank Transactions
TaxTypeId
string Exclusive Bank Transactions
Exclusive
float Total Bank Transactions
Total
float Discount Bank Transactions
Discount
float Reconciled Bank Transactions
Reconciled
integer BankUniqueIdentifier Bank Transactions
Bank Unique Identifier
string AnalysisCategoryId1 Bank Transactions
Analysis Category Id1
integer AnalysisCategoryId2 Bank Transactions
Analysis Category Id2
integer AnalysisCategoryId3 Bank Transactions
Analysis Category Id3
integer Memo Bank Transactions
Memo
string BankImportMappingId Bank Transactions
Bank Import Mapping Id
string TaxPeriodId Bank Transactions
Tax Period Id
string Editable Bank Transactions
Editable
integer Accepted Bank Transactions
Accepted
integer Duplicate Bank Transactions
Duplicate
integer Matched Bank Transactions
Matched
integer MatchReference Bank Transactions
Match Reference
string Locked Bank Transactions
Locked
integer HasAttachments Bank Transactions
Has Attachments
integer HasAllocations Bank Transactions
Has Allocations
integer PaymentMethodId Bank Transactions
Payment Method Id
integer ImportTypeId Bank Transactions
Import Type Id
integer BankAccount_CurrencyId Bank Transactions
Bank Account — Currency Id
string BankAccount_ExchangeRate Bank Transactions
Bank Account — Exchange Rate
float Selection_CurrencyId Bank Transactions
Selection — Currency Id
integer Selection_ExchangeRate Bank Transactions
Selection — Exchange Rate
float TimeTrackingProjectId Bank Transactions
Time Tracking Project Id
integer TimeTrackingExpenseId Bank Transactions
Time Tracking Expense Id
integer BillingMethodId Bank Transactions
Billing Method Id
integer Recharge Bank Transactions
Recharge
float MarkupPercentage Bank Transactions
Markup Percentage
float ImportActionDate Bank Transactions
Import Action Date
datetime HasManualDiscountAllocations Bank Transactions
Has Manual Discount Allocations
integer StatusId Bank Transactions
Status Id
integer SalesOrdersReserveItemQuantities Companies
Sales Orders Reserve Item Quantities
integer AgeMonthly Companies
Age Monthly
integer NumberDecimalDigits Companies
Number Decimal Digits
float CompanyTransferStatus Companies
Company Transfer Status
string DoNotAllowProcessingIntoNegativeQuantities Companies
Do Not Allow Processing Into Negative Quantities
integer CheckForDuplicateCustomerReferences Companies
Check For Duplicate Customer References
integer DecimalSeparator Companies
Decimal Separator
string LastLoginDate Companies
Last Login Date
datetime UseLogoOnEmails Companies
Use Logo On Emails
boolean ItemSellingPriceDecimalDigits Companies
Item Selling Price Decimal Digits
string Modified Companies
Modified
datetime CurrencySymbol Companies
Currency Symbol
string AgeingBasedOnDueDate Companies
Ageing Based On Due Date
integer DisplayInCompanyConsole Companies
Display In Company Console
integer InventoryTypeId Companies
Inventory Type Id
string TaxSystem Companies
Tax System
string CheckForDuplicateSupplierReferences Companies
Check For Duplicate Supplier References
integer DisplayInactiveTimeProjects Companies
Display Inactive Time Projects
integer WarnWhenItemSellingBelowCost Companies
Warn When Item Selling Below Cost
integer HoursDecimalDigits Companies
Hours Decimal Digits
float LogoPositionID Companies
Logo Position ID
integer RoundingType Companies
Rounding Type
string DisplayInactiveCustomers Companies
Display Inactive Customers
integer TaxReportingTypeId Companies
Tax Reporting Type Id
string CurrencyDecimalDigits Companies
Currency Decimal Digits
float EnableAutomaticBankFeedRefresh Companies
Enable Automatic Bank Feed Refresh
integer LockProcessing Companies
Lock Processing
integer DisplayInactiveSuppliers Companies
Display Inactive Suppliers
integer IsPrimarySendingEmail Companies
Is Primary Sending Email
integer DateFormatId Companies
Date Format Id
string WarnWhenItemQuantityIsZero Companies
Warn When Item Quantity Is Zero
integer DisplayInactiveItems Companies
Display Inactive Items
integer DisplayTotalTypeId Companies
Display Total Type Id
string PrescribedGoodsTrader Companies
Prescribed Goods Trader
integer GroupSeparator Companies
Group Separator
string UseNoreplyEmail Companies
Use Noreply Email
integer IsPracticeAccount Companies
Is Practice Account
integer UseInclusiveProcessingByDefault Companies
Use Inclusive Processing By Default
integer UseLogoOnCustomerZone Companies
Use Logo On Customer Zone
integer DisplayName Companies
Display Name
string RoundingValue Companies
Rounding Value
float ClientTypeId Companies
Client Type Id
string EnableCustomerZone Companies
Enable Customer Zone
integer LockTimesheetProcessing Companies
Lock Timesheet Processing
integer CountryId Companies
Country Id
string ItemCostPriceDecimalDigits Companies
Item Cost Price Decimal Digits
float Telephone Companies
Telephone
string WarnWhenItemCostIsZero Companies
Warn When Item Cost Is Zero
integer CustomerZoneGuid Companies
Customer Zone Guid
string Category_ID Customers
Category ID
string SalesRepresentativeId Customers
Sales Representative Id
string TaxReference Customers
Tax Reference
string ContactName Customers confidencial
Contact Name
string Telephone Customers confidencial
Telephone
string Fax Customers confidencial
Fax
string Mobile Customers confidencial
Mobile
string Email Customers confidencial
Email
string WebAddress Customers
Web Address
string IsObfuscated Customers
Is Obfuscated
integer CreditLimit Customers
Credit Limit
float CommunicationMethod Customers
Communication Method
float PostalAddress01 Customers confidencial
Postal Address01
string PostalAddress02 Customers confidencial
Postal Address02
string PostalAddress03 Customers confidencial
Postal Address03
string PostalAddress04 Customers confidencial
Postal Address04
string PostalAddress05 Customers confidencial
Postal Address05
string DeliveryAddress01 Customers confidencial
Delivery Address01
string DeliveryAddress02 Customers confidencial
Delivery Address02
string DeliveryAddress03 Customers confidencial
Delivery Address03
string DeliveryAddress04 Customers confidencial
Delivery Address04
string DeliveryAddress05 Customers confidencial
Delivery Address05
string AutoAllocateToOldestInvoice Customers
Auto Allocate To Oldest Invoice
integer EnableCustomerZone Customers
Enable Customer Zone
integer CustomerZoneGuid Customers
Customer Zone Guid
string CashSale Customers
Cash Sale
integer TextField1 Customers
Text Field1
string TextField2 Customers
Text Field2
string TextField3 Customers
Text Field3
string NumericField1 Customers
Numeric Field1
float NumericField2 Customers
Numeric Field2
float NumericField3 Customers
Numeric Field3
float YesNoField1 Customers
Yes No Field1
integer YesNoField2 Customers
Yes No Field2
integer YesNoField3 Customers
Yes No Field3
integer DateField1 Customers
Date Field1
datetime DateField2 Customers
Date Field2
datetime DateField3 Customers
Date Field3
datetime DefaultPriceListId Customers
Default Price List Id
float DefaultPriceList_ID Customers
Default Price List - ID
float DefaultPriceList_Description Customers
Default Price ListDescription
string DefaultPriceList_IsDefault Customers
Default Price List Is Default
integer DefaultPriceListName Customers
Default Price List Name
string AcceptsElectronicInvoices Customers
Accepts Electronic Invoices
integer Modified Customers
Modified
datetime BusinessRegistrationNumber Customers
Business Registration Number
string TaxStatusVerified Customers
Tax Status Verified
datetime CurrencyId Customers
Currency Id
string CurrencySymbol Customers
Currency Symbol
string HasActivity Customers
Has Activity
integer DefaultDiscountPercentage Customers
Default Discount Percentage
float DefaultTaxTypeId Customers
Default Tax Type Id
string DefaultTaxType_ID Customers
Default Tax Type - ID
string DefaultTaxType_Name Customers
Default Tax Type Name
string DefaultTaxType_HasActivity Customers
Default Tax Type Has Activity
integer DefaultTaxType_Percentage Customers
Default Tax Type Percentage
float DefaultTaxType_IsManualTax Customers
DefaultTaxType Is Manual Tax
integer DefaultTaxType_Active Customers
Default Tax Type Active
integer DefaultTaxType_CompanyId Customers
Default Tax Type Company Id
string DueDateMethodId Customers
Due Date Method Id
string DueDateMethodValue Customers
Due Date Method Value
float HasSpecialCountryTax Customers
Has Special Country Tax
integer AccountingAgreement Customers
Accounting Agreement
integer HasSpecialCountryTaxActivity Customers
Has Special Country Tax Activity
integer OutstandingInvoices Customers
Outstanding Invoices
integer OverdueInvoices Customers
Overdue Invoices
integer ExcludeFromDebtorsManager Customers
Exclude From Debtors Manager
integer Description Items
Description
string Category_Description Items
Category Description
string Category_ID Items
Category ID
string Category_Modified Items
Category Modified
string Category_Created Items
Category Created
string PriceInclusive Items
Price Inclusive
string PriceExclusive Items
Price Exclusive
string TaxTypeIdSales Items
Tax Type Id Sales
string TaxTypeSales_ID Items
Tax Type Sales ID
string TaxTypeSales_Name Items
Tax Type Sales Name
string TaxTypeSales_Percentage Items
Tax Type Sales Percentage
string TaxTypeSales_IsDefault Items
Tax Type Sales Is Default
integer TaxTypeSales_HasActivity Items
Tax Type Sales Has Activity
integer TaxTypeSales_IsManualTax Items
Tax Type Sales Is Manual Tax
integer TaxTypeSales_Active Items
Tax Type Sales Active
integer TaxTypeIdPurchases Items
Tax Type Id Purchases
string TaxTypePurchases_ID Items
Tax Type Purchases ID
string TaxTypePurchases_Name Items
Tax Type Purchases Name
string TaxTypePurchases_Percentage Items
Tax Type Purchases Percentage
float TaxTypePurchases_IsDefault Items
Tax Type Purchases Is Default
integer TaxTypePurchases_HasActivity Items
Tax Type Purchases Has Activity
integer TaxTypePurchases_IsManualTax Items
Tax Type Purchases Is Manual Tax
integer TaxTypePurchases_Active Items
Tax Type Purchases Active
integer AverageCost Items
Average Cost
float QuantityOnHand Items
Quantity On Hand
float HasAttachments Items
Has Attachments
integer HasActivity Items
Has Activity
integer ItemReportingGroupId_Sales Items
Item Reporting Group Id Sales
string ItemReportingGroupSales_ID Items
Item Reporting Group Sales ID
string ItemReportingGroupSales_Name Items
Item Reporting Group Sales Name
string ItemReportingGroupSales_ItemReportingGroupTypeId Items
Item Reporting Group Sales Item Reporting Group Type Id
string ItemReportingGroupSales_ItemReportingGroupType Items
Item Reporting Group Sales Item Reporting Group Type
string ItemReportingGroupSales_ReportingGroupId Items
Item Reporting Group Sales Reporting Group Id
string ItemReportingGroupSales_AccountCategoryId Items
Item Reporting Group Sales Account Category Id
string ItemReportingGroupId_Purchases Items
Item Reporting Group Id Purchases
string ItemReportingGroupPurchases_ID Items
Item Reporting Group Purchases ID
string ItemReportingGroupPurchases_Name Items
Item Reporting Group Purchases Name
string ItemReportingGroupPurchases_ItemReportingGroupTypeId Items
Item Reporting Group Purchases Item Reporting Group Type Id
string ItemReportingGroupPurchases_ItemReportingGroupType Items
Item Reporting Group Purchases Item Reporting Group Type
string ItemReportingGroupPurchases_ReportingGroupId Items
Item Reporting Group Purchases Reporting Group Id
string ItemReportingGroupPurchases_AccountCategoryId Items
Item Reporting Group Purchases Account Category Id
string ItemReportingGroupId_Inventory Items
Item Reporting Group Id Inventory
string ItemReportingGroupInventory_ID Items
Item Reporting Group Inventory ID
string ItemReportingGroupInventory_Name Items
Item Reporting Group Inventory Name
string ItemReportingGroupInventory_ItemReportingGroupTypeId Items
Item Reporting Group Inventory Item Reporting Group Type Id
string ItemReportingGroupInventory_ItemReportingGroupType Items
Item Reporting Group Inventory Item Reporting Group Type
string ItemReportingGroupInventory_ReportingGroupId Items
Item Reporting Group Inventory Reporting Group Id
string ItemReportingGroupInventory_AccountCategoryId Items
Item Reporting Group Inventory Account Category Id
string ItemReportingGroupId_ItemAdjustments Items
Item Reporting Group Id Item Adjustments
string AccountId_ServiceItemRecovery Items
Account Id Service Item Recovery
string ItemReportingGroupItemAdjustments_ID Items
Item Reporting Group Item Adjustments ID
string ItemReportingGroupItemAdjustments_Name Items
Item Reporting Group Item Adjustments Name
string ItemReportingGroupItemAdjustments_ItemReportingGroupTypeId Items
Item Reporting Group Item Adjustments Item Reporting Group Type Id
string ItemReportingGroupItemAdjustments_ItemReportingGroupType Items
Item Reporting Group Item Adjustments Item Reporting Group Type
string ItemReportingGroupItemAdjustments_ReportingGroupId Items
Item Reporting Group Item Adjustments Reporting Group Id
string ItemReportingGroupItemAdjustments_AccountCategoryId Items
Item Reporting Group Item Adjustments Account Category Id
string AccountServiceItemRecovery_Name Items
Account Service Item Recovery Name
string AccountServiceItemRecovery_Category_Comment Items
Account Service Item Recovery Category Comment
string AccountServiceItemRecovery_Category_Order Items
Account Service Item Recovery Category Order
string AccountServiceItemRecovery_Category_Description Items
Account Service Item Recovery Category Description
string AccountServiceItemRecovery_Category_ID Items
Account Service Item Recovery Category ID
string AccountServiceItemRecovery_Category_Modified Items
Account Service Item Recovery Category Modified
datetime AccountServiceItemRecovery_Category_Created Items
Account Service Item Recovery Category Created
string AccountServiceItemRecovery_Active Items
Account Service Item Recovery Active
integer AccountServiceItemRecovery_Balance Items
Account Service Item Recovery Balance
string AccountServiceItemRecovery_Description Items
Account Service Item Recovery Description
string AccountServiceItemRecovery_ReportingGroupId Items
Account Service Item Recovery Reporting Group Id
string AccountServiceItemRecovery_UnallocatedAccount Items
Account Service Item Recovery Unallocated Account
integer AccountServiceItemRecovery_IsTaxLocked Items
Account Service Item Recovery Is Tax Locked
integer AccountServiceItemRecovery_Modified Items
Account Service Item Recovery Modified
datetime AccountServiceItemRecovery_Created Items
Account Service Item Recovery Created
string AccountServiceItemRecovery_AccountType Items
Account Service Item Recovery Account Type
string AccountServiceItemRecovery_HasActivity Items
Account Service Item Recovery Has Activity
integer AccountServiceItemRecovery_DefaultTaxTypeId Items
Account Service Item Recovery Default Tax Type Id
string AccountServiceItemRecovery_ID Items
Account Service Item Recovery ID
string TextUserField1 Items
Text User Field1
string TextUserField2 Items
Text User Field2
string TextUserField3 Items
Text User Field3
string NumericUserField1 Items
Numeric User Field1
float NumericUserField2 Items
Numeric User Field2
float NumericUserField3 Items
Numeric User Field3
float DateUserField1 Items
Date User Field1
string DateUserField2 Items
Date User Field2
string DateUserField3 Items
Date User Field3
string MajorIndustryCodeId Items
Major Industry Code Id
string GPPercentage Items
G P Percentage
float ItemReportingGroupPurchasesName Items
Item Reporting Group Purchases Name
string ItemReportingGroupSalesName Items
Item Reporting Group Sales Name
string ItemReportingGroupInventoryName Items
Item Reporting Group Inventory Name
string ItemReportingGroupItemAdjustmentsName Items
Item Reporting Group Item Adjustments Name
string AccountServiceItemRecoveryName Items
Account Service Item Recovery Name
string AdditionalItemPrices_ID Items
Additional Item Prices ID
string AdditionalItemPrices_ItemId Items
Additional Item Prices Item Id
string AdditionalItemPrices_PriceInclusive Items
Additional Item Prices Price Inclusive
string AdditionalItemPrices_PriceExclusive Items
Additional Item Prices Price Exclusive
string AdditionalItemPrices_AdditionalPriceListId Items
Additional Item Prices Additional Price List Id
string Effect Journal Entries
Effect
integer AccountId Journal Entries
Account Id
string Reference Journal Entries
Reference
string Description Journal Entries
Description
string TaxTypeId Journal Entries
Tax Type Id
integer TaxPeriodId Journal Entries
Tax Period Id
integer Exclusive Journal Entries
Exclusive
float Total Journal Entries
Total
float ContraAccountId Journal Entries
Contra Account Id
string HasAttachments Journal Entries
Has Attachments
integer AnalysisCategoryId1 Journal Entries
Analysis Category Id1
integer AnalysisCategoryId2 Journal Entries
Analysis Category Id2
integer AnalysisCategoryId3 Journal Entries
Analysis Category Id3
integer Editable Journal Entries
Editable
integer Locked Journal Entries
Locked
integer Debit Journal Entries
Debit
float Credit Journal Entries
Credit
float BusinessId Journal Entries
Business Id
integer PayRunId Journal Entries
Pay Run Id
integer DiscountPercentage Quotes
Discount Percentage
float TaxReference Quotes
Tax Reference
string DocumentNumber Quotes
Document Number
string AmountDue Quotes
Amount Due
float PostalAddress01 Quotes confidencial
Postal Address01
string PostalAddress02 Quotes confidencial
Postal Address02
string PostalAddress03 Quotes confidencial
Postal Address03
string PostalAddress04 Quotes confidencial
Postal Address04
string PostalAddress05 Quotes confidencial
Postal Address05
string DeliveryAddress01 Quotes confidencial
Delivery Address01
string DeliveryAddress02 Quotes confidencial
Delivery Address02
string DeliveryAddress03 Quotes confidencial
Delivery Address03
string DeliveryAddress04 Quotes confidencial
Delivery Address04
string DeliveryAddress05 Quotes confidencial
Delivery Address05
string TaxPeriodId Quotes
Tax Period Id
string HasAttachments Quotes
Has Attachments
integer HasAnticipatedDate Quotes
Has Anticipated Date
integer AnticipatedDate Quotes
Anticipated Date
datetime ExternalReference Quotes
External Reference
string CustomerId Quotes
Customer Id
string CustomerName Quotes confidencial
Customer Name
string SalesRepresentativeId Quotes
Sales Representative Id
string Customer_CurrencyId Quotes
Customer Currency Id
string Customer_ExchangeRate Quotes
Customer Exchange Rate
string ExpiryDate Quotes
Expiry Date
datetime AllowOnlineAccept Quotes
Allow Online Accept
integer UseForeignCurrency Quotes
Use Foreign Currency
integer Lines_SelectionId Quotes
Lines Selection Id
string Lines_TaxTypeId Quotes
Lines Tax Type Id
string Lines_Description Quotes
Lines Description
string Lines_LineType Quotes
Lines Line Type
string Lines_Quantity Quotes
Lines Quantity
float Lines_UnitPriceExclusive Quotes
Lines Unit Price Exclusive
float Lines_Unit Quotes
Lines Unit
string Lines_UnitPriceInclusive Quotes
Lines Unit Price Inclusive
float Lines_TaxPercentage Quotes
Lines Tax Percentage
float Lines_Exclusive Quotes
Lines Exclusive
float Lines_Discount Quotes
Lines Discount
float Lines_Total Quotes
Lines Total
float Lines_Comments Quotes
Lines Comments
string Lines_AnalysisCategoryId1 Quotes
Lines Analysis Category Id1
string Lines_AnalysisCategoryId2 Quotes
Lines Analysis Category Id2
string Lines_AnalysisCategoryId3 Quotes
Lines Analysis Category Id3
string Lines_CurrencyId Quotes
Lines Currency Id
string Lines_UnitCost Quotes
Lines Unit Cost
float Active Recurring Journals
Active
integer MarkAsReviewed Recurring Journals
Mark As Reviewed
integer TemplateName Recurring Journals
Template Name
string Created Recurring Journals
Created
datetime Modified Recurring Journals
Modified
datetime TransactionID Recurring Journals
Journal Transaction - Journal ID
string TransactionEffect Recurring Journals
Journal Transaction - Effect
string TransactionAccountId Recurring Journals
Journal Transaction - Account Id
string TransactionReference Recurring Journals
Journal Transaction - Reference
string TransactionDescription Recurring Journals
Journal Transaction - Description
string TransactionTaxTypeId Recurring Journals
Journal Transaction - Tax Type Id
string TransactionExclusive Recurring Journals
Journal Transaction - Exclusive
float TransactionTax Recurring Journals
Journal Transaction - Tax
float TransactionTotal Recurring Journals
Journal Transaction - Total
float TransactionContraAccountId Recurring Journals
Journal Transaction - Contra Account Id
string TransactionMemo Recurring Journals
Journal Transaction - Memo
string TransactionAnalysisCategoryId1 Recurring Journals
Journal Transaction - Analysis Category Id1
string TransactionAnalysisCategoryId2 Recurring Journals
Journal Transaction - Analysis Category Id2
string TransactionAnalysisCategoryId3 Recurring Journals
Journal Transaction - Analysis Category Id3
string TransactionEditable Recurring Journals
Journal Transaction - Editable
boolean TransactionLocked Recurring Journals
Journal Transaction - Locked
boolean TransactionDebit Recurring Journals
Journal Transaction - Debit
string TransactionCredit Recurring Journals
Journal Transaction - Credit
string TransactionCreated Recurring Journals
Journal Transaction - Created
datetime TransactionModified Recurring Journals
Journal Transaction - Modified
datetime RecurrenceID Recurring Journals
Recurrence ID
string FrequencyType Recurring Journals
Frequency Type
string FrequencyInterval Recurring Journals
Frequency Interval
string FrequencyRelativeInterval Recurring Journals
Frequency Relative Interval
string FrequencyRecurrenceFactor Recurring Journals
Frequency Recurrence Factor
string FrequencyYearlyMonth Recurring Journals
Frequency Yearly Month
string RecurrenceRangeType Recurring Journals
Recurrence Range Type
string RecurrenceStartDate Recurring Journals
Recurrence Start Date
datetime RecurrenceNextRunDate Recurring Journals
Recurrence Next Run Date
datetime RecurrenceLastRunDate Recurring Journals
Recurrence Last Run Date
datetime RecurrenceEndDate Recurring Journals
Recurrence End Date
datetime NumberOfOccurrences Recurring Journals
Number Of Occurrences
float RecurrenceCreated Recurring Journals
Recurrence Created
datetime RecurrenceModified Recurring Journals
Recurrence Modified
datetime transaction_id Sales By Item
Transaction ID
integer document_type_id Sales By Item
Document Type ID
integer item_code Sales By Item
Item Code
string item_description Sales By Item
Item Description
string item_code_and_description Sales By Item
Item Code And Description
string unit_price_exclusive Sales By Item
Unit Price Exclusive
float quantity Sales By Item
Quantity
float total_cost Sales By Item
Total Cost
float total_selling Sales By Item
Total Selling
float last_cost Sales By Item
Last Cost
float price_exclusive Sales By Item
Price Exclusive
float gp_amount Sales By Item
GP Amount
float gp_percentage Sales By Item
GP Percentage
float Date Supplier Invoices
Date
datetime Inclusive Supplier Invoices
Inclusive
integer DiscountPercentage Supplier Invoices
Discount Percentage
string TaxReference Supplier Invoices
Tax Reference
string DocumentNumber Supplier Invoices
Document Number
string Reference Supplier Invoices
Reference
string Message Supplier Invoices
Message
string Discount Supplier Invoices
Discount
float Exclusive Supplier Invoices
Exclusive
float Rounding Supplier Invoices
Rounding
float Total Supplier Invoices
Total
float AmountDue Supplier Invoices
Amount Due
float PostalAddress01 Supplier Invoices confidencial
Postal Address01
string PostalAddress02 Supplier Invoices confidencial
Postal Address02
string PostalAddress03 Supplier Invoices confidencial
Postal Address03
string PostalAddress04 Supplier Invoices confidencial
Postal Address04
string PostalAddress05 Supplier Invoices confidencial
Postal Address05
string DeliveryAddress01 Supplier Invoices confidencial
Delivery Address01
string DeliveryAddress02 Supplier Invoices confidencial
Delivery Address02
string DeliveryAddress03 Supplier Invoices confidencial
Delivery Address03
string DeliveryAddress04 Supplier Invoices confidencial
Delivery Address04
string DeliveryAddress05 Supplier Invoices confidencial
Delivery Address05
string TaxPeriodId Supplier Invoices
Tax Period Id
string Editable Supplier Invoices
Editable
integer HasAttachments Supplier Invoices
Has Attachments
integer HasNotes Supplier Invoices
Has Notes
integer HasAnticipatedDate Supplier Invoices
Has Anticipated Date
integer AnticipatedDate Supplier Invoices
Anticipated Date
datetime ExternalReference Supplier Invoices
External Reference
string SupplierId Supplier Invoices
Supplier Id
string SupplierName Supplier Invoices
Supplier Name
string Modified Supplier Invoices
Modified
datetime Created Supplier Invoices
Created
datetime StatusId Supplier Invoices
Status Id
string Supplier_CurrencyId Supplier Invoices
Supplier - Currency Id
string Supplier_ExchangeRate Supplier Invoices
Supplier - Exchange Rate
string DueDate Supplier Invoices
Due Date
datetime Paid Supplier Invoices
Paid
integer Status Supplier Invoices
Status
string FromDocument Supplier Invoices
From Document
string Locked Supplier Invoices
Locked
integer HasAdditionalCost Supplier Invoices
Has Additional Cost
integer Category_ID Suppliers
Category ID
string Category_Description Suppliers
Category Description
string Category_Modified Suppliers
Category Modified
datetime Category_Created Suppliers
Category Created
datetime TaxReference Suppliers
Tax Reference
string ContactName Suppliers confidencial
Contact Name
string Telephone Suppliers confidencial
Telephone
string Fax Suppliers confidencial
Fax
string Mobile Suppliers confidencial
Mobile
string Email Suppliers confidencial
Email
string WebAddress Suppliers
Web Address
string IsObfuscated Suppliers
Is Obfuscated
integer CreditLimit Suppliers
Credit Limit
float PostalAddress01 Suppliers confidencial
Postal Address01
string PostalAddress02 Suppliers confidencial
Postal Address02
string PostalAddress03 Suppliers confidencial
Postal Address03
string PostalAddress04 Suppliers confidencial
Postal Address04
string PostalAddress05 Suppliers confidencial
Postal Address05
string DeliveryAddress01 Suppliers confidencial
Delivery Address01
string DeliveryAddress02 Suppliers confidencial
Delivery Address02
string DeliveryAddress03 Suppliers confidencial
Delivery Address03
string DeliveryAddress04 Suppliers confidencial
Delivery Address04
string DeliveryAddress05 Suppliers confidencial
Delivery Address05
string AutoAllocateToOldestInvoice Suppliers
Auto Allocate To Oldest Invoice
integer HasSpecialCountryTax Suppliers
Has Special Country Tax
integer AccountingAgreement Suppliers
Accounting Agreement
integer HasSpecialCountryTaxActivity Suppliers
Has Special Country Tax Activity
integer Modified Suppliers
Modified
datetime BusinessRegistrationNumber Suppliers
Business Registration Number
string RMCDApprovalNumber Suppliers
R M C D Approval Number
string TaxStatusVerified Suppliers
Tax Status Verified
string CurrencyId Suppliers
Currency Id
string CurrencySymbol Suppliers
Currency Symbol
string HasActivity Suppliers
Has Activity
integer DefaultDiscountPercentage Suppliers
Default Discount Percentage
string DefaultTaxTypeId Suppliers
Default Tax Type Id
string DueDateMethodId Suppliers
Due Date Method Id
string DueDateMethodValue Suppliers
Due Date Method Value
string due_date Tax Invoices
Due Date
datetime from_document Tax Invoices
From Document
string allow_online_payment Tax Invoices
Allow Online Payment
integer customer_id Tax Invoices
Customer Id
integer customer_name Tax Invoices confidencial
Customer Name
integer modified Tax Invoices
Modified
datetime created Tax Invoices
Created
datetime inclusive Tax Invoices
Inclusive
integer discount_percentage Tax Invoices
Discount Percentage
float tax_reference Tax Invoices
Tax Reference
string document_number Tax Invoices
Document Number
string reference Tax Invoices
Reference
string message Tax Invoices
Message
string discount Tax Invoices
Discount
float exclusive Tax Invoices
Exclusive
float rounding Tax Invoices
Rounding
float amount_due Tax Invoices
Amount Due
float postal_address_01 Tax Invoices confidencial
Postal Address 01
string postal_address_02 Tax Invoices confidencial
Postal Address 02
string postal_address_03 Tax Invoices confidencial
Postal Address 03
string postal_address_04 Tax Invoices confidencial
Postal Address 04
string postal_address_05 Tax Invoices confidencial
Postal Address 05
string delivery_address_01 Tax Invoices confidencial
Delivery Address 01
string delivery_address_02 Tax Invoices confidencial
Delivery Address 02
string delivery_address_03 Tax Invoices confidencial
Delivery Address 03
string delivery_address_04 Tax Invoices confidencial
Delivery Address 04
string delivery_address_05 Tax Invoices confidencial
Delivery Address 05
string printed Tax Invoices
Printed
integer tax_period_id Tax Invoices
Tax Period Id
integer editable Tax Invoices
Editable
integer has_attachments Tax Invoices
Has Attachments
integer has_notes Tax Invoices
Has Notes
integer has_anticipated_date Tax Invoices
Has Anticipated Date
integer has_special_country_tax Tax Invoices
Has Special Country Tax
integer