Tableau Connector for Sage Intacct

Build 25.0.9434

STKitDocument

Tracks stock kit documents, detailing item bundling, shipping requirements, and relevant transaction references.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

A unique identifier for the stock kit document record.

Docno String False

The document number for the stock kit document.

Docid String False

The document ID for the stock kit document.

Createdfrom String False

The origin or source from which the stock kit document was created.

State String False

The current state of the stock kit document (e.g., open, closed).

Closed Boolean False

Indicates whether the stock kit document has been closed.

Whencreated Datetime False

The date and time when the stock kit document was created.

Whenmodified Datetime False

The date and time when the stock kit document was last modified.

Whendue Datetime False

The date and time when the stock kit document is due.

Status String False

The status of the stock kit document (e.g., pending, processed).

Ponumber String False

The purchase order number associated with the stock kit document.

Vendordocno String False

The vendor document number associated with the stock kit document.

Docparid String False

The document parameter ID for the stock kit document.

Docparkey String False

The document parameter key for the stock kit document.

Docparclass String False

The class of the document parameters for the stock kit document.

Term_name String False

The name of the payment terms associated with the stock kit document.

Note String False

Any additional notes associated with the stock kit document.

Warehouse_locationid String False

The warehouse location ID associated with the stock kit document.

Shipvia String False

The shipping method for the stock kit document.

User String False

The user associated with the stock kit document.

Createduser String False

The user who created the stock kit document.

Userid String False

The user ID associated with the stock kit document.

Createduserid String False

The user ID of the person who created the stock kit document.

Contact_contactname String False

The name of the contact associated with the stock kit document.

Contact_prefix String False

The prefix for the contact's name in the stock kit document.

Contact_firstname String False

The first name of the contact associated with the stock kit document.

Contact_initial String False

The initial of the contact associated with the stock kit document.

Contact_lastname String False

The last name of the contact associated with the stock kit document.

Contact_companyname String False

The company name of the contact for the stock kit document.

Contact_printas String False

The name to be printed for the contact in the stock kit document.

Contact_phone1 String False

The primary phone number of the contact associated with the stock kit document.

Contact_phone2 String False

The secondary phone number of the contact associated with the stock kit document.

Contact_cellphone String False

The cell phone number of the contact associated with the stock kit document.

Contact_pager String False

The pager number of the contact associated with the stock kit document.

Contact_fax String False

The fax number of the contact associated with the stock kit document.

Contact_email1 String False

The primary email address of the contact for the stock kit document.

Contact_email2 String False

The secondary email address of the contact for the stock kit document.

Contact_url1 String False

The primary URL associated with the contact in the stock kit document.

Contact_url2 String False

The secondary URL associated with the contact in the stock kit document.

Contact_visible Boolean False

Indicates whether the contact information is visible in the stock kit document.

Contact_mailaddress_address1 String False

The first line of the contact's mailing address.

Contact_mailaddress_address2 String False

The second line of the contact's mailing address.

Contact_mailaddress_city String False

The city of the contact's mailing address.

Contact_mailaddress_state String False

The state of the contact's mailing address.

Contact_mailaddress_zip String False

The postal code of the contact's mailing address.

Contact_mailaddress_country String False

The country of the contact's mailing address.

Contact_mailaddress_countrycode String False

The country code of the contact's mailing address.

Shiptokey String False

The shipping key associated with the stock kit document.

Shipto_contactname String False

The name of the contact at the shipping address.

Shipto_prefix String False

The prefix of the name of the contact at the shipping address.

Shipto_firstname String False

The first name of the contact at the shipping address.

Shipto_initial String False

The initial of the contact at the shipping address.

Shipto_lastname String False

The last name of the contact at the shipping address.

Shipto_companyname String False

The company name of the contact at the shipping address.

Shipto_printas String False

The name to be printed for the contact at the shipping address.

Shipto_phone1 String False

The primary phone number of the contact at the shipping address.

Shipto_phone2 String False

The secondary phone number of the contact at the shipping address.

Shipto_cellphone String False

The cell phone number of the contact at the shipping address.

Shipto_pager String False

The pager number of the contact at the shipping address.

Shipto_fax String False

The fax number of the contact at the shipping address.

Shipto_email1 String False

The primary email address of the contact at the shipping address.

Shipto_email2 String False

The secondary email address of the contact at the shipping address.

Shipto_url1 String False

The primary URL associated with the shipping contact.

Shipto_url2 String False

The secondary URL associated with the shipping contact.

Shipto_visible Boolean False

Indicates whether the shipping contact information is visible.

Shipto_mailaddress_address1 String False

The first line of the shipping address.

Shipto_mailaddress_address2 String False

The second line of the shipping address.

Shipto_mailaddress_city String False

The city of the shipping address.

Shipto_mailaddress_state String False

The state of the shipping address.

Shipto_mailaddress_zip String False

The postal code of the shipping address.

Shipto_mailaddress_country String False

The country of the shipping address.

Shipto_mailaddress_countrycode String False

The country code of the shipping address.

Billtokey String False

The billing key for the stock kit document.

Billto_contactname String False

The Billto_contactname field of the STKitDocument object.

Billto_prefix String False

The prefix or title (e.g., Mr., Mrs., Dr.) of the billing contact.

Billto_firstname String False

The first name of the billing contact.

Billto_initial String False

The initial(s) of the billing contact's first name.

Billto_lastname String False

The last name of the billing contact.

Billto_companyname String False

The name of the company associated with the billing contact.

Billto_printas String False

The name format to print for the billing contact (e.g., 'John Doe' or 'Doe, John').

Billto_phone1 String False

The primary phone number for the billing contact.

Billto_phone2 String False

The secondary phone number for the billing contact.

Billto_cellphone String False

The mobile phone number for the billing contact.

Billto_pager String False

The pager number for the billing contact.

Billto_fax String False

The fax number for the billing contact.

Billto_email1 String False

The primary email address for the billing contact.

Billto_email2 String False

The secondary email address for the billing contact.

Billto_url1 String False

The primary URL associated with the billing contact.

Billto_url2 String False

The secondary URL associated with the billing contact.

Billto_visible Boolean False

Indicates whether the billing contact's information is visible for display.

Billto_mailaddress_address1 String False

The first line of the billing contact's mailing address.

Billto_mailaddress_address2 String False

The second line of the billing contact's mailing address.

Billto_mailaddress_city String False

The city of the billing contact's mailing address.

Billto_mailaddress_state String False

The state of the billing contact's mailing address.

Billto_mailaddress_zip String False

The postal code of the billing contact's mailing address.

Billto_mailaddress_country String False

The country of the billing contact's mailing address.

Billto_mailaddress_countrycode String False

The country code for the billing contact's mailing address.

Message String False

Any special message or instructions associated with the billing contact or transaction.

Prrecordkey String False

The unique identifier for the related transaction record.

Invbatchkey String False

The key identifying the inventory batch related to the billing document.

Prinvbatchkey String False

The key identifying the sales invoice batch related to the billing document.

Printed String False

Indicates whether the billing document has been printed.

Backorder String False

Indicates whether the billing document is part of a backorder.

Subtotal Double False

The subtotal amount for the billing document before taxes and other charges.

Total Double False

The total amount for the billing document, including taxes and other charges.

Entglgroup Int64 False

The general ledger group associated with the billing document.

Currency String False

The currency used for the billing document.

Exchratedate Datetime False

The date when the exchange rate was applied for the billing document.

Exchratetypes_name String False

The name of the exchange rate type applied to the billing document.

Exchrate Double False

The exchange rate applied to the billing document.

Schopkey String False

The key identifying the sales order for the billing document.

Salescontract String False

The sales contract associated with the billing document.

Usedascontract String False

Indicates if the billing document is used as a contract.

Trx_subtotal Double False

The transaction subtotal for the billing document.

Trx_total Double False

The transaction total, including all taxes and charges, for the billing document.

Exch_rate_type_id String False

The identifier for the exchange rate type used in the billing document.

Reneweddoc String False

Indicates whether the billing document is a renewal of a previous document.

Basecurr String False

The base currency used for the billing document.

Systemgenerated String False

Indicates whether the billing document was generated by the system.

Invoicerunkey Int64 False

The key identifying the invoice run associated with the billing document.

Docpar_in_out String False

Indicates whether the document is incoming or outgoing.

Megaentitykey Int64 False

The key identifying the mega entity associated with the billing document.

Megaentityid String False

The ID of the mega entity associated with the billing document.

Megaentityname String False

The name of the mega entity associated with the billing document.

Record_url String False

The URL for accessing the billing document record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434