U0438 ALI Insurance Data Export

U04 End of Period

U0438 ALI Insurance Data Export

EOP Only	Yes
Frequency	Daily
Sequential Updates	Yes
Skip Notes	No restrictions

For more information about End of Period,
refer to U04 End of Period Overview.

Sequential Updates: This EOP module runs as part of U0411 Sequential Updates.

For use with an ALI Insurance interface.

For detailed reference on how to setup ALI data extract, see ALI Data Export overview document.

The update generates processed leases and assets file of selected portfolio named pxx_ali_export.dat in $ueop directory. Where xx is portfolio number.

For each lease meeting the necessary criteria, collects data and creates a fixed width ASCII export file for ALI. The collected data is separated by lease and asset. Each record begins with a single character indicating L for lease or U for unit/asset. After each letter the next four numbers indicate how long the records is, including the letter at the beginning. This number should be the number defined in the layout. All records beginning with a U belong to the preceding asset record until a new lease record is encountered or until the end of the file is reached. The following table lists the data collected:

Lease Record Layout

Export Field	Table	LeasePak Field(s)	Format	Length	Notes
Record Type		Constant 'L'	char	1	L = Lease
Record Length		Constant '2080'	integer	4	length of lease record currently fixed at 2080 characters
Portfolio	rls	por_s	char	2
Company	rls	com_s	char	2
Region	rls	reg_s	char	2
Office	rls	off_s	char	3
Lease Number	rls	lse_s	char	10	unique lease identifier
Lease Start Date	rls	d_com_s	date	8	lease commencement date
Maturity Date	rls	d_mat_s	date	8	maturity date
Lease Type	rls	ls_typ_s	char	4	lease type code
Accrual Method	rls	acc_l_s	char	4	lessor accrual method code
Lease Status Code	rls	act_s	char	4	activity status code
Lease Status Date	rls	d_act_s	DATE	8	activity status date
Next Invoice Billing	rls/rpa	see note	DATE	8	Next date invoices will be generated (may be different than accruals) ==>
Next Invoice Date to Accrue	rls	d_pmt_s	date	8	next payment due day
Last Payment Date Accrued	rls	d_lst_s	date	8	last payment due date
Monthly Payment Frequency	rlsp	if all (pmt_cd_s = 'MON') then 'Y' else 'N'	long	1	If all records in the payment schedule are monthly then 'Y' else 'N'
Last Payment Date	rls	d_pay_s	date	8	date last payment was made
Pap Payment Switch	rls	pap_pmt_c	char	1	PAP/ACH setting (Y/N/1/2/3)
Original Total Cost Of Assets	rls	tot_org_d	real	11	Original cost of all assets
# Of Assets On Lease	rls	n_unt_l	long	4	Number of assets not including sub-assets
Gross Remaining Payments	rls	call lspayoff to calculate.	real	11	total contract unearned by calling lspayoff
Payoff/Termination date	rps	d_pay_s	char	8	Date of payoff/termination if the lease has been paid off/terminated
Dba Name	rcx	client_s_name_s	char	25	the 'les' relation
Lessee Name	ral	nam_long_s	char	125	lessee long name
Contact Name	ral	short_cont_nam_s	char	25	lessee contact name
Email Address	ral/rcu	email_s	char	50	email (if billing level flag (b_lvl_s) is C and rcu.email_s is not blank use rcu.email_s)
Customer Billing Address	ral rls rcu	bill_add_s or add_s	char	36	based on billing level flag (b_lvl_s) C/L/I
Billing Address 2nd Line	ral rls rcu	bill_add2_s or add2_s	char	36	based on billing level flag (b_lvl_s) C/L/I
Billing City	ral rls rcu	bill_cty_s or cty_s	char	25	based on billing level flag (b_lvl_s) C/L/I
Billing State	ral rls rcu	bill_st_s or st_s	char	2	based on billing level flag (b_lvl_s) C/L/I
Billing Zip Code	ral rls rcu	bill_zip_s or zip_s	char	9	based on billing level flag (b_lvl_s) C/L/I
Primary Phone#	ral rls rcu	bus_phn_s	char	10	based on billing level flag (b_lvl_s) C/L/I
Secondary Phone #	ral rls rcu	hom_phn_s	char	10	based on billing level flag (b_lvl_s) C/L/I
Name for Billing	ral rls rcu	rlsa.bill_nam_s ral.short_cont_nam_s rcu.cont_nam_s	char	25	contact name
Invoice Number	rar/rha	invo_s	char	8	most recent invoice
Payment Amount	rar/rha	pamt_b_d	real	11
Premium Collected	rtr	tax_r_d	real	11	total the tax_r_d for all records that match the lease in unit_lse_s or lse_s where the pay_typ_s = rpay.rcr_ali_s
Remittance Code	rna	rna_code_s	char	4	remittance address rna_s flg_c = '8'
Remit To Name	rna	nam_long_s	char	36
Remit To Address 1	rna	long_add1_s	char	36
Remit To Address 2	rna	add2_s	char	36
Remit To City	rna	cty_s	char	25
Remit To State	rna	st_s	char	2
Remit To Zip	rna	zip_s	char	9
Insurance Carrier 1	rdmi	ins_car_nam_s	char	36	5 insurance policies, fill all 5 even if not there
Insurance Agent 1	rdmi	ag_nam_s	char	36
Agent 1 address	rdmi	ag_add_s	char	36
Agent 1 address 2	rdmi	ag_add2_s	char	36
Agent 1 city	rdmi	ag_cty_s	char	25
Agent 1 state	rdmi	ag_st_s	char	2
Agent 1 zip code	rdmi	ag_zip_s	char	9
Agent 1 contact name	rdmi	ag_cont_nam_s	char	36
Agent 1 contact title	rdmi	ag_cont_title_s	char	25
Insurance agent 1 phone	rdmi	ins_phn_s	char	10
Current Policy Number 1	rdmi	pol_num_s	char	20
Expiration Date 1	rdmi	d_ins_s	char	8
Insurance Carrier 2	rdmi	ins_car_nam_s	char	36
Insurance Agent 2	rdmi	ag_nam_s	char	36
Agent 2 address	rdmi	ag_add_s	char	36
Agent 2 address 2	rdmi	ag_add2_s	char	36
Agent 2 city	rdmi	ag_cty_s	char	25
Agent 2 state	rdmi	ag_st_s	char	2
Agent 2 zip code	rdmi	ag_zip_s	char	9
Agent 2 contact name	rdmi	ag_cont_nam_s	char	36
Agent 2 contact title	rdmi	ag_cont_title_s	char	25
Insurance agent 2 phone	rdmi	ins_phn_s	char	10
Current Policy Number 2	rdmi	pol_num_s	char	20
Expiration Date 2	rdmi	d_ins_s	char	8
Insurance Carrier 3	rdmi	ins_car_nam_s	char	36
Insurance Agent 3	rdmi	ag_nam_s	char	36
Agent 3 address	rdmi	ag_add_s	char	36
Agent 3 address 2	rdmi	ag_add2_s	char	36
Agent 3 city	rdmi	ag_cty_s	char	25
Agent 3 state	rdmi	ag_st_s	char	2
Agent 3 zip code	rdmi	ag_zip_s	char	9
Agent 3 contact name	rdmi	ag_cont_nam_s	char	36
Agent 3 contact title	rdmi	ag_cont_title_s	char	25
Insurance agent 3 phone	rdmi	ins_phn_s	char	10
Current Policy Number 3	rdmi	pol_num_s	char	20
Expiration Date 3	rdmi	d_ins_s	char	8
Insurance Carrier 4	rdmi	ins_car_nam_s	char	36
Insurance Agent 4	rdmi	ag_nam_s	char	36
Agent 4 address	rdmi	ag_add_s	char	36
Agent 4 address 2	rdmi	ag_add2_s	char	36
Agent 4 city	rdmi	ag_cty_s	char	25
Agent 4 state	rdmi	ag_st_s	char	2
Agent 4 zip code	rdmi	ag_zip_s	char	9
Agent 4 contact name	rdmi	ag_cont_nam_s	char	36
Agent 4 contact title	rdmi	ag_cont_title_s	char	25
Insurance agent 4 phone	rdmi	ins_phn_s	char	10
Current Policy Number 4	rdmi	pol_num_s	char	20
Expiration Date 4	rdmi	d_ins_s	char	8
Insurance Carrier	rdmi	ins_car_nam_s	char	36
Insurance Agent 5	rdmi	ag_nam_s	char	36
Agent 5 address	rdmi	ag_add_s	char	36
Agent 5 address 2	rdmi	ag_add2_s	char	36
Agent 5 city	rdmi	ag_cty_s	char	25
Agent 5 state	rdmi	ag_st_s	char	2
Agent 5 zip code	rdmi	ag_zip_s	char	9
Agent 5 contact name	rdmi	ag_cont_nam_s	char	36
Agent 5 contact title	rdmi	ag_cont_title_s	char	25
Insurance agent 5 phone	rdmi	ins_phn_s	char	10
Current Policy Number 5	rdmi	pol_num_s	char	20
Expiration Date 5	rdmi	d_ins_s	char	8

Asset Record Layout

Export Field	Table	LeasePak Field(s)	Format	Length	Notes
Record Length		Constant '0128'	integer	4	length of unit record currently fixed at 0128 characters
Asset Number	req	unit_s	char	10	Unique asset identifier
Original acquisition cost	req	org_d	real	11	Value at beginning of lease contract
List Price	req	lst_d	real	11
Appraised Value	rua	field1_s	real	11
Description	req	desc_s	char	36
Asset identification	req	id_s	char	25	Serial number or VIN
Class Code	req	cls_s	char	4
Year	req	yr_s	char	2
Manufacturer Code	req	mnf_s	char	4
Model Code	req	mdl_s	char	4
Equipment Activity Status	req	eqt_s	char	4