Purchase Order With Line Items

PurchaseOrderWithLineItems

25 columns Fetched February 27, 2026

Related Reports

Invoice Agreement Additions 2 shared Invoice Product 2 shared Document 1 shared IVProduct Bundle 1 shared Inventory Item 1 shared

Columns

IV_Item_RecID Numeric

Also in 5 reports

Inventory Item Invoice Agreement Additions Invoice Product Managed Device XRef Pricing Schedule

Item_ID Text nullable

Serialized_Flag Boolean nullable

Description Text nullable

Quantity Numeric nullable

Received_Qty Numeric nullable

received_status Text

Purchase_Detail_RecID Numeric

Purchase_Header_RecID Numeric

Also in 2 reports

Document Purchase Order Template Products

PO_Number Text nullable

Line_Number Numeric nullable

itemUOM Text nullable

itemunitcost Numeric nullable

Vendor_SKU Text nullable

shipmethoddescription Text nullable

tracking_number Text nullable

tracking_url Text nullable

Updated_By Text nullable

Last_Update DateTime

Time_Zone Text nullable

Received Boolean

Date_Received DateTime nullable

Backorder_Flag Boolean

Expected_Ship_Date DateTime nullable

IV_Product_RecID Numeric nullable

Also in 5 reports

IVProduct Bundle Invoice Agreement Additions Invoice Product Product Product Detail

Name	Type	Nullable	Also In
IV_Item_RecID	Numeric	No	5 reports Inventory Item Invoice Agreement Additions Invoice Product Managed Device XRef Pricing Schedule
Item_ID	Text	Yes	unique
Serialized_Flag	Boolean	Yes	unique
Description	Text	Yes	unique
Quantity	Numeric	Yes	unique
Received_Qty	Numeric	Yes	unique
received_status	Text	No	unique
Purchase_Detail_RecID	Numeric	No	unique
Purchase_Header_RecID	Numeric	No	2 reports Document Purchase Order Template Products
PO_Number	Text	Yes	unique
Line_Number	Numeric	Yes	unique
itemUOM	Text	Yes	unique
itemunitcost	Numeric	Yes	unique
Vendor_SKU	Text	Yes	unique
shipmethoddescription	Text	Yes	unique
tracking_number	Text	Yes	unique
tracking_url	Text	Yes	unique
Updated_By	Text	Yes	unique
Last_Update	DateTime	No	unique
Time_Zone	Text	Yes	unique
Received	Boolean	No	unique
Date_Received	DateTime	Yes	unique
Backorder_Flag	Boolean	No	unique
Expected_Ship_Date	DateTime	Yes	unique
IV_Product_RecID	Numeric	Yes	5 reports IVProduct Bundle Invoice Agreement Additions Invoice Product Product Product Detail