TABLE DETAIL REFERENCE:
  
(AUSTRALIA/NZ VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
Id Integer 13 True False False N/A FQID
AccountingPrefsIsUsingAccountNumbers Bit 5 True False False N/A 1 0 true false
AccountingPrefsIsRequiringAccounts Bit 5 True False False N/A 1 0 true false
AccountingPrefsIsUsingClassTracking Bit 5 True False False N/A 1 0 true false
AccountingPrefsIsUsingAuditTrail Bit 5 True False False N/A 1 0 true false
AccountingPrefsIsAssigningJournalEntryNumbers Bit 5 True False False N/A 1 0 true false
AccountingPrefsClosingDate Date 10 True False False N/A CCCC-MM-DD
AccountingPrefsIsUsingMulticurrency Bit 5 True False False N/A 1 0 true false
AccountingPrefsHomeCurrencyRefListID Varchar 36 True False False N/A String
AccountingPrefsHomeCurrencyRefFullName Varchar 100 True False False N/A String
AccountingPrefsIsUsingForeignPricesOnItems Bit 5 True False False N/A 1 0 true false
AccountingPrefsForeignCurrencyRefListID Varchar 36 True False False N/A String
AccountingPrefsForeignCurrencyRefFullName Varchar 100 True False False N/A String
FinanceChargePrefsAnnualInterestRate Decimal 13 True False False N/A 7.5
FinanceChargePrefsMinFinanceCharge Decimal 11 True False False N/A 8.2
FinanceChargePrefsGracePeriod Integer 13 True False False N/A 11.0
FinanceChargePrefsFinanceChargeAcctRefListID Varchar 36 True False False N/A String
FinanceChargePrefsFinanceChargeAcctRefFullName Varchar 159 True False False N/A String
FinanceChargePrefsIsAssessingForOverdueCharges Bit 5 True False False N/A 1 0 true false
FinanceChargePrefsCalculateChargesFrom Varchar 20 True False False N/A DueDate InvoiceOrBilledDate
FinanceChargePrefsIsMarkedToBePrinted Bit 5 True False False N/A 1 0 true false
JobsAndEstimatesPrefsIsUsingEstimates Bit 5 True False False N/A 1 0 true false
JobsAndEstimatesPrefsIsUsingProgressInvoicing Bit 5 True False False N/A 1 0 true false
JobsAndEstimatesPrefsIsPrintItemsWithZeroAmt Bit 5 True False False N/A 1 0 true false
PurchasesAndVendorsPrefsIsUsingInventory Bit 5 True False False N/A 1 0 true false
PurchasesAndVendorsPrefsDaysBillsAreDue Integer 13 True False False N/A 11.0
PurchasesAndVendorsPrefsIsAutomaticUsingDis Bit 5 True False False N/A 1 0 true false
PurchasesAndVendorsPrefDefaultDisARefListID Varchar 36 True False False N/A String
PurchasesAndVendorsPrefDefaultDisARefFullName Varchar 159 True False False N/A String
PurchasesAndVendorsPrefsIsUsingUnitsOfMeasure Bit 5 True False False N/A 1 0 true false
ReportsPrefsAgingReportBasis Varchar 22 True False False N/A AgeFromDueDate AgeFromTransactionDate
ReportsPrefsSummaryReportBasis Varchar 7 True False False N/A Accrual Cash
ReportsPrefsReportAmountIncludeVAT Bit 5 True False False N/A 1 0 true false
SalesAndCustomersPrefsDeftShipMethRefListID Varchar 36 True False False N/A String
SalesAndCustomersPrefsDeftShipMethRefFullName Varchar 15 True False False N/A String
SalesAndCustomersPrefsDefaultFOB Varchar 13 True False False N/A String
SalesAndCustomersPrefsDefaultMarkup Decimal 13 True False False N/A 7.5
SalesAndCustomersPrefsIsTrackingRembrsdExpInc Bit 5 True False False N/A 1 0 true false
SalesAndCustomersPrefsIsAutoApplyingPayments Bit 5 True False False N/A 1 0 true false
SalesAndCustomersPrefsIsUsingUnitsOfMeasure Bit 5 True False False N/A 1 0 true false
TaxPrefsChargeTax1 Bit 5 True False False N/A 1 0 true false
TaxPrefsTrackTax1Expenses Bit 5 True False False N/A 1 0 true false
TaxPrefsTax1Number Varchar 50 True False False N/A String
TaxPrefsTax1AgencyRefListID Varchar 36 True False False N/A String
TaxPrefsTax1AgencyRefFullName Varchar 41 True False False N/A String
TaxPrefsTax1ReportingPeriod Varchar 50 True False False N/A String
TaxPrefsChargeTax2 Bit 5 True False False N/A 1 0 true false
TaxPrefsTrackTax2Expenses Bit 5 True False False N/A 1 0 true false
TaxPrefsTax2Number Varchar 50 True False False N/A String
TaxPrefsTax2AgencyRefListID Varchar 36 True False False N/A String
TaxPrefsTax2AgencyRefFullName Varchar 41 True False False N/A String
TaxPrefsTax2ReportingPeriod Varchar 50 True False False N/A String
TaxPrefsAllowCustomerTaxCodes Bit 5 True False False N/A 1 0 true false
TaxPrefsPaySalesTax Varchar 9 True False False N/A Monthly Quarterly Annually
TaxPrefsDefaultCustomerTaxCodesRefListID Varchar 36 True False False N/A String
TaxPrefsDefaultCustomerTaxCodesRefFullName Varchar 3 True False False N/A String
TimeTrackingPrefsFirstDayOfWeek Varchar 9 True False False N/A Monday Tuesday Wednesday Thursday Friday Saturday Sunday
CurrentAppAccessRightsIsAutomaticLoginAllowed Bit 5 True False False N/A 1 0 true false
CurrentAppAccessRightsAutomaticLoginUserName Varchar 29 True False False N/A String
CurrentAppAccessRightsIsPersonalDataAccAllowed Bit 5 True False False N/A 1 0 true false