JDBC Driver for Acumatica

Build 22.0.8462

Invoice

Invoice is an auto-generated table.

Columns

Name Type ReadOnly Description
LinkBranch String False

Date Datetime False

LinkedApplicationsCreditMemo String False

BillingPrinted Bool False

LinkARAccount String False

LinkedDetails String False

Customer String False

Type [KEY] String False

DueDate Datetime False

LocationID String False

LastModifiedDateTime Datetime False

Balance Double False

ReferenceNbr [KEY] String False

Terms String False

Status String False

CreatedDateTime Datetime False

CustomerOrder String False

Project String False

TaxTotal Double False

Hold Bool False

Amount Double False

PostPeriod String False

LinkedTaxDetails String False

Description String False

LinkedApplicationsDefault String False

Custom_CurrentDocument_DontEmail Bool False

Custom_Document_DiscDate String False

Custom_CurrentDocument_WorkgroupID String False

Custom_CurrentDocument_PMInstanceID_description String False

Custom_Document_CuryLineTotal String False

Custom_CurrentDocument_BatchNbr String False

Custom_Document_CuryID String False

Custom_CurrentDocument_OrigRefNbr String False

Custom_CurrentDocument_CuryDiscountedPrice String False

Custom_CurrentDocument_AvalaraCustomerUsageType String False

Custom_Document_CuryVatExemptTotal String False

Custom_CurrentDocument_CuryDiscountedDocTotal String False

Custom_Document_CuryViewState Bool False

Custom_CurrentDocument_ARSubID String False

Custom_CurrentDocument_CuryCommnblAmt String False

Custom_CurrentDocument_NoteID String False

Custom_Document_NoteText String False

Custom_CurrentDocument_ApplyOverdueCharge Bool False

Custom_CurrentDocument_CashAccountID String False

Custom_Document_CuryRoundDiff String False

Custom_CurrentDocument_PMInstanceID Int False

Custom_Document_CuryInitDocBal String False

Custom_CurrentDocument_DisplayCuryInitDocBal String False

Custom_Document_NoteID String False

Custom_CurrentDocument_CampaignID String False

Custom_CurrentDocument_DontPrint Bool False

Custom_CurrentDocument_OwnerID String False

Custom_Document_CuryVatTaxableTotal String False

Custom_CurrentDocument_TaxZoneID String False

Custom_CurrentDocument_CuryCommnAmt String False

Custom_CurrentDocument_CuryDiscountedTaxableTotal String False

Custom_CurrentDocument_Emailed Bool False

Custom_CurrentDocument_PaymentMethodID String False

Custom_CurrentDocument_Revoked Bool False

Custom_CurrentDocument_SalesPersonID String False

Custom_Document_CuryOrigDiscAmt String False

Custom_Document_CuryDiscTot String False

Custom_CurrentDocument_Printed Bool False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462