Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | id | 18 | null |
|
|
Label: Order ID |
||||||
ContractId | reference | 18 | null |
|
|
Label: Contract ID |
||||||
AccountId | reference | 18 | null |
|
|
Label: Account ID |
||||||
EffectiveDate | date | 0 | null |
|
|
Label: Order Start Date |
||||||
IsReductionOrder | boolean | 0 | null |
|
|
Label: Reduction Order |
||||||
Status | picklist | 40 | null |
|
|
Label: Status |
||||||
Description | textarea | 32000 | null |
|
|
Label: Description |
||||||
CustomerAuthorizedById | reference | 18 | null |
|
|
Label: Customer Authorized By ID |
||||||
CompanyAuthorizedById | reference | 18 | null |
|
|
Label: Company Authorized By ID |
||||||
Type | picklist | 40 | null |
|
|
Label: Order Type |
||||||
BillingStreet | textarea | 255 | null |
|
|
Label: Billing Street |
||||||
BillingCity | string | 40 | null |
|
|
Label: Billing City |
||||||
BillingState | string | 80 | null |
|
|
Label: Billing State/Province |
||||||
BillingPostalCode | string | 20 | null |
|
|
Label: Billing Zip/Postal Code |
||||||
BillingCountry | string | 80 | null |
|
|
Label: Billing Country |
||||||
ShippingStreet | textarea | 255 | null |
|
|
Label: Shipping Street |
||||||
ShippingCity | string | 40 | null |
|
|
Label: Shipping City |
||||||
ShippingState | string | 80 | null |
|
|
Label: Shipping State/Province |
||||||
ShippingPostalCode | string | 20 | null |
|
|
Label: Shipping Zip/Postal Code |
||||||
ShippingCountry | string | 80 | null |
|
|
Label: Shipping Country |
||||||
ActivatedDate | datetime | 0 | null |
|
|
Label: Activated Date |
||||||
ActivatedById | reference | 18 | null |
|
|
Label: Activated By ID |
||||||
StatusCode | picklist | 40 | null |
|
|
Label: Status Category |
||||||
OrderNumber | string | 30 | null |
|
|
Label: Order Number |
||||||
TotalAmount | currency | 18 | null |
|
|
Label: Order Amount |
||||||
CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||||
CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||||
LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||||
LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
||||||
IsDeleted | boolean | 0 | null |
|
|
Label: Deleted |
||||||
SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
FakeIndex121 | Must be unique | Asc | Id |