PurchaseOrderLine 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		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
VendorRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
VendorRef_FullName	12	VARCHAR	41	True	True	True	False	%s	Name	1.0	US, CA, UK
ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s	Name	1.0	US, CA, UK
InventorySiteRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	10.0	US, CA, UK
InventorySiteRef_FullName	12	VARCHAR	31	True	True	True	True	%s	Name	10.0	US, CA, UK
ShipToEntityRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ShipToEntityRef_FullName	12	VARCHAR	209	True	True	True	False	%s	Name	1.0	US, CA, UK
TemplateRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	3.0	US, CA, UK
TemplateRef_FullName	12	VARCHAR	159	True	True	True	False	%s	Name	3.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
RefNumber	12	VARCHAR	11	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
VendorAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
VendorAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Country	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
VendorAddress_Note	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
VendorAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
VendorAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
VendorAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
VendorAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
VendorAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr3	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Addr4	12	VARCHAR	41	True	True	True	False	%s		2.0	US, CA, UK
ShipAddress_Addr5	12	VARCHAR	41	True	True	True	False	%s		6.0	US, CA, UK
ShipAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Country	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
ShipAddress_Note	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
ShipAddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
ShipAddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
TermsRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
TermsRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
DueDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
ExpectedDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
ShipMethodRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
ShipMethodRef_FullName	12	VARCHAR	15	True	True	True	False	%s	Name	1.0	US, CA, UK
FOB	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
TotalAmount	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
ExchangeRate	2	NUMERIC	18	True	True	True	False	%6.6f		8.0	US, CA, UK
TotalAmountInHomeCurrency	2	NUMERIC	15	True	False	False	False	%10.2f		8.0	US, CA, UK
IsManuallyClosed	-7	BIT	2	True	True	True	False	1 0 true false		2.1	US, CA, UK
IsFullyReceived	-7	BIT	2	True	False	False	False	1 0 true false		2.1	US, CA, UK
Memo	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
VendorMsg	12	VARCHAR	99	True	True	True	False	%s		1.0	US, CA, UK
IsToBePrinted	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
IsToBeEmailed	-7	BIT	2	True	True	True	False	1 0 true false		6.0	US, CA, UK
Other1	12	VARCHAR	29	True	True	True	False	%s		6.0	US, CA, UK
Other2	12	VARCHAR	29	True	True	True	False	%s		6.0	US, CA, UK
ExternalGUID	12	VARCHAR	40							9.0	US, CA, UK
PurchaseOrderLineType	12	VARCHAR	11	True	False	False	False	ItemType		1.0	US, CA, UK
PurchaseOrderLineGroup_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
PurchaseOrderLineGroup_ItemGroupRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLineGroup_ItemGroupRef_FullName	12	VARCHAR	31	True	True	True	False	%s	FullName	1.0	US, CA, UK
PurchaseOrderLineGroup_Desc	12	VARCHAR	4095	True	False	False	False	%s		1.0	US, CA, UK
PurchaseOrderLineGroup_Quantity	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
PurchaseOrderLineGroup_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Name	1.0	US, CA, UK
PurchaseOrderLineGroup_OverrideUOMSetRef_ListID	12	VARCHAR	36	True	True	False	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLineGroup_OverrideUOMSetRef_FullName	12	VARCHAR	31	True	True	False	False	%s	Name	1.0	US, CA, UK
PurchaseOrderLineGroup_IsPrintItemsInGroup	-7	BIT	2	True	False	False	False	1 0 true false		1.0	US, CA, UK
PurchaseOrderLineGroup_TotalAmount	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
PurchaseOrderLineGroup_InventorySiteLocationRef_ListID	12	VARCHAR	36	True	True	True	True	%s		1.0	US, CA, UK
PurchaseOrderLineGroup_InventorySiteLocationRef_FullName	12	VARCHAR	31	True	True	True	True	%s		1.0	US, CA, UK
PurchaseOrderLine_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		1.0	US, CA, UK
PurchaseOrderLine_ItemRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLine_ItemRef_FullName	12	VARCHAR	36	True	True	True	False	%s	FullName	1.0	US, CA, UK
PurchaseOrderLine_ManufacturerPartNumber	12	VARCHAR	31	True	True	True	False	%s		7.0	US, CA, UK
PurchaseOrderLine_Desc	12	VARCHAR	4095	True	True	True	False	%s		1.0	US, CA, UK
PurchaseOrderLine_Quantity	4	INTEGER	9	True	True	True	False	%10.5f		1.0	US, CA, UK
PurchaseOrderLine_UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Name	7.0	US, CA, UK
PurchaseOrderLine_OverrideUOMSetRef_ListID	12	VARCHAR	36	True	True	False	False	%s	ListID	7.0	US, CA, UK
PurchaseOrderLine_OverrideUOMSetRef_FullName	12	VARCHAR	159	True	True	False	False	%s	Name	7.0	US, CA, UK
PurchaseOrderLine_Rate	2	NUMERIC	15	True	True	True	False	%10.5f		1.0	US, CA, UK
PurchaseOrderLine_ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLine_ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	1.0	US, CA, UK
PurchaseOrderLine_Amount	2	NUMERIC	15	True	True	True	False	%10.2f		1.0	US, CA, UK
PurchaseOrderLine_InventorySiteLocationRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	12.0	US, CA, UK
PurchaseOrderLine_InventorySiteLocationRef_FullName	12	VARCHAR	31	True	True	True	True	%s	Name	12.0	US, CA, UK
PurchaseOrderLine_CustomerRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLine_CustomerRef_FullName	12	VARCHAR	209	True	True	True	False	%s	FullName	1.0	US, CA, UK
PurchaseOrderLine_ServiceDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		1.0	US, CA, UK
PurchaseOrderLine_ReceivedQuantity	2	NUMERIC	18	True	False	False	False	%10.5f		1.1	US, CA, UK
PurchaseOrderLine_UnbilledQuantity	2	NUMERIC	18	True	False	False	False	%10.5f		11.0	US, CA, UK
PurchaseOrderLine_IsBilled	-7	BIT	2	True	True	False	False	1 0 true false		11.0	US, CA, UK
PurchaseOrderLine_IsManuallyClosed	-7	BIT	2	True	True	True	False	1 0 true false		2.1	US, CA, UK
PurchaseOrderLine_OverrideItemAccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	1.0	US, CA, UK
PurchaseOrderLine_OverrideItemAccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	1.0	US, CA, UK
PurchaseOrderLine_Other1	12	VARCHAR	29	True	True	True	False	%s		6.0	US, CA, UK
PurchaseOrderLine_Other2	12	VARCHAR	29	True	True	True	False	%s		6.0	US, CA, UK
RQUseCachedID	-7	BIT	2

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.

• 
• 
•