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": "e15050bb-e346-4331-b48b-d6be91360756",
"internal_number": "sample string 2",
"company_id": "7dfcc36f-277c-4a3e-98f4-cd1fcc7a1b6f",
"company_code": "sample string 4",
"company_name": "sample string 5",
"company_email": "sample string 6",
"company_phone": "sample string 7",
"date_create": "2024-09-29T05:30:59.8786346+00:00",
"memo": "sample string 9",
"description": "sample string 10",
"invoice_type": "sample string 11",
"source_type": "sample string 12",
"source_id_in_table": "dd23383b-5af8-4f80-a996-2398d552ba6c",
"total_lines": 14,
"total_amount": 15.0,
"db_currency_id": "8dd44b91-7fe9-453b-8aad-5b069f7268c8",
"total_taxes": 17.0,
"due_date": "2024-09-29T05:30:59.8893145+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": "88e38c72-770b-4fed-b171-84b7ff9243e0",
"id2": 27,
"customer_remarks": "sample string 28",
"bill_to_party": "sample string 29",
"bill_to_contact_id": "8b52c9c7-f292-493a-914d-53ce200cee74",
"contact_id": "1867f3f0-f87e-4dc4-b4d7-b4c67deae59b",
"article_price_label_id": "9169ab89-8735-40c6-bda3-8d93a82cc212",
"db_language_id": "9417c5fe-b3c9-4d47-aa5e-37ee6b303ef1",
"invoice_status_id": "510ad5f0-a621-41de-8ab5-df2a40ac4540",
"invoice_status_name": "sample string 35",
"discount_group_id": "bb2c8ab1-dbc8-4520-97c5-8fb537b6e462",
"discount": 37.0,
"email": "sample string 38",
"invoice_number": "sample string 39",
"bill_to_company_id": "e00896a4-a903-42af-b27f-236abed2aceb",
"dateutc_confirmation": "2024-09-29T05:30:59.8893145+00:00",
"modified_dateutc": "2024-09-29T05:30:59.8893145+00:00",
"invoice_details": [
{
"id": "d38e264b-a77b-4cc3-8786-c5372eb854dd",
"invoice_id": "73d8b914-7b47-492c-aa53-93e85e722963",
"article_id": "b8226459-03b8-4905-959d-04d013c2a113",
"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": "e43ee570-d189-4a27-a39d-66a435d1cdcf",
"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": "58e93474-6141-40d5-992f-7d7239f56239",
"company_vat_code": "sample string 25",
"modified_dateutc": "2024-09-29T05:30:59.8893145+00:00"
},
{
"id": "d38e264b-a77b-4cc3-8786-c5372eb854dd",
"invoice_id": "73d8b914-7b47-492c-aa53-93e85e722963",
"article_id": "b8226459-03b8-4905-959d-04d013c2a113",
"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": "e43ee570-d189-4a27-a39d-66a435d1cdcf",
"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": "58e93474-6141-40d5-992f-7d7239f56239",
"company_vat_code": "sample string 25",
"modified_dateutc": "2024-09-29T05:30:59.8893145+00:00"
}
],
"db_payment_method_name": "sample string 43",
"db_payment_method_pm": "sample string 44"
}