SORecurDocument
Holds data for recurring SO documents, managing repeated transactions, billing schedules, and customer payment details.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the recurring SO document record. |
| Status | String | The current status of the recurring SO document (e.g., active, inactive). |
| Ponumber | String | The purchase order number associated with the recurring SO document. |
| Whenmodified | Datetime | The date and time when the recurring SO document was last modified. |
| Vendordocno | String | The vendor document number associated with the recurring sales order. |
| Shipvia | String | The shipping method used for the recurring SO document. |
| Userkey | String | The key of the user associated with the recurring SO document. |
| Warehouse_locationid | String | The identifier of the warehouse location for the recurring sales order. |
| Shiptokey | String | The shipping key associated with the recurring SO document. |
| Billtokey | String | The billing key associated with the recurring SO document. |
| Message | String | Any additional message associated with the recurring SO document. |
| Entity | String | The entity associated with the recurring SO document. |
| Contractid | String | The identifier of the contract associated with the recurring sales order. |
| Contractdesc | String | A description of the contract related to the recurring SO document. |
| Note | String | Any additional notes related to the recurring SO document. |
| Subtotal | String | The subtotal amount for the recurring SO document. |
| Total | String | The total amount for the recurring SO document. |
| Schopkey | Int64 | The key for the schedule operation associated with the recurring SO document. |
| Sourcedocument | String | The identifier of the source document for the recurring sales order. |
| Docid | String | The document ID for the recurring sales order. |
| Startdate | Datetime | The start date for the recurring SO document. |
| Enddate | Datetime | The end date for the recurring SO document. |
| Nextexecdate | Datetime | The next execution date for the recurring SO document. |
| Lastexecdate | Datetime | The last execution date for the recurring SO document. |
| Recurduedate | Datetime | The due date for the next recurring transaction of the sales order. |
| Frequency | String | The frequency of the recurring SO document (e.g., weekly, monthly). |
| Execcount | Int64 | The number of times the recurring sales order has been executed. |
| Repeatcount | Int64 | The number of times the recurring sales order will be repeated. |
| Repeatby | String | The criteria for repeating the recurring sales order (e.g., by day, week, or month). |
| Interval | Int64 | The interval between recurring SO executions. |
| User | String | The user associated with the recurring SO document. |
| Customername | String | The name of the customer for the recurring sales order. |
| Term_name | String | The name of the payment terms associated with the recurring sales order. |
| Scheduledcontactemail | String | The email address for the scheduled contact related to the recurring sales order. |
| Contact_contactname | String | The name of the contact associated with the recurring sales order. |
| Contact_email1 | String | The primary email address of the contact for the recurring sales order. |
| Contact_email2 | String | The secondary email address of the contact for the recurring sales order. |
| Shipto_contactname | String | The name of the contact at the shipping location. |
| Shipto_email1 | String | The primary email address of the contact at the shipping location. |
| Shipto_email2 | String | The secondary email address of the contact at the shipping location. |
| Billto_contactname | String | The name of the contact at the billing location. |
| Billto_email1 | String | The primary email address of the contact at the billing location. |
| Billto_email2 | String | The secondary email address of the contact at the billing location. |
| Dochdrno | Int64 | The document header number associated with the recurring sales order. |
| Basecurr | String | The base currency used for the recurring SO document. |
| Currency | String | The currency used for the recurring SO document. |
| Exchratedate | Datetime | The date on which the exchange rate was applied to the recurring SO document. |
| Exchratetypes_name | String | The exchange rate type used for the recurring SO document. |
| Exchrate | Double | The exchange rate applied to the recurring SO document. |
| Trx_subtotal | String | The transaction subtotal for the recurring SO document. |
| Trx_total | String | The total transaction amount for the recurring SO document. |
| Docstatus | String | The document status of the recurring sales order (e.g., open, closed). |
| Paymethod | String | The payment method for the recurring SO document. |
| Payinfull | Boolean | Indicates whether the full payment has been made for the recurring SO document. |
| Paymentamount | String | The payment amount for the recurring SO document. |
| Customercreditcardkey | String | The customer credit card key for payment processing. |
| Customerbankaccountkey | String | The customer bank account key for payment processing. |
| Creditcardtype | String | The type of credit card used for the recurring SO payment. |
| Accounttype | String | The account type for the payment method used. |
| Bankaccountid | String | The bank account ID used for payment processing. |
| Glaccountkey | String | The general ledger account key for the recurring SO document. |
| Megaentitykey | Int64 | The mega entity key associated with the recurring SO document. |
| Megaentityid | String | The mega entity identifier associated with the recurring SO document. |
| Megaentityname | String | The mega entity name associated with the recurring SO document. |
| Record_url | String | The URL to view or access the recurring SO document. |