DARKWING Table Descriptions

Notes
Click the table link to view the field list with descriptions.
LTD- SmartStream life-to-date beginning July fiscal year 1998.  
All tables are updated nightly.  
Table Name and Description
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.).
dbo_DW_FY####_Tran_Invoice_v
  Provides fiscal year invoice and posted journal transaction information: including invoice number, check number, pmt request voucher number(PO, DV, Release #, etc.), journal id. There are tables for FY2000, FY1999 and FY1998.