This section gives list of data entities used for projects360 features.


Data entity name Target entity
1 Client type PMIPClientTypeEntity
Purpose – To import or export data from Client setup form used for Qualification view.
2 Customer integration table PMINCustIntegrationEntity
Purpose – Used for CRM integration.
3 Customer PO matching PMIPCustPOMatchingEntity
Purpose – To import and export date on the PO line tab on Project contracts form.
4 Deferred revenue PMIPDeferredRevenueEntity
Purpose – To import or export data from Deferred revenue periods form.
5 Dimension defaults PMIPDimDefaultRuleEntity
Purpose – To import or export data from Dimension default rule setup form.
6 Dimension source PMIPDimSourceEntity
Purpose – To import or export data from Dimension default rule setup form for enum field Source.
7 Facility attribute PMIPFacilityAttributeEntity
Purpose – To import or export data from Facility attribute form used for Qualification view.
8 Facility type PMIPFacilityTypeEntity
Purpose – To import or export data from Facility type form used for Qualification view.
9 Manage subprojects PMIPManageSubprojectEntity
Purpose – To import or export data from Manage subprojects form on projects.
10 Market PMIPMarketEntity
Purpose – To import or export data from Market form used for Qualification view.
11 Pay code PMIPPayCodeTableEntity
Purpose – To import or export data from Pay code form.
12 Personal time off request PMIPPersonalTimeOffRequestEntity
Purpose – To import or export data from Personal time off request.
13 Planned resource forecast PMIPPlannedResourceForecastDataEntity
Purpose – To import or export data from Resource forecast form for planned resource.
14 PMIP_InvAging PMIP_InvAgingEntity
Purpose – To import or export data for Invoice aging .
15 PMIP_ResourceSkillSearchDependentRoleTable PMIP_ResourceSkillSearchDependentRoleTableEntity
Purpose – To import or export data from Dependent role on Setup roles form.
16 Project Contract integration table PMINProjContractIntegTableEntity
Purpose – Used for CRM integration.
17 Project invoicing Archives PMIPInvoicingArchivesEntity
Purpose – To import or export data from Invoice archive tab of project invoice grouping form.
18 Project invoicing group all PMIPProjInvoicingGroupAllDataEntity
Purpose – To import or export data from All tab of project invoice grouping form.
19 Project invoicing group cost PMIPProjInvoicingGroupCostDataEntity
Purpose – To import or export data from Expense tab of project invoice grouping form.
20 Project invoicing group hour PMIPProjInvoicingGroupHourDataEntity
Purpose – To import or export data from Hour tab of project invoice grouping form.
21 Project invoicing group item PMIPProjInvoicingGroupItemDataEntity
Purpose – To import or export data from Item tab of project invoice grouping form.
22 Project invoicing group on-account PMIPProjInvoicingGroupOnAccountDataEntity
Purpose – To import or export data from On-account tab of project invoice grouping form.
23 Project invoicing group revenue PMIPProjInvoicingGroupFeeDataEntity
Purpose – To import or export data from Fee tab of project invoice grouping form.
24 Project type PMIPProjectTypeEntity
Purpose – To import or export data from Project type form used for Qualification view.
25 Project work location PMIPProjWorkLocationSetupEntity
Purpose – To import or export data from Assign work location form on projects form.
26 Projects integration table PMINProjectsIntegrationTableEntity
Purpose – Used for CRM integration.
27 Projects+ integrations parameters PMINCRMIntegrationParameterEntity
Purpose – Used for CRM integration.
28 PSA business unit PMINCRMBusinessUnitMapEntity
Purpose – Used for CRM integration.
29 PSA integration key table PMINIntegrationKeyEntity
Purpose – Used for CRM integration.
30 PSA Resource staging entity PMINCRMResourceStagingEntity
Purpose – Used for CRM integration.
31 PTO balances PMIPPTOBalancesEntity
Purpose – Used to import personal time off balances.
32 Region PMIPRegionEntity
Purpose – To import or export data from Region form used for Qualification view.
33 Resource forecast PMIPResourceForecastV2DataEntity
Purpose – To import or export data from Resource forecast form on projects.
34 Service group PMIPServicesGroupEntity
Purpose – To import or export data from Service group form used for Qualification view.
35 Services PMIPServicesEntity
Purpose – To import or export data from Services form used for Qualification view.
36 Structure attribute PMIPStructureAttributeEntity
Purpose – To import or export data from Structure attribute form used for Qualification view.
37 Structure type PMIPStructuteTypeEntity
Purpose – To import or export data from Structure type form used for Qualification view.
38 Time export lines PMIPTimeExportLineEntity
Purpose – To export data from Time export lines form used for payroll.
39 Timesheet integration PMIPTSTimesheetStagingTableEntity
Purpose – Used for CRM integration.
40 Transaction group PMIPTransactionGroupEntity
Purpose – To import or export data from Transaction group form used for PowerBI reporting.
41 Utilization targets PMIPUtilizationTargetEntity
Purpose – To import or export data from Utilization targets form.
42 Utilization type PMIPUtilizationTypeEntity
Purpose – To import or export data from Utilization type form.
43 Work locations PMIPWorkLocationTableEntity
Purpose – To import or export data from Work locations form.
44 ProjInvoicingGroup PMIPProjInvoicingGroupEntity
Purpose – To import or export data from Project invoicing group form.
45 Project funding source ProjFundingSourceEntity
Purpose – To import or export data from project funding source related to Invoice.
46 PMIPHcmPersonEducationEntity PMIPHcmPersonEducationEntity
Purpose – To import or export data employee education form.
47 Project address PMIPProjectAddressEntity
Purpose – To import or export data project address.
48 Project invoice journal details PMIPProjectInvoiceJourEntity
Purpose – To retrieve project invoices data for our F&O-CE integration.
49 Adjustment request actions PMIPAdjustmentRequestActionsEntity
Purpose – To import or export data from Adjustment request actions setup form.
50 Adjustment request header PMIPAdjustmentRequestHeaderEntity
Purpose – To retrieve header data for an adjustment request from Adjustment request form.
51 Adjustment request lines PMIPAdjustmentRequestEntity
Purpose – To retrieve transaction data for an adjustment request from Adjustment request form.
52 Category reporting group entity PMIPCategoryReportingGroupSetupEntity
Purpose – To import or export category reporting group ID data from Category reporting group setup form.
53 Category reporting groups PMIPCategoryReportingGroupsEntity
Purpose – To import or export category reporting group data from Category reporting group setup form.
54 Contract agreement types PMIPContractAgreementTypesEntity
Purpose – To import or export data from Contract agreement types setup form.
55 Contract agreements PMIPContractManagementAgreementsEntity
Purpose – To import or export contract management header data from Contract management form.
56 Contract agreement lines PMIPContractManagementAgreementLinesEntity
Purpose – To import or export contract agreement lines data from Contract management form.
57 Contract billing frequency PMIPContractBillingFrequencyEntity
Purpose – To import or export contract billing frequency data from Project contracts form.
58 Contract reason codes PMIPContractReasonCodesEntity
Purpose – To import or export data from Contract reason codes setup form.
59 Contract management buckets PMIPContractManagementBucketsEntity
Purpose – To import or export data Contract management buckets setup form.
60 Employee approver assignment PMIPEmployeeApproverEntity
Purpose – To import or export approvers assigned on employee from Employees form.
61 Invoice grouping translations PMIPLanguageTxtTranslationsEntity
Purpose – To import or export invoice translation data from Project invoicing group setup form.
62 Project contract custom PMIPProjectContractDataEntity
Purpose – To import or export billing approvers from the Project contract form.
63 Revenue adjustments PMIPRevenueAdjustmentsEntity
Purpose – To import or export revenue adjustment data from Fee management form.
64 Subcontractors management PMIPSubcontractorsManagementEntity
Purpose – To import or export revenue adjustment data from Contract management form.
65 Project PWP vendor retention setting ProjPWPVendorRetentionSettingEntity
Purpose – To import or export vendor agreement data from projects.
66 Subcontractors accruals PMIPSubcontractorsAccrualEntity
Purpose – To import or export subcontractor accruals data from subcontractor accruals form.
67 Subcontractors accrual line PMIPSubcontractorsAccrualLineEntity
Purpose – To import or export subcontractor accrual lines data from subcontractor accruals form.
Last modified: 18 August 2021

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment