[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference acadmy::tpas_notes

Title:	Transfer Price Administration System
Notice:	Conference has moved to ACADMY::TPAS_NOTES
Moderator:	ACADMY::MAGNI

Created:	Wed Jul 01 1992
Last Modified:	Fri Mar 21 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	102
Total number of notes:	459

28.0. "HOW TO DETECT TPAS$DB AND TPAS$STKRM_DB CHANGE?" by SNOC01::TSANGKC () Sun Feb 21 1993 22:31

    As the TPAS$DB and TPAS$STKRM_DB are changed periodically by the Corp
    Tax, how do we know what have been changed each update?
    
    Would there any SQL tool available to check them out? If yes, how to
    locate one?
    
    Regards,
    KC

T.R Title User Personal
Name Date Lines

28.1 SR Reports Available, TPAS$DB reports maybe mailed AWARD::MAGNI IM&T - 223-9837 Mon Feb 22 1993 13:24 24

T.R	Title	User	Personal Name	Date	Lines
28.1	SR Reports Available, TPAS$DB reports maybe mailed	AWARD::MAGNI	IM&T - 223-9837	`Mon Feb 22 1993 13:24`	24
	KC, The sources of the TPAS data are different. The stockroom data, TPAS$STKRM_DB, is obtained from Corp Cost Accounting. We copy the NEWSRCTLTAB.DAT in RMS format and move it to an RDB database. The Corp Cost Accounting group creates reports identifying all changes for the month. The STOCKROOM CONTROL TABLE CHANGE report is available in : MILPND::GRO7:[060TRANS.REPORTS]TABSC004.RPT There are other reports also available in this area. Diane Nickson or Don Shea are the contacts for this data. The TPAS$DB, PRICING_TABLE, DISCOUNT_TABLE and TRNSFR_AREA_TABLE, is from Corp Tax. This data is specifically for calculating Transfer Area Prices. I believe that Corporate Tax mails out the changes that will be occuring. I will verify this and post it here. Barbara Wilfand and Tracy Walker are the contacts for this data. As for an SQL tool to note the differences we have not written any reporting feature. But it will be taken as input . regards, Lois

KC,

The sources of the TPAS data are different. 

The stockroom data, TPAS$STKRM_DB, is obtained from Corp Cost Accounting.
We copy the NEWSRCTLTAB.DAT in RMS format and move it to an RDB database.
The Corp Cost Accounting group creates reports identifying all changes for
the month. The STOCKROOM CONTROL TABLE CHANGE report is available in :
     MILPND::GRO7:[060TRANS.REPORTS]TABSC004.RPT
There are other reports also available in this area. Diane Nickson or 
Don Shea are the contacts for this data.
  
The TPAS$DB, PRICING_TABLE, DISCOUNT_TABLE and TRNSFR_AREA_TABLE, is from 
Corp Tax. This data is specifically for calculating Transfer Area Prices.
I believe that Corporate Tax mails out the changes that will be occuring. 
I will verify this and post it here. Barbara Wilfand and Tracy Walker are
the contacts for this data.


As for an SQL tool to note the differences we have not written any
reporting feature. But it will be taken as input .

regards,
Lois