Table "Phys. Inventory Ledger Entry"
ID 281
Namespace: Microsoft.Inventory.Counting.Journal
Properties
Fields
| Name |
Type |
Description |
| "Entry No." |
Integer
|
|
| "Item No." |
Code[20]
|
|
| "Posting Date" |
Date
|
|
| "Entry Type" |
Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type"
|
|
| "Document No." |
Code[20]
|
|
| Description |
Text[100]
|
|
| "Location Code" |
Code[10]
|
|
| "Inventory Posting Group" |
Code[20]
|
|
| Quantity |
Decimal
|
|
| "Unit Amount" |
Decimal
|
|
| "Unit Cost" |
Decimal
|
|
| Amount |
Decimal
|
|
| "Item Register No." |
Integer
|
|
| "SIFT Bucket No." |
Integer
|
Specifies an automatically generated number that is used by the system to enable better concurrency.
|
| "Salespers./Purch. Code" |
Code[20]
|
|
| "User ID" |
Code[50]
|
|
| "Source Code" |
Code[10]
|
|
| "Global Dimension 1 Code" |
Code[20]
|
|
| "Global Dimension 2 Code" |
Code[20]
|
|
| "Journal Batch Name" |
Code[10]
|
|
| "Reason Code" |
Code[10]
|
|
| "Qty. (Calculated)" |
Decimal
|
|
| "Qty. (Phys. Inventory)" |
Decimal
|
|
| "Last Item Ledger Entry No." |
Integer
|
|
| "Document Date" |
Date
|
|
| "External Document No." |
Code[35]
|
|
| "No. Series" |
Code[20]
|
|
| "Dimension Set ID" |
Integer
|
|
| "Shortcut Dimension 3 Code" |
Code[20]
|
|
| "Shortcut Dimension 4 Code" |
Code[20]
|
|
| "Shortcut Dimension 5 Code" |
Code[20]
|
|
| "Shortcut Dimension 6 Code" |
Code[20]
|
|
| "Shortcut Dimension 7 Code" |
Code[20]
|
|
| "Shortcut Dimension 8 Code" |
Code[20]
|
|
| "Variant Code" |
Code[10]
|
|
| "Unit of Measure Code" |
Code[10]
|
|
| "Phys Invt Counting Period Code" |
Code[10]
|
|
| "Phys Invt Counting Period Type" |
Option
|
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
GetNextEntryNo
[InherentPermissions(TableData,281,r)]
procedure GetNextEntryNo(): Integer
Returns
GetLastEntryNo
[InherentPermissions(TableData,281,r)]
procedure GetLastEntryNo(): Integer
Returns
ShowDimensions
procedure ShowDimensions()
See also