Item 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
ListID	12	VARCHAR	36	True	False	False	False	%s		1.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		1.0	US, CA, UK
Name	12	VARCHAR	31	True	True	True	True	%s		1.0	US, CA, UK
FullName	12	VARCHAR	209	True	False	False	False	%s		1.0	US, CA, UK
Type	12	VARCHAR	32							1.0	US, CA, UK
BarCode_Value	12	VARCHAR	50	True	True	True	False	%s		12.0	US, CA, UK
ItemDesc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
IsActive	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s		12.0	US, CA, UK
ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s		12.0	US, CA, UK
ParentRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
ParentRef_FullName	12	VARCHAR	159	True	True	True	False	%s		1.0	US, CA, UK
Sublevel	4	INTEGER	9	True	False	False	False	%11.0f		1.0	US, CA, UK
ManufacturerPartNumber	12	VARCHAR	31	True	True	True	False	%s		7.0	US, CA, UK
UnitOfMeasureSetRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	7.0	US, CA, UK
UnitOfMeasureSetRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	7.0	US, CA, UK
SalesTaxCodeRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesTaxCodeRef_FullName	12	VARCHAR	3	True	True	True	False	%s	Name	1.0	US, CA, UK
SalesOrPurchase_Desc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
SalesOrPurchase_Price	2	NUMERIC	15	True	True	True	True	%10.5f		1.0	US, CA, UK
SalesOrPurchase_PricePercent	2	NUMERIC	15	True	True	True	True	%10.5f		1.0	US, CA, UK
SalesOrPurchase_AccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
SalesOrPurchase_AccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
SalesAndPurchase_SalesDesc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
SalesAndPurchase_SalesPrice	3	DECIMAL	18	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesAndPurchase_IncomeAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
SalesAndPurchase_IncomeAccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
SalesAndPurchase_ApplyIncomeAccountRefToExistingTxns	-7	BIT	1	True	True	False	False	1 0 true false		1.0	US, CA, UK
SalesAndPurchase_PurchaseDesc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
SalesAndPurchase_PurchaseCost	3	DECIMAL	18	True	True	True	False	%10.5f		1.0	US, CA, UK
SalesAndPurchase_ExpenseAccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
SalesAndPurchase_ExpenseAccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
SalesAndPurchase_PrefVendorRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
SalesAndPurchase_PrefVendorRef_FullName	12	VARCHAR	41	True	True	True	False	%s	Name	1.0	US, CA, UK
SalesDesc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
SalesPrice	2	NUMERIC	18	True	True	True	False	%10.5f		1.0	US, CA, UK
IncomeAccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
IncomeAccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
PurchaseDesc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
PurchaseCost	2	NUMERIC	15	True	True	True	False	%10.5f		1.0	US, CA, UK
COGSAccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
COGSAccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
PrefVendorRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PrefVendorRef_FullName	12	VARCHAR	41	True	True	True	False	%s	FullName	1.0	US, CA, UK
AssetAccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
AssetAccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
ReorderPoint	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
BuildPoint	4	INTEGER	9							2.0	US, CA, UK
QuantityOnHand	4	INTEGER	9	True	False	True	False	%10.5f		1.0	US, CA, UK
AverageCost	3	DECIMAL	18	True	False	False	False	%10.5f		1.0	US, CA, UK
QuantityOnOrder	4	INTEGER	9	True	False	False	False	%10.5f		1.0	US, CA, UK
QuantityOnSalesOrder	4	INTEGER	9	True	False	False	False	%10.5f		2.0	US, CA, UK
VendorOrPayeeName	12	VARCHAR	50	True	True	True	False	%s		3.0	US, CA, UK
FixedAssetSalesInfo_SalesDesc	12	VARCHAR	50	True	True	True	False	%s		3.0	US, CA, UK
FixedAssetSalesInfo_SalesDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		3.0	US, CA, UK
FixedAssetSalesInfo_SalesPrice	2	NUMERIC	15	True	True	True	False	%10.5f		3.0	US, CA, UK
FixedAssetSalesInfo_SalesExpense	2	NUMERIC	15	True	True	True	False	%10.5f		3.0	US, CA, UK
AssetDesc	12	VARCHAR	50	True	True	True	False	%s		3.0	US, CA, UK
Location	12	VARCHAR	50	True	True	True	False	%s		3.0	US, CA, UK
PONumber	12	VARCHAR	30	True	True	True	False	%s		3.0	US, CA, UK
SerialNumber	12	VARCHAR	30	True	True	True	False	%s		3.0	US, CA, UK
WarrantyExpDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		3.0	US, CA, UK
Notes	12	VARCHAR	4095	True	True	True	False	%s		3.0	US, CA, UK
AssetNumber	12	VARCHAR	10	True	True	True	False	%s		3.0	US, CA, UK
CostBasis	2	NUMERIC	15	True	True	True	False	%10.2f		3.0	US, CA, UK
YearEndAccumulatedDepreciation	2	NUMERIC	15	True	True	True	False	%10.2f		3.0	US, CA, UK
YearEndBookValue	2	NUMERIC	15	True	True	True	False	%10.2f		3.0	US, CA, UK
DiscountRate	2	NUMERIC	15	True	True	True	True	%10.5f		1.0	US, CA, UK
DiscountRatePercent	2	NUMERIC	18	True	True	True	True	%10.5f		1.0	US, CA, UK
AccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
AccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	fullname	1.0	US, CA, UK
DepositToAccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	1.0	US, CA, UK	ListID
DepositToAccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	1.0	US, CA, UK	FullName
PaymentMethodRef_ListID	12	VARCHAR	31	True	True	True	False	%s	1.0	US, CA, UK	ListID
PaymentMethodRef_FullName	12	VARCHAR	31	True	True	True	False	%s	1.0	US, CA, UK	Name
TaxVendorRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
TaxVendorRef_FullName	12	VARCHAR	41	True	True	True	False	%s	Name	1.0	US, CA, UK
IsPrintItemsInGroup	-7	BIT	1	True	True	True	False	1 0 true false		1.0	US, CA, UK
SpecialItemType	12	VARCHAR	24	True	False	False	False	FinanceCharge ReimbursableExpenseGroup ReimbursableExpenseSubtotal	SpecialItemType	6.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.

• 
• 
•