test spRptJobs
: !/bin/sh

tbssql <<SQLCMD0
spRptJobs 'INV003316'
\go
SQLCMD0


 CustomerID  LogDatTime CallNumber                                        
	Descr                                             
	Location                                          
	Reference                                         
	LastName                                           amountexGST          
	BatchID    
	InvDetailDesc                                                           
                            
	Period 
	SupplierDisplayedName                                                   
                            
 ----------- ---------- --------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	-------------------------------------------------- ---------------------
	-----------
	------------------------------------------------------------------------
----------------------------
	-------



####################################################################33
test spInvoiceReport

	------------------------------------------------------------------------
----------------------------
: !/bin/sh
tbssql <<SQLCMD0
spInvoiceReport '', '', '$INV003316'
\go
SQLCMD0



 ID          ShipTo FullName                                           VNumber 
	Address01                                                               
                                                                                
                                                                                
                       
	Address02                                                               
                                                                                
                                                                                
                       
	Address03                                                               
                                                                                
                                                                                
                       
	Address04                                                               
                                                                                
                                                                                
                       
	Address05                                                               
                                                                                
                                                                                
                       
	Address06                                                               
                                                                                
                                                                                
                       
	Status       Rate        Invoice Active StartDate          
	EndDate             LastUpdatedBy                                     
	PlatinumUpdate InvoiceServices
	eMailAddress                                                            
                                                                                
                                                                                
                       
	eInvoice MaxExServiceAmount    ARContactID AmountExGST           Period 
	BatchID     ID          CustomerID  InvoiceDate        
	PlatinumFileName                                                        
                                                                                
                                                                                
                       
	PlatinumInvoiceNo                                  AuditControl        
	CreditNoteFlag CreditNoteInvID ReportedFlag
	UserName                                           GSTAmount            
	Comment                                                                 
                                                                                
                                                                                
                       
	StatusID    PaymentReceivedDate PaymentReceivedAmount
	PlatinumInvoiceAmount CompanyName                                       
	ABN                  AddressLine1                                      
	AddressLine2                                      
	Phone                                             
	Fax                                               
	PaymentTerms                                      
	Bank                                              
	BSB                                               
	Account                                           
	RemittanceContact                                 
	FullAddress                                                             
                                                                                
                                                                                
                       
	ReportOrder                                       
	line_desc                                                               
                            
	ContactName                                                             
                                                                                
                                                                                
                       
	ContactPhone                                                            
                                                                                
                                                                                
                       
	ContactEmail                                                            
                                                                                
                                                                                
                       
 ----------- ------ -------------------------------------------------- --------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------ ----------- ------- ------ -------------------
	------------------- --------------------------------------------------
	-------------- ---------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	-------- --------------------- ----------- --------------------- -------
	----------- ----------- ----------- -------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	-------------------------------------------------- --------------------
	-------------- --------------- ------------
	-------------------------------------------------- ---------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	----------- ------------------- ---------------------
	--------------------- --------------------------------------------------
	-------------------- --------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	--------------------------------------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	--------------------------------------------------
	------------------------------------------------------------------------
----------------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
	------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------

###########
if I dont have the $ I get...

"gettbssp2" 95 lines, 2437 characters
telmaxdr# gettbssp2
Msg 207, Level 16, State 3
Server 'BLT02-TBS', Line 1
Invalid column name 'INV003316'.