ABCDE
1
This worksheet lists detailed information that posts to the General Ledger by module. It includes one data table beginning at cell A2.
2
Source (Module)Source DocumentDetail Information FieldSummaryInquiry Path
3
AM (Asset Management)Asset ID.Transaction type, Asset description.Asset Management detail information.Asset Management > search for an asset
4
AP (Accounts Payable)Voucher ID.Vendor number, Vendor name, PO number.Voucher encumbrance.Accounts Payable > Review Accounts Payable > Vouchers > Voucher
5
AP-PCARD (Accounts Payable)Voucher number.Employee name, Barcode number.The barcode number consists of the following information concatenated together: employee ID, last 4 digits of the card number, and billing date in mmddyyy format.
Example: 1645050545407252008		Accounts Payable > Review Accounts Payable > Vouchers > Voucher
6
AP-PREPCARD (Accounts Payable)Voucher number.Invoice number, Invoice date.PCard prepayment invoice.Accounts Payable > Review Accounts Payable >Payments > Prepayments
7
AP-XXXX, where XXXX= business unit (Accounts Payable), Example: AP-UMN01, AP-UMNISVoucher number.Vendor number, Vendor name, PO_number.Voucher detail.Accounts Payable > Review Accounts Payable > Vouchers > Voucher
8
AR (Accounts Receivable)Item number.N/A.AR item detail information.Billing > Review Billing Information > Review Entries by Invoice
9
AR (Accounts Receivable)Deposit ID.Line description.AR deposit detail information.Accounts Receivable > Payments > Review Payments > All Deposits
10
BI (Billing)Invoice number.N/A.Billing detail.Billing > Review Billing Information > Review Entries by Invoice
11
EX_CA (Travel and Expense)Expense report ID.Employee number, Employee name.Cash advance detail.Travel and Expense Center > Cash Advances > View
12
EX-ER
(Travel and Expense)		Expense report ID.Employee number, Employee name, Travel authorization number.Expense report detail.Travel and Expense Center > Expenses > View
13
EX-ER
(Travel and Expense)		Report ID sheet number.Employee number, Employee name, Travel authorization number.Expense report encumbrances.Travel and Expense Center > Expenses > View
14
EX-TA
(Travel and Expense)		Travel authorization number.Employee number, Employee name.Travel authorization encumbrances.Travel and Expense Center > Travel Authorizations > View
15
EXTERNALTransaction number.Line description.External detail.N/A.
16
GL (General Ledger)Journal number.Line description, Journal line reference.Manual journal entries.General Ledger > Review Financial Information > Journals
17
GL (General Ledger)Journal number.Journal description.Journal pre-encumbrances and journal encumbrances.General Ledger > Review Financial Information > Journals
18
GM (Grants Management)Contract number.N/A.Grants management detail information.N/A.
19
HR (HRMS)If the journal ID begins with “HSA,” then the journal line reference is provided. If the journal ID does not begin with “HSA,” then the journal generator description is provided.If the journal ID begins with “PCD,” then the journal line reference is provided. If the journal ID does not begin with “PCD,” then the journal generator description is provided.HR detail information.Human Resources Management System (HRMS)
20
PO (e-Procurement)Requisition number.N/A.Requisition pre-encumbrances.e-Procurement > Manage Requisition
21
PO (e-Procurement)PO number.Vendor number, Vendor name, Requisition number.Purchase order pre-encumbrances.e-Procurement > Buyer Center
22
PO (e-Procurement)PO number.Vendor number,
Vendor name, Requisition number.		Purchase order encumbrances.e-Procurement > Buyer Center
23
HR (HRMS)Journal generator description.If reversing encumbrance – line description. If encumbrance – line description and journal line reference.Payroll encumbrances.Human Resources Management System (HRMS)
24
SA/SF (Student Financial System)Run date, Sequence number.Line description.Student detail info.Student Financial System
25
TR (Cash Management)Accounting ID.Transaction description.Treasury.Cash Management > Treasury and Accounting > Accounting Entries
26
Controller’s Office Financial Training. Financial Helpline controller@umn.edu