> ## Documentation Index > Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt > Use this file to discover all available pages before exploring further. # The lots a capex proposal's capitalization plan is capitalized in, each with its depreciation. > The lots a capex proposal's capitalization plan is capitalized in, each with its depreciation. capitalization_date is the day the lot becomes an asset and capitalization_value what it is capitalized at; the lots of a plan add up to its total capitalization value before it can be approved. asset_block_id is its block, a value of your organisation's Asset Block Master list, and tnc_asset_type_id its TNC asset type, a value of the TNC Asset Type Master list, given only where the block is Plant and Machinery (is_plant_and_machinery). asset_block_value is what it is depreciated on. depreciation_rate_percent (the Applicable Depreciation Rate) is the block's rate and shift_factor (the Shift Factor proposed) the proposal's location's Shift Factor for Plant and Machinery and 1 otherwise, both as they were when the lot was saved in its block, and kept while it stays there. Worked out, never stored, for the planned year (PY1) and the four after it: months_py1 to months_py5 are the months of each year the lot is depreciated for, 12 for a year it was capitalized before, 0 for a year it is capitalized after, and otherwise from the month of the capitalization date to the year's last month, both counted; depreciation_py1 to depreciation_py5 are asset_block_value times depreciation_rate_percent over a hundred, over twelve, times that year's months and shift_factor, rounded to two places. month_01 to month_12 are the planned year's depreciation shared equally among its months from the month of capitalization to the twelfth, rounded to two places with the twelfth taking the rounding, and null for the months before; depreciation_py1_total adds them up and equals depreciation_py1. Every worked-out figure is null where the lot's block has no rate. You see the lots of every plan you can see in capex_capitalization_plans. ## OpenAPI ````yaml /api-reference/openapi.json get /capex_capitalization_lines openapi: 3.0.0 info: description: '' title: >- The only schema PostgREST exposes. Reads are security_invoker views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every deploy — it holds no data. version: 12.2.3 servers: - url: https://app.assetinfinity.ai/api security: [] tags: - name: Signing in - name: Profile - name: My work - name: Sites and locations - name: Assets - name: Asset lifecycle - name: Asset components - name: Kits - name: Work lifecycle - name: Work order execution - name: Work sequencing - name: Maintenance - name: Inspections - name: Checklists - name: Verification - name: Self verification - name: Inventory - name: Inventory detail - name: Parts demand - name: Procurement - name: Catalogue - name: Vendors and contracts - name: Contracts - name: Amendments - name: Vendor spend forecast - name: Workforce - name: Workforce detail - name: Capacity - name: Dispatch - name: Shutdown - name: Permits - name: Tools - name: Tools on jobs - name: Bookings - name: Booking hand over - name: Booking bills - name: Calibration history - name: Reliability - name: Sensors and meters - name: Readers - name: Trackers - name: Real-time location - name: Feeds - name: Energy - name: IT assets - name: IT asset software - name: IT asset topology - name: Warranty lookups - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Visitors - name: Root cause analysis - name: Costing - name: Finance - name: E-way bills - name: E-way bill filing - name: Budgets - name: Capex plans - name: Capex consolidation - name: Capex capitalization - name: FF&E plans - name: Documents - name: Document control - name: Document folders - name: Document tree - name: Knowledge - name: Reports - name: Dashboards - name: Extracts - name: Data exports - name: Audit center - name: Audit feed - name: Activity - name: Conversations - name: Notifications - name: Date reminders - name: Channels - name: Search - name: Copilot - name: Import - name: Bulk jobs - name: File exchange - name: Filing exceptions - name: Files - name: Sync - name: Support - name: API keys - name: Webhooks - name: MCP connections - name: MCP sign-in - name: SCIM provisioning - name: Directory sync - name: Security streams - name: Clarity - name: Single sign-on - name: Two-factor sign-in - name: Admin - name: Access - name: Lookups - name: Read models - name: Reference - name: Reference columns - name: Reference entry - name: List views - name: Mapping - name: Numbering - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Today - name: Work configuration - name: Asset configuration - name: Inventory configuration - name: Tool configuration - name: Workforce configuration - name: Vendor and contract configuration - name: Document configuration - name: Inspection configuration - name: Sites, locations and the organisation - name: Setup - name: Features - name: Billing - name: Licence - name: Welcome - name: Tray - name: Tenant switch - name: Release - name: Upgrade - name: Telegram - name: Whatsapp - name: Inbound mail - name: Platform externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /capex_capitalization_lines: get: tags: - Capex capitalization summary: >- The lots a capex proposal's capitalization plan is capitalized in, each with its depreciation. description: >- The lots a capex proposal's capitalization plan is capitalized in, each with its depreciation. capitalization_date is the day the lot becomes an asset and capitalization_value what it is capitalized at; the lots of a plan add up to its total capitalization value before it can be approved. asset_block_id is its block, a value of your organisation's Asset Block Master list, and tnc_asset_type_id its TNC asset type, a value of the TNC Asset Type Master list, given only where the block is Plant and Machinery (is_plant_and_machinery). asset_block_value is what it is depreciated on. depreciation_rate_percent (the Applicable Depreciation Rate) is the block's rate and shift_factor (the Shift Factor proposed) the proposal's location's Shift Factor for Plant and Machinery and 1 otherwise, both as they were when the lot was saved in its block, and kept while it stays there. Worked out, never stored, for the planned year (PY1) and the four after it: months_py1 to months_py5 are the months of each year the lot is depreciated for, 12 for a year it was capitalized before, 0 for a year it is capitalized after, and otherwise from the month of the capitalization date to the year's last month, both counted; depreciation_py1 to depreciation_py5 are asset_block_value times depreciation_rate_percent over a hundred, over twelve, times that year's months and shift_factor, rounded to two places. month_01 to month_12 are the planned year's depreciation shared equally among its months from the month of capitalization to the twelfth, rounded to two places with the twelfth taking the rounding, and null for the months before; depreciation_py1_total adds them up and equals depreciation_py1. Every worked-out figure is null where the lot's block has no rate. You see the lots of every plan you can see in capex_capitalization_plans. parameters: - $ref: '#/components/parameters/rowFilter.capex_capitalization_lines.id' - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.capex_capitalization_plan_id - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.capex_plan_line_id - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.scheme_code - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.created_at - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.updated_at - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.capitalization_date - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.capitalization_value - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.asset_block_id - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.asset_block_name - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.is_plant_and_machinery - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.tnc_asset_type_id - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.tnc_asset_type_name - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.asset_block_value - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_rate_percent - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.shift_factor - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.months_py1 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py1 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.months_py2 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py2 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.months_py3 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py3 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.months_py4 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py4 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.months_py5 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py5 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_01 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_02 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_03 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_04 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_05 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_06 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_07 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_08 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_09 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_10 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_11 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.month_12 - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.depreciation_py1_total - $ref: >- #/components/parameters/rowFilter.capex_capitalization_lines.currency_id - $ref: '#/components/parameters/select' - $ref: '#/components/parameters/order' - $ref: '#/components/parameters/range' - $ref: '#/components/parameters/rangeUnit' - $ref: '#/components/parameters/offset' - $ref: '#/components/parameters/limit' - $ref: '#/components/parameters/preferCount' responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/capex_capitalization_lines' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/capex_capitalization_lines' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/capex_capitalization_lines' type: array text/csv: schema: items: $ref: '#/components/schemas/capex_capitalization_lines' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.capex_capitalization_lines.id: in: query name: id required: false schema: type: string rowFilter.capex_capitalization_lines.capex_capitalization_plan_id: in: query name: capex_capitalization_plan_id required: false schema: type: string rowFilter.capex_capitalization_lines.capex_plan_line_id: in: query name: capex_plan_line_id required: false schema: type: string rowFilter.capex_capitalization_lines.scheme_code: in: query name: scheme_code required: false schema: type: string rowFilter.capex_capitalization_lines.created_at: in: query name: created_at required: false schema: type: string rowFilter.capex_capitalization_lines.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.capex_capitalization_lines.capitalization_date: in: query name: capitalization_date required: false schema: type: string rowFilter.capex_capitalization_lines.capitalization_value: in: query name: capitalization_value required: false schema: type: string rowFilter.capex_capitalization_lines.asset_block_id: in: query name: asset_block_id required: false schema: type: string rowFilter.capex_capitalization_lines.asset_block_name: in: query name: asset_block_name required: false schema: type: string rowFilter.capex_capitalization_lines.is_plant_and_machinery: in: query name: is_plant_and_machinery required: false schema: type: string rowFilter.capex_capitalization_lines.tnc_asset_type_id: in: query name: tnc_asset_type_id required: false schema: type: string rowFilter.capex_capitalization_lines.tnc_asset_type_name: in: query name: tnc_asset_type_name required: false schema: type: string rowFilter.capex_capitalization_lines.asset_block_value: in: query name: asset_block_value required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_rate_percent: in: query name: depreciation_rate_percent required: false schema: type: string rowFilter.capex_capitalization_lines.shift_factor: in: query name: shift_factor required: false schema: type: string rowFilter.capex_capitalization_lines.months_py1: in: query name: months_py1 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py1: in: query name: depreciation_py1 required: false schema: type: string rowFilter.capex_capitalization_lines.months_py2: in: query name: months_py2 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py2: in: query name: depreciation_py2 required: false schema: type: string rowFilter.capex_capitalization_lines.months_py3: in: query name: months_py3 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py3: in: query name: depreciation_py3 required: false schema: type: string rowFilter.capex_capitalization_lines.months_py4: in: query name: months_py4 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py4: in: query name: depreciation_py4 required: false schema: type: string rowFilter.capex_capitalization_lines.months_py5: in: query name: months_py5 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py5: in: query name: depreciation_py5 required: false schema: type: string rowFilter.capex_capitalization_lines.month_01: in: query name: month_01 required: false schema: type: string rowFilter.capex_capitalization_lines.month_02: in: query name: month_02 required: false schema: type: string rowFilter.capex_capitalization_lines.month_03: in: query name: month_03 required: false schema: type: string rowFilter.capex_capitalization_lines.month_04: in: query name: month_04 required: false schema: type: string rowFilter.capex_capitalization_lines.month_05: in: query name: month_05 required: false schema: type: string rowFilter.capex_capitalization_lines.month_06: in: query name: month_06 required: false schema: type: string rowFilter.capex_capitalization_lines.month_07: in: query name: month_07 required: false schema: type: string rowFilter.capex_capitalization_lines.month_08: in: query name: month_08 required: false schema: type: string rowFilter.capex_capitalization_lines.month_09: in: query name: month_09 required: false schema: type: string rowFilter.capex_capitalization_lines.month_10: in: query name: month_10 required: false schema: type: string rowFilter.capex_capitalization_lines.month_11: in: query name: month_11 required: false schema: type: string rowFilter.capex_capitalization_lines.month_12: in: query name: month_12 required: false schema: type: string rowFilter.capex_capitalization_lines.depreciation_py1_total: in: query name: depreciation_py1_total required: false schema: type: string rowFilter.capex_capitalization_lines.currency_id: in: query name: currency_id required: false schema: type: string select: description: Filtering Columns in: query name: select required: false schema: type: string order: description: Ordering in: query name: order required: false schema: type: string range: description: Limiting and Pagination in: header name: Range required: false schema: type: string rangeUnit: description: Limiting and Pagination in: header name: Range-Unit required: false schema: default: items type: string offset: description: Limiting and Pagination in: query name: offset required: false schema: type: string limit: description: Limiting and Pagination in: query name: limit required: false schema: type: string preferCount: description: Preference in: header name: Prefer required: false schema: enum: - count=none type: string schemas: capex_capitalization_lines: description: >- The lots a capex proposal's capitalization plan is capitalized in, each with its depreciation. capitalization_date is the day the lot becomes an asset and capitalization_value what it is capitalized at; the lots of a plan add up to its total capitalization value before it can be approved. asset_block_id is its block, a value of your organisation's Asset Block Master list, and tnc_asset_type_id its TNC asset type, a value of the TNC Asset Type Master list, given only where the block is Plant and Machinery (is_plant_and_machinery). asset_block_value is what it is depreciated on. depreciation_rate_percent (the Applicable Depreciation Rate) is the block's rate and shift_factor (the Shift Factor proposed) the proposal's location's Shift Factor for Plant and Machinery and 1 otherwise, both as they were when the lot was saved in its block, and kept while it stays there. Worked out, never stored, for the planned year (PY1) and the four after it: months_py1 to months_py5 are the months of each year the lot is depreciated for, 12 for a year it was capitalized before, 0 for a year it is capitalized after, and otherwise from the month of the capitalization date to the year's last month, both counted; depreciation_py1 to depreciation_py5 are asset_block_value times depreciation_rate_percent over a hundred, over twelve, times that year's months and shift_factor, rounded to two places. month_01 to month_12 are the planned year's depreciation shared equally among its months from the month of capitalization to the twelfth, rounded to two places with the twelfth taking the rounding, and null for the months before; depreciation_py1_total adds them up and equals depreciation_py1. Every worked-out figure is null where the lot's block has no rate. You see the lots of every plan you can see in capex_capitalization_plans. properties: asset_block_id: description: >- Note: This is a Foreign Key to `capex_asset_blocks.id`. format: uuid type: string asset_block_name: format: character varying maxLength: 150 type: string asset_block_value: format: numeric type: number capex_capitalization_plan_id: description: >- Note: This is a Foreign Key to `capex_capitalization_plans.id`. format: uuid type: string capex_plan_line_id: description: >- Note: This is a Foreign Key to `capex_plan_lines.id`. format: uuid type: string capitalization_date: format: date type: string capitalization_value: format: numeric type: number created_at: format: timestamp with time zone type: string currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string depreciation_py1: format: numeric type: number depreciation_py1_total: format: numeric type: number depreciation_py2: format: numeric type: number depreciation_py3: format: numeric type: number depreciation_py4: format: numeric type: number depreciation_py5: format: numeric type: number depreciation_rate_percent: format: numeric type: number id: description: |- Note: This is a Primary Key. format: uuid type: string is_plant_and_machinery: format: boolean type: boolean month_01: format: numeric type: number month_02: format: numeric type: number month_03: format: numeric type: number month_04: format: numeric type: number month_05: format: numeric type: number month_06: format: numeric type: number month_07: format: numeric type: number month_08: format: numeric type: number month_09: format: numeric type: number month_10: format: numeric type: number month_11: format: numeric type: number month_12: format: numeric type: number months_py1: format: integer type: integer months_py2: format: integer type: integer months_py3: format: integer type: integer months_py4: format: integer type: integer months_py5: format: integer type: integer scheme_code: format: character varying maxLength: 60 type: string shift_factor: format: numeric type: number tnc_asset_type_id: description: >- Note: This is a Foreign Key to `capex_asset_blocks.id`. format: uuid type: string tnc_asset_type_name: format: character varying maxLength: 150 type: string updated_at: format: timestamp with time zone type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.