Oracle E-Business Suite · Schema
SalesOrder
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| headerId | integer | Order header identifier |
| orderNumber | integer | Order number |
| orderedDate | string | Order date |
| orderTypeId | integer | Order type identifier |
| orderTypeName | string | Order type name |
| soldToOrgId | integer | Customer identifier (sold-to) |
| customerName | string | Customer name |
| shipToOrgId | integer | Ship-to organization identifier |
| invoiceToOrgId | integer | Bill-to organization identifier |
| transactionalCurrCode | string | Transaction currency code (ISO 4217) |
| flowStatusCode | string | Order flow status |
| bookedFlag | string | |
| totalAmount | number | Order total amount |
| salesrepId | integer | Salesperson identifier |
| lines | array | |
| orgId | integer | |
| creationDate | string | |
| lastUpdateDate | string |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "SalesOrder",
"type": "object",
"properties": {
"headerId": {
"type": "integer",
"description": "Order header identifier"
},
"orderNumber": {
"type": "integer",
"description": "Order number"
},
"orderedDate": {
"type": "string",
"description": "Order date"
},
"orderTypeId": {
"type": "integer",
"description": "Order type identifier"
},
"orderTypeName": {
"type": "string",
"description": "Order type name"
},
"soldToOrgId": {
"type": "integer",
"description": "Customer identifier (sold-to)"
},
"customerName": {
"type": "string",
"description": "Customer name"
},
"shipToOrgId": {
"type": "integer",
"description": "Ship-to organization identifier"
},
"invoiceToOrgId": {
"type": "integer",
"description": "Bill-to organization identifier"
},
"transactionalCurrCode": {
"type": "string",
"description": "Transaction currency code (ISO 4217)"
},
"flowStatusCode": {
"type": "string",
"description": "Order flow status"
},
"bookedFlag": {
"type": "string"
},
"totalAmount": {
"type": "number",
"description": "Order total amount"
},
"salesrepId": {
"type": "integer",
"description": "Salesperson identifier"
},
"lines": {
"type": "array"
},
"orgId": {
"type": "integer"
},
"creationDate": {
"type": "string"
},
"lastUpdateDate": {
"type": "string"
}
}
}