RecurDocumentEntry
Stores recurring document data at the entry level, capturing periodic line items, associated amounts, and schedule details for automating repetitive transactions.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the recurring document entry. |
| Dochdrno | Int64 | Header number of the associated recurring document. |
| Line_no | Int64 | Line number within the recurring document entry. |
| Itemid | String | Identifier for the item in the recurring document entry. |
| Itemdesc | String | Description of the item in the recurring document entry. |
| Unit | String | Unit of measurement for the item. |
| Warehouse_location_no | String | Warehouse location associated with the entry. |
| Memo | String | Memo or note attached to the recurring document entry. |
| Whenmodified | Datetime | Timestamp indicating the last modification of the entry. |
| Item_taxable | Boolean | Indicates whether the item is taxable. |
| Item_computeforshortterm | Boolean | Indicates whether the item is computed for short-term transactions. |
| Item_taxgroup_recordno | Int64 | Identifier for the tax group associated with the item. |
| Item_uomgrpkey | Int64 | Key for the unit of measure group associated with the item. |
| Cost_method | String | Costing method used for the item in the entry. |
| State | String | Current state of the recurring document entry. |
| Status | String | Overall status of the recurring document entry. |
| Linestatus | String | Status of the individual line within the entry. |
| Uiqty | Double | Quantity of the item in the unit of issue. |
| Uiprice | String | Price per unit of the item. |
| Uivalue | Double | Total value of the item in the unit of issue. |
| Department | String | Department associated with the recurring document entry. |
| Location | String | Location associated with the recurring document entry. |
| Docentrykey | Int64 | Unique key for the document entry. |
| Revrecstartdate | Datetime | Start date for revenue recognition. |
| Revrecenddate | Datetime | End date for revenue recognition. |
| Itemterm | String | Term associated with the item. |
| Termperiod | String | Term period for the item in the entry. |
| Prorateprice | Boolean | Indicates if the price is prorated for the term. |
| Revrectemplate | String | Revenue recognition template applied to the entry. |
| Retailprice | String | Retail price of the item in the entry. |
| Discount_memo | String | Memo for any discounts applied to the entry. |
| Currency | String | Currency used in the entry. |
| Exchratedate | Datetime | Date for the exchange rate used. |
| Exchratetype | String | Type of exchange rate applied to the entry. |
| Exchrate | Double | Exchange rate applied to the entry. |
| Trx_price | String | Transaction price of the item. |
| Trx_value | Double | Transaction value of the item. |
| Discountpercent | Double | Percentage discount applied to the entry. |
| Billable | Boolean | Indicates if the entry is billable. |
| Form1099 | Boolean | Indicates if the entry is subject to Form 1099 reporting. |
| Overridetax | Boolean | Indicates if the tax calculation is overridden. |
| Projectdimkey | Int64 | Key for the project dimension associated with the entry. |
| Projectid | String | Identifier for the project associated with the entry. |
| Projectname | String | Name of the project associated with the entry. |
| Vendordimkey | Int64 | Key for the vendor dimension associated with the entry. |
| Vendorid | String | Identifier for the vendor associated with the entry. |
| Vendorname | String | Name of the vendor associated with the entry. |
| Employeedimkey | Int64 | Key for the employee dimension associated with the entry. |
| Employeeid | String | Identifier for the employee associated with the entry. |
| Employeename | String | Name of the employee associated with the entry. |
| Record_url | String | URL for accessing the record of the entry. |