JDBC Driver for Sage Intacct

Build 20.0.7654

APBill

Retrieves APBill report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the APBill object.

Recordtype String False

The Recordtype field of the APBill object.

Recordid String False

The Recordid field of the APBill object.

Financialentity String False

The Financialentity field of the APBill object.

State String False

The State field of the APBill object.

Rawstate String False

The Rawstate field of the APBill object.

Entity String False

The Entity field of the APBill object.

Vendorid String False

The Vendorid field of the APBill object.

Vendorname String False

The Vendorname field of the APBill object.

Form1099type String False

The Form1099type field of the APBill object.

Vendtype1099type String False

The Vendtype1099type field of the APBill object.

Trx_entitydue Double False

The Trx_entitydue field of the APBill object.

Docnumber String False

The Docnumber field of the APBill object.

Description String False

The Description field of the APBill object.

Description2 String False

The Description2 field of the APBill object.

Termname String False

The Termname field of the APBill object.

Termkey Int64 False

The Termkey field of the APBill object.

Whencreated Datetime False

The Whencreated field of the APBill object.

Whenposted Datetime False

The Whenposted field of the APBill object.

Whendiscount Datetime False

The Whendiscount field of the APBill object.

Whendue Datetime False

The Whendue field of the APBill object.

Whenpaid Datetime False

The Whenpaid field of the APBill object.

Recpaymentdate Datetime False

The Recpaymentdate field of the APBill object.

Paymentpriority String False

The Paymentpriority field of the APBill object.

Onhold Boolean False

The Onhold field of the APBill object.

Basecurr String False

The Basecurr field of the APBill object.

Currency String False

The Currency field of the APBill object.

Exch_rate_date Datetime False

The Exch_rate_date field of the APBill object.

Exch_rate_type_id Int64 False

The Exch_rate_type_id field of the APBill object.

Exchange_rate Double False

The Exchange_rate field of the APBill object.

Totalentered Double False

The Totalentered field of the APBill object.

Totalselected Double False

The Totalselected field of the APBill object.

Totalpaid Double False

The Totalpaid field of the APBill object.

Totaldue String False

The Totaldue field of the APBill object.

Trx_totalentered Double False

The Trx_totalentered field of the APBill object.

Trx_totalselected Double False

The Trx_totalselected field of the APBill object.

Trx_totalpaid Double False

The Trx_totalpaid field of the APBill object.

Trx_totaldue Double False

The Trx_totaldue field of the APBill object.

Billtopaytocontactname String False

The Billtopaytocontactname field of the APBill object.

Shiptoreturntocontactname String False

The Shiptoreturntocontactname field of the APBill object.

Billtopaytokey Int64 False

The Billtopaytokey field of the APBill object.

Shiptoreturntokey Int64 False

The Shiptoreturntokey field of the APBill object.

Prbatch String False

The Prbatch field of the APBill object.

Prbatchkey Int64 False

The Prbatchkey field of the APBill object.

Modulekey String False

The Modulekey field of the APBill object.

Schopkey Int64 False

The Schopkey field of the APBill object.

Systemgenerated String False

The Systemgenerated field of the APBill object.

Auwhencreated Datetime False

The Auwhencreated field of the APBill object.

Whenmodified Datetime False

The Whenmodified field of the APBill object.

Createdby Int64 False

The Createdby field of the APBill object.

Modifiedby Int64 False

The Modifiedby field of the APBill object.

Megaentitykey Int64 False

The Megaentitykey field of the APBill object.

Megaentityid String False

The Megaentityid field of the APBill object.

Record_url String False

The Record_url field of the APBill object.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654