Client Implementation Valid Values Glossary

The below table lists the valid values for each of the fields listed above where a Drop-down exists. LeaseAccelerator contains detailed logic and algorithms to validate and process information based on the specific values in these fields. LA will reject the imported data file IF values entered are not in the Drop-down. (NOTE: The valid values below are contained on the DATA tab in the Client Workbooks).

Download a PDF version of the Client Implementation guide.

Workbook Section	Tab	Field Name	Valid Values
Portfolio	Schedule	Currency	See Currency List Below
Portfolio	Schedule	Frequency	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Portfolio	Schedule	Lease Type	FMV, FinLse-FixPO, FinLse-Put, First Amend, Full-Service, Gross, Lev-Debt, Lev-Equity, Loan/NSA, Municipal, Split-TRAC, Synthetic, TRAC, Triple-Net
Portfolio	Schedule	Index Basis (CIW)	See Index Basis List Below
Portfolio	Schedule	Adjustment Frequency(CIW)	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Portfolio	Schedule	Repayment Mode	Advance, Arrears
Portfolio	Schedule	Accounting Classification	Capital, Operating, Capitalized-Operating. (LA will adjust Capital to Finance for new standards)
Portfolio	Schedule	ShipTo Country	See Country List Below
Portfolio	Schedule	Geo	See Country List Below
Portfolio	Schedule	Partial Building Flag	Yes
Portfolio	Schedule	Is Sub-Leased	Yes, Blank
Portfolio	Details	Product Category	See Product Category List Below
Portfolio	Details	ShipTo Country	See Country List Below
Portfolio	Details	Units	Square Feet, Square Meters, Acres
Portfolio	Details	Utility Pricing Basis	Total, Usable, Rentable
Portfolio	EOT Options	Timing	EOT, Mid-Term
Portfolio	EOT Options	Option Type	Buyout, Other, Renewal, Return
Portfolio	EOT Options	Reasonably Certain EOT Option	Yes, No
Portfolio	EOT Options	Exercisable by Lessee	Yes, No
Portfolio	EOT Options	Utility Units	Square Feet, Square Meters, Acres
Portfolio	Notifications	Timing	Before, After
Portfolio	Notifications	Milestone	Start, EOT, Deadline
Portfolio	Notifications	Frequency	One-Time, Recurring, None
Portfolio	Notifications	Units	Days, Weeks, Months
Portfolio	Notifications	Send To	Analyst, AssetOwner, AssetUser, TreasuryApproval, Funder, OrderAdministrator, ShipTo, SourcingContact
Portfolio	Notifications	Enqueue	Record EOT
Portfolio	Notifications	Enqueue To	Analyst, AssetOwner, AssetUser, TreasuryApproval, Funder, OrderAdministrator, ShipTo, SourcingContact
Portfolio	Notifications	Enqueue Event Frequency	One-Time To-do, Recurring To-do
Portfolio	Interim Rent	Interim Rent Type	Accrue & pay at commencement, Accrue & add to the amount financed at commencement
Portfolio	Interim Rent	Interim Rent Basis	Floating, Amount
Portfolio	Interim Rent	Interim Index Type	See Index Basis List Below
Portfolio	Step Payments	Payment Frequency	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Portfolio	Payment Adjustments	Index Basis (CIW)	See Index Basis List Below
Portfolio	Payment Adjustments	Reason (CIW)	Floating Rate Adjustment, Contingency Resolved, Other (No Remeasurement)
Portfolio	Scheduled Related Expenses	Product Category	See Product Category List Below
Portfolio	Scheduled Related Expenses	Expense Type	ARO-End of Life, CAMS, IDC, Lease Incentive, Other Related Expenses, Security Deposit, Special Deposit, Late Fee, Variable/Performance
Portfolio	Scheduled Related Expenses	Expense SubType	Type = ARO-End of Life à Equipment-Refurbishment, Real Estate – Return to Original Condition; Cost to Dismantle or Remove (per Agreement) Type = CAMS à Custodial, Security, Landscaping, Artwork, Garage/Parking, Telcom Svcs, Cafeteria Svcs; Type = IDC à Commission, Payment to Prior Tenant to Terminate Early Type = Lease Incentive à Paid to Lessee, Paid On Behalf of Lessee Type = Other Related Expenses à Real Estate Taxes, Base Year/Expense Stop, Gross Up, Landlord’s Insurance, Liability Insurance, Property Insurance, Rental Loss, Utilities-Premises, After Hours Utilities – HVAC, R&M Premises, Marketing Fund, Administration Fee, Other Landlord Services; Type = Security Deposit à Blank Type = Special Deposit à Water, Sewer, Utility Type = Late Fee à Blank Variable/Performance à Daily Rate, Mileage Based, Per Unit of Production, Capacity Based
Portfolio	Scheduled Related Expenses	Frequency	Annual, Bi-Monthly, Monthly, Quarterly, Semi-Annual
Portfolio	Scheduled Related Expenses	Interest Bearing	Yes, No
Portfolio	Invoiced Related Expenses	Product Category	See Product Category List Below
Portfolio	Invoiced Related Expenses	Expense Type	ARO-End of Life, CAMS, IDC, Lease Incentive, Other Related Expense, Security Deposit, Special Deposit, Late Fee, Variable/Performance
Portfolio	Invoiced Related Expenses	Expense SubType	Type = ARO-End of Life à Equipment – Refurbishment, Real Estate – Return to Original Condition; Cost to Dismantle or Remove (per Agreement) Type = CAMS --> Custodial, Security, Landscaping, Artwork, Garage/Parking,Telcom Svcs, Cafeteria Svcs; Type = IDC à Commission, Payment to Prior Tenant to Terminate Early Type = Lease Incentive à Paid to Lessee, Paid On Behalf of Lessee Type = Other Related Expenses à Real Estate Taxes, Base Year/Expense Stop, Gross Up, Landlord’s Insurance, Liability Insurance, Property Insurance, Rental Loss, Utilities-Premises, After Hours Utilities – HVAC, R&M Premises, Marketing Fund, Administration Fee, Other Landlord Services; Type = Security Deposit à Blank Type = Special Deposit --> Water, Sewer, Utility Type = Late Fee à Blank Variable/Performance à Daily Rate, Mileage Based, Per Unit of Production, Capacity Based
Portfolio	Invoiced Related Expenses	Payment or Receipt	Payment, Receipt
Portfolio	Paid Related Expenses	Product Category	See Product Category List Below
Portfolio	Paid Related Expenses	Expense Type	ARO-End of Life, CAMS, IDC, Lease Incentive, Other Related Expense, Security Deposit, Special Deposit, Late Fee, Variable/Performance
Portfolio	Paid Related Expenses	Expense SubType	For Asset Retirement Obligations: Type = ARO-End of Life à Equipment – Refurbishment, Real Estate – Return to Original Condition For End of Life: Type = ARO-End of Life à Cost to Dismantle or Remove (per Agreement) Type = CAMS --> Custodial, Security, Landscaping, Artwork, Garage /Parking,Telcom Svcs, Cafeteria Svcs; Type = IDC à Commission, Payment to Prior Tenant to Terminate Early Type = Lease Incentive à Paid to Lessee, Paid On Behalf of Lessee Type = Other Related Expenses à Real Estate Taxes, Base Year/Expense Stop, Gross Up, Landlord’s Insurance, Liability Insurance, Property Insurance, Rental Loss, Utilities-Premises, After Hours Utilities – HVAC, R&M Premises, Marketing Fund, Administration Fee, Other Landlord Services; Type = Security Deposit à Blank Type = Special Deposit --> Water, Sewer, Utility Type = Late Fee à Blank Variable/Performance à Daily Rate, Mileage Based, Per Unit of Production, Capacity Based
Portfolio	Paid Related Expenses	Payment or Receipt	Payment, Receipt
Portfolio	Category LRFs	Product Category	See Product Category List Below
Portfolio	Documents	Document Type	See Document Type List Below
Portfolio	Documents	Document Status	Amalgam, Executed, Original, PartiallyExecuted, Substitute, Unknown
Configuration	Companies	Company Role Type	BU, Entity, Funder, Geo, Lessee, Project, PropertyTaxAuthority, Reporting Area, Vendor
Configuration	Companies	Country	See Country List Below
Configuration	Addresses	Address Role Type	ShipTo
Configuration	Addresses	Country	See Country List Below
Configuration	People	Person Role Type	AccountingAnalyst, AccountingApprover, Analyst, AssetOwner, AssetUser, TreasuryApprover, OrderAdministrator, Sourcing
Configuration	People	Country	See Country List Below
Configuration	People	Is User	Yes, No
Configuration	Geos	Geo Name	See Country List Below
Configuration	FX Rates	From Currency	See Currency List Below
Configuration	FX Rates	To Currency	USD
Configuration	Notifications	Timing	Before, After
Configuration	Notifications	Milestone	Start, EOT, Deadline
Configuration	Notifications	Frequency	One-Time, Recurring, None
Configuration	Notifications	Units	Days, Weeks, Months
Configuration	Notifications	Enqueue	RecordEOT, Alter Purchase Order Information, Alter Purchase Order line item details, Alter Purchase Requisition information, Alter Purchase Requisition line item details, Alter Schedule information, Alter Schedule line item details, Amend Proposal, Amend RFP, Answer a question, Apply Tag to Deal, Approve Award, Approve Certificate of Acceptance, Approve Credit Line, Approve Proposal, Approve RFP, Ask a question, Assess reasonableness of FMV quote, Attach a purchase requisition, Attach a Schedule, Attach an Asset Manifest, Attest to the accuracy of asset coding for cost allocation purposes, Attest to the accuracy of asset location information, Award RFP, Award selected proposal(s), Book Deal, Cancel a Purchase Requisition, Capture buyout quote from funder, Capture Certificate of Destruction, Capture funder-provided effective return date for returned assets, Capture invoicing or payment of scheduled expenses, Capture Lessee-signed Schedule, Capture Parent Guaranty, Capture PO amendment authorizing renewal of assets, Capture Purchase Order authorizing buyout of assets, Capture renewal quote from funder, Capture signed Lease Schedule, Classify document received via mailback, Compare Proposals and Review Compose e-mail, Consolidate Credit Lines, Create Certificate of Acceptance, Create Credit Line, Create Credit Usage Request, Create deal relationship, Create manifest of assets for which EOT intentions need to be declared, Create Policy Elections, Create Proposal, Create RFP, Delete artifact, Delete deal, Delete deal relationship, Designate Credit Usage Request, Designate funds for a deal, Edit Asset Manifest, Edit Asset Manifest Line items, Elaborated payment schedule and asset-level accounting (where applicable), Enable Lease Line, Enter Asset Manifest details, Enter Purchase Requisition details, Enter Schedule details, Exercise Mid-Term/EOT Option, Expire Credit Request, Expire Credit Usage Request, Generate Certificate of Acceptance, Generate Policy Elections, Generate Proposal, Generate request for credit adjustment, Generate RFP, Import deal form historical lease portfolio, Invalidate (mark as lapsed) declaration of intentions (DM), Make changes to deal form Deal Summary, Make special notes on deal status, Manually revise deal history, Modification Recorded, Modify Deal, Month-End Close, No quote needed from funder for EOT event, Pay an Invoice, Perform Accounting Classification Analysis, Perform Custom Lease vs. Buy Analysis, Perform Proposal Analysis and Review (PAR), Receive invoice, Received evergreen invoice, Reclassify Lease, Reconcile Purchase Order, Reconciled, Reconciliation started, Record a comment, Record Disposal of terminated assets, Record end-of-term intentions for assets approaching end of term, Record Funder Approved for Credit Request, Record Payment Adjustment, Record receipt of a Purchase Order, Record receipt of a Purchase Requisition, Record receipts of a Schedule, Record receipts of an invoice credit, Record signing of Certificate of Acceptance, Record start date for rental payment stream, Regenerate Accounting Classification Analysis, Reject Certificate of Acceptance, Reject Credit Line, Reject Credit Line - Need More info, Reject Credit Usage Request, Reject Proposal, Reject Reconciliation, Reject RFP, Release RFP, Remove pending task, Remove Tag from Deal, Reopen RFP, Request a credit against one of more invoices, Request Buyout Purchase Order, Request buyout quote from Funder, Request non-critical downward PO revision, Request non-critical upward PO revision, Request PO amendment for renewal, Request quote for renewal pricing from Funder, Request RMA (return authorization) for asset return, Resubmit Proposal, Reverse funded deal, Review and classify document, Revise Artifact, Run Reconciliation, Send Certificate of Acceptance to asset owner for signature, Send Credit Request to funder, Send e-mail, Send Lease Schedule for Treasury approval, Send Purchase Order to Procurement for approval, Send signed Certificate of Acceptance to Lessor, Send signed Lease Schedule to Lessor, Submit Credit Request, Submit EOT paperwork to funder for processing, Submit Proposal, Submit RFP for internal review and release, Undesignate Funds, Use the Proposal to create a pre-populated Schedule, User defined, Withdraw Proposal, Withdraw RFP
Configuration	Notifications	Enqueue To	AccountingAnalyst, AccountingApprover, Analyst, AssetOwner, AssetUser, TreasuryApprover, Funder, OrderAdministrator, ShipTo, SourcingContact
Configuration	Notifications	Enqueue Event Frequency	One-Time To-do, Recurring To-do
Configuration	Lessee Rates	Geo	See Country List Below
Configuration	Lessee Rates	Rate Type	IBR, DEBT, EQUITY
Configuration	Economic Life	Default Lease Component Treatment	Lease Component, Non-lease Component
Configuration	Economic Life	Default EOT Treatment	Evergreen Renewal (month-to-month), Terminate without Fee
Configuration	Economic Life	Product Category	See Product Category List Below
Configuration	Depreciation	Geo	See Country List Below
Configuration	Depreciation	Product Category	See Product Category List Below
Configuration	Depreciation	Book Depreciation Method	See Book Depreciation List Below
Configuration	Depreciation	Tax Depreciation Method	See Tax Depreciation List Below
Configuration	LvB Settings	Rate Type	Debt, Equity, WACC
Configuration	Salvage Value	Product Category	See Product Category List Below
Configuration	Salvage Value	Geo	See Country List Below
Configuration	Policy Threshold	Product Category	See Product Category List Below
Configuration	Policy Threshold	Geo	See Country List Below
Configuration	Lessee Info	Fiscal Year Model	Gregorian, 4/4-5 Model
Configuration	Lessee Info	Industry	See Industry List Below
Configuration	Lessee Info	Business Type	See Business Type List Below
Configuration	Lessee Info	Ownership Type	See Ownership Type List Below
Configuration	Lessee Info	Credit Rate	See Credit Rating List Below
Configuration	Lessee Info	Credit Rating Source	Dun & Bradstreet, Fitch IBCA, Moody’s, Standard and Poors
Configuration	Tax Rates	Geo	See Country List Below
Configuration	Lessee Financials	Source	SEC Filing, Annual Report, Press Release, Other
Configuration	Lessee Financials	Currency	See Currency List Below
Configuration	LA Users	Country	See Country List Below

Currency List

USD	BAM	BZD	DZD	GTQ	JOD	LSL	MVR	PEN	SDD	TMM	VND
AED	BBD	CAD	EEK	GWP	JPY	LTL	MWK	PGK	SEK	TND	VUV
AFN	BDT	CHF	EGP	GYD	KES	LVL	MXN	PHP	SGD	TOP	WST
ALL	BGN	CLF	ERN	HKD	KGS	LYD	MYR	PKR	SHP	TPE	XAF
AMD	BHD	CLP	ETB	HNL	KHR	MAD	MZN	PLN	SIT	TRY	XCD
ANG	BIF	CNY	EUR	HRK	KMF	MDL	NAD	PYG	SKK	TTD	XCG
AON	BMD	COP	FJD	HTG	KRW	MGA	NGN	QAR	SLE	TWD	XOF
AOA	BND	CRC	FKP	HUF	KWD	MKD	NIO	RON	SOS	TZS	XPF
ARA	BOB	CVE	GBP	IDR	KYD	MMK	NOK	RSD	SRG	UAH	YER
ARS	BRL	CYP	GEL	ILS	KZT	MNT	NPR	RUB	STD	UGX	ZAR
AUD	BRR	CZK	GHS	INR	LAK	MOP	NZD	RWF	SVC	UYU	ZMW
AWG	BSD	DJF	GIP	IQD	LBP	MRO	OMR	SAR	SZL	UZS	ZWD
AZM	BWP	DKK	GMD	ISK	LKR	MTL	PAB	SBD	THB	VEF	ZWG
AZN	BYN	DOP	GNS	JMD	LRD	MUR	PEI	SCR	TJR	VES

Index Basis List

Index Name
Commercial Paper – 30 Day	Swap – 7 Year
Commercial Paper – 60 Day	Swap – 10 Year
Commercial Paper – 90 Day	Swap – 30 Year
Commercial Paper – 180 Day	Treasury Constant Maturities – 1 Month
Libor – 1 Month	Treasury Constant Maturities – 3 Month
Libor – 1 Year	Treasury Constant Maturities – 6 Month
Libor – 2 Month	Treasury Constant Maturities – 9 Month
Libor – 3 Month	Treasury Constant Maturities – 1 Year
Libor – 6 Month	Treasury Constant Maturities – 2 Year
Libor – Overnight	Treasury Constant Maturities – 3 Year
Prime	Treasury Constant Maturities – 5 Year
Swap – 1 Year	Treasury Constant Maturities – 7 Year
Swap – 2 Year	Treasury Constant Maturities – 10 Year
Swap – 3 Year	Treasury Constant Maturities – 20 Year
Swap – 4 Year	Banker's Acceptance (30-Day)
Swap – 5 Year	Consumer Price Index

Country and Province List

Australian Capital Territory	ACT	Australia
New South Wales	NSW	Australia
Northern Territory	NT	Australia
Queensland	QLD	Australia
South Australia	SA	Australia
Tasmania	TAS	Australia
Victoria	VIC	Australia
Western Australia	WA	Australia
Acre	AC	Brazil
Alagoas	AL	Brazil
Amazonas	AM	Brazil
Amapá	AP	Brazil
Bahia	BA	Brazil
Ceará	CE	Brazil
Distrito Federal	DF	Brazil
Espírito Santo	ES	Brazil
Goiás	GO	Brazil
Maranhão	MA	Brazil

Northwest Territories	NT	Canada
Nunavut	NU	Canada
Ontario	ON	Canada
Prince Edward Island	PE	Canada
Quebec	QC	Canada
Saskatchewan	SK	Canada
Yukon Territory	YT	Canada
Anhui	CNAH	China
Beijing	CNBJ	China
Chongqing	CNCQ	China
Fujian	CNFJ	China
Guangdong	CNGD	China
Gansu	CNGS	China
Guangxi Zhuang	CNGX	China
Guizhou	CNGZ	China
Hainan	CNHA	China
Hebei	CNHB	China
Henan	CNHE	China

Xinjiang Uygur	CNXJ	China
Xizang	CNXZ	China
Yunnan	CNYN	China
Zhejiang	CNZJ	China
Andaman and Nicobar Islands	AN	India
Andhra Pradesh	AP	India
Arunachal Pradesh	AR	India
Assam	AS	India
Bihar	BR	India
Chandigarh	CHD	India
Daman and Diu	DD	India
Jammu and Kashmir	JK	India
Kerala	KER	India
Karnataka	KRN	India
Ladakh	LA	India
Lakshadweep	LKP	India
Maharashtra	MAH	India

Minas Gerais	MG	Brazil
Mato Grosso do Sul	MS	Brazil
Mato Grosso	MT	Brazil
Pará	PA	Brazil
Paraíba	PB	Brazil
Pernambuco	PE	Brazil
Piauí	PI	Brazil
Paraná	PR	Brazil
Rio de Janeiro	RJ	Brazil
Rio Grande do Norte	RN	Brazil
Rondônia	RO	Brazil
Roraima	RR	Brazil
Rio Grande do Sul	RS	Brazil
Santa Catarina	SC	Brazil
Sergipe	SE	Brazil
São Paulo	SP	Brazil
Tocantins	TO	Brazil
Alberta	AB	Canada
British Columbia	BC	Canada
Manitoba	MB	Canada
New Brunswick	NB	Canada
Newfoundland	NL	Canada
Nova Scotia	NS	Canada
Kildare	KE	Ireland
Kilkenny	KK	Ireland
Laoighis	LS	Ireland
Leitrim	LM	Ireland
Limerick	LK	Ireland
Longford	LD	Ireland
Louth	LH	Ireland
Mayo	MO	Ireland
Meath	MH	Ireland
Monaghan	MN	Ireland
Offaly	OY	Ireland
Roscommon	RN	Ireland
Sligo	SO	Ireland
Tipperary	TA	Ireland
Waterford	WD	Ireland
Westmeath	WH	Ireland
Wexford	WX	Ireland
Wicklow	WW	Ireland
Abruzzi	AB	Italy
Agrigento	AG	Italy
Alessandria	AL	Italy
Ancona	AN	Italy
Aosta	AO	Italy
Ascoli Piceno	AP	Italy
L'Aquila	AQ	Italy
Arezzo	AR	Italy
Asti	AT	Italy
Avellino	AV	Italy
Bari	BA	Italy
Basilicata	BC	Italy
Belluno	BL	Italy
Benevento	BN	Italy
Bergamo	BG	Italy
Biella	BI	Italy
Bologna	BO	Italy
Bolzano	BZ	Italy
Brescia	BS	Italy
Brindisi	BR	Italy
Cagliari	CA	Italy
Calabria	CI	Italy
Caltanisetta	CL	Italy
Campania	CM	Italy

Heilongjiang	CNHL	China
Hunan	CNHN	China
Hubei	CNHU	China
Jiangsu	CNJS	China
Jiangxi	CNJX	China
Jilin	CNJL	China
Liaoning	CNLN	China
Nei Mongol	CNNM	China
Ningxia Hui	CNNX	China
Qinghai	CNQH	China
Shaanxi	CNSA	China
Shandong	CNSD	China
Shanghai	CNSH	China
Shanxi	CNSX	China
Sichuan	CNSC	China
Tianjin	CNTJ	China
Delhi	DEL	India
Dadra and Nagar Haveli	DNH	India
Goa	GOA	India
Gujarat	GUJ	India
Himachal Pradesh	HP	India
Haryana	HR	India
Jharkhand	JH	India
Campobasso	CB	Italy
Caserta	CE	Italy
Catania	CT	Italy
Catanzaro	CZ	Italy
Chieti	CH	Italy
Como	CO	Italy
Cosenza	CS	Italy
Cremona	CR	Italy
Crotone	KR	Italy
Cuneo	NC	Italy
Emilia-Romagna	ER	Italy
Enna	EN	Italy
Ferrara	FE	Italy
Firenze	FI	Italy
Foggia	FG	Italy
Forli	FO	Italy
Friuli-Venezia Giulia	FV	Italy
Frosinone	FR	Italy
Genova	GE	Italy
Gorizia	GO	Italy
Grosseto	GR	Italy
Imperia	IM	Italy
Isernia	IS	Italy
La Spezia	SP	Italy
Latina	LT	Italy
Lazio	LZ	Italy
Lecce	LE	Italy
Lecco	LC	Italy
Liguria	LG	Italy
Livorno	LI	Italy
Lodi	LO	Italy
Lombardy	LM	Italy
Lucca	LU	Italy
Macerata	MC	Italy
Mantova	MN	Italy
Marche	MH	Italy
Massa-Carrara	MS	Italy
Matera	MT	Italy
Messina	ME	Italy
Milano	MI	Italy
Modena	MO	Italy
Molise	ML	Italy

Meghalaya	MEG	India
Mizoram	MIZ	India
Manipur	MNP	India
Madhya Pradesh	MP	India
Nagaland	NLD	India
Odisha	OD	India
Puducherry	PY	India
Punjab	PU	India
Rajasthan	RAJ	India
Sikkim	SKM	India
Tamil Nadu	TN	India
Telangana	TS	India
Tripura	TRP	India
Uttarakhand	UK	India
Uttar Pradesh	UP	India
West Bengal	WB	India
Carlow	CW	Ireland
Cavan	CN	Ireland
Claire	CE	Ireland
Cork	C	Ireland
Donegal	DL	Ireland
Dublin	D	Ireland
Galway	G	Ireland
Kerry	KY	Ireland
Napoli	NA	Italy
Novara	NO	Italy
Nuoro	NU	Italy
Oristano	OR	Italy
Padova	PD	Italy
Palermo	PA	Italy
Parma	PR	Italy
Pavia	PV	Italy
Perugia	PG	Italy
Pesaro-Urbino	PS	Italy
Pescara	PE	Italy
Piacenza	PC	Italy
Piedmont	PM	Italy
Pisa	PI	Italy
Pistoia	PT	Italy
Pordenone	PN	Italy
Potenza	PZ	Italy
Prato	PO	Italy
Ragusa	RG	Italy
Ravenna	RA	Italy
Reggio di Calabria	RC	Italy
Reggio nell-Emilia	RE	Italy
Rieti	RI	Italy
Rimini	RN	Italy
Roma	RM	Italy
Rovigo	RO	Italy
Salerno	SA	Italy
Sardinia	SD	Italy
Sassari	SS	Italy
Savona	SV	Italy
Sicily	SC	Italy
Siena	SI	Italy
Siracusa	SR	Italy
Sondrio	SO	Italy
Taranto	TA	Italy
Teramo	TE	Italy
Terni	TR	Italy
Torino	TO	Italy
Trapani	TP	Italy
Trentino-Alto Adige	TT	Italy
Trento	TN	Italy
Treviso	TV	Italy

Trieste	TS	Italy
Tuscany	TC	Italy
Udine	UD	Italy
Umbria	UM	Italy
Valle d’Aosta	VD	Italy
Varese	VA	Italy
Veneto	VN	Italy
Venezia	VE	Italy
Verbania	VB	Italy
Vercelli	VC	Italy
Verona	VR	Italy
Vibo Valentia	VV	Italy
Vicenza	VI	Italy
Viterbo	VT	Italy
Aichi	JP23	Japan
Akita	JP04	Japan
Aomori	JP02	Japan
Chiba	JP11	Japan
Ehime	JP38	Japan
Fukui	JP20	Japan
Fukuoka	JP40	Japan
Fukushima	JP07	Japan
Gifu	JP19	Japan
Gumma	JP10	Japan
Hiroshima	JP34	Japan
Hokkaido	JP01	Japan
Hyogo	JP26	Japan
IIbaraki	JP08	Japan
Ishikawa	JP17	Japan
Iwate	JP03	Japan
Kagawa	JP36	Japan
Kagoshima	JP46	Japan
Kanagawa	JP14	Japan
Kochi	JP39	Japan
Kumamoto	JP44	Japan
Kyoto	JP25	Japan
Mie	JP27	Japan
Miyagi	JP05	Japan
Miyazaki	JP45	Japan
Nagano	JP18	Japan
Nagasaki	JP42	Japan
Nara	JP28	Japan

Niigata	JP15	Japan
Oita	JP43	Japan
Okayama	JP33	Japan
Okinawa	JP47	Japan
Osaka	JP29	Japan
Saga	JP41	Japan
Saitama	JP12	Japan
Shiga	JP24	Japan
Shimane	JP32	Japan
Shizuoka	JP22	Japan
Tochigi	JP09	Japan
Tokushima	JP37	Japan
Tokyo	JP13	Japan
Tottori	JP31	Japan
Toyama	JP16	Japan
Wakayama	JP30	Japan
Yamagata	JP06	Japan
Yamaguchi	JP35	Japan
Yamanashi	JP21	Japan
Aguascalientes	AGS	Mexico
Baja California	BCN	Mexico
Baja California Sur	BCS	Mexico
Campeche	CAM	Mexico
Chihuahua	CHIH	Mexico
Chiapas	CHIS	Mexico
Coahuila	COAH	Mexico
Colima	COL	Mexico
Distrito Federal	DF	Mexico
Durango	DGO	Mexico
Guerrero	GRO	Mexico
Guanajuato	GTO	Mexico
Hidalgo	HGO	Mexico
Jalisco	JAL	Mexico
Mexico	MEX	Mexico
Michoacán	MICH	Mexico
Morelos	MOR	Mexico
Nayarit	NAY	Mexico
Nuevo León	NL	Mexico
Oaxaca	OAX	Mexico
Puebla	PUE	Mexico
Querétaro	QRO	Mexico
Quintana Roo	QROO	Mexico

Sinaloa	SIN	Mexico
San Luis Potosí	SLP	Mexico
Sonora	SON	Mexico
Tabasco	TAB	Mexico
Tamaulipas	TAMP	Mexico
Tlaxcala	TLAX	Mexico
Veracruz	VER	Mexico
Yucatán	YUC	Mexico
Zacatecas	ZAC	Mexico
Alabama	AL	US
Alaska	AK	US
Arizona	AZ	US
Arkansas	AR	US
California	CA	US
Colorado	CO	US
Connecticut	CT	US
Delaware	DE	US
District of Columbia	DC	US
Florida	FL	US
Georgia	GA	US
Hawaii	HI	US
Idaho	ID	US
Illinois	IL	US
Indiana	IN	US
Iowa	IA	US
Kansas	KS	US
Kentucky	KY	US
Louisiana	LA	US
Maine	ME	US
Maryland	MD	US
Massachusetts	MA	US
Michigan	MI	US
Minnesota	MN	US
Mississippi	MS	US
Missouri	MO	US
Montana	MT	US
Nebraska	NE	US
Nevada	NV	US
New Hampshire	NH	US
New Jersey	NJ	US
New Mexico	NM	US
New York	NY	US

North Carolina	NC	US
North Dakota	ND	US
Ohio	OH	US
Oklahoma	OK	US
Oregon	OR	US
Pennsylvania	PA	US
Puerto Rico	PR	US

Rhode Island	RI	US
South Carolina	SC	US
South Dakota	SD	US
Tennessee	TN	US
Texas	TX	US
US Virgin Islands	VI	US
Utah	UT	US

Vermont	VT	US
Virginia	VA	US
Washington	WA	US
West Virginia	WV	US
Wisconsin	WI	US
Wyoming	WY	US

Country List

US*	Bouvet Island	Dominican Republic	Guinea
Afghanistan	Brazil*	East Timor	Guinea-Bissau
Aland Island	British Indian Ocean Territory	Ecuador	Guyana
Albania	Brunei	Egypt	Haiti
Algeria	Bulgaria	El Salvador	Heard Island and McDonald Islands
American Samoa	Burkina Faso	Equatorial Guinea	Honduras
Andorra	Burundi	Eritrea	Hong Kong
Angola	Cambodia	Estonia	Hungary
Anguilla	Cameroon	Ethiopia	Iceland
Antarctica	Canada	Falkland Islands (Malvinas)	India*
Antigua and Barbuda	Cape Verde	Faroe Islands	Indonesia
Argentina*	Cayman Islands	Fiji	Iraq
Armenia	Central African Republic	Finland	Ireland
Aruba	Chad	France*	Isle of Man
Australia*	Chile	French Guiana	Israel
Austria	China*	French Polynesia	Italy
Azerbaijan	Christmas Island	French Southern Territories	Ivory Coast
Bahamas	Cocos (Keeling) Islands	Gabon	Jamaica
Bahrain	Colombia	Gambia	Japan*
Bangladesh	Comoros	Georgia	Jersey
Barbados	Congo	Germany*	Jordan
Belarus	Congo, The Democratic Republic of the	Ghana	Kazakhstan
Belgium*	Cook Islands	Gibraltar	Kenya
Belize	Costa Rica	Greece	Kiribati
Benin	Croatia	Greenland	Korea, Republic of*
Bermuda	Cyprus	Grenada	Kuwait
Bhutan	Czech Republic*	Guadeloupe	Kyrgyzstan
Bolivia	Denmark	Guam	Laos
Bosnia-Herzegovina	Djibouti	Guatemala	Latvia
Botswana	Dominica	Guernsey	Lebanon
Lesotho	Netherlands Antilles	Saint Helena	Togo
Liberia	Netherlands*	Saint Kitts and Nevis	Tokelau
Libya	New Caledonia	Saint Lucia	Tonga
Liechtenstein	New Zealand*	Saint Pierre and Miquedon	Trinidad and Tobago
Lithuania	Nicaragua	Saint Vincent and the Grenadines	Tunisia
Luxembourg	Niger	Samoa	Turkey*
Macao	Nigeria	San Marino	Turkmenistan
Madagascar	Niue	Sao Tome and Principe	Turks and Caicos Islands
Malawi	Norfolk Islands	Saudi Arabia	Tuvalu
Malaysia	North Macedonia, Republic of	Senegal	Uganda
Maldives	Northern Mariana Islands	Serbia	Ukraine
Mali	Norway*	Seychelles	United Arab Emirates
Malta	Oman	Sierra Leone	United Kingdom*
Marshall Islands	Pakistan	Singapore*	United States Minor Outlying Islands
Martinique	Palau	Slovakia	Uruguay*
Mauritania	Palestinian Territory, Occupied	Slovenia	Uzbekistan
Mauritius	Panama	Solomon Islands	Vanuatu
Mayotte	Papua New Guinea	Somalia	Vatican City
Mexico*	Paraguay	South Africa*	Venezuela
Micronesia, Federated States of	Peru	Spain*	Vietnam
Moldova, Republic of	Philippines*	Sri Lanka	Virgin Islands, British
Monaco	Pitcairn	Suriname	Virgin Islands, U.S.
Mongolia	Poland*	Svalbard and Jan Mayen	Wallis and Futuna
Montserrat	Portugal	Swaziland	Western Sahara
Morocco	Puerto Rico*	Sweden*	Yemen
Mozambique	Qatar	Switzerland	Zambia
Myanmar	Reunion	Taiwan, Province of China	Zimbabwe
Nambia	Romania*	Tajikistan
Nauru	Russia*	Tanzania, United Republic of
Nepal	Rwanda	Thailand

* indicates countries that have tax payment calendars configured in LeaseAccelerator

Product Category List

Agriculture and Forestry	Electronics	Mobile Shop Equipment (Soft Costs)	Stadium Suite
Aircraft and Related	Emergency Vehicles	Modular Building	Recreation
Automobiles	Energy Systems	Mold Tools	Restaurant Fixtures
Broadcast/Audiovisual	Food Processing	Office Equipment	Retail Fixtures
Building Improvement/Equipment	Furniture and Fixtures	Office Equipment (Soft Costs)	Semiconductor
Building Improvement/Equipment (Soft Costs)	Furniture and Fixtures (Soft Costs)	Oil and Gas	Software
Building/HVAC	Gaming	Other	Telecommunications
Buses	Laboratory Equipment	Packaging/Bottling	Telecommunications (Soft Costs)
Computers/Peripherals	Machine/Shop Equipment	Point of Sale	Telephone Systems
Networking	Power Tools	Power and Pipeline	Telephone Systems (Soft Costs)
Servers	Manufacturing/Fabricating	Power and Pipeline (Soft Costs)	Test and Measurement
Storage	Manufacturing/Fabricating (Soft Costs)	Printing/Publishing	Trailers
Supercomputer	Marine	Rail	Trucks
Supercomputer (Soft Costs)	Material Handling	Real Estate	Trucks (Soft Costs)
Computers/Peripherals (Soft Costs)	Material Handling (Soft Costs)	Billboards	Waste Remediation/Recycling
Construction	Medical	Building
Containers	Mining	Data Center
Durable Tooling	Mobile Shop Equipment	Land

Document Types

AmendmentRequisition	BuyoutQuote	EOTDocument	LeaseReviewChecklist	PurchaseOrder
AnnexA	CofA	EquipmentList	LessorDownload	PurchaseRequisition
AssetManifest	CofI	ExemptionCertificate	LvBAnalysis	ReconciliationBundle
Assignment	CorpGuaranty	ExternalEmail	MLA	RenewalQuote
Attachment	CoverSheet	FinancingPackage	NDA	RentalInvoice
BillOfSale	CustomerFinancials	Invoice	OneOffLease	Schedule
BillingInformation	DealSummary	InvoiceCredit	PayProceeds	ScheduleAmendment
BlanketApproval	DeclarationManifest	JurisdictionRider	PriceQuote	StipLossTable
BuyoutInvoice	DisposalManifest	LandlordWaiver	ProofOfDisposal	UCCFiling

Depreciation Methods

Book Depreciation Method
8% Declining Balance	Straight Line 3-Year
10% Declining Balance	Straight Line 4-Year
18% Declining Balance	Straight Line 5-Year
20% Declining Balance	Straight Line 6-Year
20% Declining Balance (5-year)	Straight Line 7-Year
20% Declining Balance (5-year, switch to SLM)	Straight Line 8-Year
25% Declining Balance	Straight Line 9-Year
40% Declining Balance	Straight Line 10-Year
40% Declining Balance (5-year)	Straight Line 15-Year
40% Declining Balance (5-year, switch to SLM)	Straight Line 20-Year
Straight Line 1-Year	Straight Line 30-Year
Straight Line 2-Year	Straight Line 40-Year

Tax Depreciation Method
US equipment depreciation (2018-2022)	10-Year MACRS
8% Declining Balance	10-Year MACRS (2011 Bonus Depreciation)
10% Declining Balance	10-Year MACRS (2012 Bonus Depreciation)
18% Declining Balance	10-Year MACRS (2013 Bonus Depreciation)
20% Declining Balance	Straight Line 1-Year
25% Declining Balance	Straight Line 2-Year
40% Declining Balance	Straight Line 3-Year
3-Year MACRS	Straight Line 4-Year
3-Year MACRS (2011 Bonus Depreciation)	Straight Line 5-Year
3-Year MACRS (2012 Bonus Depreciation)	Straight Line 6-Year
3-Year MACRS (2013 Bonus Depreciation)	Straight Line 7-Year
5-Year MACRS	Straight Line 8-Year
5-Year MACRS (2011 Bonus Depreciation)	Straight Line 9-Year
5-Year MACRS (2012 Bonus Depreciation)	Straight Line 10-Year
5-Year MACRS (2013 Bonus Depreciation)	Straight Line 15-Year
7-Year MACRS	Straight Line 20-Year
7-Year MACRS (2011 Bonus Depreciation)	Straight Line 30-Year
7-Year MACRS (2012 Bonus Depreciation)	Straight Line 40-Year
7-Year MACRS (2013 Bonus Depreciation)	Not Applicable

Industry, Ownership Type, and Business Type

Industry
Aerospace and Defense Public Closely Held Private Company	Non-Profit
Agriculture, Forestry and Fishing Private Co-Operative Organization	Oil and Gas
Air Transport Government Owned Corporation	Paper
Automotive Corporation (Example: US 'C' Corp)	Pharmaceuticals and Biotechnology
Broadcasting, Cable TV and Entertainment General Partnership	Printing and Publishing
Casinos and Gaming Government Agency	Professional Services
Chemicals Joint Venture	Railroads
Computers and Information Technologies Limited Liability Company	Recreation
Construction Limited Liability Partnership	Restaurants and Food Services
Fabric and Apparel Limited Partnership	Retail
Federal Government Municipality	Software
Finance, Insurance and Real Estate Non-Profit	State and Local Government
Food Processing, Beverages and Tobacco Non-Profit	Telecommunications
Healthcare Services Other	Trucking
Hotels and Motels Pty Ltd	Utilities (Power, Water and Gas)
Industrial and Manufacturing Simple Partnership (Example: US 'S' Corp)	Waste Management
Mining Sole Proprietorship	Water Transport

Ownership Type
Public
Private
Government Owned

Business Type
Closely Held Private Company	Joint Venture	Other
Co-Operative Organization	Limited Liability Company	Pty Ltd
Corporation	Limited Liability Partnership	Simple Partnership (Example: US 'S' Corp)
Corporation (Example: US 'C' Corp)	Limited Partnership	Sole Proprietorship
General Partnership	Municipality
Government Agency	Non-Profit

Lease Type Definitions and Genre

Key:

EQ = Equipment
RE = Real Estate

The following table defines the Lease Types and the business rules applicable to determining each.

Lease Type	Lease Genre	Value in PIW	Definition	Business Rule to Identify
Absolute Lease	RE	Absolute	Tenant pays rent PLUS all operating expenses (taxes, insurance, maintenance), AND major structural repairs, such as the roof. Essentially, the tenant is responsible for all costs as if they owned the property. Rent is usually much less than other lease types because the tenant is covering all expenses. A stricter version of a triple-net lease, usually for long-term, single-tenant deals.
Base Year Lease	RE	Base-Year	Sub-type of a full-service lease. Tenant only pays rent for a base year, then pays rent PLUS a portion of operating expenses that exceed the base year amount in subsequent years.
Double Net Lease (NN)	RE	Double-Net	Tenant pays rent PLUS property taxes and insurance.
Finance Lease - $1Out Mandatory Purchase	EQ	FinLse-Put	Lease which requires the Lessee to purchase the assets at the end of the term.	Any of the following: Title to assets automatically transfers to Lessee at the end of term Buyout Price = $1 Language similar to “Lessee is required to purchase assets”
Finance Lease – Fixed Purchase Option	EQ	FinLse-FixPO	Lease granting Lessee the option to purchase the assets at a fixed amount.	Any of the following: Option to Buy at a price of $$$
First Amendment Lease	EQ	First Amend	A lease which contains a first amendment clause. Used for Lessees who may opt to purchase equipment early. Typically includes a penalty for non-purchase or requires the Lessee to renew for a fixed number of months.
Full-Service Lease	RE	Full-Service	A lease where the Base Rent includes a baseline cost for CAMS and Other Rent charges, but lease allows landlord to pass through incremental charges or credits to reflect the actual cost of CAMS and Other Rent expenses.	Real Estate Lease where: CAMS charges listed CAMS benchmark cost identified Contains CAMS Billing language Contains CAMS expense Reconciliation language
Leveraged Lease Debt	EQ	Lev-Debt	A lease agreement that is partially financed by the Lessor through a third-party financial institution. In a leveraged lease, the lending company holds the title to the leased asset, while the lessor creates the agreement with the Lessee and collects the payment. The payments are then passed on to the lender.
Leveraged Lease Equity	EQ	Lev-Equity
Loan / Note & Security Agreement	EQ	Loan/NSA	This is not a lease but a financed purchase either as a loan or promissory note.
Modified Gross Lease	RE	Gross	A lease where the Base Rent includes all costs including CAMS and Other Rent; however, utilities may be separately identified as a cost where the landlord is allowed to pass through incremental charges or credits to reflect the actual Utility costs.	Real Estate lease where: Base Rent language exists Only Utility Cost Benchmark is identified Excess Utility cost pass through language Utility uses reconciliation language This is the default Lease Type for Real Estate
Municipal Lease Purchase	EQ	Municipal	A municipal or tax-exempt lease agreement allows a political subdivision to use annual revenues to make payments for any type of essential use equipment or facilities. While municipal leases are documented as a lease, they have characteristics similar to a loan. The Lessee owns the equipment at the end of the lease, and the lease can be paid off early. These financing agreements are structured as a lease to accommodate the fiscal funding restrictions of political subdivisions. In most cases, the obligation terminates if the Lessee fails to appropriate funds to make the renewal year's lease payments. Because of this provision, neither the lease nor the lease payments are considered debt (in most states).
Other Financial Product	EQ	Other
Split-TRAC Lease	EQ	Split-TRAC	A modified TRAC lease where the Lessor assumes part of the estimated residual value risk which may allow the Lessee to classify the transaction as an operating lease.	Includes a possible return fee such that the Lessee has limited responsibility for the fee
Synthetic Lease	EQ	Synthetic	A disguised loan. Treated as a loan for tax purposes and an operating lease (off-balance sheet financing) for accounting purposes. Relies on Lessee to exercise FMV purchase option or pay substantial penalty for non-renewal.
TRAC Lease	EQ	TRAC	Terminal Rental Adjustment Clause. A Lessee guaranteed residual value for vehicle leases (automobiles – trucks or trailers), the inclusion of which will not in and of itself disqualify the tax lease status of a tax-oriented vehicle lease.	Includes a possible return fee that is born solely by the Lessee
Triple-Net Lease	RE	Triple-Net	A lease where the Base Rent Rate excludes the full cost of CAMS and Other Rent expenses on a monthly basis.	Real Estate Lease where: Base Rent Rate excludes the full cost of CAMS and Other Rent expenses on a monthly basis CAMS and Other Rent pass through language
True/Operating Lease (FMV)	EQ	FMV	Lease granting the Lessee the option to purchase the assets at the FMV of the lease equipment at the option date. Option may be at the FMV or at a defined percentage of the FMV.	May include the following: True Lease Contains purchase option Contains language referencing Lessee ability to buyout the asset at a date. This is default lease type for non-Real Estate leases

USD	BAM	BZD	DZD	GTQ	JOD	LSL	MVR	PEN	SDD	TMM	VND
AED	BBD	CAD	EEK	GWP	JPY	LTL	MWK	PGK	SEK	TND	VUV
AFN	BDT	CHF	EGP	GYD	KES	LVL	MXN	PHP	SGD	TOP	WST
ALL	BGN	CLF	ERN	HKD	KGS	LYD	MYR	PKR	SHP	TPE	XAF
AMD	BHD	CLP	ETB	HNL	KHR	MAD	MZN	PLN	SIT	TRY	XCD
ANG	BIF	CNY	EUR	HRK	KMF	MDL	NAD	PYG	SKK	TTD	XCG
AON	BMD	COP	FJD	HTG	KRW	MGA	NGN	QAR	SLE	TWD	XOF
AOA	BND	CRC	FKP	HUF	KWD	MKD	NIO	RON	SOS	TZS	XPF
ARA	BOB	CVE	GBP	IDR	KYD	MMK	NOK	RSD	SRG	UAH	YER
ARS	BRL	CYP	GEL	ILS	KZT	MNT	NPR	RUB	STD	UGX	ZAR
AUD	BRR	CZK	GHS	INR	LAK	MOP	NZD	RWF	SVC	UYU	ZMW
AWG	BSD	DJF	GIP	IQD	LBP	MRO	OMR	SAR	SZL	UZS	ZWD
AZM	BWP	DKK	GMD	ISK	LKR	MTL	PAB	SBD	THB	VEF	ZWG
AZN	BYN	DOP	GNS	JMD	LRD	MUR	PEI	SCR	TJR	VES

USD	BAM	BZD	DZD	GTQ	JOD	LSL	MVR	PEN	SDD	TMM	VND
AED	BBD	CAD	EEK	GWP	JPY	LTL	MWK	PGK	SEK	TND	VUV
AFN	BDT	CHF	EGP	GYD	KES	LVL	MXN	PHP	SGD	TOP	WST
ALL	BGN	CLF	ERN	HKD	KGS	LYD	MYR	PKR	SHP	TPE	XAF
AMD	BHD	CLP	ETB	HNL	KHR	MAD	MZN	PLN	SIT	TRY	XCD
ANG	BIF	CNY	EUR	HRK	KMF	MDL	NAD	PYG	SKK	TTD	XCG
AON	BMD	COP	FJD	HTG	KRW	MGA	NGN	QAR	SLE	TWD	XOF
AOA	BND	CRC	FKP	HUF	KWD	MKD	NIO	RON	SOS	TZS	XPF
ARA	BOB	CVE	GBP	IDR	KYD	MMK	NOK	RSD	SRG	UAH	YER
ARS	BRL	CYP	GEL	ILS	KZT	MNT	NPR	RUB	STD	UGX	ZAR
AUD	BRR	CZK	GHS	INR	LAK	MOP	NZD	RWF	SVC	UYU	ZMW
AWG	BSD	DJF	GIP	IQD	LBP	MRO	OMR	SAR	SZL	UZS	ZWD
AZM	BWP	DKK	GMD	ISK	LKR	MTL	PAB	SBD	THB	VEF	ZWG
AZN	BYN	DOP	GNS	JMD	LRD	MUR	PEI	SCR	TJR	VES