Overview
The tables-data-model.yaml file defines the entities that are used in the Enrichment and Eyeball combo box related fields (the multi column combo box which refers to the master data lookup).
These entities are of three types:
- Tables
- Views
- Stored Procedures (SP)
You should map the entity, in the master data DB, to the system, as explained below.
Template
kind: document metadata: name: extraction/v1/documents/tables-data-model spec: tables: - name: VendorsByNumber schemaName: mdm tableName: tbl_vendor fields: - name: VendorName dataSourceName: vendor_name dataType: String - name: VendorNumber dataSourceName: vendor_number dataType: String - name: VendorType dataSourceName: vendor_type dataType: String storedProcedures: - name: GetOpCoFromAddress commandText: dbo.USP_GetOpCO_From_Address parameters: - name: BillingAddress1 dbType: String - name: ShippingAddress2 dbType: String - name: SoldToAddress3 dbType: String - name: CustomerAddress4 dbType: String fields: - name: opco_code dataSourceName: opco_code dataType: String
| Parameter | Description |
|---|---|
| Name | The name of the entity (table, views, or stored procedure). |
| schemaName | The name of the schema. |
| tableName | The database tables, which needs to be mapped to the system. |
| field name | Fields in the tables. |
| dataSourceName | Source name of the field data. |
| dataType | Data type of the field. |
| Stored procedure | Stored procedures in the database. |
| Parameters | Parameters in the stored procedure. |
For example, in the above template, VendorsByNumber is a table with VendorName, VendorNumber, and VendorType as fields.
