SODocumentEntry
Provides line-level detail for SO documents, including items, pricing, taxes, and references to related records.
Columns
| Name | Type | Description |
| Recordno [KEY] | Long | Unique identifier for the SO document entry record. |
| Dochdrno | Long | Header record number associated with the SO document. |
| Dochdrid | String | Unique identifier for the document header. |
| Docparid | String | Identifier for the document template used in the entry. |
| Bundlenumber | String | Bundle number associated with the SO document. |
| Line_no | Long | Line number of the entry in the SO document. |
| Itemid | String | Identifier for the item listed in the SO document. |
| Itemname | String | Name of the item in the SO document. |
| Itemdesc | String | Description of the item in the SO document. |
| Unit | String | Unit of measurement for the item in the SO document. |
| Warehouse_location_no | String | Location number of the warehouse associated with the item. |
| Warehouse_name | String | Name of the warehouse associated with the item. |
| Memo | String | Additional notes or remarks for the SO document entry. |
| Pricecalcmemo | String | Details related to price calculation for the SO document entry. |
| Quantity | Decimal | Quantity of the item ordered in the SO document. |
| Qty_converted | Decimal | Converted quantity based on the unit of measurement. |
| Retailprice | Decimal | Retail price of the item. |
| Price | Decimal | Actual price of the item in the SO document. |
| Total | Decimal | Extended total price for the item in the SO document. |
| Whencreated | Date | Date the SO document entry was created. |
| Whenmodified | Datetime | Date and time the SO document entry was last modified. |
| Auwhencreated | Datetime | Audit timestamp indicating when the record was created. |
| Createdby | Long | User ID of the person who created the SO document entry. |
| Modifiedby | Long | User ID of the person who last modified the SO document entry. |
| Item_taxable | Bool | Indicates whether the item is taxable. |
| Item_taxgroup_recordno | Long | Record number of the tax group associated with the item. |
| Item_renewalmacro_macroid | String | Renewal macro ID associated with the item. |
| Extended_description | String | Detailed description of the item in the SO document entry. |
| Itemglgroup | Long | General ledger group associated with the item in the SO document entry. |
| State | Bool | State or status of the SO document entry. |
| Status | String | Current status of the SO document entry (e.g., active, inactive). |
| Cost | Decimal | Cost of the item in the SO document. |
| Cost_method | String | Method used to calculate the cost of the item in the SO document. |
| Uiqty | Decimal | Quantity for UI (user interface) purposes in the SO document. |
| Discountpercent | Decimal | Discount percentage applied to the item. |
| Multiplier | Decimal | Multiplier used for calculating price or quantity. |
| Uiprice | Decimal | User interface price for the item in the SO document. |
| Uivalue | Decimal | Extended total price based on UI quantity and price. |
| Locationid | String | Identifier for the location associated with the SO document entry. |
| Locationname | String | Name of the location associated with the SO document entry. |
| Departmentid | String | Department ID related to the SO document entry. |
| Departmentname | String | Name of the department related to the SO document entry. |
| Deptkey | String | Key for the department associated with the SO document entry. |
| Locationkey | String | Key for the location associated with the SO document entry. |
| Timetypekey | Long | Key for the time type associated with the SO document entry. |
| Timetypename | String | Name of the time type associated with the SO document entry. |
| Timenotes | String | Notes related to the time type for the SO document entry. |
| Eeaccountlabelkey | Long | Key for the employee account label related to the SO document entry. |
| Eeaccountlabel | String | Account label for the employee associated with the SO document entry. |
| Source_dockey | String | Source document key associated with the SO document entry. |
| Source_doclinekey | String | Source document line key associated with the SO document entry. |
| Adjdochdrkey | Long | Adjustment document header key associated with the SO document entry. |
| Adjdocentrykey | Long | Adjustment document entry key related to the SO document entry. |
| Revrectemplate | String | Revenue recognition template associated with the SO document entry. |
| Revrectemplatekey | String | Key for the revenue recognition template related to the SO document entry. |
| Revrecstartdate | Date | Revenue recognition start date for the SO document entry. |
| Itemterm | String | Default term period for the item in the SO document. |
| Termperiod | Long | Number of periods for the default term in the SO document. |
| Revrecenddate | Date | Revenue recognition end date for the SO document entry. |
| Prorateprice | Bool | Indicates whether price should be prorated for the SO document entry. |
| Deferrevenue | String | Defer revenue for the SO document entry. |
| Sc_revrectemplate | String | Revenue recognition template for sales contract related to the SO document entry. |
| Sc_revrectemplatekey | String | Key for the sales contract revenue recognition template related to the SO document entry. |
| Sc_revrecstartdate | Date | Start date for revenue recognition for sales contract related to the SO document entry. |
| Sc_revrecenddate | Date | End date for revenue recognition for sales contract related to the SO document entry. |
| Sc_startdate | Date | Start date for the sales contract schedule related to the SO document entry. |
| Item_itemtype | String | Item type for the SO document entry. |
| Item_numdec_sale | Long | Number of decimal places used for sales quantity. |
| Item_numdec_std | Long | Number of decimal places used for standard quantity. |
| Item_numdec_pur | Long | Number of decimal places used for purchase quantity. |
| Item_revposting | String | Revenue posting method for the item in the SO document entry. |
| Item_computeforshortterm | Bool | Indicates whether the item should be computed for short-term revenue recognition. |
| Item_renewalmacrokey | Long | Key for the renewal macro associated with the item in the SO document entry. |
| Item_uomgrpkey | Long | Key for the unit of measure group related to the item in the SO document entry. |
| Item_dropship | Bool | Indicates whether the item is available for drop shipment. |
| Item_buytoorder | Bool | Indicates whether the item is available for buy-to-order. |
| Discount_memo | String | Memo for discount or charge related to the SO document entry. |
| Item_revprinting | String | Revision printing status of the item related to the SO document entry. |
| Currency | String | Transaction currency for the SO document entry. |
| Basecurr | String | Base currency used in the SO document entry. |
| Exchratedate | Date | Date of exchange rate for the SO document entry. |
| Exchratetype | Decimal | Exchange rate type used for the SO document entry. |
| Exchrate | Decimal | Exchange rate used for the SO document entry. |
| Trx_price | Decimal | Transaction price for the SO document entry. |
| Trx_value | Decimal | Extended transaction price for the SO document entry. |
| Schedulename | String | Recurring schedule associated with the SO document entry. |
| Scheduleid | Long | ID of the recurring schedule related to the SO document entry. |
| Recurdocname | String | Name of the recurring document associated with the SO document entry. |
| Recurdocid | Long | ID of the recurring document associated with the SO document entry. |
| Recurdocentrykey | Long | Key for the recurring document entry associated with the SO document entry. |
| Renewalmacro | String | Renewal macro associated with the SO document entry. |
| Renewalmacrokey | String | Key for the renewal macro associated with the SO document entry. |
| Overridetax | Bool | Indicates whether tax is overridden for the SO document entry. |
| Sc_createrecursched | String | Indicates if a recurring schedule template is created for the SO document entry. |
| Sc_existingsched | String | Indicates if an existing recurring schedule is used for the SO document entry. |
| Sc_extendlineperiod | Bool | Indicates whether the line period is extended for the SO document entry. |
| Sc_installpricing | Bool | Indicates whether installment pricing is applied to the SO document entry. |
| Recurcontractid | String | Contract ID for recurring billing related to the SO document entry. |
| Source_docid | String | Source document ID related to the SO document entry. |
| Billable | Bool | Indicates whether the SO document entry is billable. |
| Billed | Bool | Indicates whether the SO document entry has been billed. |
| Billabletimeentrykey | Long | Time entry key associated with the billable SO document entry. |
| Billableglentrykey | Long | General ledger entry key associated with the billable SO document entry. |
| Billableprentrykey | Long | Purchase request entry key associated with the billable SO document entry. |
| Billabledocentrykey | Long | Document entry key associated with the billable SO document entry. |
| Billablecontractschentrykey | Long | Contract schedule entry key associated with the billable SO document entry. |
| Billablecontractusagebillingid | Long | Contract usage billing ID associated with the billable SO document entry. |
| Percentval | Decimal | Line tax rate for the SO document entry. |
| Taxabsval | Decimal | Line tax value for the SO document entry. |
| Taxableamount | Decimal | Taxable amount for the SO document entry. |
| Linetotal | Decimal | Total amount for the line of the SO document entry. |
| Discount | Decimal | Line discount for the SO document entry. |
| Trx_taxabsval | Decimal | Transaction line tax value for the SO document entry. |
| Trx_linetotal | Decimal | Transaction line total for the SO document entry. |
| Taxvaloverride | Bool | Indicates whether tax values are overridden for the SO document entry. |
| Total_amount_converted | Decimal | Total amount converted for the SO document entry. |
| Total_amount_remaining | Decimal | Remaining amount for the SO document entry. |
| Qty_remaining | Decimal | Remaining quantity for the SO document entry. |
| Price_converted | Decimal | Converted price for the SO document entry. |
| Conversiontype | String | Conversion type for the SO document entry. |
| Quantityreserved | Decimal | Reserved quantity for the SO document entry. |
| Quantityallocated | Decimal | Allocated quantity for the SO document entry. |
| Quantityreservedwhenopen | Decimal | Quantity reserved before the fulfillment for the SO document entry. |
| Quantityallocatedwhenopen | Decimal | Quantity allocated before the fulfillment for the SO document entry. |
| Allocreserveisenabled | Bool | Indicates whether allocation and reservation are enabled for the SO document entry. |
| Projectkey | String | Project key for the SO document entry. |
| Projectname | String | Project name for the SO document entry. |
| Taskkey | String | Task key associated with the SO document entry. |
| Taskid | String | Task ID associated with the SO document entry. |
| Taskname | String | Task name associated with the SO document entry. |
| Billingtemplatekey | String | Billing template key associated with the SO document entry. |
| Billingtemplate | String | Billing template for the SO document entry. |
| Geninvoicelinekey | Long | Invoice line key for the preview of the SO document entry. |
| Linelevelsimpletaxtype | String | Tax type at the line level for the SO document entry. |
| Needbydate | Date | The date by which the SO document entry is needed. |
| Shipby | Date | The date by which the SO document entry should be shipped. |
| Donotshipbeforedate | Date | The date before which the SO document entry should not be shipped. |
| Donotshipafterdate | Date | The date after which the SO document entry should not be shipped. |
| Datepickticketprinted | Date | The date when the pick ticket for the SO document entry was printed. |
| Cancelafterdate | Date | The date after which the SO document entry should be canceled. |
| Shippeddate | Date | The date when the SO document entry was shipped. |
| Shiptokey | String | Bill-to contact key for the SO document entry. |
| Shipto_contactname | String | Contact name for the 'Ship To' address. |
| Shipto_prefix | String | Prefix for the 'Ship To' contact (Mr./Ms./Mrs.). |
| Shipto_firstname | String | First name for the 'Ship To' contact. |
| Shipto_initial | String | Middle name or initial for the 'Ship To' contact. |
| Shipto_lastname | String | Last name for the 'Ship To' contact. |
| Shipto_companyname | String | Company name for the 'Ship To' address. |
| Shipto_printas | String | The 'Ship To' name as it appears on official documents. |
| Shipto_phone1 | String | Primary phone number for the 'Ship To' contact. |
| Shipto_phone2 | String | Secondary phone number for the 'Ship To' contact. |
| Shipto_cellphone | String | Cellular phone number for the 'Ship To' contact. |
| Shipto_pager | String | Pager number for the 'Ship To' contact. |
| Shipto_fax | String | Fax number for the 'Ship To' contact. |
| Shipto_email1 | String | Primary email address for the 'Ship To' contact. |
| Shipto_email2 | String | Secondary email address for the 'Ship To' contact. |
| Shipto_url1 | String | Primary URL for the 'Ship To' contact. |
| Shipto_url2 | String | Secondary URL for the 'Ship To' contact. |
| Shipto_visible | Bool | Indicates whether the 'Ship To' contact is visible. |
| Shipto_mailaddress_address1 | String | Address line 1 for the 'Ship To' contact. |
| Shipto_mailaddress_address2 | String | Address line 2 for the 'Ship To' contact. |
| Shipto_mailaddress_city | String | City for the 'Ship To' contact address. |
| Shipto_mailaddress_state | String | State or province for the 'Ship To' contact address. |
| Shipto_mailaddress_zip | String | Zip or postal code for the 'Ship To' contact address. |
| Shipto_mailaddress_country | String | Country for the 'Ship To' contact address. |
| Shipto_mailaddress_countrycode | String | Country code for the 'Ship To' contact address. |
| Btoshiptokey | String | Buy to order deliver-to key for the 'Ship To' contact. |
| Btoshiptocontactname | String | Buy to order deliver-to contact name. |
| Retainagepercentage | String | Retainage percentage for the SO document entry. |
| Amountretained | Decimal | Amount retained for the SO document entry. |
| Trx_amountretained | Decimal | Transaction amount retained for the SO document entry. |
| Relateddockey | String | Related document key for the SO document entry. |
| Relateddoclinekey | String | Related document line key for the SO document entry. |
| Revisedunitqty | Decimal | Revised unit quantity for the SO document entry. |
| Revisedqty | Decimal | Revised quantity for the SO document entry. |
| Draftchangeunitqty | Decimal | Draft change in unit quantity for the SO document entry. |
| Draftchangeqty | Decimal | Draft change in quantity for the SO document entry. |
| Revisedunitvalue | Decimal | Revised unit value (base price) for the SO document entry. |
| Revisedvalue | Decimal | Revised total value for the SO document entry. |
| Trx_revisedvalue | Decimal | Revised transaction total value for the SO document entry. |
| Revisedprice | Decimal | Revised unit price for the SO document entry. |
| Revisedunitprice | Decimal | Revised unit price (base price) for the SO document entry. |
| Trx_revisedprice | Decimal | Revised transaction price for the SO document entry. |
| Relateddoclineno | String | Related document line number for the SO document entry. |
| Draftchangeprice | Decimal | Draft change in price for the SO document entry. |
| Postedqtychanges | Decimal | Posted quantity changes for the SO document entry. |
| Postedchangeextprice | Decimal | Posted changes in extended price for the SO document entry. |
| Postedchangeextbaseprice | Decimal | Posted changes in extended base price for the SO document entry. |
| Addedbychange | Bool | Indicates if the entry was added by change for the SO document. |
| Projectcontractid | String | Project contract ID related to the SO document entry. |
| Projectcontractname | String | Project contract name related to the SO document entry. |
| Projectcontractkey | Long | Project contract key for the SO document entry. |
| Projectcontractlineid | String | Project contract line ID related to the SO document entry. |
| Projectcontractlinename | String | Project contract line name related to the SO document entry. |
| Projectcontractlinekey | Long | Project contract line key for the SO document entry. |
| Pcblexternalrefno | String | External reference number for the SO document entry. |
| Pcbldescription | String | Description related to the SO document entry. |
| Pcblbillingtype | String | Billing type for the SO document entry. |
| Contractlinevalue | Decimal | Contract line value for the SO document entry. |
| Priorapplicationamt | Decimal | Amount from prior application for the SO document entry. |
| Completedthisperiod | Decimal | Amount completed during this period for the SO document entry. |
| Storedmaterials | Decimal | Stored materials for the SO document entry. |
| Totalcompletedtodate | Decimal | Total completed to date for the SO document entry. |
| Percentcompletedtodate | Decimal | Percentage completed to date for the SO document entry. |
| Balanceremaining | Decimal | Remaining balance for the SO document entry. |
| Draftchangebaseprice | Decimal | Draft change in base price for the SO document entry. |
| Previousretainagebalance | Decimal | Previous retainage balance for the SO document entry. |
| Isretainagerelease | Bool | Indicates if retainage release is applicable for the SO document entry. |
| Retainagetobill | Decimal | Retainage to bill for the SO document entry. |
| Retainagebalance | Decimal | Retainage balance for the SO document entry. |
| Itemaliasid | String | Item cross-reference ID for the SO document entry. |
| Projectdimkey | Long | Project dimension key for the SO document entry. |
| Projectid | String | Project ID for the SO document entry. |
| Customerdimkey | Long | Customer dimension key for the SO document entry. |
| Customerid | String | Customer ID for the SO document entry. |
| Customername | String | Customer name for the SO document entry. |
| Vendordimkey | Long | Vendor dimension key for the SO document entry. |
| Vendorid | String | Vendor ID for the SO document entry. |
| Vendorname | String | Vendor name for the SO document entry. |
| Employeedimkey | Long | Employee dimension key for the SO document entry. |
| Employeeid | String | Employee ID for the SO document entry. |
| Employeename | String | Employee name for the SO document entry. |
| Classdimkey | Long | Class dimension key for the SO document entry. |
| Classid | String | Class ID for the SO document entry. |
| Classname | String | Class name for the SO document entry. |
| Contractdimkey | Long | Contract dimension key for the SO document entry. |
| Contractid | String | Contract ID for the SO document entry. |
| Contractname | String | Contract name for the SO document entry. |
| Billed_timesheetentry_entrydate | Date | The billed timesheet entry date for the SO document entry. |
| Gldimtestegi1 | String | GL dimension test field 1 for the SO document entry. |
| Gldimtest | String | GL dimension test for the SO document entry. |
| Item_recordno [KEY] | Long | Foreign key for related object: ITEM |
| Department_recordno [KEY] | Long | Foreign key for related object: DEPARTMENT |
| Location_recordno [KEY] | Long | Foreign key for related object: LOCATION |
| Warehouse_recordno [KEY] | Long | Foreign key for related object: WAREHOUSE |
| Sodocument_recordno [KEY] | String | Foreign key for related object: SODOCUMENT |
| Task_recordno [KEY] | Long | Foreign key for related object: TASK |