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 Records | Record ID |
---|---|
NetLease Contract Provision | customrecord_laa_contract_provision |
NetLease Custom Calendar | customrecord_laa_custom_calendar |
NetLease Custom Calendar Period | customrecord_laa_custom_calendar_period |
NetLease Custom Filter | customrecord_laa_custom_filter |
NetLease Custom Sourcing | customrecord_laa_custom_sourcing |
NetLease Global Settings | customrecord_laa_global_settings |
NetLease Lease | customrecord_laa_lease |
NetLease Lease Accounting Standard | customrecord_laa_accounting_standard |
NetLease Lease Classification | customrecord_laa_lease_classification |
NetLease Lease Payment | customrecord_laa_lease_payment |
NetLease Lease Proposal | customrecord_laa_lease_proposal |
NetLease Lease Type | customrecord_laa_lease_type |
NetLease Lease Type Account History | customrecord_laa_account_history |
NetLease Modification | customrecord_laa_lease_modification |
NetLease Reclass Journal Type | customrecord_laa_reclass_je_type |
NetLease Renewal Type | customrecord_laa_renewal_type |
NetLease Report | customrecord_laa_report |
NetLease Report Package | customrecord_laa_report_package |
NetLease Schedule Line | customrecord_laa_lse_schedule_line |
NetLease Selection Cache | customrecord_laa_cache |
NetLease System Job | customrecord_laa_system_job |
NetLease System Job Batch | customrecord_laa_system_job_batch |
NetLease Termination | customrecord_laa_termination |
NetLease Transaction Processing | customrecord_laa_transaction_processing |
NetLease Custom Transactions | Transaction Type ID |
---|---|
NetLease Amortization | customtransaction_laa_amortization |
NetLease Close Out | customtransaction_laa_close_out |
NetLease Go-Live | customtransaction_laa_go_live |
NetLease Initial Balance | customtransaction_laa_initial_balance |
NetLease Modification | customtransaction_laa_modification |
NetLease Termination | customtransaction_laa_termination |
NetLease Transfer | customtransaction_laa_transfer |
NetLease Custom Lists | List ID |
---|---|
NetLease Amortization Type | customlist_laa_amortization_type |
NetLease Breakpoint Type | customlist_laa_pr_breakpoint |
NetLease Calendar Format | customlist_laa_calendar_format |
NetLease Checkbox Filter | customlist_laa_checkbox_filter |
NetLease Date Grouping | customlist_laa_report_date_group |
NetLease Day of Month | customlist_laa_day_of_month |
NetLease Entity Type | customlist_laa_entity_type |
NetLease Expense Convention | customlist_laa_expense_convention |
NetLease FX Setting Options | customlist_laa_fx_setting_options |
NetLease Impact Type | customlist_laa_impact_type |
NetLease Index Rates | customlist_laa_index_rates |
NetLease Journal Status | customlist_laa_list_leaseje_status |
NetLease Modification Type | customlist_laa_lease_mod_type |
NetLease Numbering Options | customlist_laa_lease_numbering_options |
NetLease Other Clause Type | customlist_laa_prov_other_clause_type |
NetLease Payment Frequency | customlist_laa_payment_frequency |
NetLease Payment Timing | customlist_laa_list_npv_calc_time |
NetLease Processing Status | customlist_laa_lp_status |
NetLease Proposal Status | customlist_laa_proposal_status |
NetLease Provision Status | customlist_laa_provision_status |
NetLease Provision Type | customlist_laa_provision_type |
NetLease Renewal Settings | customlist_laa_renewal_settings |
NetLease Report Category | customlist_laa_report_category |
NetLease Report Date Pref | customlist_laa_report_date_preference |
NetLease Report Type | customlist_laa_report_type |
NetLease ROU FX Acct. Pref. | customlist_laa_rou_fx_acct_pref |
NetLease Sourcing Types | customlist_laa_sourcing_types |
NetLease ST/LT Reclass Portion | customlist_laa_reclass_portion |
NetLease Status | customlist_laa_lease_status |
NetLease System Job Type | customlist_laa_system_job_type |
NetLease Time of Day | customlist_laa_time_of_day |
NetLease Transaction Type | customlist_laa_lease_transaction_type |
NetLease Transfer Type | customlist_laa_transfer_type |
NetLease Upgrade Preferences | customlist_laa_upgrade_preferences |
NetLease Variable Payments | customlist_laa_variable_lease_pmt_type |
NetLease YesMaybeNo | customlist_laa_yes_maybe_no |
NetLease Lease Fields | Field ID | Field Type | List/Record |
---|---|---|---|
Status | custrecord_laa_ls_status | List/Record | NetLease Status |
Lease Type | custrecord_laa_ls_type | List/Record | NetLease Lease Type |
Lease Classification | custrecord_laa_ls_classification | List/Record | NetLease Lease Classification |
Subsidiary | custrecord_laa_ls_subsidiary | List/Record | Subsidiary |
Vendor | custrecord_laa_ls_vendor | List/Record | Entity |
Customer | custrecord_laa_ls_customer | List/Record | Entity |
Currency | custrecord_laa_ls_currency | List/Record | Currency |
Historical Exchange Rate | custrecord_laa_ls_exchange_rate | Decimal Number | |
Notes | custrecord_laa_ls_notes | Long Text | |
Asset Photo | custrecord_laa_ls_photo | Image | |
Commencement Date | custrecord_laa_ls_commencement_date | Date | |
End Date | custrecord_laa_ls_end_date | Date | |
Lease Term (months) | custrecord_laa_ls_term | Integer Number | |
ROU Asset Useful Life | custrecord_laa_ls_useful_life | Integer Number | |
Initial Lease Payment | custrecord_laa_ls_initial_payment_amount | Currency | |
Discount Rate % | custrecord_laa_ls_inc_borrowing_rate | Percent | |
Prepaid Lease Payment | custrecord_laa_ls_lease_prepaid_pmt | Currency | |
Initial Direct Costs | custrecord_laa_ls_initial_direct_costs | Currency | |
Lease Incentives Received | custrecord_laa_ls_lease_incentives | Currency | |
Processing Status | custrecord_laa_ls_processing_status | Free-Form Text | |
ROU Asset Balance | custrecord_laa_ls_asset_balance | Currency | |
Liability Balance | custrecord_laa_ls_liability_balance | Currency | |
Net Balance | custrecord_laa_ls_net_balance | Currency | |
Deferred Rent Balance | custrecord_laa_ls_rent_balance | Currency | |
Department | custrecord_laa_ls_department | List/Record | Cost Center |
Class | custrecord_laa_ls_class | List/Record | Line of Business |
Location | custrecord_laa_ls_location | List/Record | Location |
Variable Rate Index | custrecord_laa_ls_var_rate_index | List/Record | NetLease Index Rates |
Variable Non-Lease Payments | custrecord_laa_ls_var_nonlease_payments | List/Record | NetLease Variable Payments |
Residual Value Guarantee | custrecord_laa_ls_residual_guarantee | Currency | |
Residual Value Estimate | custrecord_laa_ls_resid_value_estimate | Currency | |
Accounting Book | custrecord_laa_ls_accounting_book | List/Record | Accounting Book |
Secondary Book | custrecord_laa_ls_secondary_book | List/Record | Accounting Book |
Secondary Classification | custrecord_laa_ls_second_classification | List/Record | NetLease Lease Classification |
Payment Timing (NPV Calc) | custrecord_laa_ls_payment_timing | List/Record | NetLease Payment Timing |
No GL Impact | custrecord_laa_ls_no_gl_impact | Check Box | |
840 Lease; To Convert at Adoption | custrecord_laa_ls_840_lease | Check Box | |
Elimination Subsidiary | custrecord_laa_ls_elimination_subsidiary | List/Record | Subsidiary |
Lease Locked (Transactions Recorded) | custrecord_laa_ls_locked | Check Box | |
Flagged for Mass Update | custrecord_laa_ls_flagged_for_update | Check Box | |
Termination | custrecord_laa_ls_termination | List/Record | NetLease Termination |
Termination Date | custrecord_laa_ls_termination_date | Date | |
Termination Reason | custrecord_laa_ls_termination_reason | Free-Form Text | |
Termination Note | custrecord_laa_ls_termination_note | Text Area | |
Termination Cash Paid | custrecord_laa_ls_termination_cash_paid | Currency | |
Termination Cash Received | custrecord_laa_ls_termination_cash_rec | Currency | |
Script Execution Log | custrecord_laa_ls_execution_log | Text Area | |
HIDDEN: Default NPV Calculation Time | custrecord_laa_ls_npv_calc_time | List/Record | NetLease Payment Timing |
HIDDEN: Schedule Generated | custrecord_laa_ls_schedule_generated | Check Box | |
HIDDEN: Recent Modification | custrecord_laa_ls_recent_modification | List/Record | NetLease Modification |
HIDDEN: Base Currency | custrecord_laa_ls_base_currency | List/Record | Currency |
HIDDEN: Task Key | custrecord_laa_ls_task_key | Free-Form Text | |
HIDDEN: Banner JSON | custrecord_laa_ls_banner_json | Text Area | |
HIDDEN: Currency Precision | custrecord_laa_ls_currency_precision | Integer Number | |
HIDDEN: Override Go-Live Date | custrecord_laa_ls_go_live_date | Date | |
HIDDEN: Override Go-Live Exchange Rate | custrecord_laa_ls_override_exchange_rate | Decimal Number | |
HIDDEN: Gross Asset Balance | custrecord_laa_ls_asset_gross_balance | Currency | |
HIDDEN: Expense Convention | custrecord_laa_ls_expense_convention | List/Record | NetLease Expense Convention |
HIDDEN: Recent Transfer | custrecord_laa_ls_recent_transfer | List/Record | NetLease Schedule Line |
HIDDEN: Preferred Vendor Subsidiary | custrecord_laa_ls_vendor_subsidiary | List/Record | Subsidiary |
HIDDEN: Global Settings | custrecord_laa_ls_global_configuration | Long Text | |
DEPRECATED: Short Term or Low Value Lease | custrecord_laa_ls_stlv_lease | Check Box | |
HIDDEN: Subsidiary / Currency Combination | custrecord_laa_ls_sub_curr_combo | Free-Form Text | |
HIDDEN: Entity Type | custrecord_laa_ls_entity_type | List/Record | NetLease Entity Type |
HIDDEN: Created from File ID | custrecord_laa_ls_created_from_file_id | Free-Form Text | |
HIDDEN: Accounting Standard | custrecord_laa_ls_acct_standard | List/Record | NetLease Lease Accounting Standard |
Close Out Date | custrecord_laa_ls_close_out_date | Date | |
Subsidiary (No Hierarchy) | custrecord_laa_ls_sub_no_hierarchy | Free-Form Text | |
HIDDEN: Trigger Auto-Numbering | custrecord_laa_ls_trigger_auto_number | Check Box | |
1st Uplift Date | custrecord_laa_ls_uplift_date | Date | |
Uplift Frequency | custrecord_laa_ls_uplift_frequency | List/Record | NetLease Payment Frequency |
Uplift Percentage | custrecord_laa_ls_uplift_percentage | Percent | |
Uplift Amount | custrecord_laa_ls_uplift_amount | Currency | |
Uplift Frequency Multiplier | custrecord_laa_ls_uplift_freq_multi | Integer Number | |
Assigned To | custrecord_laa_ls_assigned_to | List/Record | Employee |
Parent Lease | custrecord_laa_ls_parent_lease | List/Record | NetLease Lease |
Lease Proposal | custrecord_laa_ls_proposal | List/Record | NetLease Lease Proposal |
Source Transaction | custrecord_laa_ls_source_transaction | List/Record | Transaction |
ROU Adjustment | custrecord_laa_ls_rou_adjustment | Currency | |
ROU Asset Accumulated Balance At Commencement Date | custrecord_laa_ls_asset_accum_balance | Currency | |
Billing Day | custrecord_laa_ls_billing_day | List/Record | NetLease Day of Month |
Custom Calendar | custrecord_laa_ls_custom_calendar | List/Record | NetLease Custom Calendar |
Default Payment Frequency | custrecord_laa_ls_payment_frequency | List/Record | NetLease Payment Frequency |
Transfer of Ownership? | custrecord_laa_ls_ownership_transfer | Check Box | |
Reasonably Certain Purchase Option? | custrecord_laa_ls_purchase_option | Check Box | |
Remaining Economic Life at Commencement (Months) | custrecord_laa_ls_remaining_life | Integer Number | |
Commencement Date Near End of Life? | custrecord_laa_ls_commencement_near_end | Check Box | |
Percentage of Remaining Economic Life | custrecord_laa_ls_term_percent_of_life | Free-Form Text | |
Major Part of Remaining Economic Life? | custrecord_laa_ls_term_majority_of_life | Check Box | |
Practical to Determine the Asset Fair Value? | custrecord_laa_ls_practical_fair_value | Check Box | |
Fair Value of the Underlying Asset | custrecord_laa_ls_asset_fair_value | Currency | |
Guaranteed Residual Value NOT reflected in Payments | custrecord_laa_ls_res_not_in_pmts | Currency | |
PV of Payments & Guaranteed Residual Value | custrecord_laa_ls_pv_including_residual | Currency | |
PV of Payments & Guaranteed Residual Value as % of Fair Value | custrecord_laa_ls_pv_as_percnt_of_value | Free-Form Text | |
PV equals or exceeds substantially all of the fair value? | custrecord_laa_ls_pv_exceeds_fair_value | Check Box | |
Override Lease Classification | custrecord_laa_ls_carry_forward_class | List/Record | NetLease Lease Classification |
Specialized Asset? | custrecord_laa_ls_specialized_asset | Check Box | |
Calculated Lease Classification | custrecord_laa_ls_calculated_class | List/Record | NetLease Lease Classification |
Lease Address | custrecord_laa_ls_address | List/Record | Address Book |
Impact Chart | custrecord_laa_ls_impact_chart | Inline HTML | |
Map | custrecord_laa_ls_map | Inline HTML | |
Auto Renewal | custrecord_laa_ls_is_autorenewal | Check Box | |
Default Renewal Type | custrecord_laa_ls_renewal_type | List/Record | NetLease Renewal Type |
Default Renewal Term | custrecord_laa_ls_auto_renew_term | Integer Number | |
Total Renewals | custrecord_laa_ls_renewal_total | Integer Number | |
Final Renewal End Date | custrecord_laa_ls_auto_renew_end_date | Date | |
HIDDEN: Renewal Option JSON | custrecord_laa_ls_renewal_option_json | Long Text | |
Renewal Start Date | custrecord_laa_ls_auto_renew_start_date | Date |
NetLease Schedule Line Fields | Field ID | Field Type | List/Record |
---|---|---|---|
Lease | custrecord_laa_lse_lease | List/Record | NetLease Lease |
Lease Classification | custrecord_laa_lse_classification | List/Record | NetLease Lease Classification |
Transaction Type | custrecord_laa_lse_transaction_type | List/Record | NetLease Transaction Type |
Amortization Type | custrecord_laa_lse_amortization_type | List/Record | NetLease Amortization Type |
Period Number | custrecord_laa_lse_period_number | Decimal Number | |
Period Start Date | custrecord_laa_lse_period_start_date | Date | |
Period End Date | custrecord_laa_lse_period_end_date | Date | |
Remaining Periods | custrecord_laa_lse_remaining_periods | Integer Number | |
Lease Payment | custrecord_laa_lse_payment | Currency | |
Equivalent Monthly Payment | custrecord_laa_lse_monthly_payment | Currency | |
Remaining Payment | custrecord_laa_lse_remaining_payment | Currency | |
Discount Rate % | custrecord_laa_lse_inc_borrowing_rate | Percent | |
Right of Use Asset Gross Balance (Posting) | custrecord_laa_lse_asset_gross_balance | Currency | |
Right of Use Asset Accum. Balance (Posting) | custrecord_laa_lse_asset_accum_balance | Currency | |
Right of Use Asset Net Balance (Posting) | custrecord_laa_lse_asset_balance | Currency | |
Lease Liability Balance (Posting) | custrecord_laa_lse_liability_balance | Currency | |
Net Balance (Posting) | custrecord_laa_lse_net_balance | Currency | |
Interest Expense | custrecord_laa_lse_interest | Currency | |
Allocated to Principal | custrecord_laa_lse_principal | Currency | |
Lease Liability Balance (Financing) | custrecord_laa_lse_fin_liability_balance | Currency | |
Amortization Amount (Financing) | custrecord_laa_lse_amortization_amount | Currency | |
Gross Asset Adjustment (Financing) | custrecord_laa_lse_fin_gross_asset_adj | Currency | |
Asset Adjustment (Financing) | custrecord_laa_lse_fin_asset_adjustment | Currency | |
Right of Use Asset Net Balance (Financing) | custrecord_laa_lse_fin_asset_balance | Currency | |
Right of Use Asset Gross Balance (Financing) | custrecord_laa_lse_fin_asset_gross_bal | Currency | |
Right of Use Asset Accum. Balance (Financing) | custrecord_laa_lse_fin_asset_accum_bal | Currency | |
Net Balance (Financing) | custrecord_laa_lse_fin_net_balance | Currency | |
Interest Accretion (Operating) | custrecord_laa_lse_liability_accretion | Currency | |
Allocated to Principal (Operating) | custrecord_laa_lse_liability_reduction | Currency | |
Lease Liability Balance (Operating) | custrecord_laa_lse_op_liability_balance | Currency | |
Lease Expense (Operating) | custrecord_laa_lse_lease_expense | Currency | |
Gross Asset Adjustment (Operating) | custrecord_laa_lse_op_gross_asset_adj | Currency | |
Asset Adjustment (Operating) | custrecord_laa_lse_asset_adjustment | Currency | |
Right of Use Asset Net Balance (Operating) | custrecord_laa_lse_op_asset_balance | Currency | |
Right of Use Asset Gross Balance (Operating) | custrecord_laa_lse_op_asset_gross_bal | Currency | |
Right of Use Asset Accum. Balance (Operating) | custrecord_laa_lse_op_asset_accum_bal | Currency | |
Net Balance (Operating) | custrecord_laa_lse_op_net_balance | Currency | |
Lease Expense/Income (ST/LV/Sublease) | custrecord_laa_lse_st_lease_expense | Currency | |
Allocated To Deferred/Accrued Rent (ST/LV/Sublease) | custrecord_laa_lse_alloc_deferred_rent | Currency | |
Deferred/Accrued Rent Balance (ST/LV/Sublease) | custrecord_laa_lse_deferred_rent_balance | Currency | |
Processing Status | custrecord_laa_lse_processing_status | List/Record | NetLease Processing Status |
Execution Log | custrecord_laa_lse_execution_log | Text Area | |
Current Portion of Lease Liability (Posting) | custrecord_laa_lse_st_reclass_amt | Currency | |
Journal Entry | custrecord_laa_lse_journal_entry | List/Record | Transaction |
Book Specific Journal Entry | custrecord_laa_lse_book_specific_je | List/Record | Transaction |
LT to ST Reclass Journal Entry | custrecord_laa_lse_st_reclass_journal | List/Record | Transaction |
Book-Specific LT to ST Reclass Journal Entry | custrecord_laa_lse_st_reclass_bsjournal | List/Record | Transaction |
FX Historical Adjustment Journal Entry | custrecord_laa_lse_fx_adjustment_je | List/Record | Transaction |
FX Adjustment Audit | custrecord_laa_lse_fx_audit | Free-Form Text | |
Book Specific FX Historical Adjustment Journal Entry | custrecord_laa_lse_bs_fx_adjustment_je | List/Record | Transaction |
Custom Reclass Journal Entry | custrecord_laa_lse_custom_reclass_je | List/Record | Transaction |
Book-Specific Custom Reclass Journal Entry | custrecord_laa_lse_custom_reclass_bsje | List/Record | Transaction |
Reversal Journal Entry | custrecord_laa_lse_reversal_journal | List/Record | Transaction |
Bill | custrecord_laa_lse_vendor_bill | List/Record | Transaction |
Interest Payable Balance | custrecord_laa_lse_interest_payable_amt | Currency | |
Non-Lease Payment 1 | custrecord_laa_lse_nonls_payment_1 | Currency | |
Non-Lease Payment 2 | custrecord_laa_lse_nonls_payment_2 | Currency | |
Non-Lease Payment 3 | custrecord_laa_lse_nonls_payment_3 | Currency | |
Payment Reclass Amount | custrecord_laa_lse_payment_reclass | Currency | |
Modification Detail | custrecord_laa_lse_modification_detail | List/Record | NetLease Modification |
Termination Detail | custrecord_laa_lse_termination_detail | List/Record | NetLease Termination |
Partial Expense Calculation Audit | custrecord_laa_lse_expense_calc_audit | Free-Form Text | |
Processed with No Journal Entry | custrecord_laa_lse_processed_no_entry | Check Box | |
Total Lease Expense | custrecord_laa_lse_total_expense | Currency | |
Total Payment | custrecord_laa_lse_total_payment | Currency | |
HIDDEN: Processing Record | custrecord_laa_lse_processing_record | List/Record | NetLease Transaction Processing |
HIDDEN: Reclass Processing Record | custrecord_laa_lse_reclass_record | List/Record | NetLease Transaction Processing |
HIDDEN: Bill Processing Record | custrecord_laa_lse_vendor_bill_record | List/Record | NetLease Transaction Processing |
HIDDEN: Old Subsidiary | custrecord_laa_lse_old_subsidiary | Free-Form Text | |
HIDDEN: Old Department | custrecord_laa_lse_old_department | Free-Form Text | |
HIDDEN: Old Class | custrecord_laa_lse_old_class | Free-Form Text | |
HIDDEN: Old Location | custrecord_laa_lse_old_location | Free-Form Text | |
HIDDEN: Old Segment | custrecord_laa_lse_old_segment | Free-Form Text | |
HIDDEN: Old Exchange Rate | custrecord_laa_lse_old_exchange_rate | Decimal Number | |
DEPRECATED: Is Initial Balance | custrecord_laa_lse_is_initial_balance | Check Box | |
DEPRECATED: Is Transition Entry | custrecord_laa_lse_is_transition | Check Box | |
DEPRECATED: Is Amortization Entry | custrecord_laa_lse_is_amortization | Check Box | |
DEPRECATED: Is Modification Entry | custrecord_laa_lse_is_modification | Check Box | |
DEPRECATED: Is Termination Entry | custrecord_laa_lse_is_termination | Check Box | |
DEPRECATED: Is Final Period Entry | custrecord_laa_lse_is_final_period | Check Box | |
Month Over Month Uplift Percentage | custrecord_laa_lse_month_uplift_percent | Free-Form Text | |
Uplift Percentage | custrecord_laa_lse_uplift_percentage | Free-Form Text | |
Allocated to Interest | custrecord_laa_lse_interest_paid | Currency | |
HIDDEN: Old Period Number | custrecord_laa_lse_old_period_number | Decimal Number | |
Percentage Rent Payment | custrecord_laa_lse_pr_payment | Currency | |
Total Percent Rent Expense Payable | custrecord_laa_lse_pr_accrued | Currency | |
Percentage Rent Total Payments | custrecord_laa_lse_pr_due | Currency | |
Total Sales | custrecord_laa_lse_pr_sales | Currency | |
Contract Breakpoint | custrecord_laa_lse_pr_breakpoint | Currency | |
Contract Percentage | custrecord_laa_lse_pr_percentage | Percent | |
Percentage Rent Expense Payable | custrecord_laa_lse_pr_expense | Currency | |
Percentage Rent Expense Payable Audit | custrecord_laa_lse_pr_expense_audit | Free-Form Text | |
Expense Payable Contract Provision | custrecord_laa_lse_pr_expense_contract | List/Record | NetLease Contract Provision |
Payment Contract Provision | custrecord_laa_lse_pr_payable_contract | List/Record | NetLease Contract Provision |
Rolling Monthly Breakpoint | custrecord_laa_lse_pr_rolling_breakpoint | Currency | |
Allocated to Breakpoint | custrecord_laa_lse_pr_alloc_breakpoint | Currency | |
Percentage Rent Accumulated Accrued Expense | custrecord_laa_lse_pr_acc_accr_exp | Currency | |
Percentage Rent Accrued Expense | custrecord_laa_lse_pr_accr_exp | Currency | |
HIDDEN: Percentage Rent Processing Record | custrecord_laa_lse_percent_rent_record | List/Record | NetLease Transaction Processing |