PSADocumentEntry
Details line entries within PSA documents, capturing item-level pricing, taxes, and project or vendor links.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the PSA document entry record. |
| Dochdrno | Int64 | Reference number for the document header associated with this entry. |
| Dochdrid | String | Identifier for the document header linked to this entry. |
| Bundlenumber | String | The bundle number assigned to this entry. |
| Line_no | Int64 | Line number of the entry in the document. |
| Itemid | String | Unique identifier for the item associated with this entry. |
| Itemname | String | Name of the item linked to this entry. |
| Itemdesc | String | Detailed description of the item for this entry. |
| Unit | String | Unit of measurement for the item in this entry. |
| Warehouse_location_no | String | Location number of the warehouse storing the item. |
| Warehouse_name | String | Name of the warehouse where the item is stored. |
| Memo | String | Additional notes or memo for this entry. |
| Quantity | Double | Number of units for the item in this entry. |
| Qty_converted | Double | Converted quantity for the item in this entry. |
| Retailprice | Double | Retail price of the item for this entry. |
| Price | Double | Price of the item as recorded in this entry. |
| Total | Double | Total amount for this 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 | Tax group record number associated with the item. |
| Item_renewalmacro_macroid | String | Renewal macro ID linked to the item in this entry. |
| Extended_description | String | Extended description for the item in this entry. |
| Itemglgroup | String | General ledger group associated with the item. |
| State | String | Current state or status of the document entry. |
| Status | String | Current status of the PSA document entry record. |
| Glentrykey1 | Int64 | Primary general ledger entry key linked to this entry. |
| Glentrykey2 | Int64 | Secondary general ledger entry key linked to this entry. |
| Cost | Double | Cost value associated with this entry. |
| Cost_method | String | Costing method used for this entry. |
| Average_cost | String | Average cost value of the item for this entry. |
| Whse_average_cost | String | Average cost of the item in the specified warehouse. |
| Uiqty | Double | Unique identifier for the quantity of items in this entry. |
| Discountpercent | Double | Percentage of discount applied to the item in this entry. |
| Uiprice | Double | Unit price for the item in this entry. |
| Uivalue | Double | Calculated value for the unit item in this entry. |
| Locationid | String | Identifier for the location associated with this entry. |
| Locationname | String | Name of the location associated with this entry. |
| Departmentid | String | Identifier for the department associated with this entry. |
| Departmentname | String | Name of the department associated with this entry. |
| Deptkey | String | Unique key for the department linked to this entry. |
| Locationkey | String | Unique key for the location linked to this entry. |
| Timetypekey | Int64 | Key identifying the type of time entry for this record. |
| Timetypename | String | Name of the time entry type for this record. |
| Timenotes | String | Notes or additional details about the time entry. |
| Eeaccountlabelkey | Int64 | Key for the account label associated with this entry. |
| Eeaccountlabel | String | Label for the account associated with this entry. |
| Source_dockey | String | Key for the source document linked to this entry. |
| Source_doclinekey | String | Key for the source document line linked to this entry. |
| Revrectemplate | String | Revenue recognition template for this entry. |
| Revrectemplatekey | String | Key identifying the revenue recognition template. |
| Revrecstartdate | Datetime | Start date for revenue recognition. |
| Itemterm | String | Term or duration associated with the item in this entry. |
| Termperiod | String | Time period for the term associated with this entry. |
| Revrecenddate | Datetime | End date for revenue recognition. |
| Prorateprice | Boolean | Indicates whether the price is prorated. |
| Deferrevenue | String | Details regarding deferred revenue for this entry. |
| Sc_revrectemplate | String | Revenue recognition template for schedule changes. |
| Sc_revrectemplatekey | String | Key for the revenue recognition template related to schedule changes. |
| Sc_revrecstartdate | Datetime | Start date for revenue recognition related to schedule changes. |
| Sc_revrecenddate | Datetime | End date for revenue recognition related to schedule changes. |
| Sc_startdate | Datetime | Start date for the schedule changes in this entry. |
| Item_itemtype | String | Type of the item in this document entry. |
| Item_numdec_sale | String | Number of decimals allowed for sales calculations of this item. |
| Item_numdec_std | String | Number of decimals allowed for standard calculations of this item. |
| Item_numdec_pur | String | Number of decimals allowed for purchase calculations of this item. |
| Item_revposting | String | Revenue posting configuration for this item. |
| Item_computeforshortterm | Boolean | Indicates whether this item is computed for short-term revenue. |
| Item_renewalmacrokey | Int64 | Key identifying the renewal macro associated with this item. |
| Item_uomgrpkey | Int64 | Key for the unit of measure group associated with this item. |
| Discount_memo | String | Memo or notes related to discounts applied to this entry. |
| Item_revprinting | String | Revenue printing configuration for this item. |
| Currency | String | Currency used in this document entry. |
| Exchratedate | Datetime | Date when the exchange rate was applied to this entry. |
| Exchratetype | String | Type of exchange rate applied to this entry. |
| Exchrate | Double | Exchange rate used for this entry. |
| Trx_price | Double | Transaction price associated with this entry. |
| Trx_value | Double | Transaction value calculated for this entry. |
| Schedulename | String | Name of the schedule linked to this entry. |
| Scheduleid | String | Identifier for the schedule linked to this entry. |
| Recurdocname | String | Name of the recurring document linked to this entry. |
| Recurdocid | String | Identifier for the recurring document linked to this entry. |
| Recurdocentrykey | Int64 | Key for the recurring document entry associated with this item. |
| Renewalmacro | String | Renewal macro associated with this entry. |
| Renewalmacrokey | String | Key identifying the renewal macro linked to this entry. |
| Overridetax | Boolean | Indicates whether the tax value is overridden for this entry. |
| Sc_createrecursched | String | Specifies if a recurring schedule should be created for this entry. |
| Sc_existingsched | String | Details of any existing schedule associated with this entry. |
| Sc_extendlineperiod | Boolean | Indicates if the line period should be extended for this entry. |
| Sc_installpricing | Boolean | Indicates if installation pricing is applicable for this entry. |
| Recurcontractid | String | Identifier for the recurring contract linked to this entry. |
| Source_docid | String | Identifier for the source document associated with this entry. |
| Billable | Boolean | Indicates if the entry is billable. |
| Billed | Boolean | Indicates if the entry has already been billed. |
| Billabletimeentrykey | Int64 | Key associated with the billable time entry for this document. |
| Billableprentrykey | Int64 | Key associated with the billable project entry for this document. |
| Billabledocentrykey | Int64 | Key for the billable document entry linked to this record. |
| Percentval | Double | Percentage value associated with the document entry. |
| Taxabsval | Double | Absolute value of the tax for this document entry. |
| Taxableamount | Double | Amount that is subject to tax for this entry. |
| Linetotal | Double | Total amount for the line item in this document entry. |
| Discount | Double | Discount applied to this document entry. |
| Trx_taxabsval | Double | Absolute value of tax specific to the transaction. |
| Trx_linetotal | Double | Transaction-specific total amount for the line item. |
| Taxvaloverride | Boolean | Indicates whether the tax value is overridden for this entry. |
| Projectkey | String | Key identifying the associated project for this entry. |
| Projectname | String | Name of the project linked to this document entry. |
| Taskkey | String | Key identifying the task associated with this entry. |
| Taskname | String | Name of the task linked to this document entry. |
| Billingtemplatekey | String | Key identifying the billing template for this entry. |
| Billingtemplate | String | Name of the billing template applied to this entry. |
| Projectdimkey | Int64 | Key for the project dimension associated with this entry. |
| Projectid | String | Identifier for the project associated with this document entry. |
| Vendordimkey | Int64 | Key for the vendor dimension linked to this entry. |
| Vendorid | String | Identifier for the vendor associated with this document entry. |
| Vendorname | String | Name of the vendor linked to this document entry. |
| Employeedimkey | Int64 | Key for the employee dimension associated with this entry. |
| Employeeid | String | Identifier for the employee associated with this entry. |
| Employeename | String | Name of the employee linked to this document entry. |
| Record_url | String | URL linking to the record associated with this document entry. |