ADO.NET Provider for Sage Intacct

Build 25.0.9434

STKitDocumentEntry

Offers line-level insights into stock kit document entries, capturing kit components, pricing, and quantity data.

Columns

Name Type Description
Recordno [KEY] String A unique identifier for each entry in the stock kit document.
Dochdrno Int64 The document header number associated with the stock kit document entry.
Dochdrid String The unique identifier of the document header for the stock kit document entry.
Bundlenumber String The bundle number related to the stock kit document entry.
Line_no Int64 The line number for the stock kit document entry.
Itemid String The unique identifier for the item in the stock kit document entry.
Itemname String The name of the item in the stock kit document entry.
Itemdesc String A description of the item in the stock kit document entry.
Unit String The unit of measurement for the item in the stock kit document entry.
Warehouse_location_no String The location number of the warehouse where the item is stored.
Warehouse_name String The name of the warehouse where the item is stored.
Memo String Any additional notes or comments related to the stock kit document entry.
Quantity Double The quantity of the item in the stock kit document entry.
Qty_converted Double The converted quantity of the item, based on the applicable conversion rate.
Retailprice Double The retail price of the item in the stock kit document entry.
Price Double The price of the item in the stock kit document entry.
Total Double The total value of the item (price * quantity) in the stock kit document entry.
Whencreated Datetime The timestamp when the stock kit document entry was created.
Whenmodified Datetime The timestamp when the stock kit document entry was last modified.
Item_taxable Boolean Indicates whether the item is taxable in the stock kit document entry.
Item_taxgroup_recordno Int64 The tax group record number associated with the item in the stock kit document entry.
Item_renewalmacro_macroid String The macro ID used for item renewal in the stock kit document entry.
Extended_description String A more detailed description of the item or transaction in the stock kit document entry.
Itemglgroup String The general ledger group associated with the item in the stock kit document entry.
State String The current state of the stock kit document entry.
Status String The status of the stock kit document entry.
Glentrykey1 Int64 The first general ledger entry key associated with the stock kit document entry.
Glentrykey2 Int64 The second general ledger entry key associated with the stock kit document entry.
Cost Double The cost of the item in the stock kit document entry.
Cost_method String The cost method (e.g., FIFO, LIFO) used for the item in the stock kit document entry.
Average_cost String The average cost of the item in the stock kit document entry.
Whse_average_cost String The average cost of the item at the warehouse in the stock kit document entry.
Uiqty Double The quantity of the item in the unit of issue for the stock kit document entry.
Discountpercent Double The discount percentage applied to the item in the stock kit document entry.
Uiprice Double The price per unit of the item in the stock kit document entry.
Uivalue Double The total value of the item in the unit of issue for the stock kit document entry.
Locationid String The location ID where the item is stored in the stock kit document entry.
Locationname String The name of the location where the item is stored in the stock kit document entry.
Departmentid String The department ID associated with the stock kit document entry.
Departmentname String The name of the department associated with the stock kit document entry.
Deptkey String The unique key identifying the department for the stock kit document entry.
Locationkey String The unique key identifying the location for the stock kit document entry.
Timetypekey Int64 The key identifying the type of time associated with the stock kit document entry.
Timetypename String The name of the time type associated with the stock kit document entry.
Timenotes String Any notes related to the time entry in the stock kit document entry.
Eeaccountlabelkey Int64 The key identifying the employee account label for the stock kit document entry.
Eeaccountlabel String The label for the employee account associated with the stock kit document entry.
Source_dockey String The source document key for the stock kit document entry.
Source_doclinekey String The source document line key for the stock kit document entry.
Revrectemplate String The revenue recognition template associated with the stock kit document entry.
Revrectemplatekey String The unique key identifying the revenue recognition template for the stock kit document entry.
Revrecstartdate Datetime The start date for revenue recognition associated with the stock kit document entry.
Itemterm String The item term for the stock kit document entry.
Termperiod String The period for the terms associated with the stock kit document entry.
Revrecenddate Datetime The end date for revenue recognition associated with the stock kit document entry.
Prorateprice Boolean Indicates whether the price is prorated for the stock kit document entry.
Deferrevenue String Indicates if revenue is deferred for the stock kit document entry.
Sc_revrectemplate String The service charge revenue recognition template associated with the stock kit document entry.
Sc_revrectemplatekey String The key identifying the service charge revenue recognition template for the stock kit document entry.
Sc_revrecstartdate Datetime The start date for service charge revenue recognition for the stock kit document entry.
Sc_revrecenddate Datetime The end date for service charge revenue recognition for the stock kit document entry.
Sc_startdate Datetime The start date for the service charge schedule related to the stock kit document entry.
Item_itemtype String The type of item associated with the stock kit document entry.
Item_numdec_sale String The number of decimal places used for sale prices associated with the stock kit document entry.
Item_numdec_std String The number of decimal places used for standard prices associated with the stock kit document entry.
Item_numdec_pur String The number of decimal places used for purchase prices associated with the stock kit document entry.
Item_revposting String The revenue posting method for the item associated with the stock kit document entry.
Item_computeforshortterm Boolean Indicates if the item is computed for short-term revenue recognition in the stock kit document entry.
Item_renewalmacrokey Int64 The key identifying the renewal macro for the item in the stock kit document entry.
Item_uomgrpkey Int64 The key identifying the unit of measure group for the item in the stock kit document entry.
Discount_memo String Any discount-related notes for the stock kit document entry.
Item_revprinting String Indicates the printing method used for revenue recognition entries in the stock kit document entry.
Currency String The currency used for the stock kit document entry.
Exchratedate Datetime The date when the exchange rate was applied for the stock kit document entry.
Exchratetype String The type of exchange rate applied for the stock kit document entry.
Exchrate Double The exchange rate applied for the stock kit document entry.
Trx_price Double The transaction price of the item in the stock kit document entry.
Trx_value Double The transaction value (price * quantity) of the item in the stock kit document entry.
Schedulename String The name of the schedule associated with the stock kit document entry.
Scheduleid String The ID of the schedule associated with the stock kit document entry.
Recurdocid String The recurring document ID associated with the stock kit document entry.
Recurdocentrykey Int64 The key identifying the recurring document entry for the stock kit document entry.
Renewalmacro String The renewal macro associated with the stock kit document entry.
Renewalmacrokey String The key identifying the renewal macro for the stock kit document entry.
Overridetax Boolean Indicates whether the tax for the stock kit document entry has been overridden.
Sc_createrecursched String Indicates whether a recurring schedule has been created for the stock kit document entry.
Sc_existingsched String Indicates if an existing recurring schedule is used for the stock kit document entry.
Sc_extendlineperiod Boolean Indicates whether the line period has been extended for the stock kit document entry.
Sc_installpricing Boolean Indicates whether pricing for the stock kit document entry is installed.
Recurcontractid String The recurring contract ID associated with the stock kit document entry.
Source_docid String The source document ID for the stock kit document entry.
Billable Boolean Indicates whether the stock kit document entry is billable.
Billed Boolean Indicates whether the stock kit document entry has been billed.
Billabletimeentrykey Int64 The key identifying the billable time entry for the stock kit document entry.
Billableprentrykey Int64 The key identifying the billable PR entry for the stock kit document entry.
Billabledocentrykey Int64 The key identifying the billable document entry for the stock kit document entry.
Percentval Double The percentage value applied to the stock kit document entry.
Taxabsval Double The absolute tax value applied to the stock kit document entry.
Taxableamount Double The taxable amount for the stock kit document entry.
Linetotal Double The total amount for the line item in the stock kit document entry.
Discount Double The discount amount applied to the stock kit document entry.
Trx_taxabsval Double The transaction-level absolute tax value applied to the stock kit document entry.
Trx_linetotal Double The total value of the line item for the transaction in the stock kit document entry.
Taxvaloverride Boolean Indicates whether the tax value has been overridden for the stock kit document entry.
Projectkey String The key identifying the project associated with the stock kit document entry.
Projectname String The name of the project associated with the stock kit document entry.
Taskkey String The key identifying the task associated with the stock kit document entry.
Taskname String The name of the task associated with the stock kit document entry.
Projectdimkey Int64 The dimension key of the project associated with the stock kit document entry.
Projectid String The unique identifier for the project associated with the stock kit document entry.
Record_url String The URL for accessing the stock kit document entry record.

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