Borgs
Below are the schemas and relationships for the Borgs.
| Column | Description | Type |
|---|---|---|
| Id | Internal identifier | String |
| TenantId | Customer identifier | String |
| UpdatedAt | Date of the last record update | Datetime |
| SnapshotAt | Reference date of the transaction | Datetime |
| TimeKey | Incremental temporal value | String |
| BorgId | Business unit identifier | String |
| Code | Business unit code | String |
| Name | Business unit name | String |
| VentId | Virtual Entity (VEnt) identifier of the business unit | String |
| VentName | Virtual Entity (VEnt) name of the business unit | String |
| VentDescription | Virtual Entity (VEnt) description of the business unit | String |
| VentType | Virtual Entity (VEnt) type of the business unit | String |
Borgs Schema Joins
The Borgs schema is related to the following schemas:
| Schema | Relationship Column | Description |
|---|---|---|
| ContractBorgs | BorgId | Relates the rows of Borgs with the rows of ContractBorgs |
| OrderBorgs | BorgId | Relates the rows of Borgs with the rows of OrderBorgs |
| OrderItemBorgs | BorgId | Relates the rows of Borgs with the rows of OrderItemBorgs |
| PreOrderBorgs | BorgId | Relates the rows of Borgs with the rows of PreOrderBorgs |
| PreOrderItemBorgs | BorgId | Relates the rows of Borgs with the rows of PreOrderItemBorgs |
| RequestBorgs | BorgId | Relates the rows of Borgs with the rows of RequestBorgs |
| RequestItemBorgs | BorgId | Relates the rows of Borgs with the rows of RequestItemBorgs |
| RfqBorgs | BorgId | Relates the rows of Borgs with the rows of RfqBorgs |
| SupplierBorgs | BorgId | Relates the rows of Borgs with the rows of SupplierBorgs |