GetPOInfo()

Returns detailed information for the specified purchase order(s). Returns three data sets: POHeader, PODetail, and PODisc.

XML String

XmlIds = XML String containing the PO Header Ids of the records to return. You must format this string using the XML IdList Structure Definition.

XML String contains the following structures:

POHeader

Field	Type	Length	Description
iId	Integer	4	Primary Key - Unique Identifier.
iLocationId	Integer	4	Not used.
cPONumber	String	13	Purchase Order number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing PO number)
iClassId	Integer	4	Product Class Id. Foreign Key to Product Class iId.
iManufId	Integer	4	Manufacturer Id. Foreign Key to Manufacturer iId.
iDistribId	Integer	4	Distributor Id. Foreign Key to Distributor iId.
nSortBy	Decimal	1,0	Not used.
nPST	Decimal	8	Total PST tax amount.
nGST	Decimal	8	Total GST tax amount.
dOrdered	DateTime	8	PO order date
mNotes	String		PO notes.
iEmpId	Integer	4	The Id of the employee who created the PO. Foreign Key to Employee lnfo iId.
nShipHand	Decimal	8	Shipping and Handling charges for the PO.
nInclude	Decimal	1,0	Indicates the type of products ordered. 1 = Retail and Professional Supplies 2 = Retail Only 3 = Professional Supplies Only
dDateDel	DateTime	8	Date deleted.
iGId	Integer	4	Global Id for the PO Header record.
lTaxShip	Boolean	1	Indicates whether Shipping/Handling is taxable.
lOrderFromCO	Boolean	1	Indicates whether the order is for the Central Office warehouse.
cRefNumber	String	13	Distributor reference number.
iInvCreditId	Integer	4	Invoice Credit Id.
iInvCreditLocationId	Integer	4	Id for the location that received the invoice credit.

PODetail

Field	Type	Length	Description
cCode	String	10	Product Code
cUPCCode	String	14	Product UPC Code.
cDistCode	String	14	The Distributor Product Id field displays the distributor’s product Id.
iId	Integer	4	Primary Key - Unique Identifier.
iLocationId	Integer	4	Not used.
iHeaderId	Integer	4	PO Header Id. Foreign Key to PO Header iId.
iProdId	Integer	4	Product Id. Foreign Key to Products iId.
lPreTaxed	Boolean	1	Indicates whether the distributor charges tax on the product.
dExpected	DateTime	8	Expected date for item.
nStatus	Decimal	1,0	Indicates the status of the item. 1 = On Order 2 = Partially Received 3 = Received In Full 4 = Back Ordered
nQuantity	Decimal	4,0	Quantity Ordered.
nPrice	Decimal	8	Price of each item.
cDiscount	String	5	Discount type given. % = Percentage off discount $ = Fixed dollar off or a spread discount S = "Special price" or a price override
nLineNo	Integer	4	Item line number.
nCost	Decimal	8	Cost of item.
nReceived	Decimal	4,0	Quantity of item received.
dReceived	DateTime	8	Date received.
lCounted	Boolean	1	Indicates whether you received the product.
iRecvdBy	Integer	4	The Id of the employee who received the PO. Foreign Key to Employee Info iId.
iGId	Integer	4	Global Id for the PO Detail record.

PODisc

Note: PO Discounts only contains records for discounted items in the purchase order.

Field	Type	Length	Description
iId	Integer	4	Primary Key - Unique Identifier.
iLocationId	Integer	4	Not used.
cDiscType	String	1	Discount type given. % = Percentage off discount $ = Fixed dollar off or a spread discount S = "Special price" or a price override
cPONumber	String	13	Purchase Order number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing PO number)
iHeaderId	Integer	4	PO Detail Id. Foreign Key to PO Detail iId.
nPercent	Decimal	6,2	Indicates percentage off discount.
nDiscAmount	Decimal	8	Indicates the total amount discounted off item.
nLineNo	Integer	4	Item line number.
mNote	String		Discount note.
iGId	Integer	4	Global Id for the PO Discount record.