| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| company_id |
Foreign key to company |
globally unique identifier | |
| sales_territory_id |
Foreign key to sales_territory |
globally unique identifier | |
| reference_back_office |
Field used for Embedded entity (store there your ERP PK) |
string | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| sys_logical_delete |
Soft-delete flag: when true, this link is considered deleted, optimizing synchronization (can be physically deleted offline). |
boolean |