NetLease - Schema

Below are the key elements of the NetLease Schema. Any fields on records not included here and and custom fields that may have been added in your account can be found in your NetSuite instance under Customization > Lists, Records, Fields > Record Types > [select the record for which fields you want to view]

 

NetLease Custom RecordsRecord ID
NetLease Contract Provisioncustomrecord_laa_contract_provision
NetLease Custom Calendarcustomrecord_laa_custom_calendar
NetLease Custom Calendar Periodcustomrecord_laa_custom_calendar_period
NetLease Custom Filtercustomrecord_laa_custom_filter
NetLease Custom Sourcingcustomrecord_laa_custom_sourcing
NetLease Global Settingscustomrecord_laa_global_settings
NetLease Leasecustomrecord_laa_lease
NetLease Lease Accounting Standardcustomrecord_laa_accounting_standard
NetLease Lease Classificationcustomrecord_laa_lease_classification
NetLease Lease Paymentcustomrecord_laa_lease_payment
NetLease Lease Proposalcustomrecord_laa_lease_proposal
NetLease Lease Typecustomrecord_laa_lease_type
NetLease Lease Type Account Historycustomrecord_laa_account_history
NetLease Modificationcustomrecord_laa_lease_modification
NetLease Reclass Journal Typecustomrecord_laa_reclass_je_type
NetLease Renewal Typecustomrecord_laa_renewal_type
NetLease Reportcustomrecord_laa_report
NetLease Report Packagecustomrecord_laa_report_package
NetLease Schedule Linecustomrecord_laa_lse_schedule_line
NetLease Selection Cachecustomrecord_laa_cache
NetLease System Jobcustomrecord_laa_system_job
NetLease System Job Batchcustomrecord_laa_system_job_batch
NetLease Terminationcustomrecord_laa_termination
NetLease Transaction Processingcustomrecord_laa_transaction_processing


NetLease Custom TransactionsTransaction Type ID
NetLease Amortizationcustomtransaction_laa_amortization
NetLease Close Outcustomtransaction_laa_close_out
NetLease Go-Livecustomtransaction_laa_go_live
NetLease Initial Balancecustomtransaction_laa_initial_balance
NetLease Modificationcustomtransaction_laa_modification
NetLease Terminationcustomtransaction_laa_termination
NetLease Transfercustomtransaction_laa_transfer


NetLease Custom ListsList ID
NetLease Amortization Typecustomlist_laa_amortization_type
NetLease Breakpoint Typecustomlist_laa_pr_breakpoint
NetLease Calendar Formatcustomlist_laa_calendar_format
NetLease Checkbox Filtercustomlist_laa_checkbox_filter
NetLease Date Groupingcustomlist_laa_report_date_group
NetLease Day of Monthcustomlist_laa_day_of_month
NetLease Entity Typecustomlist_laa_entity_type
NetLease Expense Conventioncustomlist_laa_expense_convention
NetLease FX Setting Optionscustomlist_laa_fx_setting_options
NetLease Impact Typecustomlist_laa_impact_type
NetLease Index Ratescustomlist_laa_index_rates
NetLease Journal Statuscustomlist_laa_list_leaseje_status
NetLease Modification Typecustomlist_laa_lease_mod_type
NetLease Numbering Optionscustomlist_laa_lease_numbering_options
NetLease Other Clause Typecustomlist_laa_prov_other_clause_type
NetLease Payment Frequencycustomlist_laa_payment_frequency
NetLease Payment Timingcustomlist_laa_list_npv_calc_time
NetLease Processing Statuscustomlist_laa_lp_status
NetLease Proposal Statuscustomlist_laa_proposal_status
NetLease Provision Statuscustomlist_laa_provision_status
NetLease Provision Typecustomlist_laa_provision_type
NetLease Renewal Settingscustomlist_laa_renewal_settings
NetLease Report Categorycustomlist_laa_report_category
NetLease Report Date Prefcustomlist_laa_report_date_preference
NetLease Report Typecustomlist_laa_report_type
NetLease ROU FX Acct. Pref.customlist_laa_rou_fx_acct_pref
NetLease Sourcing Typescustomlist_laa_sourcing_types
NetLease ST/LT Reclass Portioncustomlist_laa_reclass_portion
NetLease Statuscustomlist_laa_lease_status
NetLease System Job Typecustomlist_laa_system_job_type
NetLease Time of Daycustomlist_laa_time_of_day
NetLease Transaction Typecustomlist_laa_lease_transaction_type
NetLease Transfer Typecustomlist_laa_transfer_type
NetLease Upgrade Preferencescustomlist_laa_upgrade_preferences
NetLease Variable Paymentscustomlist_laa_variable_lease_pmt_type
NetLease YesMaybeNocustomlist_laa_yes_maybe_no

 

NetLease Lease FieldsField IDField TypeList/Record
Statuscustrecord_laa_ls_statusList/RecordNetLease Status
Lease Typecustrecord_laa_ls_typeList/RecordNetLease Lease Type
Lease Classificationcustrecord_laa_ls_classificationList/RecordNetLease Lease Classification
Subsidiarycustrecord_laa_ls_subsidiaryList/RecordSubsidiary
Vendorcustrecord_laa_ls_vendorList/RecordEntity
Customercustrecord_laa_ls_customerList/RecordEntity
Currencycustrecord_laa_ls_currencyList/RecordCurrency
Historical Exchange Ratecustrecord_laa_ls_exchange_rateDecimal Number
Notescustrecord_laa_ls_notesLong Text
Asset Photocustrecord_laa_ls_photoImage
Commencement Datecustrecord_laa_ls_commencement_dateDate
End Datecustrecord_laa_ls_end_dateDate
Lease Term (months)custrecord_laa_ls_termInteger Number
ROU Asset Useful Lifecustrecord_laa_ls_useful_lifeInteger Number
Initial Lease Paymentcustrecord_laa_ls_initial_payment_amountCurrency
Discount Rate %custrecord_laa_ls_inc_borrowing_ratePercent
Prepaid Lease Paymentcustrecord_laa_ls_lease_prepaid_pmtCurrency
Initial Direct Costscustrecord_laa_ls_initial_direct_costsCurrency
Lease Incentives Receivedcustrecord_laa_ls_lease_incentivesCurrency
Processing Statuscustrecord_laa_ls_processing_statusFree-Form Text
ROU Asset Balancecustrecord_laa_ls_asset_balanceCurrency
Liability Balancecustrecord_laa_ls_liability_balanceCurrency
Net Balancecustrecord_laa_ls_net_balanceCurrency
Deferred Rent Balancecustrecord_laa_ls_rent_balanceCurrency
Departmentcustrecord_laa_ls_departmentList/RecordCost Center
Classcustrecord_laa_ls_classList/RecordLine of Business
Locationcustrecord_laa_ls_locationList/RecordLocation
Variable Rate Indexcustrecord_laa_ls_var_rate_indexList/RecordNetLease Index Rates
Variable Non-Lease Paymentscustrecord_laa_ls_var_nonlease_paymentsList/RecordNetLease Variable Payments
Residual Value Guaranteecustrecord_laa_ls_residual_guaranteeCurrency
Residual Value Estimatecustrecord_laa_ls_resid_value_estimateCurrency
Accounting Bookcustrecord_laa_ls_accounting_bookList/RecordAccounting Book
Secondary Bookcustrecord_laa_ls_secondary_bookList/RecordAccounting Book
Secondary Classificationcustrecord_laa_ls_second_classificationList/RecordNetLease Lease Classification
Payment Timing (NPV Calc)custrecord_laa_ls_payment_timingList/RecordNetLease Payment Timing
No GL Impactcustrecord_laa_ls_no_gl_impactCheck Box
840 Lease; To Convert at Adoptioncustrecord_laa_ls_840_leaseCheck Box
Elimination Subsidiarycustrecord_laa_ls_elimination_subsidiaryList/RecordSubsidiary
Lease Locked (Transactions Recorded)custrecord_laa_ls_lockedCheck Box
Flagged for Mass Updatecustrecord_laa_ls_flagged_for_updateCheck Box
Terminationcustrecord_laa_ls_terminationList/RecordNetLease Termination
Termination Datecustrecord_laa_ls_termination_dateDate
Termination Reasoncustrecord_laa_ls_termination_reasonFree-Form Text
Termination Notecustrecord_laa_ls_termination_noteText Area
Termination Cash Paidcustrecord_laa_ls_termination_cash_paidCurrency
Termination Cash Receivedcustrecord_laa_ls_termination_cash_recCurrency
Script Execution Logcustrecord_laa_ls_execution_logText Area
HIDDEN: Default NPV Calculation Timecustrecord_laa_ls_npv_calc_timeList/RecordNetLease Payment Timing
HIDDEN: Schedule Generatedcustrecord_laa_ls_schedule_generatedCheck Box
HIDDEN: Recent Modificationcustrecord_laa_ls_recent_modificationList/RecordNetLease Modification
HIDDEN: Base Currencycustrecord_laa_ls_base_currencyList/RecordCurrency
HIDDEN: Task Keycustrecord_laa_ls_task_keyFree-Form Text
HIDDEN: Banner JSONcustrecord_laa_ls_banner_jsonText Area
HIDDEN: Currency Precisioncustrecord_laa_ls_currency_precisionInteger Number
HIDDEN: Override Go-Live Datecustrecord_laa_ls_go_live_dateDate
HIDDEN: Override Go-Live Exchange Ratecustrecord_laa_ls_override_exchange_rateDecimal Number
HIDDEN: Gross Asset Balancecustrecord_laa_ls_asset_gross_balanceCurrency
HIDDEN: Expense Conventioncustrecord_laa_ls_expense_conventionList/RecordNetLease Expense Convention
HIDDEN: Recent Transfercustrecord_laa_ls_recent_transferList/RecordNetLease Schedule Line
HIDDEN: Preferred Vendor Subsidiarycustrecord_laa_ls_vendor_subsidiaryList/RecordSubsidiary
HIDDEN: Global Settingscustrecord_laa_ls_global_configurationLong Text
DEPRECATED: Short Term or Low Value Leasecustrecord_laa_ls_stlv_leaseCheck Box
HIDDEN: Subsidiary / Currency Combinationcustrecord_laa_ls_sub_curr_comboFree-Form Text
HIDDEN: Entity Typecustrecord_laa_ls_entity_typeList/RecordNetLease Entity Type
HIDDEN: Created from File IDcustrecord_laa_ls_created_from_file_idFree-Form Text
HIDDEN: Accounting Standardcustrecord_laa_ls_acct_standardList/RecordNetLease Lease Accounting Standard
Close Out Datecustrecord_laa_ls_close_out_dateDate
Subsidiary (No Hierarchy)custrecord_laa_ls_sub_no_hierarchyFree-Form Text
HIDDEN: Trigger Auto-Numberingcustrecord_laa_ls_trigger_auto_numberCheck Box
1st Uplift Datecustrecord_laa_ls_uplift_dateDate
Uplift Frequencycustrecord_laa_ls_uplift_frequencyList/RecordNetLease Payment Frequency
Uplift Percentagecustrecord_laa_ls_uplift_percentagePercent
Uplift Amountcustrecord_laa_ls_uplift_amountCurrency
Uplift Frequency Multipliercustrecord_laa_ls_uplift_freq_multiInteger Number
Assigned Tocustrecord_laa_ls_assigned_toList/RecordEmployee
Parent Leasecustrecord_laa_ls_parent_leaseList/RecordNetLease Lease
Lease Proposalcustrecord_laa_ls_proposalList/RecordNetLease Lease Proposal
Source Transactioncustrecord_laa_ls_source_transactionList/RecordTransaction
ROU Adjustmentcustrecord_laa_ls_rou_adjustmentCurrency
ROU Asset Accumulated Balance At Commencement Datecustrecord_laa_ls_asset_accum_balanceCurrency
Billing Daycustrecord_laa_ls_billing_dayList/RecordNetLease Day of Month
Custom Calendarcustrecord_laa_ls_custom_calendarList/RecordNetLease Custom Calendar
Default Payment Frequencycustrecord_laa_ls_payment_frequencyList/RecordNetLease Payment Frequency
Transfer of Ownership?custrecord_laa_ls_ownership_transferCheck Box
Reasonably Certain Purchase Option?custrecord_laa_ls_purchase_optionCheck Box
Remaining Economic Life at Commencement (Months)custrecord_laa_ls_remaining_lifeInteger Number
Commencement Date Near End of Life?custrecord_laa_ls_commencement_near_endCheck Box
Percentage of Remaining Economic Lifecustrecord_laa_ls_term_percent_of_lifeFree-Form Text
Major Part of Remaining Economic Life?custrecord_laa_ls_term_majority_of_lifeCheck Box
Practical to Determine the Asset Fair Value?custrecord_laa_ls_practical_fair_valueCheck Box
Fair Value of the Underlying Assetcustrecord_laa_ls_asset_fair_valueCurrency
Guaranteed Residual Value NOT reflected in Paymentscustrecord_laa_ls_res_not_in_pmtsCurrency
PV of Payments & Guaranteed Residual Valuecustrecord_laa_ls_pv_including_residualCurrency
PV of Payments & Guaranteed Residual Value as % of Fair Valuecustrecord_laa_ls_pv_as_percnt_of_valueFree-Form Text
PV equals or exceeds substantially all of the fair value?custrecord_laa_ls_pv_exceeds_fair_valueCheck Box
Override Lease Classificationcustrecord_laa_ls_carry_forward_classList/RecordNetLease Lease Classification
Specialized Asset?custrecord_laa_ls_specialized_assetCheck Box
Calculated Lease Classificationcustrecord_laa_ls_calculated_classList/RecordNetLease Lease Classification
Lease Addresscustrecord_laa_ls_addressList/RecordAddress Book
Impact Chartcustrecord_laa_ls_impact_chartInline HTML
Mapcustrecord_laa_ls_mapInline HTML
Auto Renewalcustrecord_laa_ls_is_autorenewalCheck Box
Default Renewal Typecustrecord_laa_ls_renewal_typeList/RecordNetLease Renewal Type
Default Renewal Termcustrecord_laa_ls_auto_renew_termInteger Number
Total Renewalscustrecord_laa_ls_renewal_totalInteger Number
Final Renewal End Datecustrecord_laa_ls_auto_renew_end_dateDate
HIDDEN: Renewal Option JSONcustrecord_laa_ls_renewal_option_jsonLong Text
Renewal Start Datecustrecord_laa_ls_auto_renew_start_dateDate

 

NetLease Schedule Line FieldsField ID
Field Type
List/Record
Leasecustrecord_laa_lse_leaseList/RecordNetLease Lease
Lease Classificationcustrecord_laa_lse_classificationList/RecordNetLease Lease Classification
Transaction Typecustrecord_laa_lse_transaction_typeList/RecordNetLease Transaction Type
Amortization Typecustrecord_laa_lse_amortization_typeList/RecordNetLease Amortization Type
Period Numbercustrecord_laa_lse_period_numberDecimal Number
Period Start Datecustrecord_laa_lse_period_start_dateDate
Period End Datecustrecord_laa_lse_period_end_dateDate
Remaining Periodscustrecord_laa_lse_remaining_periodsInteger Number
Lease Paymentcustrecord_laa_lse_paymentCurrency
Equivalent Monthly Paymentcustrecord_laa_lse_monthly_paymentCurrency
Remaining Paymentcustrecord_laa_lse_remaining_paymentCurrency
Discount Rate %custrecord_laa_lse_inc_borrowing_ratePercent
Right of Use Asset Gross Balance (Posting)custrecord_laa_lse_asset_gross_balanceCurrency
Right of Use Asset Accum. Balance (Posting)custrecord_laa_lse_asset_accum_balanceCurrency
Right of Use Asset Net Balance (Posting)custrecord_laa_lse_asset_balanceCurrency
Lease Liability Balance (Posting)custrecord_laa_lse_liability_balanceCurrency
Net Balance (Posting)custrecord_laa_lse_net_balanceCurrency
Interest Expensecustrecord_laa_lse_interestCurrency
Allocated to Principalcustrecord_laa_lse_principalCurrency
Lease Liability Balance (Financing)custrecord_laa_lse_fin_liability_balanceCurrency
Amortization Amount (Financing)custrecord_laa_lse_amortization_amountCurrency
Gross Asset Adjustment (Financing)custrecord_laa_lse_fin_gross_asset_adjCurrency
Asset Adjustment (Financing)custrecord_laa_lse_fin_asset_adjustmentCurrency
Right of Use Asset Net Balance (Financing)custrecord_laa_lse_fin_asset_balanceCurrency
Right of Use Asset Gross Balance (Financing)custrecord_laa_lse_fin_asset_gross_balCurrency
Right of Use Asset Accum. Balance (Financing)custrecord_laa_lse_fin_asset_accum_balCurrency
Net Balance (Financing)custrecord_laa_lse_fin_net_balanceCurrency
Interest Accretion (Operating)custrecord_laa_lse_liability_accretionCurrency
Allocated to Principal (Operating)custrecord_laa_lse_liability_reductionCurrency
Lease Liability Balance (Operating)custrecord_laa_lse_op_liability_balanceCurrency
Lease Expense (Operating)custrecord_laa_lse_lease_expenseCurrency
Gross Asset Adjustment (Operating)custrecord_laa_lse_op_gross_asset_adjCurrency
Asset Adjustment (Operating)custrecord_laa_lse_asset_adjustmentCurrency
Right of Use Asset Net Balance (Operating)custrecord_laa_lse_op_asset_balanceCurrency
Right of Use Asset Gross Balance (Operating)custrecord_laa_lse_op_asset_gross_balCurrency
Right of Use Asset Accum. Balance (Operating)custrecord_laa_lse_op_asset_accum_balCurrency
Net Balance (Operating)custrecord_laa_lse_op_net_balanceCurrency
Lease Expense/Income (ST/LV/Sublease)custrecord_laa_lse_st_lease_expenseCurrency
Allocated To Deferred/Accrued Rent (ST/LV/Sublease)custrecord_laa_lse_alloc_deferred_rentCurrency
Deferred/Accrued Rent Balance (ST/LV/Sublease)custrecord_laa_lse_deferred_rent_balanceCurrency
Processing Statuscustrecord_laa_lse_processing_statusList/RecordNetLease Processing Status
Execution Logcustrecord_laa_lse_execution_logText Area
Current Portion of Lease Liability (Posting)custrecord_laa_lse_st_reclass_amtCurrency
Journal Entrycustrecord_laa_lse_journal_entryList/RecordTransaction
Book Specific Journal Entrycustrecord_laa_lse_book_specific_jeList/RecordTransaction
LT to ST Reclass Journal Entrycustrecord_laa_lse_st_reclass_journalList/RecordTransaction
Book-Specific LT to ST Reclass Journal Entrycustrecord_laa_lse_st_reclass_bsjournalList/RecordTransaction
FX Historical Adjustment Journal Entrycustrecord_laa_lse_fx_adjustment_jeList/RecordTransaction
FX Adjustment Auditcustrecord_laa_lse_fx_auditFree-Form Text
Book Specific FX Historical Adjustment Journal Entrycustrecord_laa_lse_bs_fx_adjustment_jeList/RecordTransaction
Custom Reclass Journal Entrycustrecord_laa_lse_custom_reclass_jeList/RecordTransaction
Book-Specific Custom Reclass Journal Entrycustrecord_laa_lse_custom_reclass_bsjeList/RecordTransaction
Reversal Journal Entrycustrecord_laa_lse_reversal_journalList/RecordTransaction
Billcustrecord_laa_lse_vendor_billList/RecordTransaction
Interest Payable Balancecustrecord_laa_lse_interest_payable_amtCurrency
Non-Lease Payment 1custrecord_laa_lse_nonls_payment_1Currency
Non-Lease Payment 2custrecord_laa_lse_nonls_payment_2Currency
Non-Lease Payment 3custrecord_laa_lse_nonls_payment_3Currency
Payment Reclass Amountcustrecord_laa_lse_payment_reclassCurrency
Modification Detailcustrecord_laa_lse_modification_detailList/RecordNetLease Modification
Termination Detailcustrecord_laa_lse_termination_detailList/RecordNetLease Termination
Partial Expense Calculation Auditcustrecord_laa_lse_expense_calc_auditFree-Form Text
Processed with No Journal Entrycustrecord_laa_lse_processed_no_entryCheck Box
Total Lease Expensecustrecord_laa_lse_total_expenseCurrency
Total Paymentcustrecord_laa_lse_total_paymentCurrency
HIDDEN: Processing Recordcustrecord_laa_lse_processing_recordList/RecordNetLease Transaction Processing
HIDDEN: Reclass Processing Recordcustrecord_laa_lse_reclass_recordList/RecordNetLease Transaction Processing
HIDDEN: Bill Processing Recordcustrecord_laa_lse_vendor_bill_recordList/RecordNetLease Transaction Processing
HIDDEN: Old Subsidiarycustrecord_laa_lse_old_subsidiaryFree-Form Text
HIDDEN: Old Departmentcustrecord_laa_lse_old_departmentFree-Form Text
HIDDEN: Old Classcustrecord_laa_lse_old_classFree-Form Text
HIDDEN: Old Locationcustrecord_laa_lse_old_locationFree-Form Text
HIDDEN: Old Segmentcustrecord_laa_lse_old_segmentFree-Form Text
HIDDEN: Old Exchange Ratecustrecord_laa_lse_old_exchange_rateDecimal Number
DEPRECATED: Is Initial Balancecustrecord_laa_lse_is_initial_balanceCheck Box
DEPRECATED: Is Transition Entrycustrecord_laa_lse_is_transitionCheck Box
DEPRECATED: Is Amortization Entrycustrecord_laa_lse_is_amortizationCheck Box
DEPRECATED: Is Modification Entrycustrecord_laa_lse_is_modificationCheck Box
DEPRECATED: Is Termination Entrycustrecord_laa_lse_is_terminationCheck Box
DEPRECATED: Is Final Period Entrycustrecord_laa_lse_is_final_periodCheck Box
Month Over Month Uplift Percentagecustrecord_laa_lse_month_uplift_percentFree-Form Text
Uplift Percentagecustrecord_laa_lse_uplift_percentageFree-Form Text
Allocated to Interestcustrecord_laa_lse_interest_paidCurrency
HIDDEN: Old Period Numbercustrecord_laa_lse_old_period_numberDecimal Number
Percentage Rent Paymentcustrecord_laa_lse_pr_paymentCurrency
Total Percent Rent Expense Payablecustrecord_laa_lse_pr_accruedCurrency
Percentage Rent Total Paymentscustrecord_laa_lse_pr_dueCurrency
Total Salescustrecord_laa_lse_pr_salesCurrency
Contract Breakpointcustrecord_laa_lse_pr_breakpointCurrency
Contract Percentagecustrecord_laa_lse_pr_percentagePercent
Percentage Rent Expense Payablecustrecord_laa_lse_pr_expenseCurrency
Percentage Rent Expense Payable Auditcustrecord_laa_lse_pr_expense_auditFree-Form Text
Expense Payable Contract Provisioncustrecord_laa_lse_pr_expense_contractList/RecordNetLease Contract Provision
Payment Contract Provisioncustrecord_laa_lse_pr_payable_contractList/RecordNetLease Contract Provision
Rolling Monthly Breakpointcustrecord_laa_lse_pr_rolling_breakpointCurrency
Allocated to Breakpointcustrecord_laa_lse_pr_alloc_breakpointCurrency
Percentage Rent Accumulated Accrued Expensecustrecord_laa_lse_pr_acc_accr_expCurrency
Percentage Rent Accrued Expensecustrecord_laa_lse_pr_accr_expCurrency
HIDDEN: Percentage Rent Processing Recordcustrecord_laa_lse_percent_rent_recordList/RecordNetLease Transaction Processing



Was this article helpful?