[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

46.0. "How to Pull NOR & APPIX database files" by PASM01::ANDREWKAN () Mon Oct 24 1994 00:10

Our organization, Asia Logistics in Hong Kong, is planned to implement
TPAS-2 in January-March 1995 time frame.  We completed feasibility study
and preliminary program specifications last month.  

At this moment, we are looking into the procedures/steps to pull NOR 
and APPIX databases.  Because our site is a new TPAS-2 site, please
provide us information on how to prepare/setup to pull NOR and APPIX 
database files.  Thanks.


Regards,


Andrew Kan

Asia Logistics

T.R Title User Personal
Name Date Lines

46.1 Database/file procedures/regimines AWARD::MAGNI IM&T - 223-9837 Mon Oct 24 1994 10:32 56

T.R	Title	User	Personal Name	Date	Lines
46.1	Database/file procedures/regimines	AWARD::MAGNI	IM&T - 223-9837	`Mon Oct 24 1994 10:32`	56
	Andrew, The procedures and regimine for the TPAS II databases are as follows: AMP - If opting to use the AMPs data file send a mail request to ACADMY::QCA_ADMIN requesting registration for AMPs. Once you have registered you will receive an initial "MASS" load of the AMP data. After that you will receive daily files (5 times a week) with records that were updates/added to the CPRS (APPIX) database. The command streams, software and documentation are provided for both the mass load and the daily loads of the AMPs file locally. PPCS - If opting to use PPCS, Part and Product Client/Server, mail a request to ACADMY::QCA_ADMIN requesting the PPCS software. You will need to fill a registration. The software and documentation will be provided. There will be no local database or data file needed for part information. TPAS$DB - This database will be re-created monthly. The command streams to pull and populate, and the documentation are provided in the TPAS Kit. The site installing TPAS are given instructions to put the command streams in production as well as the process for requesting a proxy. The SQL Export file is made available for sites to pull the last fiscal THURSDAY of the month. This RBR file should be put in place for the begining of the fiscal month. TPAS$STKRM_DB - This database will be re-created monthly. The command streams to pull and populate, and the documentation are provided in the TPAS Kit. The site installing TPAS are given instructions to put the command streams in production as well as the process for requesting a proxy. The SQL Export file is made available for sites to pull the last fiscal SATURDAY of the month. This RBR file should be put in place for the begining of the fiscal month. TPAS$NOR$DB - This database will be re-created monthly. The command streams to pull and populate, and the documentation are provided in the TPAS Kit. The site installing TPAS are given instructions to put the command streams in production as well as the process for requesting a proxy. The RMU Unload file is made available for sites to pull the last fiscal THURSDAY of the month. This UNL file should be put in place for the begining of the fiscal month.

Andrew,

The procedures and regimine for the TPAS II databases are as follows:

 	AMP     -  If opting to use the AMPs data file send a 	
		   mail request to ACADMY::QCA_ADMIN  requesting
		   registration for AMPs.  Once you have registered
                   you will receive an initial "MASS" load of the 
		   AMP data. After that you will receive daily files
	 	   (5 times a week) with records that were updates/added
		   to the CPRS (APPIX) database.
		   The command streams, software and documentation are 
		   provided for both the mass load and the daily loads
		   of the AMPs file locally.

	PPCS    -  If opting to use PPCS, Part and Product Client/Server,
		   mail a request to ACADMY::QCA_ADMIN requesting 
		   the PPCS software. You will need to fill a registration. 
	   	   The software and documentation will be provided. There
		   will be no local database or data file needed for part 
 		   information.

	TPAS$DB -  This database will be re-created monthly. The command
		   streams to pull and populate, and the documentation are 
                   provided in the TPAS Kit.
		   The site installing TPAS are given instructions to 
 		   put the command streams in production as well as the
		   process for requesting a proxy.
		   The SQL Export file is made available for sites to pull
		   the last fiscal THURSDAY of the month. This RBR file 
	 	   should be put in place for the begining of the fiscal 
		   month.


      TPAS$STKRM_DB -  This database will be re-created monthly. The command
		   streams to pull and populate, and the documentation are 
                   provided in the TPAS Kit.
		   The site installing TPAS are given instructions to 
 		   put the command streams in production as well as the
		   process for requesting a proxy.
		   The SQL Export file is made available for sites to pull
		   the last fiscal SATURDAY of the month. This RBR file 
	 	   should be put in place for the begining of the fiscal 
		   month.


	TPAS$NOR$DB -  This database will be re-created monthly. The command
		   streams to pull and populate, and the documentation are 
                   provided in the TPAS Kit.
		   The site installing TPAS are given instructions to 
 		   put the command streams in production as well as the
		   process for requesting a proxy.
		   The RMU Unload file is made available for sites to pull
		   the last fiscal THURSDAY of the month. This UNL file 
	 	   should be put in place for the begining of the fiscal 
		   month.