---
title: "CustomerDebitNoteLines (Visma.net Financials)"
description: "Customer Debit Note Lines"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerDebitNote.CustomerDebitNoteLines
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerDebitNote.CustomerDebitNoteLines
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# CustomerDebitNoteLines: Visma.net Financials Customer Debit Note Lines

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CustomerDebitNote`
- Label: Customer Debit Note Lines

Get a range of Customer Debit Notes - ScreenId=AR301000
Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information.
If requested page size is greater than allowed max page size, request will be limited to max page size
Data for Customer Debit Note

Can only retrieve data.

## Summary

Data for Customer Debit Note

## API Source

- Endpoint: `/v1/customerDebitNote`
- Operation: `get /v1/customerDebitNote`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 19,200 |
| Point query rows per minute | 387 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `branch` | `` | [ ] |  | Filter by Branch |
| `closedFinancialPeriod` | `` | [ ] |  | The date of the closing of the financial period. |
| `createdDateTime` | `` | [ ] |  | This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present.  Accepted format: * ```yyyy-MM-dd``` * ```yyyy-MM-dd HH:mm:ss``` * ```yyyy-MM-dd HH:mm:ss.FFF``` * ```yyyy-MM-ddTHH:mm:ss``` * ```yyyy-MM-ddTHH:mm:ss.FFF```  _Note:_ __CreatedDateTime__ and __CreatedDateTimeCondition__ are __mutually inclusive__. |
| `createdDateTimeCondition` | `` | [ ] |  | This value represents the condition to be applied when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal  _Note:_ __CreatedDateTime__ and __CreatedDateTimeCondition__ are __mutually inclusive__. |
| `customer` | `` | [ ] |  | Filter by Customer |
| `customerRefNumber` | `` | [ ] |  | The top part &gt; External reference &gt; The external reference used in AutoInvoice. |
| `documentDate` | `` | [ ] |  | This value indicates the document date. Use it to retrieve all records that have the Document Date since that time, up to the future.  Accepted format: * ```yyyy-MM-dd``` * ```yyyy-MM-dd``` * ```yyyy-MM-dd``` * ```yyyy-MM-dd``` * ```yyyy-MM-dd```  _Note:_ __DocumentDate__ and __DocumentDateCondition__ are __mutually inclusive__. |
| `documentDateCondition` | `` | [ ] |  | This value represents the condition to be applied to the Document Date when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal  _Note:_ __DocumentDate__ and __DocumentDateCondition__ are __mutually inclusive__. |
| `documentDueDate` | `` | [ ] |  | The date when payment for the document is due, in accordance with the credit terms. |
| `documentDueDateCondition` | `` | [ ] |  | This value represents the condition to be applied to the Due Date when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal |
| `documentType` | `` | [ ] |  | The field is deprecated for specific customer document endpoints. It will only be usable from customer document endpoint. (Values: Invoice, DebitNote, CreditNote, Payment, VoidPayment, Prepayment, Refund, FinCharge, SmallBalanceWo, SmallCreditWo, CashSale, CashReturn, Undefined, NoUpdate) |
| `dunningLetterDateTime` | `` | [ ] |  | The date and time for when the document last released a dunning letter. |
| `dunningLetterDateTimeCondition` | `` | [ ] |  | Set time/date as before (&lt;), after (&gt;), before and including (=&lt;) OR after and including (=&gt;) to filter on time frame. |
| `dunningLevel` | `` | [ ] |  | The dunning level of the document. |
| `expandApplications` | `` | [ ] |  | True if you want to see all dunning information regarding this document. |
| `expandAttachments` | `` | [ ] |  | True if you want to see all attachments regarding this document. |
| `expandDunningInformation` | `` | [ ] |  |  |
| `expandInvoiceAddress` | `` | [ ] |  | True if you want to see all information regarding the invoice address for this document. |
| `expandTaxDetails` | `` | [ ] |  | True if you want to see all VAT details regarding this document. |
| `externalReference` | `` | [ ] |  | The top part &gt; External reference &gt; The external reference used in AutoInvoice. |
| `financialPeriod` | `` | [ ] |  | The financial period to which the transactions recorded in the document is posted. Format YYYYMM. |
| `greaterThanValue` | `` | [ ] |  | Greater than value. The item which is the object for this, varies from API to API. |
| `lastModifiedDateTime` | `` | [ ] |  | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present.  Accepted format: * ```yyyy-MM-dd``` * ```yyyy-MM-dd HH:mm:ss``` * ```yyyy-MM-dd HH:mm:ss.FFF``` * ```yyyy-MM-ddTHH:mm:ss``` * ```yyyy-MM-ddTHH:mm:ss.FFF```  _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
| `lastModifiedDateTimeCondition` | `` | [ ] |  | This value represents the condition to be applied when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal  _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
| `paymentReference` | `` | [ ] |  | The top part &gt; Payment ref. &gt; The reference number of the document, as automatically generated by the system in accordance with the number series assigned to cash sales in the Customer ledger preferences window.. |
| `project` | `` | [ ] |  | The project with which the document is associated. |
| `released` | `` | [ ] |  | Parameter for showing if invoice has been released or not. |
| `status` | `` | [ ] |  | The status of the document. Use the dropdown to select status. (Values: Hold, Balanced, Voided, Scheduled, Open, Closed, PendingPrint, PendingEmail, CreditHold, CcHold, Reserved) |

## Table Columns

The columns of the table `CustomerDebitNoteLines` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `varchar2(30)` | Company Code | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `account_active` | `char` | Account Active | [ ] | writable, `account.active` |  |
| `account_active_2` | `char` | Account Active 2 | [ ] | filters on the platform, writable, `::ancestor.account.active` |  |
| `account_description` | `varchar2` | Account Description | [ ] | writable, `account.description` | Name of item/description |
| `account_description_2` | `varchar2` | Account Description 2 | [ ] | filters on the platform, writable, `::ancestor.account.description` | Name of item/description |
| `account_externalCode1` | `varchar2` | Account External Code 1 | [ ] | writable, `account.externalCode1` | Account class &gt; The identifier of the account class. |
| `account_externalCode1_2` | `varchar2` | Account External Code 1 2 | [ ] | filters on the platform, writable, `::ancestor.account.externalCode1` | Account class &gt; The identifier of the account class. |
| `account_externalCode2` | `varchar2` | Account External Code 2 | [ ] | writable, `account.externalCode2` | Account class &gt; The name of the account class. |
| `account_externalCode2_2` | `varchar2` | Account External Code 2 2 | [ ] | filters on the platform, writable, `::ancestor.account.externalCode2` | Account class &gt; The name of the account class. |
| `account_number` | `varchar2` | Account Number | [ ] | writable, `account.number` | Number of item |
| `account_number_2` | `varchar2` | Account Number 2 | [ ] | filters on the platform, writable, `::ancestor.account.number` | Number of item |
| `account_type` | `varchar2` | Account Type | [ ] | writable, `account.type` | Account &gt; The account number. |
| `account_type_2` | `varchar2` | Account Type 2 | [ ] | filters on the platform, writable, `::ancestor.account.type` | Account &gt; The account number. |
| `amount` | `double` | Amount | [ ] | writable, `amount` | Amount &gt; The amount after the discount has been applied. The value of this read-only box is calculated automatically by deducting the discount amount from the extended price. |
| `amountInCurrency` | `double` | Amount in Currency | [ ] | writable, `amountInCurrency` | Background calculation giving you the Amount in your default currency. This field is applicable if the amount is given in another currency than your default. |
| `amountInCurrency_2` | `double` | Amount in Currency 2 | [ ] | filters on the platform, writable, `::ancestor.amountInCurrency` | Background calculation giving you the Amount in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `amount_2` | `double` | itgen_vnet_amount_2 | [ ] | filters on the platform, writable, `::ancestor.amount` | The top part &gt; Amount &gt; The amount paid by the document. The value appears for new documents if the Validate document totals on entry check box is selected on the AR101000 window. If the check box is cleared, then the value appears when the document status is Open. |
| `balance` | `double` | Balance | [ ] | filters on the platform, writable, `::ancestor.balance` | The top part &gt; Balance &gt; For an open customer ledger document, the balance after any cash discount was taken.  For a document used in the application process, this is the balance after the payments were applied. |
| `balanceInCurrency` | `double` | Balance in Currency | [ ] | filters on the platform, writable, `::ancestor.balanceInCurrency` | Background calculation giving you the Balance in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `branchNumber_name` | `varchar2` | Branch Name | [ ] | writable, `branchNumber.name` | Click the magnifier. &gt; The name. |
| `branchNumber_name_2` | `varchar2` | Branch Number Name 2 | [ ] | filters on the platform, writable, `::ancestor.branchNumber.name` | Click the magnifier. &gt; The name. |
| `branchNumber_number` | `varchar2` | Branch Number | [ ] | writable, `branchNumber.number` | Click the magnifier. &gt; The identifier. |
| `branchNumber_number_2` | `varchar2` | Branch Number 2 | [ ] | filters on the platform, writable, `::ancestor.branchNumber.number` | Click the magnifier. &gt; The identifier. |
| `cashAccount` | `varchar2` | Cash Account | [ ] | filters on the platform, writable, `::ancestor.cashAccount` | Financial details tab &gt; The payment information section &gt; Cash account &gt; The cash account associated with the payment method. |
| `cashDiscount` | `double` | Cash Discount | [ ] | filters on the platform, writable, `::ancestor.cashDiscount` | The top part &gt; Cash discount &gt; The cash discount amount that has been or will be taken on the document, which the system calculates based on the specified credit terms. |
| `cashDiscountDate` | `datetime` | Cash Discount Date | [ ] | filters on the platform, writable, `::ancestor.cashDiscountDate` | Mandatory field: The Top part &gt; Cash discount date* &gt; The end date of the cash discount period, which the system calculates by using the credit terms. |
| `cashDiscountInCurrency` | `double` | Cash Discount in Currency | [ ] | filters on the platform, writable, `::ancestor.cashDiscountInCurrency` | Background calculation giving you the Cash discount in your default currency. This field is applicable if the amount is given in another currency than your default. |
| `childRecord_name` | `varchar2` | itgen_vnet_childrecord_name | [ ] | filters on the platform, writable, `::ancestor.childRecord.name` | Click the magnifier. &gt; The name. |
| `childRecord_number` | `varchar2` | itgen_vnet_childrecord_number | [ ] | filters on the platform, writable, `::ancestor.childRecord.number` | Click the magnifier. &gt; The identifier. |
| `closedFinancialPeriod` | `varchar2` | Closed Financial Period | [ ] | filters on the platform, writable, `::ancestor.closedFinancialPeriod` | Format YYYYMM. |
| `contact_id` | `int32` | Contact ID | [ ] | filters on the platform, writable, `::ancestor.contact.id` | Click the magnifier &gt; The identifier |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `::ancestor.contact.name` | Click the magnifier &gt; The displayed name |
| `cost` | `double` | Cost | [ ] | writable, `cost` | Cost &gt; The total cost of the line in default currency.  The value will always be 0 for unreleased documents. |
| `createdDateTime` | `datetime` | Created | [ ] | filters on the platform, writable, `::ancestor.createdDateTime` | The Attachments tab &gt; Creation time &gt; The date the attachment was created. |
| `creditTerms_description` | `varchar2` | Credit Terms Description | [ ] | filters on the platform, writable, `::ancestor.creditTerms.description` | Click on the magnifier. &gt; The description. |
| `creditTerms_id` | `varchar2` | Credit Terms ID | [ ] | filters on the platform, writable, `::ancestor.creditTerms.id` | Click on the magnifier. &gt; The identifier. |
| `currencyId` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.currencyId` | The top part &gt; Currency &gt; The currency of the document. By default, it is the customer’s default currency,but it can be changed if the Allow Currency Override check box is selected in the AR303000 window. |
| `customerProject` | `varchar2` | Customer Project | [ ] | filters on the platform, writable, `::ancestor.customerProject` | The top part &gt; Customer project no. &gt; The customer project no. used in AutoInvoice. |
| `customerRefNumber` | `varchar2` | Custom Reference Number | [ ] | filters on the platform, writable, `::ancestor.customerRefNumber` | The top part &gt; External reference &gt; The external reference used in AutoInvoice. |
| `customerVatZone_description` | `varchar2` | VAT Zone Description | [ ] | filters on the platform, writable, `::ancestor.customerVatZone.description` | Click on the magnifier. &gt; The description. |
| `customerVatZone_id` | `varchar2` | VAT Zone ID | [ ] | filters on the platform, writable, `::ancestor.customerVatZone.id` | Click on the magnifier. &gt; The identifier. |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `::ancestor.customer.name` | Click the magnifier. &gt; The name. |
| `customer_number` | `varchar2` | Customer Number | [ ] | filters on the platform, writable, `::ancestor.customer.number` |  |
| `deductableAmount` | `double` | itgen_vnet_deductableamount | [ ] | writable, `deductableAmount` |  |
| `deferralCode` | `varchar2` | itgen_vnet_deferralcode | [ ] | writable, `deferralCode` | The deferral code assigned to the stock item or non-stock item specified in this document line.Upon release of the document, the system generates a deferral schedule (or schedules) based on the settings defined in this deferral code. |
| `deferralSchedule` | `int32` | itgen_vnet_deferralschedule | [ ] | writable, `deferralSchedule` | Original deferral schedule &gt; A read-only column filled in by the system in the Cash return documents created by the reversing process. It shows the identifier of the deferral schedule associated with the original Cash sale document. |
| `description` | `varchar2` | Description | [ ] | writable, `description` | Transaction descr. &gt; Any brief comment relevant to the transaction.The alphanumeric string may contain up to 30 characters. |
| `detailTotal` | `double` | Detail Total | [ ] | filters on the platform, writable, `::ancestor.detailTotal` | The top part &gt; Detail total &gt; The document total, which the system calculates for all line items in the Document details tab. |
| `detailTotalInCurrency` | `double` | Detail Total in Currency | [ ] | filters on the platform, writable, `::ancestor.detailTotalInCurrency` | Background calculation giving you the Detail total in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `discountAmount` | `double` | itgen_vnet_discountamount | [ ] | writable, `discountAmount` | Discount amount &gt; The amount of the line-level discount that has been applied manually or automatically to this line.The system selects the Manual Discount check box and calculates the line amount after you have entered the discount amount manually and save your changes or added a new line. |
| `discountAmountInCurrency` | `double` | itgen_vnet_discountamountincurrency | [ ] | writable, `discountAmountInCurrency` | Background calculation giving you the Discount amount in your default currency. This field is applicable if the amount is given in another currency than your default. |
| `discountCode` | `varchar2` | Discount Code | [ ] | writable, `discountCode` | The code of the line discount that has been applied to this line automatically or manually. |
| `discountPercent` | `double` | Discount Percent | [ ] | writable, `discountPercent` | Discount percent &gt; The percent of the line-level discount that has been applied manually or automatically.The system selects the Manual Discount check box and calculates the discount amount after you have entered the percent manually and saved your changes or added a new line. |
| `discountTotal` | `double` | Discount Total | [ ] | filters on the platform, writable, `::ancestor.discountTotal` | The top part &gt; Discount total &gt; The document discount total. |
| `discountTotalInCurrency` | `double` | Discount Total in Currency | [ ] | filters on the platform, writable, `::ancestor.discountTotalInCurrency` | The top part &gt; Discount total &gt; The document discount total in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `documentDate` | `datetime` | Document Date | [ ] | filters on the platform, writable, `::ancestor.documentDate` | The top part &gt; Date* &gt; The date when the customer ledger document was created. By default, for a new document, it is the current business date, but you can change the date. |
| `documentDueDate` | `datetime` | Document Due Date | [ ] | filters on the platform, writable, `::ancestor.documentDueDate` | Mandatory field: The Top part &gt; Due date* &gt; The date when payment for the document is due, in accordance with the credit terms. |
| `documentType` | `varchar2` | Document Type | [ ] | filters on the platform, writable, `::ancestor.documentType` | The top part &gt; Type &gt; The document type. The following types are available: invoice, debit note, credit note, overdue charge, credit write-off |
| `dontEmail` | `char` | Don't Email | [ ] | filters on the platform, writable, `::ancestor.dontEmail` |  |
| `dontPrint` | `char` | Don't Print | [ ] | filters on the platform, writable, `::ancestor.dontPrint` |  |
| `dunningLetterDate` | `datetime` | Dunning Letter Date | [ ] | filters on the platform, writable, `::ancestor.dunningLetterDate` | The Financial details tab &gt; The Dunning information section &gt; Dunning letter date &gt; The date of the last released dunning letter in which the document was listed. |
| `dunningLetterLevel` | `int32` | Dunning Letter Level | [ ] | filters on the platform, writable, `::ancestor.dunningLetterLevel` | The Financial details tab &gt; The Dunning information section &gt; Dunning level &gt; The dunning level of the document. |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `::ancestor.errorInfo` |  |
| `exchangeRate` | `double` | Exchange Rate | [ ] | filters on the platform, writable, `::ancestor.exchangeRate` | The Top part &gt; Currency &gt; The middle field, click the down arrow &gt; Exchange rate. |
| `externalLink` | `varchar2` | itgen_vnet_externallink | [ ] | writable, `externalLink` |  |
| `externalReference` | `varchar2` | External Reference | [ ] | filters on the platform, writable, `::ancestor.externalReference` | The Top part &gt; External reference &gt; The external reference used in AutoInvoice. |
| `financialPeriod` | `varchar2` | Financial Period | [ ] | filters on the platform, writable, `::ancestor.financialPeriod` | The financial period to which the transactions recorded in the document should be posted. Format YYYYMM. |
| `hold` | `char` | Hold | [ ] | filters on the platform, writable, `::ancestor.hold` | The top part &gt; Hold &gt; A check box that indicates (if selected) that the document is a draft. A document with the On Hold status may be edited and cannot be released. |
| `inventoryNumber` | `varchar2` | Inventory Number | [ ] | writable, `inventoryNumber` | Item ID &gt; The item ID of the line item, if applicable. Only a non-stock item can be selected. |
| `invoiceAddress_addressId` | `int32` | Invoice Address ID | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.addressId` |  |
| `invoiceAddress_addressLine1` | `varchar2` | Invoice Address Line 1 | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.addressLine1` | Address 1 &gt; The first line of the customer's contact address. |
| `invoiceAddress_addressLine2` | `varchar2` | Invoice Address Line 2 | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `invoiceAddress_addressLine3` | `varchar2` | Invoice Address Line 3 | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `invoiceAddress_city` | `varchar2` | Invoice Address City | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.city` | City &gt; The city. |
| `invoiceAddress_country_errorInfo` | `varchar2` | Invoice Address Country Error Information | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.country.errorInfo` |  |
| `invoiceAddress_country_id` | `varchar2` | Invoice Address Country ID | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `invoiceAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_invoiceaddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.country.metadata.maxPageSize` |  |
| `invoiceAddress_country_metadata_totalCount` | `int64` | itgen_vnet_invoiceaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.country.metadata.totalCount` |  |
| `invoiceAddress_country_name` | `varchar2` | Invoice Address Country Name | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `invoiceAddress_county_id` | `varchar2` | Invoice Address County ID | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.county.id` | Click the magnifier &gt; The identifier |
| `invoiceAddress_county_name` | `varchar2` | Invoice Address County Name | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.county.name` | Click the magnifier &gt; The displayed name |
| `invoiceAddress_overrideAddress` | `char` | itgen_vnet_invoiceaddress_overrideaddress | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.overrideAddress` | Override address &gt; A check box that indicates (if selected) that the invoice address is not the default invoice address of the customer. |
| `invoiceAddress_postalCode` | `varchar2` | Invoice Address Postal Code | [ ] | filters on the platform, writable, `::ancestor.invoiceAddress.postalCode` | Postcode &gt; The postcode. |
| `invoiceContact_attention` | `varchar2` | Invoice Contact Attention | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.attention` |  |
| `invoiceContact_businessName` | `varchar2` | itgen_vnet_invoicecontact_businessname | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.businessName` |  |
| `invoiceContact_contactId` | `int32` | Invoice Contact ID | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.contactId` |  |
| `invoiceContact_email` | `varchar2` | Invoice Contact Email Address | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.email` |  |
| `invoiceContact_overrideContact` | `char` | itgen_vnet_invoicecontact_overridecontact | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.overrideContact` |  |
| `invoiceContact_phone1` | `varchar2` | Invoice Contact Phone 1 | [ ] | filters on the platform, writable, `::ancestor.invoiceContact.phone1` |  |
| `invoiceText` | `varchar2` | Invoice Text | [ ] | filters on the platform, writable, `::ancestor.invoiceText` | The top part &gt; Invoice text &gt; Any user-provided description of the customer ledger document. |
| `isRotRutDeductible` | `char` | itgen_vnet_isrotrutdeductible | [ ] | writable, `isRotRutDeductible` | Domestic services deductible document &gt; A check box indicating if the document is Rot/rut deductible (applicable for the Swedish markets) |
| `isRotRutDeductible_2` | `char` | Is ROTRUT Deductible 2 | [ ] | filters on the platform, writable, `::ancestor.isRotRutDeductible` | The top part &gt; Domestic services deductible document &gt; A check box indicating if the document is Rot/rut deductible (applicable for the Swedish markets) |
| `itemType` | `varchar2` | Item Type | [ ] | writable, `itemType` |  |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModifiedDateTime` | System generated field for last modification date/time of document. |
| `lineNumber` | `int32` | Line Number | [ ] | writable, `lineNumber` | Line no. &gt; A counter of lines in the overview of cash sales document overview. |
| `location_countryId` | `varchar2` | Location Country ID | [ ] | filters on the platform, writable, `::ancestor.location.countryId` | Location*. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `::ancestor.location.id` | Click the magnifier &gt; The identifier |
| `location_name` | `varchar2` | Location Name | [ ] | filters on the platform, writable, `::ancestor.location.name` | Click the magnifier &gt; The displayed name |
| `manualAmount` | `double` | Manual Amount | [ ] | writable, `manualAmount` | Manual amount &gt; a check box indicating that the amount has been entered manually. |
| `manualAmountInCurrency` | `double` | itgen_vnet_manualamountincurrency | [ ] | writable, `manualAmountInCurrency` | Background calculation giving you the Manual amount in your default currency. This field is applicable if the amount is given in another currency than your default. |
| `manualDiscount` | `char` | Manual Discount | [ ] | writable, `manualDiscount` | Manual discount &gt; A check box that indicates (if selected) that the discount has been applied manually.If you clear the check box, the system clears entered discount percent, or discount amount, or selected discount code. |
| `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | [ ] | filters on the platform, writable, `::ancestor.metadata.maxPageSize` |  |
| `metadata_totalCount` | `int64` | Total Count | [ ] | filters on the platform, writable, `::ancestor.metadata.totalCount` |  |
| `note` | `varchar2` | Note | [ ] | writable, `note` | Table &gt; Icon Notes &gt; Pop-up window for providing any user-defined text connected to the order. |
| `note_2` | `varchar2` | Note 2 | [ ] | filters on the platform, writable, `::ancestor.note` | Icon Notes on top of the window &gt; Pop-up window for providing any user-defined text connected to the document. |
| `origInvoiceDate` | `datetime` | Original Invoice Date | [ ] | filters on the platform, writable, `::ancestor.origInvoiceDate` | The top part &gt; Orig invoice date &gt; The date based on which the Due date and Cash discount date is calculated. Only used if setting "Use Orig Invoice Date" is active in AR Preferences. By default, for a new document, it is the current business date, but you can change the date. |
| `paymentMethod_description` | `varchar2` | Payment Method Description | [ ] | filters on the platform, writable, `::ancestor.paymentMethod.description` | Click on the magnifier. &gt; The description. |
| `paymentMethod_id` | `varchar2` | Payment Method ID | [ ] | filters on the platform, writable, `::ancestor.paymentMethod.id` | Click on the magnifier. &gt; The identifier. |
| `paymentReference` | `varchar2` | Payment Reference | [ ] | filters on the platform, writable, `::ancestor.paymentReference` | ///The top part &gt; Payment ref. &gt; The reference number of the document, as automatically generated by the system in accordance with the number series assigned to cash sales in the Customer ledger preferences window.. |
| `postPeriod` | `varchar2` | Post Period | [ ] | filters on the platform, writable, `::ancestor.postPeriod` | The top part &gt; Post period &gt; The period to which the document should be posted. Format YYYYMM. |
| `project_description` | `varchar2` | Project Description | [ ] | filters on the platform, writable, `::ancestor.project.description` | Click on the magnifier. &gt; The description. |
| `project_id` | `varchar2` | Project ID | [ ] | filters on the platform, writable, `::ancestor.project.id` | Click on the magnifier. &gt; The identifier. |
| `project_internalId` | `int32` | itgen_vnet_project_internalid | [ ] | filters on the platform, writable, `::ancestor.project.internalId` | The internal identifier. |
| `quantity` | `double` | Quantity | [ ] | writable, `quantity` | Quantity &gt; The quantity of items (goods or services) of a particular type sold to the customer. |
| `referenceNumber` | `varchar2` | Reference Number | [ ] | filters on the platform, writable, `::ancestor.referenceNumber` | The Top part &gt; Ref. no. &gt; The reference number of the customer ledger document in the system. |
| `revoked` | `char` | Revoke | [ ] | filters on the platform, writable, `::ancestor.revoked` |  |
| `roundingDiff` | `double` | Rounding Difference | [ ] | filters on the platform, writable, `::ancestor.roundingDiff` | The Top part &gt; Rounding diff. &gt; The difference between the original amount and the rounded amount. |
| `salesPersonDescr` | `varchar2` | Sales Person Name | [ ] | filters on the platform, writable, `::ancestor.salesPersonDescr` | The field is deprecated for customer document endpoints, please use SalesPerson instead |
| `salesPersonID` | `int32` | Sales Person ID | [ ] | filters on the platform, writable, `::ancestor.salesPersonID` | The field is deprecated for customer document endpoints, please use SalesPerson instead |
| `salesPerson_2_description` | `varchar2` | Salesperson 2 Description | [ ] | filters on the platform, writable, `::ancestor.salesPerson.description` | Click on the magnifier. &gt; The description. |
| `salesPerson_2_id` | `varchar2` | Salesperson 2 ID | [ ] | filters on the platform, writable, `::ancestor.salesPerson.id` | Click on the magnifier. &gt; The identifier. |
| `salesperson` | `varchar2` | Salesperson | [ ] | writable, `salesperson` | The field is deprecated for customer document endpoints, please use Seller instead |
| `seller_description` | `varchar2` | Seller Description | [ ] | writable, `seller.description` | Click on the magnifier. &gt; The description. |
| `seller_id` | `varchar2` | Seller ID | [ ] | writable, `seller.id` | Click on the magnifier. &gt; The identifier. |
| `soOrderNbr` | `varchar2` | itgen_vnet_soordernbr | [ ] | writable, `soOrderNbr` |  |
| `soOrderType` | `varchar2` | itgen_vnet_soordertype | [ ] | writable, `soOrderType` |  |
| `soShipmentNbr` | `varchar2` | itgen_vnet_soshipmentnbr | [ ] | writable, `soShipmentNbr` |  |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `::ancestor.status` | The top part &gt; Status &gt; The status of the document, which can be one of the following: Hold, Balanced, Voided, Scheduled, Open, Closed, Pending print, Pending email. |
| `subaccount_active` | `char` | Sub Account Active 2 | [ ] | writable, `subaccount.active` | Active &gt; The status of the identifier. |
| `subaccount_active_2` | `char` | Sub Account Active 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.active` | Active &gt; The status of the identifier. |
| `subaccount_description` | `varchar2` | Subaccount Description | [ ] | writable, `subaccount.description` | Description &gt; The description of the identifier. |
| `subaccount_description_2` | `varchar2` | Sub Account Description 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.description` | Description &gt; The description of the identifier. |
| `subaccount_errorInfo` | `varchar2` | Sub Account Error Message | [ ] | writable, `subaccount.errorInfo` |  |
| `subaccount_errorInfo_2` | `varchar2` | Sub Account Error Information 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.errorInfo` |  |
| `subaccount_lastModifiedDateTime` | `datetime` | Sub Account Last Modified | [ ] | writable, `subaccount.lastModifiedDateTime` | System generated information. |
| `subaccount_lastModifiedDateTime_2` | `datetime` | Sub Account Last Modified Date/Time 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.lastModifiedDateTime` | System generated information. |
| `subaccount_metadata_maxPageSize` | `int64` | Sub Account Metadata Max Pagesize | [ ] | writable, `subaccount.metadata.maxPageSize` |  |
| `subaccount_metadata_maxPageSize_2` | `int64` | Sub Account Metadata Max Pagesize 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.metadata.maxPageSize` |  |
| `subaccount_metadata_totalCount` | `int64` | Sub Account Metadata Total Count | [ ] | writable, `subaccount.metadata.totalCount` |  |
| `subaccount_metadata_totalCount_2` | `int64` | Sub Account Metadata Total Count 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.metadata.totalCount` |  |
| `subaccount_subaccountId` | `int32` | Sub Account ID | [ ] | writable, `subaccount.subaccountId` | SubID &gt; The  identifier of the subaccount. |
| `subaccount_subaccountId_2` | `int32` | Sub Account ID 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.subaccountId` | SubID &gt; The  identifier of the subaccount. |
| `subaccount_subaccountNumber` | `varchar2` | Sub Account Number | [ ] | writable, `subaccount.subaccountNumber` | Mandatory field: Subaccount* &gt; The subaccount number. Format 9-XX. |
| `subaccount_subaccountNumber_2` | `varchar2` | Sub Account Number 2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.subaccountNumber` | Mandatory field: Subaccount* &gt; The subaccount number. Format 9-XX. |
| `subaccount_timeStamp` | `blob` | itgen_vnet_subaccount_timestamp | [ ] | writable, `subaccount.timeStamp` | The timestamp of the subaccount, used for concurrency control. |
| `subaccount_timeStamp_2` | `blob` | itgen_vnet_subaccount_timestamp_2 | [ ] | filters on the platform, writable, `::ancestor.subaccount.timeStamp` | The timestamp of the subaccount, used for concurrency control. |
| `termEndDate` | `datetime` | Term End Date | [ ] | writable, `termEndDate` | The date when the process of the deferred revenue recognition should finish for the selected item; this date can be specified manually if the deferral code assigned to the item is based on the Flexible by Periods, Prorate by days or Flexible by Days in Period recognition method.This column appears only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features form. |
| `termStartDate` | `datetime` | Term Start Date | [ ] | writable, `termStartDate` | The date when the process of deferred revenue recognition should start for the selected item; this date can be specified manually if the deferral code assigned to the item is based on the Flexible by Periods, Prorate by days or Flexible by Days in Period recognition method.This column appears only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features screen. |
| `timeStamp` | `blob` | Timestamp | [ ] | filters on the platform, writable, `::ancestor.timeStamp` |  |
| `typeOfWork_description` | `varchar2` | itgen_vnet_typeofwork_description | [ ] | writable, `typeOfWork.description` |  |
| `typeOfWork_rutRotType` | `varchar2` | itgen_vnet_typeofwork_rutrottype | [ ] | writable, `typeOfWork.rutRotType` |  |
| `typeOfWork_xmlTag` | `varchar2` | itgen_vnet_typeofwork_xmltag | [ ] | writable, `typeOfWork.xmlTag` |  |
| `unitPrice` | `double` | itgen_vnet_unitprice | [ ] | writable, `unitPrice` | Unit price &gt; The unit price set for the item or service. If you want to update the unit price automatically to the current value(that is, the applicable sales or default price), you can use the Recalculate Prices and Discounts action.If you have modified the unit price and saved the document, the value will not be updated by the system if you change the document date. |
| `unitPriceInCurrency` | `double` | Unit Price in Currency | [ ] | writable, `unitPriceInCurrency` | Background calculation giving you the Unit price in your default currency. This field is applicable if the amount is given in another currency than your default. |
| `uom` | `varchar2` | Unit of Measure | [ ] | writable, `uom` | UoM &gt; The unit of measure (UoM) for the item. |
| `vatCode_description` | `varchar2` | VAT Code Description | [ ] | writable, `vatCode.description` | Click on the magnifier. &gt; The description. |
| `vatCode_id` | `varchar2` | VAT Code ID | [ ] | writable, `vatCode.id` | Click on the magnifier. &gt; The identifier. |
| `vatExemptTotal` | `double` | VAT Exempt Total | [ ] | filters on the platform, writable, `::ancestor.vatExemptTotal` | The top part &gt; VAT exempt. total &gt; The document total that is exempt from VAT. This total is calculated as the taxable amount for the tax with the Include in VAT Exempt Total check box selected on the Taxes form.This box is available only if the VAT Reporting feature is enabled in your system. |
| `vatExemptTotalInCurrency` | `double` | VAT Exempt Total in Currency | [ ] | filters on the platform, writable, `::ancestor.vatExemptTotalInCurrency` | Background calculation giving you the VAT exempt. total in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `vatTaxableTotal` | `double` | VAT Taxable Total | [ ] | filters on the platform, writable, `::ancestor.vatTaxableTotal` | The top part &gt; VAT taxable total &gt; The document total that is subjected to VAT. |
| `vatTaxableTotalInCurrency` | `double` | VAT Taxable Total in Currency | [ ] | filters on the platform, writable, `::ancestor.vatTaxableTotalInCurrency` | Background calculation giving you the VAT taxable total in your default currency. This field is applicable if the amount is given in a another currency than your default. |
| `vatTotal` | `double` | VAT Total | [ ] | filters on the platform, writable, `::ancestor.vatTotal` | The top part &gt; VAT total &gt; The VAT amount of the document, as defined on the VAT details tab. |
| `vatTotalInCurrency` | `double` | VAT Total in Currency | [ ] | filters on the platform, writable, `::ancestor.vatTotalInCurrency` | Background calculation giving you the VAT total in your default currency. This field is applicable if the amount is given in a another currency than your default. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `CustomerDebitNoteLines_account_number_fk` | `account_number` | [Accounts](VismaNet.Account.Accounts)`.accountCD` | Key |  |
| `CustomerDebitNoteLines_branchNumber_number_fk` | `branchNumber_number` | [Branches](VismaNet.Branch.Branches)`.number` | Key |  |
| `CustomerDebitNoteLines_creditTerms_id_fk` | `creditTerms_id` | [CreditTermRecords](VismaNet.CreditTerm.CreditTermRecords)`.termsId` | Key |  |
| `CustomerDebitNoteLines_currencyId_fk` | `currencyId` | [Currencies](VismaNet.Currency.Currencies)`.id` | Key |  |
| `CustomerDebitNoteLines_customerVatZone_id_fk` | `customerVatZone_id` | [VatZones](VismaNet.VatZone.VatZones)`.id` | Key |  |
| `CustomerDebitNoteLines_customer_number_fk` | `customer_number` | [Customers](VismaNet.Customer.Customers)`.number` | Key |  |
| `CustomerDebitNoteLines_location_countryId_fk` | `location_countryId` | [Countries](VismaNet.Country.Countries)`.id` | Key |  |
| `CustomerDebitNoteLines_paymentMethod_id_fk` | `paymentMethod_id` | [PaymentMethods](VismaNet.PaymentMethod.PaymentMethods)`.paymentMethodID` | Key |  |
| `CustomerDebitNoteLines_project_id_txt` | `project_id` | [Projects](VismaNet.Project.Projects)`.projectID` | Textual | The project, or the code for no project when the document is not associated with a project; that code has no row in Projects. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

