Objects/Tables/Table 5851 Invt. Document Line
Table 5851 Invt. Document Line in 28
Jonas Paprotka, Base Application 28.5.54151.54365, checked
- App
- Base Application
- Namespace
- Microsoft.Inventory.Document
Fields, 57Keys, 4Procedures, 27Events, 7
Versions171819202122232425262728latest
Source29
Fields, 57
| Id | Name | Type | Obsolete |
|---|
| 1 | Document Type | Enum Invt. Doc. Document Type | - |
| 2 | Line No. | Integer | - |
| 3 | Item No. | Code[20] | - |
| 4 | Posting Date | Date | - |
| 5 | Document Date | Date | - |
| 7 | Document No. | Code[20] | - |
| 8 | Description | Text[100] | - |
| 9 | Location Code | Code[10] | - |
| 10 | Inventory Posting Group | Code[20] | - |
| 13 | Quantity | Decimal | - |
| 16 | Unit Amount | Decimal | - |
| 17 | Unit Cost | Decimal | - |
| 18 | Amount | Decimal | - |
| 23 | Salespers./Purch. Code | Code[20] | - |
| 26 | Source Code | Code[10] | - |
| 29 | Applies-to Entry | Integer | - |
| 32 | Item Shpt. Entry No. | Integer | - |
| 34 | Shortcut Dimension 1 Code | Code[20] | - |
| 35 | Shortcut Dimension 2 Code | Code[20] | - |
| 37 | Indirect Cost % | Decimal | - |
| 38 | Gross Weight | Decimal | - |
| 39 | Net Weight | Decimal | - |
| 40 | Units per Parcel | Decimal | - |
| 41 | Unit Volume | Decimal | - |
| 42 | Reason Code | Code[10] | - |
| 55 | Last Item Ledger Entry No. | Integer | - |
| 57 | Gen. Bus. Posting Group | Code[20] | - |
| 58 | Gen. Prod. Posting Group | Code[20] | - |
| 65 | Posting No. Series | Code[20] | - |
| 72 | Unit Cost (ACY) | Decimal | - |
| 480 | Dimension Set ID | Integer | - |
| 5402 | Variant Code | Code[10] | - |
| 5403 | Bin Code | Code[20] | - |
| 5404 | Qty. per Unit of Measure | Decimal | - |
| 5405 | Qty. Rounding Precision | Decimal | - |
| 5406 | Qty. Rounding Precision (Base) | Decimal | - |
| 5407 | Unit of Measure Code | Code[10] | - |
| 5413 | Quantity (Base) | Decimal | - |
| 5470 | Reserved Quantity Inbnd. | Decimal | - |
| 5471 | Reserved Quantity Outbnd. | Decimal | - |
| 5472 | Reserved Qty. Inbnd. (Base) | Decimal | - |
| 5473 | Reserved Qty. Outbnd. (Base) | Decimal | - |
| 5704 | Item Category Code | Code[20] | - |
| 5706 | Purchasing Code | Code[10] | - |
| 5725 | Item Reference No. | Code[50] | - |
| 5726 | Item Reference Unit of Measure | Code[10] | - |
| 5727 | Item Reference Type | Enum Item Reference Type | - |
| 5728 | Item Reference Type No. | Code[30] | - |
| 5801 | Item Charge No. | Code[20] | - |
| 5807 | Applies-from Entry | Integer | - |
| 5811 | Applied Amount | Decimal | - |
| 5812 | Update Standard Cost | Boolean | - |
| 5813 | Amount (ACY) | Decimal | - |
| 5819 | Applies-to Value Entry | Integer | - |
| 12450 | FA No. | Code[20] | - |
| 12451 | FA Entry No. | Integer | - |
| 12452 | Depreciation Book Code | Code[10] | - |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Document Type, Document No., Line No. | - |
| Key2 | Location Code | - |
| Key3 | Item No., Variant Code | - |
| Key4 | Document Type, Document No., Item No., Location Code | - |
Procedures, 27
| Name | Parameters | Returns | Access | Obsolete |
|---|
| EmptyLine | () | Boolean | public | - |
| UpdateAmount | () | | public | - |
| GetInvtDocHeader | () | | public | - |
| GetUnitAmount | (Integer) | | public | - |
| ShowReservation | () | | public | - |
| OpenItemTrackingLines | () | | public | - |
| ShowDimensions | () | | public | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | | public | - |
| LookupShortcutDimCode | (Integer, var Code[20]) | | public | - |
| ShowShortcutDimCode | (var Code[20]) | | public | - |
| RowID1 | () | Text[250] | public | - |
| SuspendStatusCheck | (Boolean) | | public | - |
| Signed | (Decimal) | Decimal | public | - |
| ReserveFromInventory | (var Record Invt. Document Line) | | public | - |
| GetRemainingQty | (var Decimal, var Decimal, Integer) | | public | - |
| GetReservationQty | (var Decimal, var Decimal, var Decimal, var Decimal, Integer) | Decimal | public | - |
| GetSourceCaption | () | Text | public | - |
| FilterReceiptLinesForReservation | (Record Reservation Entry, Text, Boolean) | | public | - |
| FilterShipmentLinesForReservation | (Record Reservation Entry, Text, Boolean) | | public | - |
| ReservEntryExist | () | Boolean | public | - |
| SetReservationEntry | (var Record Reservation Entry) | | public | - |
| SetReservationFilters | (var Record Reservation Entry) | | public | - |
| CheckItemAvailable | (Integer) | | public | - |
| CreateDim | (List) | | public | - |
| CreateDimFromDefaultDim | (Integer) | | public | - |
| SuppressRecalculateDimensions | (Boolean) | | public | - |
| IsCorrection | () | Boolean | public | - |
Events, 7
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeRetrieveCosts | (var Record Invt. Document Line, var Decimal, var Boolean) | - |
| Integration event | OnAfterFilterReceiptLinesForReservation | (var Record Invt. Document Line, Record Reservation Entry, Text, Boolean) | - |
| Integration event | OnAfterFilterShipmentLinesForReservation | (var Record Invt. Document Line, Record Reservation Entry, Text, Boolean) | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Invt. Document Line, var List, Integer) | - |
| Integration event | OnAfterGetUnitAmount | (var Record Invt. Document Line, var Decimal, Integer) | - |
| Integration event | OnAfterOpenItemTrackingLines | (var Record Invt. Document Line) | - |
| Integration event | OnAfterCreateDim | (var Record Invt. Document Line, Integer, Record Invt. Document Line, List) | - |