| Name | Description | Type | Additional information |
|---|---|---|---|
| Id | integer |
None. |
|
| CustomerId | integer |
None. |
|
| OrderNumber | string |
None. |
|
| CustomerName | string |
None. |
|
| JdeNumber | string |
None. |
|
| BillingInfo | string |
None. |
|
| ShippingTo | string |
None. |
|
| WorksheetName | string |
None. |
|
| InstallDate | date |
None. |
|
| RevisionDate | date |
None. |
|
| ExpirationDate | date |
None. |
|
| CommittedDate | date |
None. |
|
| SubmittedDate | date |
None. |
|
| Subtotal | decimal number |
None. |
|
| Freight | decimal number |
None. |
|
| SalesTax | decimal number |
None. |
|
| SalesTaxRate | decimal number |
None. |
|
| Total | decimal number |
None. |
|
| DownPayment | decimal number |
None. |
|
| Discount | decimal number |
None. |
|
| DealerCost | decimal number |
None. |
|
| ActualGP | decimal number |
None. |
|
| OrderStatusId | string |
None. |
|
| GeneralNote | string |
None. |
|
| ConfidentalNote | string |
None. |
|
| CustomFreight | boolean |
None. |
|
| CustomDownPayment | boolean |
None. |
|
| FreightPercentage | decimal number |
None. |
|
| DownPaymentPercentage | decimal number |
None. |
|
| OrderTypeId | integer |
None. |
|
| BusinessVersion | integer |
None. |
|
| IsDeleted | boolean |
None. |
|
| SalesRepId | integer |
None. |
|
| SalesRepName | string |
None. |
|
| EquipmentRepId | integer |
None. |
|
| EquipmentRepName | string |
None. |
|
| AdditionalRepId | integer |
None. |
|
| AdditionalRepName | string |
None. |
|
| AdditionalRep2Id | integer |
None. |
|
| AdditionalRep2Name | string |
None. |
|
| TransferRepId | integer |
None. |
|
| TransferRepName | string |
None. |
|
| SysStartTime | date |
None. |
|
| SysEndTime | date |
None. |
|
| IsCurrent | boolean |
None. |
|
| VersionNumber | integer |
None. |
|
| ChangedFields | string |
None. |
|
| HasCompleteTemporalData | boolean |
None. |