TELECOM_INVOICE_SUMMARY Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

TELECOM_INVOICE_SUMMARY Table

Explanation
Contains Telecommunications charge data, comprised of invoice totals, invoice and accounting dates, originating location information, phone number or user id, and account combination segments by accounting period. This data comprises the Telecommunications feeder aggregated amounts which are posted to the General Ledger on a monthly basis.

Common Uses
Reporting on Telecommunications charge data for a given ORG or other accounting segment, for a given time period.

ACCOUNTING_PERIOD
COA_ACCOUNT
ISC_INVOICE_NUMBER
ITEM
TRANSACTION_SEQ

ACCOUNTING_PERIOD
CALENDAR_MONTH
CALENDAR_YEAR
COA_ACCOUNT
COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_PROGRAM
COA_RESPONSIBLE_ORG
CYCLE_END_DATE
CYCLE_START_DATE
FISCAL_MONTH_SEQ
FISCAL_YEAR
ISC_INVOICE_NUMBER
ITEM
SERVICE_ID
TRAN_CODE
TRANSACTION_SEQ

BALANCES
CENTER_REF_CODES
CNAC_CODES
FUND_CODES
GL_DETAIL
OBJECT_CODES
ORG_CODES
PARENT_CNAC_CODES
PARENT_FUND_CODES
PARENT_OBJECT_CODES
PARENT_ORG_CODES
PARENT_PROGRAM_CODES
PROGRAM_CODES
TELECOM_CALL_DETAIL

• The Cycle_Start_Date and Cycle_End_Date represent the time period for which the item was billed; the Invoice_Date, Accounting_Period and corresponding fiscal/calendar year information indicate the point at which the feeder containing this data was posted to the General Ledger.
• Telecommunications charge and detail data are available (in the DWCHG schema in the Data Warehouse) from fiscal year 2006 (the JUL-05 period) and on.

TELECOM_INVOICE_SUMMARY Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home