JDBC Driver for Acumatica

Build 22.0.8462

Bill

Bill is an auto-generated table.

Columns

Name Type ReadOnly Description
Date Datetime False

LinkedDetails String False

Type [KEY] String False

DueDate Datetime False

BranchID String False

LocationID String False

CurrencyID String False

Balance Double False

LinkedApplications String False

ReferenceNbr [KEY] String False

Terms String False

Status String False

ApprovedForPayment Bool False

TaxTotal Double False

Hold Bool False

PostPeriod String False

Amount Double False

Vendor String False

LinkedTaxDetails String False

CashAccount String False

Description String False

VendorRef String False

Custom_CurrentDocument_PayLocationID String False

Custom_CurrentDocument_SuppliedByVendorID String False

Custom_Document_DiscDate String False

Custom_CurrentDocument_PayDate String False

Custom_CurrentDocument_PayAccountID String False

Custom_Document_CuryLineTotal String False

Custom_CurrentDocument_EmployeeID String False

Custom_CurrentDocument_UsesManualVAT Bool False

Custom_CurrentDocument_EmployeeWorkgroupID String False

Custom_CurrentDocument_BatchNbr String False

Custom_CurrentDocument_APSubID String False

Custom_CurrentDocument_PaySel Bool False

Custom_CurrentDocument_OrigRefNbr String False

Custom_CurrentDocument_CuryDiscountedPrice String False

Custom_Document_CuryVatExemptTotal String False

Custom_CurrentDocument_PrebookSubID String False

Custom_CurrentDocument_PrebookBatchNbr String False

Custom_CurrentDocument_CuryDiscountedDocTotal String False

Custom_Document_CuryViewState Bool False

Custom_Document_CuryOrigWhTaxAmt String False

Custom_CurrentDocument_SuppliedByVendorLocationID String False

Custom_CurrentDocument_NoteID String False

Custom_Document_NoteText String False

Custom_CurrentDocument_PayTypeID String False

Custom_Document_CuryRoundDiff String False

Custom_Document_CuryInitDocBal String False

Custom_CurrentDocument_DisplayCuryInitDocBal String False

Custom_CurrentDocument_PrebookAcctID String False

Custom_CurrentDocument_VoidBatchNbr String False

Custom_Document_NoteID String False

Custom_Document_CuryTaxAmt String False

Custom_CurrentDocument_APAccountID String False

Custom_Document_CuryVatTaxableTotal String False

Custom_CurrentDocument_TaxCalcMode String False

Custom_CurrentDocument_TaxZoneID String False

Custom_CurrentDocument_CuryDiscountedTaxableTotal String False

Custom_Document_LCEnabled Bool False

Custom_Document_CuryOrigDiscAmt String False

Custom_CurrentDocument_SeparateCheck Bool False

Custom_Document_CuryDiscTot String False

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