Amortization Schedule

Internal ID: amortizationschedule

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountingbook	select	false	Accounting Book	false
amortizationtype	select	false	Type	false
enddate	date	false	End Date	false
externalid	text	false	ExternalId	false
initialamount	rate	false	Initial Amount	false
isinactive	checkbox	false	Inactive	false
job	select	false	Project	false
name	text	false	Name	true
parentSched	select	false	Template	false
periodoffset	integer	false	Period Offset	true
recogintervalsrc	select	false	Term Source	false
recurrencetype	select	false	Method	false
remainingdeferredbalance	currency	false	Remaining Deferred Balance	false
residual	rate	false	Residual	false
revrecoffset	integer	false	Start Offset	true
schedulenumber	text	false	Number	false
sourcetran	select	false	Created From	false
startdate	date	false	Start Date	false
status	select	false	Status	false
totalamortized	currency	false	Total Amortized	false
totalamount	currency2	false	Amount	false

Sublists

recurrence - Custom Recurrence Pattern

Internal ID	Type	Label	Required
defrevaccount	select	Account	false
id	integer		false
incomeaccount	text		false
isrecognized	checkbox	Is Recognized	false
jdate	date	Date Executed	false
journal	text	Journal	false
periodoffset	integer	Period Offset	true
postingperiod	text		false
recamount	rate	Amount	true
recurdate	date	Date	false

Search Joins

Join ID	Join Description	Actual Join Name
user	User	Employee
vendor	Vendor	Vendor

Search Filters

Internal ID	Type	Label
accountingbook	select	Accounting Book
amorstatus	select	Status
amortizedamount	currency	Total Amortized
amortype	select	Type
amount	currency	Amount
currencyname	select	Schedule Currency
deferredamount	currency	Remaining Deferred Balance
destacct	select	Destination Account
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
initialamt	currency	Initial Amount
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isrecognized	checkbox	Is Recognized?
name	text	Schedule Name
pctcomplete	float	% Complete
pctrecognition	float	% Recog.
periodoffset	integer	Period Offset
postperiod	select	Posting Period
residual	currency	Residual
scheddate	date	Date
schedulenumber	integer	Number
schedulenumbertext	text	Number/ID
sourceacct	select	Source Account
srctranpostperiod	select	Source Transaction Posting Period
srctrantype	select	Transaction Type
startoffset	integer	Start Offset
templatename	text	Template Name
useforeignamounts	checkbox	Use Transaction Currency

Search Columns

Internal ID	Type	Label
accountingbook	select	Accounting Book
amorstatus	text	Status
amortemplate	select	Template Name
amortizedamount	currency	Total Amortized
amortype	text	Type
amount	currency	Amount (Schedule Total)
currency	select	Schedule Currency
deferredamount	currency	Remaining Deferred Balance
destacct	select	Destination Account
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
initialamt	currency	Initial Amount
internalid	select	Internal ID
isrecognized	checkbox	Is Recognized?
name	text	Schedule Name
pctcomplete	percent	% Complete
pctrecognition	percent	% Recog.
periodoffset	integer	Period Offset
recuramount	currency	Amount
recurfxamount	currency	Amount (Foreign Currency)
residual	currency	Residual
scheddate	date	Date
schedulenumber	text	Number
sourceacct	select	Source Account
srctran	select	Source Transaction
srctranpostperiod	select	Posting Period
startoffset	integer	Start Offset
useforeignamounts	checkbox	Use Transaction Currency