ChecksItemLine 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	12	VARCHAR	115
TxnID	12	VARCHAR	36	True	False	False	False	%s	TxnID	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
TxnNumber	4	INTEGER	9	True	False	False	False	%11.0f		1.0	US, CA, UK
AccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
AccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	1.0	US, CA, UK
PayeeEntityRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PayeeEntityRef_FullName	12	VARCHAR	209	True	True	True	False	%s	FullName	1.0	US, CA, UK
RefNumber	12	VARCHAR	11	True	True	True	False	%s		1.0	US, CA, UK
TxnDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
TxnDateMacro	12	VARCHAR	25	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear		1.0	US, CA, UK
Amount	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
CurrencyRef_ListID	12	VARCHAR	36	True	False	False	False	%s	ListID	8.0	US, CA, UK
CurrencyRef_FullName	12	VARCHAR	64	True	False	False	False	%s	Name	8.0	US, CA, UK
AmountInHomeCurrency	2	NUMERIC	15	True	False	False	False	%10.2f		8.0	US, CA, UK
Memo	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
Address_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Address_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Address_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Address_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
Address_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
Address_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
Address_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
Address_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
Address_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
Address_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
AddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
IsToBePrinted	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
ExchangeRate	2	NUMERIC	18	True	True	True	False	%6.6f		8.0	US, CA, UK
ExternalGUID	12	VARCHAR	40							9.0	US, CA, UK
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType		1.0	US, CA, UK
ItemGroupLine_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
ItemGroupLine_ItemGroupRef_ListID	12	VARCHAR	36					%s	ListID	1.0	US, CA, UK
ItemGroupLine_ItemGroupRef_FullName	12	VARCHAR	31					%s	FullName	1.0	US, CA, UK
ItemGroupLine_Desc	12	VARCHAR	4095	True	False	False	False	%s		1.0	US, CA, UK
ItemGroupLine_Quantity	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
ItemGroupLine_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
ItemGroupLine_InventorySiteRef_ListID	12	VARCHAR	36					%s		1.0	US, CA, UK
ItemGroupLine_InventorySiteRef_FullName	12	VARCHAR	31					%s		1.0	US, CA, UK
ItemGroupLine_InventorySiteLocationRef_ListID	12	VARCHAR	36					%s		1.0	US, CA, UK
ItemGroupLine_InventorySiteLocationRef_FullName	12	VARCHAR	31					%s		1.0	US, CA, UK
ItemGroupLine_OverrideUOMSetRef_ListID	12	VARCHAR	36	True	True	False	False	%s	ListID	1.0	US, CA, UK
ItemGroupLine_OverrideUOMSetRef_FullName	12	VARCHAR	31	True	True	False	False	%s	Name	1.0	US, CA, UK
ItemGroupLine_TotalAmount	2	NUMERIC	18					%s		1.0	US, CA, UK
ItemLine_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
ItemLine_ItemRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	1.0	US, CA, UK
ItemLine_ItemRef_FullName	12	VARCHAR	159	True	True	True	True	%s	Name	1.0	US, CA, UK
ItemLine_InventorySiteRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemLine_InventorySiteRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
ItemLine_InventorySiteLocationRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
Itemline_InventorySiteLocationRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
ItemLine_SerialNumber	12	VARCHAR	4095	True	True	True	True	%s		1.0	US, CA, UK
ItemLine_LotNumber	12	VARCHAR	40	True	True	True	True	%s		1.0	US, CA, UK
ItemLine_Desc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
ItemLine_Quantity	2	NUMERIC	18	True	True	True	False	%10.5f		1.0	US, CA, UK
ItemLine_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ItemLine_OverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	ListID	1.0	US, CA, UK
ItemLine_OverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Name	1.0	US, CA, UK
ItemLine_Cost	2	NUMERIC	18	True	True	True	False	%10.5f		1.0	US, CA, UK
ItemLine_Amount	2	NUMERIC	15	True	True	True	False	%10.2f		1.0	US, CA, UK
ItemLine_CustomerRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemLine_CustomerRef_FullName	12	VARCHAR	209	True	True	True	False	%s	FullName	1.0	US, CA, UK
ItemLine_ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemLine_ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	1.0	US, CA, UK
ItemLine_BillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled		1.0	US, CA, UK
ItemLine_OverrideItemAccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ItemLine_OverrideItemAccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	fullname	1.0	US, CA, UK
ItemLine_SalesRepRef_ListID	12	VARCHAR	36	True	True	True	False	%s		1.0	US, CA, UK
ItemLine_SalesRepRef_FullName	12	VARCHAR	5	True	True	True	False	%s		1.0	US, CA, UK
RQUseCachedID	-7	BIT	2

• 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.

• 
• 
•