Export Formats
When creating an Export Request, you have to select the Document to Export and the Export Format to control what data is exported and the format of the data. The following lists outline the documents that can be exported from the system. However, your list of available documents is based on the documents that you have access to in security; for more information about security, see Security Overview.
Auto Format
The Auto format option will export all of the fields in the selected document. In addition, it will also include any custom fields.
Documents with Auto Format
The Auto format option is available for the following documents:
|
|
|
Defined Formats
Some documents include defined formats that export a predefined set of fields based on associated business processes. These formats exclude custom fields.
Documents with Defined Formats.
Documents with Defined Formats
Defined formats are available for the following documents:
| Document | Format | Description |
|---|---|---|
| Account Map | General | This format includes all fields in the document. The data hierarchy is flattened for easy sorting and entry. |
| Allocation | Allocation | This format includes all fields in the document. |
| Allocation Entry | Allocation Entry | This format includes all fields in the document. |
| Client | Bill Routings | This format includes the Client Code, Client Name, and the Bill Routing information. |
| Addresses | This format includes Client Code, Client Name, and the Address information. | |
| General | This format includes Client Code, Client Name, and the information from the General area. | |
| Contact | Client Contact Addresses | This format includes the Contact and Client Address information. |
| Personal Addresses | This format includes the Contact and Personal Address information. | |
| Work History | This format includes the Contact and Work History information. | |
| Vendor Contacts | This format includes the contact information for Vendor Contacts. | |
| All Addresses | This format includes all of the address information, which includes the Vendor, Client and Personal addresses for a Contact. | |
| Client Contacts | This format includes the contact information for Client Contacts. | |
| Vendor Contact Addresses | This format includes the Contact and Vendor Address information. | |
| Deposit | General | This format includes all fields in the document. |
| Employee | Companies & Organizations | This format includes Employee Code, Employee Name, Organization Code, Organization Name, Company Code, Company Name. |
| General | This format includes the general information about the employee. | |
| Cost Rates | This format includes Employee Code, Employee Name and the Cost Rate information. | |
| Utilization | This format includes Employee Code, Employee Name, and the Utilization information. | |
| Employee Map | General | This format includes all fields in the document. The data hierarchy is flattened for easy sorting and entry. |
| Expense Adjustment | General | This format includes all fields in the document. |
| Expense Report | Extended | This format includes all fields in the Extended layout. |
| Simple | This format includes all fields in the Simple layout. | |
| Expense Report Category | General | This format includes all fields in the document. |
| Fee Type Map | General | This format includes all fields in the document. The data hierarchy is flattened for easy sorting and entry. |
| General Ledger Entry | General Ledger Entry | This format includes all fields in this document. |
| Journal Entry | Journal Entry | This format includes all fields in the document. |
| Journal Entry 2 | Journal Entry | This format includes all fields in the document. |
| Labor Adjustment | General | This format includes all fields in the document. |
| Opportunity | Contacts | This format includes the Opportunity Code, Opportunity Name, and the Contact information. |
| Simple | This format includes the information from Simple view. | |
| General | This format includes the information from the General tab. | |
| Fees | This format includes the Opportunity Code, Opportunity Name, and the Fee information. | |
| Locations | This format includes the Opportunity Code, Opportunity Name, and the Location information. | |
| Organization Map | General | This format includes all fields in the document. The data hierarchy is flattened for easy sorting and entry. |
| Payroll Hours | General | This format includes Payroll Company Code, Payroll Company Name, Payroll Earning Code, and Payroll Earning Name, and information about the employee, document, hours, rate, and location. |
| Privilege | General | This format includes all fields in the document. |
| Project | Authorizations | This format includes the Project Code, Project Name, Task Code, Task Name, and the Authorization information. |
| Authorization by Organization | This format includes the Project Code, Project Name, Task Code, Task Name, and the Authorization information by organization. | |
| Bill Terms |
This format includes the Project Code, Project Name, and the information from the Bill Term tab. This also includes the Distribution Method in the Surcharges area. |
|
| Contacts & Opportunities | This format includes the Project Code, Project Name, and the contact and opportunity information. | |
| Email Configurations | This format includes the Project Code, Project Name, and a summary of email configurations. | |
| Forecasts | This format includes information from the Forecasts tab. | |
| General | This format includes the information from the General areas. | |
| Locations | This format includes the Project Code, Project Name, and the Location information. | |
| Pricing | This format includes Project Code, Project Name and the information from the Pricing tab. | |
| Tasks | This format includes the Project Code, Project Name, and the information from the Tasks tab. | |
| Purchase Requisition | Purchase Requisition | This format includes all fields in the document. |
| Auto | This format includes information from the Export Filters area. | |
| Resource Pool Map | General | This format includes all fields in the document. The data hierarchy is flattened for easy sorting and entry. |
| Responsibility | General | This format includes all fields in the document. |
| Statistical Ledger Entry | Statistical Ledger Entry | This format includes all fields in the document. |
| Timesheet | Timesheet | This format includes all fields in the document. |
| Unit Adjustment | General | This format includes all fields in the document. |
| Vendor | General | This format includes information from the General area. |
| Addresses | This format includes the Vendor Code, Vendor Name, and the Address information. | |
| Voucher | Voucher | This format includes all fields in the document. |
Transactional Data
Some of the defined formats allow you to export transactional data from system processes. The transactional data comes from the underlying system tables and is read-only and cannot be re-imported.
Note: To access the transactional data defined formats, you will need to manually enable each format in Responsibility (Administration / Document)and assign an access control. For example, select the Export General Ledger Process Documents option to enable the General Ledger Detail format.
Available Transactional Data
The following transactional data formats are available for export:
| Document | Description |
|---|---|
| General Ledger Detail |
This format includes every change applied to any general ledger account balance. These records are never edited and any change to the account balance is represented by a new record. Security Package: Export General Ledger Process Documents |
| General Ledger Summary |
This format includes a summary of General Ledger balances by Company, General Ledger Account, Posting Period, Currency, and transaction nature (Regular, Allocation, and Retained Earnings). Security Package: Export General Ledger Process Documents |
| Payable Detail |
This format includes detailed information of any entry posted to a liability General Ledger Account that has a subsidiary type of Accounts Payable or Intercompany Payable. Security Package: Export Payable Process Documents |
| Payable Summary |
This format includes a summary of payable balances by Company, General Ledger Account, Posting Period, and Currency. The PaymentRequest, DiscountToTakeDC, PaymentDC, PaymentDescription, PaymentGeneration and PaymentInProgressId fields are used during the Payment Request and Payment Generation. If a Payable Summary instance is not in the process of being paid via the Payment Generation process, their values will be Null. Security Package: Export Payable Process Documents |
| Pay When Paid Detail | This format includes Pay When Paid transactional information that is subsequently aggregated and used to populate Pay When Paid Summary. |
| Pay When Paid Summary | This format includes Pay When Paid information about bills, collections, and when a voucher is eligible to be paid to the vendor. |
| Pending Project Detail |
This format includes extra information about all project detail related information from input documents that are still in draft. This includes effort and hours. Security Package: Export Project Process Documents |
| Project Detail |
This format includes extra information about all processed input document lines that are associated to projects. This includes effort, cost and hours. Security Package: Export Project Process Documents |
| Project Task Resource |
This format includes resource management information for a task. For a given project, it has a record of resources assigned to each Task on the project. This document is loaded as part of processing the resource assignment information on the Project, Project Progress and Resource Management documents. The individual assignments related to each resource assigned to a task are stored in the ProjectTaskResourceAssignment. It also has aggregate values related to scheduled hours, cost and effort in various currencies. Security Package: Export Project Process Documents |
| Project Task Resource Assignment Published |
This format includes Project Task Resource Assignment level information published at a point in time. It contains a subset of Project Task Resource Assignment level properties and the Id to the row in the source table ProjectTaskResourceAssignment. Data is written to this table when an assignment related to the resource is marked as 'Published' from the ResourcePlanUpdate document. Security Package: Export Project Process Documents |
| Project Task Summary |
This format includes budget and revenue information summarized by Project, Company, Organization, Posting Period, Budget Category, and Task (Task element). Security Package: Export Project Process Documents |
| Receivable Detail |
This format includes detailed information for any entry posted to a receivable General Ledger Account that has a subsidiary type of Project, Intercompany, or Other Receivable. Security Package: Export Receivable Process Documents |
| Receivable Summary |
This format includes a summary of Receivable balances by Company, General Ledger Account, Posting Period, and Currency. Security Package: Export Receivable Process Documents |
| Staff Utilization |
This format includes source data for Staff Utilization calculation and reports. Security Package: Export Staff Utilization Process Documents |
| Work In Progress Detail |
This format includes detailed information for any entry posted to a General Ledger Account that has a subsidiary type Work In Progress. Security Package: Export Work in Progress Process Documents |
| Work In Progress Summary |
This format includes a summary of Work In Progress balances by Company, General Ledger Account, Posting Period, and Currency. Security Package: Export Work in Progress Process Documents |