Table 281 Phys. Inventory Ledger Entry in 21
- App
- Base Application
Fields, 36Keys, 5Procedures, 2
Versions171819202122232425262728latest
Source29
Fields, 36
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Item No. | Code[20] | - |
| 3 | Posting Date | Date | - |
| 4 | Entry Type | Enum Item Ledger Entry Type | - |
| 6 | Document No. | Code[20] | - |
| 7 | Description | Text[100] | - |
| 8 | Location Code | Code[10] | - |
| 9 | Inventory Posting Group | Code[20] | - |
| 12 | Quantity | Decimal | - |
| 15 | Unit Amount | Decimal | - |
| 16 | Unit Cost | Decimal | - |
| 17 | Amount | Decimal | - |
| 22 | Salespers./Purch. Code | Code[20] | - |
| 24 | User ID | Code[50] | - |
| 25 | Source Code | Code[10] | - |
| 33 | Global Dimension 1 Code | Code[20] | - |
| 34 | Global Dimension 2 Code | Code[20] | - |
| 45 | Journal Batch Name | Code[10] | - |
| 46 | Reason Code | Code[10] | - |
| 54 | Qty. (Calculated) | Decimal | - |
| 55 | Qty. (Phys. Inventory) | Decimal | - |
| 56 | Last Item Ledger Entry No. | Integer | - |
| 60 | Document Date | Date | - |
| 61 | External Document No. | Code[35] | - |
| 64 | No. Series | Code[20] | - |
| 480 | Dimension Set ID | Integer | - |
| 481 | Shortcut Dimension 3 Code | Code[20] | - |
| 482 | Shortcut Dimension 4 Code | Code[20] | - |
| 483 | Shortcut Dimension 5 Code | Code[20] | - |
| 484 | Shortcut Dimension 6 Code | Code[20] | - |
| 485 | Shortcut Dimension 7 Code | Code[20] | - |
| 486 | Shortcut Dimension 8 Code | Code[20] | - |
| 5402 | Variant Code | Code[10] | - |
| 5407 | Unit of Measure Code | Code[10] | - |
| 7380 | Phys Invt Counting Period Code | Code[10] | - |
| 7381 | Phys Invt Counting Period Type | Option | - |
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Item No., Variant Code, Location Code, Posting Date | - |
| Key3 | Item No., Variant Code, Global Dimension 1 Code, Global Dimension 2 Code, Location Code, Posting Date | - |
| Key4 | Document No., Posting Date | - |
| Key5 | Item No., Phys Invt Counting Period Type, Posting Date | - |
Procedures, 2
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetLastEntryNo | () | Integer | public | - |
| ShowDimensions | () | public | - |