Name of the table: BIQuotationLineFinishes
| Field Name | Description |
|---|---|
| PK_BIItemlineFinishHistoryID | Internal unique reference (Primary Key, Identity) |
| PRI_FK_ItemlineID | Foreign key reference to the item line |
| FK_BISalesContractVersionID | Foreign key to the Sales Contract Version (required) |
| PRI_FK_ItemLineFinishHistoryID | Foreign key to the item line finish history (required) |
| PRI_FK_FinishID | Foreign key reference to the finish |
| FinishNr | Numeric identifier of the finish |
| FinishGroupCode | Code for the finish group (max 64 characters) |
| FinishGroupName | Name of the finish group (max 128 characters) |
| VisibleGroup | Boolean indicating if the group is visible |
| FinishGroupSortPos | Sort position for finish group display |
| FinishCode | Unique finish code (max 64 characters) |
| FinishName | Name of the finish (max 128 characters) |
| CatalogueName | Name of the catalogue (max 128 characters) |
| PrintName | Catalogue print name (max 254 characters) |
| FileName | Catalogue file name (max 8 characters) |
| ExcludeFromProfitCalc | Boolean indicating if the catalogue is excluded from profit calculation |
| FK_SupplierID | ID of the supplier (max 16 characters) |
| SupplierChangeApprovalStatus | Approval status of supplier change: 0 = Not Checked, 1 = Not Approved, 2 = Approved |
| ColorCode | Color code (max 128 characters) |
| ColorSystem | Color system name (max 128 characters) |
| DateUpdatedBISynchItemlineFinishHIstory | Last update timestamp in BI |
| DateCreatedBISynchItemlineFinishHIstory | Record creation timestamp in BI |
| BIDeletedItemlineFinishHIstory | Boolean indicating soft-deletion status in BI |
Comments
0 comments
Article is closed for comments.