Add contract detail code to Winprism Interface

 Problem Description : 

Business Office/Bookstore need a new detail code added as a Contract Account

 Resolution : 

If BO/Bookstore add a new detail code as a contract account, several changes to interface processes must be updated. Contract amounts are manually added by BO within Banner.

Updates to pull contract amount for Winprism:

1 - Add detail code to the WHERE clause of /gdn01/prodhome/local/winprism/bookstore_cust_file4.sql - this pulls the student demographic info for Winprism

2 - Add detail code to the WHERE clause of /gdn01/prodhome/local/winprism/account_balance2.sql - this pulls the contract amount info for Winprism

Updates for Winprism to pull charges and send to Banner:

1 - Connect to the bookstore's POS server using the remote desktop to 168.26.240.22 username nbcsupp 

2 - Open command prompt to the c:\gdnprocs folder

3 - Edit all bat files that contain BKTE (currently move_ftp, fixit and manual) (grep -i BKTE *bat) to include line for the new detail code

Verify that balances are in the /home/winprism/work files.

After bookstore has made charge to new detail code, verify amount in the worbktn file in /home/winprism from bookstore

Verify transaction for detail code is in TSAAREV 

 Revision Date : 5/24/2013