SODocument
Retrieves SODocument report data.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
The Recordno field of the SODocument object. |
| Docno | String | False |
The Docno field of the SODocument object. |
| Docid | String | False |
The Docid field of the SODocument object. |
| Createdfrom | String | False |
The Createdfrom field of the SODocument object. |
| State | String | False |
The State field of the SODocument object. |
| Closed | Boolean | False |
The Closed field of the SODocument object. |
| Whencreated | Datetime | False |
The Whencreated field of the SODocument object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the SODocument object. |
| Whendue | Datetime | False |
The Whendue field of the SODocument object. |
| Status | String | False |
The Status field of the SODocument object. |
| Ponumber | String | False |
The Ponumber field of the SODocument object. |
| Vendordocno | String | False |
The Vendordocno field of the SODocument object. |
| Docparid | String | False |
The Docparid field of the SODocument object. |
| Docparkey | String | False |
The Docparkey field of the SODocument object. |
| Docparclass | String | False |
The Docparclass field of the SODocument object. |
| Term_name | String | False |
The Term_name field of the SODocument object. |
| Note | String | False |
The Note field of the SODocument object. |
| Warehouse_locationid | String | False |
The Warehouse_locationid field of the SODocument object. |
| Shipvia | String | False |
The Shipvia field of the SODocument object. |
| User | String | False |
The User field of the SODocument object. |
| Createduser | String | False |
The Createduser field of the SODocument object. |
| Userid | String | False |
The Userid field of the SODocument object. |
| Createduserid | String | False |
The Createduserid field of the SODocument object. |
| Contact_contactname | String | False |
The Contact_contactname field of the SODocument object. |
| Contact_prefix | String | False |
The Contact_prefix field of the SODocument object. |
| Contact_firstname | String | False |
The Contact_firstname field of the SODocument object. |
| Contact_initial | String | False |
The Contact_initial field of the SODocument object. |
| Contact_lastname | String | False |
The Contact_lastname field of the SODocument object. |
| Contact_companyname | String | False |
The Contact_companyname field of the SODocument object. |
| Contact_printas | String | False |
The Contact_printas field of the SODocument object. |
| Contact_phone1 | String | False |
The Contact_phone1 field of the SODocument object. |
| Contact_phone2 | String | False |
The Contact_phone2 field of the SODocument object. |
| Contact_cellphone | String | False |
The Contact_cellphone field of the SODocument object. |
| Contact_pager | String | False |
The Contact_pager field of the SODocument object. |
| Contact_fax | String | False |
The Contact_fax field of the SODocument object. |
| Contact_email1 | String | False |
The Contact_email1 field of the SODocument object. |
| Contact_email2 | String | False |
The Contact_email2 field of the SODocument object. |
| Contact_url1 | String | False |
The Contact_url1 field of the SODocument object. |
| Contact_url2 | String | False |
The Contact_url2 field of the SODocument object. |
| Contact_visible | Boolean | False |
The Contact_visible field of the SODocument object. |
| Contact_mailaddress_address1 | String | False |
The Contact_mailaddress_address1 field of the SODocument object. |
| Contact_mailaddress_address2 | String | False |
The Contact_mailaddress_address2 field of the SODocument object. |
| Contact_mailaddress_city | String | False |
The Contact_mailaddress_city field of the SODocument object. |
| Contact_mailaddress_state | String | False |
The Contact_mailaddress_state field of the SODocument object. |
| Contact_mailaddress_zip | String | False |
The Contact_mailaddress_zip field of the SODocument object. |
| Contact_mailaddress_country | String | False |
The Contact_mailaddress_country field of the SODocument object. |
| Contact_mailaddress_countrycode | String | False |
The Contact_mailaddress_countrycode field of the SODocument object. |
| Shiptokey | String | False |
The Shiptokey field of the SODocument object. |
| Shipto_contactname | String | False |
The Shipto_contactname field of the SODocument object. |
| Shipto_prefix | String | False |
The Shipto_prefix field of the SODocument object. |
| Shipto_firstname | String | False |
The Shipto_firstname field of the SODocument object. |
| Shipto_initial | String | False |
The Shipto_initial field of the SODocument object. |
| Shipto_lastname | String | False |
The Shipto_lastname field of the SODocument object. |
| Shipto_companyname | String | False |
The Shipto_companyname field of the SODocument object. |
| Shipto_printas | String | False |
The Shipto_printas field of the SODocument object. |
| Shipto_phone1 | String | False |
The Shipto_phone1 field of the SODocument object. |
| Shipto_phone2 | String | False |
The Shipto_phone2 field of the SODocument object. |
| Shipto_cellphone | String | False |
The Shipto_cellphone field of the SODocument object. |
| Shipto_pager | String | False |
The Shipto_pager field of the SODocument object. |
| Shipto_fax | String | False |
The Shipto_fax field of the SODocument object. |
| Shipto_email1 | String | False |
The Shipto_email1 field of the SODocument object. |
| Shipto_email2 | String | False |
The Shipto_email2 field of the SODocument object. |
| Shipto_url1 | String | False |
The Shipto_url1 field of the SODocument object. |
| Shipto_url2 | String | False |
The Shipto_url2 field of the SODocument object. |
| Shipto_visible | Boolean | False |
The Shipto_visible field of the SODocument object. |
| Shipto_mailaddress_address1 | String | False |
The Shipto_mailaddress_address1 field of the SODocument object. |
| Shipto_mailaddress_address2 | String | False |
The Shipto_mailaddress_address2 field of the SODocument object. |
| Shipto_mailaddress_city | String | False |
The Shipto_mailaddress_city field of the SODocument object. |
| Shipto_mailaddress_state | String | False |
The Shipto_mailaddress_state field of the SODocument object. |
| Shipto_mailaddress_zip | String | False |
The Shipto_mailaddress_zip field of the SODocument object. |
| Shipto_mailaddress_country | String | False |
The Shipto_mailaddress_country field of the SODocument object. |
| Shipto_mailaddress_countrycode | String | False |
The Shipto_mailaddress_countrycode field of the SODocument object. |
| Billtokey | String | False |
The Billtokey field of the SODocument object. |
| Billto_contactname | String | False |
The Billto_contactname field of the SODocument object. |
| Billto_prefix | String | False |
The Billto_prefix field of the SODocument object. |
| Billto_firstname | String | False |
The Billto_firstname field of the SODocument object. |
| Billto_initial | String | False |
The Billto_initial field of the SODocument object. |
| Billto_lastname | String | False |
The Billto_lastname field of the SODocument object. |
| Billto_companyname | String | False |
The Billto_companyname field of the SODocument object. |
| Billto_printas | String | False |
The Billto_printas field of the SODocument object. |
| Billto_phone1 | String | False |
The Billto_phone1 field of the SODocument object. |
| Billto_phone2 | String | False |
The Billto_phone2 field of the SODocument object. |
| Billto_cellphone | String | False |
The Billto_cellphone field of the SODocument object. |
| Billto_pager | String | False |
The Billto_pager field of the SODocument object. |
| Billto_fax | String | False |
The Billto_fax field of the SODocument object. |
| Billto_email1 | String | False |
The Billto_email1 field of the SODocument object. |
| Billto_email2 | String | False |
The Billto_email2 field of the SODocument object. |
| Billto_url1 | String | False |
The Billto_url1 field of the SODocument object. |
| Billto_url2 | String | False |
The Billto_url2 field of the SODocument object. |
| Billto_visible | Boolean | False |
The Billto_visible field of the SODocument object. |
| Billto_mailaddress_address1 | String | False |
The Billto_mailaddress_address1 field of the SODocument object. |
| Billto_mailaddress_address2 | String | False |
The Billto_mailaddress_address2 field of the SODocument object. |
| Billto_mailaddress_city | String | False |
The Billto_mailaddress_city field of the SODocument object. |
| Billto_mailaddress_state | String | False |
The Billto_mailaddress_state field of the SODocument object. |
| Billto_mailaddress_zip | String | False |
The Billto_mailaddress_zip field of the SODocument object. |
| Billto_mailaddress_country | String | False |
The Billto_mailaddress_country field of the SODocument object. |
| Billto_mailaddress_countrycode | String | False |
The Billto_mailaddress_countrycode field of the SODocument object. |
| Message | String | False |
The Message field of the SODocument object. |
| Prrecordkey | String | False |
The Prrecordkey field of the SODocument object. |
| Invbatchkey | String | False |
The Invbatchkey field of the SODocument object. |
| Prinvbatchkey | String | False |
The Prinvbatchkey field of the SODocument object. |
| Printed | String | False |
The Printed field of the SODocument object. |
| Backorder | String | False |
The Backorder field of the SODocument object. |
| Subtotal | Double | False |
The Subtotal field of the SODocument object. |
| Total | Double | False |
The Total field of the SODocument object. |
| Entglgroup | Int64 | False |
The Entglgroup field of the SODocument object. |
| Currency | String | False |
The Currency field of the SODocument object. |
| Exchratedate | Datetime | False |
The Exchratedate field of the SODocument object. |
| Exchratetypes_name | String | False |
The Exchratetypes_name field of the SODocument object. |
| Exchrate | Double | False |
The Exchrate field of the SODocument object. |
| Schopkey | String | False |
The Schopkey field of the SODocument object. |
| Salescontract | String | False |
The Salescontract field of the SODocument object. |
| Usedascontract | String | False |
The Usedascontract field of the SODocument object. |
| Trx_subtotal | Double | False |
The Trx_subtotal field of the SODocument object. |
| Trx_total | Double | False |
The Trx_total field of the SODocument object. |
| Exch_rate_type_id | String | False |
The Exch_rate_type_id field of the SODocument object. |
| Reneweddoc | String | False |
The Reneweddoc field of the SODocument object. |
| Basecurr | String | False |
The Basecurr field of the SODocument object. |
| Systemgenerated | String | False |
The Systemgenerated field of the SODocument object. |
| Invoicerunkey | Int64 | False |
The Invoicerunkey field of the SODocument object. |
| Docpar_in_out | String | False |
The Docpar_in_out field of the SODocument object. |
| Custvendid | String | False |
The Custvendid field of the SODocument object. |
| Custvendname | String | False |
The Custvendname field of the SODocument object. |
| Haspostedrevrec | String | False |
The Haspostedrevrec field of the SODocument object. |
| Contractid | String | False |
The Contractid field of the SODocument object. |
| Contractdesc | String | False |
The Contractdesc field of the SODocument object. |
| Trx_totalpaid | String | False |
The Trx_totalpaid field of the SODocument object. |
| Totalpaid | String | False |
The Totalpaid field of the SODocument object. |
| Trx_totalentered | String | False |
The Trx_totalentered field of the SODocument object. |
| Totalentered | String | False |
The Totalentered field of the SODocument object. |
| Trx_totaldue | String | False |
The Trx_totaldue field of the SODocument object. |
| Totaldue | String | False |
The Totaldue field of the SODocument object. |
| Paymentstatus | String | False |
The Paymentstatus field of the SODocument object. |
| Sign_flag | Int64 | False |
The Sign_flag field of the SODocument object. |
| Vsoepricelist | String | False |
The Vsoepricelist field of the SODocument object. |
| Vsoeprclstkey | String | False |
The Vsoeprclstkey field of the SODocument object. |
| Origdocdate | Datetime | False |
The Origdocdate field of the SODocument object. |
| Hasadvbilling | Boolean | False |
The Hasadvbilling field of the SODocument object. |
| Invoicerun_expensepricemarkup | Double | False |
The Invoicerun_expensepricemarkup field of the SODocument object. |
| Invoicerun_description | String | False |
The Invoicerun_description field of the SODocument object. |
| Projectkey | Int64 | False |
The Projectkey field of the SODocument object. |
| Project | String | False |
The Project field of the SODocument object. |
| Projectname | String | False |
The Projectname field of the SODocument object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the SODocument object. |
| Megaentityid | String | False |
The Megaentityid field of the SODocument object. |
| Megaentityname | String | False |
The Megaentityname field of the SODocument object. |
| Record_url | String | False |
The Record_url field of the SODocument object. |