LeasePak Utilities

222 PTMS Export

Beginning with LeasePak 6.6a, the utility will no longer output fixed-width (with fixed field widths) text file. PTMS no longer supports this file format, but they do support delimited files, so the output will now be tilde (~) delimited. As a result, Customer and Lessee long names no longer need to be truncated to 25 characters, and the file will support the longer Manufacturer and Model codes introduced in 6.6a. Contact your NetSol representative for more information.

Prepares an export file for the Property Tax Management System (PTMS) software. The user must specify the portfolio/company/region/office combination, file name, and start date. The file name format is PPCCRROOO.dat, where PPCCRROOO is the P/C/R/O combination.

This Utility option is used to create PTMS export file 

Do you wish to continue (Y/N)? 

Enter ‘Y’ to proceed. The program displays:

Client Password?

Enter correct LeasePak client string password to proceed. The program displays:

Enter the pcro/file, <RETURN> to exit:

Enter PCRO combination or file number to proceed. The file name format should be PPCCRROOO.dat, where PPCCRROOO is the P/C/R/O combination. The program displays:

Enter lien date YYMMDD,  to exit: 

Enter the lien date of the Property Tax Assessment in YYMMDD format. The program displays:

Enter Export file name, <RETURN> to exit:

Enter Export file name and extension. The program displays:

Include SS/Bus ID in export file (Y/N), <RETURN> to exit?

Enter ‘Y’ or ‘y‘ if you want to include SS/Bus ID in the export file otherwise enter blank. The program displays:

Include assets based on (A)sset acquisition date or (L)ease commencement date and lease status (A/L), <RETURN> to exit?

Enter ‘A’ or ‘a’ to include all assets in your extract that have an acquisition date less than or equal to the lien date entered in the previous prompt regardless of the asset status whether it is currently on lease or not.

Enter ‘L’ or ‘l’ to extract all assets attached to a lease with an activity status that does not start with ‘N’ and regardless of the asset's status as long as the lease commencement date is less than or equal to the lien date entered.

NOTE:The utility will not extract any asset whose Report Property Tax flag (rpt_ptax_c) is turned off no matter what is entered in the last prompt.

The export file will list the number of unique leases that are being selected in the given PCRO for which assets booked on them will be extracted. The leases are selected based on the following criteria.

• The status (rls.act_s) is not equal to N* which means the lease is active and not matured or paid off.
• The commencement date of the lease (rls.d_com_s) is >= the lien date entered when the utility is run.

Once the leases to be included in the extract are determined, only assets attached to those leases will be extracted and only if their report property tax flag (req.rpt_ptax_c) is set to Y. Fields exported to the file are:

required fields	table	field(s)	format	length	comments
portfolio, company, region, office, lease ID	rls	por_s+com_s+reg_s+off_s+lse_s	char	19
billing ID	rls	les_s	char	9
asset ID	req	unit_s	char	10
original asset ID (if transferred, rewritten, inventoried)	req	asset_s	char	10	associated asset
customer name	ral	nam_long_s	char	25	truncate field from 125 chars
customer city	ral	cty_s	char	25
customer state	ral	st_s	char	2
customer zip	ral	zip_s	char	9
customer billing name	ral	short_cont_nam_s	char	25
customer billing address	ral rls rcu	bill_add_s or add_s	char	36	based on billing level flag (b_lvl_s)
customer address		bill_add2_s or add2_s	char	36	same as above
customer billing city		bill_cty_s or cty_s	char	25	same as above
customer billing state		bill_st_s or st_s	char	2	same as above
customer billing zip		bill_zip_s or zip_s	char	9	same as above
customer billing phone	ral rcu	bus_phn_s	char	10	same as above
lease start date	rls	d_com_s	date	8	contract commencement date
lease maturity date	rls	d_mat_s	date	8
lease level equipment cost	rls	lsd_unit_d	real	11
asset purchase date	req	d_bok_s	date	8
asset tax basis	req	bk_basis_d	real	11
asset description	req	desc_s	char	36
asset serial number	reqa	part_num_s	char	25
asset payment amount	req	pmt_amt_d	real	11
asset residual	req	res_d	real	11
asset last used date	reqa	d_ptax_last_used_s	date	8	last used date
asset tax sale date	req	d_disp_s	date	8	asset disposition date
asset class	req	cls_s	char	4
asset ppt switch (y/n)	req	rpt_ptax_s	char	1
asset ppt exemption status	req	ptax_exempt_s	char	4
asset address	req	eq_add_s	char	36
asset address 2	reqa	eq_add2_s	char	36
asset city	req	eq_cty_s	char	25
asset state	req	eq_st_s	char	2
county county	mlo_county reqe	nam_long_s vtx_taid	char char	25 10	lookup of req.ct_s If asset's "Vertex tax area id" (reqe.vtx_taid_s) field populated is a vertex O asset.
asset zip	req	eq_zip_s	char	9
Asset manufacturer code	req	mnf_s	char	10
Asset model code	req	mdl_s	char	10
Asset year code	req	yr_s	char	4
New/used (N/U)	req	new_c	char	1
FHUT asset weight (pounds)	req	weight_l	integer	8
Depreciation L-T-D book	req	ltd_bkd_d	real	11
Upfront sales tax - sales tax amount	req	upf_samt_d	real	11
Equipment activity status	req	eqt_s	char	4
Equipment activity status date	req	d_eqt_s	date	8	format YYYYMMDD
Sales/use tax exempt code	req	stax_exempt_s	char	4
SS/Bus Id	rcx	ss_s	char	20	For the lessee of the lease the asset is on
Lessee name	ral	nam_long_s	char	25	Truncate the 125 character field to 25 characters
Lease type code	rls	ls_typ_s	char	4
Upfront sales tax code	rap	stax_cd_s	char	1	Change the value based on the following: If rap.stax_cd_s= 'FIN' then T else 'N'
Asset serial number/VIN	req	id_s	char	25
Property tax basis	req	prop_tax_basis_d	real	11