Response Reference Grid
LeasePak Documentation Suite NETSOL website
getR0601A

(mPower icon) LPReports

getR0601A

Response Reference Grid

NOTE: Numbers are formatted as ###,###,###,###.######

U0212 Portfolio → Miscellaneous Customization Flag"Alternate Delinquency Report = Y"

Response
Occurs
Level Elements / Attributes Min Max Type Description
1 r0601a 1 1
hrefs_on 1 1
lpmreq_on 1 1
popups_on 1 1
1.1 key_change_alt 1 1
1.1.1 header 1 1
1.1.1.1 run_dt 1 1 Date Run date
1.1.1.2 run_tm 1 1 String Run time
1.1.1.3 user_s 1 1 String(12) User Id
1.1.1.4 version_s 1 1 String Database version
1.1.1.5 por_name_s 1 1 String(36) Portfolio name
1.1.1.6 div_name_s 1 1 String(80) Division name
1.1.1.7 lskey 1 5
1.1.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.1.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.1.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.1.1.7.4 criteria_s 1 1 String Selection criteria
1.1.2 data_alt 0 unbounded line item data
1.1.2.1 old_lease_s 1 1 String Lease number
1.1.2.2 dq_short_name_s 1 1 String Lessee Short Name
1.1.2.3 pr_watch_code_s 1 1 Date Watch Code
1.1.2.4 dq_last_dt 1 1 String Last Paid
1.1.2.5 dq_next_dt 1 1 Date Most Delq. Invoice
1.1.2.6 dq_pmt_billed_d 1 1 String Payment Amount
1.1.2.7 dq_del_pmt_due_d 1 1 String Delinquent Total Due
1.1.2.8 dq_cur_pmt_due_d 1 1 String Due to Current
1.1.2.9 dq_times_delq_l 1 1 Decimal(15) Times Delq.
1.1.2.10 dq_days_delq_l 1 1 Decimal(15) # Days Delq.
1.1.3 subtotal_data_alt 1 1 line item data
1.1.3.1 count_d 1 1 Decimal(15,6) '1'
1.1.3.2 tot_pmt_billed_d 1 1 Decimal(15,2) Total Payment Amount
1.1.3.3 tot_del_pmt_due_d 1 1 Decimal(15,2) Total Delinquent Total Due
1.1.3.4 tot_cur_pmt_due_d 1 1 Decimal(15,2) Total Due to Current
1.1.4 grand_total_alt
1.1.4.1 header 1 1
1.1.4.1.1 run_dt 1 1 Date Run date
1.1.4.1.2 run_tm 1 1 String Run time
1.1.4.1.3 user_s 1 1 String(12) User Id
1.1.4.1.4 version_s 1 1 String Database version
1.1.4.1.5 por_name_s 1 1 String(36) Portfolio name
1.1.4.1.6 div_name_s 1 1 String(80) Division name
1.1.4.1.7 lskey 1 5
1.1.4.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.1.4.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.1.4.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.1.4.1.7.4 criteria_s 1 1 String Selection criteria
1.2 grand_total_alt
1.2.1 header 1 1
1.2.1.1 run_dt 1 1 Date Run date
1.2.1.2 run_tm 1 1 String Run time
1.2.1.3 user_s 1 1 String(12) User Id
1.2.1.4 version_s 1 1 String Database version
1.2.1.5 por_name_s 1 1 String(36) Portfolio name
1.2.1.6 div_name_s 1 1 String(80) Division name
1.2.1.7 lskey 1 5
1.2.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.2.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.2.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.2.1.7.4 criteria_s 1 1 String Selection criteria


U0212 Portfolio → Miscellaneous Customization Flag"Alternate Delinquency Report = N"


Response
Occurs
Level Elements / Attributes Min Max Type Description
1 r0601a 1 1    
  hrefs_on 1 1    
  lpmreq_on 1 1    
  popups_on 1 1    
1.1 key_change 1 1    
1.1.1 header 1 1    
1.1.1.1 run_dt 1 1 Date Run date
1.1.1.2 run_tm 1 1 String Run time
1.1.1.3 user_s 1 1 String(12) User Id
1.1.1.4 version_s 1 1 String Database version
1.1.1.5 por_name_s 1 1 String(36) Portfolio name
1.1.1.6 div_name_s 1 1 String(80) Division name
1.1.1.7 lskey 1 5    
1.1.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.1.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.1.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.1.1.7.4 criteria_s 1 1 String Selection criteria
1.1.2 data 0 unbounded   line item data
1.1.2.1 old_lease_s 1 1 String Lease number
1.1.2.2 dq_short_name_s 1 1 String Lessee Short Name
1.1.2.3 dq_times_delq_l 1 1 Date Times Delnq
1.1.2.4 dq_days_delq_l 1 1 Decimal(15) # Days Delnq
1.1.2.5 dq_last_dt 1 1 Date Last Payment
1.1.2.6 dq_next_dt 1 1 Date Most Del Invoice
1.1.2.7 dq_pmt_billed_d 1 1 Decimal(15,2) Payment Amount
1.1.2.8 dq_del_pmt_due_d 1 1 Decimal(15,2) Delinquent Tot Pmt Zue
1.1.2.9 dq_del_int_due_d 1 1 Decimal(15,2) Delinquent Incm Due
1.1.2.10 dq_del_asm_due_d 1 1 Decimal(15,2) Delinquent Assmt Due
1.1.2.11 dq_invoice_due_d     Decimal(15,2) Delinquent Tot Inv Due
1.1.2.12 dq_mat_dt     Date Maturity Date
1.1.3 subtotal_data 1 1   line item data
1.1.3.1 count_d 1 1 Decimal(15,6) '1'
1.1.3.2 tot_pmt_billed_d 1 1 Decimal(15,2) Total Payment Amount
1.1.3.3 tot_pmt_due_d 1 1 Decimal(15,2) Total Delinquent Total Due
1.1.3.4 tot_int_due_d 1 1 Decimal(15,2) Total Delinquent Incm Due
1.1.3.5 tot_asm_due_d 1 1 Decimal(15,2) Total Delinquent Assmt Due
1.1.3.6 tot_inv_due_d 1 1 Decimal(15,2) Total Delinquent Tot Inv Due
1.1.4 grand_total_normal        
1.1.4.1 header 1 1    
1.1.4.1.1 run_dt 1 1 Date Run date
1.1.4.1.2 run_tm 1 1 String Run time
1.1.4.1.3 user_s 1 1 String(12) User Id
1.1.4.1.4 version_s 1 1 String Database version
1.1.4.1.5 por_name_s 1 1 String(36) Portfolio name
1.1.4.1.6 div_name_s 1 1 String(80) Division name
1.1.4.1.7 lskey 1 5    
1.1.4.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.1.4.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.1.4.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.1.4.1.7.4 criteria_s 1 1 String Selection criteria
1.2 grand_total_normal        
1.2.1 header 1 1    
1.2.1.1 run_dt 1 1 Date Run date
1.2.1.2 run_tm 1 1 String Run time
1.2.1.3 user_s 1 1 String(12) User Id
1.2.1.4 version_s 1 1 String Database version
1.2.1.5 por_name_s 1 1 String(36) Portfolio name
1.2.1.6 div_name_s 1 1 String(80) Division name
1.2.1.7 lskey 1 5    
1.2.1.7.1 type_s 1 1 String 'PORTFOLIO' or 'COMPANY' or 'REGION' or 'OFFICE'
1.2.1.7.2 data_s 1 1 String Portfolio number or Company number or Region number or Office number
1.2.1.7.3 desc_s 1 1 String Name of PORTFOLIO or COMPANY or REGION or OFFICE
1.2.1.7.4 criteria_s 1 1 String Selection criteria