# Order: Order - Name: `Order` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Order ## Table Columns The columns of the table `Order` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountId` | `string` | Account ID | ☐ | | | `ActivatedById` | `string` | Activated by ID | ☐ | | | `ActivatedDate` | `datetime` | Activated Date | ☐ | | | `BillingCity` | `string` | Billing City | ☐ | | | `BillingCountry` | `string` | Billing Country | ☐ | | | `BillingGeocodeAccuracy` | `string` | Billing Geocode Accuracy | ☐ | | | `BillingLatitude` | `double` | Billing Latitude | ☐ | | | `BillingLongitude` | `double` | Billing Longitude | ☐ | | | `BillingPostalCode` | `string` | Billing Postal Code | ☐ | | | `BillingState` | `string` | Billing State | ☐ | | | `BillingStreet` | `string` | Billing Street | ☐ | | | `BillToContactId` | `string` | Bill to Contact ID | ☐ | | | `CompanyAuthorizedById` | `string` | Company Authorized by ID | ☐ | | | `CompanyAuthorizedDate` | `datetime` | Company Authorized Date | ☐ | | | `ContractId` | `string` | Contract ID | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `CustomerAuthorizedById` | `string` | Customer Authorized by ID | ☐ | | | `CustomerAuthorizedDate` | `datetime` | Customer Authorized Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `EffectiveDate` | `datetime` | Effective Date | ☐ | | | `EndDate` | `datetime` | End Date | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsReductionOrder` | `boolean` | Is Reduction Order | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `OrderNumber` | `string` | Order Number | ☐ | | | `OrderReferenceNumber` | `string` | Order Reference Number | ☐ | | | `OriginalOrderId` | `string` | Original Order ID | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `PoDate` | `datetime` | PO Date | ☐ | | | `PoNumber` | `string` | PO Number | ☐ | | | `Pricebook2Id` | `string` | Pricebook ID | ☐ | | | `ShippingCity` | `string` | Shipping City | ☐ | | | `ShippingCountry` | `string` | Shipping Country | ☐ | | | `ShippingGeocodeAccuracy` | `string` | Shipping Geocode Accuracy | ☐ | | | `ShippingLatitude` | `double` | Shipping Latitude | ☐ | | | `ShippingLongitude` | `double` | Shipping Longitude | ☐ | | | `ShippingPostalCode` | `string` | Shipping Postal Code | ☐ | | | `ShippingState` | `string` | Shipping State | ☐ | | | `ShippingStreet` | `string` | Shipping Street | ☐ | | | `ShipToContactId` | `string` | Ship to Contact ID | ☐ | | | `Status` | `string` | Status | ☐ | | | `StatusCode` | `string` | Status Code | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TotalAmount` | `decimal` | Total Amount | ☐ | | | `Type` | `string` | Type | ☐ | |