Oracle E-Business Suite · Schema
Oracle EBS Purchase Order
Schema representing a purchase order in Oracle E-Business Suite Purchasing module. Maps to PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL tables.
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| poHeaderId | integer | Unique identifier for the purchase order header (PO_HEADERS_ALL.PO_HEADER_ID) |
| segment1 | string | Purchase order number (PO_HEADERS_ALL.SEGMENT1) |
| typeLookupCode | string | Purchase order type |
| revisionNum | integer | Document revision number |
| vendorId | integer | Supplier/vendor identifier (AP_SUPPLIERS.VENDOR_ID) |
| vendorName | string | Supplier/vendor name |
| vendorSiteId | integer | Vendor site identifier (AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID) |
| vendorSiteCode | string | Vendor site code |
| vendorContactId | integer | Vendor contact identifier |
| currencyCode | string | Document currency code (ISO 4217) |
| rateType | stringnull | Currency exchange rate type |
| rate | numbernull | Currency exchange rate |
| rateDate | stringnull | Exchange rate date |
| agentId | integer | Buyer/agent employee identifier |
| authorizationStatus | string | Authorization/approval status of the purchase order |
| approvedFlag | string | Whether the PO has been approved |
| approvedDate | stringnull | Date the purchase order was approved |
| closedCode | string | Close status of the purchase order |
| closedDate | stringnull | Date the purchase order was closed |
| shipToLocationId | integer | Default ship-to location identifier (HR_LOCATIONS_ALL.LOCATION_ID) |
| billToLocationId | integer | Default bill-to location identifier |
| termsId | integer | Payment terms identifier (AP_TERMS.TERM_ID) |
| description | stringnull | Purchase order description |
| comments | stringnull | Purchase order comments |
| totalAmount | number | Total purchase order amount |
| confirmedFlag | string | |
| printCount | integer | Number of times the PO has been printed |
| lines | array | Purchase order lines |
| orgId | integer | Operating unit identifier (HR_OPERATING_UNITS.ORGANIZATION_ID) |
| createdBy | integer | User who created the record (FND_USER.USER_ID) |
| creationDate | string | Record creation date |
| lastUpdatedBy | integer | User who last updated the record |
| lastUpdateDate | string | Record last update date |