Response Reference Grid
LeasePak Documentation Suite NETSOL website
getR0404

(mPower icon) LPReports

getR0404

Response Reference Grid

Response
Occurs
Level Elements / Attributes Min Max Type Source Description
1 r0404a or r0404b 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 Same as LeasePak R0404 Run date (MM/DD/YY)
1.1.1.2 run_tm 1 1 Same as LeasePak R0404 Run time (HH:MMam)
1.1.1.3 user_s 1 1 String(12) Same as LeasePak R0404 User Id
1.1.1.4 version_s 1 1 String Same as LeasePak R0404 Database version
1.1.1.5 por_name_s 1 1 String(36) Same as LeasePak R0404 Portfolio name
1.1.1.6 div_name_s 1 1 String(80) Same as LeasePak R0404 Division name
1.1.1.7 lskey 1 4
1.1.1.7.1 type_s 1 1 String Same as LeasePak R0404 PORTFOLIO, COMPANY, REGION, or OFFICE
1.1.1.7.2 data_s 1 1 String Same as LeasePak R0404 Code corresponding to the type listed previously
1.1.1.7.3 desc_s 1 1 String Same as LeasePak R0404 Description of code listed in <data_s>
1.1.1.7.4 criteria_s 1 1 String Same as LeasePak R0404 'SELECTED ALL'
1.1.2 data 0 unbounded line item data
1.1.2.1 invo_typ_s 1 1 String Same as LeasePak R0404 Type of AR record if not 'I' from invoice
1.1.2.2 lse_s 1 1 String Same as LeasePak R0404 Lease number
1.1.2.3 se_s 1 1 String Same as LeasePak R0404 Suspended Earnings indicator
1.1.2.4 les_name_s 1 1 String Same as LeasePak R0404 Lessee name
1.1.2.5 invo_s 1 1 String Same as LeasePak R0404 Invoice number
1.1.2.6 adv_inv_l 1 1 Number Same as LeasePak R0404 Advanced invoice indicator
1.1.2.7 invo_due_dt 1 1 Date Same as LeasePak R0404 Invoice due date
1.1.2.8 pmt_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Payment amount due
1.1.2.9 int_stax_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Sales tax due
1.1.2.10 oth_typ_s 1 1 String Same as LeasePak R0404 Charge Description
1.1.2.11 oth_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Other charge amount
1.1.2.12 pmt_outs_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total amount due
1.1.2.13 last_upd_dt 1 1 Date Same as LeasePak R0404 Date last updated
1.1.2.14 prtx_desc_s 1 1 String Same as LeasePak R0404 NA
1.1.2.15 fhut_desc_s 1 1 String Same as LeasePak R0404 NA
1.1.3 subtotal_data1 0 1
1.1.3.1 tot_outs_invs_d 1 1 Decimal(15,2) Same as LeasePak R0404 Number of invoices
1.1.3.2 pmt_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment
1.1.3.3 int_stax_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Use Tax
1.1.3.4 oth_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Other
1.1.3.5 pmt_outs_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment + Tax + Other
1.1.4 subtotal_data2 0 1
1.1.4.1 pmt_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment
1.1.4.2 int_stax_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Use Tax
1.1.4.3 oth_typ_s 1 1 String Same as LeasePak R0404 Charge Description
1.1.4.4 oth_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Other
1.1.4.5 pmt_outs_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment + Tax + Other
1.1.5 subtotal_data3 0 1
1.1.5.1 caption_s 1 1 String Same as LeasePak R0404 "ADVANCED INVOICES TOTAL" or "GENERAL LEDGER ACCOUNTS RECEIVABLE TOTAL"
1.1.5.2 pmt_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment
1.1.5.3 int_stax_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Use Tax
1.1.5.4 oth_amt_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Other
1.1.5.5 pmt_outs_d 1 1 Decimal(15,2) Same as LeasePak R0404 Total Payment + Tax + Other
1.1.5.6 oth_typ_s 1 1 String Same as LeasePak R0404 Charge Description
1.1.6 lstotal 1 1
type "sub"
1.1.6.1 header 1 1
1.1.6.1.1 run_dt 1 1 Date Same as LeasePak R0404 Run date (MM/DD/YY)
1.1.6.1.2 run_tm 1 1 Run time (HH:MMam)
1.1.6.1.3 user_s 1 1 String Same as LeasePak R0404 User Id
1.1.6.1.4 version_s 1 1 String Same as LeasePak R0404 Database version
1.1.6.1.5 por_name_s 1 1 String Same as LeasePak R0404 Portfolio name
1.1.6.1.6 div_name_s 1 1 String Same as LeasePak R0404 Division name
1.1.6.1.7 lskey 1 4
1.1.6.1.7.1 type_s 1 1 String Same as LeasePak R0404 PORTFOLIO, COMPANY, REGION, or OFFICE
1.1.6.1.7.2 data_s 1 1 String Same as LeasePak R0404 Code corresponding to the type listed previously
1.1.6.1.7.3 desc_s 1 1 String Same as LeasePak R0404 Description of code listed in <data_s>
1.1.6.1.7.4 criteria_s 1 1 String Same as LeasePak R0404 'SELECTED ALL'
1.1.6.2 lstotal_data 1 unbounded
1.1.6.2.1 key_nam_s 1 1 String Same as LeasePak R0404 PORTFOLIO, COMPANY, REGION, or OFFICE
1.1.6.2.2 key_num_s 1 1 String Same as LeasePak R0404 PCRO code
1.1.6.2.3 float3_d 1 1 Decimal(15,2) Same as LeasePak R0404 Number of invoices
1.1.6.2.4 float4_d 1 1 Decimal(15,2) Same as LeasePak R0404 Principal or Payment
1.1.6.2.5 float5_d 1 1 Decimal(15,2) Same as LeasePak R0404 Interest or Use Tax
1.1.6.2.6 float6_d 1 1 Decimal(15,2) Same as LeasePak R0404 Other
1.1.6.2.7 float7_d 1 1 Decimal(15,2) Same as LeasePak R0404 Suspended Interest
1.1.6.2.8 float8_d 1 1 Decimal(15,2) Same as LeasePak R0404 Suspended Principal
1.1.6.2.9 float9_d 1 1 Decimal(15,2) Same as LeasePak R0404 Prin + Int or Payment + Tax
1.1.6.2.10 float10_d 1 1 Decimal(15,2) Same as LeasePak R0404 Deferred Income
1.1.6.2.11 float11_d 1 1 Decimal(15,2) Same as LeasePak R0404 Deferred Residual
1.1.6.2.12 float12_d 1 1 Decimal(15,2) Same as LeasePak R0404 Pur. Opt. Income
1.1.6.2.13 float13_d 1 1 Decimal(15,2) Same as LeasePak R0404 Pur. Opt. Residual
1.1.6.2.14 float14_d 1 1 Decimal(15,2) Same as LeasePak R0404 Not used
1.2 lstotal 0 1
type "grand"
1.2.1 header 1 1 Same as LeasePak R0404
1.2.1.1 run_dt 1 1 Date Same as LeasePak R0404 Run date (MM/DD/YY)
1.2.1.2 run_tm 1 1 Same as LeasePak R0404 Run time (HH:MMam)
1.2.1.3 user_s 1 1 String Same as LeasePak R0404 User Id
1.2.1.4 version_s 1 1 String Same as LeasePak R0404 Database version
1.2.1.5 por_name_s 1 1 String Same as LeasePak R0404 Portfolio name
1.2.1.6 div_name_s 1 1 String Same as LeasePak R0404 Division name
1.2.1.7 lskey 1 1
1.2.1.7.1 type_s 1 1 String Same as LeasePak R0404 PORTFOLIO, COMPANY, REGION, or OFFICE
1.2.1.7.2 data_s 1 1 String Same as LeasePak R0404 Code corresponding to the type listed previously
1.2.1.7.3 desc_s 1 1 String Same as LeasePak R0404 Description of code listed in <data_s>
1.2.1.7.4 criteria_s 1 1 String Same as LeasePak R0404 'SELECTED ALL'
1.2.2 lstotal_data 1 unbounded
1.2.2.1 key_nam_s 1 1 String Same as LeasePak R0404 PORTFOLIO, COMPANY, REGION, OFFICE, or GRAND TOTALS
1.2.2.2 key_num_s 1 1 String Same as LeasePak R0404 PCRO code
1.2.2.3 float5_d 1 1 Decimal(15,2) Same as LeasePak R0404 Interest or Use Tax
1.2.2.4 float6_d 1 1 Decimal(15,2) Same as LeasePak R0404 Other
1.2.2.5 float7_d 1 1 Decimal(15,2) Same as LeasePak R0404 Suspended Interest
1.2.2.6 float8_d 1 1 Decimal(15,2) Same as LeasePak R0404 Suspended Principal
1.2.2.7 float9_d 1 1 Decimal(15,2) Same as LeasePak R0404 Prin + Int or Payment + Tax
1.2.2.8 float10_d 1 1 Decimal(15,2) Same as LeasePak R0404 Deferred Income
1.2.2.9 float11_d 1 1 Decimal(15,2) Same as LeasePak R0404 Deferred Residual
1.2.2.10 float12_d 1 1 Decimal(15,2) Same as LeasePak R0404 Pur. Opt. Income
1.2.2.11 float13_d 1 1 Decimal(15,2) Same as LeasePak R0404 Pur. Opt. Residual
1.2.2.12 float14_d 1 1 Decimal(15,2) Same as LeasePak R0404 Not used