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

# CustomerCreditNoteSubaccountSegments: Visma.net Financials Customer Credit Note Subaccount Segments

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CustomerCreditNote`
- Label: Customer Credit Note Subaccount Segments

Get a range of Customer Credit 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 Credit Note

Can only retrieve data.

## Summary

Data for Customer Credit Note

## API Source

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

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| 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 `CustomerCreditNoteSubaccountSegments` 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 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.active` |  |
| `account_description` | `varchar2` | Account Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.description` | Name of item/description |
| `account_externalCode1` | `varchar2` | Account External Code 1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.externalCode1` | Account class &gt; The identifier of the account class. |
| `account_externalCode2` | `varchar2` | Account External Code 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.externalCode2` | Account class &gt; The name of the account class. |
| `account_number` | `varchar2` | Account Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.number` | Number of item |
| `account_type` | `varchar2` | Account Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.type` | Account &gt; The account number. |
| `active` | `char` | Active | [ ] | writable, `::ancestor.active` | Active &gt; The status of the identifier. |
| `amount` | `double` | Amount | [ ] | filters on the platform, writable, `::ancestor.::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. |
| `amountInCurrency` | `double` | Amount in Currency | [ ] | filters on the platform, writable, `::ancestor.::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. |
| `balance` | `double` | Balance | [ ] | filters on the platform, writable, `::ancestor.::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.::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 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.branchNumber.name` | Click the magnifier. &gt; The name. |
| `branchNumber_number` | `varchar2` | Branch Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.branchNumber.number` | Click the magnifier. &gt; The identifier. |
| `cashAccount` | `varchar2` | Cash Account | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::ancestor.cashDiscountDate` | 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.::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.::ancestor.childRecord.name` | Click the magnifier. &gt; The name. |
| `childRecord_number` | `varchar2` | itgen_vnet_childrecord_number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.childRecord.number` | Click the magnifier. &gt; The identifier. |
| `closedFinancialPeriod` | `varchar2` | Closed Financial Period | [ ] | filters on the platform, writable, `::ancestor.::ancestor.closedFinancialPeriod` | Format YYYYMM. |
| `contact_id` | `int32` | Contact ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.contact.id` | Click the magnifier &gt; The identifier |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.contact.name` | Click the magnifier &gt; The displayed name |
| `createdDateTime` | `datetime` | Created | [ ] | filters on the platform, writable, `::ancestor.::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.::ancestor.creditTerms.description` | Click on the magnifier. &gt; The description. |
| `creditTerms_id` | `varchar2` | Credit Terms ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.creditTerms.id` | Click on the magnifier. &gt; The identifier. |
| `currencyId` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::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.::ancestor.customerVatZone.description` | Click on the magnifier. &gt; The description. |
| `customerVatZone_id` | `varchar2` | VAT Zone ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVatZone.id` | Click on the magnifier. &gt; The identifier. |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customer.name` | Click the magnifier. &gt; The name. |
| `customer_number` | `varchar2` | Customer Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customer.number` |  |
| `description` | `varchar2` | Description | [ ] | writable, `::ancestor.description` | Description &gt; The description of the identifier. |
| `detailTotal` | `double` | Detail Total | [ ] | filters on the platform, writable, `::ancestor.::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.::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. |
| `discountTotal` | `double` | Discount Total | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::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.::ancestor.documentDueDate` | 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.::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.::ancestor.dontEmail` |  |
| `dontPrint` | `char` | Don't Print | [ ] | filters on the platform, writable, `::ancestor.::ancestor.dontPrint` |  |
| `dunningLetterDate` | `datetime` | Dunning Letter Date | [ ] | filters on the platform, writable, `::ancestor.::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.::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 | [ ] | writable, `::ancestor.errorInfo` |  |
| `errorInfo_2` | `varchar2` | Error Information 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.errorInfo` |  |
| `exchangeRate` | `double` | Exchange Rate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.exchangeRate` | The top part &gt; Currency &gt; The middle field, click the down arrow &gt; Exchange rate - To change the currency rate, click the arrow by the rate to invoke the Rate selection dialog box. |
| `externalReference` | `varchar2` | External Reference | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::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. |
| `invoiceAddress_addressId` | `int32` | Invoice Address ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceAddress.addressId` |  |
| `invoiceAddress_addressLine1` | `varchar2` | Invoice Address Line 1 | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::ancestor.invoiceAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `invoiceAddress_city` | `varchar2` | Invoice Address City | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceAddress.city` | City &gt; The city. |
| `invoiceAddress_country_errorInfo` | `varchar2` | Invoice Address Country Error Information | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceAddress.country.errorInfo` |  |
| `invoiceAddress_country_id` | `varchar2` | Invoice Address Country ID | [ ] | filters on the platform, writable, `::ancestor.::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.::ancestor.invoiceAddress.country.metadata.maxPageSize` |  |
| `invoiceAddress_country_metadata_totalCount` | `int64` | itgen_vnet_invoiceaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceAddress.country.metadata.totalCount` |  |
| `invoiceAddress_country_name` | `varchar2` | Invoice Address Country Name | [ ] | filters on the platform, writable, `::ancestor.::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.::ancestor.invoiceAddress.county.id` | Click the magnifier &gt; The identifier |
| `invoiceAddress_county_name` | `varchar2` | Invoice Address County Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceAddress.county.name` | Click the magnifier &gt; The displayed name |
| `invoiceAddress_overrideAddress` | `char` | itgen_vnet_invoiceaddress_overrideaddress | [ ] | filters on the platform, writable, `::ancestor.::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.::ancestor.invoiceAddress.postalCode` | Postcode &gt; The postcode. |
| `invoiceContact_attention` | `varchar2` | Invoice Contact Attention | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.attention` |  |
| `invoiceContact_businessName` | `varchar2` | itgen_vnet_invoicecontact_businessname | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.businessName` |  |
| `invoiceContact_contactId` | `int32` | Invoice Contact ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.contactId` |  |
| `invoiceContact_email` | `varchar2` | Invoice Contact Email Address | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.email` |  |
| `invoiceContact_overrideContact` | `char` | itgen_vnet_invoicecontact_overridecontact | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.overrideContact` |  |
| `invoiceContact_phone1` | `varchar2` | Invoice Contact Phone 1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceContact.phone1` |  |
| `invoiceText` | `varchar2` | Invoice Text | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceText` | The top part &gt; Invoice text &gt; Any user-provided description of the customer ledger document. |
| `isRotRutDeductible` | `char` | itgen_vnet_isrotrutdeductible | [ ] | filters on the platform, writable, `::ancestor.::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) |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | writable, `::ancestor.lastModifiedDateTime` | System generated information. |
| `lastModifiedDateTime_2` | `datetime` | Last Modified Date/Time 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.lastModifiedDateTime` | System generated field for last modification date/time of document. |
| `location_countryId` | `varchar2` | Location Country ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.location.countryId` | Location*. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.location.id` | Click the magnifier &gt; The identifier |
| `location_name` | `varchar2` | Location Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.location.name` | Click the magnifier &gt; The displayed name |
| `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | [ ] | writable, `::ancestor.metadata.maxPageSize` |  |
| `metadata_maxPageSize_2` | `int64` | itgen_vnet_metadata_maxpagesize_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.metadata.maxPageSize` |  |
| `metadata_totalCount` | `int64` | Total Count | [ ] | writable, `::ancestor.metadata.totalCount` |  |
| `metadata_totalCount_2` | `int64` | itgen_vnet_metadata_totalcount_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.metadata.totalCount` |  |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::ancestor.paymentMethod.description` | Click on the magnifier. &gt; The description. |
| `paymentMethod_id` | `varchar2` | Payment Method ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.paymentMethod.id` | Click on the magnifier. &gt; The identifier. |
| `paymentReference` | `varchar2` | Payment Reference | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::ancestor.project.description` | Click on the magnifier. &gt; The description. |
| `project_id` | `varchar2` | Project ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.project.id` | Click on the magnifier. &gt; The identifier. |
| `project_internalId` | `int32` | itgen_vnet_project_internalid | [ ] | filters on the platform, writable, `::ancestor.::ancestor.project.internalId` | The internal identifier. |
| `referenceNumber` | `varchar2` | Reference Number | [ ] | filters on the platform, writable, `::ancestor.::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.::ancestor.revoked` |  |
| `roundingDiff` | `double` | Rounding Difference | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::ancestor.salesPersonID` | The field is deprecated for customer document endpoints, please use SalesPerson instead |
| `salesPerson_description` | `varchar2` | Sales Person Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.salesPerson.description` | Click on the magnifier. &gt; The description. |
| `salesPerson_id` | `varchar2` | Sales Person ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.salesPerson.id` | Click on the magnifier. &gt; The identifier. |
| `segmentDescription` | `varchar2` | itgen_vnet_segmentdescription | [ ] | writable, `segmentDescription` | The Segment values window &gt; The Top part &gt; The description of the segment. |
| `segmentId` | `int32` | Segment ID | [ ] | writable, `segmentId` | The Segment values window &gt; The Top part &gt; The ID of the segment. |
| `segmentValue` | `varchar2` | Segment Value | [ ] | writable, `segmentValue` | The Segment values window &gt; The table &gt; The value of the segment, alphanumeric. |
| `segmentValueDescription` | `varchar2` | Segment Value Description | [ ] | writable, `segmentValueDescription` | The Segment values window &gt; The table &gt; The description of the segment value. |
| `sendToAutoInvoice` | `char` | Send to Auto-invoice | [ ] | filters on the platform, writable, `::ancestor.::ancestor.sendToAutoInvoice` | The Attachment tab &gt; Send the file to AutoInvoice &gt; The selected files will be attached to the invoice. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `::ancestor.::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. |
| `subaccountId` | `int32` | itgen_vnet_subaccountid | [ ] | writable, `::ancestor.subaccountId` | SubID &gt; The  identifier of the subaccount. |
| `subaccountNumber` | `varchar2` | itgen_vnet_subaccountnumber | [ ] | writable, `::ancestor.subaccountNumber` | Mandatory field: Subaccount* &gt; The subaccount number. Format 9-XX. |
| `timeStamp` | `blob` | Timestamp | [ ] | writable, `::ancestor.timeStamp` | The timestamp of the subaccount, used for concurrency control. |
| `timeStamp_2` | `blob` | itgen_vnet_timestamp_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.timeStamp` |  |
| `vatExemptTotal` | `double` | VAT Exempt Total | [ ] | filters on the platform, writable, `::ancestor.::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.::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.::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.::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.::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.::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 |
|---|---|---|---|---|
| `CustomerCreditNoteSubaccountSegments_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)

