JDBC Driver for Sage Intacct

Build 24.0.9062

STKitDocument

Retrieves STKitDocument report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the STKitDocument object.

Docno String False

The Docno field of the STKitDocument object.

Docid String False

The Docid field of the STKitDocument object.

Createdfrom String False

The Createdfrom field of the STKitDocument object.

State String False

The State field of the STKitDocument object.

Closed Boolean False

The Closed field of the STKitDocument object.

Whencreated Datetime False

The Whencreated field of the STKitDocument object.

Whenmodified Datetime False

The Whenmodified field of the STKitDocument object.

Whendue Datetime False

The Whendue field of the STKitDocument object.

Status String False

The Status field of the STKitDocument object.

Ponumber String False

The Ponumber field of the STKitDocument object.

Vendordocno String False

The Vendordocno field of the STKitDocument object.

Docparid String False

The Docparid field of the STKitDocument object.

Docparkey String False

The Docparkey field of the STKitDocument object.

Docparclass String False

The Docparclass field of the STKitDocument object.

Term_name String False

The Term_name field of the STKitDocument object.

Note String False

The Note field of the STKitDocument object.

Warehouse_locationid String False

The Warehouse_locationid field of the STKitDocument object.

Shipvia String False

The Shipvia field of the STKitDocument object.

User String False

The User field of the STKitDocument object.

Createduser String False

The Createduser field of the STKitDocument object.

Userid String False

The Userid field of the STKitDocument object.

Createduserid String False

The Createduserid field of the STKitDocument object.

Contact_contactname String False

The Contact_contactname field of the STKitDocument object.

Contact_prefix String False

The Contact_prefix field of the STKitDocument object.

Contact_firstname String False

The Contact_firstname field of the STKitDocument object.

Contact_initial String False

The Contact_initial field of the STKitDocument object.

Contact_lastname String False

The Contact_lastname field of the STKitDocument object.

Contact_companyname String False

The Contact_companyname field of the STKitDocument object.

Contact_printas String False

The Contact_printas field of the STKitDocument object.

Contact_phone1 String False

The Contact_phone1 field of the STKitDocument object.

Contact_phone2 String False

The Contact_phone2 field of the STKitDocument object.

Contact_cellphone String False

The Contact_cellphone field of the STKitDocument object.

Contact_pager String False

The Contact_pager field of the STKitDocument object.

Contact_fax String False

The Contact_fax field of the STKitDocument object.

Contact_email1 String False

The Contact_email1 field of the STKitDocument object.

Contact_email2 String False

The Contact_email2 field of the STKitDocument object.

Contact_url1 String False

The Contact_url1 field of the STKitDocument object.

Contact_url2 String False

The Contact_url2 field of the STKitDocument object.

Contact_visible Boolean False

The Contact_visible field of the STKitDocument object.

Contact_mailaddress_address1 String False

The Contact_mailaddress_address1 field of the STKitDocument object.

Contact_mailaddress_address2 String False

The Contact_mailaddress_address2 field of the STKitDocument object.

Contact_mailaddress_city String False

The Contact_mailaddress_city field of the STKitDocument object.

Contact_mailaddress_state String False

The Contact_mailaddress_state field of the STKitDocument object.

Contact_mailaddress_zip String False

The Contact_mailaddress_zip field of the STKitDocument object.

Contact_mailaddress_country String False

The Contact_mailaddress_country field of the STKitDocument object.

Contact_mailaddress_countrycode String False

The Contact_mailaddress_countrycode field of the STKitDocument object.

Shiptokey String False

The Shiptokey field of the STKitDocument object.

Shipto_contactname String False

The Shipto_contactname field of the STKitDocument object.

Shipto_prefix String False

The Shipto_prefix field of the STKitDocument object.

Shipto_firstname String False

The Shipto_firstname field of the STKitDocument object.

Shipto_initial String False

The Shipto_initial field of the STKitDocument object.

Shipto_lastname String False

The Shipto_lastname field of the STKitDocument object.

Shipto_companyname String False

The Shipto_companyname field of the STKitDocument object.

Shipto_printas String False

The Shipto_printas field of the STKitDocument object.

Shipto_phone1 String False

The Shipto_phone1 field of the STKitDocument object.

Shipto_phone2 String False

The Shipto_phone2 field of the STKitDocument object.

Shipto_cellphone String False

The Shipto_cellphone field of the STKitDocument object.

Shipto_pager String False

The Shipto_pager field of the STKitDocument object.

Shipto_fax String False

The Shipto_fax field of the STKitDocument object.

Shipto_email1 String False

The Shipto_email1 field of the STKitDocument object.

Shipto_email2 String False

The Shipto_email2 field of the STKitDocument object.

Shipto_url1 String False

The Shipto_url1 field of the STKitDocument object.

Shipto_url2 String False

The Shipto_url2 field of the STKitDocument object.

Shipto_visible Boolean False

The Shipto_visible field of the STKitDocument object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the STKitDocument object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the STKitDocument object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the STKitDocument object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the STKitDocument object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the STKitDocument object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the STKitDocument object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the STKitDocument object.

Billtokey String False

The Billtokey field of the STKitDocument object.

Billto_contactname String False

The Billto_contactname field of the STKitDocument object.

Billto_prefix String False

The Billto_prefix field of the STKitDocument object.

Billto_firstname String False

The Billto_firstname field of the STKitDocument object.

Billto_initial String False

The Billto_initial field of the STKitDocument object.

Billto_lastname String False

The Billto_lastname field of the STKitDocument object.

Billto_companyname String False

The Billto_companyname field of the STKitDocument object.

Billto_printas String False

The Billto_printas field of the STKitDocument object.

Billto_phone1 String False

The Billto_phone1 field of the STKitDocument object.

Billto_phone2 String False

The Billto_phone2 field of the STKitDocument object.

Billto_cellphone String False

The Billto_cellphone field of the STKitDocument object.

Billto_pager String False

The Billto_pager field of the STKitDocument object.

Billto_fax String False

The Billto_fax field of the STKitDocument object.

Billto_email1 String False

The Billto_email1 field of the STKitDocument object.

Billto_email2 String False

The Billto_email2 field of the STKitDocument object.

Billto_url1 String False

The Billto_url1 field of the STKitDocument object.

Billto_url2 String False

The Billto_url2 field of the STKitDocument object.

Billto_visible Boolean False

The Billto_visible field of the STKitDocument object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the STKitDocument object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the STKitDocument object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the STKitDocument object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the STKitDocument object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the STKitDocument object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the STKitDocument object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the STKitDocument object.

Message String False

The Message field of the STKitDocument object.

Prrecordkey String False

The Prrecordkey field of the STKitDocument object.

Invbatchkey String False

The Invbatchkey field of the STKitDocument object.

Prinvbatchkey String False

The Prinvbatchkey field of the STKitDocument object.

Printed String False

The Printed field of the STKitDocument object.

Backorder String False

The Backorder field of the STKitDocument object.

Subtotal Double False

The Subtotal field of the STKitDocument object.

Total Double False

The Total field of the STKitDocument object.

Entglgroup Int64 False

The Entglgroup field of the STKitDocument object.

Currency String False

The Currency field of the STKitDocument object.

Exchratedate Datetime False

The Exchratedate field of the STKitDocument object.

Exchratetypes_name String False

The Exchratetypes_name field of the STKitDocument object.

Exchrate Double False

The Exchrate field of the STKitDocument object.

Schopkey String False

The Schopkey field of the STKitDocument object.

Salescontract String False

The Salescontract field of the STKitDocument object.

Usedascontract String False

The Usedascontract field of the STKitDocument object.

Trx_subtotal Double False

The Trx_subtotal field of the STKitDocument object.

Trx_total Double False

The Trx_total field of the STKitDocument object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the STKitDocument object.

Reneweddoc String False

The Reneweddoc field of the STKitDocument object.

Basecurr String False

The Basecurr field of the STKitDocument object.

Systemgenerated String False

The Systemgenerated field of the STKitDocument object.

Invoicerunkey Int64 False

The Invoicerunkey field of the STKitDocument object.

Docpar_in_out String False

The Docpar_in_out field of the STKitDocument object.

Megaentitykey Int64 False

The Megaentitykey field of the STKitDocument object.

Megaentityid String False

The Megaentityid field of the STKitDocument object.

Megaentityname String False

The Megaentityname field of the STKitDocument object.

Record_url String False

The Record_url field of the STKitDocument object.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062