Order

Name	Label	Type	Description
Id	Order ID	ID
OwnerId	Owner ID	LOOKUP
ContractId	Contract ID	LOOKUP
AccountId	Account ID	LOOKUP
Pricebook2Id	Price Book ID	LOOKUP
OriginalOrderId	Order ID	LOOKUP
EffectiveDate	Order Start Date	DATE
EndDate	Order End Date	DATE
IsReductionOrder	Reduction Order	CHECKBOX
Status	Status	PICKLIST
Description	Description	TEXT AREA (LONG)(32000)
CustomerAuthorizedById	Customer Authorized By ID	LOOKUP
CustomerAuthorizedDate	Customer Authorized Date	DATE
CompanyAuthorizedById	Company Authorized By ID	LOOKUP
CompanyAuthorizedDate	Company Authorized Date	DATE
Type	Order Type	PICKLIST
BillingStreet	Billing Street	TEXT AREA(255)
BillingCity	Billing City	TEXT(40)
BillingState	Billing State/Province	TEXT(80)
BillingPostalCode	Billing Zip/Postal Code	TEXT(20)
BillingCountry	Billing Country	TEXT(80)
BillingLatitude	Billing Latitude	NUMBER(3,15)
BillingLongitude	Billing Longitude	NUMBER(3,15)
BillingGeocodeAccuracy	Billing Geocode Accuracy	PICKLIST
BillingAddress	Billing Address	AUTO NUMBER
ShippingStreet	Shipping Street	TEXT AREA(255)
ShippingCity	Shipping City	TEXT(40)
ShippingState	Shipping State/Province	TEXT(80)
ShippingPostalCode	Shipping Zip/Postal Code	TEXT(20)
ShippingCountry	Shipping Country	TEXT(80)
ShippingLatitude	Shipping Latitude	NUMBER(3,15)
ShippingLongitude	Shipping Longitude	NUMBER(3,15)
ShippingGeocodeAccuracy	Shipping Geocode Accuracy	PICKLIST
ShippingAddress	Shipping Address	AUTO NUMBER
Name	Order Name	TEXT(80)
PoDate	PO Date	DATE
PoNumber	PO Number	TEXT(80)
OrderReferenceNumber	Order Reference Number	TEXT(80)
BillToContactId	Bill To Contact ID	LOOKUP
ShipToContactId	Ship To Contact ID	LOOKUP
ActivatedDate	Activated Date	DATETIME
ActivatedById	Activated By ID	LOOKUP
StatusCode	Status Category	PICKLIST
OrderNumber	Order Number	AUTO NUMBER
TotalAmount	Order Amount	CURRENCY(16,2)
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
IsDeleted	Deleted	CHECKBOX
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME

Name	Id
Label	Order ID
Type	ID
Required	Yes

Name	OwnerId
Label	Owner ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	ContractId
Label	Contract ID
Type	LOOKUP
Foreign key	Yes

Name	AccountId
Label	Account ID
Type	LOOKUP

Name	Pricebook2Id
Label	Price Book ID
Type	LOOKUP
Foreign key	Yes

Name	OriginalOrderId
Label	Order ID
Type	LOOKUP
Foreign key	Yes

Name	EffectiveDate
Label	Order Start Date
Type	DATE
Required	Yes

Name	EndDate
Label	Order End Date
Type	DATE

Name	IsReductionOrder
Label	Reduction Order
Type	CHECKBOX
Required	Yes
Default value	false

Name	Status
Label	Status
Type	PICKLIST
Required	Yes
Picklist values	Draft Activated

Name	Description
Label	Description
Type	TEXT AREA (LONG)(32000)

Name	CustomerAuthorizedById
Label	Customer Authorized By ID
Type	LOOKUP
Foreign key	Yes

Name	CustomerAuthorizedDate
Label	Customer Authorized Date
Type	DATE

Name	CompanyAuthorizedById
Label	Company Authorized By ID
Type	LOOKUP
Foreign key	Yes

Name	CompanyAuthorizedDate
Label	Company Authorized Date
Type	DATE

Name	Type
Label	Order Type
Type	PICKLIST

Name	BillingStreet
Label	Billing Street
Type	TEXT AREA(255)

Name	BillingCity
Label	Billing City
Type	TEXT(40)

Name	BillingState
Label	Billing State/Province
Type	TEXT(80)

Name	BillingPostalCode
Label	Billing Zip/Postal Code
Type	TEXT(20)

Name	BillingCountry
Label	Billing Country
Type	TEXT(80)

Name	BillingLatitude
Label	Billing Latitude
Type	NUMBER(3,15)

Name	BillingLongitude
Label	Billing Longitude
Type	NUMBER(3,15)

Name	BillingGeocodeAccuracy
Label	Billing Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	BillingAddress
Label	Billing Address
Type	AUTO NUMBER

Name	ShippingStreet
Label	Shipping Street
Type	TEXT AREA(255)

Name	ShippingCity
Label	Shipping City
Type	TEXT(40)

Name	ShippingState
Label	Shipping State/Province
Type	TEXT(80)

Name	ShippingPostalCode
Label	Shipping Zip/Postal Code
Type	TEXT(20)

Name	ShippingCountry
Label	Shipping Country
Type	TEXT(80)

Name	ShippingLatitude
Label	Shipping Latitude
Type	NUMBER(3,15)

Name	ShippingLongitude
Label	Shipping Longitude
Type	NUMBER(3,15)

Name	ShippingGeocodeAccuracy
Label	Shipping Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	ShippingAddress
Label	Shipping Address
Type	AUTO NUMBER

Name	Name
Label	Order Name
Type	TEXT(80)

Name	PoDate
Label	PO Date
Type	DATE

Name	PoNumber
Label	PO Number
Type	TEXT(80)

Name	OrderReferenceNumber
Label	Order Reference Number
Type	TEXT(80)

Name	BillToContactId
Label	Bill To Contact ID
Type	LOOKUP
Foreign key	Yes

Name	ShipToContactId
Label	Ship To Contact ID
Type	LOOKUP
Foreign key	Yes

Name	ActivatedDate
Label	Activated Date
Type	DATETIME

Name	ActivatedById
Label	Activated By ID
Type	LOOKUP
Foreign key	Yes

Name	StatusCode
Label	Status Category
Type	PICKLIST
Required	Yes
Picklist values	Draft Activated Canceled Expired

Name	OrderNumber
Label	Order Number
Type	AUTO NUMBER
Required	Yes

Name	TotalAmount
Label	Order Amount
Type	CURRENCY(16,2)
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Label	Value