ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.utility/AD Script SQL
Contents |
AD_Script_SQL
Auxiliary table used by several processes to temporarily store sql commands and later execute them
- Name:SQLScript
- Classname:SQLScript
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| Seqno | N | NUMBER(10, 0) | The order of records in a specified document. |
| Strsql | Y | VARCHAR2(4000) | null |
Other Info
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- AD_SCRIPT_SQL_PK
Columns
Sequence Number
The Sequence indicates the order of records
- Physical column name: Seqno
- Property Name: id
- Reference: Integer
- Default value: @SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM AD_SCRIPT_SQL WHERE xxParentColumn=@xxParentColumn@
- This column is part of the table's identifier
Strsql
- Physical column name: Strsql
- Property Name: strsql
- Reference: Text