Order

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