ABC
1
This worksheet lists commonly used records. It includes one data table beginning at cell A2.
2
Subject Matter AreaRecordDescription
3
RequisitionsREQ_HDRHeader record for requisition.
4
RequisitionsREQ_LINELine record for requisition.
5
RequisitionsREQ_LINE_DISTRIBAccounting distribution for requisition.
6
RequisitionsREQ_LINE_SHIPShipment details for requisition.
7
Purchase OrdersPO_HDRHeader record for purchase order.
8
Purchase OrdersPO_LINELine record for purchase order.
9
Purchase OrdersPO_LINE_DISTRIBAccounting distribution for purchase order.
10
Purchase OrdersPO_LINE_MATCHEDMatching information for purchase order (voucher, receipt, purchase order).
11
Purchase OrdersPO_LINE_SHIPShipment details for purchase order.
12
VouchersVOUCHERHeader record for requisition.
13
VouchersVOUCHER_LINELine record for requisition.
14
VouchersDISTRIB_LINEAccounting distribution for requisition.
15
ReceiptsRECV_HDRReceipt header record.
16
ReceiptsRECV_LN_DISTRIBReceipt distribution line.
17
ReceiptsRECV_LN_ASSETReceipt line asset information.
18
ReceiptsRECV_LINE_SHIPReceipt shipment information.
19
Travel AuthorizationsEX_TAUTH_HDRHeader record for TAR.
20
Travel AuthorizationsEX_TAUTH_LINELine record for TAR.
21
Travel AuthorizationsEX_TAUTH_DISTAccounting distribution for TAR.
22
Expense ReportsEX_SHEET_HDRHeader record for expense report.
23
Expense ReportsEX_SHEET_LINELine record for expense report.
24
Expense ReportsEX_SHEET_DISTAccounting distribution for expense report.
25
Cash AdvancesEX_ADV_HDRHeader record for advances.
26
Cash AdvancesEX_ADV_LINELine record for advances.
27
Cash AdvancesEX_ADV_DISTAccounting distribution for advances.
28
VendorsVENDORMain vendor table; important fields include vendor ID, vendor names, vendor classifications, vendor status.
29
VendorsVENDOR_LOCLocation information for each vendor.
30
VendorsVENDOR_ADDRAddress information for each vendor.
31
EndowmentsUM_ENDOW_ACCT_VWEndowment accounting (ChartField) information.
32
EndowmentsUM_ENDOW_HDR_VWHeader record for endowments.
33
EndowmentsUM_ENDOW_ POS_VWEndowment market value, book value and number of shares.
34
EndowmentsUM_ENDOW_TXN_VWEndowment transaction detail.
35
PaymentsPAYMENT_TBLDetail of each payment generated from the Accounts Payable pay cycle. Includes fields such as check #, payment #, vendor paid, employee ID paid (from expenses), address and method of payment, payment status (e.g., cancelled, scheduled).
36
PaymentsPYMNT_VCHR_XREFAccounts Payable detail (e.g., voucher ID) related to a specific payment.
37
PaymentsEX_ADVNCE_PYMNTCash advance detail related to a specific payment.
38
PaymentsEX_SHEET_PYMNTExpense report detail related to a specific payment.
39
UM Reports - SponsoredPROJ_RESOURCE, UM_HR_ACCT_LINE, LEDGER_KK Budget, expense, requisition, encumbrance and reversal data used in: Sponsored Transaction Detail report, Sponsored Transaction Detail – Expenses report.
40
UM Reports - Non-SponsoredLEDGER_BUDG, LEDGER_KK, LEDGERBudget data, encum./pre-encum. data and actual values used in: Account Budget Status for Current Non-Sponsored Funds report, Chartfield String Budget Status for Current Non-Sponsored Funds report.
41
UM Reports - Non-SponsoredUM_FUND_CATEGORY, LEDGER_KK, LEDGERDetail of budget, expense Transaction Detail for Current Non-Sponsored Funds.
42
General LedgerJRNL_HEADERHeader record for journal; important fields include JOURNAL_ID, JOURNAL_DATE, JRNL_HDR_STATUS, BUDGET_HDR_STATUS, DESCR254.
43
General LedgerJRNL_LNLine record for journal; important fields include journal ID, journal line #, ChartField strings, budget line status, distribution amounts, budget dates, close flag.
44
General LedgerLEDGERSummary of balances by ChartFields by fiscal year, accounting period.
45
Asset ManagementBookThe record has the financial asset book transactions; important fields include BU, asset #, book, Begin_Depr_Dt.
46
Asset ManagementCOSTThe record has the asset cost transactions; important fields include asset #, book, Group_Asset_ID, category, cost type, cost.
47
Asset ManagementASSETThe primary asset record populated when an asset is created; important fields include asset #, tag, description, acquisition dates, serial #, profile.
48
Asset ManagementDEPRECIATIONThe record has the depreciation transactions; important fields include BU, asset #, book, Start_PD, End_PD, Trans_Dt.
49
ChartField InformationDEPT_TBLDepartment information.
50
ChartField InformationPROJECTProject information.
51
ChartField InformationGL_ACCOUNT_TBLAccount information.
52
ChartField InformationFUND_TBLFund information.
53
ChartField InformationPROGRAM_TBLProgram information.
54
ChartField InformationCHARTFIELD1_TBLChartField 1 information.
55
ChartField InformationCHARTFIELD2_TBLChartField 2 information.
56
ChartField InformationCHARTFIELD3_TBLFIN EmplID information.
57
Grants, Projects, and ContractsCA_DETAIL_PROJLinks to contracts/”awards.”
58
Grants, Projects, and ContractsCA_CONTR_HDRHeader record for contract.
59
Grants, Projects, and ContractsPROJECTStores the project information when a new project is created, keyed by business unit.
60
Grants, Projects, and ContractsPROJ_RESOURCEGives the budget and expense information for every project in the system.
61
Grants, Projects, and ContractsGM_AWARDHeader record for purchase order.
62
Grants, Projects, and ContractsGM_PROPOSALHeader record for proposal.
63
BillingBI_HDRHeader record for customer bill.
64
BillingBI_LNLine information for customer bills.
65
BillingBI_ACCT_ENTRYAccounting information for bills.
66
CustomersCUSTOMERCustomer details.
67
CustomersADDRESSCustomer address data information.
68
CustomersCUST_CONTACTCustomer contact information.
69
Payments (Billing)DEPOSIT_CONTROLLists the customer deposit information; Deposit_Bu and Deposit_ID are keys.
70
Payments (Billing)PAYMENTLists the payment information of the customer.
71
Payments (Billing)UM_PYMT_ID_VWPayment customer identification.
72
Payments (Billing)PAYMENT_ID_ITEMPayment item identification.
73
ReceivablesITEMHeader record for the receivable items.
74
ReceivablesITEM_ACTIVITYDetail line information of receivable items.
75
ReceivablesITEM_DSTCustomer item distribution information.
76
ReceivablesCUST_DATADetails specific to customer balance, last payment, last aged.
77
ReceivablesCUST_AGINGSpecific details of aging ID, aging amount, count, etc.
78
Interface to GL RecordsVCHR_ACCTG_LNSubsystem: Accounts Payable. Key Field: VOUCHER_ID.
79
Interface to GL RecordsEX_ACCTG_LINESubsystem: Expenses. Key Field: EX_DOCID (sheet ID).
80
Commitment ControlLEDGER_KKSummary of balances by ChartFields by fiscal year, accounting period. Similar to LEDGER record with the additional field, for budget period.
81
Controller’s Office Financial Training. Financial Helpline controller@umn.edu