Get all invoices
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
invoice_view| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| internal_number |
Internal number to identify the invoice |
string | |
| company_id |
Foreign key to company, identifies the company of the invoice |
globally unique identifier | |
| company_code |
Company code of the invoice |
string | |
| company_name |
Company name of the invoice |
string | |
| company_email |
Company email of the invoice |
string | |
| company_phone |
Company phone of the invoice |
string | |
| date_create |
Invoice creation date in utc |
date | |
| memo |
Memo field for invoice |
string | |
| description |
Decription field for invoice |
string | |
| invoice_type |
Invoice type, possible values “ContractGenerated“ and “WorkOrderApproval“ |
string | |
| source_type |
Source of invoice, refers to the type of the object from which invoice is derived |
string | |
| source_id_in_table |
Key of the object from which the invoice is derived |
globally unique identifier | |
| total_lines |
Total amount of lines linked to the invoice |
integer | |
| total_amount |
Total value of items in lines linked to the invoice |
decimal number | |
| db_currency_id |
Key of db_currency entity, identifies the db_currency of the invoice |
globally unique identifier | |
| total_taxes |
Total taxes |
decimal number | |
| due_date |
The due date |
date | |
| source_db_table_name |
The name of db table |
string | |
| delivery_name |
The delivery name |
string | |
| delivery_street |
The street for delivery |
string | |
| delivery_city |
The city for delivery |
string | |
| delivery_zip |
The zip for delivery |
string | |
| delivery_db_country_name |
The country name for delivery |
string | |
| reference_back_office |
Reference data for back office |
string | |
| db_payment_method_id |
Payment method id |
globally unique identifier | |
| id2 |
id for internal |
integer | |
| customer_remarks |
Customer remarks |
string | |
| bill_to_party |
The bill to party |
string | |
| bill_to_contact_id |
Contact id for bill |
globally unique identifier | |
| contact_id |
Contact id of invoice |
globally unique identifier | |
| article_price_label_id |
Article price label id |
globally unique identifier | |
| db_language_id |
The language id |
globally unique identifier | |
| invoice_status_id |
The status id of invoice |
globally unique identifier | |
| invoice_status_name |
The status name of invoice |
string | |
| discount_group_id |
The id of discount group |
globally unique identifier | |
| discount |
Discount value |
decimal number | |
|
The email |
string | ||
| invoice_number |
Invoice number |
string | |
| bill_to_company_id |
Company id for bill |
globally unique identifier | |
| dateutc_confirmation |
The confirmation date (UTC) |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| invoice_details |
Details of invoice |
Collection of invoice_details_view | |
| db_payment_method_name |
Payment method name of the invoice |
string | |
| db_payment_method_pm |
Payment method pm of the invoice |
string |
Response Formats
application/json, text/json
{
"id": "aaba65b2-8744-43ed-b0c9-0d060b743092",
"internal_number": "sample string 2",
"company_id": "95f37841-d856-49cb-b1aa-2fe67181fb5e",
"company_code": "sample string 4",
"company_name": "sample string 5",
"company_email": "sample string 6",
"company_phone": "sample string 7",
"date_create": "2025-01-18T10:44:18.3159582+00:00",
"memo": "sample string 9",
"description": "sample string 10",
"invoice_type": "sample string 11",
"source_type": "sample string 12",
"source_id_in_table": "4b659315-46ed-413e-a284-9fd4fef0a284",
"total_lines": 14,
"total_amount": 15.0,
"db_currency_id": "2203f503-b4fe-481b-b2c4-f9c3bc6a496e",
"total_taxes": 17.0,
"due_date": "2025-01-18T10:44:18.3358069+00:00",
"source_db_table_name": "sample string 19",
"delivery_name": "sample string 20",
"delivery_street": "sample string 21",
"delivery_city": "sample string 22",
"delivery_zip": "sample string 23",
"delivery_db_country_name": "sample string 24",
"reference_back_office": "sample string 25",
"db_payment_method_id": "9ec9437b-5b02-4e22-943b-6531b38b7349",
"id2": 27,
"customer_remarks": "sample string 28",
"bill_to_party": "sample string 29",
"bill_to_contact_id": "63f03f47-3952-4b48-b34d-a3c7e72b237a",
"contact_id": "8c62906f-2f43-4a53-972e-52ea5678b9f0",
"article_price_label_id": "74245cca-aa82-4b3c-8502-0ec643e29fb5",
"db_language_id": "4294748e-3b33-4996-b720-ce49c9055b1c",
"invoice_status_id": "39a7d0fb-b56e-41bc-9db0-30e898c834ea",
"invoice_status_name": "sample string 35",
"discount_group_id": "bb63f639-f340-4b07-9f89-0c22a910b48c",
"discount": 37.0,
"email": "sample string 38",
"invoice_number": "sample string 39",
"bill_to_company_id": "db851594-09ca-401c-b49a-7e893a928414",
"dateutc_confirmation": "2025-01-18T10:44:18.3358069+00:00",
"modified_dateutc": "2025-01-18T10:44:18.3358069+00:00",
"invoice_details": [
{
"id": "8b8e24b1-8b5e-4be8-8f11-466586ab4b9b",
"invoice_id": "e9961fb0-73b8-4fb2-9f44-af637df4c280",
"article_id": "f3bb3319-9f39-458e-a7d0-4534994c724c",
"article_name": "sample string 4",
"article_description": "sample string 5",
"article_code": "sample string 6",
"line_num": 7,
"quantity_decimal": 9.0,
"article_price": 10.0,
"discount": 11.0,
"vat_rate": 12.0,
"vat_value": 13.0,
"total_vat": 14.0,
"total_line": 15.0,
"total_line_with_vat": 16.0,
"source_db_table_name": "sample string 17",
"source_id_in_table": "6514465e-00d3-4b21-9475-287a05cd904b",
"serial_number": "sample string 19",
"no_warranty_reason": "sample string 20",
"is_under_warranty": true,
"discount_percentage": 22.0,
"cost_price": 23.0,
"company_vat_id": "28618107-5c8a-42e4-ab0e-f6d22d326c5b",
"company_vat_code": "sample string 25",
"modified_dateutc": "2025-01-18T10:44:18.3472101+00:00"
},
{
"id": "8b8e24b1-8b5e-4be8-8f11-466586ab4b9b",
"invoice_id": "e9961fb0-73b8-4fb2-9f44-af637df4c280",
"article_id": "f3bb3319-9f39-458e-a7d0-4534994c724c",
"article_name": "sample string 4",
"article_description": "sample string 5",
"article_code": "sample string 6",
"line_num": 7,
"quantity_decimal": 9.0,
"article_price": 10.0,
"discount": 11.0,
"vat_rate": 12.0,
"vat_value": 13.0,
"total_vat": 14.0,
"total_line": 15.0,
"total_line_with_vat": 16.0,
"source_db_table_name": "sample string 17",
"source_id_in_table": "6514465e-00d3-4b21-9475-287a05cd904b",
"serial_number": "sample string 19",
"no_warranty_reason": "sample string 20",
"is_under_warranty": true,
"discount_percentage": 22.0,
"cost_price": 23.0,
"company_vat_id": "28618107-5c8a-42e4-ab0e-f6d22d326c5b",
"company_vat_code": "sample string 25",
"modified_dateutc": "2025-01-18T10:44:18.3472101+00:00"
}
],
"db_payment_method_name": "sample string 43",
"db_payment_method_pm": "sample string 44"
}