Oracle Retail · Schema

PurchaseOrder

A purchase order header

RetailMerchandisingOrder ManagementPricingInventoryPoint-of-SaleOmnichannelOracle

Properties

Name Type Description
orderId integer Order number
supplier integer Supplier number
status string W=Worksheet, A=Approved, C=Closed, T=Terminated, D=Deleted
orderDate string
notBeforeDate string
notAfterDate string
freightTerms string
paymentTerms string
currencyCode string
totalCost number
totalRetail number
createDatetime string
lastUpdateDatetime string
View JSON Schema on GitHub

JSON Schema

oracle-retail-purchaseorder-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/PurchaseOrder",
  "title": "PurchaseOrder",
  "type": "object",
  "description": "A purchase order header",
  "properties": {
    "orderId": {
      "type": "integer",
      "description": "Order number"
    },
    "supplier": {
      "type": "integer",
      "description": "Supplier number"
    },
    "status": {
      "type": "string",
      "enum": [
        "W",
        "A",
        "C",
        "T",
        "D"
      ],
      "description": "W=Worksheet, A=Approved, C=Closed, T=Terminated, D=Deleted"
    },
    "orderDate": {
      "type": "string",
      "format": "date"
    },
    "notBeforeDate": {
      "type": "string",
      "format": "date"
    },
    "notAfterDate": {
      "type": "string",
      "format": "date"
    },
    "freightTerms": {
      "type": "string"
    },
    "paymentTerms": {
      "type": "string"
    },
    "currencyCode": {
      "type": "string",
      "maxLength": 3
    },
    "totalCost": {
      "type": "number",
      "format": "double"
    },
    "totalRetail": {
      "type": "number",
      "format": "double"
    },
    "createDatetime": {
      "type": "string",
      "format": "date-time"
    },
    "lastUpdateDatetime": {
      "type": "string",
      "format": "date-time"
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/oracle-retail-purchaseorder"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.