> ## 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 T&C appraisal notes: the papers a manager's IT purchase is appraised on before it is bought, a row per note, each… > The T&C appraisal notes: the papers a manager's IT purchase is appraised on before it is bought, a row per note, each with the items it buys in tnc_appraisal_note_items. tc_no is the note's T&C/No., given when it is added from the TC number series (TC-0000001 unless your organisation set another format) and never typed. category_master_id is the Category, a value of your organisation's list named Category Master (see capex_category_master_values), beside its name. site_id and location_id are the BUSA: the unit the purchase is for, which the note is read under and its approval filed at, and the place inside it where the note names one. item_type is MIS or NON_MIS. manager_location_id is a value of your organisation's list named Manager Location (see tnc_manager_locations). manager_name, emp_code and grade are typed, up to 100, 10 and 100 characters. item_count is how many items the note buys, and gross_total, gst_total and net_total the sum of their gross values, their GST, and the two together, in the currency currency_id names, which is your organisation's own. The note is approved in a workflow of its own, sent with submit_tnc_appraisal_note once it is written; note_needs lists the columns it still needs before it can be sent or approved, and items where it buys nothing, empty when nothing. note_standing is where it stands in the words the screen uses: DRAFT while no request holds it, IN_APPROVAL while one does, APPROVED when the last level approves it (or at once when sent with no workflow to ask) and REJECTED when a level rejects it, which is final. note_status is the stored half of that, OPEN until the note is decided, with note_status_reason what the rejecting approver said. request_id and request_display_status are its approval request, the open one where there is one; last_approved_by_name and last_approved_at who last approved a level of it, and when. may_edit says whether you may change it now: while it is with its approvers only the approver it waits on may, and otherwise anybody holding finance.tnc_appraisal_note.edit, until it is decided. may_send says whether you may send it. created_at, created_by_id and created_by_name say when the note was added and by whom; created_source says what added it where nobody signed in did. updated_at, updated_by_id and updated_by_name say when it was last changed and by whom. The last level's approval is carried out in the name of the person who sent the note, so on an approved note it is last_approved_by_name, not updated_by_name, that says who approved it. You see every note on the units you can read if you may view T&C appraisal notes. Without that, you see a note only while a step of its approval is waiting on you under your own authority. ## OpenAPI ````yaml /api-reference/openapi.json get /tnc_appraisal_notes 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: Capex approval notes - name: T&C appraisal notes - name: Capex change logs - 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: User activity - 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: /tnc_appraisal_notes: get: tags: - T&C appraisal notes summary: >- The T&C appraisal notes: the papers a manager's IT purchase is appraised on before it is bought, a row per note, each… description: >- The T&C appraisal notes: the papers a manager's IT purchase is appraised on before it is bought, a row per note, each with the items it buys in tnc_appraisal_note_items. tc_no is the note's T&C/No., given when it is added from the TC number series (TC-0000001 unless your organisation set another format) and never typed. category_master_id is the Category, a value of your organisation's list named Category Master (see capex_category_master_values), beside its name. site_id and location_id are the BUSA: the unit the purchase is for, which the note is read under and its approval filed at, and the place inside it where the note names one. item_type is MIS or NON_MIS. manager_location_id is a value of your organisation's list named Manager Location (see tnc_manager_locations). manager_name, emp_code and grade are typed, up to 100, 10 and 100 characters. item_count is how many items the note buys, and gross_total, gst_total and net_total the sum of their gross values, their GST, and the two together, in the currency currency_id names, which is your organisation's own. The note is approved in a workflow of its own, sent with submit_tnc_appraisal_note once it is written; note_needs lists the columns it still needs before it can be sent or approved, and items where it buys nothing, empty when nothing. note_standing is where it stands in the words the screen uses: DRAFT while no request holds it, IN_APPROVAL while one does, APPROVED when the last level approves it (or at once when sent with no workflow to ask) and REJECTED when a level rejects it, which is final. note_status is the stored half of that, OPEN until the note is decided, with note_status_reason what the rejecting approver said. request_id and request_display_status are its approval request, the open one where there is one; last_approved_by_name and last_approved_at who last approved a level of it, and when. may_edit says whether you may change it now: while it is with its approvers only the approver it waits on may, and otherwise anybody holding finance.tnc_appraisal_note.edit, until it is decided. may_send says whether you may send it. created_at, created_by_id and created_by_name say when the note was added and by whom; created_source says what added it where nobody signed in did. updated_at, updated_by_id and updated_by_name say when it was last changed and by whom. The last level's approval is carried out in the name of the person who sent the note, so on an approved note it is last_approved_by_name, not updated_by_name, that says who approved it. You see every note on the units you can read if you may view T&C appraisal notes. Without that, you see a note only while a step of its approval is waiting on you under your own authority. parameters: - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.id' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.tc_no' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.created_at' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.updated_at' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.category_master_id - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.category_name' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.site_id' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.site_name' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.location_id' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.location_name' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.item_type' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.manager_name' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.manager_location_id - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.manager_location_name - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.emp_code' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.grade' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.currency_id' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.item_count' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.gross_total' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.gst_total' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.net_total' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.note_status' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.note_status_reason - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.note_decided_at - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.note_standing' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.request_id' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.request_display_status - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.last_approved_by_user_id - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.last_approved_by_name - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.last_approved_at - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.created_by_id' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.created_by_name - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.created_source' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.updated_by_id' - $ref: >- #/components/parameters/rowFilter.tnc_appraisal_notes.updated_by_name - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.note_needs' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.may_edit' - $ref: '#/components/parameters/rowFilter.tnc_appraisal_notes.may_send' - $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/tnc_appraisal_notes' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/tnc_appraisal_notes' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/tnc_appraisal_notes' type: array text/csv: schema: items: $ref: '#/components/schemas/tnc_appraisal_notes' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.tnc_appraisal_notes.id: in: query name: id required: false schema: type: string rowFilter.tnc_appraisal_notes.tc_no: in: query name: tc_no required: false schema: type: string rowFilter.tnc_appraisal_notes.created_at: in: query name: created_at required: false schema: type: string rowFilter.tnc_appraisal_notes.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.tnc_appraisal_notes.category_master_id: in: query name: category_master_id required: false schema: type: string rowFilter.tnc_appraisal_notes.category_name: in: query name: category_name required: false schema: type: string rowFilter.tnc_appraisal_notes.site_id: in: query name: site_id required: false schema: type: string rowFilter.tnc_appraisal_notes.site_name: in: query name: site_name required: false schema: type: string rowFilter.tnc_appraisal_notes.location_id: in: query name: location_id required: false schema: type: string rowFilter.tnc_appraisal_notes.location_name: in: query name: location_name required: false schema: type: string rowFilter.tnc_appraisal_notes.item_type: in: query name: item_type required: false schema: type: string rowFilter.tnc_appraisal_notes.manager_name: in: query name: manager_name required: false schema: type: string rowFilter.tnc_appraisal_notes.manager_location_id: in: query name: manager_location_id required: false schema: type: string rowFilter.tnc_appraisal_notes.manager_location_name: in: query name: manager_location_name required: false schema: type: string rowFilter.tnc_appraisal_notes.emp_code: in: query name: emp_code required: false schema: type: string rowFilter.tnc_appraisal_notes.grade: in: query name: grade required: false schema: type: string rowFilter.tnc_appraisal_notes.currency_id: in: query name: currency_id required: false schema: type: string rowFilter.tnc_appraisal_notes.item_count: in: query name: item_count required: false schema: type: string rowFilter.tnc_appraisal_notes.gross_total: in: query name: gross_total required: false schema: type: string rowFilter.tnc_appraisal_notes.gst_total: in: query name: gst_total required: false schema: type: string rowFilter.tnc_appraisal_notes.net_total: in: query name: net_total required: false schema: type: string rowFilter.tnc_appraisal_notes.note_status: in: query name: note_status required: false schema: type: string rowFilter.tnc_appraisal_notes.note_status_reason: in: query name: note_status_reason required: false schema: type: string rowFilter.tnc_appraisal_notes.note_decided_at: in: query name: note_decided_at required: false schema: type: string rowFilter.tnc_appraisal_notes.note_standing: in: query name: note_standing required: false schema: type: string rowFilter.tnc_appraisal_notes.request_id: in: query name: request_id required: false schema: type: string rowFilter.tnc_appraisal_notes.request_display_status: in: query name: request_display_status required: false schema: type: string rowFilter.tnc_appraisal_notes.last_approved_by_user_id: in: query name: last_approved_by_user_id required: false schema: type: string rowFilter.tnc_appraisal_notes.last_approved_by_name: in: query name: last_approved_by_name required: false schema: type: string rowFilter.tnc_appraisal_notes.last_approved_at: in: query name: last_approved_at required: false schema: type: string rowFilter.tnc_appraisal_notes.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.tnc_appraisal_notes.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.tnc_appraisal_notes.created_source: in: query name: created_source required: false schema: type: string rowFilter.tnc_appraisal_notes.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.tnc_appraisal_notes.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.tnc_appraisal_notes.note_needs: in: query name: note_needs required: false schema: type: string rowFilter.tnc_appraisal_notes.may_edit: in: query name: may_edit required: false schema: type: string rowFilter.tnc_appraisal_notes.may_send: in: query name: may_send 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: tnc_appraisal_notes: description: >- The T&C appraisal notes: the papers a manager's IT purchase is appraised on before it is bought, a row per note, each with the items it buys in tnc_appraisal_note_items. tc_no is the note's T&C/No., given when it is added from the TC number series (TC-0000001 unless your organisation set another format) and never typed. category_master_id is the Category, a value of your organisation's list named Category Master (see capex_category_master_values), beside its name. site_id and location_id are the BUSA: the unit the purchase is for, which the note is read under and its approval filed at, and the place inside it where the note names one. item_type is MIS or NON_MIS. manager_location_id is a value of your organisation's list named Manager Location (see tnc_manager_locations). manager_name, emp_code and grade are typed, up to 100, 10 and 100 characters. item_count is how many items the note buys, and gross_total, gst_total and net_total the sum of their gross values, their GST, and the two together, in the currency currency_id names, which is your organisation's own. The note is approved in a workflow of its own, sent with submit_tnc_appraisal_note once it is written; note_needs lists the columns it still needs before it can be sent or approved, and items where it buys nothing, empty when nothing. note_standing is where it stands in the words the screen uses: DRAFT while no request holds it, IN_APPROVAL while one does, APPROVED when the last level approves it (or at once when sent with no workflow to ask) and REJECTED when a level rejects it, which is final. note_status is the stored half of that, OPEN until the note is decided, with note_status_reason what the rejecting approver said. request_id and request_display_status are its approval request, the open one where there is one; last_approved_by_name and last_approved_at who last approved a level of it, and when. may_edit says whether you may change it now: while it is with its approvers only the approver it waits on may, and otherwise anybody holding finance.tnc_appraisal_note.edit, until it is decided. may_send says whether you may send it. created_at, created_by_id and created_by_name say when the note was added and by whom; created_source says what added it where nobody signed in did. updated_at, updated_by_id and updated_by_name say when it was last changed and by whom. The last level's approval is carried out in the name of the person who sent the note, so on an approved note it is last_approved_by_name, not updated_by_name, that says who approved it. You see every note on the units you can read if you may view T&C appraisal notes. Without that, you see a note only while a step of its approval is waiting on you under your own authority. properties: category_master_id: description: >- Note: This is a Foreign Key to `capex_budget_categories.id`. format: uuid type: string category_name: format: character varying maxLength: 150 type: string created_at: format: timestamp with time zone type: string created_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string created_by_name: format: character varying maxLength: 200 type: string created_source: format: text type: string currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string emp_code: format: character varying maxLength: 10 type: string grade: format: character varying maxLength: 100 type: string gross_total: format: numeric type: number gst_total: format: numeric type: number id: description: |- Note: This is a Primary Key. format: uuid type: string item_count: format: bigint type: integer item_type: format: character varying maxLength: 16 type: string last_approved_at: format: timestamp with time zone type: string last_approved_by_name: format: character varying maxLength: 200 type: string last_approved_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string location_id: format: uuid type: string location_name: format: character varying maxLength: 200 type: string manager_location_id: description: >- Note: This is a Foreign Key to `capex_budget_categories.id`. format: uuid type: string manager_location_name: format: character varying maxLength: 150 type: string manager_name: format: character varying maxLength: 100 type: string may_edit: format: boolean type: boolean may_send: format: boolean type: boolean net_total: format: numeric type: number note_decided_at: format: timestamp with time zone type: string note_needs: format: text[] items: type: string type: array note_standing: format: text type: string note_status: format: character varying maxLength: 16 type: string note_status_reason: format: text type: string request_display_status: format: text type: string request_id: format: uuid type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string site_name: format: character varying maxLength: 200 type: string tc_no: format: character varying maxLength: 60 type: string updated_at: format: timestamp with time zone type: string updated_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string updated_by_name: format: character varying maxLength: 200 type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.