Objects/Tables/Table 5777 Item Reference
Table 5777 Item Reference in 21
Jonas Paprotka, Base Application 21.5.53619.63803, checked
- App
- Base Application
Fields, 9Keys, 6Procedures, 3Events, 8
Versions171819202122232425262728latest
Source29
Fields, 9
| Id | Name | Type | Obsolete |
|---|
| 1 | Item No. | Code[20] | - |
| 2 | Variant Code | Code[10] | - |
| 3 | Unit of Measure | Code[10] | - |
| 4 | Reference Type | Enum Item Reference Type | - |
| 5 | Reference Type No. | Code[20] | - |
| 6 | Reference No. | Code[50] | - |
| 7 | Description | Text[100] | - |
| 8 | Discontinue Bar Code | Boolean | Removed 21.0 |
| Not used in base application. |
| 9 | Description 2 | Text[50] | - |
Keys, 6
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Item No., Variant Code, Unit of Measure, Reference Type, Reference Type No., Reference No. | - |
| Key2 | Reference No. | - |
| Key3 | Reference No., Reference Type, Reference Type No. | - |
| Key4 | Reference Type, Reference No. | - |
| Key5 | Item No., Variant Code, Unit of Measure, Reference Type, Reference No. | - |
| Key6 | Reference Type, Reference Type No. | - |
Procedures, 3
| Name | Parameters | Returns | Access | Obsolete |
|---|
| FindItemDescription | (var Text[100], var Text[50], Code[20], Code[10], Code[10], Enum Item Reference Type, Code[20]) | Boolean | public | - |
| HasValidUnitOfMeasure | () | Boolean | public | - |
| CreateItemVendor | () | | public | - |
Events, 8
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCreateItemVendor | (var Record Item Reference, Record Item Vendor) | - |
| Integration event | OnBeforeItemVendorDelete | (Record Item Vendor, Record Item Reference) | - |
| Integration event | OnBeforeFindItemDescription | (var Text[100], var Text[50], Code[20], Code[10], Code[10], Enum Item Reference Type, Code[20], var Boolean, var Boolean) | - |
| Integration event | OnBeforeUpdateItemVendorNo | (var Record Item Reference, var Boolean) | - |
| Integration event | OnBeforeMultipleItemReferencesExist | (var Record Item Reference, var Boolean, var Boolean) | - |
| Integration event | OnInsertTriggerOnBeforeCreateItemVendor | (var Record Item Reference, Record Item Reference, Record Item) | - |
| Integration event | OnBeforeCreateItemVendor | (var Record Item Reference, var Record Item Vendor) | - |
| Integration event | OnBeforeCreateItemVendorProcedure | (var Record Item Reference, var Record Item Vendor, var Boolean) | - |