invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerInvoiceLines: Visma.net Financials Customer Invoice Lines

popular read only REST

  • Catalog: VismaNet
  • Schema: CustomerInvoice
  • Label: Customer Invoice Lines

Get a range of Invoices - 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 Change log: 2020-May:Added forced pagination Data for Customer Invoice

Can only retrieve data.

Summary

Data for Customer Invoice

API Source

  • Endpoint: /v1/customerinvoice
  • Operation: get /v1/customerinvoice

Performance Characteristics

Characteristic Value
Average access latency (ms) 1,060
Full scan rows per minute 15,700
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): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
customer `` Filter by Customer
customerRefNumber `` The top part > External reference > 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): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' 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): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' 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 (<), after (>), before and including (=<) OR after and including (=>) 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 > External reference > 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): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
paymentReference `` The top part > Payment ref. > 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 CustomerInvoiceLines 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 writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name 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 > 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 > The identifier of the account class.
account_externalCode2 varchar2 Account External Code 2 writable, account.externalCode2 Account class > 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 > 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 > The account number.
account_type_2 varchar2 Account Type 2 filters on the platform, writable, ::ancestor.account.type Account > The account number.
accountingCostRef varchar2 itgen_vnet_accountingcostref filters on the platform, writable, ::ancestor.accountingCostRef
amount double Amount writable, amount Amount > 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 > Amount > 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 > Balance > 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. > The name.
branchNumber_name_2 varchar2 Branch Number Name 2 filters on the platform, writable, ::ancestor.branchNumber.name Click the magnifier. > The name.
branchNumber_number varchar2 Branch Number writable, branchNumber.number Click the magnifier. > The identifier.
branchNumber_number_2 varchar2 Branch Number 2 filters on the platform, writable, ::ancestor.branchNumber.number Click the magnifier. > The identifier.
cashAccount varchar2 Cash Account filters on the platform, writable, ::ancestor.cashAccount Financial details tab > The payment information section > Cash account > The cash account associated with the payment method.
cashDiscount double Cash Discount filters on the platform, writable, ::ancestor.cashDiscount The top part > Cash discount > 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 > Cash discount date * > 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. > The name.
childRecord_number varchar2 itgen_vnet_childrecord_number filters on the platform, writable, ::ancestor.childRecord.number Click the magnifier. > 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 > The identifier
contact_name varchar2 Contact Name filters on the platform, writable, ::ancestor.contact.name Click the magnifier > The displayed name
contractDocRef varchar2 itgen_vnet_contractdocref filters on the platform, writable, ::ancestor.contractDocRef
cost double Cost writable, cost Cost > 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 > Creation time > The date the attachment was created.
creditTerms_description varchar2 Credit Terms Description filters on the platform, writable, ::ancestor.creditTerms.description Click on the magnifier. > The description.
creditTerms_id varchar2 Credit Terms ID filters on the platform, writable, ::ancestor.creditTerms.id Click on the magnifier. > The identifier.
currencyId varchar2 Currency ID filters on the platform, writable, ::ancestor.currencyId The top part > Currency > 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 > Customer project no. > The customer project no. used in AutoInvoice.
customerRefNumber varchar2 Custom Reference Number filters on the platform, writable, ::ancestor.customerRefNumber The top part > External reference > The external reference used in AutoInvoice.
customerVatZone_description varchar2 VAT Zone Description filters on the platform, writable, ::ancestor.customerVatZone.description Click on the magnifier. > The description.
customerVatZone_id varchar2 VAT Zone ID filters on the platform, writable, ::ancestor.customerVatZone.id Click on the magnifier. > The identifier.
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number filters on the platform, writable, ::ancestor.customer.number
debtCollection_caseNumber varchar2 itgen_vnet_debtcollection_casenumber filters on the platform, writable, ::ancestor.debtCollection.caseNumber Debt Collection Case Number
debtCollection_caseStatus varchar2 itgen_vnet_debtcollection_casestatus filters on the platform, writable, ::ancestor.debtCollection.caseStatus Debt Collection Case Number
debtCollection_caseType varchar2 itgen_vnet_debtcollection_casetype filters on the platform, writable, ::ancestor.debtCollection.caseType Debt Collection Case Number
debtCollection_caseUrl varchar2 itgen_vnet_debtcollection_caseurl filters on the platform, writable, ::ancestor.debtCollection.caseUrl Debt Collection Case 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 > 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. > 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 > Detail total > 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.
directDebitMandate_id guid itgen_vnet_directdebitmandate_id filters on the platform, writable, ::ancestor.directDebitMandate.id Mandate Guid as stored in the database.
directDebitMandate_mandateDescription varchar2 itgen_vnet_directdebitmandate_mandatedescription filters on the platform, writable, ::ancestor.directDebitMandate.mandateDescription Mandate description show on Billing Address tab
directDebitMandate_mandateId varchar2 itgen_vnet_directdebitmandate_mandateid filters on the platform, writable, ::ancestor.directDebitMandate.mandateId The id shown on Billing Address tab
discountAmount double itgen_vnet_discountamount writable, discountAmount Discount amount > 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 > 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 > Discount total > The document discount total.
discountTotalInCurrency double Discount Total in Currency filters on the platform, writable, ::ancestor.discountTotalInCurrency The top part > Discount total > 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 > Date* > 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 > Due date* > 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 > Type > 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 > The dunning info section > Dunning letter date > 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 > The dunning info section > Dunning level > The dunning level of the document.
endDate datetime End Date writable, endDate
endDate_2 datetime itgen_vnet_enddate_2 filters on the platform, writable, ::ancestor.endDate
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.errorInfo
exchangeRate double Exchange Rate filters on the platform, writable, ::ancestor.exchangeRate
excludeDebtCollection char itgen_vnet_excludedebtcollection filters on the platform, writable, ::ancestor.excludeDebtCollection Exclude Debt Collection for Autocollect
externalLink varchar2 itgen_vnet_externallink writable, externalLink
externalReference varchar2 External Reference filters on the platform, writable, ::ancestor.externalReference The top part > External reference > 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 > Hold > 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 > 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 > 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 > The second line of the address.
invoiceAddress_addressLine3 varchar2 Invoice Address Line 3 filters on the platform, writable, ::ancestor.invoiceAddress.addressLine3 Address 3 > The third line of the address.
invoiceAddress_city varchar2 Invoice Address City filters on the platform, writable, ::ancestor.invoiceAddress.city City > 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* > 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* > 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 > The identifier
invoiceAddress_county_name varchar2 Invoice Address County Name filters on the platform, writable, ::ancestor.invoiceAddress.county.name Click the magnifier > The displayed name
invoiceAddress_overrideAddress char itgen_vnet_invoiceaddress_overrideaddress filters on the platform, writable, ::ancestor.invoiceAddress.overrideAddress Override address > 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 > 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 > Invoice text > Any user-provided description of the customer ledger document.
isRotRutDeductible char itgen_vnet_isrotrutdeductible writable, isRotRutDeductible
isRotRutDeductible_2 char Is ROTRUT Deductible 2 filters on the platform, writable, ::ancestor.isRotRutDeductible The top part > Domestic services deductible document > 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. > A counter of lines in the overview of cash sales document overview.
lineType varchar2 Line Type writable, lineType Transaction line type. Possible Values: -> Inventory = "GI"; -> NonInventory = "GN"; -> MiscCharge = "MI"; -> Freight = "FR"; -> Discount = "DS"; -> Reallocation = "RA";
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 > The identifier
location_name varchar2 Location Name filters on the platform, writable, ::ancestor.location.name Click the magnifier > The displayed name
manualAmount double Manual Amount writable, manualAmount Manual amount > 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 > 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 > Icon Notes > 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 > 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 > Orig invoice date > 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.
originatorDocRef varchar2 itgen_vnet_originatordocref filters on the platform, writable, ::ancestor.originatorDocRef
paymentMethod_description varchar2 Payment Method Description filters on the platform, writable, ::ancestor.paymentMethod.description Click on the magnifier. > The description.
paymentMethod_id varchar2 Payment Method ID filters on the platform, writable, ::ancestor.paymentMethod.id Click on the magnifier. > The identifier.
paymentReference varchar2 Payment Reference filters on the platform, writable, ::ancestor.paymentReference ///The top part > Payment ref. > 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 > Post period > The period to which the document should be posted. Format YYYYMM.
projectTask_description varchar2 Project Task Description writable, projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, projectTask.internalId The internal identifier.
project_description varchar2 Project Description filters on the platform, writable, ::ancestor.project.description Click on the magnifier. > The description.
project_id varchar2 Project ID filters on the platform, writable, ::ancestor.project.id Click on the magnifier. > 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 > 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 > Ref. no. > 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 > Rounding diff. > 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. > The description.
salesPerson_2_id varchar2 Salesperson 2 ID filters on the platform, writable, ::ancestor.salesPerson.id Click on the magnifier. > 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. > The description.
seller_id varchar2 Seller ID writable, seller.id Click on the magnifier. > The identifier.
sendToAutoInvoice char Send to Auto-invoice filters on the platform, writable, ::ancestor.sendToAutoInvoice The Attachment tab > Send the file to AutoInvoice > The selected files will be attached to the invoice.
soOrderNbr varchar2 itgen_vnet_soordernbr writable, soOrderNbr
soOrderType varchar2 itgen_vnet_soordertype writable, soOrderType
soShipmentNbr varchar2 itgen_vnet_soshipmentnbr writable, soShipmentNbr
startDate datetime Start Date writable, startDate
startDate_2 datetime itgen_vnet_startdate_2 filters on the platform, writable, ::ancestor.startDate
status varchar2 Status filters on the platform, writable, ::ancestor.status The top part > Status > 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 > The status of the identifier.
subaccount_active_2 char Sub Account Active 2 filters on the platform, writable, ::ancestor.subaccount.active Active > The status of the identifier.
subaccount_description varchar2 Subaccount Description writable, subaccount.description Description > The description of the identifier.
subaccount_description_2 varchar2 Sub Account Description 2 filters on the platform, writable, ::ancestor.subaccount.description Description > 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 > The identifier of the subaccount.
subaccount_subaccountId_2 int32 Sub Account ID 2 filters on the platform, writable, ::ancestor.subaccount.subaccountId SubID > The identifier of the subaccount.
subaccount_subaccountNumber varchar2 Sub Account Number writable, subaccount.subaccountNumber Mandatory field: Subaccount* > 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* > 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 Term end date > 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 only appears if the Deferred revenue management functionality is enabled in the(CS100000) window.
termStartDate datetime Term Start Date writable, termStartDate Term start date > 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 only appears if the Deferred revenue management functionality is enabled in the(CS100000) window.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
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 > 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 > The unit of measure (UoM) for the item.
vatCode_description varchar2 VAT Code Description writable, vatCode.description Click on the magnifier. > The description.
vatCode_id varchar2 VAT Code ID writable, vatCode.id Click on the magnifier. > The identifier.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, ::ancestor.vatExemptTotal The top part > VAT exempt. total > 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 > VAT taxable total > 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 > VAT total > 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
CustomerInvoiceLines_account_number_fk account_number Accounts.accountCD Key
CustomerInvoiceLines_branchNumber_number_fk branchNumber_number Branches.number Key
CustomerInvoiceLines_creditTerms_id_fk creditTerms_id CreditTermRecords.termsId Key
CustomerInvoiceLines_currencyId_fk currencyId Currencies.id Key
CustomerInvoiceLines_customerVatZone_id_fk customerVatZone_id VatZones.id Key
CustomerInvoiceLines_customer_number_fk customer_number Customers.number Key
CustomerInvoiceLines_inventoryNumber_fk inventoryNumber InventoryItems.inventoryNumber Key
CustomerInvoiceLines_location_countryId_fk location_countryId Countries.id Key
CustomerInvoiceLines_paymentMethod_id_fk paymentMethod_id PaymentMethods.paymentMethodID Key
CustomerInvoiceLines_project_id_txt project_id 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.
CustomerInvoiceLines_referenceNumber_fk referenceNumber CustomerInvoices.referenceNumber Key

Release Notes

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