Preferences Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 4 INTEGER 9 True False False False FQID 1.1 US, CA, UK
AccountingPrefs_IsUsingAccountNumbers -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
AccountingPrefs_IsRequiringAccounts -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
AccountingPrefs_IsUsingClassTracking -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
AccountingPrefs_IsUsingAuditTrail -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
AccountingPrefs_IsAssigningJournalEntryNumbers -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
AccountingPrefs_ClosingDate 91 DATE 6 True False False False CCCC-MM-DD 1.1 US, CA, UK
FinanceChargePrefs_AnnualInterestRate 2 NUMERIC 18 True False False False %10.5f 1.1 US, CA, UK
FinanceChargePrefs_MinFinanceCharge 2 NUMERIC 15 True False False False %10.2f 1.1 US, CA, UK
FinanceChargePrefs_GracePeriod 4 INTEGER 4 True False False False %11.1f 1.1 US, CA, UK
FinanceChargePrefs_FinanceChargeAcctRefListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
FinanceChargePrefs_FinanceChargeAcctRefFullName 12 VARCHAR 159 True False False False %s FullName 1.1 US, CA, UK
FinanceChargePrefs_IsAssessingForOverdueCharges -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
FinanceChargePrefs_CalculateChargesFrom 12 VARCHAR 20 True False False False
DueDate
InvoiceOrBilledDate
 1.1 US, CA, UK
FinanceChargePrefs_IsMarkedToBePrinted -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
JobsAndEstimatesPrefs_IsUsingEstimates -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
JobsAndEstimatesPrefs_IsUsingProgressInvoicing -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
JobsAndEstimatesPrefs_IsPrintingItemsWithZeroAmounts -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
MultiCurrencyPrefs_IsMultiCurrencyOn -7 BIT 2 True False False False
1
0
true
false
 8.0 US, CA, UK
MultiCurrencyPrefs_HomeCurrencyRef_ListID 12 VARCHAR 36 True False False False %s ListID 8.0 US, CA, UK
MultiCurrencyPrefs_HomeCurrencyRef_FullName 12 VARCHAR 159 True False False False %s FullName 8.0 US, CA, UK
MultiLocationInventoryPrefs_IsMultiLocationInventoryAvailable -7 BIT 2 True False False False
1
0
true
false
 10.0 US, CA, UK
MultiLocationInventoryPrefs_IsMultiLocationInventoryEnabled -7 BIT 2 True False False False
1
0
true
false
 10.0 US, CA, UK
PurchasesAndVendorsPrefs_IsUsingInventory -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
PurchasesAndVendorsPrefs_DaysBillsAreDue 4 INTEGER 9 True False False False %11.1f 1.1 US, CA, UK
PurchasesAndVendorsPrefs_IsAutomaticallyUsingDiscounts -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
PurchasesAndVendorsPrefs_DefaultDiscountAccountRef_ListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
PurchasesAndVendorsPrefs_DefaultDiscountAccountRef_FullName 12 VARCHAR 159 True False False False %s FullName 1.1 US, CA, UK
ReportsPrefs_AgingReportBasis 12 VARCHAR 22 True False False False
AgeFromDueDate
AgeFromTransactionDate
 1.1 US, CA, UK
ReportsPrefs_SummaryReportBasis 12 VARCHAR 7 True False False False
Accrual
Cash
 1.1 US, CA, UK
SalesAndCustomersPrefs_DefaultShipMethRef_ListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
SalesAndCustomersPrefs_DefaultShipMethRef_FullName 12 VARCHAR 15 True False False False %s Name 1.1 US, CA, UK
SalesAndCustomersPrefs_DefaultFOB 12 VARCHAR 13 True False False False %s 1.1 US, CA, UK
SalesAndCustomersPrefs_DefaultMarkup 2 NUMERIC 18 True False False False %10.5f 1.1 US, CA, UK
SalesAndCustomersPrefs_IsTrackingReimbursedExpensesAsIncome -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
SalesAndCustomersPrefs_IsAutoApplyingPayments -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
SalesAndCustomersPrefs_PriceLevels_IsUsingPriceLevels -7 BIT 2 True False False False
1
0
true
false
 4.0 US, CA, UK
SalesAndCustomersPrefs_PriceLevels_IsRoundingSalesPriceUp -7 BIT 2 True False False False
1
0
true
false
 4.0 US, CA, UK
SalesTaxPrefs_DefaultItemSalesTaxRef_ListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
SalesTaxPrefs_DefaultItemSalesTaxRef_FullName 12 VARCHAR 31 True False False False %s Name 1.1 US, CA, UK
SalesTaxPrefs_PaySalesTax 12 VARCHAR 9 True False False False
Monthly
Quarterly
Annually
 1.1 US, CA, UK
SalesTaxPrefs_DefaultTaxableSaleTaxCodeRef_ListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
SalesTaxPrefs_DefaultTaxableSaleTaxCodeRef_FullName 12 VARCHAR 3 True False False False %s Name 1.1 US, CA, UK
SalesTaxPrefs_DefaultNonTaxableSaleTaxCodeRef_ListID 12 VARCHAR 36 True False False False %s ListID 1.1 US, CA, UK
SalesTaxPrefs_DefaultNonTaxableSaleTaxCodeRef_FullName 12 VARCHAR 3 True False False False %s Name 1.1 US, CA, UK
TimeTrackingPrefs_FirstDayOfWeek 12 VARCHAR 9 True False False False
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 1.1 US, CA, UK
CurrentAppAccessRights_IsAutomaticLoginAllowed -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
CurrentAppAccessRights_AutomaticLoginUserName 12 VARCHAR 29 True False False False %s 1.1 US, CA, UK
CurrentAppAccessRights_IsPersonalDataAccessAllowed -7 BIT 2 True False False False
1
0
true
false
 1.1 US, CA, UK
ItemsAndInventoryPrefs_EnhancedInventoryReceivingEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsTrackingSerialOrLotNumber 12 VARCHAR 12 True False False False None
SerialNumber
LotNumber		 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsTrackingOnSalesTransactionsEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsTrackingOnPurchaseTransactionsEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsTrackingOnInventoryAdjustmentEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsTrackingOnBuildAssemblyEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_FIFOEnabled -7 BIT 2 True False False False
1
0
true
false
 11.0 US, CA, UK
ItemsAndInventoryPrefs_FIFOEffectiveDate 91 DATE 10 True False False False CCCC-MM-DD 11.0 US, CA, UK
ItemsAndInventoryPrefs_IsRSBEnabled -7 BIT 2 True False False False
1
0
true
false
 12.0 US, CA, UK
ItemsAndInventoryPrefs_IsBarcodeEnabled -7 BIT 2 True False False False
1
0
true
false
 12.0 US, CA, UK

Back to list of tables.