Common data model overview



Microsoft Common Data ModelEntity ReferenceTable of Contents TOC \o "1-2" \h \z \u Common data model overview PAGEREF _Toc482115985 \h 7Standard entities PAGEREF _Toc482115986 \h 9Entity field data types PAGEREF _Toc482115987 \h 10Entity relationships and lookup fields PAGEREF _Toc482115988 \h 12Entity relationship diagrams PAGEREF _Toc482115989 \h 12Referential integrity PAGEREF _Toc482115990 \h 14Header-line composition PAGEREF _Toc482115991 \h 15Entity field properties PAGEREF _Toc482115992 \h 16System fields PAGEREF _Toc482115993 \h 17Naming conventions PAGEREF _Toc482115994 \h 18Entity versioning PAGEREF _Toc482115995 \h 19Security PAGEREF _Toc482115996 \h 20Security model PAGEREF _Toc482115997 \h 21Database security PAGEREF _Toc482115998 \h 21Role-based security PAGEREF _Toc482115999 \h 21Permission sets PAGEREF _Toc482116000 \h 21Policies (Technical Preview) PAGEREF _Toc482116001 \h 21Roles PAGEREF _Toc482116002 \h 22Out-of-the-box security roles PAGEREF _Toc482116003 \h 22Privacy notice PAGEREF _Toc482116004 \h 23Customer service entities PAGEREF _Toc482116005 \h 24Customer service ERD PAGEREF _Toc482116006 \h 24Customer service reference PAGEREF _Toc482116007 \h 25Case (Case) Entity PAGEREF _Toc482116008 \h 25CaseActivity (Case activity) Entity PAGEREF _Toc482116009 \h 27CaseActivityKBArticle (Case activity KB article) Entity PAGEREF _Toc482116010 \h 31KBArticle (KB article) Entity PAGEREF _Toc482116011 \h 32Foundation entities PAGEREF _Toc482116012 \h 34Foundation ERD PAGEREF _Toc482116013 \h 34Foundation reference PAGEREF _Toc482116014 \h 35BusinessUnit (Business unit) Entity PAGEREF _Toc482116015 \h 35BusinessUnitContact (Business unit contact) Entity PAGEREF _Toc482116016 \h 37CostCenter (Cost center) Entity PAGEREF _Toc482116017 \h 39Department (Department) Entity PAGEREF _Toc482116018 \h 40Product (Product) Entity PAGEREF _Toc482116019 \h 41ProductCategory (Product category) Entity PAGEREF _Toc482116020 \h 44ProductCategoryAssignment (Product category assignment) Entity PAGEREF _Toc482116021 \h 45UnitOfMeasureConversion (Unit of measure conversion) Entity PAGEREF _Toc482116022 \h 46UserOrGroup (User or group) Entity PAGEREF _Toc482116023 \h 48Human resources entities PAGEREF _Toc482116024 \h 50Human resources ERD PAGEREF _Toc482116025 \h 50Human resources reference PAGEREF _Toc482116026 \h 51Employment (Employment) Entity PAGEREF _Toc482116027 \h 51Job (Job) Entity PAGEREF _Toc482116028 \h 52JobFunction (Job Function) Entity PAGEREF _Toc482116029 \h 54JobType (Job Type) Entity PAGEREF _Toc482116030 \h 55LeaveRequest (Leave request) Entity PAGEREF _Toc482116031 \h 56LeaveRequestDetail (Leave request detail) Entity PAGEREF _Toc482116032 \h 57LeaveType (Leave type) Entity PAGEREF _Toc482116033 \h 58Position (Position) Entity PAGEREF _Toc482116034 \h 59PositionType (Position Type) Entity PAGEREF _Toc482116035 \h 61PositionWorkerAssignment (Position worker assignment) Entity PAGEREF _Toc482116036 \h 62Person, organization, and group entities PAGEREF _Toc482116037 \h 64Person, organization, and group ERD PAGEREF _Toc482116038 \h 64Person, organization, and group reference PAGEREF _Toc482116039 \h 65Alumnus (Alumnus) Entity PAGEREF _Toc482116040 \h 65ApplicationUser (Application user) Entity PAGEREF _Toc482116041 \h 68ApplicationUserContact (Application user contact) Entity PAGEREF _Toc482116042 \h 71ApplicationUserGroup (Application user group) Entity PAGEREF _Toc482116043 \h 72Constituent (Constituent) Entity PAGEREF _Toc482116044 \h 74Contact (Contact) Entity PAGEREF _Toc482116045 \h 77ContactOtherPostalAddress (Contact other postal address) Entity PAGEREF _Toc482116046 \h 81Family (Family) Entity PAGEREF _Toc482116047 \h 82FamilyMember (Family member) Entity PAGEREF _Toc482116048 \h 84Fan (Fan) Entity PAGEREF _Toc482116049 \h 85Household (Household) Entity PAGEREF _Toc482116050 \h 88HouseholdMember (Household member) Entity PAGEREF _Toc482116051 \h 90Organization (Organization) Entity PAGEREF _Toc482116052 \h 92OrganizationContact (Organization contact) Entity PAGEREF _Toc482116053 \h 95Team (Team) Entity PAGEREF _Toc482116054 \h 97TeamMember (Team member) Entity PAGEREF _Toc482116055 \h 99Tenant (Tenant) Entity PAGEREF _Toc482116056 \h 100Worker (Worker) Entity PAGEREF _Toc482116057 \h 103Productivity entities PAGEREF _Toc482116058 \h 107Productivity ERD PAGEREF _Toc482116059 \h 107Productivity reference PAGEREF _Toc482116060 \h 108Event (Event) Entity PAGEREF _Toc482116061 \h 108Message (Message) Entity PAGEREF _Toc482116062 \h 114Purchasing entities PAGEREF _Toc482116063 \h 117Purchase order ERD PAGEREF _Toc482116064 \h 117Vendor invoice ERD PAGEREF _Toc482116065 \h 118Purchasing reference PAGEREF _Toc482116066 \h 119PurchaseOrder (Purchase order) Entity PAGEREF _Toc482116067 \h 119PurchaseOrderCharge (Purchase order charge) Entity PAGEREF _Toc482116068 \h 121PurchaseOrderLine (Purchase order line) Entity PAGEREF _Toc482116069 \h 123PurchaseOrderLineCharge (Purchase order line charge) Entity PAGEREF _Toc482116070 \h 126PurchaseOrderLineReceipt (Purchase order line receipt) Entity PAGEREF _Toc482116071 \h 127PurchaseOrderLineTax (Purchase order line tax) Entity PAGEREF _Toc482116072 \h 129PurchaseOrderTax (Purchase order tax) Entity PAGEREF _Toc482116073 \h 130Vendor (Vendor) Entity PAGEREF _Toc482116074 \h 132VendorContact (Vendor contact) Entity PAGEREF _Toc482116075 \h 136VendorInvoice (Vendor invoice) Entity PAGEREF _Toc482116076 \h 138VendorInvoiceCharge (Vendor invoice charge) Entity PAGEREF _Toc482116077 \h 140VendorInvoiceLine (Vendor invoice line) Entity PAGEREF _Toc482116078 \h 142VendorInvoiceLineCharge (Vendor Invoice Line Charge) Entity PAGEREF _Toc482116079 \h 144VendorInvoiceLineTax (Vendor invoice line tax) Entity PAGEREF _Toc482116080 \h 146VendorInvoiceTax (Vendor invoice tax) Entity PAGEREF _Toc482116081 \h 147Sales entities PAGEREF _Toc482116082 \h 150Sales invoice ERD PAGEREF _Toc482116083 \h 150Sales order ERD PAGEREF _Toc482116084 \h 150Quotation ERD PAGEREF _Toc482116085 \h 152Competitor ERD PAGEREF _Toc482116086 \h 153Lead ERD PAGEREF _Toc482116087 \h 153Sales reference PAGEREF _Toc482116088 \h 154Account (Account) Entity PAGEREF _Toc482116089 \h 154AccountContact (Account contact) Entity PAGEREF _Toc482116090 \h 158AccountGroup (Account group) Entity PAGEREF _Toc482116091 \h 160AccountLead (Account lead) Entity PAGEREF _Toc482116092 \h 161AccountOtherPostalAddress (Account other postal address) Entity PAGEREF _Toc482116093 \h 161Competitor (Competitor) Entity PAGEREF _Toc482116094 \h 162CompetitorOtherPostalAddress (Competitor other postal address) Entity PAGEREF _Toc482116095 \h 166CompetitorProduct (Competitor product) Entity PAGEREF _Toc482116096 \h 167ContactLead (Contact lead) Entity PAGEREF _Toc482116097 \h 168Lead (Lead) Entity PAGEREF _Toc482116098 \h 169LeadCompetitor (Lead competitor) Entity PAGEREF _Toc482116099 \h 174LeadContact (Lead contact) Entity PAGEREF _Toc482116100 \h 175LeadOtherPostalAddress (Lead other postal address) Entity PAGEREF _Toc482116101 \h 176LeadProduct (Lead product) Entity PAGEREF _Toc482116102 \h 177Opportunity (Opportunity) Entity PAGEREF _Toc482116103 \h 178OpportunityCompetitor (Opportunity competitor) Entity PAGEREF _Toc482116104 \h 182OpportunityProduct (Opportunity product) Entity PAGEREF _Toc482116105 \h 183Partner (Partner) Entity PAGEREF _Toc482116106 \h 184Quotation (Quotation) Entity PAGEREF _Toc482116107 \h 188QuotationCharge (Quotation charge) Entity PAGEREF _Toc482116108 \h 191QuotationLine (Quotation line) Entity PAGEREF _Toc482116109 \h 193QuotationLineCharge (Quotation line charge) Entity PAGEREF _Toc482116110 \h 195QuotationLineTax (Quotation line tax) Entity PAGEREF _Toc482116111 \h 197QuotationTax (Quotation tax) Entity PAGEREF _Toc482116112 \h 198SalesInvoice (Sales invoice) Entity PAGEREF _Toc482116113 \h 200SalesInvoiceCharge (Sales invoice charge) Entity PAGEREF _Toc482116114 \h 203SalesInvoiceLine (Sales invoice line) Entity PAGEREF _Toc482116115 \h 204SalesInvoiceLineCharge (Sales invoice line charge) Entity PAGEREF _Toc482116116 \h 207SalesInvoiceLineTax (Sales invoice line tax) Entity PAGEREF _Toc482116117 \h 208SalesInvoiceTax (Sales invoice tax) Entity PAGEREF _Toc482116118 \h 210SalesOrder (Sales order) Entity PAGEREF _Toc482116119 \h 211SalesOrderCharge (Sales order charge) Entity PAGEREF _Toc482116120 \h 214SalesOrderLine (Sales order line) Entity PAGEREF _Toc482116121 \h 216SalesOrderLineCharge (Sales order line charge) Entity PAGEREF _Toc482116122 \h 218SalesOrderLineShipment (Sales order line shipment) Entity PAGEREF _Toc482116123 \h 220SalesOrderLineTax (Sales order line tax) Entity PAGEREF _Toc482116124 \h 221SalesOrderTax (Sales order tax) Entity PAGEREF _Toc482116125 \h 223Standard picklists PAGEREF _Toc482116126 \h 225Common data model overviewAt the core of the Common Data Service is the common data model. The common data model comes pre-populated with many business entities that are useful across a variety of business and application domains. These entities can be used by apps built atop the Common Data Service via PowerApps or the Common Data Service SDK, or by the integration capabilities that the Common Data Service provides customers. The common data model is fully extensible - you can add fields to any of the entities that come with the Common Data Service, or create your own. The benefit of the common data model is that applications can work against data without needing to explicitly know where that data is coming from.The common data model provides a rich and productive development platform through the following features:Common data model?– The common data model is a library of entities that represent the most commonly used entities across business and productivity applications. The library is organized for simplicity and rapid discoverability. Typical solutions will revolve around core elements of enterprise data – for example, a worker, an account, a product, or a vendor. Applications across the enterprise will drive updates to that data. The common data model is implemented to simplify the challenges of data management.Data import?– You can quickly and easily import data from your existing systems. The Common Data Service rapidly establishes trusted connections for IT-managed tenants. The trusted connections continually synchronize the data between your existing systems and your platform solutions.Simple, but rich?– The common data model balances the richness to be useful and the simplicity to be usable.Extensibility?– You can extend the entities without breaking data sharing with other apps.Robustness?– Because you can depend on common entities, you can build reusable components that are bound to the entities. The Common Data Model includes a design for extensibility and versioning that protects your development investment.Unification?– Your solutions can connect information from productivity platforms with data from business applications. For example, you can connect a calendar appointment or a Microsoft Outlook task with a sales opportunity. The Common Data Service connects through standard interfaces, such as the Microsoft Graph application programming interface (API), and maps entities to the productivity platform objects to enable the join relationships with business data.Additionally, the Common Data Service provides several key capabilities over the common data model including:Build apps with PowerApps?- For information about creating apps with the Common Data Service and PowerApps, see?Understand entities in the Common Data Service.Build apps with the Common Data Service SDK?– Developers and Independent Software Vendors can create applications using PowerApps or with the CDS SDK. For more information, see?Common Data Service SDK.Automate business processes with Flow?- For information about creating a flow that uses the Common Data Service, see?Create a flow that uses the Common Data Service.Security?– The Common Data Service manages access to data in the database and conforms to the security models of the enterprise. For more information, see?Common Data Service Security.Standard entitiesOut of the box, the common data model provides a set of entities that supports key scenarios. For example, the Worker, Employment, and Organization entities support employment scenarios. The PurchaseOrder and PurchaseOrderLine entities support purchasing scenarios. The entities are grouped by function – for example, sales, purchasing, and productivity. The model is simpler and, at the same time, more consumable than the models in a full enterprise resource planning (ERP) or customer relationship management (CRM) suite. This simplicity is reflected in the number of entities, the relational structure of those entities, and the number of fields in those entities. All entities have a standard set of fields that drive the core capabilities of the platform.The entities are organized into these functional groups.Functional GroupDescriptionCustomer serviceThe customer service entities manage issues from your customers, including tracking, escalation, and documentation.FoundationThe Foundation entities contain information that is relevant to nearly every other entity group. This group contains entities such as Address and Currency.Human resourcesThe human resources entities let you manage employment information, jobs, leaves, and positions.Person, organization, and groupThese entities encompass a rich set of people and organizations that you might interact with, including workers, vendors, tenants, fans, alumni, and families.ProductivityThe productivity entities let you track events and messages.PurchasingThe Purchasing entities let you create purchasing solutions.SalesThe Sales entities let you create end-to-end sales solutions, from tracking leads and opportunities, to following through with contacts, to accepting and delivering orders, to sending invoices.Entity field data typesThe following table describes the data types that are used in the entities.TypePrimitive TypeDescriptionAddressCompoundThe?Address?data type is implemented as separate fields for first line, second line, city, state/province, postal code, and country/region.AutoNumberStringNumberSequence?is used to automatically generate user-friendly IDs for rows. The ID is a concatenation of a three-character prefix and an automatically incrementing number. For example, the Expense entity has a prefix of “EXP,” so the ExpenseID looks like “EXP001.”BigIntegerBigIntegerBigInteger?is used for theRecordId?field that is included as a system field in every entity. You cannot create fields that use the BigInteger type.BooleanBooleanA value that supports?True?and False.CurrencyCompoundThe?Currency?data type in an entity is implemented as two fields. One field is a decimal value of six decimal places. The other is an enumeration that specifies the currency code – for example, USD or EUR.DateDateTimeOnly the?Date?portion of the DateTime?type is used by the platform. The?Date?data type is used when time zone conversion should not be done.DateTimeDateTimeA date that is combined with a time of day with fractional seconds that is based on a 24-hour clock.EmailStringEmail?is stored as a string but is understood as a separate type, so that special behavior can be implemented in storage, in the user interface, and in application lifecycle management. The string is stored in Unicode format.GuidGuidA guid.IntegerIntegerAn integer between -2,147,483,648 and 2,147,483,647.Lookup[Foreign key]The value matches the primary key in another table and is used to join information between two tables. It is also known as a foreign key.Multiline TextStringMultiple lines of text. The maximum length varies, but it is never more than 2,048. The string is stored in Unicode format.NumberDecimalA total of 32 digits can be stored, with a maximum of six digits to the right of the decimal point.PersonNameCompoundThe?PersonName?data type is implemented as separate fields for given name (first name), middle name, and surname (last name).PhoneStringPhone?is stored as a string but is understood as a separate type, so that special behavior can be implemented in storage, in the user interface. The string is stored in Unicode format.PicklistIntegerThe integer serves as a reference into one of the standard picklists.QuantityQuantityA decimal value.TextStringOne line of text. The maximum length varies, but it is never more than 128 characters. The string is stored in Unicode format.UrlStringUrl?is stored as a string but is understood as a separate type, so that special behavior can be implemented in storage, in the user interface. The string is stored in Unicode format.Entity relationships and lookup fieldsEntity relationship diagramsFor each entity group, there is an entity relationship diagram (ERD) that describes the entities and their relationships with each other. An entity is described by an entity object.Relationships are specified by crow’s foot connectors between entities. Each end of the connector is one of the following.DiagramDescriptionZero or moreExample: A company has zero or more business units.One or moreExample: A sales order has one or more order lines.One and only oneExample: A sales order is associated with exactly one customer.Zero or oneExample: A postal address is associated with, at most, one country or region.The following ERD shows a greatly simplified diagram for a sales order. The interpretation of this model is as follows:Each sales order is associated with one and only one customer.A customer has zero or more sales orders.A sales order consists of one or more sales order lines.Each sales order line is associated with one and only one sales order.Each sales order line lists one and only one product.A product can appear on multiple sales order lines, both within a sales order and across sales orders.The connectors in the ERD also specify which fields are used as the lookup fields between entities. For example, the?Customerfield in the SalesOrder entity is a lookup of the?RecordID?field in the Customer entity. Note that the lookup is not on theCustomerID?field.Referential integrityReferential integrity is implemented on lookup fields to help guarantee that associations between rows in entities are valid. The value of the lookup field (also known as a foreign key) in any referencing entity must always refer to a valid row in the referenced entity (by way of the primary key in the referenced entity). In the common data model, the following rules are applied to maintain referential integrity:The value of a lookup field must match the primary key of a row in the lookup entity. For example, you cannot associate a sales order line with a non-existent sales order.Cascading delete: If a row in the referenced entitiy is deleted, all the associated rows in the referencing entity are deleted. As an example, in the common data model, if a SalesOrder row is deleted, the corresponding SalesOrderCharge, SalesOrderTax, and SalesOrderLine rows are deleted. If a SalesOrderLine row is deleted, corresponding SalesOrderLineTax and SalesOrderLineCharge rows are deleted. The cascading delete rule applies to all entities in a header-line composition.Restricted delete: You cannot delete a row in the referenced entity if it has associated rows in the referencing entity. As an example, in the common data model, if you try to delete a Product row, and the Product row is referenced in a SalesOrderLine row, then Product delete will be restricted (blocked). This is called a lookup pattern, and restricted delete is applied to all lookup patterns.Referential integrity is maintained when data is added or imported into the common data model. If primary keys do not exist, they are created. If you attempt to import data that would break referential integrity, the import will fail.Header-line compositionThe header-line composition pattern is implemented on the following entity pairs.Sales Order and Sales Order LinePurchase Order and Purchase Order LineSales Invoice and Sales Invoice LineSupplier Invoice and Supplier Invoice LineCase and Case ActivityUsing Sales Order as an example, the combination of the sales order header (Sales Order entity) and its associated sales order line items (Sales Order Line entity) compose the entire sales order. When a sales order is deleted, all the associated sales order line items are deleted. Note that any customer associated with the sales order is not deleted, even though the sales order is associated with a customer. The entity schema allows a Customer row to exist even if there is no sales order associated with that customer.Entity field propertiesSome field types have additional properties that affect what you can store in the field.PropertyApplies ToDescriptionDefault valueTextThe default value of the Text field.Max lengthTextThe maximum number of characters in a text field.PrefixNumber SequenceThe prefix that is used for the number sequence. For Example, using the prefix "SO" on Sales orders to generate a number sequence in the format SO0001.PicklistPicklistThe option set type of the field.RequiredAllA value is required for the field.SearchableAllThe data can be searched.UniqueAllValues for the field must be unique across the entity.System fieldsA set of standard fields is included with every entity. These fields are used to provide behaviors such as concurrency management, security, and audit trails.Field NameDescriptionRecordIDType: BigIntegerDescription: Uniquely identifies an instance of an entity.Created By (CreatedByUser)Type: TextDescription: The RecordID of the user who created the entity instance.Created Record Date (CreatedOnDateTime)Type: DateTimeDescription: The date and time when the entity instance was created.Last Modified By (LastModifiedByUser)Type: TextDescription: The RecordID of the user who last modified the entity instance.Modified Record Date (LastModifiedDateTime)Type: DateTimeDescription: The date and time when the entity instance was last modified.Naming conventionsTo provide a consistent experience across objects, and to improve discoverability and usability, the common data model follows these naming conventions:Entity names are singular. Examples: Tenant, Family, SalesOrder.Entity ID names are created by appending “Id” to the entity name. Examples: WorkerId, CaseId, FamilyId.Lookup fields are named with the entity name of the entity that they are related to. Example: The Worker entity has a lookup field that is named?Organization, and that is foreign key to the primary key of the Organization entity. In this case, the company is the employer of the employee.Entity versioningEntities created with the common data model during the Public Preview will be not be supported when the Common Data Service (Version 1.0) is released. While in some cases there are no or minor changes, other areas have undergone a more significant change based on the feedback received during the preview.Security The Common Data Service provides a security framework to help protect your data. All applications that use the Common Data Service, such as Microsoft PowerApps, Microsoft Power BI, and Microsoft Flow, are subject to the security that is defined in the security mon Data Service security is based on role-based security. Data in the Common Data Service can be secured at several levels:Database level?– Admins can define which users can perform all administrative operations in the Common Data Service. Entity level?– Admins can define which users have access to entities, and what actions those users can take on those entities. Record level?– Admins can use policies to define which records a user has access to in a given entity. Security modelThe Common Data Service provides a security framework to help protect your data. You can control security for your data at several levels - at the database level, entity or now even record-level! You can choose how to structure your security based on role memberships, Permission Sets and policies. Read on to learn more about the ways you can secure your data.Database securityThere are two modes in which the Common Data Service can run: open or restricted. In open mode, the data stored in the common data service is open to all users. This means that you can share apps and view data without having to worry about managing permissions to your data. Everyone will always have the needed permissions to use any app. When using Microsoft PowerApps, your database will be created in restricted mode by default, but you can optionally choose to open access at creation time. After your database is created you can always toggle between open mode and restricted access on the database tab of the admin center. If you choose to store sensitive data, you should turn off the open mode setting and grant specific data permissions to users by using the admin center. When running in restricted mode, you will need to configure the role-based security described in the following section.Role-based securityA role-based system is used to grant users permissions to data. The security model is a hierarchy, with each level representing a different level of access. At the lowest level are individual create, read, update, and delete permissions on a single entity. A collection of these entity level permissions form a permission set. Multiple permission sets can then be combined to create a role. A role is the top-level artifact that encompasses all the permissions needed by a user or a group of users.Permission setsPermission sets are the building blocks of the role-based security framework. A permission set specifies the level of access that is granted to a set of entities. Create, read, update, and delete permissions can be granted to any entity included in the permission set. A permission set should contain a set of entities needed to perform a specific task or run a single app. There is also a set of out-of-the-box permission sets that grant access to the out-of-the-box entities. Add these permission sets to a role to leverage the out-of-the-box entities, or create your own.Policies (Technical Preview)Policies determine the records that a user has access to within an entity. A policy can be used to simplify your Common Data Service application or PowerApp. The policy allows you to limit the data returned to the user to only the set that is relevant to them. A policy restricts access based on the value of a field within the record.Policies can be defined to only return values:With a given picklist valueWhere the current user of the application matches the user stored in the recordRolesIn restricted mode, every user must have one or more role assigned to them. Managing security through roles allows you to save time by not having to set up security for each user. A role can be set up for a given position within your company, and assigned to any person who is in that position. Users can also be automatically added to a role based on the Azure Active Directory groups they belong to.Roles combine the permissions granted across the permission sets added to them. In this way, members of a role can access all the data provided to them by the permission sets included in the role.Out-of-the-box security rolesDatabase OwnerThe Database Owner role is intended for users in an administrative function. Users in this role will always have full access to all entities in the database, even as new entities are added. The database owner role also provides users the ability to create and edit entity schema in the anization UserThe Organization User role is the default role assigned to all users. This role is intended to provide all users access to the entities that contain public data.PowerAppsFor information about configuring security in PowerApps, see Configure database security.Privacy noticeWith the Microsoft PowerApps common data model we collect and store custom entity and field names in our diagnostic systems. We use this knowledge to improve the common data model for our customers. The entity and field names that Creators create help us understand scenarios that are common across the Microsoft PowerApps community and ascertain gaps in the service’s standard entity coverage, such as schemas related to organizations. The data in the database tables associated with these entities is not accessed or used by Microsoft or replicated outside of the region in which the database is provisioned. Note, however, the custom entity and field names may be replicated across regions and are deleted in accordance with our data retention policies. Microsoft is committed to your privacy as described further in our?Trust Center.Customer service entitiesThe customer service entities manage issues from your customers, including tracking, escalation, and documentation.Customer service ERDCustomer service referenceCase (Case) EntityA problem, question, or request encountered by a customer on a product, service, or interaction that requires support intervention.FieldDescriptionAccountLookup: AccountArrivalDateData: DateTimeRequired, SearchableBusinessUnitLookup: BusinessUnitCaseIdPrimary keyNumber sequence:?Unique, SearchableCategoryPicklist: CaseCategoryValues: Problem, Question, RequestRequiredCloseDateData: DateTimeSearchableCommentData: MultilineTextCurrentAssignedSupportWorkerLookup: WorkerCurrentContactLookup: ContactCustomerSatisfactionCodePicklist: CaseCustomerSatisfactionCodeValues: Dissatisfied, Neutral, Satisfied, VeryDissatisfied, VerySatisfiedDescriptionData: TextMaximum length: 255NameData: TextRequired, Maximum length: 60Description: Case nameOrganizationLookup: OrganizationOriginCodePicklist: CaseOriginCodeValues: Email, Facebook, Other, Phone, Twitter, WebRequiredDescription: OriginParentCaseLookup: CaseSeverityPicklist: SeverityValues: High, Low, NormalRequiredSolutionTypePicklist: CaseSolutionTypeValues: SolvedByCustomer, SolvedByKBArticle, SolvedBySupportWorkerStatusPicklist: CaseStatusValues: Active, Cancelled, Closed, OnHold, Resolved, SolvedAnsweredRequiredRelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationContactCurrent contactOneToManyAssociationCaseParent caseOneToManyAssociationWorkerCurrent assigned support workerOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameCategoryStatusSeverityArrivalDateDescriptionOriginCodeCurrentContactParentCaseAccountCustomerSatisfactionCodeDefaultListDefaultList field groupCaseIdNameCategoryStatusSeverityArrivalDateDefaultCardDefaultCard field groupCaseIdNameStatusSeverityDefaultDetailsDefaultDetails field groupCaseIdNameCategoryStatusSeverityArrivalDateDescriptionOriginCodeCurrentContactParentCaseAccountCustomerSatisfactionCodeCloseDateSolutionTypeCommentDefaultLookupDefaultLookup field groupCaseIdNameCategoryStatusSeverityDefaultReportDefaultReport field groupCaseIdNameCategoryStatusSeverityArrivalDateDescriptionOriginCodeCurrentContactParentCaseAccountCustomerSatisfactionCodeCloseDateSolutionTypeDefaultIdentificationDefaultIdentification field groupCaseIdNameCaseActivity (Case activity) EntityActions performed by a support worker or customer that must be logged for a case, for example, contacts, escalations, and case status changes.FieldDescriptionBeginDateData: DateTimeRequired, SearchableBusinessUnitLookup: BusinessUnitCaseSeverityPicklist: SeverityValues: High, Low, NormalRequiredDescription: Current case severityCaseStatusPicklist: CaseStatusValues: Active, Cancelled, Closed, OnHold, Resolved, SolvedAnsweredRequiredDescription: Current case statusCommentData: MultilineTextContactLookup: ContactContactTypePicklist: CaseOriginCodeValues: Email, Facebook, Other, Phone, Twitter, WebDescriptionData: TextMaximum length: 255EndDateData: DateTimeSearchableHasKBArticleData: BooleanRequiredDescription: Has KB article(s)IsReassignmentData: BooleanRequiredIsSeverityChangeData: BooleanRequiredDescription: Is severity changedIsStatusChangeData: BooleanRequiredDescription: Is status changedPriorCaseSeverityPicklist: SeverityValues: High, Low, NormalPriorCaseStatusPicklist: CaseStatusValues: Active, Cancelled, Closed, OnHold, Resolved, SolvedAnsweredReassignedCommentData: TextMaximum length: 255ReassignedFromCaseWorkerLookup: WorkerReassignedReasonPicklist: CaseReassignedReasonValues: NotResolvedDescription: Case reassigned reasonSequenceData: IntegerRequiredSupportCasePrimary keyLookup: CaseRequiredSupportWorkerLookup: WorkerTypePicklist: CaseActivityTypeValues: AssignReassignCaseWorker, Cancel, ChangeCaseStatus, Close, Contact, CreateSubcase, Intake, MakeKBReference, Open, ResearchRequiredRelationshipsRelated entityDescriptionCardinalityTypeCaseSupport caseOneToManyCompositionContactContactOneToManyAssociationWorkerSupport workerOneToManyAssociationWorkerReassigned from case workerOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSupportCaseSequenceTypeBeginDateDescriptionContactContactTypeCaseSeverityCaseStatusHasKBArticleIsReassignmentIsSeverityChangeIsStatusChangeDefaultListDefaultList field groupSupportCaseSequenceTypeBeginDateDescriptionCaseSeverityCaseStatusDefaultCardDefaultCard field groupSupportCaseSequenceTypeBeginDateDefaultDetailsDefaultDetails field groupSupportCaseSequenceTypeBeginDateDescriptionContactContactTypeCaseSeverityCaseStatusCommentDefaultLookupDefaultLookup field groupSupportCaseSequenceTypeBeginDateDescriptionDefaultReportDefaultReport field groupSupportCaseSequenceTypeBeginDateDescriptionContactContactTypeCaseSeverityCaseStatusHasKBArticleIsReassignmentIsSeverityChangeIsStatusChangeDefaultIdentificationDefaultIdentification field groupSupportCaseSequenceDescriptionCaseActivityKBArticle (Case activity KB article) EntityAssociates a knowledge base article with a case activity.FieldDescriptionArticleValueData: IntegerRequiredCaseActivityPrimary keyLookup: CaseActivityRequiredDescriptionData: TextMaximum length: 255KBArticleLookup: KBArticleRequiredKBArticleNameData: TextMaximum length: 60RelationshipsRelated entityDescriptionCardinalityTypeCaseActivityCase activityOneToManyAssociationKBArticleKB articleOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupCaseActivityKBArticleDescriptionKBArticleNameArticleValueDefaultListDefaultList field groupCaseActivityKBArticleDescriptionKBArticleNameDefaultCardDefaultCard field groupCaseActivityKBArticleKBArticleNameDefaultDetailsDefaultDetails field groupCaseActivityKBArticleDescriptionKBArticleNameArticleValueDefaultLookupDefaultLookup field groupCaseActivityKBArticleDescriptionDefaultReportDefaultReport field groupCaseActivityKBArticleDescriptionKBArticleNameArticleValueDefaultIdentificationDefaultIdentification field groupCaseActivityKBArticleKBArticle (KB article) EntityA knowledge base article that contains technical information that may be relevant in customer support scenarios.FieldDescriptionArticleScoreData: IntegerAuthorLookup: WorkerRequiredDescriptionData: TextMaximum length: 255KBArticleIdPrimary keyNumber sequence:?Unique, SearchableLinkToArticleData: WebsiteUrlSynopsisData: MultilineTextRelationshipsRelated entityDescriptionCardinalityTypeWorkerAuthorOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupDescriptionAuthorArticleScoreLinkToArticleSynopsisDefaultListDefaultList field groupKBArticleIdDescriptionAuthorArticleScoreDefaultCardDefaultCard field groupKBArticleIdAuthorArticleScoreDefaultDetailsDefaultDetails field groupKBArticleIdDescriptionAuthorArticleScoreLinkToArticleSynopsisDefaultLookupDefaultLookup field groupKBArticleIdDescriptionAuthorDefaultReportDefaultReport field groupKBArticleIdDescriptionAuthorArticleScoreLinkToArticleSynopsisDefaultIdentificationDefaultIdentification field groupKBArticleIdDescriptionFoundation entitiesThe foundation entities are used to drive other entities in the Common Data Model. They contain information that is relevant to nearly every other entity functional group.Foundation ERDFoundation referenceBusinessUnit (Business unit) EntityA division or unit within an organization with a defined business function.FieldDescriptionBusinessUnitIdPrimary keyNumber sequence:?Unique, SearchableCostCenterLookup: CostCenterDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFullNameData: TextSearchable, Maximum length: 128IsDefaultForOrganizationData: BooleanRequiredIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredMailingPostalAddressData: AddressOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressParentBusinessUnitLookup: BusinessUnitDescription: Parent business unit IDPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhoneSatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSourcePicklist: SourceValues: DefaultRequiredStatusPicklist: BusinessUnitStatusValues: Active, InactiveRequiredTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeCostCenterCost centerOneToManyAssociationOrganizationOrganizationOneToManyAssociationBusinessUnitParent business unit IDOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupOrganizationNameDescriptionParentBusinessUnitCostCenterMailingPostalAddressPhonePrimaryWebsiteURLEmailPrimaryPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedStatusIsDefaultForOrganizationDefaultListDefaultList field groupBusinessUnitIdFullNameOrganizationNameDescriptionParentBusinessUnitDefaultCardDefaultCard field groupFullNameOrganizationNameParentBusinessUnitDefaultDetailsDefaultDetails field groupBusinessUnitIdFullNameOrganizationNameDescriptionParentBusinessUnitCostCenterMailingPostalAddressPhonePrimaryWebsiteURLEmailPrimaryDefaultLookupDefaultLookup field groupBusinessUnitIdFullNameOrganizationNameDefaultReportDefaultReport field groupBusinessUnitIdFullNameOrganizationNameDescriptionParentBusinessUnitCostCenterMailingPostalAddressPhonePrimaryWebsiteURLEmailPrimaryDefaultIdentificationDefaultIdentification field groupBusinessUnitIdFullNameBusinessUnitContact (Business unit contact) EntityAssociates a business unit and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionBusinessUnitPrimary keyLookup: BusinessUnitRequiredContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128RelationshipsRelated entityDescriptionCardinalityTypeBusinessUnitBusiness unitOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupBusinessUnitContactDataSourceDescriptionDefaultListDefaultList field groupBusinessUnitContactDataSourceDescriptionDefaultCardDefaultCard field groupBusinessUnitContactDataSourceDescriptionDefaultDetailsDefaultDetails field groupBusinessUnitContactDataSourceDescriptionDefaultLookupDefaultLookup field groupBusinessUnitContactDataSourceDescriptionDefaultReportDefaultReport field groupBusinessUnitContactDataSourceDescriptionDefaultIdentificationDefaultIdentification field groupBusinessUnitContactCostCenter (Cost center) EntityA department within an organization that does not directly add profits to an organization but costs the organization money to operate.FieldDescriptionCostCenterIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 128NameData: TextRequired, Maximum length: 128OrganizationLookup: OrganizationRequiredParentCostCenterLookup: CostCenterRelationshipsRelated entityDescriptionCardinalityTypeOrganizationOrganizationOneToManyAssociationCostCenterParent cost centerOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameParentCostCenterOrganizationDescriptionDefaultListDefaultList field groupCostCenterIdNameParentCostCenterOrganizationDefaultCardDefaultCard field groupCostCenterIdNameParentCostCenterOrganizationDefaultDetailsDefaultDetails field groupCostCenterIdNameParentCostCenterOrganizationDescriptionDefaultLookupDefaultLookup field groupCostCenterIdNameParentCostCenterDefaultReportDefaultReport field groupDescriptionCostCenterIdNameParentCostCenterOrganizationDefaultIdentificationDefaultIdentification field groupCostCenterIdNameDepartment (Department) EntityA department within an organization.FieldDescriptionDepartmentIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 2048NameData: TextRequired, Maximum length: 2048OrganizationLookup: OrganizationParentDepartmentLookup: DepartmentRelationshipsRelated entityDescriptionCardinalityTypeDepartmentParent departmentOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupDepartmentIdNameOrganizationParentDepartmentDefaultCreateDefaultCreate field groupDepartmentIdNameOrganizationParentDepartmentDescriptionDefaultDetailsDefaultDetails field groupDepartmentIdNameOrganizationParentDepartmentDescriptionDefaultIdentificationDefaultIdentification field groupDepartmentIdNameDefaultListDefaultList field groupDepartmentIdNameOrganizationParentDepartmentDefaultLookupDefaultLookup field groupDepartmentIdNameDefaultReportDefaultReport field groupDepartmentIdNameOrganizationParentDepartmentDescriptionProduct (Product) EntityAn item that is available for sale.FieldDescriptionDefaultBuyingUnitOfMeasurePicklist: UnitOfMeasureValues: Bag, Box, Bucket, Centilitre, Centimeter, CubicCentimeter, CubicFeet, CubicInch, CubicMeter, CubicMillimeter, CubicYard, Day, Deciliter, DegreesBrix, Dozen, Each, Feet, FluidOunce, Gallon, GigaByte, Gram, HalfCubicInch, HalfInch, HalfPint, HalfPound, HalfSquareInch, Hour, Inch, Keg, Kilogram, Kilometer, KilowattHour, Litre, Meter, Mgpx, Mile, Milligram, Millilitre, Millimeter, Minute, Month, Ohm, OneEighthCubicInch, OneEighthInch, OneEighthSquareInch, Option, Ounce, Pair, Pallet, PascalSecond, Percentage, pHValue, Piece, Pint, Pound, Quart, QuarterCubicInch, QuarterInch, QuarterPound, QuarterSquareInch, Second, SetOfEquipment, SquareCentimeter, SquareFeet, SquareInch, SquareMeter, SquareMile, SquareMillimeter, SquareYard, Ton, Tray, YardDefaultSellingQuantityData: QuantityDefaultStockingUnitOfMeasurePicklist: UnitOfMeasureValues: Bag, Box, Bucket, Centilitre, Centimeter, CubicCentimeter, CubicFeet, CubicInch, CubicMeter, CubicMillimeter, CubicYard, Day, Deciliter, DegreesBrix, Dozen, Each, Feet, FluidOunce, Gallon, GigaByte, Gram, HalfCubicInch, HalfInch, HalfPint, HalfPound, HalfSquareInch, Hour, Inch, Keg, Kilogram, Kilometer, KilowattHour, Litre, Meter, Mgpx, Mile, Milligram, Millilitre, Millimeter, Minute, Month, Ohm, OneEighthCubicInch, OneEighthInch, OneEighthSquareInch, Option, Ounce, Pair, Pallet, PascalSecond, Percentage, pHValue, Piece, Pint, Pound, Quart, QuarterCubicInch, QuarterInch, QuarterPound, QuarterSquareInch, Second, SetOfEquipment, SquareCentimeter, SquareFeet, SquareInch, SquareMeter, SquareMile, SquareMillimeter, SquareYard, Ton, Tray, YardDescriptionData: TextMaximum length: 255IsStockedData: BooleanNameData: TextRequired, Searchable, Maximum length: 60OrganizationLookup: OrganizationProductCategoryLookup: ProductCategoryProductIdPrimary keyNumber sequence:?Unique, SearchableProductTypePicklist: ProductTypeValues: Item, ServiceRequiredSellingUnitPriceData: CurrencyDecimal places: 6StandardCostAmountData: CurrencyDecimal places: 6StatusPicklist: ProductStatusValues: Active, InactiveRequiredUnitOfMeasureScaleData: IntegerRelationshipsRelated entityDescriptionCardinalityTypeProductCategoryProduct categoryOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameProductTypeProductCategoryStatusDescriptionStandardCostAmountSellingUnitPriceDefaultListDefaultList field groupProductIdNameProductTypeProductCategoryStatusDefaultCardDefaultCard field groupProductIdNameProductTypeStatusDefaultDetailsDefaultDetails field groupProductIdNameProductTypeProductCategoryStatusDescriptionStandardCostAmountSellingUnitPriceDefaultBuyingUnitOfMeasureDefaultSellingQuantityDefaultStockingUnitOfMeasureDefaultLookupDefaultLookup field groupProductIdNameProductTypeStatusDefaultReportDefaultReport field groupProductIdNameProductTypeProductCategoryStatusStandardCostAmountSellingUnitPriceDefaultBuyingUnitOfMeasureDefaultSellingQuantityDefaultStockingUnitOfMeasureDefaultIdentificationDefaultIdentification field groupProductIdNameProductCategory (Product category) EntityA categorization of a product.FieldDescriptionCategoryIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: MultilineTextNameData: TextRequired, Maximum length: 60Description: Category nameOrganizationLookup: OrganizationParentProductCategoryLookup: ProductCategoryRelationshipsRelated entityDescriptionCardinalityTypeProductCategoryParent product categoryOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameDescriptionDefaultListDefaultList field groupCategoryIdNameDefaultCardDefaultCard field groupCategoryIdNameDefaultDetailsDefaultDetails field groupCategoryIdNameDescriptionDefaultLookupDefaultLookup field groupCategoryIdNameDescriptionDefaultReportDefaultReport field groupCategoryIdNameDescriptionDefaultIdentificationDefaultIdentification field groupCategoryIdNameProductCategoryAssignment (Product category assignment) EntityAssociates a product and a product category. This entity creates a many-to-many relationship between the two entities.FieldDescriptionProductPrimary keyLookup: ProductRequiredProductCategoryLookup: ProductCategoryRequiredRelationshipsRelated entityDescriptionCardinalityTypeProductProductOneToManyAssociationProductCategoryProduct categoryOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupProductProductCategoryDefaultListDefaultList field groupProductProductCategoryDefaultCardDefaultCard field groupProductProductCategoryDefaultDetailsDefaultDetails field groupProductProductCategoryDefaultLookupDefaultLookup field groupProductProductCategoryDefaultReportDefaultReport field groupProductProductCategoryDefaultIdentificationDefaultIdentification field groupProductProductCategoryUnitOfMeasureConversion (Unit of measure conversion) EntityThe linear conversion rate of one unit of measure to another.FieldDescriptionFromToConversionRateData: NumberRequiredFromUnitOfMeasurePrimary keyPicklist: UnitOfMeasureValues: Bag, Box, Bucket, Centilitre, Centimeter, CubicCentimeter, CubicFeet, CubicInch, CubicMeter, CubicMillimeter, CubicYard, Day, Deciliter, DegreesBrix, Dozen, Each, Feet, FluidOunce, Gallon, GigaByte, Gram, HalfCubicInch, HalfInch, HalfPint, HalfPound, HalfSquareInch, Hour, Inch, Keg, Kilogram, Kilometer, KilowattHour, Litre, Meter, Mgpx, Mile, Milligram, Millilitre, Millimeter, Minute, Month, Ohm, OneEighthCubicInch, OneEighthInch, OneEighthSquareInch, Option, Ounce, Pair, Pallet, PascalSecond, Percentage, pHValue, Piece, Pint, Pound, Quart, QuarterCubicInch, QuarterInch, QuarterPound, QuarterSquareInch, Second, SetOfEquipment, SquareCentimeter, SquareFeet, SquareInch, SquareMeter, SquareMile, SquareMillimeter, SquareYard, Ton, Tray, YardRequiredToFromConversionRateData: NumberRequiredToUnitOfMeasurePicklist: UnitOfMeasureValues: Bag, Box, Bucket, Centilitre, Centimeter, CubicCentimeter, CubicFeet, CubicInch, CubicMeter, CubicMillimeter, CubicYard, Day, Deciliter, DegreesBrix, Dozen, Each, Feet, FluidOunce, Gallon, GigaByte, Gram, HalfCubicInch, HalfInch, HalfPint, HalfPound, HalfSquareInch, Hour, Inch, Keg, Kilogram, Kilometer, KilowattHour, Litre, Meter, Mgpx, Mile, Milligram, Millilitre, Millimeter, Minute, Month, Ohm, OneEighthCubicInch, OneEighthInch, OneEighthSquareInch, Option, Ounce, Pair, Pallet, PascalSecond, Percentage, pHValue, Piece, Pint, Pound, Quart, QuarterCubicInch, QuarterInch, QuarterPound, QuarterSquareInch, Second, SetOfEquipment, SquareCentimeter, SquareFeet, SquareInch, SquareMeter, SquareMile, SquareMillimeter, SquareYard, Ton, Tray, YardRequiredRelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupFromUnitOfMeasureToUnitOfMeasureFromToConversionRateToFromConversionRateDefaultListDefaultList field groupFromUnitOfMeasureToUnitOfMeasureDefaultCardDefaultCard field groupFromUnitOfMeasureToUnitOfMeasureDefaultDetailsDefaultDetails field groupFromUnitOfMeasureToUnitOfMeasureFromToConversionRateToFromConversionRateDefaultLookupDefaultLookup field groupFromUnitOfMeasureToUnitOfMeasureDefaultReportDefaultReport field groupFromUnitOfMeasureToUnitOfMeasureFromToConversionRateToFromConversionRateDefaultIdentificationDefaultIdentification field groupFromUnitOfMeasureToUnitOfMeasureUserOrGroup (User or group) EntityA user or a group.FieldDescriptionDisplayNameData: TextRequired, Maximum length: 255EmailData: TextMaximum length: 255GivenNameData: TextMaximum length: 255GraphIdentifierPrimary keyData: TextRequired, Unique, Searchable, Maximum length: 36IsSecurityEnabledData: BooleanRequiredSurnameData: TextMaximum length: 255TypePicklist: UserOrGroupTypeValues: Group, ServicePrincipal, UserRequiredRelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupDisplayNameEmailDefaultCreateDefaultCreate field groupDisplayNameTypeGivenNameSurnameEmailDefaultDetailsDefaultDetails field groupDisplayNameTypeGivenNameSurnameEmailDefaultIdentificationDefaultIdentification field groupGraphIdentifierDefaultListDefaultList field groupDisplayNameTypeEmailDefaultLookupDefaultLookup field groupDisplayNameEmailDefaultReportDefaultReport field groupHuman resources entitiesThe human resources entities let you manage employment information, jobs, leaves, and positions.Human resources ERDHuman resources referenceEmployment (Employment) EntityEmployment information of a worker who has been hired by an organization.FieldDescriptionAdjustedWorkerStartDateData: DateTimeEmployerNoticeAmountData: NumberEmployerUnitOfNoticePicklist: EmploymentUnitOfNoticeValues: Month, WeekEmploymentEndDateData: DateTimeEmploymentStartDateData: DateTimeRequiredLastDateWorkedData: DateTimeOrganizationLookup: OrganizationRequiredTransitionDateData: DateTimeValidFromData: DateTimeRequiredValidToData: DateTimeWorkerPrimary keyLookup: WorkerRequiredWorkerNoticeAmountData: NumberWorkerStartDateData: DateTimeWorkerTypePicklist: WorkerTypeValues: Contractor, Employee, Unspecified, VolunteerRequiredWorkerUnitOfNoticePicklist: EmploymentUnitOfNoticeValues: Month, WeekRelationshipsRelated entityDescriptionCardinalityTypeOrganizationOrganizationOneToManyAssociationWorkerWorkerOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupWorkerOrganizationEmploymentStartDateEmploymentEndDateDefaultCreateDefaultCreate field groupWorkerOrganizationEmploymentStartDateValidFromWorkerTypeDefaultDetailsDefaultDetails field groupWorkerOrganizationEmploymentStartDateEmploymentEndDateValidFromValidToDefaultIdentificationDefaultIdentification field groupWorkerOrganizationDefaultListDefaultList field groupWorkerOrganizationEmploymentStartDateEmploymentEndDateDefaultLookupDefaultLookup field groupWorkerOrganizationDefaultReportDefaultReport field groupWorkerOrganizationEmploymentStartDateEmploymentEndDateValidFromValidToJob (Job) EntityRole or responsibility that an employee or contractor has within an organization.FieldDescriptionAllowUnlimitedPositionsData: BooleanDefaultFullTimeEquivalentData: NumberDescriptionData: TextMaximum length: 2048JobFunctionLookup: JobFunctionJobIdPrimary keyNumber sequence:?Unique, SearchableJobTypeLookup: JobTypeMaximumNumberOfPositionsData: IntegerNameData: TextSearchable, Maximum length: 2048TitlePicklist: JobTitleValues: NotSpecifiedValidFromData: DateTimeRequired, SearchableValidToData: DateTimeRelationshipsRelated entityDescriptionCardinalityTypeJobTypeJob TypeOneToManyAssociationJobFunctionJob FunctionOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupNameTitleValidFromValidToDefaultCreateDefaultCreate field groupNameTitleValidFromValidToJobFunctionJobTypeDefaultFullTimeEquivalentDefaultDetailsDefaultDetails field groupNameTitleValidFromValidToJobFunctionJobTypeDefaultFullTimeEquivalentDefaultIdentificationDefaultIdentification field groupJobIdNameDefaultListDefaultList field groupNameTitleValidFromValidToDefaultLookupDefaultLookup field groupJobIdNameDefaultReportDefaultReport field groupNameTitleValidFromValidToJobFunctionJobTypeDefaultFullTimeEquivalentJobFunction (Job Function) EntityClassification defining the function of the job, for example, professionals, technicians, or service workers.FieldDescriptionDescriptionData: TextRequired, Maximum length: 2048JobFunctionIdPrimary keyNumber sequence:?Unique, SearchableRelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupJobFunctionIdDescriptionDefaultCreateDefaultCreate field groupJobFunctionIdDescriptionDefaultDetailsDefaultDetails field groupJobFunctionIdDescriptionDefaultIdentificationDefaultIdentification field groupJobFunctionIdDescriptionDefaultListDefaultList field groupJobFunctionIdDescriptionDefaultLookupDefaultLookup field groupJobFunctionIdDescriptionDefaultReportDefaultReport field groupJobFunctionIdDescriptionJobType (Job Type) EntitySecondary classification of jobs, for example, exempt and nonexempt positions.FieldDescriptionDescriptionData: TextRequired, Maximum length: 2048ExemptStatusPicklist: JobExemptStatusValues: DoesNotApply, Exempt, NonExemptRequiredJobTypeIdPrimary keyNumber sequence:?Unique, SearchableRelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupJobTypeIdDescriptionExemptStatusDefaultCreateDefaultCreate field groupJobTypeIdDescriptionExemptStatusDefaultDetailsDefaultDetails field groupJobTypeIdDescriptionExemptStatusDefaultIdentificationDefaultIdentification field groupJobTypeIdDescriptionDefaultListDefaultList field groupJobTypeIdDescriptionExemptStatusDefaultLookupDefaultLookup field groupJobTypeIdDescriptionDefaultReportDefaultReport field groupJobTypeIdDescriptionExemptStatusLeaveRequest (Leave request) EntityRequest entered for leave or time off.FieldDescriptionCommentData: TextMaximum length: 2048LeaveRequestIdPrimary keyNumber sequence:?Unique, SearchableOrganizationLookup: OrganizationRequestDateData: DateTimeRequiredStatusPicklist: LeaveRequestStatusValues: Approved, Draft, InReviewWorkerLookup: WorkerRequiredRelationshipsRelated entityDescriptionCardinalityTypeWorkerWorkerOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupLeaveRequestIdWorkerRequestDateStatusDefaultCreateDefaultCreate field groupLeaveRequestIdWorkerRequestDateStatusCommentDefaultDetailsDefaultDetails field groupLeaveRequestIdWorkerRequestDateStatusCommentDefaultIdentificationDefaultIdentification field groupLeaveRequestIdWorkerDefaultListDefaultList field groupLeaveRequestIdWorkerRequestDateStatusDefaultLookupDefaultLookup field groupLeaveRequestIdWorkerDefaultReportDefaultReport field groupLeaveRequestIdWorkerRequestDateStatusLeaveRequestDetail (Leave request detail) EntityDetails captured during the leave request process.FieldDescriptionAmountData: NumberLeaveDateData: DateTimeRequiredDescription: DateLeaveRequestPrimary keyLookup: LeaveRequestRequiredLeaveTypeLookup: LeaveTypeRequiredRelationshipsRelated entityDescriptionCardinalityTypeLeaveTypeLeave typeOneToManyAssociationLeaveRequestLeave requestOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupLeaveRequestLeaveTypeLeaveDateAmountDefaultCreateDefaultCreate field groupLeaveRequestLeaveTypeLeaveDateAmountDefaultDetailsDefaultDetails field groupLeaveRequestLeaveTypeLeaveDateAmountDefaultIdentificationDefaultIdentification field groupLeaveRequestLeaveTypeDefaultListDefaultList field groupLeaveRequestLeaveTypeLeaveDateAmountDefaultLookupDefaultLookup field groupLeaveRequestLeaveTypeDefaultReportDefaultReport field groupLeaveRequestLeaveTypeLeaveDateAmountLeaveType (Leave type) EntityClassifications of different types of leave that are offered by an organization.FieldDescriptionDescriptionData: TextRequired, Maximum length: 2048LeaveTypeIdPrimary keyNumber sequence:?Unique, SearchableOrganizationLookup: OrganizationRelationshipsRelated entityDescriptionCardinalityTypeOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupLeaveTypeIdDescriptionDefaultCreateDefaultCreate field groupLeaveTypeIdDescriptionDefaultDetailsDefaultDetails field groupLeaveTypeIdDescriptionDefaultIdentificationDefaultIdentification field groupLeaveTypeIdDescriptionDefaultListDefaultList field groupLeaveTypeIdDescriptionDefaultLookupDefaultLookup field groupLeaveTypeIdDescriptionDefaultReportDefaultReport field groupLeaveTypeIdDescriptionPosition (Position) EntityAn instance of a job. Positions are assigned to workers.FieldDescriptionActivationData: DateTimeAvailableForAssignmentData: DateTimeDepartmentLookup: DepartmentDescriptionData: TextMaximum length: 2048FullTimeEquivalentData: NumberJobLookup: JobRequiredParentPositionLookup: PositionPositionIdPrimary keyNumber sequence:?Unique, SearchablePositionTypeLookup: PositionTypeRetirementData: DateTimeTitlePicklist: JobTitleValues: NotSpecifiedValidFromData: DateTimeRequiredValidToData: DateTimeRelationshipsRelated entityDescriptionCardinalityTypePositionParent positionOneToManyAssociationJobJobOneToManyAssociationDepartmentDepartmentOneToManyAssociationPositionTypePosition TypeOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupPositionIdValidFromDescriptionJobDefaultCreateDefaultCreate field groupPositionIdValidFromValidToPositionTypeJobDepartmentDescriptionDefaultDetailsDefaultDetails field groupPositionIdValidFromValidToPositionTypeJobDepartmentDescriptionDefaultIdentificationDefaultIdentification field groupPositionIdDescriptionDefaultListDefaultList field groupPositionIdValidFromDescriptionJobDefaultLookupDefaultLookup field groupPositionIdDescriptionDefaultReportDefaultReport field groupPositionIdValidFromValidToPositionTypePositionType (Position Type) EntityClassification of positions in an organization, for example, full-time, part-time, or volunteer.FieldDescriptionClassificationPicklist: PositionClassificationValues: FullTime, PartTimeDescriptionData: TextRequired, Maximum length: 2048PositionTypeIdPrimary keyNumber sequence:?Unique, SearchableRelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupPositionTypeIdDescriptionClassificationDefaultCreateDefaultCreate field groupPositionTypeIdDescriptionClassificationDefaultDetailsDefaultDetails field groupPositionTypeIdDescriptionClassificationDefaultIdentificationDefaultIdentification field groupPositionTypeIdDescriptionDefaultListDefaultList field groupPositionTypeIdDescriptionClassificationDefaultLookupDefaultLookup field groupPositionTypeIdDescriptionDefaultReportDefaultReport field groupPositionTypeIdDescriptionPositionWorkerAssignment (Position worker assignment) EntityThe position or job instance that an employee or contractor has been assigned. Assignments are defined by a start-date and an end-date.FieldDescriptionPositionPrimary keyLookup: PositionRequiredValidFromData: DateTimeRequiredValidToData: DateTimeWorkerLookup: WorkerRequiredRelationshipsRelated entityDescriptionCardinalityTypeWorkerWorkerOneToManyAssociationPositionPositionOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupPositionValidFromValidToWorkerDefaultCreateDefaultCreate field groupPositionValidFromValidToWorkerDefaultDetailsDefaultDetails field groupPositionValidFromValidToWorkerDefaultIdentificationDefaultIdentification field groupPositionValidFromDefaultListDefaultList field groupPositionValidFromValidToWorkerDefaultLookupDefaultLookup field groupPositionValidFromDefaultReportDefaultReport field groupPositionValidFromValidToWorkerPerson, organization, and group entitiesThe people, organizations, and groups entities encompass a rich set of people and organizations that you might interact with, including employees, contractors, donors, volunteers, fans, alumni, and families.Person, organization, and group ERDPerson, organization, and group referenceAlumnus (Alumnus) EntityA graduate of a school.FieldDescriptionAlumnusIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.BirthdateData: DateBusinessPostalAddressData: AddressDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128GraduationClassData: TextMaximum length: 128GraduationDateData: DateHomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128NameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200PartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: AlumnusStatusValues: Current, Inactive, PastRequiredTwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameGraduationClassStatusEmailPrimaryHomePostalAddressDescriptionFacebookIdentityTwitterIdentityPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedDefaultListDefaultList field groupFullNameGraduationClassStatusEmailPrimaryDefaultCardDefaultCard field groupFullNameGraduationClassPhonePrimaryDefaultDetailsDefaultDetails field groupAlumnusIdNameGraduationClassStatusEmailPrimaryHomePostalAddressDescriptionFacebookIdentityTwitterIdentityDefaultLookupDefaultLookup field groupAlumnusIdFullNameGraduationClassStatusDefaultReportDefaultReport field groupAlumnusIdNameGraduationClassStatusEmailPrimaryDescriptionFacebookIdentityTwitterIdentityDefaultIdentificationDefaultIdentification field groupAlumnusIdFullNameApplicationUser (Application user) EntityA person who can be authenticated as a user of Common Data Service.FieldDescriptionAADUserOIDPrimary keyData: TextRequired, Unique, Searchable, Maximum length: 36Description: AAD user object IDApplicationUserIdNumber sequence:?Unique, SearchableBirthdateData: DateBusinessPostalAddressData: AddressBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailRequired, Unique, SearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextMaximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128HomePostalAddressData: AddressIsAdminData: BooleanRequiredIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128NameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200PartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: ApplicationUserStatusValues: Active, InactiveRequiredTwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameEmailPrimaryDescriptionSocialNetwork01SocialNetworkIdentity01PartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedStatusIsAdminAADUserOIDDefaultListDefaultList field groupApplicationUserIdFullNameStatusDefaultCardDefaultCard field groupApplicationUserIdFullNameEmailPrimaryDefaultDetailsDefaultDetails field groupApplicationUserIdFullNameNameEmailPrimaryDescriptionSocialNetwork01SocialNetworkIdentity01DefaultLookupDefaultLookup field groupApplicationUserIdFullNameEmailPrimaryDefaultReportDefaultReport field groupApplicationUserIdFullNameNameEmailPrimaryDescriptionSocialNetwork01SocialNetworkIdentity01DefaultIdentificationDefaultIdentification field groupApplicationUserIdFullNameApplicationUserContact (Application user contact) EntityAssociates an application user and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionApplicationUserPrimary keyLookup: ApplicationUserRequiredContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128IsOwnerData: BooleanRequiredRelationshipsRelated entityDescriptionCardinalityTypeApplicationUserApplication userOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupDataSourceDescriptionIsOwnerContactApplicationUserDefaultListDefaultList field groupDataSourceDescriptionIsOwnerContactApplicationUserDefaultCardDefaultCard field groupDataSourceDescriptionIsOwnerContactApplicationUserDefaultDetailsDefaultDetails field groupDataSourceDescriptionIsOwnerContactApplicationUserDefaultLookupDefaultLookup field groupDescriptionIsOwnerContactApplicationUserDefaultReportDefaultReport field groupDataSourceDescriptionIsOwnerContactApplicationUserDefaultIdentificationDefaultIdentification field groupApplicationUserContactApplicationUserGroup (Application user group) EntityA collection of application users.FieldDescriptionApplicationUserGroupIdPrimary keyNumber sequence:?Unique, SearchableBusinessUnitLookup: BusinessUnitRequiredDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFullNameData: TextSearchable, Maximum length: 128GroupNameData: TextMaximum length: 128IsSecurityPrincipalData: BooleanRequiredMailingPostalAddressData: AddressOfficeGraphIdentifierData: TextMaximum length: 200OtherPostalAddressData: AddressPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhonePrimaryData: PhoneShippingPostalAddressData: AddressSourcePicklist: SourceValues: DefaultRequiredStatusPicklist: ApplicationUserGroupStatusValues: Active, InactiveRequiredWebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupStatusBusinessUnitPartyTypeSourceIsSecurityPrincipalDefaultListDefaultList field groupApplicationUserGroupIdFullNameStatusDefaultCardDefaultCard field groupApplicationUserGroupIdFullNameStatusDefaultDetailsDefaultDetails field groupApplicationUserGroupIdFullNameStatusBusinessUnitDefaultLookupDefaultLookup field groupApplicationUserGroupIdFullNameStatusDefaultReportDefaultReport field groupApplicationUserGroupIdFullNameStatusBusinessUnitDefaultIdentificationDefaultIdentification field groupApplicationUserGroupIdFullNameConstituent (Constituent) EntityA member of a constituency.FieldDescriptionBirthdateData: DateBusinessPostalAddressData: AddressConstituentIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.DescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128HomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredIsSecurityPrincipalData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128NameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200PartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128SatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: ConstituentStatusValues: Active, InactiveRequiredTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameStatusPhoneCellPhoneBusinessEmailPrimaryDescriptionFacebookIdentityLinkedInIdentityTwitterIdentityPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedIsSecurityPrincipalDefaultListDefaultList field groupFullNameStatusPhoneCellPhoneBusinessEmailPrimaryDefaultCardDefaultCard field groupConstituentIdFullNameStatusDefaultDetailsDefaultDetails field groupConstituentIdFullNameNameStatusPhoneCellPhoneBusinessEmailPrimaryDescriptionFacebookIdentityLinkedInIdentityTwitterIdentityDefaultLookupDefaultLookup field groupConstituentIdFullNameDefaultReportDefaultReport field groupConstituentIdFullNameNameStatusPhoneCellPhoneBusinessEmailPrimaryFacebookIdentityLinkedInIdentityTwitterIdentityDefaultIdentificationDefaultIdentification field groupConstituentIdFullNameContact (Contact) EntityA person who serves as a contact for an organization.FieldDescriptionBirthdateData: DateBusinessPostalAddressData: AddressBusinessUnitLookup: BusinessUnitContactIdPrimary keyNumber sequence:?Unique, SearchableDepartmentData: TextMaximum length: 128DescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128GovernmentIdentifierData: TextMaximum length: 128HomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredIsPostalMailAllowedData: BooleanLinkedInIdentityData: TextMaximum length: 128MaritalStatusPicklist: MaritalStatusValues: Divorced, Married, None, Single, WidowedNameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPersonInformationData: TextMaximum length: 2048PhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhonePrimaryAccountLookup: AccountPrimaryAccountRolePicklist: PrimaryAccountRoleValues: DecisionMaker, Employee, InfluencerProfessionData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: StatusValues: Active, InactiveRequiredTwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255WorkerResponsibleLookup: WorkerRelationshipsRelated entityDescriptionCardinalityTypeAccountPrimary accountOneToManyAssociationWorkerWorker responsibleOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNamePhoneCellPhoneBusinessPhoneHomeEmailPrimaryFacebookIdentityLinkedInIdentityTwitterIdentityBusinessPostalAddressWebsiteURLPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedStatusDefaultListDefaultList field groupFullNameEmailPrimaryPhoneBusinessPhoneCellDefaultCardDefaultCard field groupFullNamePhoneCellEmailPrimaryDefaultDetailsDefaultDetails field groupContactIdFullNameNamePhoneCellPhoneBusinessPhoneHomeEmailPrimaryFacebookIdentityLinkedInIdentityTwitterIdentityBusinessPostalAddressWebsiteURLDefaultLookupDefaultLookup field groupContactIdFullNameEmailPrimaryDefaultReportDefaultReport field groupContactIdFullNameNamePhoneCellPhoneBusinessPhoneHomeEmailPrimaryFacebookIdentityLinkedInIdentityTwitterIdentityBusinessPostalAddressWebsiteURLDefaultIdentificationDefaultIdentification field groupFullNameEmailPrimaryContactOtherPostalAddress (Contact other postal address) EntityA postal address that is associated with a contact. It is separate from the shipping address and the mailing address.FieldDescriptionAddressIdPrimary keyNumber sequence:?Unique, SearchableContactLookup: ContactRequiredDescriptionData: TextMaximum length: 128OtherPostalAddressData: AddressRelationshipsRelated entityDescriptionCardinalityTypeContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupContactDescriptionOtherPostalAddressDefaultListDefaultList field groupContactDescriptionOtherPostalAddressDefaultCardDefaultCard field groupContactDescriptionOtherPostalAddressDefaultDetailsDefaultDetails field groupContactDescriptionOtherPostalAddressDefaultLookupDefaultLookup field groupContactDescriptionOtherPostalAddressDefaultReportDefaultReport field groupContactDescriptionOtherPostalAddressDefaultIdentificationDefaultIdentification field groupAddressIdContactFamily (Family) EntityA group of related people. Individual family members are described in the FamilyMember entity.FieldDescriptionDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFamilyIdPrimary keyNumber sequence:?Unique, SearchableFullNameData: TextSearchable, Maximum length: 128GroupNameData: TextMaximum length: 128MailingPostalAddressData: AddressOtherPostalAddressData: AddressPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhoneShippingPostalAddressData: AddressSourcePicklist: SourceValues: DefaultRequiredStatusPicklist: FamilyStatusValues: Active, InactiveRequiredWebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupStatusPhonePrimaryDescriptionMailingPostalAddressPartyTypeSourceDefaultListDefaultList field groupFamilyIdFullNameStatusPhonePrimaryDefaultCardDefaultCard field groupFamilyIdFullNameStatusPhonePrimaryDefaultDetailsDefaultDetails field groupFamilyIdFullNameStatusPhonePrimaryDescriptionMailingPostalAddressDefaultLookupDefaultLookup field groupFamilyIdFullNameStatusDefaultReportDefaultReport field groupFamilyIdFullNameStatusPhonePrimaryDefaultIdentificationDefaultIdentification field groupFamilyIdFullNameFamilyMember (Family member) EntityA person who is a member of a Family entity.FieldDescriptionDescriptionData: TextMaximum length: 128FamilyPrimary keyLookup: FamilyRequiredPersonLookup: PersonRequiredPrimaryRolePicklist: FamilyRoleValues: ElderSiblings, Father, GrandParents, Mother, YoungerSiblingsRequiredStatusPicklist: FamilyMemberStatusValues: Active, InactiveRequiredRelationshipsRelated entityDescriptionCardinalityTypeFamilyFamilyOneToManyAssociationPersonPersonOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPersonPrimaryRoleFamilyDescriptionStatusDefaultListDefaultList field groupPersonPrimaryRoleFamilyDefaultCardDefaultCard field groupPersonPrimaryRoleFamilyDefaultDetailsDefaultDetails field groupPersonPrimaryRoleFamilyDescriptionDefaultLookupDefaultLookup field groupPersonPrimaryRoleFamilyDefaultReportDefaultReport field groupPersonPrimaryRoleFamilyDescriptionDefaultIdentificationDefaultIdentification field groupPersonFamilyFan (Fan) EntityA fan of a sports team.FieldDescriptionBirthdateData: DateBusinessPostalAddressData: AddressDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FanIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.FanSinceData: DateFavoritePlayerData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128HomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredIsSecurityPrincipalData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128NameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200PartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128SatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: FanStatusValues: Bronze, Club, Gold, Platinum, PreferenceTicket, SeasonTicketHolder, SilverRequiredDescription: Fan statusTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameStatusFanSinceFavoritePlayerPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedIsSecurityPrincipalDefaultListDefaultList field groupFullNameStatusFanSinceFavoritePlayerDefaultCardDefaultCard field groupFanIdFullNameStatusDefaultDetailsDefaultDetails field groupFanIdFullNameNameStatusFanSinceFavoritePlayerDefaultLookupDefaultLookup field groupFanIdFullNameStatusFanSinceDefaultReportDefaultReport field groupFanIdFullNameNameStatusFanSinceFavoritePlayerDefaultIdentificationDefaultIdentification field groupFanIdFullNameHousehold (Household) EntityA group of individuals who share a living space. Individual household members are described in the HouseholdMember entity.FieldDescriptionDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFullNameData: TextSearchable, Maximum length: 128GroupNameData: TextMaximum length: 128HouseholdIdPrimary keyNumber sequence:?Unique, SearchableMailingPostalAddressData: AddressOtherPostalAddressData: AddressPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhoneShippingPostalAddressData: AddressSourcePicklist: SourceValues: DefaultRequiredStatusPicklist: HouseholdStatusValues: Active, InactiveRequiredWebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupStatusPhonePrimaryDescriptionMailingPostalAddressPartyTypeSourceDefaultListDefaultList field groupFullNameStatusPhonePrimaryDefaultCardDefaultCard field groupHouseholdIdFullNameStatusPhonePrimaryDefaultDetailsDefaultDetails field groupHouseholdIdFullNameStatusPhonePrimaryDescriptionMailingPostalAddressDefaultLookupDefaultLookup field groupHouseholdIdFullNameStatusDefaultReportDefaultReport field groupHouseholdIdFullNameStatusPhonePrimaryDescriptionDefaultIdentificationDefaultIdentification field groupHouseholdIdFullNameHouseholdMember (Household member) EntityA person who is a member of a Household entity.FieldDescriptionDescriptionData: TextMaximum length: 128HouseholdPrimary keyLookup: HouseholdRequiredPersonLookup: PersonRequiredPrimaryRolePicklist: HouseholdRoleValues: ElderSiblings, Father, GrandParents, Mother, YoungerSiblingsRequiredStatusPicklist: HouseholdMemberStatusValues: Active, InactiveRequiredRelationshipsRelated entityDescriptionCardinalityTypeHouseholdHouseholdOneToManyAssociationPersonPersonOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupHouseholdPersonPrimaryRoleDescriptionStatusDefaultListDefaultList field groupPersonHouseholdPrimaryRoleDefaultCardDefaultCard field groupHouseholdPersonPrimaryRoleDefaultDetailsDefaultDetails field groupHouseholdPersonPrimaryRoleDescriptionDefaultLookupDefaultLookup field groupHouseholdPersonPrimaryRoleDefaultReportDefaultReport field groupHouseholdPersonPrimaryRoleDefaultIdentificationDefaultIdentification field groupPersonHouseholdOrganization (Organization) EntityA corporate organization that can have business units.FieldDescriptionDescriptionData: TextMaximum length: 128DUNSNumberData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128IndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleIsEmailContactAllowedData: BooleanRequiredIsInternalData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128MailingPostalAddressData: AddressOfficeGraphIdentifierData: TextMaximum length: 200OrganizationIdPrimary keyNumber sequence:?Unique, SearchableOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressParentOrganizationLookup: OrganizationPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhonePrimaryContactLookup: ContactSatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: OrganizationStatusValues: Active, InactiveRequiredStockExchangePicklist: StockExchangeValues: BMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeStockTickerData: TextMaximum length: 128TaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128TypePicklist: OrganizationTypeValues: Corporation, Government, NonProfit, OtherRequiredDescription: OrganizationTypeWebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeOrganizationParent OrganizationOneToManyAssociationContactPrimary contactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupDescriptionParentOrganizationPhonePrimaryEmailPrimaryMailingPostalAddressPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedIsInternalTypeStatusDefaultListDefaultList field groupOrganizationIdFullNameDescriptionParentOrganizationDefaultCardDefaultCard field groupOrganizationIdFullNameDefaultDetailsDefaultDetails field groupOrganizationIdFullNameDescriptionParentOrganizationPhonePrimaryEmailPrimaryMailingPostalAddressFacebookIdentityLinkedInIdentityTwitterIdentityTaxIdentificationNumberStockTickerDefaultLookupDefaultLookup field groupOrganizationIdFullNameDefaultReportDefaultReport field groupOrganizationIdFullNameDescriptionParentOrganizationPhonePrimaryEmailPrimaryTaxIdentificationNumberStockTickerDefaultIdentificationDefaultIdentification field groupOrganizationIdFullNameOrganizationContact (Organization contact) EntityAssociates an organization and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128OrganizationPrimary keyLookup: OrganizationRequiredRelationshipsRelated entityDescriptionCardinalityTypeOrganizationOrganizationOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupOrganizationContactDataSourceDescriptionDefaultListDefaultList field groupOrganizationContactDataSourceDescriptionDefaultCardDefaultCard field groupOrganizationContactDataSourceDescriptionDefaultDetailsDefaultDetails field groupOrganizationContactDataSourceDescriptionDefaultLookupDefaultLookup field groupOrganizationContactDataSourceDescriptionDefaultReportDefaultReport field groupOrganizationContactDataSourceDescriptionDefaultIdentificationDefaultIdentification field groupOrganizationContactTeam (Team) EntityA group of persons who participate together in a defined effort.FieldDescriptionDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFullNameData: TextSearchable, Maximum length: 128GroupNameData: TextMaximum length: 128MailingPostalAddressData: AddressOtherPostalAddressData: AddressPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhoneShippingPostalAddressData: AddressSourcePicklist: SourceValues: DefaultRequiredStatusPicklist: TeamStatusValues: Active, InactiveRequiredTeamIdPrimary keyNumber sequence:?Unique, SearchableWebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupDescriptionStatusPhonePrimaryEmailPrimaryPartyTypeSourceDefaultListDefaultList field groupFullNameStatusPhonePrimaryEmailPrimaryDefaultCardDefaultCard field groupFullNameStatusPhonePrimaryEmailPrimaryDefaultDetailsDefaultDetails field groupTeamIdFullNameDescriptionStatusPhonePrimaryEmailPrimaryDefaultLookupDefaultLookup field groupTeamIdFullNameStatusPhonePrimaryEmailPrimaryDefaultReportDefaultReport field groupTeamIdFullNameDescriptionStatusPhonePrimaryEmailPrimaryDefaultIdentificationDefaultIdentification field groupTeamIdFullNameTeamMember (Team member) EntityA person who is a member of a team.FieldDescriptionDescriptionData: TextMaximum length: 128PersonLookup: PersonRequiredPrimaryRolePicklist: TeamRoleValues: Coach, Lead, Manager, Player, Reserve, TeamLeader, TeamMemberRequiredStatusPicklist: TeamMemberStatusValues: Active, InactiveRequiredTeamPrimary keyLookup: TeamRequiredRelationshipsRelated entityDescriptionCardinalityTypeTeamTeamOneToManyAssociationPersonPersonOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPersonTeamPrimaryRoleStatusDefaultListDefaultList field groupPersonTeamPrimaryRoleDefaultCardDefaultCard field groupPersonTeamPrimaryRoleDefaultDetailsDefaultDetails field groupPersonTeamPrimaryRoleDefaultLookupDefaultLookup field groupPersonTeamPrimaryRoleDefaultReportDefaultReport field groupPersonTeamPrimaryRoleDefaultIdentificationDefaultIdentification field groupPersonTeamTenant (Tenant) EntityA person or organization that leases space.FieldDescriptionBirthdateData: DateBusinessPostalAddressData: AddressDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128HomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredIsSecurityPrincipalData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128OfficeGraphIdentifierData: TextMaximum length: 200PartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPersonNameData: PersonNameDescription: Given namePhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128SatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: TenantStatusValues: Active, InactiveRequiredTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TenantIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPersonNameStatusPhonePrimaryHomePostalAddressPartyTypeSourceIsSecurityPrincipalIsEmailContactAllowedIsPhoneContactAllowedDefaultListDefaultList field groupFullNameStatusDefaultCardDefaultCard field groupFullNameStatusDefaultDetailsDefaultDetails field groupTenantIdFullNamePersonNameStatusPhonePrimaryHomePostalAddressDefaultLookupDefaultLookup field groupTenantIdFullNameStatusDefaultReportDefaultReport field groupTenantIdFullNamePersonNameStatusPhonePrimaryHomePostalAddressDefaultIdentificationDefaultIdentification field groupTenantIdFullNameWorker (Worker) EntityA person who is engaged by an organization as an employee, contractor, or volunteer.FieldDescriptionBirthdateData: DateBusinessPostalAddressData: AddressBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128HomePostalAddressData: AddressIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredLinkedInAPIURLData: MultilineTextLinkedInIdentityData: TextMaximum length: 128ManagerLookup: WorkerNameData: PersonNameDescription: Given nameOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhoneBusinessData: PhonePhoneCellData: PhonePhoneHomeData: PhonePhonePrimaryData: PhoneProfessionData: TextMaximum length: 128SatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: WorkerStatusValues: Active, InactiveRequiredTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128TypePicklist: WorkerTypeValues: Contractor, Employee, Unspecified, VolunteerRequiredWebsiteURLData: TextMaximum length: 255WorkerIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.RelationshipsRelated entityDescriptionCardinalityTypeWorkerManagerOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameStatusDescriptionManagerBusinessUnitPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedTypeDefaultListDefaultList field groupWorkerIdFullNameStatusManagerBusinessUnitDefaultCardDefaultCard field groupWorkerIdFullNameStatusManagerBusinessUnitDefaultDetailsDefaultDetails field groupWorkerIdFullNameNameStatusDescriptionManagerBusinessUnitPhoneCellPhoneBusinessFacebookIdentityLinkedInIdentityTwitterIdentityHomePostalAddressDefaultLookupDefaultLookup field groupWorkerIdFullNameStatusDefaultReportDefaultReport field groupWorkerIdFullNameNameStatusManagerBusinessUnitPhoneCellPhoneBusinessFacebookIdentityLinkedInIdentityTwitterIdentityDefaultIdentificationDefaultIdentification field groupWorkerIdFullNameProductivity entitiesThe productivity entities let you track events and messages.Productivity ERDProductivity referenceEvent (Event) EntityAn event (appointment, meeting) within a user’s mailbox or related to data within the Common Data Service. This entity is connected to Microsoft Graph to retrieve mail box events.FieldDescriptionAttendeesData: TextMaximum length: 2048Body_ContentData: MemoDescription: Body contentBody_ContentTypePicklist: BodyContentTypeValues: HTML, TextDescription: Body content typeBodyPreviewData: TextMaximum length: 2048CategoriesData: TextMaximum length: 2048ChangeKeyData: TextMaximum length: 2048EndData: DateTimeHasAttachmentsData: BooleanICalUIdData: TextMaximum length: 2048Description: Unique calendar IDIdPrimary keyData: TextRequired, Unique, Searchable, Maximum length: 2048Description: Event IDImportancePicklist: EventImportanceValues: High, Low, NormalIsAllDayData: BooleanDescription: All dayIsCancelledData: BooleanDescription: CancelledIsOrganizerData: BooleanDescription: OrganizerIsReminderOnData: BooleanDescription: ReminderLocation_AddressData: AddressDescription: Location addressLocation_DisplayNameData: TextMaximum length: 2048Description: Location display nameLocation_EmailAddressData: TextMaximum length: 2048Description: Location email addressOnlineMeetingURLData: TextMaximum length: 2048OrganizerData: TextMaximum length: 2048OriginalEndTimeZonePicklist: TimezoneValues: GMT_CASABLANCA, GMT_CASABLANCA_MONTROVIA_REYKJAVIK, GMT_COORDINATEDUNIVERSALTIME, GMT_DUBLIN_EDINBURGH_LISBON_LONDON, GMT_PLUS0300KALININGRAD_MINSK, GMTMINUS0100AZORES, GMTMINUS0100CAPEVERDIS, GMTMINUS0200MIDATLANTIC, GMTMINUS0300_SALVADOR, GMTMINUS0300BRASILIA, GMTMINUS0300BUENOSAIRES, GMTMINUS0300BUENOSAIRES_GEORGETOWN, GMTMINUS0300GREENLAND, GMTMINUS0300MONTEVIDEO, GMTMINUS0330NEWFOUNDLAND, GMTMINUS0400ASUNCION, GMTMINUS0400ATLANTICTIME, GMTMINUS0400LAPAZ, GMTMINUS0400MANAUS, GMTMINUS0400SANTIAGO, GMTMINUS0430CARACAS, GMTMINUS0500BOGOTA_LIMA_QUITO_RIOBRANCO, GMTMINUS0500EASTERNTIME, GMTMINUS0500INDIANA, GMTMINUS0600CENTRALAMERICA, GMTMINUS0600CENTRALTIME, GMTMINUS0600GUADALAJARA_MEXICOCITY, GMTMINUS0600SASKATCHEWAN, GMTMINUS0700ARIZONA, GMTMINUS0700CHIHUAHUA_LAPAZ_MAZATLAN, GMTMINUS0700MOUNTAINTIME, GMTMINUS0800PACIFICTIME, GMTMINUS0800TIJUANA_BAJACALIFORNIA, GMTMINUS0900ALASKA, GMTMINUS1000HAWAII, GMTMINUS1100COORDINATEDUNIVERSALTIME, GMTMINUS1100MIDWAYISLAND_SAMOA, GMTMINUS1200INTERNATIONALDATELINEWEST, GMTPLUS0100_AMSTERDAM_BERLIN_BERN_ROME, GMTPLUS0100BELGRADE_BRATISLAVA_BUDAPEST, GMTPLUS0100BRUSSELS_COPENHAGEN_MADRID, GMTPLUS0100SARAJEVO_SKOPJE_WARSAW_ZAGREB, GMTPLUS0100TRIPOLI, GMTPLUS0100WESTCENTRALAFRICA, GMTPLUS0200_DAMASCUS, GMTPLUS0200AMMAN, GMTPLUS0200ATHENS_BUCHAREST_ISTANBUL, GMTPLUS0200BEIRUT, GMTPLUS0200CAIRO, GMTPLUS0200HARARE_PRETORIA, GMTPLUS0200HELSINKI_KYIV_RIGA_VILNIUS, GMTPLUS0200ISTANBUL, GMTPLUS0200JERUSALEM, GMTPLUS0200MINSK, GMTPLUS0200WINDHOEK, GMTPLUS0300BAGHDAD, GMTPLUS0300KUWAIT_RIYADH, GMTPLUS0300MOSCOW_STPETERSBURG_VOLGOGRAD, GMTPLUS0300NAIROBI, GMTPLUS0300TBILISI, GMTPLUS0330TEHRAN, GMTPLUS0400ABUDHABI_MUSCAT, GMTPLUS0400BAKU, GMTPLUS0400CAUCASUSSTANDARDTIME, GMTPLUS0400IZHEVSK_SAMARA, GMTPLUS0400PORTLOUIS, GMTPLUS0400YEREVAN, GMTPLUS0430KABUL, GMTPLUS0500EKATERINBURG, GMTPLUS0500ISLAMABAD_KARACHI, GMTPLUS0500ISLAMABAD_KARACHI_TASHKENT, GMTPLUS0530CHENNAI_KOLKATA_MUMBAI, GMTPLUS0530SRIJAYAWARDENEPURA, GMTPLUS0545KATHMANDU, GMTPLUS0600ALMATY_NOVOSIBIRSK, GMTPLUS0600ASTANA_DHAKA, GMTPLUS0600DHAKA, GMTPLUS0600MAGADAN, GMTPLUS0630_YANGON, GMTPLUS0700_BANGKOK_HANOI_JAKARTA, GMTPLUS0700KRASNOYARSK, GMTPLUS0800_ULAANBAATAR, GMTPLUS0800BEIJING_CHONGQING_HONGKONG, GMTPLUS0800IRKUTSK_ULAANBATAAR, GMTPLUS0800KUALALUMPUR_SINGAPORE, GMTPLUS0800PERTH, GMTPLUS0800TAIPEI, GMTPLUS0900OSAKA_SAPPORO_TOKYO, GMTPLUS0900SEOUL, GMTPLUS0900YAKUTSK, GMTPLUS0930ADELAIDE, GMTPLUS0930DARWIN, GMTPLUS1000BRISBANE, GMTPLUS1000CANBERRA_MELBOURNE_SYDNEY, GMTPLUS1000GUAM_PORTMORESBY, GMTPLUS1000HOBART, GMTPLUS1000VLADIVOSTOK, GMTPLUS1100CHOKURDAKH, GMTPLUS1100MAGADAN_SOLOMONIS, GMTPLUS1200ANADYR_PETRO_KAMCHATSKY, GMTPLUS1200AUCKLAND_WELLINGTON, GMTPLUS1200COORDINATEDUNIVERSALTIME, GMTPLUS1200FIJI_KAMCHATKA_MARSHALLIS, GMTPLUS1300NUKU_ALOFAOriginalStartData: DateTimeSearchableOriginalStartTimeZonePicklist: TimezoneValues: GMT_CASABLANCA, GMT_CASABLANCA_MONTROVIA_REYKJAVIK, GMT_COORDINATEDUNIVERSALTIME, GMT_DUBLIN_EDINBURGH_LISBON_LONDON, GMT_PLUS0300KALININGRAD_MINSK, GMTMINUS0100AZORES, GMTMINUS0100CAPEVERDIS, GMTMINUS0200MIDATLANTIC, GMTMINUS0300_SALVADOR, GMTMINUS0300BRASILIA, GMTMINUS0300BUENOSAIRES, GMTMINUS0300BUENOSAIRES_GEORGETOWN, GMTMINUS0300GREENLAND, GMTMINUS0300MONTEVIDEO, GMTMINUS0330NEWFOUNDLAND, GMTMINUS0400ASUNCION, GMTMINUS0400ATLANTICTIME, GMTMINUS0400LAPAZ, GMTMINUS0400MANAUS, GMTMINUS0400SANTIAGO, GMTMINUS0430CARACAS, GMTMINUS0500BOGOTA_LIMA_QUITO_RIOBRANCO, GMTMINUS0500EASTERNTIME, GMTMINUS0500INDIANA, GMTMINUS0600CENTRALAMERICA, GMTMINUS0600CENTRALTIME, GMTMINUS0600GUADALAJARA_MEXICOCITY, GMTMINUS0600SASKATCHEWAN, GMTMINUS0700ARIZONA, GMTMINUS0700CHIHUAHUA_LAPAZ_MAZATLAN, GMTMINUS0700MOUNTAINTIME, GMTMINUS0800PACIFICTIME, GMTMINUS0800TIJUANA_BAJACALIFORNIA, GMTMINUS0900ALASKA, GMTMINUS1000HAWAII, GMTMINUS1100COORDINATEDUNIVERSALTIME, GMTMINUS1100MIDWAYISLAND_SAMOA, GMTMINUS1200INTERNATIONALDATELINEWEST, GMTPLUS0100_AMSTERDAM_BERLIN_BERN_ROME, GMTPLUS0100BELGRADE_BRATISLAVA_BUDAPEST, GMTPLUS0100BRUSSELS_COPENHAGEN_MADRID, GMTPLUS0100SARAJEVO_SKOPJE_WARSAW_ZAGREB, GMTPLUS0100TRIPOLI, GMTPLUS0100WESTCENTRALAFRICA, GMTPLUS0200_DAMASCUS, GMTPLUS0200AMMAN, GMTPLUS0200ATHENS_BUCHAREST_ISTANBUL, GMTPLUS0200BEIRUT, GMTPLUS0200CAIRO, GMTPLUS0200HARARE_PRETORIA, GMTPLUS0200HELSINKI_KYIV_RIGA_VILNIUS, GMTPLUS0200ISTANBUL, GMTPLUS0200JERUSALEM, GMTPLUS0200MINSK, GMTPLUS0200WINDHOEK, GMTPLUS0300BAGHDAD, GMTPLUS0300KUWAIT_RIYADH, GMTPLUS0300MOSCOW_STPETERSBURG_VOLGOGRAD, GMTPLUS0300NAIROBI, GMTPLUS0300TBILISI, GMTPLUS0330TEHRAN, GMTPLUS0400ABUDHABI_MUSCAT, GMTPLUS0400BAKU, GMTPLUS0400CAUCASUSSTANDARDTIME, GMTPLUS0400IZHEVSK_SAMARA, GMTPLUS0400PORTLOUIS, GMTPLUS0400YEREVAN, GMTPLUS0430KABUL, GMTPLUS0500EKATERINBURG, GMTPLUS0500ISLAMABAD_KARACHI, GMTPLUS0500ISLAMABAD_KARACHI_TASHKENT, GMTPLUS0530CHENNAI_KOLKATA_MUMBAI, GMTPLUS0530SRIJAYAWARDENEPURA, GMTPLUS0545KATHMANDU, GMTPLUS0600ALMATY_NOVOSIBIRSK, GMTPLUS0600ASTANA_DHAKA, GMTPLUS0600DHAKA, GMTPLUS0600MAGADAN, GMTPLUS0630_YANGON, GMTPLUS0700_BANGKOK_HANOI_JAKARTA, GMTPLUS0700KRASNOYARSK, GMTPLUS0800_ULAANBAATAR, GMTPLUS0800BEIJING_CHONGQING_HONGKONG, GMTPLUS0800IRKUTSK_ULAANBATAAR, GMTPLUS0800KUALALUMPUR_SINGAPORE, GMTPLUS0800PERTH, GMTPLUS0800TAIPEI, GMTPLUS0900OSAKA_SAPPORO_TOKYO, GMTPLUS0900SEOUL, GMTPLUS0900YAKUTSK, GMTPLUS0930ADELAIDE, GMTPLUS0930DARWIN, GMTPLUS1000BRISBANE, GMTPLUS1000CANBERRA_MELBOURNE_SYDNEY, GMTPLUS1000GUAM_PORTMORESBY, GMTPLUS1000HOBART, GMTPLUS1000VLADIVOSTOK, GMTPLUS1100CHOKURDAKH, GMTPLUS1100MAGADAN_SOLOMONIS, GMTPLUS1200ANADYR_PETRO_KAMCHATSKY, GMTPLUS1200AUCKLAND_WELLINGTON, GMTPLUS1200COORDINATEDUNIVERSALTIME, GMTPLUS1200FIJI_KAMCHATKA_MARSHALLIS, GMTPLUS1300NUKU_ALOFAReminderMinutesBeforeStartData: IntegerResponseRequestedData: BooleanResponseStatus_ResponsePicklist: EventResponseValues: Accepted, Declined, None, NotResponded, Organizer, TentativelyAcceptedDescription: ResponseResponseStatus_TimeData: DateTimeDescription: Response timeSensitivityPicklist: EventSensitivityValues: Confidential, Normal, Personal, PrivateShowAsPicklist: EventTimeStatusValues: Busy, Free, OutofOffice, Tentative, Unknown, WorkingelsewhereSourceCreatedDateTimeData: DateTimeSearchableSourceLastModifiedDateTimeData: DateTimeStartData: DateTimeSubjectData: TextMaximum length: 2048TypePicklist: EventTypeValues: Exception, Occurrence, SeriesMaster, SingleInstanceWebLinkData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupStartEndSubjectLocation_DisplayNameDefaultCreateDefaultCreate field groupIdStartEndSubjectImportanceLocation_DisplayNameBody_ContentDefaultDetailsDefaultDetails field groupStartEndSubjectShowAsImportanceBodyPreviewLocation_DisplayNameDefaultIdentificationDefaultIdentification field groupIdSubjectDefaultListDefaultList field groupStartEndSubjectLocation_DisplayNameDefaultLookupDefaultLookup field groupStartSubjectDefaultReportDefaultReport field groupStartEndSubjectLocation_DisplayNameMessage (Message) EntityA message (email) within a user’s mailbox or related to data within the Common Data Service. This entity is connected to Microsoft Graph to retrieve mail box messages.FieldDescriptionBccRecipientsData: TextMaximum length: 2048Body_ContentData: MemoDescription: Body contentBody_ContentTypePicklist: BodyContentTypeValues: HTML, TextDescription: Body content typeBodyPreviewData: TextMaximum length: 2048CategoriesData: TextMaximum length: 2048CCRecipientsData: TextMaximum length: 2048ChangeKeyData: TextMaximum length: 2048ConversationIdData: TextMaximum length: 2048FromData: TextMaximum length: 2048HasAttachmentsData: BooleanIdPrimary keyData: TextRequired, Unique, Searchable, Maximum length: 2048Description: Message IDImportancePicklist: MessageImportanceValues: High, Low, NormalInferenceClassificationPicklist: MessageInferenceClassificationValues: Focused, OtherInternetMessageIdData: TextMaximum length: 2048IsDeliveryReceiptRequestedData: BooleanDescription: Delivery receipt requestedIsDraftData: BooleanDescription: DraftIsReadData: BooleanDescription: ReadIsReadReceiptRequestedData: BooleanDescription: Read receipt requestedParentFolderIdData: TextMaximum length: 2048ReceivedDateTimeData: DateTimeReplyToData: TextMaximum length: 2048SenderData: TextMaximum length: 2048SentDateTimeData: DateTimeSearchableSourceCreatedDateTimeData: DateTimeSearchableSourceLastModifiedDateTimeData: DateTimeSubjectData: TextSearchable, Maximum length: 2048ToRecipientsData: TextMaximum length: 2048Description: To receipientsUniqueBody_ContentData: MemoDescription: Unique body contentUniqueBody_ContentTypePicklist: BodyContentTypeValues: HTML, TextDescription: Unique body content typeWebLinkData: TextMaximum length: 255RelationshipsThis entity has no relationships.Field groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupFromToRecipientsSubjectSentDateTimeDefaultCreateDefaultCreate field groupIdFromToRecipientsCCRecipientsSubjectSentDateTimeImportanceBody_ContentDefaultDetailsDefaultDetails field groupFromToRecipientsCCRecipientsSubjectSentDateTimeImportanceBodyPreviewDefaultIdentificationDefaultIdentification field groupIdSubjectDefaultListDefaultList field groupFromToRecipientsSubjectSentDateTimeDefaultLookupDefaultLookup field groupSubjectSentDateTimeDefaultReportDefaultReport field groupFromToRecipientsSubjectSentDateTimePurchasing entitiesThe purchasing entities let you create purchasing solutions and track vendor invoices.Purchase order ERDVendor invoice ERDPurchasing referencePurchaseOrder (Purchase order) EntityAn offer for a commercial engagement issued by the company to a vendor to make a purchase.FieldDescriptionBillingAddressData: AddressBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyDecimal places: 6ExpectedShipDateData: DateTimeFreightTermsPicklist: FreightTermsValues: FOB, NoChargeOrderDateData: DateTimeRequiredOrganizationLookup: OrganizationPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30PurchaseOrderIdPrimary keyNumber sequence:?Unique, SearchableDescription: Order IDRequestedDeliveryDateData: DateTimeShippingAddressData: AddressShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSStatusPicklist: PurchaseOrderStatusValues: Blocked, Closed, Confirmed, Invoiced, Open, Received, SuspendedRequiredDescription: Order statusTotalAmountData: CurrencyDecimal places: 6TotalChargeAmountData: CurrencyDecimal places: 6TotalDiscountAmountData: CurrencyDecimal places: 6TotalTaxAmountData: CurrencyDecimal places: 6VendorLookup: VendorRequiredVendorContactLookup: ContactVendorInvoiceData: TextMaximum length: 128WorkerBuyerLookup: WorkerDescription: Purchase personRelationshipsRelated entityDescriptionCardinalityTypeVendorVendorOneToManyAssociationWorkerPurchase personOneToManyAssociationContactVendor contactOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorOrderDateDescriptionWorkerBuyerVendorContactFreightTermsShippingMethodShippingAddressVendorInvoiceBillingAddressStatusDefaultListDefaultList field groupPurchaseOrderIdVendorOrderDateStatusWorkerBuyerTotalAmountDefaultCardDefaultCard field groupPurchaseOrderIdVendorOrderDateWorkerBuyerDefaultDetailsDefaultDetails field groupPurchaseOrderIdVendorOrderDateDescriptionStatusWorkerBuyerVendorContactTotalAmountFreightTermsShippingMethodShippingAddressVendorInvoiceBillingAddressTotalChargeAmountTotalDiscountAmountTotalTaxAmountDefaultLookupDefaultLookup field groupPurchaseOrderIdVendorOrderDateDescriptionDefaultReportDefaultReport field groupPurchaseOrderIdVendorOrderDateDescriptionWorkerBuyerVendorContactTotalAmountFreightTermsShippingMethodVendorInvoiceDefaultIdentificationDefaultIdentification field groupPurchaseOrderIdDescriptionPurchaseOrderCharge (Purchase order charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the whole purchase order.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: ChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge namePurchaseOrderPrimary keyLookup: PurchaseOrderRequiredRelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderPurchase orderOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPurchaseOrderChargeTypeNameDescriptionAmountDefaultListDefaultList field groupPurchaseOrderChargeTypeNameAmountDefaultCardDefaultCard field groupPurchaseOrderChargeTypeNameAmountDefaultDetailsDefaultDetails field groupPurchaseOrderChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupPurchaseOrderChargeTypeNameAmountDefaultReportDefaultReport field groupPurchaseOrderChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupPurchaseOrderChargeTypePurchaseOrderLine (Purchase order line) EntityA component of a purchase order that contains a portion of the total amount including information such as product, quantity, and price.FieldDescriptionBusinessUnitLookup: BusinessUnitDeliveryPostalAddressData: AddressDescription: Delivery addressDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6ExpectedShipDateData: DateTimeLineAmountData: CurrencyRequired, Decimal places: 6MostRecentActualReceiptDateData: DateTimeDescription: Most recent actual ship dateNameData: TextMaximum length: 60ProductLookup: ProductProductNameData: TextRequired, Maximum length: 60PromisedShipDateData: DateTimePurchaseOrderPrimary keyLookup: PurchaseOrderRequiredQuantityData: QuantityRequiredRequestedDeliveryDateData: DateTimeSequenceData: IntegerRequiredStatusPicklist: PurchaseOrderLineStatusValues: Blocked, Closed, Confirmed, Invoiced, Open, Received, SuspendedRequiredDescription: Order line statusTotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalTaxAmountData: CurrencyDecimal places: 6UnitPriceData: CurrencyRequired, Decimal places: 6VendorProductNameData: TextMaximum length: 60RelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderPurchase orderOneToManyCompositionProductProductOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPurchaseOrderSequenceProductDescriptionQuantityStatusUnitPriceLineAmountProductNameDefaultListDefaultList field groupPurchaseOrderSequenceProductProductNameStatusQuantityLineAmountDefaultCardDefaultCard field groupPurchaseOrderSequenceProductProductNameStatusQuantityDefaultDetailsDefaultDetails field groupPurchaseOrderSequenceProductProductNameDescriptionStatusQuantityUnitPriceLineAmountPromisedShipDateMostRecentActualReceiptDateDeliveryPostalAddressTotalChargeAmountTotalTaxAmountDefaultLookupDefaultLookup field groupPurchaseOrderSequenceProductNameStatusQuantityDefaultReportDefaultReport field groupPurchaseOrderSequenceProductProductNameStatusQuantityUnitPriceLineAmountPromisedShipDateMostRecentActualReceiptDateDefaultIdentificationDefaultIdentification field groupPurchaseOrderSequenceProductNamePurchaseOrderLineCharge (Purchase order line charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the purchase order line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: LineChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge namePurchaseOrderLinePrimary keyLookup: PurchaseOrderLineRequiredRelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderLinePurchase order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPurchaseOrderLineChargeTypeNameDescriptionAmountDefaultListDefaultList field groupPurchaseOrderLineChargeTypeNameAmountDefaultCardDefaultCard field groupPurchaseOrderLineChargeTypeNameAmountDefaultDetailsDefaultDetails field groupPurchaseOrderLineChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupPurchaseOrderLineChargeTypeNameAmountDefaultReportDefaultReport field groupPurchaseOrderLineChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupPurchaseOrderLineChargeTypePurchaseOrderLineReceipt (Purchase order line receipt) EntityThe receipt of product on the line of a purchase order for part or all of the line quantity.FieldDescriptionActualReceiptDateData: DateRequiredBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60PurchaseOrderLinePrimary keyLookup: PurchaseOrderLineRequiredQuantityData: QuantityRequiredSequenceData: IntegerRequiredStatusPicklist: ShipmentStatusValues: Delivered, OpenRequiredRelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderLinePurchase order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPurchaseOrderLineDescriptionQuantityStatusActualReceiptDateSequenceDefaultListDefaultList field groupDescriptionQuantityStatusActualReceiptDateDefaultCardDefaultCard field groupPurchaseOrderLineQuantityStatusActualReceiptDateDefaultDetailsDefaultDetails field groupPurchaseOrderLineDescriptionQuantityStatusActualReceiptDateSequenceDefaultLookupDefaultLookup field groupPurchaseOrderLineDescriptionQuantityStatusActualReceiptDateDefaultReportDefaultReport field groupPurchaseOrderLineDescriptionQuantityStatusActualReceiptDateSequenceDefaultIdentificationDefaultIdentification field groupPurchaseOrderLineDescriptionPurchaseOrderLineTax (Purchase order line tax) EntityTax incurred on a purchase order line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax namePurchaseOrderLinePrimary keyLookup: PurchaseOrderLineRequiredRateCodeData: TextMaximum length: 60TaxTypePicklist: LineTaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderLinePurchase order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameRateCodeTaxTypeAmountDescriptionPurchaseOrderLineDefaultListDefaultList field groupNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupNameTaxTypeAmountDefaultDetailsDefaultDetails field groupNameRateCodeTaxTypeAmountDescriptionPurchaseOrderLineDefaultLookupDefaultLookup field groupNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupNameRateCodeTaxTypeAmountDescriptionPurchaseOrderLineDefaultIdentificationDefaultIdentification field groupPurchaseOrderLineNamePurchaseOrderTax (Purchase order tax) EntityTax incurred on a purchase order as a whole.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax namePurchaseOrderPrimary keyLookup: PurchaseOrderRequiredRateCodeData: TextMaximum length: 60TaxTypePicklist: TaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypePurchaseOrderPurchase orderOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPurchaseOrderNameRateCodeTaxTypeAmountDescriptionDefaultListDefaultList field groupPurchaseOrderNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupPurchaseOrderNameTaxTypeAmountDefaultDetailsDefaultDetails field groupPurchaseOrderNameRateCodeTaxTypeAmountDescriptionDefaultLookupDefaultLookup field groupPurchaseOrderNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupPurchaseOrderNameRateCodeTaxTypeAmountDescriptionDefaultIdentificationDefaultIdentification field groupPurchaseOrderNameVendor (Vendor) EntityAn organization that has sold products to the customer at least once.FieldDescriptionBirthdateData: DateBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 128DUNSNumberData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedIndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleIsDisabledOwnedData: BooleanDescription: Disabled ownedIsEmailContactAllowedData: BooleanRequiredIsMinorityOwnedData: BooleanDescription: Minority ownedIsNativeAmOwnedData: BooleanDescription: Native American ownedIsPhoneContactAllowedData: BooleanRequiredIsWomanOwnedData: BooleanDescription: Woman ownedLinkedInIdentityData: TextMaximum length: 128MailingPostalAddressData: AddressOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressParentVendorLookup: VendorPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPersonNameData: PersonNameDescription: Given namePhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhonePrimaryContactLookup: ContactSatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: VendorStatusValues: Active, Blocked, InactiveRequiredStockExchangePicklist: StockExchangeValues: BMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeStockTickerData: TextMaximum length: 128SupplierApprovalStatusPicklist: SupplierApprovalStatusValues: Approved, NotApproved, UnderReviewRequiredTaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128VendorIdPrimary keyNumber sequence:?Unique, SearchableDescription: Type an ID number or code for the account to quickly search and identify the account in system views.WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeVendorParent vendorOneToManyAssociationContactPrimary contactOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPersonNameStatusParentVendorDescriptionEmailPrimaryWebsiteURLPhonePrimaryPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedSupplierApprovalStatusDefaultListDefaultList field groupVendorIdFullNameStatusPhonePrimaryWebsiteURLDefaultCardDefaultCard field groupVendorIdFullNameStatusDefaultDetailsDefaultDetails field groupVendorIdFullNamePersonNameStatusParentVendorDescriptionEmailPrimaryWebsiteURLPhonePrimaryMailingPostalAddressShippingPostalAddressDefaultLookupDefaultLookup field groupVendorIdFullNameStatusDefaultReportDefaultReport field groupVendorIdFullNamePersonNameStatusParentVendorDescriptionEmailPrimaryWebsiteURLPhonePrimaryDefaultIdentificationDefaultIdentification field groupVendorIdFullNameVendorContact (Vendor contact) EntityAssociates a vendor and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128VendorPrimary keyLookup: VendorRequiredRelationshipsRelated entityDescriptionCardinalityTypeVendorVendorOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultIdentificationDefaultIdentification field groupVendorContactDefaultCreateDefaultCreate field groupVendorContactDataSourceDescriptionDefaultListDefaultList field groupVendorContactDataSourceDescriptionDefaultCardDefaultCard field groupVendorContactDataSourceDescriptionDefaultDetailsDefaultDetails field groupVendorContactDataSourceDescriptionDefaultLookupDefaultLookup field groupVendorContactDataSourceDescriptionDefaultReportDefaultReport field groupVendorContactDataSourceDescriptionVendorInvoice (Vendor invoice) EntityAn invoice received from a vendor that documents the liability for a purchase.FieldDescriptionBillingAddressData: AddressBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyDecimal places: 6FreightTermsPicklist: FreightTermsValues: FOB, NoChargeOrganizationLookup: OrganizationPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30PurchaseOrderLookup: PurchaseOrderShippingAddressData: AddressShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSStatusPicklist: InvoiceStatusValues: Cancelled, Created, Hold, PaidRequiredDescription: Invoice statusTotalAmountData: CurrencyDecimal places: 6TotalChargeAmountData: CurrencyDecimal places: 6TotalDiscountAmountData: CurrencyDecimal places: 6TotalTaxAmountData: CurrencyDecimal places: 6VendorLookup: VendorRequiredVendorContactLookup: ContactVendorInvoiceDateData: DateTimeRequired, SearchableDescription: Invoice dateVendorInvoiceIdPrimary keyNumber sequence:?Unique, SearchableWorkerBuyerLookup: WorkerDescription: Purchase personRelationshipsRelated entityDescriptionCardinalityTypeVendorVendorOneToManyAssociationWorkerPurchase personOneToManyAssociationContactVendor contactOneToManyAssociationPurchaseOrderPurchase orderOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorInvoiceDateDescriptionVendorVendorContactStatusBillingAddressDefaultListDefaultList field groupVendorInvoiceIdVendorInvoiceDateDescriptionVendorStatusTotalAmountDefaultCardDefaultCard field groupVendorInvoiceIdVendorInvoiceDateDescriptionVendorStatusTotalAmountDefaultDetailsDefaultDetails field groupVendorInvoiceIdVendorInvoiceDateDescriptionVendorVendorContactStatusTotalAmountFreightTermsPaymentTermsWorkerBuyerShippingMethodTotalChargeAmountTotalDiscountAmountTotalTaxAmountBillingAddressDefaultLookupDefaultLookup field groupVendorInvoiceIdVendorInvoiceDateVendorDefaultReportDefaultReport field groupVendorInvoiceDateVendorInvoiceIdDescriptionVendorVendorContactStatusTotalAmountFreightTermsPaymentTermsWorkerBuyerShippingMethodTotalChargeAmountTotalDiscountAmountTotalTaxAmountBillingAddressDefaultIdentificationDefaultIdentification field groupVendorInvoiceIdVendorInvoiceCharge (Vendor invoice charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the whole invoice.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: InvoiceChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameVendorInvoicePrimary keyLookup: VendorInvoiceRequiredRelationshipsRelated entityDescriptionCardinalityTypeVendorInvoiceVendor invoiceOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorInvoiceChargeTypeNameDescriptionAmountDefaultListDefaultList field groupVendorInvoiceChargeTypeNameAmountDefaultCardDefaultCard field groupVendorInvoiceChargeTypeNameAmountDefaultDetailsDefaultDetails field groupVendorInvoiceChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupVendorInvoiceChargeTypeNameAmountDefaultReportDefaultReport field groupVendorInvoiceChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupVendorInvoiceNameVendorInvoiceLine (Vendor invoice line) EntityA component of a vendor invoice that contains a portion of the invoiced amount including information such as product, quantity, and price.FieldDescriptionBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6LineAmountData: CurrencyRequired, Decimal places: 6NameData: TextRequired, Maximum length: 60ProductLookup: ProductProductNameData: TextRequired, Maximum length: 60PurchaseOrderLineLookup: PurchaseOrderLineQuantityData: QuantityRequiredSequenceData: IntegerRequiredStatusPicklist: OrderLineStatusValues: Active, Confirmed, Invoice, PackingSlip, QuoteRequiredDescription: Invoice line statusTotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalTaxAmountData: CurrencyRequired, Decimal places: 6UnitPriceData: CurrencyRequired, Decimal places: 6VendorInvoicePrimary keyLookup: VendorInvoiceRequiredVendorProductNameData: TextMaximum length: 60RelationshipsRelated entityDescriptionCardinalityTypeProductProductOneToManyAssociationVendorInvoiceVendor invoiceOneToManyCompositionPurchaseOrderLinePurchase order lineOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorInvoiceProductNameDescriptionStatusQuantitySequenceProductNameUnitPriceDefaultListDefaultList field groupVendorInvoiceProductNameStatusQuantityLineAmountDefaultCardDefaultCard field groupVendorInvoiceProductStatusQuantityLineAmountDefaultDetailsDefaultDetails field groupVendorInvoiceProductNameDescriptionStatusQuantityLineAmountDiscountAmountTotalChargeAmountTotalTaxAmountDefaultLookupDefaultLookup field groupVendorInvoiceProductStatusQuantityLineAmountDefaultReportDefaultReport field groupVendorInvoiceProductNameDescriptionStatusQuantityLineAmountDiscountAmountTotalChargeAmountTotalTaxAmountDefaultIdentificationDefaultIdentification field groupVendorInvoiceProductVendorInvoiceLineCharge (Vendor Invoice Line Charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the invoice line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6Description: Total line chargesBusinessUnitLookup: BusinessUnitChargeTypePicklist: InvoiceLineChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameVendorInvoiceLinePrimary keyLookup: VendorInvoiceLineRequiredRelationshipsRelated entityDescriptionCardinalityTypeVendorInvoiceLineVendor invoice lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorInvoiceLineChargeTypeNameDescriptionAmountDefaultListDefaultList field groupVendorInvoiceLineChargeTypeNameAmountDefaultCardDefaultCard field groupVendorInvoiceLineChargeTypeNameAmountDefaultDetailsDefaultDetails field groupVendorInvoiceLineChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupVendorInvoiceLineChargeTypeAmountDefaultReportDefaultReport field groupVendorInvoiceLineChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupVendorInvoiceLineNameVendorInvoiceLineTax (Vendor invoice line tax) EntityTax charged on a vendor invoice line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60TaxTypePicklist: InvoiceLineTaxTypeValues: Others, SalesTax, VATRequiredVendorInvoiceLinePrimary keyLookup: VendorInvoiceLineRequiredRelationshipsRelated entityDescriptionCardinalityTypeVendorInvoiceLineVendor invoice lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameRateCodeTaxTypeAmountVendorInvoiceLineDefaultListDefaultList field groupNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupNameTaxTypeAmountDefaultDetailsDefaultDetails field groupVendorInvoiceLineNameRateCodeTaxTypeAmountDescriptionDefaultLookupDefaultLookup field groupNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupVendorInvoiceLineNameRateCodeTaxTypeAmountDescriptionDefaultIdentificationDefaultIdentification field groupVendorInvoiceLineNameVendorInvoiceTax (Vendor invoice tax) EntityTax charged on a vendor invoice as a whole.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60TaxTypePicklist: InvoiceTaxTypeValues: Others, SalesTax, VATRequiredVendorInvoicePrimary keyLookup: VendorInvoiceRequiredRelationshipsRelated entityDescriptionCardinalityTypeVendorInvoiceVendor invoiceOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupVendorInvoiceRateCodeTaxTypeNameAmountDescriptionDefaultListDefaultList field groupVendorInvoiceRateCodeTaxTypeAmountDefaultCardDefaultCard field groupVendorInvoiceTaxTypeAmountDefaultDetailsDefaultDetails field groupVendorInvoiceRateCodeTaxTypeNameAmountDescriptionDefaultLookupDefaultLookup field groupVendorInvoiceRateCodeAmountDefaultReportDefaultReport field groupVendorInvoiceRateCodeTaxTypeNameAmountDefaultIdentificationDefaultIdentification field groupVendorInvoiceRateCodeSales entitiesThe sales entities let you create end-to-end sales solutions, from tracking leads and opportunities, to following through with contacts, to accepting and delivering orders, to sending invoices.Sales invoice ERDSales order ERDThe sales order is modeled with a header, lines, and deliveries. The delivery enables a single line item to be broken up into shipments to different locations. For example, out of 100 items of a specific product, 60 items are shipped to one location, and 40 items are shipped to another location.Quotation ERDCompetitor ERDLead ERDSales referenceAccount (Account) EntityA person or organization that buys offered goods or services.FieldDescriptionAccountGroupLookup: AccountGroupAccountIdPrimary keyNumber sequence:?Unique, SearchableBirthdateData: DateBusinessUnitLookup: BusinessUnitCreditLimitAmountData: CurrencyDecimal places: 6DescriptionData: TextMaximum length: 128DUNSNumberData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableEmployeeCountData: IntegerFacebookIdentityData: TextMaximum length: 128FreightTermsPicklist: FreightTermsValues: FOB, NoChargeFullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedIndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128MailingPostalAddressData: AddressMaritalStatusPicklist: MaritalStatusValues: Divorced, Married, None, Single, WidowedOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressParentAccountLookup: AccountPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30PersonInformationData: TextMaximum length: 2048PersonNameData: PersonNameDescription: Given namePhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhoneFaxData: PhonePhonePrimaryData: PhonePrimaryContactLookup: ContactSalesCurrencyCodePicklist: CurrencyCodeValues: AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRL, BSD, BTN, BWP, BYN, BYR, BZD, CAD, CDF, CHE, CHF, CHW, CLF, CLP, CNY, COP, COU, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MXV, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLL, SOS, SRD, SSP, STD, SVC, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, USN, UYI, UYU, UZS, VEF, VND, VUV, WST, XAF, XAG, XAU, XBA, XBB, XBC, XBD, XCD, XDR, XOF, XPD, XPF, XPT, XSU, XTS, XUA, XXX, YER, ZAR, ZMW, ZWLSatoriIdData: TextMaximum length: 128ShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: AccountStatusValues: Active, InactiveRequiredStockExchangePicklist: StockExchangeValues: BMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeStockTickerData: TextMaximum length: 128TaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeContactPrimary contactOneToManyAssociationAccountParent accountOneToManyAssociationAccountGroupAccount groupOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupFullNamePersonNameStatusParentAccountDescriptionEmailPrimaryWebsiteURLPhonePrimaryPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedDefaultListDefaultList field groupAccountIdFullNameStatusPhonePrimaryWebsiteURLDefaultCardDefaultCard field groupAccountIdFullNameStatusDefaultDetailsDefaultDetails field groupAccountIdFullNamePersonNameStatusParentAccountDescriptionEmailPrimaryWebsiteURLPhonePrimaryMailingPostalAddressShippingPostalAddressDefaultLookupDefaultLookup field groupAccountIdFullNameStatusDefaultReportDefaultReport field groupAccountIdFullNamePersonNameStatusParentAccountDescriptionEmailPrimaryWebsiteURLPhonePrimaryDefaultIdentificationDefaultIdentification field groupAccountIdFullNameAccountContact (Account contact) EntityAssociates an account and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionAccountPrimary keyLookup: AccountRequiredContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128RelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupAccountContactDataSourceDescriptionDefaultListDefaultList field groupAccountContactDataSourceDescriptionDefaultCardDefaultCard field groupAccountContactDataSourceDescriptionDefaultDetailsDefaultDetails field groupAccountContactDataSourceDescriptionDefaultLookupDefaultLookup field groupAccountContactDataSourceDescriptionDefaultReportDefaultReport field groupAccountContactDataSourceDescriptionDefaultIdentificationDefaultIdentification field groupAccountContactAccountGroup (Account group) EntityA collection of accounts.FieldDescriptionAccountGroupIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 128NameData: TextRequired, Searchable, Maximum length: 128OrganizationLookup: OrganizationRelationshipsRelated entityDescriptionCardinalityTypeOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupAccountGroupIdNameDescriptionDefaultListDefaultList field groupAccountGroupIdNameDefaultCardDefaultCard field groupAccountGroupIdNameDefaultDetailsDefaultDetails field groupAccountGroupIdNameDescriptionDefaultLookupDefaultLookup field groupAccountGroupIdNameDefaultReportDefaultReport field groupAccountGroupIdNameDefaultIdentificationDefaultIdentification field groupAccountGroupIdNameAccountLead (Account lead) EntityAssociates a account and a lead. This entity creates a many-to-many relationship between the two entities.FieldDescriptionAccountPrimary keyLookup: AccountRequiredLeadLookup: LeadRequiredRelationshipsRelated entityDescriptionCardinalityTypeLeadLeadOneToManyAssociationAccountAccountOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupAccountLeadDefaultCreateDefaultCreate field groupAccountLeadDefaultDetailsDefaultDetails field groupAccountLeadDefaultIdentificationDefaultIdentification field groupAccountLeadDefaultListDefaultList field groupAccountLeadDefaultLookupDefaultLookup field groupAccountLeadDefaultReportDefaultReport field groupAccountLeadAccountOtherPostalAddress (Account other postal address) EntityA postal address that is associated with an account. It is separate from the shipping address and the mailing address.FieldDescriptionAccountLookup: AccountRequiredAddressIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 128OtherPostalAddressData: AddressRelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupAccountDescriptionOtherPostalAddressDefaultListDefaultList field groupAccountDescriptionOtherPostalAddressDefaultCardDefaultCard field groupAccountDescriptionOtherPostalAddressDefaultDetailsDefaultDetails field groupAccountDescriptionOtherPostalAddressDefaultLookupDefaultLookup field groupAccountDescriptionOtherPostalAddressDefaultReportDefaultReport field groupAccountDescriptionOtherPostalAddressDefaultIdentificationDefaultIdentification field groupAddressIdAccountCompetitor (Competitor) EntityBusiness competing for the sale represented by a lead or opportunity.FieldDescriptionCompetitorIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 2048DUNSNumberData: TextMaximum length: 2048EmailAlternateData: TextMaximum length: 80EmailPrimaryData: TextMaximum length: 80FacebookIdentityData: TextMaximum length: 2048FullNameData: TextMaximum length: 2048IndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleKeyProductNameData: TextMaximum length: 2048LinkedInIdentityData: TextMaximum length: 2048MailingPostalAddressData: AddressOpportunityDescriptionData: MemoOrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 2048OtherPostalAddressData: AddressOverviewDescriptionData: MemoPartyTypePicklist: PartyTypeValues: Group, Organization, PersonPersonNameData: PersonNameDescription: Given namePhone01Data: TextMaximum length: 32Phone02Data: TextMaximum length: 32Phone03Data: TextMaximum length: 32PrimaryContactLookup: ContactReferenceInfoURLData: TextMaximum length: 2048ReportedAnnualRevenueData: CurrencyDecimal places: 6ReportingQuarterData: IntegerReportingYearData: IntegerShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 2048SocialNetworkIdentity02Data: TextMaximum length: 2048SourcePicklist: SourceValues: DefaultStatusPicklist: CompetitorStatusValues: Active, InactiveStockExchangeData: TextMaximum length: 2048StockTickerData: TextMaximum length: 2048StrengthDescriptionData: MemoThreatDescriptionData: MemoTransactionCurrencyPicklist: CurrencyCodeValues: AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRL, BSD, BTN, BWP, BYN, BYR, BZD, CAD, CDF, CHE, CHF, CHW, CLF, CLP, CNY, COP, COU, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MXV, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLL, SOS, SRD, SSP, STD, SVC, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, USN, UYI, UYU, UZS, VEF, VND, VUV, WST, XAF, XAG, XAU, XBA, XBB, XBC, XBD, XCD, XDR, XOF, XPD, XPF, XPT, XSU, XTS, XUA, XXX, YER, ZAR, ZMW, ZWLTwitterIdentityData: TextMaximum length: 2048WeaknessesData: MemoDescription: WeaknessWebsiteURLData: TextMaximum length: 2048WinPercentageData: IntegerRelationshipsRelated entityDescriptionCardinalityTypeContactPrimary contactOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupCompetitorIdOrganizationNameDefaultCreateDefaultCreate field groupCompetitorIdOrganizationNameStatusOverviewDescriptionDefaultDetailsDefaultDetails field groupCompetitorIdOrganizationNameStatusOverviewDescriptionDefaultIdentificationDefaultIdentification field groupCompetitorIdOrganizationNameDefaultListDefaultList field groupCompetitorIdOrganizationNameStatusDefaultLookupDefaultLookup field groupCompetitorIdOrganizationNameDefaultReportDefaultReport field groupCompetitorIdOrganizationNameStatusOverviewDescriptionCompetitorOtherPostalAddress (Competitor other postal address) EntityAdditional addresses for a competitor.FieldDescriptionAddressIdPrimary keyNumber sequence:?Unique, SearchableCompetitorLookup: CompetitorDescriptionData: TextMaximum length: 2048OtherPostalAddressData: AddressRelationshipsRelated entityDescriptionCardinalityTypeCompetitorCompetitorOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupAddressIdDescriptionDefaultCreateDefaultCreate field groupAddressIdDescriptionOtherPostalAddressCompetitorDefaultDetailsDefaultDetails field groupAddressIdDescriptionOtherPostalAddressCompetitorDefaultIdentificationDefaultIdentification field groupAddressIdDescriptionDefaultListDefaultList field groupAddressIdDescriptionCompetitorDefaultLookupDefaultLookup field groupAddressIdDescriptionDefaultReportDefaultReport field groupAddressIdDescriptionOtherPostalAddressCompetitorCompetitorProduct (Competitor product) EntityAssociation between a competitor and a product offered by the competitor.FieldDescriptionCompetitorPrimary keyLookup: CompetitorRequiredCompetitorProductIdData: TextMaximum length: 2048ProductLookup: ProductRequiredRelationshipsRelated entityDescriptionCardinalityTypeProductProductOneToManyAssociationCompetitorCompetitorOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupCompetitorProductDefaultCreateDefaultCreate field groupCompetitorProductDefaultDetailsDefaultDetails field groupCompetitorProductDefaultIdentificationDefaultIdentification field groupCompetitorProductDefaultListDefaultList field groupCompetitorProductDefaultLookupDefaultLookup field groupCompetitorProductDefaultReportDefaultReport field groupCompetitorProductContactLead (Contact lead) EntityAssociates a contract and a lead. This entity creates a many-to-many relationship between the two entities.FieldDescriptionContactPrimary keyLookup: ContactRequiredLeadLookup: LeadRequiredRelationshipsRelated entityDescriptionCardinalityTypeLeadLeadOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupContactLeadDefaultCreateDefaultCreate field groupContactLeadDefaultDetailsDefaultDetails field groupContactLeadDefaultIdentificationDefaultIdentification field groupContactLeadDefaultListDefaultList field groupContactLeadDefaultLookupDefaultLookup field groupContactLeadDefaultReportDefaultReport field groupContactLeadLead (Lead) EntityA person who is interested in receiving information about the products or services that the company offers.FieldDescriptionAccountLookup: AccountAnnualRevenueData: CurrencyDecimal places: 6BirthdateData: DateBudgetAmountData: CurrencyDecimal places: 6BudgetStatusPicklist: BudgetStatusValues: CanBuy, MayBuy, NoCommittedBudget, WillBuyBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 128DUNSNumberData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableEstimatedAmountData: CurrencyDecimal places: 6EstimatedCloseDateData: DateTimeFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128GenderPicklist: GenderValues: Female, Male, Nonspecific, NotSpecifiedGenerationData: TextMaximum length: 128IndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleIsDecisionMakerData: BooleanIsEmailContactAllowedData: BooleanRequiredIsInterestConfirmedData: BooleanDescription: Interest confirmedIsPhoneContactAllowedData: BooleanRequiredIsSecurityPrincipalData: BooleanRequiredLastCampaignDateData: DateTimeLeadIdPrimary keyNumber sequence:?Unique, SearchableLeadRatingPicklist: LeadRatingValues: Cold, Hot, WarmDescription: RatingLeadSourcePicklist: LeadSourceValues: Advertisement, EmployeeReferral, ExternalReferral, Other, Partner, PublicRelations, Seminar, TradeShow, Web, WordOfMouthLinkedInIdentityData: TextMaximum length: 128MailingPostalAddressData: AddressOfficeGraphIdentifierData: TextMaximum length: 200OrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressPartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPersonNameData: PersonNameDescription: Given namePhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhonePreferredContactMethodPicklist: ContactMethodValues: Any, Email, Fax, Mail, PhoneProfessionData: TextMaximum length: 128PurchaseTimelinePicklist: PurchaseTimeframeValues: Immediate, NextQuarter, ThisQuarter, ThisYear, UnknownQualificationDescriptionData: MemoQualifyingOpportunityLookup: OpportunitySatoriIdData: TextMaximum length: 128ScheduleFollowUpProspectData: DateTimeDescription: Schedule propsect follow upScheduleFollowUpQualifyData: DateTimeDescription: Schedule qualify follow upShippingPostalAddressData: AddressSICData: TextMaximum length: 2048Description: SIC codeSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: LeadStatusValues: Cancelled, Contacted, Disqualified, New, NoLongerInterested, QualifiedRequiredStockExchangePicklist: StockExchangeValues: BMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeStockTickerData: TextMaximum length: 128TaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypeBusinessUnitBusiness unitOneToManyAssociationOpportunityQualifying opportunityOneToManyAssociationAccountAccountOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPersonNameStatusWebsiteURLPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedIsSecurityPrincipalDefaultListDefaultList field groupLeadIdFullNameStatusWebsiteURLSourceDefaultCardDefaultCard field groupLeadIdFullNameStatusDefaultDetailsDefaultDetails field groupLeadIdFullNamePersonNameStatusWebsiteURLSourceDescriptionPhonePrimaryEmailPrimaryFacebookIdentityLinkedInIdentityTwitterIdentityDefaultLookupDefaultLookup field groupLeadIdFullNameStatusDefaultReportDefaultReport field groupLeadIdFullNamePersonNameStatusWebsiteURLSourcePhonePrimaryEmailPrimaryDefaultIdentificationDefaultIdentification field groupLeadIdFullNameLeadCompetitor (Lead competitor) EntityAssociates a lead and a competitor. This entity creates a many-to-many relationship between the two entities.FieldDescriptionCompetitorPrimary keyLookup: CompetitorRequiredLeadLookup: LeadRequiredRelationshipsRelated entityDescriptionCardinalityTypeLeadLeadOneToManyAssociationCompetitorCompetitorOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupCompetitorLeadDefaultCreateDefaultCreate field groupCompetitorLeadDefaultDetailsDefaultDetails field groupCompetitorLeadDefaultIdentificationDefaultIdentification field groupCompetitorLeadDefaultListDefaultList field groupCompetitorLeadDefaultLookupDefaultLookup field groupCompetitorLeadDefaultReportDefaultReport field groupCompetitorLeadLeadContact (Lead contact) EntityAssociates a lead and a contact. This entity creates a many-to-many relationship between the two entities.FieldDescriptionContactLookup: ContactRequiredDataSourcePicklist: SourceValues: DefaultRequiredDescription: SourceDescriptionData: TextMaximum length: 128LeadPrimary keyLookup: LeadRequiredRelationshipsRelated entityDescriptionCardinalityTypeLeadLeadOneToManyAssociationContactContactOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupLeadContactDataSourceDescriptionDefaultListDefaultList field groupLeadContactDataSourceDescriptionDefaultCardDefaultCard field groupLeadContactDataSourceDescriptionDefaultDetailsDefaultDetails field groupLeadContactDataSourceDescriptionDefaultLookupDefaultLookup field groupLeadContactDataSourceDescriptionDefaultReportDefaultReport field groupLeadContactDataSourceDescriptionDefaultIdentificationDefaultIdentification field groupLeadContactLeadOtherPostalAddress (Lead other postal address) EntityAdditional addresses for a lead.FieldDescriptionAddressIdPrimary keyNumber sequence:?Unique, SearchableDescriptionData: TextMaximum length: 2048LeadLookup: LeadOtherPostalAddressData: AddressRelationshipsRelated entityDescriptionCardinalityTypeLeadLeadOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupAddressIdDescriptionDefaultCreateDefaultCreate field groupAddressIdDescriptionOtherPostalAddressLeadDefaultDetailsDefaultDetails field groupAddressIdDescriptionOtherPostalAddressLeadDefaultIdentificationDefaultIdentification field groupAddressIdDescriptionDefaultListDefaultList field groupAddressIdDescriptionLeadDefaultLookupDefaultLookup field groupAddressIdDescriptionDefaultReportDefaultReport field groupAddressIdDescriptionOtherPostalAddressLeadLeadProduct (Lead product) EntityAssociates a lead and a product. This entity creates a many-to-many relationship between the two entities.FieldDescriptionLeadPrimary keyLookup: LeadRequiredProductLookup: ProductRequiredRelationshipsRelated entityDescriptionCardinalityTypeProductProductOneToManyAssociationLeadLeadOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupLeadProductDefaultCreateDefaultCreate field groupLeadProductDefaultDetailsDefaultDetails field groupLeadProductDefaultIdentificationDefaultIdentification field groupLeadProductDefaultListDefaultList field groupLeadProductDefaultLookupDefaultLookup field groupLeadProductDefaultReportDefaultReport field groupLeadProductOpportunity (Opportunity) EntityInformation about potential sales to new or established customers.FieldDescriptionActualCloseDateData: DateTimeActualValueAmountData: CurrencyRequired, Decimal places: 6BudgetAmountData: CurrencyDecimal places: 6BusinessUnitLookup: BusinessUnitCloseProbabilityData: IntegerCompetitorsIdentifiedData: BooleanContactLookup: ContactCreatedDateData: DateRequiredCurrentSituationDescriptionData: MemoCustomerContactsIdentifiedData: BooleanCustomerNeedDescriptionData: MemoCustomerPainPointsDescriptionData: MemoDescriptionData: TextMaximum length: 128DiscountAmountData: CurrencyDecimal places: 6DiscountPercentageData: IntegerEstimatedCloseDateData: DateTimeEstimatedValueAmountData: CurrencyRequired, Decimal places: 6FollowupProspectDateData: DateTimeFollowupQualifyDateData: DateTimeIndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleRequiredIsDecisionMakerData: BooleanNameData: TextRequired, Maximum length: 128NextFollowupDateData: DateDescription: Next follow-up dateOpportunityIdPrimary keyNumber sequence:?Unique, SearchableOrganizationLookup: OrganizationOriginalEstimatedValueAmountData: CurrencyRequired, Decimal places: 6OriginatingLeadLookup: LeadParentOpportunityLookup: OpportunityProposalMeetingDateData: DateTimeProposedSolutionDescriptionData: MemoPurchaseProcessPicklist: ProcessValues: Committee, Individual, UnknownRequiredPurchaseTimeFramePicklist: TimeFrameValues: Day, HalfYear, Hour, Month, Quarter, Trimester, Week, YearRequiredQualificationDescriptionData: MemoRatingCodePicklist: HotWarmColdValues: Cold, Hot, WarmRequiredSalesStagePicklist: OpportunityStateValues: Lost, Open, WonSalesTeamIdentifiedData: BooleanSourcePicklist: OpportunitySourceValues: Advertisement, EmployeeReferral, ExternalReferral, Other, Partner, PublicRelations, Seminar, TradeShow, Web, WordOfMouthRequiredStatusPicklist: OpportunityStatusValues: Canceled, InProgress, OnHold, OutSold, WonRequiredTimelinePicklist: PurchaseTimeframeValues: Immediate, NextQuarter, ThisQuarter, ThisYear, UnknownRelationshipsRelated entityDescriptionCardinalityTypeOpportunityParent opportunityOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationLeadOriginating leadOneToManyAssociationContactContactOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameStatusEstimatedValueAmountEstimatedCloseDatePurchaseTimeFramePurchaseProcessSalesStageDescriptionCreatedDateIndustryCodeRatingCodeSourceDefaultListDefaultList field groupOpportunityIdNameStatusEstimatedValueAmountEstimatedCloseDatePurchaseTimeFrameDefaultCardDefaultCard field groupOpportunityIdNameStatusDefaultDetailsDefaultDetails field groupOpportunityIdNameStatusEstimatedValueAmountEstimatedCloseDatePurchaseTimeFramePurchaseProcessSalesStageDescriptionCreatedDateSourceIndustryCodeRatingCodeDefaultLookupDefaultLookup field groupOpportunityIdNameStatusDefaultReportDefaultReport field groupOpportunityIdNameStatusEstimatedValueAmountEstimatedCloseDatePurchaseTimeFramePurchaseProcessSalesStageDescriptionCreatedDateSourceIndustryCodeRatingCodeDefaultIdentificationDefaultIdentification field groupOpportunityIdNameOpportunityCompetitor (Opportunity competitor) EntityAssociates an opportunity and a competitor. This entity creates a many-to-many relationship between the two entities.FieldDescriptionCompetitorPrimary keyLookup: CompetitorRequiredOpportunityLookup: OpportunityRequiredRelationshipsRelated entityDescriptionCardinalityTypeOpportunityOpportunityOneToManyAssociationCompetitorCompetitorOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupCompetitorOpportunityDefaultCreateDefaultCreate field groupCompetitorOpportunityDefaultDetailsDefaultDetails field groupCompetitorOpportunityDefaultIdentificationDefaultIdentification field groupCompetitorOpportunityDefaultListDefaultList field groupCompetitorOpportunityDefaultLookupDefaultLookup field groupCompetitorOpportunityDefaultReportDefaultReport field groupCompetitorOpportunityOpportunityProduct (Opportunity product) EntityAssociates an opportunity and a product. This entity creates a many-to-many relationship between the two entities.FieldDescriptionDescriptionData: MemoDiscountAmountData: CurrencyDecimal places: 6IsPriceOverriddenData: BooleanLineAmountData: CurrencyDecimal places: 6OpportunityPrimary keyLookup: OpportunityRequiredProductLookup: ProductRequiredQuantityData: QuantitySequenceData: IntegerTotalTaxAmountData: CurrencyDecimal places: 6UnitPriceData: CurrencyDecimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeProductProductOneToManyAssociationOpportunityOpportunityOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCardDefaultCard field groupProductOpportunityDescriptionDefaultCreateDefaultCreate field groupDescriptionLineAmountOpportunityProductDefaultDetailsDefaultDetails field groupDescriptionLineAmountOpportunityProductDefaultIdentificationDefaultIdentification field groupDescriptionProductDefaultListDefaultList field groupDescriptionLineAmountOpportunityProductDefaultLookupDefaultLookup field groupProductOpportunityDefaultReportDefaultReport field groupDescriptionLineAmountOpportunityProductPartner (Partner) EntityAn organization that takes part in a business relationship with another organization with shared risks and profits.FieldDescriptionBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 128DUNSNumberData: TextMaximum length: 128EmailAlternateData: EmailEmailPrimaryData: EmailSearchableFacebookIdentityData: TextMaximum length: 128FullNameData: TextSearchable, Maximum length: 128IndustryCodePicklist: IndustryCodeValues: Accounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleIsEmailContactAllowedData: BooleanRequiredIsPhoneContactAllowedData: BooleanRequiredIsSecurityPrincipalData: BooleanRequiredLinkedInIdentityData: TextMaximum length: 128MailingPostalAddressData: AddressOrganizationLookup: OrganizationOrganizationNameData: TextMaximum length: 128OtherPostalAddressData: AddressParentPartnerLookup: PartnerPartnerIdPrimary keyNumber sequence:?Unique, SearchablePartyTypePicklist: PartyTypeValues: Group, Organization, PersonRequiredPhone01Data: PhonePhone02Data: PhonePhone03Data: PhonePhonePrimaryData: PhonePrimaryContactLookup: ContactSatoriIdData: TextMaximum length: 128ShippingPostalAddressData: AddressSocialNetwork01Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetwork02Picklist: SocialNetworkValues: Facebook, Konnects, LinkedIn, Myspace, Twitter, XINGSocialNetworkIdentity01Data: TextMaximum length: 128SocialNetworkIdentity02Data: TextMaximum length: 128SourcePicklist: SourceValues: DefaultRequiredStatusPicklist: PartnerStatusValues: Active, InactiveRequiredStockExchangePicklist: StockExchangeValues: BMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeStockTickerData: TextMaximum length: 128TaxIdentificationIssuerData: TextMaximum length: 128TaxIdentificationNumberData: TextMaximum length: 128TwitterIdentityData: TextMaximum length: 128WebsiteURLData: TextMaximum length: 255RelationshipsRelated entityDescriptionCardinalityTypePartnerParent partnerOneToManyAssociationContactPrimary contactOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupPhonePrimaryParentPartnerWebsiteURLPartyTypeSourceIsEmailContactAllowedIsPhoneContactAllowedIsSecurityPrincipalStatusDefaultListDefaultList field groupPartnerIdFullNamePhonePrimaryParentPartnerWebsiteURLDefaultCardDefaultCard field groupPartnerIdFullNamePhonePrimaryDefaultDetailsDefaultDetails field groupPartnerIdFullNamePhonePrimaryParentPartnerWebsiteURLDescriptionFacebookIdentityLinkedInIdentityTwitterIdentityStockTickerDefaultLookupDefaultLookup field groupPartnerIdFullNamePhonePrimaryDefaultReportDefaultReport field groupPartnerIdFullNamePhonePrimaryParentPartnerWebsiteURLFacebookIdentityLinkedInIdentityTwitterIdentityMailingPostalAddressStockTickerDefaultIdentificationDefaultIdentification field groupPartnerIdFullNameQuotation (Quotation) EntityA sales quote prepared for a customer.FieldDescriptionAccountLookup: AccountRequiredAccountContactLookup: ContactBillingAddressData: AddressBusinessUnitLookup: BusinessUnitCustomerPurchaseOrderReferenceData: TextMaximum length: 20DeliveryAddressData: AddressDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6DiscountPercentData: NumberRequiredExpectedShipDateData: DateTimeExpirationDateData: DateRequiredFreightTermsPicklist: FreightTermsValues: FOB, NoChargeInvoiceAccountLookup: AccountNameData: TextMaximum length: 60OpportunityLookup: OpportunityOrganizationLookup: OrganizationPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30QuotationDateData: DateRequiredQuotationIdPrimary keyNumber sequence:?Unique, SearchableQuotationTypePicklist: QuotationTypeValues: Maintainence, Product, ServiceRequiredDescription: TypeRequestedDeliveryDateData: DateTimeSalesOrderReferenceData: TextMaximum length: 128SalesPersonWorkerLookup: WorkerDescription: Sales personShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSStatusPicklist: QuotationStatusValues: Active, Closed, Draft, WonRequiredDescription: Quotation statusStatusReasonPicklist: QuotationStatusReasonValues: Active, Cancelled, Lost, Open, Revised, WonDescription: Quotation status reasonTotalAmountData: CurrencyRequired, Decimal places: 6TotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalDiscountAmountData: CurrencyRequired, Decimal places: 6TotalDiscountPercentData: NumberRequiredTotalTaxAmountData: CurrencyRequired, Decimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationWorkerSales personOneToManyAssociationContactAccount contactOneToManyAssociationOpportunityOpportunityOneToManyAssociationAccountInvoice accountOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationIdAccountQuotationDateCustomerPurchaseOrderReferenceStatusQuotationTypeNameDescriptionSalesPersonWorkerAccountContactExpirationDateDefaultListDefaultList field groupQuotationIdAccountQuotationDateCustomerPurchaseOrderReferenceQuotationTypeStatusSalesPersonWorkerTotalAmountDefaultCardDefaultCard field groupQuotationIdAccountQuotationDateStatusTotalAmountDefaultDetailsDefaultDetails field groupQuotationIdAccountQuotationDateCustomerPurchaseOrderReferenceQuotationTypeNameDescriptionSalesPersonWorkerAccountContactTotalAmountFreightTermsShippingMethodInvoiceAccountBillingAddressTotalChargeAmountTotalDiscountAmountTotalTaxAmountDefaultLookupDefaultLookup field groupQuotationIdAccountQuotationDateStatusTotalAmountDefaultReportDefaultReport field groupQuotationIdAccountQuotationDateCustomerPurchaseOrderReferenceStatusQuotationTypeNameDescriptionSalesPersonWorkerAccountContactTotalAmountDefaultIdentificationDefaultIdentification field groupQuotationIdNameQuotationCharge (Quotation charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the whole quotation.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: ChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameQuotationPrimary keyLookup: QuotationRequiredRelationshipsRelated entityDescriptionCardinalityTypeQuotationQuotationOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationChargeTypeNameDescriptionAmountDefaultListDefaultList field groupChargeTypeQuotationAmountDefaultCardDefaultCard field groupChargeTypeQuotationAmountDefaultDetailsDefaultDetails field groupQuotationChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupQuotationChargeTypeAmountDefaultReportDefaultReport field groupQuotationChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupQuotationNameQuotationLine (Quotation line) EntityA component of a quotation that contains a portion of the quoted amount including information such as product, quantity, and price.FieldDescriptionBusinessUnitLookup: BusinessUnitDeliveryAddressData: AddressDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6DiscountPercentData: NumberRequiredExpectedShipDateData: DateTimeLineAmountData: CurrencyRequired, Decimal places: 6MostRecentActualShipDateData: DateTimeNameData: TextMaximum length: 60ProductLookup: ProductRequiredProductNameData: TextRequired, Maximum length: 60PromisedShipDateData: DateTimeQuantityData: QuantityRequiredQuotationPrimary keyLookup: QuotationRequiredRequestedDeliveryDateData: DateTimeSequenceData: IntegerRequiredStatusPicklist: QuotationLineStatusValues: Active, Closed, Draft, WonRequiredDescription: Quotation line statusStatusReasonPicklist: QuotationLineStatusReasonValues: Active, Cancelled, Lost, Open, Revised, WonDescription: Quotation line status reasonTotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalTaxAmountData: CurrencyRequired, Decimal places: 6UnitPriceData: CurrencyRequired, Decimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeQuotationQuotationOneToManyCompositionProductProductOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationSequenceProductDescriptionStatusQuantityUnitPriceLineAmountProductNameDefaultListDefaultList field groupQuotationProductProductNameStatusQuantityLineAmountDefaultCardDefaultCard field groupQuotationProductProductNameStatusQuantityDefaultDetailsDefaultDetails field groupQuotationSequenceProductProductNameDescriptionStatusQuantityUnitPriceLineAmountExpectedShipDateMostRecentActualShipDateDeliveryAddressTotalChargeAmountTotalTaxAmountDefaultLookupDefaultLookup field groupQuotationProductNameStatusQuantityDefaultReportDefaultReport field groupQuotationProductProductNameStatusQuantityUnitPriceLineAmountExpectedShipDateMostRecentActualShipDateDefaultIdentificationDefaultIdentification field groupSequenceProductNameQuotationLineCharge (Quotation line charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the quotation line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6Description: Total line chargesBusinessUnitLookup: BusinessUnitChargeTypePicklist: LineChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameQuotationLinePrimary keyLookup: QuotationLineRequiredRelationshipsRelated entityDescriptionCardinalityTypeQuotationLineQuotation lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationLineChargeTypeNameAmountDefaultListDefaultList field groupChargeTypeNameAmountDefaultCardDefaultCard field groupChargeTypeNameAmountDefaultDetailsDefaultDetails field groupQuotationLineChargeTypeNameAmountDefaultLookupDefaultLookup field groupChargeTypeNameAmountDefaultReportDefaultReport field groupQuotationLineChargeTypeNameAmountDefaultIdentificationDefaultIdentification field groupQuotationLineChargeTypeQuotationLineTax (Quotation line tax) EntityTax charged on a quotation line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6Description: Total line taxesBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameQuotationLinePrimary keyLookup: QuotationLineRequiredRateCodeData: TextMaximum length: 60TaxTypePicklist: LineTaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeQuotationLineQuotation lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationLineTaxTypeNameAmountDefaultListDefaultList field groupTaxTypeNameAmountDefaultCardDefaultCard field groupTaxTypeNameAmountDefaultDetailsDefaultDetails field groupQuotationLineTaxTypeNameAmountDefaultLookupDefaultLookup field groupTaxTypeNameAmountDefaultReportDefaultReport field groupQuotationLineTaxTypeNameAmountDefaultIdentificationDefaultIdentification field groupQuotationLineTaxTypeQuotationTax (Quotation tax) EntityTax charged on a quotation as a whole.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameQuotationPrimary keyLookup: QuotationRequiredRateCodeData: TextMaximum length: 60TaxTypePicklist: TaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeQuotationQuotationOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupQuotationNameRateCodeTaxTypeAmountDescriptionDefaultListDefaultList field groupQuotationNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupQuotationNameRateCodeTaxTypeAmountDefaultDetailsDefaultDetails field groupQuotationNameRateCodeTaxTypeAmountDescriptionDefaultLookupDefaultLookup field groupQuotationNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupQuotationNameRateCodeTaxTypeAmountDescriptionDefaultIdentificationDefaultIdentification field groupQuotationNameSalesInvoice (Sales invoice) EntityAn invoice sent to a customer to document the customer's liability for a purchase.FieldDescriptionAccountLookup: AccountAccountContactLookup: ContactBillingAddressData: AddressBusinessUnitLookup: BusinessUnitCustomerPurchaseOrderReferenceData: TextMaximum length: 20DescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyDecimal places: 6FreightTermsPicklist: FreightTermsValues: FOB, NoChargeInvoiceDateData: DateTimeRequiredNameData: TextMaximum length: 60OpportunityLookup: OpportunityOrganizationLookup: OrganizationPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30SalesInvoiceIdPrimary keyNumber sequence:?Unique, SearchableSalesOrderLookup: SalesOrderSalesPersonWorkerLookup: WorkerDescription: Sales personShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSStatusPicklist: InvoiceStatusValues: Cancelled, Created, Hold, PaidDescription: Invoice statusTotalAmountData: CurrencyDecimal places: 6TotalChargeAmountData: CurrencyDecimal places: 6TotalDiscountAmountData: CurrencyDecimal places: 6TotalTaxAmountData: CurrencyDecimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationWorkerSales personOneToManyAssociationContactAccount contactOneToManyAssociationOpportunityOpportunityOneToManyAssociationSalesOrderSales orderOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupInvoiceDateNameDescriptionAccountCustomerPurchaseOrderReferenceAccountContactStatusBillingAddressDefaultListDefaultList field groupInvoiceDateSalesInvoiceIdNameAccountCustomerPurchaseOrderReferenceStatusTotalAmountDefaultCardDefaultCard field groupInvoiceDateSalesInvoiceIdNameAccountStatusTotalAmountDefaultDetailsDefaultDetails field groupInvoiceDateSalesInvoiceIdNameDescriptionAccountCustomerPurchaseOrderReferenceAccountContactStatusBillingAddressTotalAmountFreightTermsPaymentTermsSalesPersonWorkerShippingMethodTotalChargeAmountTotalDiscountAmountTotalTaxAmountDefaultLookupDefaultLookup field groupSalesInvoiceIdInvoiceDateNameAccountDefaultReportDefaultReport field groupInvoiceDateSalesInvoiceIdNameDescriptionAccountCustomerPurchaseOrderReferenceAccountContactStatusBillingAddressTotalAmountFreightTermsPaymentTermsSalesPersonWorkerShippingMethodTotalChargeAmountTotalDiscountAmountTotalTaxAmountDefaultIdentificationDefaultIdentification field groupSalesInvoiceIdNameSalesInvoiceCharge (Sales invoice charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the whole invoice.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: InvoiceChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameSalesInvoicePrimary keyLookup: SalesInvoiceRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesInvoiceSales invoiceOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesInvoiceChargeTypeNameDescriptionAmountDefaultListDefaultList field groupSalesInvoiceChargeTypeNameAmountDefaultCardDefaultCard field groupSalesInvoiceChargeTypeNameAmountDefaultDetailsDefaultDetails field groupSalesInvoiceChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupSalesInvoiceChargeTypeAmountDefaultReportDefaultReport field groupSalesInvoiceChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupSalesInvoiceNameSalesInvoiceLine (Sales invoice line) EntityA component of a sales invoice that contains a portion of the invoiced amount including information such as product, quantity, and price.FieldDescriptionBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6ExpectedShipDateData: DateTimeLineAmountData: CurrencyRequired, Decimal places: 6MostRecentActualShipDateData: DateTimeNameData: TextMaximum length: 60ProductLookup: ProductProductNameData: TextRequired, Maximum length: 60PromisedShipDateData: DateTimeQuantityData: QuantityRequiredSalesInvoicePrimary keyLookup: SalesInvoiceRequiredSequenceData: IntegerRequiredStatusPicklist: InvoiceLineStatusValues: Active, Confirmed, Invoice, PackingSlip, QuoteRequiredDescription: Invoice line statusTotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalTaxAmountData: CurrencyRequired, Decimal places: 6UnitPriceData: CurrencyRequired, Decimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeSalesInvoiceSales invoiceOneToManyCompositionProductProductOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesInvoiceProductNameDescriptionStatusQuantitySequenceProductNameUnitPriceDefaultListDefaultList field groupSalesInvoiceProductNameStatusQuantityLineAmountDefaultCardDefaultCard field groupSalesInvoiceProductStatusQuantityLineAmountDefaultDetailsDefaultDetails field groupSalesInvoiceProductNameDescriptionStatusQuantityLineAmountDiscountAmountTotalChargeAmountTotalTaxAmountDefaultLookupDefaultLookup field groupSalesInvoiceProductStatusQuantityLineAmountDefaultReportDefaultReport field groupSalesInvoiceProductNameStatusQuantityLineAmountDiscountAmountTotalChargeAmountTotalTaxAmountDefaultIdentificationDefaultIdentification field groupSalesInvoiceSequenceProductSalesInvoiceLineCharge (Sales invoice line charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the invoice line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: InvoiceLineChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameSalesInvoiceLinePrimary keyLookup: SalesInvoiceLineRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesInvoiceLineSales invoice lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesInvoiceLineChargeTypeNameDescriptionAmountDefaultListDefaultList field groupChargeTypeNameAmountDefaultCardDefaultCard field groupChargeTypeNameAmountDefaultDetailsDefaultDetails field groupSalesInvoiceLineChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupChargeTypeAmountDefaultReportDefaultReport field groupSalesInvoiceLineChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupSalesInvoiceLineNameSalesInvoiceLineTax (Sales invoice line tax) EntityTax charged on a sales invoice line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60SalesInvoiceLinePrimary keyLookup: SalesInvoiceLineRequiredTaxTypePicklist: InvoiceLineTaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesInvoiceLineSales invoice lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupNameRateCodeTaxTypeAmountSalesInvoiceLineDefaultListDefaultList field groupNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupNameTaxTypeAmountDefaultDetailsDefaultDetails field groupNameRateCodeTaxTypeAmountDescriptionSalesInvoiceLineDefaultLookupDefaultLookup field groupNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupNameRateCodeTaxTypeAmountDescriptionSalesInvoiceLineDefaultIdentificationDefaultIdentification field groupSalesInvoiceLineNameSalesInvoiceTax (Sales invoice tax) EntityTax charged on a sales invoice as a whole.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60SalesInvoicePrimary keyLookup: SalesInvoiceRequiredTaxTypePicklist: InvoiceTaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesInvoiceSales invoiceOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesInvoiceRateCodeTaxTypeNameAmountDescriptionDefaultListDefaultList field groupSalesInvoiceRateCodeTaxTypeAmountDefaultCardDefaultCard field groupSalesInvoiceTaxTypeAmountDefaultDetailsDefaultDetails field groupSalesInvoiceRateCodeTaxTypeNameAmountDescriptionDefaultLookupDefaultLookup field groupSalesInvoiceRateCodeAmountDefaultReportDefaultReport field groupSalesInvoiceRateCodeTaxTypeNameAmountDefaultIdentificationDefaultIdentification field groupSalesInvoiceTaxTypeRateCodeSalesOrder (Sales order) EntityAn order issued by a business to a customer for selling products and/or services.FieldDescriptionAccountLookup: AccountAccountContactLookup: ContactBillingAddressData: AddressBusinessUnitLookup: BusinessUnitCustomerPurchaseOrderReferenceData: TextMaximum length: 20DeliveryAddressData: AddressDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyDecimal places: 6ExpectedShipDateData: DateTimeFreightTermsPicklist: FreightTermsValues: FOB, NoChargeInvoiceAccountLookup: AccountNameData: TextMaximum length: 60OpportunityLookup: OpportunityOrderDateData: DateTimeRequiredOrganizationLookup: OrganizationPaymentTermsPicklist: PaymentTermsValues: Net30, Net45, Net60, TwoPercent10Net30RequestedDeliveryDateData: DateTimeSalesOrderIdPrimary keyNumber sequence:?Unique, SearchableSalesPersonWorkerLookup: WorkerDescription: Sales personShippingMethodPicklist: ShippingMethodValues: AirBorne, DHL, Fedex, PostalMail, UPSStatusPicklist: OrderStatusValues: Active, Cancelled, Confirmed, Invoice, PackingSlip, PartiallyInvoiced, PartiallyPacked, PartiallyPicked, PartiallyShipped, Picked, Quote, ShippedRequiredDescription: Order statusTotalAmountData: CurrencyRequired, Decimal places: 6TotalChargeAmountData: CurrencyRequired, Decimal places: 6TotalDiscountAmountData: CurrencyDecimal places: 6TotalTaxAmountData: CurrencyRequired, Decimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeAccountAccountOneToManyAssociationWorkerSales personOneToManyAssociationContactAccount contactOneToManyAssociationOpportunityOpportunityOneToManyAssociationAccountInvoice accountOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationOrganizationOrganizationOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupAccountOrderDateCustomerPurchaseOrderReferenceStatusNameDescriptionSalesPersonWorkerAccountContactDefaultListDefaultList field groupSalesOrderIdAccountOrderDateCustomerPurchaseOrderReferenceStatusSalesPersonWorkerTotalAmountDefaultCardDefaultCard field groupSalesOrderIdAccountOrderDateStatusTotalAmountDefaultDetailsDefaultDetails field groupSalesOrderIdAccountOrderDateCustomerPurchaseOrderReferenceStatusNameDescriptionSalesPersonWorkerAccountContactTotalAmountFreightTermsShippingMethodDeliveryAddressBillingAddressTotalChargeAmountTotalDiscountAmountTotalTaxAmountDefaultLookupDefaultLookup field groupSalesOrderIdAccountOrderDateStatusTotalAmountDefaultReportDefaultReport field groupSalesOrderIdAccountOrderDateCustomerPurchaseOrderReferenceStatusNameDescriptionSalesPersonWorkerAccountContactTotalAmountDefaultIdentificationDefaultIdentification field groupSalesOrderIdNameSalesOrderCharge (Sales order charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the whole sales orderFieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: ChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameSalesOrderPrimary keyLookup: SalesOrderRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesOrderSales orderOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesOrderChargeTypeNameDescriptionAmountDefaultListDefaultList field groupSalesOrderChargeTypeAmountDefaultCardDefaultCard field groupSalesOrderChargeTypeAmountDefaultDetailsDefaultDetails field groupSalesOrderChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupSalesOrderChargeTypeAmountDefaultReportDefaultReport field groupSalesOrderChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupSalesOrderChargeTypeNameSalesOrderLine (Sales order line) EntityA component of a sales order that contains a portion of the order amount including information such as product, quantity, and price.FieldDescriptionBusinessUnitLookup: BusinessUnitDeliveryPostalAddressData: AddressDescription: Delivery addressDescriptionData: TextMaximum length: 255DiscountAmountData: CurrencyRequired, Decimal places: 6ExpectedShipDateData: DateTimeLineAmountData: CurrencyDecimal places: 6MostRecentActualShipDateData: DateTimeNameData: TextMaximum length: 60ProductLookup: ProductRequiredProductNameData: TextMaximum length: 60PromisedShipDateData: DateTimeQuantityData: QuantityRequestedDeliveryDateData: DateTimeSalesOrderPrimary keyLookup: SalesOrderRequiredSequenceData: IntegerRequiredStatusPicklist: OrderLineStatusValues: Active, Confirmed, Invoice, PackingSlip, QuoteDescription: Order line statusTotalChargeAmountData: CurrencyDecimal places: 6TotalTaxAmountData: CurrencyDecimal places: 6UnitPriceData: CurrencyDecimal places: 6RelationshipsRelated entityDescriptionCardinalityTypeSalesOrderSales orderOneToManyCompositionProductProductOneToManyAssociationBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesOrderSequenceProductDescriptionStatusQuantityUnitPriceLineAmountDefaultListDefaultList field groupSalesOrderProductProductNameStatusQuantityLineAmountDefaultCardDefaultCard field groupSalesOrderProductProductNameStatusQuantityDefaultDetailsDefaultDetails field groupSalesOrderSequenceProductProductNameDescriptionStatusQuantityUnitPriceLineAmountExpectedShipDateMostRecentActualShipDateDeliveryPostalAddressTotalChargeAmountTotalTaxAmountDefaultLookupDefaultLookup field groupSalesOrderProductNameStatusQuantityDefaultReportDefaultReport field groupSalesOrderProductProductNameStatusQuantityUnitPriceLineAmountExpectedShipDateMostRecentActualShipDateDefaultIdentificationDefaultIdentification field groupSalesOrderSequenceProductNameSalesOrderLineCharge (Sales order line charge) EntityAn indirect charge in addition to product pricing and taxes, such as freight or insurance, that applies to the sales order line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitChargeTypePicklist: LineChargeTypeValues: Freight, Insurance, OthersRequiredDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Charge nameSalesOrderLinePrimary keyLookup: SalesOrderLineRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesOrderLineSales order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesOrderLineChargeTypeNameDescriptionAmountDefaultListDefaultList field groupChargeTypeAmountDefaultCardDefaultCard field groupChargeTypeAmountDefaultDetailsDefaultDetails field groupSalesOrderLineChargeTypeNameDescriptionAmountDefaultLookupDefaultLookup field groupSalesOrderLineAmountChargeTypeDefaultReportDefaultReport field groupSalesOrderLineChargeTypeNameDescriptionAmountDefaultIdentificationDefaultIdentification field groupSalesOrderLineChargeTypeNameSalesOrderLineShipment (Sales order line shipment) EntityShipment details for a line on sales order. A single line item on a sales order can be split and shipped to different addresses.FieldDescriptionActualShipDateData: DateBusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60QuantityData: QuantitySalesOrderLinePrimary keyLookup: SalesOrderLineRequiredSequenceData: IntegerRequiredStatusPicklist: ShipmentStatusValues: Delivered, OpenRelationshipsRelated entityDescriptionCardinalityTypeSalesOrderLineSales order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupActualShipDateSalesOrderLineDescriptionQuantityStatusSequenceDefaultListDefaultList field groupActualShipDateDescriptionQuantityStatusDefaultCardDefaultCard field groupActualShipDateDescriptionQuantityStatusDefaultDetailsDefaultDetails field groupActualShipDateSalesOrderLineDescriptionQuantityStatusDefaultLookupDefaultLookup field groupSalesOrderLineActualShipDateDescriptionQuantityStatusDefaultReportDefaultReport field groupStatusActualShipDateSalesOrderLineDescriptionQuantityDefaultIdentificationDefaultIdentification field groupSalesOrderLineActualShipDateSalesOrderLineTax (Sales order line tax) EntityTax charged on a sales order line.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60SalesOrderLinePrimary keyLookup: SalesOrderLineRequiredTaxTypePicklist: LineTaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesOrderLineSales order lineOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupTaxTypeRateCodeSalesOrderLineNameDescriptionAmountDefaultListDefaultList field groupTaxTypeRateCodeAmountDefaultCardDefaultCard field groupTaxTypeAmountDefaultDetailsDefaultDetails field groupTaxTypeRateCodeSalesOrderLineNameDescriptionAmountDefaultLookupDefaultLookup field groupSalesOrderLineTaxTypeRateCodeAmountDefaultReportDefaultReport field groupAmountTaxTypeRateCodeSalesOrderLineNameDescriptionDefaultIdentificationDefaultIdentification field groupSalesOrderLineTaxTypeRateCodeSalesOrderTax (Sales order tax) EntityTax charged on a sales order as a whole.FieldDescriptionAmountData: CurrencyRequired, Decimal places: 6BusinessUnitLookup: BusinessUnitDescriptionData: TextMaximum length: 60NameData: TextMaximum length: 60Description: Tax nameRateCodeData: TextMaximum length: 60SalesOrderPrimary keyLookup: SalesOrderRequiredTaxTypePicklist: TaxTypeValues: Others, SalesTax, VATRequiredRelationshipsRelated entityDescriptionCardinalityTypeSalesOrderSales orderOneToManyCompositionBusinessUnitBusiness unitOneToManyAssociationField groupsField groupDescriptionFieldsDefaultCreateDefaultCreate field groupSalesOrderNameRateCodeTaxTypeAmountDescriptionDefaultListDefaultList field groupSalesOrderNameRateCodeTaxTypeAmountDefaultCardDefaultCard field groupSalesOrderNameTaxTypeAmountDefaultDetailsDefaultDetails field groupSalesOrderNameRateCodeTaxTypeAmountDescriptionDefaultLookupDefaultLookup field groupSalesOrderNameRateCodeTaxTypeAmountDefaultReportDefaultReport field groupSalesOrderNameRateCodeTaxTypeAmountDescriptionDefaultIdentificationDefaultIdentification field groupSalesOrderNameStandard picklistsNameValuesAccountStatusActive, InactiveAccountStatusReasonActive, InactiveAccountTypeOrganization, PersonActiveInactiveActive, InactiveAddRemoveAdd, RemoveAddressRoleBillingAddress, PrimaryAddress, ShippingAddressAddUpdateAdd, UpdateAffixPrefix, SuffixAllChosenAll, ChosenAllDraftCompletedAll, Completed, DraftAllPositiveNegativeZeroAll, Negative, Positive, ZeroAlumnusStatusCurrent, Inactive, PastAlumnusStatusReasonActive, InactiveApplicationUserGroupStatusActive, InactiveApplicationUserGroupStatusReasonActive, InactiveApplicationUserStatusActive, InactiveApplicationUserStatusReasonActive, InactiveAscendingDescendingAscending, DescendingBodyContentTypeHTML, TextBudgetStatusCanBuy, MayBuy, NoCommittedBudget, WillBuyBusinessUnitStatusActive, InactiveBusinessUnitStatusReasonActive, InactiveCaseActivityTypeAssignReassignCaseWorker, Cancel, ChangeCaseStatus, Close, Contact, CreateSubcase, Intake, MakeKBReference, Open, ResearchCaseCategoryProblem, Question, RequestCaseContactTypeEmail, Facebook, Other, Phone, Twitter, WebCaseCustomerSatisfactionCodeDissatisfied, Neutral, Satisfied, VeryDissatisfied, VerySatisfiedCaseOriginEmail, Facebook, Phone, Twitter, WebCaseOriginCodeEmail, Facebook, Other, Phone, Twitter, WebCaseReassignedReasonNotResolvedCaseSolutionTypeSolvedByCustomer, SolvedByKBArticle, SolvedBySupportWorkerCaseStatusActive, Cancelled, Closed, OnHold, Resolved, SolvedAnsweredCaseStatusReasonActive, InactiveCaseWorkerAssignmentReasonCaseSeverityChange, Initial, Other, ReassignChannelActivityAppointment, Email, PhoneCall, ServiceActivity, SocialActivity, TaskChargeTypeFreight, Insurance, OthersColorAqua, Black, Blue, Fuchsia, Gray, Green, Lime, Maroon, Navy, Olive, Purple, Red, Silver, Teal, White, YellowCommunicationMethodAny, Email, Fax, Mail, Phone, SocialMediaCompetitorStatusActive, InactiveConstituentStatusActive, InactiveConstituentStatusReasonActive, InactiveContactMethodAny, Email, Fax, Mail, PhoneContractorStatusActive, InactiveConversionRoundingDown, Nearest, UpCountryCodeAD, AE, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BV, BW, BY, BZ, CA, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, ER, ES, ET, FI, FJ, FK, FM, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GU, GW, GY, HK, HM, HN, HR, HT, HU, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, US, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XE, XJ, XK, XS, YE, YT, ZA, ZM, ZWCurrencyCodeAED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRL, BSD, BTN, BWP, BYN, BYR, BZD, CAD, CDF, CHE, CHF, CHW, CLF, CLP, CNY, COP, COU, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MXV, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLL, SOS, SRD, SSP, STD, SVC, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, USN, UYI, UYU, UZS, VEF, VND, VUV, WST, XAF, XAG, XAU, XBA, XBB, XBC, XBD, XCD, XDR, XOF, XPD, XPF, XPT, XSU, XTS, XUA, XXX, YER, ZAR, ZMW, ZWLCustomerStatusActive, Blocked, InactiveDayOfTheWeekFriday, Monday, Saturday, Sunday, Thursday, Tuesday, WednesdayDocumentStatusCompleted, Draft, InProgressDonationTypeCash, Check, CreditCard, DebitCard, Paypal, PayrollDeductionDonationValuationMethodHigh, Low, NormalDonorStatusActive, InactiveEducationStatusDoctorate, Graduate, HighSchool, Postgraduate, UndergraduateElectronicAddressCategoryEmail, Fax, Phone, SocialNetworkElectronicAddressFormatEmail, Phone, TextElectronicAddressTypeCellPhone, Facebook, HomePhone, LinkedIn, PersonalEmail, Twitter, WorkEmail, WorkPhoneEmploymentStatusEmployed, None, OnLeave, Resigned, RetiredEmploymentUnitOfNoticeMonth, WeekEnableDisableDisable, EnableEthnicityAfricanAmerican, Asian, Hispanic, NativeAmerican, Other, WhiteEventImportanceHigh, Low, NormalEventResponseAccepted, Declined, None, NotResponded, Organizer, TentativelyAcceptedEventSensitivityConfidential, Normal, Personal, PrivateEventTimeStatusBusy, Free, OutofOffice, Tentative, Unknown, WorkingelsewhereEventTypeException, Occurrence, SeriesMaster, SingleInstanceExpenseCategoryAdvertising, Entertainment, Food, InteriorDesigns, Logistics, Marketing, Miscellaneous, TeamActivities, TransportationFamilyMemberStatusActive, InactiveFamilyMemberStatusReasonActive, InactiveFamilyRoleElderSiblings, Father, GrandParents, Mother, YoungerSiblingsFamilyStatusActive, InactiveFamilyStatusReasonActive, InactiveFanStatusBronze, Club, Gold, Platinum, PreferenceTicket, SeasonTicketHolder, SilverFanStatusReasonActive, InactiveFiscalPeriodAnnual, Quarter1, Quarter2, Quarter3, Quarter4, Semester1, Semester2FreightTermsFOB, NoChargeGenderFemale, Male, Nonspecific, NotSpecifiedHorizontalVerticalHorizontal, VerticalHotWarmColdCold, Hot, WarmHouseholdMemberStatusActive, InactiveHouseholdMemberStatusReasonActive, InactiveHouseholdRoleElderSiblings, Father, GrandParents, Mother, YoungerSiblingsHouseholdStatusActive, InactiveHouseholdStatusReasonActive, InactiveInboundOutboundInbound, OutboundIndustryCodeAccounting, Agriculture, BroadcastingPrintingPublishing, Brokers, BuildingSupplyRetail, BusinessServices, Consulting, ConsumerServices, DesignCreativeManagement, DistributorsDispatchersProcessors, DoctorOfficesClinics, DurableManufacturing, EatingDrinkingPlaces, EntertainmentRetail, EquipmentRentalLeasing, Financial, FoodTobaccoProcessing, InboundCapitalIntensiveProcessing, InboundRepairServices, Insurance, LegalServices, NonDurableMerchandiseRetail, OutboundConsumerService, Petrochemicals, ServiceRetail, SIGAffiliations, SocialServices, SpecialOutboundTradeContractors, SpecialtyRealty, Transportation, UtilityCreationDistribution, VehicleRetail, WholesaleInternalExternalExternal, InternalInvoiceChargeTypeFreight, Insurance, OthersInvoiceLineChargeTypeFreight, Insurance, OthersInvoiceLineStatusActive, Confirmed, Invoice, PackingSlip, QuoteInvoiceLineStatusReasonActive, InactiveInvoiceLineTaxTypeOthers, SalesTax, VATInvoiceStatusCancelled, Created, Hold, PaidInvoiceStatusReasonActive, InactiveInvoiceTaxTypeOthers, SalesTax, VATJobExemptStatusDoesNotApply, Exempt, NonExemptJobStatusFailed, Pending, Processing, SucceededJobTitleNotSpecifiedLeadRatingCold, Hot, WarmLeadSourceAdvertisement, EmployeeReferral, ExternalReferral, Other, Partner, PublicRelations, Seminar, TradeShow, Web, WordOfMouthLeadStateDisqualified, Open, QualifiedLeadStatusCancelled, Contacted, Disqualified, New, NoLongerInterested, QualifiedLeadStatusReasonActive, InactiveLeaveRequestStatusApproved, Draft, InReviewLeftRightLeft, RightLineChargeTypeFreight, Insurance, OthersLineTaxTypeOthers, SalesTax, VATLowMedHighHigh, Low, MediumMaritalStatusDivorced, Married, None, Single, WidowedMemberStatusActive, InactiveMessageImportanceHigh, Low, NormalMessageInferenceClassificationFocused, OtherMonthsOfTheYearApril, August, December, February, January, July, June, March, May, November, October, SeptemberNationalityCanada, China, India, Japan, Mexico, Others, SouthKorea, USANoYesNo, YesNoYesUnchangedNo, Unchanged, YesOpportunityRoleDefaultOpportunitySourceAdvertisement, EmployeeReferral, ExternalReferral, Other, Partner, PublicRelations, Seminar, TradeShow, Web, WordOfMouthOpportunityStateLost, Open, WonOpportunityStatusCanceled, InProgress, OnHold, OutSold, WonOrderLineStatusActive, Confirmed, Invoice, PackingSlip, QuoteOrderLineStatusReasonActive, InactiveOrderStatusActive, Cancelled, Confirmed, Invoice, PackingSlip, PartiallyInvoiced, PartiallyPacked, PartiallyPicked, PartiallyShipped, Picked, Quote, ShippedOrderStatusReasonActive, InactiveOrganizationStatusActive, InactiveOrganizationStatusReasonActive, InactiveOrganizationTypeCorporation, Government, NonProfit, OtherPartnerStatusActive, InactivePartnerStatusReasonActive, InactivePartyRoleAccount, Alumnus, ApplicationUser, ApplicationUserGroup, BusinessUnit, Constituent, Contact, Family, Fan, Household, Lead, Organization, Partner, Person, Team, Tenant, Vendor, WorkerPartyTypeGroup, Organization, PersonPaymentTermsNet30, Net45, Net60, TwoPercent10Net30PersonStatusActive, InactivePersonStatusReasonActive, InactivePersonTitleCoach, Dr, Father, Jr, Miss, Mr, Mrs, Ms, Rev, Sister, SrPledgeFrequencyDaily, Monthly, OneTime, Quarterly, Weekly, YearlyPledgeTypeOneTime, RecurringPositionClassificationFullTime, PartTimePreferenceTypeAlternateEmail, AlternateSocialNetwork, CellPhone, HomePhone, PrimaryEmail, PrimaryPhone, PrimarySocialNetworkPrimaryAccountRoleDecisionMaker, Employee, InfluencerPriorityHigh, Low, NormalProcessCommittee, Individual, UnknownProductStatusActive, InactiveProductStatusReasonActive, InactiveProductTypeItem, ServiceProductVendorStatusActive, Blocked, InactiveProductVendorStatusReasonActive, InactivePurchaseOrderLineStatusBlocked, Closed, Confirmed, Invoiced, Open, Received, SuspendedPurchaseOrderLineStatusReasonActive, InactivePurchaseOrderStatusBlocked, Closed, Confirmed, Invoiced, Open, Received, SuspendedPurchaseOrderStatusReasonActive, InactivePurchaseTimeframeImmediate, NextQuarter, ThisQuarter, ThisYear, UnknownQuotationLineStatusActive, Closed, Draft, WonQuotationLineStatusReasonActive, Cancelled, Lost, Open, Revised, WonQuotationStatusActive, Closed, Draft, WonQuotationStatusReasonActive, Cancelled, Lost, Open, Revised, WonQuotationTypeMaintainence, Product, ServiceReferencedTypeDefaultSeverityHigh, Low, NormalsexFemale, Male, UnknownShipmentStatusDelivered, OpenShipmentStatusReasonActive, InactiveShippingMethodAirBorne, DHL, Fedex, PostalMail, UPSSizeExtraLarge, Large, Medium, SmallSkillLevelAdvanced, Beginner, Expert, IntermediateSocialNetworkFacebook, Konnects, LinkedIn, Myspace, Twitter, XINGSourceDefaultStatusActive, InactiveStatusReasonActive, InactiveStockExchangeBMESpanishExchanges, Euronext, FrankfurtStockExchange, HongKongStockExchange, ItalianStockExchange, KoreaExchange, LondonStockExchange, NASDAQ, NYSE, OMXNordicExchanges, ShanghaiStockExchange, ShenzhenStockExchange, SWXSwissExchange, TokyoStockExchange, TorontoStockExchangeSupplierApprovalStatusApproved, NotApproved, UnderReviewSyncStatusComplete, PendingTaskTypeBug, Compliance, Deliverable, Feature, Other, Task, Test, WorkItemTaxTypeOthers, SalesTax, VATTeamMemberStatusActive, InactiveTeamMemberStatusReasonActive, InactiveTeamRoleCoach, Lead, Manager, Player, Reserve, TeamLeader, TeamMemberTeamStatusActive, InactiveTeamStatusReasonActive, InactiveTenantStatusActive, InactiveTenantStatusReasonActive, InactiveTimeFrameDay, HalfYear, Hour, Month, Quarter, Trimester, Week, YearTimezoneGMT_CASABLANCA, GMT_CASABLANCA_MONTROVIA_REYKJAVIK, GMT_COORDINATEDUNIVERSALTIME, GMT_DUBLIN_EDINBURGH_LISBON_LONDON, GMT_PLUS0300KALININGRAD_MINSK, GMTMINUS0100AZORES, GMTMINUS0100CAPEVERDIS, GMTMINUS0200MIDATLANTIC, GMTMINUS0300_SALVADOR, GMTMINUS0300BRASILIA, GMTMINUS0300BUENOSAIRES, GMTMINUS0300BUENOSAIRES_GEORGETOWN, GMTMINUS0300GREENLAND, GMTMINUS0300MONTEVIDEO, GMTMINUS0330NEWFOUNDLAND, GMTMINUS0400ASUNCION, GMTMINUS0400ATLANTICTIME, GMTMINUS0400LAPAZ, GMTMINUS0400MANAUS, GMTMINUS0400SANTIAGO, GMTMINUS0430CARACAS, GMTMINUS0500BOGOTA_LIMA_QUITO_RIOBRANCO, GMTMINUS0500EASTERNTIME, GMTMINUS0500INDIANA, GMTMINUS0600CENTRALAMERICA, GMTMINUS0600CENTRALTIME, GMTMINUS0600GUADALAJARA_MEXICOCITY, GMTMINUS0600SASKATCHEWAN, GMTMINUS0700ARIZONA, GMTMINUS0700CHIHUAHUA_LAPAZ_MAZATLAN, GMTMINUS0700MOUNTAINTIME, GMTMINUS0800PACIFICTIME, GMTMINUS0800TIJUANA_BAJACALIFORNIA, GMTMINUS0900ALASKA, GMTMINUS1000HAWAII, GMTMINUS1100COORDINATEDUNIVERSALTIME, GMTMINUS1100MIDWAYISLAND_SAMOA, GMTMINUS1200INTERNATIONALDATELINEWEST, GMTPLUS0100_AMSTERDAM_BERLIN_BERN_ROME, GMTPLUS0100BELGRADE_BRATISLAVA_BUDAPEST, GMTPLUS0100BRUSSELS_COPENHAGEN_MADRID, GMTPLUS0100SARAJEVO_SKOPJE_WARSAW_ZAGREB, GMTPLUS0100TRIPOLI, GMTPLUS0100WESTCENTRALAFRICA, GMTPLUS0200_DAMASCUS, GMTPLUS0200AMMAN, GMTPLUS0200ATHENS_BUCHAREST_ISTANBUL, GMTPLUS0200BEIRUT, GMTPLUS0200CAIRO, GMTPLUS0200HARARE_PRETORIA, GMTPLUS0200HELSINKI_KYIV_RIGA_VILNIUS, GMTPLUS0200ISTANBUL, GMTPLUS0200JERUSALEM, GMTPLUS0200MINSK, GMTPLUS0200WINDHOEK, GMTPLUS0300BAGHDAD, GMTPLUS0300KUWAIT_RIYADH, GMTPLUS0300MOSCOW_STPETERSBURG_VOLGOGRAD, GMTPLUS0300NAIROBI, GMTPLUS0300TBILISI, GMTPLUS0330TEHRAN, GMTPLUS0400ABUDHABI_MUSCAT, GMTPLUS0400BAKU, GMTPLUS0400CAUCASUSSTANDARDTIME, GMTPLUS0400IZHEVSK_SAMARA, GMTPLUS0400PORTLOUIS, GMTPLUS0400YEREVAN, GMTPLUS0430KABUL, GMTPLUS0500EKATERINBURG, GMTPLUS0500ISLAMABAD_KARACHI, GMTPLUS0500ISLAMABAD_KARACHI_TASHKENT, GMTPLUS0530CHENNAI_KOLKATA_MUMBAI, GMTPLUS0530SRIJAYAWARDENEPURA, GMTPLUS0545KATHMANDU, GMTPLUS0600ALMATY_NOVOSIBIRSK, GMTPLUS0600ASTANA_DHAKA, GMTPLUS0600DHAKA, GMTPLUS0600MAGADAN, GMTPLUS0630_YANGON, GMTPLUS0700_BANGKOK_HANOI_JAKARTA, GMTPLUS0700KRASNOYARSK, GMTPLUS0800_ULAANBAATAR, GMTPLUS0800BEIJING_CHONGQING_HONGKONG, GMTPLUS0800IRKUTSK_ULAANBATAAR, GMTPLUS0800KUALALUMPUR_SINGAPORE, GMTPLUS0800PERTH, GMTPLUS0800TAIPEI, GMTPLUS0900OSAKA_SAPPORO_TOKYO, GMTPLUS0900SEOUL, GMTPLUS0900YAKUTSK, GMTPLUS0930ADELAIDE, GMTPLUS0930DARWIN, GMTPLUS1000BRISBANE, GMTPLUS1000CANBERRA_MELBOURNE_SYDNEY, GMTPLUS1000GUAM_PORTMORESBY, GMTPLUS1000HOBART, GMTPLUS1000VLADIVOSTOK, GMTPLUS1100CHOKURDAKH, GMTPLUS1100MAGADAN_SOLOMONIS, GMTPLUS1200ANADYR_PETRO_KAMCHATSKY, GMTPLUS1200AUCKLAND_WELLINGTON, GMTPLUS1200COORDINATEDUNIVERSALTIME, GMTPLUS1200FIJI_KAMCHATKA_MARSHALLIS, GMTPLUS1300NUKU_ALOFAUnitOfMeasureBag, Box, Bucket, Centilitre, Centimeter, CubicCentimeter, CubicFeet, CubicInch, CubicMeter, CubicMillimeter, CubicYard, Day, Deciliter, DegreesBrix, Dozen, Each, Feet, FluidOunce, Gallon, GigaByte, Gram, HalfCubicInch, HalfInch, HalfPint, HalfPound, HalfSquareInch, Hour, Inch, Keg, Kilogram, Kilometer, KilowattHour, Litre, Meter, Mgpx, Mile, Milligram, Millilitre, Millimeter, Minute, Month, Ohm, OneEighthCubicInch, OneEighthInch, OneEighthSquareInch, Option, Ounce, Pair, Pallet, PascalSecond, Percentage, pHValue, Piece, Pint, Pound, Quart, QuarterCubicInch, QuarterInch, QuarterPound, QuarterSquareInch, Second, SetOfEquipment, SquareCentimeter, SquareFeet, SquareInch, SquareMeter, SquareMile, SquareMillimeter, SquareYard, Ton, Tray, YardUpDownDown, UpUserOrGroupTypeGroup, ServicePrincipal, UserVendorStatusActive, Blocked, InactiveVolunteerStatusActive, InactiveWorkerStatusActive, InactiveWorkerStatusReasonActive, InactiveWorkerTypeContractor, Employee, Unspecified, Volunteer? 2017 Microsoft Corporation. All rights reserved.This document is provided “as-is.” Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it.Some examples are for illustration only and are fictitious. No real association is intended or inferred.This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes.Some information relates to pre-released product which may be substantially modified before it’s commercially released. Microsoft makes no warranties, express or implied, with respect to the information provided here. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download