CreateSchema
Builds a schema file for a specified table or view, supporting documentation and metadata-driven development.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC CreateSchema TableName='APBill', FileName='CreatedSchema.rsd'
Input
| Name | Type | Accepts Output Streams | Description |
| TableName | String | False | The name of the table or view. |
| FileName | String | False | The name of the schema file that is generated. Leaving this field blank returns a base64 encoded binary output. If no file path is included, the file will be generated in the Location property. Ex: Location='C:\\Users\\User\\Desktop\\SageIntacct\\CustomSchemaDirectory\\'. |
| DocParId | String | False | Name of a document type. Used to retrieve custom fields for that document type |
| FileStream | String | True | OutputStream to write the created schema. |
Result Set Columns
| Name | Type | Description |
| Result | String | Returns Success or Failure. |
| FileData | String | The generated schema encoded in base64. Only returned if FileName is not set. |