Contents x
    Retrieve Purchase Order Headers By Code
    • 06 Jan 2026
    • 4 Minutes to read
    • Print
    • Dark
      Light
    Contents

    Retrieve Purchase Order Headers By Code

    • Updated on 06 Jan 2026
    • 4 Minutes to read
    • Print
    • 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

    Attributes

    ElementTypeDescription
    PomstRowidvarchar2(8)Row ID
    PomstCompCodevarchar2(8)Company Code
    PomstCompNamevarchar2(30)Company Name
    PomstNumvarchar2(11)PO Number
    PomstBchNumnumber(11)Batch Number
    PomstVenCodevarchar2(8)Vendor Code
    PomstVenNamevarchar2(50)Vendor Name
    PomstDeptCodevarchar2(6)Department Code
    PomstExptdDatedateExpected Date
    PomstOrdDatedateOrdered Date
    PomstRecDatedateReceived Date
    PomstTypeCodevarchar2(1)PO Type Code
    PomstAdjCodevarchar2(1)Adjustment Code
    PomstStatCodevarchar2(1)Status Code
    PomstChgCodevarchar2(1)Change Code
    PomstTermCodevarchar2(6)Term Code
    PomstTermNamevarchar2(30)Term Name
    PomstTermDueDaynumber(3)Term Due Day
    PomstTermDiscDaynumber(3)Discount Day
    PomstTermDiscPcnumber(5,2)Discount Percentage
    PomstInvCodevarchar2(20)Invoice Code
    PomstInvDatedateInvoice Date
    PomstInvDueDatedateInvoice Due Date
    PomstInvDiscDatedateDiscount Date
    PomstInvDiscAmtnumber(18,2)Discount Amount
    PomstCurrCodevarchar2(3)Currency Code
    PomstFobCodevarchar2(2)FOB Code
    PomstFobNamevarchar2(30)FOB Name
    PomstBuyCodevarchar2(30)Buyer Code
    PomstBuyNamevarchar2(30)Buyer Name
    PomstAddCodevarchar2(8)Address Code
    PomstAddNamevarchar2(195)Address Name
    PomstShplneCodevarchar2(3)Shipline Code
    PomstShplneNamevarchar2(30)Shipline Name
    PomstShpmetCodevarchar2(5)Shipment Code
    PomstShpmetNamevarchar2(30)Shipment Name
    PomstTxt1Codevarchar2(8)Text Code 1
    PomstTxt2Codevarchar2(8)Text Code 2
    PomstShpinstDescvarchar2(2000)Shipping Instruction Description
    PomstDesc1varchar2(2000)Requisition Reason
    PomstDesc2varchar2(2000)Comment
    PomstAdjPricenumber(18,4)Adjusted Price
    PomstUnadjPricenumber(18,4)Unadjusted Price
    PomstCurrConvNumnumber(16,8)Currency Conversion Number
    PomstCostedCodevarchar2(1)Costed Code
    PomstRefNumvarchar2(11)Reference Number
    PomstRefDatedateReference Date
    PomstReqCodevarchar2(30)Requester Code
    PomstReqNamevarchar2(30)Requester Name
    PomstRecCodevarchar2(30)Rec Code
    PomstReprintDatedateReprint Date
    PomstWipAccCodevarchar2(16)WIP Account Code
    PomstWipDeptCodevarchar2(6)WIP Department Code
    PomstShipinstTxt1Codevarchar2(8)Shipping Instruction Text Code 1
    PomstShipinstTxt2Codevarchar2(8)Shipping Instruction Text Code 2
    PomstShipinstTxt3Codevarchar2(8)Shipping Instruction Text Code 3
    PomstShipinstTxt4Codevarchar2(8)Shipping Instruction Text Code 4
    PomstShipinstTxt5Codevarchar2(8)Shipping Instruction Text Code 5
    PomstSwoOraseqnumber(11)SWO ORASEQ
    PomstReleaseNumnumber(11)Release Number
    PomstBilltoAddCodevarchar2(8)Bill to Address Code
    PomstBilltoAddNamevarchar2(195)Bill to Address Name
    PomstReqReasonvarchar2(255)Request Reason
    PomstInvTypeCodevarchar2(1)Invoice Type Code
    PomstImageFilenamevarchar2(255)Image Filename
    PomstInvSerCodevarchar2(4)Invoice Service Code
    PomstVendOrderAddCodevarchar2(5)Vendor Order Address Code
    PomstComplianceFlagvarchar2(1)Compliance Flag
    PomstActionCodevarchar2(1)Action Code
    PomstPrintStatusvarchar2(1)Print Status
    PomstJobCompCodevarchar2(8)Job Company Code
    PomstJobCodevarchar2(10)Job Code
    PomstContactCodevarchar2(10)Contact Code
    PomstContactNamevarchar2(40)Contact Name
    PomstOrigBidpOraseqnumberOriginal Bid ORASEQ
    PomstOrigBidpAmtnumber(18,2)Original Bid Amount
    PomstHoldPaymentFlagvarchar2(1)Hold Payment Flag
    PomstHoldPaymentDaysnumber(4)Hold Payment Days
    PomstObjectOraseqnumberObject ORASEQ
    PomstAddCompCodevarchar2(8)Address Company Code
    PomstAddCompNamevarchar2(30)Address Company Name
    PomstSuspDeptCodevarchar2(6)Suspense Department Code
    PomstSuspDeptNamevarchar2(30)Suspense Department Name
    PomstIuCreateDatedateCreate Date
    PomstIuCreateUservarchar2(30)Create User
    PomstIuUpdateDatedateUpdate Date
    PomstIuUpdateUservarchar2(30)Update User
    PomstPorgrCodevarchar2(8)Porgr Code
    PomstWkfPriorityCodevarchar2(1)Workflow Priority Code
    PomstDefaultRecCodevarchar2(1)Default Receipt Code
    PomstRoutCompCodevarchar2(8)Routing Company Code
    PomstRoutJobCodevarchar2(10)Routing Job Code
    PomstDistTypeCodevarchar2(1)Distribution Type Code
    PomstUserField1varchar2(30)User Field 1
    PomstUserField2varchar2(30)User Field 2
    PomstUserField3varchar2(30)User Field 3
    PomstSelectFlagvarchar2(1)Select Flag
    PomstReqNumvarchar2(4000)Requisition Number
    PomstTenantIdvarchar2(30)Tenant ID
    DiscriminatorCodevarchar2Discriminator Code
    PomstManPoRecFlagvarchar2Manual PO Receipt Flag
    PomstAcctDescriptionvarchar2(500)Account Description
    PomstPoAmountnumberPO Amount
    PomstStateDescvarchar2(12)State Description
    PomstVUuidvarchar2(64)VUUID
    PomstPostDatedatePost Date
    PomstPopulateSummaryvarchar2(80)Populate Summary
    PomstAdvPayAmtnumber(18,2)Advance Pay Amount
    PomstAdvPayPctnumber(16,13)Advance Pay Percent
    PomstAdvPayMultiFlagvarchar2(1)Advance Pay Multi Flag
    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-28T19:44:14Z",
  "PomstIuUpdateDate": "2016-11-01T19: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
    What's Next
    Contact Us
    Copyright © 2024 CMiC All Rights Reserved