Export Tool: Export Areas

Export area	Tables	Table Friendly Names
1099 Types	t1099	1099 Types Table
Account (Account List)	account	Account List
Account Approval	appracct	Account Approval
Alternate Vendor Address	alt_vend_addr	Alternate Vendor Address
Bank Table	bnktable	Bank Table
Batch Encumbrance	dencumbr	Batch Encumbrances
Batch Journal Entries	djournal	Batch Journal Entries
Batch Manual Check	dmanchk	Batch Manual Checks
Batch Payable	dpayable	Batch Payments
Batch Receipt	dreceipt	Batch Receipts
Batch Receivable	dreceive	Batch Receivables
Batch Vendor	dvendor	Batch Vendor
Encumbrance Ledger	encledgr	Encumbrance Ledger
Expenditure and Encumbrance Ledger	encledgr expledgr	Encumbrance Ledger Expenditure Ledger
Expenditure Budget Ledger	expbudgt orgn account	Expenditure Budget Ledger Organization Chart Account List
Expenditure Ledger	expledgr orgn account	Expenditure Ledger Organization Chart Account List
General Ledger	genledgr orgn account	General Ledger Organization Chart Account List
Organization	orgn	Organization Chart
Payable	payable	Payment Entries
Payer	payer	Payer
Project	project	Project List
Project Ledger	proledgr project account	Project Ledger Project List Account List
Receivable Ledger	recledgr orgn account	Receivables Ledger Organization Chart Account List
Revenue Ledger	revledgr orgn account	Receivables Ledger Organization Chart Account List
Shipping	shipping	Shipping Table
Standard Payable	spayable	Standard Repetitive Payable Entries
Transaction	transact	Transactions
Vendor Audit Trail	venact	Vendor Audit Trail
Vendor Details	vendor venclass vendaddr vnd_misc	Vendor Vendor Classes Alternate Order Address Vendor Miscellaneous
Vendor Only	vendor	Vendor

Export area	Tables	Table Friendly Names
Approval Group	approval	Approval Table
Change Order	chgorder	Change Order
Commodity Code	commod	Commodity
Purchase	purchase	Purchase Order Header
Purchase Detail	purchase purcomm purchrg	Purchase Order Header Purchase Order Item Purchase Order Charge
Purchase Transact (Transaction)	purchase transact	Purchase Order Header Transactions
Purchasing Price History	purchase purcomm commod vendor	Purchase Order Header Purchase Order Item Commodity Vendor
Requisition	requisit	Requisition Header
Requisition Detail	requisit reqcomm reqchrg	Requisition Header Requistion Item Requisition Charge

Export area	Tables	Table Friendly Names
1095 Maintenance	aca_employee aca_employer	Employee 1095
1099-R Processing	wrk1099r	Workfile for 1099 R
ACA Hours	employee hrm_aca_hours payrate payroll person	Employee Employee ACA Hours Information Employee Pay Rate Information Payroll Employee Personnel Information
Advanced Pay	adv_pay	Advanced Pay
Assignment Table	asntable	Assignment Table
Attendance	attend	Employee Attendance
Batch Continuing Education Detail	bemp_course_dtl	Batch Continuing Education Details
Batch Deduction	bdeduct	Batch Deduction
Batch Demographic	bdemo	Batch Demographics
Batch Employee Status Update	bchgstat	Batch Status
Batch Payrate	bpayrate	Batch Pay Rate
Batch Position	bposition bposn_data2 bposn_data3 bposn_cert bposn_qual bposn_req	Batch Position Batch Position Title Batch Position Title Position Certification Position Qualification Position Requirement
Batch Salary Schedule	bshdtable	Batch Schedule Table
Batch Tax Information	btaxinfo	Batch Tax Info
Benefit Charge Override	ben_chrg_override	Benefits Charge Override
Calendar Table	calendar	Calendar Table Header
Course Detail (Professional Development)	pd_course_mstr	Course Detail
Course Information	employee stu_course stu_qualif stu_staff	Employee Course Information Course Qualification Course Staff
Deduction Table	dedtable	Deduction Table
Department Table	dept	Department Table
Detail Distribution	detdist checkhis	Employee Detail Distributions Check History Header
Employee Activity	empact	Employee Audit Trail
Employee Activity Tracker	employee pat_act	Employee Activity Tracker
Employee Check History	employee checkhis	Employee Check History Header
Employee Check History Detail	employee checkhis checkhi2	Employee Check History Header Check History Detail
Employee Continuing Ed Detail	emp_course_dtl emp_course_costs emp_course_cred emp_course_goal emp_course_topic emp_course_misc	Continuing Education Details Continuing Eduction Costs Continuing Education Credits Continuing Education Goals Continuing Education Subject Areas Continuing Education Misc Information
Employee Contract	econtdef econtempl person_cont_type	eContracts Definition Employee Contract Detail Employee Contract Type
Employee Deductions	employee deduct person dedtable	Employee Employee Deductions Employee Personnel Information Deduction table
Employee Details	employee payrate payroll person assignment deduct emp_certificate emp_degree empuser pat_act	Employee Employee Pay Rate Information Payroll Employee Personeel Information Assignments Employee Deductions Employee Certificates Employee Degrees Employee User Defined Activity Tracker
Employee Details with Distribution	employee payrate payroll person assignment deduct emp_certificat emp_degree empuser empl_races emp_credential emp_qual_notes emp_qualify emp_require w4lockin	Employee Employee Pay Rate Information Payroll Employee Personeel Information Assignments Employee Deductions Employee Certificates Employee Degrees Employee User Defined Employee Race Employee Credential Employee Qualification Notes Employee Qualification Employee Requirement W-4 Lock-in
Employee Groups	employee payrate payroll person assignment deduct emp_certificat emp_degree empuser pat_act newhire	Employee Employee Pay Rate Information Payroll Employee Personeel Information Assignments Employee Deductions Employee Certificates Employee Degrees Employee User Defined Activity Tracker New Hire
Employee History	hemployee	Payroll History - Employee Record
Employee Only	employee	Employee
Employee Paycode	employee paycode	Employee Earnings by Pay Code
Employee Payrate	employee payrate payroll	Employee Personeel Information Employee Pay Rate Information Payroll
Employee Payrate Custom	person empl_races payroll payrate clstable paytable	Employee Personeel Information Employee Race Payroll Employee Pay Rate Information Job Class Table Pay Code Table
Employee Payrate Deduction	employee deduct payrate payroll	Employee Employee Deductions Employee Pay Rate Information Payroll
Employee Payrate Job Class Table	employee clstable payrate	Employee Job Class Table Employee Pay Rate Information
Employee Payrate Pay Table	employee payrate paytable	Employee Employee Pay Rate Information Pay Code Table
Employee Personnel	employee person	Employee Employee Personeel Information
Employee Personnel Attendance	employee person attend	Employee Employee Personeel Information Employee Attendance
Employee Personnel Certificate	employee person	Employee Employee Personeel Information
Employee Personnel Payrate Degree	employee payroll person	Employee Payroll Employee Personeel Information
Employee Personnel Payroll	employee payroll person	Employee Payroll Employee Personeel Information
Employee Personnel Payroll Payrate Job Class	employee payroll person	Employee Payroll Employee Personeel Information
Employee Status History Information	employee person stathist	Employee Employee Personeel Information Employee Status History Information
Employee W2	w2employee	W2 Employee
Future Deductions	bdedtable	Batch Deduction Table
Human Resources Location	hrm_locn crdc_locn	Employee Location CTDC link to Location Table
Leave Table	t_levtable levtable crdc_levtable	Pay Code link to Leave Table Leave Code Table CRDC link to Leave Table
Pay Code Table	paytable	Pay Code Table
Paygroups	paygroups	Pay Run Pay Group Parameters
Payrate History	payrhist	Pay Rate History
Payroll Check History	checkhis	Check History Header
Payroll Check History Detail	checkhi2 checkhis	Check History Detail Check History Header
Payroll Check Reconciliation	checkrec	Check Reconciliation
Payroll Payrate	payroll payrate	Payroll Employee Pay Rate Information
Personnel	person	Employee Personeel Information
Position	positiondata posn_data2 posn_data3 posn_cert posn_req posn_qual	Position Title Position Position Position Certification Position Requirement Position Qualification
Position History	posnhist	Position History
Redistribution	detdist employee orgn	Employee Detail Distributions Employee Organization Chart
Salary Schedule	shdtable	Salary Scheudle Table Header
School Table	school	Degree School table
Timecard	timecard payroll	Time Card Table Payroll
Timecard Payrate	timecard payroll employee payrate	Time Card Table Payroll Employee Employee Pay Rate Information
Workers Compensation	wkrtable	Workers' Compensation Table
Workers Compensation Department	wkrdept	Workers' Compensation Table Detail

Export area	Tables	Table Friendly Names
Budget Account	budacct	Budget Accounts
Budget Expenditure Ledger	bexpledgr budacct budorgn	Expenditure Budget File Budget Accounts Budget Organization Chart
Budget Organization	budorgn	Budget Organization Chart
Budget Project	budproj	Budget Projects
Budget Project Ledger	bproledgr budacct budproj	Expenditure Budget File Budget Accounts Budget Projects
Budget Project Title	bproj_title	Budget Project Titles
Budget Revenue Ledger	brevledgr budacct budorgn	Revenue Budget Ledger Budget Accounts Budget Organization Chart
Iteration	iteration	Iteration Table
Iteration Audit	it_audit	Iterations Audit File
Iteration Phase	it_phase	Iteration Phase Table
Iteration Status	it_stat	Iteration Status File

Export area	Tables	Table Friendly Names
Asset	assets multiasset	Assets Multiple Asset
Asset Activity	activtbl	Activity Table
Asset Category	category	Asset Category
Asset Department	department	Department Table
Asset Function	functbl	Function Table
Asset History	assets multiasset fxhist	Assets Multiple Asset Asset Audit Trail
Asset Location	fix_locn	Asset Location
Asset Only	assets	Assets
Batch Asset Update	b_asset	Batch Assets
Depreciation	dephist	Deprecation History
Fund Source	source	Funding Source
GASB Fixed Asset	gasb_fx	GASB Tracking
Purchase Interface	assetif	Purchase Order Interface

Export area	Tables	Table Friendly Names
Budget Job Class	pclstable pclstable_data2	Budget Job Classes
Employee Budget	budpayr pclstable ppaytable	Budget Pay Rates Budget Job Classes Budget Pay Codes
PBS Pay Code Table	ppaytable	Budget Pay Codes
Position Budget	pclstable pposition	Personnel Budgeting Position Table Budget Job Classes

Export area	Tables	Table Friendly Names
Batch Beneficiaries	bbenefici	Batch Beneficiaries
Batch Benefits	bbenefits	Batch Benefits
Batch Dependents	bdependent	Batch Dependents
Benefits Table	bentable	Benefits Table
Employee Benefits	employee person emplinfo	Employee Employee Personeel Information Employee Information

Export area	Tables	Table Friendly Names
Inventory	invtory invlocn invcomm	Warehouse Inventory Table Warehouse Location Table Warehouse Stock Table
Inventory Usage	invuse invcomm invlocn shipping	Inventory Usage Warehouse Stock Table Warehouse Location Table Shipping Table
Shipping	shipping	Shipping Table
Warehouse Batch Request	dinvreq dinvreqcom invlocn invcomm shipping	Batch Request Header Batch Request Detail Warehouse Location Table Warehouse Stock Table Shiping Table
Warehouse Location	invlocn	Warehouse Location Table
Warehouse Requests	invreq invrecom invlocn invcomm shipping	Warehouse Request Header Warehouse Request Detail Line Items Warehouse Location Table Warehouse Stock Table Shipping Table
Warehouse Stock	invcomm	Warehouse Stock Table

Export area	Tables	Table Friendly Names
Activity Codes	stuact_code	Activity Codes
Activity Sponsors	stuact_sponsor	Sponsor
Student Activity Location Activity	stuact_locn_act stuact_code sectb_user	Activity Codes Location Activity User

Export area

Tables

Table Friendly Names

Activity Codes

stuact_code

Activity Codes

Activity Sponsors

stuact_sponsor

Sponsor

Student Activity Location Activity

stuact_locn_act

stuact_code

sectb_user

Activity Codes

Location Activity

User

Export area	Tables	Table Friendly Names
Adjustments	cmrhistory	History Information
Applied Credits	cmrapcrhead	Applied Credit Header
Batch Invoice	cmrbinvdetl cmrbinvhead cmrcustomer cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Batch Invoice Detail Batch Invoice Header Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers
Billing Adjustments	cmrcustomer cmrobajhead cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Billing Adjustment Header Information Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers
Cash Receipts	cmrrcpthead	Receipt Header
Category Code	cmrcategory	Category Codes
Customer History	cmrcustomer cmrhistory cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers History Information
Customer Master	cmrcustaddr cmrcustbill cmrcustomer cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Billing Information Customer Information Customer Service Address Entities Entity Addresses Entity Contact Entity Phone
Customer Notes	cmrcustbill cmrcustomer cpbentity cpbentity_addr cpbentity_contact cpbentity_phone libnotedtl libnotehdr	Customer Billing Information Customer Information Customer Service Address Entities Entity Addresses Entity Contact Entity Phone
Customer Service	cmrcustomer cmrcustservice cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Address Entity Contacts Entity Phone Service Record
Customer Type	cmrclnttype	Client Types
Dist Details	cmrdistdesc cmrdistdetl	Distribution Code Header Distribution Detail
Dunning Code	cmrdunning	Dunning Messages
Interest Code	cmrinterest	Interest Codes
Item Code	cmrbillitem	Billing Item Information
Journal Entries	cmrjournal	Audit Trail Record
Mass Invoice	cmrminvdetl cmrminvhead	Mass Invoice Detail Record Mass Invoice Header Record
Online Invoice	cmrcustomer cmroinvdetl cmroinvhead cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers Invoice Details Invoice Headers
Payment Adjustments	cmrcustomer cmrpadjhead cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers Payment Adjustment Header Information
Penalty Code	cmrpenalty	Penalty Codes
Receipt Numbers	cmrrcpthead	Receipt Header
Recurrent Invoice	cmrcustomer cmrrinvdetl cmrrinvhead cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Address Entity Contacts Entity Phone Numbers Recurrent Invoice Detail Recurrent Invoice Header
Refunds Applied	cmrcustomer cmrrefund cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers Refund Information
Service Code	cmrservice	Service Information
Tax Code	cmrsalestax	Sales Tax Coes
Term Codes	cmrterms	Term Codes
Writeoff Adjustments	cmrcustomer cmrowofhead cpbentity cpbentity_addr cpbentity_contact cpbentity_phone	Customer Information Entities Entity Addresses Entity Contacts Entity Phone Numbers Write Off Header Information

Export Area	Tables	Table Friendly Names
Workflow Applications	Workflow Task Rule Group	Employee User Defined Screens Workflow Application Workflow Groups Workflow Roles Workflow Tasks Workflow Task Rule Group Workflow Udf Task Mapping
Workflow Groups	Global Search Workflow Groups	Global Search Workflow Groups
Workflow Roles	Workflow Role Members Workflow Roles	Workflow Role Members Workflow Roles

Export Area

Tables

Table Friendly Names

Workflow Applications

Workflow Task Rule Group

Employee User Defined Screens

Workflow Application

Workflow Groups

Workflow Roles

Workflow Tasks

Workflow Task Rule Group

Workflow Udf Task Mapping

Workflow Groups

Global Search

Workflow Groups

Global Search

Workflow Groups

Workflow Roles

Workflow Role Members

Workflow Roles

Workflow Role Members

Workflow Roles

Fund Accounting

Purchasing

Human Resources

Budget Preparation

Fixed Assets

Personnel Budgeting

Benefits

Warehouse Inventory

Student Activities

Billing and Receipts (Miscellaneous Billing)

System Administration