Retrieve Purchase Order Headers By Code
    • 25 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