| Table Name and Description |
| dbo_DW_FYcurrent_Tran_PJL_ACTUAL_v |
|
|
Provides current fiscal year posted
journal line information for amount class type ACTUAL; including
UDAK, journal ID#, transaction amount, posting year and
month. |
| dbo_DW_FYcurrent
_P01_PJL_ACTUAL thru dbo_DW_FYcurrent
_P12_PJL_ACTUAL |
| |
Posted journal line information
(actual transactions) for each month of the current fiscal
year. |
| dbo_DW_FYcurrent_Tran_PJL_v |
| |
Posted journal line transactions
for current fiscal year including Actual and Budfund for
all periods |
| dbo_DW_FYTD_Tran_ACTUAL_v |
| |
Current fiscal year transactions
(posted journals) for Actuals only (not Budfund); including
UDAK, journal ID, posting period, transaction amount. |
| dbo_DW_FYcurrent_Tran_Invoice_v
|
| |
Provides current fiscal year transaction
information (posted journal lines/invoices); including UDAK,
journal id#, invoice number, pmt request voucher number(PO,
DV, Release #, etc.) |
| dbo_DW_LTD_Tran_Invoice_v |
| |
Provides life-to-date(SmartStream
LTD) invoice transaction information: including invoice
number, check number, pmt request voucher number(PO, DV,
Release #, etc.). |
