InvDocumentEntry
Provides detailed line item information for invoicing documents, including descriptions, quantities, and amounts.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the InvDocumentEntry record. |
| Dochdrno | Int64 | Header number for the associated document. |
| Dochdrid | String | Document header ID for the associated document. |
| Bundlenumber | String | Bundle number associated with the inventory document entry. |
| Line_no | Int64 | Line number for the inventory document entry. |
| Itemid | String | Unique identifier for the item in the inventory document entry. |
| Itemname | String | Name of the item in the inventory document entry. |
| Itemdesc | String | Description of the item in the inventory document entry. |
| Unit | String | Unit of measurement for the item in the inventory document entry. |
| Warehouse_location_no | String | Location number within the warehouse for the item. |
| Warehouse_name | String | Name of the warehouse where the item is located. |
| Memo | String | Memo or notes associated with the inventory document entry. |
| Quantity | Double | Quantity of the item in the inventory document entry. |
| Qty_converted | Double | Converted quantity based on the specified unit. |
| Retailprice | Double | Retail price of the item in the inventory document entry. |
| Price | Double | Price of the item in the inventory document entry. |
| Total | Double | Total price for the item in the inventory document entry. |
| Whencreated | Datetime | Timestamp indicating when the inventory document entry was created. |
| Whenmodified | Datetime | Timestamp indicating when the inventory document entry was last modified. |
| Item_taxable | Boolean | Indicates if the item is taxable in the inventory document entry. |
| Item_taxgroup_recordno | Int64 | Record number for the tax group associated with the item. |
| Item_renewalmacro_macroid | String | Macro ID for item renewal in the inventory document entry. |
| Extended_description | String | Extended description or details about the item in the inventory document entry. |
| Itemglgroup | String | General ledger group for the item in the inventory document entry. |
| State | String | State or condition of the inventory document entry. |
| Status | String | Status of the inventory document entry. |
| Glentrykey1 | Int64 | General ledger entry key for the first entry related to the inventory document. |
| Glentrykey2 | Int64 | General ledger entry key for the second entry related to the inventory document. |
| Cost | Double | Cost of the item in the inventory document entry. |
| Cost_method | String | Cost method used for the item in the inventory document entry. |
| Average_cost | String | Average cost of the item in the inventory document entry. |
| Whse_average_cost | String | Average warehouse cost for the item in the inventory document entry. |
| Uiqty | Double | UI quantity for the item in the inventory document entry. |
| Discountpercent | Double | Discount percentage applied to the item in the inventory document entry. |
| Uiprice | Double | Unit price for the item in the inventory document entry after discounts. |
| Uivalue | Double | Unit value for the item in the inventory document entry. |
| Locationid | String | Location ID associated with the item in the inventory document entry. |
| Locationname | String | Location name where the item is stored in the inventory document entry. |
| Departmentid | String | Department ID for the item in the inventory document entry. |
| Departmentname | String | Department name for the item in the inventory document entry. |
| Deptkey | String | Key identifying the department associated with the item. |
| Locationkey | String | Key identifying the location for the item in the inventory document entry. |
| Timetypekey | Int64 | Key for the time type associated with the inventory document entry. |
| Timetypename | String | Name of the time type associated with the inventory document entry. |
| Timenotes | String | Notes or details about the time associated with the inventory document entry. |
| Eeaccountlabelkey | Int64 | Key for the employee account label in the inventory document entry. |
| Eeaccountlabel | String | Employee account label associated with the inventory document entry. |
| Source_dockey | String | Document key for the source document of the inventory entry. |
| Source_doclinekey | String | Line key for the source document entry associated with the inventory document. |
| Revrectemplate | String | Revenue recognition template associated with the inventory document entry. |
| Revrectemplatekey | String | Key for the revenue recognition template associated with the inventory document entry. |
| Revrecstartdate | Datetime | Start date for the revenue recognition for the item. |
| Itemterm | String | Term associated with the item for revenue recognition in the inventory document entry. |
| Termperiod | String | Period associated with the terms of the inventory document entry. |
| Revrecenddate | Datetime | End date for the revenue recognition for the item. |
| Prorateprice | Boolean | Indicates if the price is prorated in the inventory document entry. |
| Deferrevenue | String | Indicates if revenue is deferred for the item in the inventory document entry. |
| Sc_revrectemplate | String | Revenue recognition template associated with the scheduling of the inventory document entry. |
| Sc_revrectemplatekey | String | Key for the revenue recognition template used in scheduling. |
| Sc_revrecstartdate | Datetime | Start date for scheduling revenue recognition of the item. |
| Sc_revrecenddate | Datetime | End date for scheduling revenue recognition of the item. |
| Sc_startdate | Datetime | Start date for the scheduling of the inventory document entry. |
| Item_itemtype | String | Type of item in the inventory document entry (e.g., physical, service). |
| Item_numdec_sale | String | Number of decimal places used for sale price of the item. |
| Item_numdec_std | String | Number of decimal places used for standard price of the item. |
| Item_numdec_pur | String | Number of decimal places used for purchase price of the item. |
| Item_revposting | String | Indicates whether revenue posting is enabled for the item. |
| Item_computeforshortterm | Boolean | Indicates if the item is computed for short-term revenue recognition. |
| Item_renewalmacrokey | Int64 | Key for the renewal macro associated with the item. |
| Item_uomgrpkey | Int64 | Key for the unit of measurement group associated with the item. |
| Discount_memo | String | Memo describing any discount applied to the item in the inventory document entry. |
| Item_revprinting | String | Indicates whether revenue printing is enabled for the item. |
| Currency | String | Currency used in the inventory document entry. |
| Exchratedate | Datetime | Date the exchange rate was applied to the inventory document entry. |
| Exchratetype | String | Type of exchange rate applied to the inventory document entry. |
| Exchrate | Double | Exchange rate used in the inventory document entry. |
| Trx_price | Double | Transaction price for the item in the inventory document entry. |
| Trx_value | Double | Transaction value for the item in the inventory document entry. |
| Schedulename | String | Name of the schedule associated with the inventory document entry. |
| Scheduleid | String | ID of the schedule associated with the inventory document entry. |
| Recurdocid | String | Recurring document ID associated with the inventory document entry. |
| Recurdocentrykey | Int64 | Key for the recurring document entry associated with the inventory document. |
| Renewalmacro | String | Renewal macro for the item in the inventory document entry. |
| Renewalmacrokey | String | Key for the renewal macro associated with the item in the inventory document entry. |
| Overridetax | Boolean | Indicates if tax override is applied to the item in the inventory document entry. |
| Sc_createrecursched | String | Indicates if a recurring schedule should be created for the inventory document entry. |
| Sc_existingsched | String | Identifies if the inventory document entry is part of an existing schedule. |
| Sc_extendlineperiod | Boolean | Indicates if the line period of the inventory document entry should be extended. |
| Sc_installpricing | Boolean | Indicates if pricing is installed for the inventory document entry. |
| Recurcontractid | String | Contract ID associated with the recurring inventory document entry. |
| Source_docid | String | Document ID for the source document of the inventory entry. |
| Billable | Boolean | Indicates if the inventory document entry is billable. |
| Billed | Boolean | Indicates if the inventory document entry has been billed. |
| Billabletimeentrykey | Int64 | Key for the billable time entry associated with the inventory document. |
| Billableprentrykey | Int64 | Key for the billable PR entry associated with the inventory document. |
| Billabledocentrykey | Int64 | Key for the billable document entry associated with the inventory document. |
| Percentval | Double | Percentage value associated with the inventory document entry. |
| Taxabsval | Double | Absolute tax value for the item in the inventory document entry. |
| Taxableamount | Double | Taxable amount for the item in the inventory document entry. |
| Linetotal | Double | Total value for the line item in the inventory document entry. |
| Discount | Double | Discount applied to the item in the inventory document entry. |
| Trx_taxabsval | Double | Transaction absolute tax value for the item in the inventory document entry. |
| Trx_linetotal | Double | Transaction line total value for the item in the inventory document entry. |
| Taxvaloverride | Boolean | Indicates if the tax value is overridden for the inventory document entry. |
| Projectkey | String | Project key associated with the inventory document entry. |
| Projectname | String | Name of the project associated with the inventory document entry. |
| Taskkey | String | Task key associated with the inventory document entry. |
| Taskname | String | Task name associated with the inventory document entry. |
| Projectdimkey | Int64 | Project dimension key associated with the inventory document entry. |
| Projectid | String | Project ID associated with the inventory document entry. |
| Record_url | String | URL link to the record associated with the inventory document entry. |