Objects/Tables/Table 7134 Item Budget Entry
Table 7134 Item Budget Entry in 28
Jonas Paprotka, Base Application 28.5.54151.54365, checked
- App
- Base Application
- Namespace
- Microsoft.Inventory.Analysis
Fields, 19Keys, 4Procedures, 4Events, 1
Versions171819202122232425262728latest
Source29
Fields, 19
| Id | Name | Type | Obsolete |
|---|
| 1 | Entry No. | Integer | - |
| 2 | Analysis Area | Enum Analysis Area Type | - |
| 3 | Budget Name | Code[10] | - |
| 4 | Date | Date | - |
| 5 | Item No. | Code[20] | - |
| 6 | Source Type | Enum Analysis Source Type | - |
| 7 | Source No. | Code[20] | - |
| 8 | Description | Text[100] | - |
| 9 | Quantity | Decimal | - |
| 10 | Cost Amount | Decimal | - |
| 11 | Sales Amount | Decimal | - |
| 13 | User ID | Code[50] | - |
| 14 | Location Code | Code[10] | - |
| 15 | Global Dimension 1 Code | Code[20] | - |
| 16 | Global Dimension 2 Code | Code[20] | - |
| 17 | Budget Dimension 1 Code | Code[20] | - |
| 18 | Budget Dimension 2 Code | Code[20] | - |
| 19 | Budget Dimension 3 Code | Code[20] | - |
| 480 | Dimension Set ID | Integer | - |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Entry No. | - |
| Key2 | Analysis Area, Budget Name, Item No., Source Type, Source No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code | - |
| Key3 | Analysis Area, Budget Name, Source Type, Source No., Item No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code | - |
| Key4 | Analysis Area, Budget Name, Item No., Date | - |
Procedures, 4
| Name | Parameters | Returns | Access | Obsolete |
|---|
| GetLastEntryNo | () | Integer | public | - |
| GetCaptionClass | (Integer) | Text[250] | public | - |
| GetCaption | () | Text[1024] | public | - |
| ShowDimensions | () | | public | - |
Events, 1
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnInsertOnBeforeCheckGroupDimFilled | (var Record Item Budget Entry, var Boolean) | - |