Retrieve Purchase Order Headers By Code
  • 26 Sep 2024
  • 2 Minutes to read
  • Dark
    Light

Retrieve Purchase Order Headers By Code

  • Dark
    Light

Article summary

Get
/po-rest-api/rest/1/pomaster

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

  • Select by Company Status
  • Select by Code
  • Select by Date
  • By UUID

Select by Company Status

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
CompanyCodeCompany Code001
AuditDateAudit Date2016-01-01
StatCodeStatus CodeA

Select by Code

This is the recommended finder for querying equipment rates by Company Code, Master Number and Release Number.

ParameterDescriptionSample
compCodeCompany Code001
masterNumMaster Number16.000019
releaseNumRelease Number1

Select by Date

This is an optional finder for querying equipment rates by Audit Date.

ParameterDescriptionSample
AuditDateCreate or update date time filter2022-12-20

By UUID

This is an optional finder for querying a specific equipment rate by row ID.

ParameterDescriptionSample
/VUUIDThe VUuid attribute is the Unique row ID/po-rest-api/rest/1/pomaster/BD8E157311802691E05316821FAC4947
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleselectByCompanyStatus; AuditDate=2016-12-20, StatCode=A, CompanyCode=001
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExamplePomstNum:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourceitem+json
{
  "PomstAcctDescription": null,
  "PomstActionCode": null,
  "PomstAddCode": null,
  "PomstAddCompCode": "001",
  "PomstAddCompName": "CMiC Construction Inc",
  "PomstAddName": null,
  "PomstAdjCode": null,
  "PomstAdjPrice": null,
  "PomstBchNum": 389760,
  "PomstBilltoAddCode": "HQ",
  "PomstBilltoAddName": "Corporate Headquarters 1 Liberty Plaza, Suite 900 New York NY USA 10002",
  "PomstBuyCode": "CANDICE",
  "PomstBuyName": "CANDICE FRANCIS",
  "PomstChgCode": "O",
  "PomstCompCode": "001",
  "PomstCompName": "CMiC Construction Inc",
  "PomstComplianceFlag": "Y",
  "PomstContactCode": "FD",
  "PomstContactName": "Fred Davidson",
  "PomstCostedCode": null,
  "PomstCurrCode": "USD",
  "PomstCurrConvNum": 1,
  "PomstDefaultRecCode": "M",
  "PomstDeptCode": null,
  "PomstDesc1": null,
  "PomstDesc2": null,
  "PomstDistTypeCode": "G",
  "PomstExptdDate": "2016-11-30",
  "PomstFobCode": null,
  "PomstFobName": null,
  "PomstHoldPaymentDays": 0,
  "PomstHoldPaymentFlag": "N",
  "PomstImageFilename": null,
  "PomstInvCode": null,
  "PomstInvDate": null,
  "PomstInvDiscAmt": null,
  "PomstInvDiscDate": null,
  "PomstInvDueDate": null,
  "PomstInvSerCode": null,
  "PomstInvTypeCode": null,
  "PomstJobCode": null,
  "PomstJobCompCode": "001",
  "PomstManPoRecFlag": null,
  "PomstNum": "16.000019",
  "PomstOrdDate": "2016-11-15",
  "PomstOrigBidpAmt": null,
  "PomstPoAmount": 741375,
  "PomstPorgrCode": null,
  "PomstPrintStatus": null,
  "PomstRecCode": null,
  "PomstRecDate": null,
  "PomstRefDate": null,
  "PomstRefNum": null,
  "PomstReleaseNum": 1,
  "PomstReprintDate": null,
  "PomstReqCode": "CANDICE",
  "PomstReqName": "CANDICE FRANCIS",
  "PomstReqNum": null,
  "PomstReqReason": null,
  "PomstRoutCompCode": null,
  "PomstRoutJobCode": null,
  "PomstSelectFlag": "N",
  "PomstShipinstTxt1Code": null,
  "PomstShipinstTxt2Code": null,
  "PomstShipinstTxt3Code": null,
  "PomstShipinstTxt4Code": null,
  "PomstShipinstTxt5Code": null,
  "PomstShpinstDesc": null,
  "PomstShplneCode": null,
  "PomstShplneName": null,
  "PomstShpmetCode": null,
  "PomstShpmetName": null,
  "PomstStatCode": "O",
  "PomstStateDesc": "Processed",
  "PomstSuspDeptCode": null,
  "PomstSuspDeptName": null,
  "PomstTermCode": "NET30",
  "PomstTermDiscDay": 0,
  "PomstTermDiscPc": 0,
  "PomstTermDueDay": 30,
  "PomstTermName": "Net 30",
  "PomstTxt1Code": null,
  "PomstTxt2Code": null,
  "PomstTypeCode": "S",
  "PomstUnadjPrice": null,
  "PomstUserField1": null,
  "PomstUserField2": null,
  "PomstUserField3": null,
  "PomstVUuid": "BD8E157311802691E05316821FAC4947",
  "PomstVenCode": "1159",
  "PomstVenName": "Ace Supply Co. Inc.",
  "PomstVendOrderAddCode": null,
  "PomstWipAccCode": null,
  "PomstWipDeptCode": null,
  "PomstWkfPriorityCode": "1",
  "PomstIuCreateDate": "2016-10-28T07:44:14Z",
  "PomstIuUpdateDate": "2016-11-01T07:02:54Z",
  "PomstPostDate": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/po-rest-api/rest/1/pomaster/BD8E157311802691E05316821FAC4947",
      "name": "pomaster",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/po-rest-api/rest/1/pomaster/BD8E157311802691E05316821FAC4947",
      "name": "pomaster",
      "kind": "item"
    },
    {
      "rel": "child",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/po-rest-api/rest/1/pomaster/BD8E157311802691E05316821FAC4947/child/PoDetailViewObj",
      "name": "PoDetailViewObj",
      "kind": "collection"
    }
  ]
}
object