General informations
Fields (59)
| 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) | |
| BillingStateCode | Billing State Code | PICKLIST | |
| BillingCountryCode | Billing Country Code | PICKLIST | |
| 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) | |
| ShippingStateCode | Shipping State Code | PICKLIST | |
| ShippingCountryCode | Shipping Country Code | PICKLIST | |
| 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 | |
| SalesAgreementId | Sales Agreement ID | LOOKUP | |
| 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 | |
| CaseId__c | Case | LOOKUP |
Fields Details (59)
| 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 |
| Foreign key | Yes |
| 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 |
| Picklist values | Sample Trial Loan Mark for Order |
| 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 | BillingStateCode |
| Label | Billing State Code |
| Type | PICKLIST |
| Picklist values | AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33 |
| Name | BillingCountryCode |
| Label | Billing Country Code |
| Type | PICKLIST |
| Picklist values | AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW |
| 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 | ShippingStateCode |
| Label | Shipping State Code |
| Type | PICKLIST |
| Picklist values | AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33 |
| Name | ShippingCountryCode |
| Label | Shipping Country Code |
| Type | PICKLIST |
| Picklist values | AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW |
| 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 | SalesAgreementId |
| Label | Sales Agreement ID |
| Type | LOOKUP |
| Foreign key | Yes |
| 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 |
| Name | CaseId__c |
| Label | Case |
| Type | LOOKUP |
| Foreign key | Yes |
Parents relationships(25)
Children relationships(14)
| Name | Parent object | Child object | Parent object field | Child object field |
|---|---|---|---|---|
| Owner | User | Order |
|
|
| Contract | Contract | Order |
|
|
| Account | Account | Order |
|
|
| Pricebook2 | Pricebook2 | Order |
|
|
| OriginalOrder | Order | Order |
|
|
| CustomerAuthorizedBy | Contact | Order |
|
|
| CompanyAuthorizedBy | User | Order |
|
|
| BillToContact | Contact | Order |
|
|
| ShipToContact | Contact | Order |
|
|
| ActivatedBy | User | Order |
|
|
| SalesAgreement | SalesAgreement | Order |
|
|
| CreatedBy | User | Order |
|
|
| LastModifiedBy | User | Order |
|
|
| CaseId__r | Case | Order |
|
|
Object User-defined metadata (0)
| Label | Value |
|---|