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 |