PODocumentEntry
Details individual line items in a PO, covering item information, quantity, pricing, and other relevant metadata.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the PO document entry. |
| Dochdrno | Int64 | Header number of the associated PO document. |
| Dochdrid | String | Header ID of the associated PO document. |
| Bundlenumber | String | Identifies the bundle number for grouped entries in the PO document. |
| Line_no | Int64 | The line number within the PO document. |
| Itemid | String | Unique identifier for the item in the PO entry. |
| Itemname | String | The name of the item in the PO entry. |
| Itemdesc | String | Description of the item in the PO entry. |
| Unit | String | Unit of measure for the item. |
| Warehouse_location_no | String | Location number of the warehouse associated with this entry. |
| Warehouse_name | String | Name of the warehouse associated with this entry. |
| Memo | String | Additional notes or comments for the entry. |
| Quantity | Double | The quantity of the item in the PO entry. |
| Qty_converted | Double | Converted quantity for the item based on unit conversions. |
| Retailprice | Double | Retail price of the item. |
| Price | Double | The price of the item in the PO entry. |
| Total | Double | The total cost for this PO entry. |
| Whencreated | Datetime | Timestamp when the entry was created. |
| Whenmodified | Datetime | Timestamp when the entry was last modified. |
| Item_taxable | Boolean | Indicates whether the item is taxable. |
| Item_taxgroup_recordno | Int64 | Record number of the tax group associated with the item. |
| Item_renewalmacro_macroid | String | Macro ID for item renewal processes. |
| Extended_description | String | Extended description providing detailed information about the item. |
| Itemglgroup | String | General ledger group associated with the item. |
| State | String | Current state of the entry (e.g., active, inactive). |
| Status | String | Status of the PO entry. |
| Glentrykey1 | Int64 | First general ledger entry key for the transaction. |
| Glentrykey2 | Int64 | Second general ledger entry key for the transaction. |
| Cost | Double | The cost of the item in the PO entry. |
| Cost_method | String | Method used to calculate the cost of the item. |
| Average_cost | String | Average cost of the item across multiple transactions. |
| Whse_average_cost | String | Average cost of the item in the warehouse. |
| Uiqty | Double | Unique identifier for the quantity of the item. |
| Discountpercent | Double | Percentage discount applied to the item. |
| Uiprice | Double | Unique identifier for the price of the item. |
| Uivalue | Double | Unique identifier for the value of the item. |
| Locationid | String | Identifier for the location associated with the entry. |
| Locationname | String | Name of the location associated with the entry. |
| Departmentid | String | Identifier for the department associated with the entry. |
| Departmentname | String | Name of the department associated with the entry. |
| Deptkey | String | Key for the department associated with the entry. |
| Locationkey | String | Key for the location associated with the entry. |
| Timetypekey | Int64 | Key for the time type associated with the entry. |
| Timetypename | String | Name of the time type associated with the entry. |
| Timenotes | String | Notes related to time tracking for the entry. |
| Eeaccountlabelkey | Int64 | Key for the employee account label associated with the entry. |
| Eeaccountlabel | String | Employee account label associated with the entry. |
| Source_dockey | String | Key for the source document related to this entry. |
| Source_doclinekey | String | Key for the source document line related to this entry. |
| Revrectemplate | String | Revenue recognition template used for the entry. |
| Revrectemplatekey | String | Key for the revenue recognition template. |
| Revrecstartdate | Datetime | Start date for revenue recognition associated with the entry. |
| Itemterm | String | Terms associated with the item in the entry. |
| Termperiod | String | Period associated with the terms of the item in the entry. |
| Revrecenddate | Datetime | End date for revenue recognition associated with the entry. |
| Prorateprice | Boolean | Indicates if the price is prorated for the entry. |
| Deferrevenue | String | Details on deferred revenue associated with the entry. |
| Sc_revrectemplate | String | Subcomponent revenue recognition template used for the entry. |
| Sc_revrectemplatekey | String | Key for the subcomponent revenue recognition template. |
| Sc_revrecstartdate | Datetime | Start date for subcomponent revenue recognition. |
| Sc_revrecenddate | Datetime | End date for subcomponent revenue recognition. |
| Sc_startdate | Datetime | Start date for the subcomponent in the entry. |
| Item_itemtype | String | Type classification for the item in the entry. |
| Item_numdec_sale | String | Number of decimal places allowed for sale transactions for the item. |
| Item_numdec_std | String | Number of decimal places allowed for standard transactions for the item. |
| Item_numdec_pur | String | Number of decimal places allowed for purchase transactions for the item. |
| Item_revposting | String | Details on revenue posting associated with the item. |
| Item_computeforshortterm | Boolean | Indicates if computations are applied for short-term revenue. |
| Item_renewalmacrokey | Int64 | Key for the renewal macro associated with the item. |
| Item_uomgrpkey | Int64 | Key for the unit of measure group for the item. |
| Discount_memo | String | Memo field providing details about any discounts applied. |
| Item_revprinting | String | Details on revenue printing associated with the item. |
| Currency | String | Currency used for the entry. |
| Exchratedate | Datetime | Date when the exchange rate was applied. |
| Exchratetype | String | Type of exchange rate applied to the entry. |
| Exchrate | Double | Exchange rate applied to the transaction. |
| Trx_price | Double | Transaction price for the item in the entry. |
| Trx_value | Double | Transaction value for the item in the entry. |
| Schedulename | String | Name of the schedule associated with the entry. |
| Scheduleid | String | ID of the schedule associated with the entry. |
| Recurdocid | String | ID of the recurring document associated with the entry. |
| Recurdocentrykey | Int64 | Key for the recurring document entry. |
| Renewalmacro | String | Macro details for the renewal process associated with the entry. |
| Renewalmacrokey | String | Key for the renewal macro associated with the entry. |
| Overridetax | Boolean | Indicates if tax override is applied for the entry. |
| Sc_createrecursched | String | Details on creating recurring schedules associated with the entry. |
| Sc_existingsched | String | Details on existing schedules associated with the entry. |
| Sc_extendlineperiod | Boolean | Indicates if the line period is extended for the entry. |
| Sc_installpricing | Boolean | Indicates if installation pricing is applied for the entry. |
| Recurcontractid | String | ID of the recurring contract associated with the entry. |
| Source_docid | String | ID of the source document associated with the entry. |
| Billable | Boolean | Indicates if the entry is billable. |
| Billed | Boolean | Indicates if the entry has been billed. |
| Billabletimeentrykey | Int64 | Key for the billable time entry associated with the entry. |
| Billableprentrykey | Int64 | Key for the billable purchase request entry associated with the entry. |
| Billabledocentrykey | Int64 | Key for the billable document entry associated with the entry. |
| Form1099 | Boolean | Indicates if the entry is included in Form 1099 reporting. |
| Percentval | Double | Percentage value associated with the entry. |
| Taxabsval | Double | Absolute value of tax associated with the entry. |
| Taxableamount | Double | Taxable amount for the entry. |
| Linetotal | Double | Line total amount for the entry. |
| Discount | Double | Discount applied to the entry. |
| Trx_taxabsval | Double | Transaction tax absolute value associated with the entry. |
| Trx_linetotal | Double | Transaction line total amount associated with the entry. |
| Taxvaloverride | Boolean | Indicates if the tax value override is applied. |
| Projectkey | String | Key for the project associated with the entry. |
| Projectname | String | Name of the project associated with the entry. |
| Taskkey | String | Key for the task associated with the entry. |
| Taskname | String | Name of the task associated with the entry. |
| Projectdimkey | Int64 | Key for the project dimension associated with the entry. |
| Projectid | String | ID of the project associated with the entry. |
| Customerdimkey | Int64 | Key for the customer dimension associated with the entry. |
| Customerid | String | ID of the customer associated with the entry. |
| Customername | String | Name of the customer associated with the entry. |
| Record_url | String | URL linking to the record associated with the entry. |