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.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•