Returns a listing that only includes purchase orders that begin with or are equal to a specified number.
GetPOListingByPONumber(PONumber AS String, IncludeDeleted AS Boolean)
XML String
PONumber = Search string for purchase order number.
IncludeDeleted = Select to include deleted records in the results.
XML String has the following structure:
|
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 |
Date |
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 |
Date |
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. |