Expense Amortization Plan

Internal ID: expenseplan

Fields

Internal ID Type nlapiSubmitField Label Required Help
amount currency false Amount false
amountsource text false Amount Source false
catchupperiod select false Catch Up Period false This field is blank until the check is cleared from the Hold Expense Amortization box. When the hold is removed, the catch up period defaults to the earliest open period. You can change the catch up period to any open period. Period that are locked for accounts payable as part of the period close checklist are generally not available to select as catch up periods.
comments text false Comments false
createdfrom select false Created From false
creationtriggeredby select false Creation Triggered By false
customform select false Custom Form false
enddatechangeimpact text false End Date Change Impact false
externalid text false ExternalId false
holdrevenuerecognition checkbox false Hold Expense Amortization false Check this box to place the expense amortization plan on hold. When you check the box, the status changes to On Hold. When a plan is on hold, amortization journal entries cannot be generated for any period in the plan. Clear the box to resume amortizing expenses. Expense that was not amortized while the plan was on hold is recognized in the catch up period.
initialamount currency false Initial Amount false
iseliminate checkbox false Eliminate false
item select false Item false
periodoffset text false Period Offset false
recalcadjustperiodoffset integer false Recalculation Adjustment Period Offset false
recognitionmethod text false Recognition Method false
recognitionperiod integer false Recognition Period false
recordnumber text false Number false
reforecastmethod select false Reforecast Method false
relatedrevenuearrangement select false Related Revenue Arrangement false
relatedrevenueelement select false Related Revenue Element false
remainingdeferredbalance currency false Remaining Deferred Balance false
residual currency2 false Residual false This is the amount or percentage that remains in the deferral account and is not be amortized. A residual amount generally represents the salvage value of a fixed asset.
revenueplancurrency text false Expense Plan Currency false
revenueplantype select false Expense Plan Type false
revenuerecognitionrule select false Expense Amortization Rule false
revenueschedulekey text false None false
revrecenddate date false Amortization End Date true
revrecenddatesource text false Amortization End Date Source false
revrecstartdate date false Amortization Start Date true
revrecstartdatesource text false Amortization Start Date Source false
startoffset text false Start Offset false
status select false Status false
termindays integer false Expense Term In Days false
terminmonths integer false Expense Term In Months false
totalrecognized currency false Total Amortized false
tranlineuniquekey text false None false
transactionbook text false None false
transactiondoc text false None false
transactionline text false None false

Sublists

plannedexpense - Planned Expense

Internal ID Type Label Required Help
amount currency Amount true
dateexecuted date Date Executed false
deferredrevenueaccount select Source Account false
isrecognized checkbox Is Amortized false
journal text Journal false
percentrecognizedinperiod percent % Amortized in Period false
percenttotalrecognized percent % Total Amortized false
periodcomments text Period Comments false
plannedperiod select Planned Period true
plannedrevenue text Planned Expense false
plannedrevenuetype text Planned Expense Type false
postingperiod text Posting Period false
recognitionaccount select Expense Account false

Search Joins

Join ID Join Description Actual Join Name
customer Customer Customer
expenseamortizationrule Expense Amortization Rule Expense Amortization Rule
transaction Transaction Transaction
user User Employee

Search Filters

Internal ID Type Label
accountingbook select Accounting Book
amount currency Amount
amountsource select Amortization Amount Source Type
catchupperiod select Catch Up Period
comments text Comments
createdfrom select Created From
creationtriggeredby select Creation Triggered By
datecreated datetime Date Created
dateexecuted date Date Executed
deferralaccount select Deferred Expense Account
enddatechangeimpact select Amortization End Date Change Impact
exchangerate currency Exchange Rate
externalid select External ID
externalidstring text External ID (Text)
holdrevenuerecognition checkbox Hold Expense Amortization
initialamount currency Initial Amount
internalid select Internal ID
internalidnumber integer Internal ID (Number)
iseliminate checkbox Eliminate
isrecognized checkbox Is Recognized
item select Item
journal select Journal
lastmodifieddate datetime Date Last Modified
lineamount currency Amount (Line Level)
linetotalrecognized currency Total Recognized (Line Level)
percentrecognizedinperiod percent % Recognized in Period
percenttotalrecognized percent % Total Recognized
periodcomments text Period Comments
periodoffset integer Period Offset
plannedperiod select Planned Period
postingperiod select Posting Period
recalcadjustperiodoffset integer Recalculation Adjustment Period Offset
recognitionaccount select Expense Account
recognitionmethod select Recognition Method
recognitionperiod integer Recognition Period
recordnumber text Number
reforecastmethod select Reforecast Method
relatedrevenuearrangement select Related Revenue Arrangement
relatedrevenueelement select Related Revenue Element
remainingdeferredbalance currency Remaining Deferred Balance
residual currency Residual
revenueplancurrency text Expense Plan Currency
revenueplantype select Expense Plan Type
revenuerecognitionrule select Expense Amortization Rule
revrecenddate date Amortization End Date
revrecenddatesource select Amortization End Date Source Type
revrecstartdate date Amortization Start Date
revrecstartdatesource select Amortization Start Date Source Type
startoffset integer Start Offset
status select Status
termindays integer Expense Term In Days
terminmonths integer Expense Term In Months
totalrecognized currency Total Recognized

Search Columns

Internal ID Type Label
accountingbook select Accounting Book
amount currency Amount
amountsource text Amortization Amount Source Type
catchupperiod select Catch Up Period
comments text Comments
createdfrom text Created From
creationtriggeredby text Creation Triggered By
datecreated datetime Date Created
dateexecuted date Date Executed
deferralaccount text Deferred Expense Account
enddatechangeimpact text Amortization End Date Change Impact
exchangerate currency Exchange Rate
externalid select External ID
holdrevenuerecognition checkbox Hold Expense Amortization
initialamount currency Initial Amount
internalid select Internal ID
iseliminate checkbox Eliminate
isrecognized checkbox Is Recognized
item select Item
journal text Journal
lastmodifieddate datetime Last Modified
lineamount currency Amount (Line Level)
linetotalrecognized currency Total Recognized (Line Level)
percentrecognizedinperiod percent % Recognized in Period
percenttotalrecognized percent % Total Recognized
periodcomments text Period Comments
periodoffset integer Period Offset
plannedperiod text Planned Period
postingperiod text Posting Period
recalcadjustperiodoffset integer Recalculation Adjustment Period Offset
recognitionaccount text Expense Account
recognitionmethod text Recognition Method
recognitionperiod integer Recognition Period
recordnumber text Number
reforecastmethod select Reforecast Method
relatedrevenuearrangement select Related Revenue Arrangement
relatedrevenueelement select Related Revenue Element
remainingdeferredbalance currency Remaining Deferred Balance
residual currency Residual
revenueplancurrency text Expense Plan Currency
revenueplantype select Expense Plan Type
revenuerecognitionrule select Expense Amortization Rule
revrecenddate date Amortization End Date
revrecenddatesource text Amortization End Date Source Type
revrecstartdate date Amortization Start Date
revrecstartdatesource text Amortization Start Date Source Type
startoffset integer Start Offset
status text Status
termindays integer Expense Term In Days
terminmonths integer Expense Term In Months
totalrecognized currency Total Recognized