Table "Phys. Invt. Order Line"
ID 5876
Namespace: Microsoft.Inventory.Counting.Document
Properties
Fields
Name |
Type |
Description |
"Document No." |
Code[20]
|
|
"Line No." |
Integer
|
|
"On Recording Lines" |
Boolean
|
|
"Item No." |
Code[20]
|
|
"Variant Code" |
Code[10]
|
|
"Location Code" |
Code[10]
|
|
"Bin Code" |
Code[20]
|
|
Description |
Text[100]
|
|
"Description 2" |
Text[50]
|
|
"Unit of Measure" |
Text[50]
|
|
"Base Unit of Measure Code" |
Code[10]
|
|
"Qty. Expected (Base)" |
Decimal
|
|
"Qty. Exp. Calculated" |
Boolean
|
|
"Qty. Exp. Item Tracking (Base)" |
Decimal
|
|
"Use Item Tracking" |
Boolean
|
|
"Qty. Exp. Tracking (Base)" |
Decimal
|
|
"Last Item Ledger Entry No." |
Integer
|
|
"Unit Amount" |
Decimal
|
|
"Unit Cost" |
Decimal
|
|
"No. Finished Rec.-Lines" |
Integer
|
|
"Qty. Recorded (Base)" |
Decimal
|
|
"Quantity (Base)" |
Decimal
|
|
"Entry Type" |
Option
|
|
"Pos. Qty. (Base)" |
Decimal
|
|
"Neg. Qty. (Base)" |
Decimal
|
|
"Without Difference" |
Boolean
|
|
"Recorded Without Order" |
Boolean
|
|
"Shortcut Dimension 1 Code" |
Code[20]
|
|
"Shortcut Dimension 2 Code" |
Code[20]
|
|
"Shelf No." |
Code[10]
|
|
"Gen. Bus. Posting Group" |
Code[20]
|
|
"Gen. Prod. Posting Group" |
Code[20]
|
|
"Inventory Posting Group" |
Code[20]
|
|
"Dimension Set ID" |
Integer
|
|
"Item Category Code" |
Code[20]
|
|
"Item Reference No." |
Code[50]
|
|
"Item Reference Unit of Measure" |
Code[10]
|
|
"Item Reference Type" |
Microsoft.Inventory.Item.Catalog."Item Reference Type"
|
|
"Item Reference Type No." |
Code[30]
|
|
"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
GetPhysInvtOrderHeader
procedure GetPhysInvtOrderHeader()
TestStatusOpen
procedure TestStatusOpen()
CalcQtyAndTrackLinesExpected
procedure CalcQtyAndTrackLinesExpected()
CalcQtyAndLastItemLedgExpected
procedure CalcQtyAndLastItemLedgExpected(var QtyExpected: Decimal, var LastItemLedgEntryNo: Integer)
Parameters
Name |
Type |
Description |
QtyExpected
|
Decimal
|
|
LastItemLedgEntryNo
|
Integer
|
|
ResetQtyExpected
procedure ResetQtyExpected()
TestQtyExpected
procedure TestQtyExpected()
TestQtyRecorded
procedure TestQtyRecorded()
CalcCosts
CheckLine
EmptyLine
procedure EmptyLine(): Boolean
Returns
PrepareLineArgs
procedure PrepareLineArgs(WhseEntry: Record "Warehouse Entry")
Parameters
Name |
Type |
Description |
WhseEntry
|
Record "Warehouse Entry"
|
|
PrepareLineArgs
procedure PrepareLineArgs(ItemLedgEntry: Record "Item Ledger Entry")
Parameters
Name |
Type |
Description |
ItemLedgEntry
|
Record "Item Ledger Entry"
|
|
PrepareLineArgs
procedure PrepareLineArgs(WhseEntry: Record "Warehouse Entry", ItemLedgEntry: Record "Item Ledger Entry")
Parameters
Name |
Type |
Description |
WhseEntry
|
Record "Warehouse Entry"
|
|
ItemLedgEntry
|
Record "Item Ledger Entry"
|
|
PrepareLine
procedure PrepareLine(DocNo: Code[20], LineNo: Integer, ItemNo: Code[20], VariantCode: Code[10], LocationCode: Code[10], BinCode: Code[20], PeriodCode: Code[10], PeriodType: Option)
Parameters
Name |
Type |
Description |
DocNo
|
Code[20]
|
|
LineNo
|
Integer
|
|
ItemNo
|
Code[20]
|
|
VariantCode
|
Code[10]
|
|
LocationCode
|
Code[10]
|
|
BinCode
|
Code[20]
|
|
PeriodCode
|
Code[10]
|
|
PeriodType
|
Option
|
|
PrepareLine
procedure PrepareLine(DocNo: Code[20], LineNo: Integer, PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line", PeriodCode: Code[10], PeriodType: Option)
Parameters
Name |
Type |
Description |
DocNo
|
Code[20]
|
|
LineNo
|
Integer
|
|
PhysInvtOrderLineArgs
|
Record "Phys. Invt. Order Line"
|
|
PeriodCode
|
Code[10]
|
|
PeriodType
|
Option
|
|
ShowDimensions
procedure ShowDimensions()
CreateDim
procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
Parameters
Name |
Type |
Description |
DefaultDimSource
|
List of [Dictionary of [Integer, Code[20]]]
|
|
ValidateShortcutDimCode
procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])
Parameters
Name |
Type |
Description |
FieldNumber
|
Integer
|
|
ShortcutDimCode
|
Code[20]
|
|
LookupShortcutDimCode
procedure LookupShortcutDimCode(FieldNo: Integer, var ShortcutDimCode: Code[20])
Parameters
Name |
Type |
Description |
FieldNo
|
Integer
|
|
ShortcutDimCode
|
Code[20]
|
|
ShowShortcutDimCode
procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
Parameters
Name |
Type |
Description |
ShortcutDimCode
|
array[8] of Code[20]
|
|
ShowPhysInvtRecordingLines
procedure ShowPhysInvtRecordingLines()
ShowExpectPhysInvtTrackLines
procedure ShowExpectPhysInvtTrackLines()
ShowItemTrackingLines
procedure ShowItemTrackingLines(Which: Option)
Parameters
Name |
Type |
Description |
Which
|
Option
|
|
ShowItemLedgerEntries
procedure ShowItemLedgerEntries()
ShowPhysInvtLedgerEntries
procedure ShowPhysInvtLedgerEntries()
GetFieldsFromSKU
procedure GetFieldsFromSKU()
ShowBinContentItem
procedure ShowBinContentItem()
ShowBinContentBin
procedure ShowBinContentBin()
CreateDimFromDefaultDim
procedure CreateDimFromDefaultDim()
CreateDimFromDefaultDim
procedure CreateDimFromDefaultDim(FieldNo: Integer)
Parameters
Name |
Type |
Description |
FieldNo
|
Integer
|
|
GetDateForCalculations
procedure GetDateForCalculations(): Date
Returns
See also