Where are the diagrams?

NAV Diagrams

Table 7321 Warehouse Shipment LineSetup BC Server URL to get a link to the data

CaptionML
ENU=Warehouse Shipment Line
LookupPageID
Page7341
DrillDownPageID
Page7341

Fields

# Name ・Caption Type  
1 PK
No.
Code20
NotEditable
CaptionML
ENU=No.
2 PK
Line No.
Integer
NotEditable
CaptionML
ENU=Line No.
3
Source Type
Integer
NotEditable
CaptionML
ENU=Source Type
4
Source Subtype
Option
NotEditable
CaptionML
ENU=Source Subtype
OptionCaptionML
ENU=0,1,2,3,4,5,6,7,8,9,10
OptionString
[0,1,2,3,4,5,6,7,8,9,10]
6
Source No.
Code20
NotEditable
CaptionML
ENU=Source No.
7
Source Line No.
Integer
NotEditable
CaptionML
ENU=Source Line No.
9
Source Document
Option
NotEditable
CaptionML
ENU=Source Document
OptionCaptionML
ENU=,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,,Outbound Transfer,,,,,,,,Service Order
OptionString
[,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,,Outbound Transfer,,,,,,,,Service Order]
10
Location Code
Code10
NotEditable
TableRelation
Location
Refers To
Location
CaptionML
ENU=Location Code
11
Shelf No.
Code10
CaptionML
ENU=Shelf No.
12
Bin Code
Code20
TableRelation
IF (Zone Code=FILTER('')) Bin.Code WHERE (Location Code=FIELD(Location Code)) ELSE IF (Zone Code=FILTER(<>'')) Bin.Code WHERE (Location Code=FIELD(Location Code), Zone Code=FIELD(Zone Code));
Refers To
Bin
CaptionML
ENU=Bin Code
13
Zone Code
Code10
TableRelation
Zone.Code WHERE (Location Code=FIELD(Location Code))
Refers To
Zone
CaptionML
ENU=Zone Code
14
Item No.
Code20
NotEditable
TableRelation
Item
Refers To
Item
CaptionML
ENU=Item No.
15
Quantity
Decimal
NotEditable
CaptionML
ENU=Quantity
DecimalPlaces
0:5
MinValue
0
16
Qty. (Base)
Decimal
NotEditable
CaptionML
ENU=Qty. (Base)
DecimalPlaces
0:5
19
Qty. Outstanding
Decimal
NotEditable
CaptionML
ENU=Qty. Outstanding
DecimalPlaces
0:5
20
Qty. Outstanding (Base)
Decimal
NotEditable
CaptionML
ENU=Qty. Outstanding (Base)
DecimalPlaces
0:5
21
Qty. to Ship
Decimal
CaptionML
ENU=Qty. to Ship
DecimalPlaces
0:5
MinValue
0
22
Qty. to Ship (Base)
Decimal
CaptionML
ENU=Qty. to Ship (Base)
DecimalPlaces
0:5
23
Qty. Picked
Decimal
NotEditableNormal
CaptionML
ENU=Qty. Picked
DecimalPlaces
0:5
24
Qty. Picked (Base)
Decimal
NotEditable
CaptionML
ENU=Qty. Picked (Base)
DecimalPlaces
0:5
25
Qty. Shipped
Decimal
NotEditable
CaptionML
ENU=Qty. Shipped
DecimalPlaces
0:5
26
Qty. Shipped (Base)
Decimal
NotEditable
CaptionML
ENU=Qty. Shipped (Base)
DecimalPlaces
0:5
27
Pick Qty.
Decimal
NotEditableFlowField
CalcFormula
Sum("Warehouse Activity Line"."Qty. Outstanding" WHERE (Activity Type=CONST(Pick), Whse. Document Type=CONST(Shipment), Whse. Document No.=FIELD(No.), Whse. Document Line No.=FIELD(Line No.), Unit of Measure Code=FIELD(Unit of Measure Code), Action Type=FILTER(' '|Place), Original Breakbulk=CONST(No), Breakbulk No.=CONST(0), Assemble to Order=CONST(No)));
CaptionML
ENU=Pick Qty.
DecimalPlaces
0:5
28
Pick Qty. (Base)
Decimal
NotEditableFlowField
CalcFormula
Sum("Warehouse Activity Line"."Qty. Outstanding (Base)" WHERE (Activity Type=CONST(Pick), Whse. Document Type=CONST(Shipment), Whse. Document No.=FIELD(No.), Whse. Document Line No.=FIELD(Line No.), Action Type=FILTER(' '|Place), Original Breakbulk=CONST(No), Breakbulk No.=CONST(0), Assemble to Order=CONST(No)));
CaptionML
ENU=Pick Qty. (Base)
DecimalPlaces
0:5
29
Unit of Measure Code
Code10
NotEditable
TableRelation
"Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))
Refers To
Item Unit of Measure
CaptionML
ENU=Unit of Measure Code
30
Qty. per Unit of Measure
Decimal
NotEditable
CaptionML
ENU=Qty. per Unit of Measure
DecimalPlaces
0:5
InitValue
1
31
Variant Code
Code10
NotEditable
TableRelation
"Item Variant".Code WHERE (Item No.=FIELD(Item No.))
Refers To
Item Variant
CaptionML
ENU=Variant Code
32
Description
Text50
NotEditable
CaptionML
ENU=Description
33
Description 2
Text50
NotEditable
CaptionML
ENU=Description 2
34
Status
Option
NotEditable
CaptionML
ENU=Status
OptionCaptionML
ENU=" ,Partially Picked,Partially Shipped,Completely Picked,Completely Shipped"
OptionString
[ ,Partially Picked,Partially Shipped,Completely Picked,Completely Shipped]
35
Sorting Sequence No.
Integer
NotEditable
CaptionML
ENU=Sorting Sequence No.
36
Due Date
Date
CaptionML
ENU=Due Date
39
Destination Type
Option
NotEditable
CaptionML
ENU=Destination Type
OptionCaptionML
ENU=" ,Customer,Vendor,Location"
OptionString
[ ,Customer,Vendor,Location]
40
Destination No.
Code20
NotEditable
TableRelation
IF (Destination Type=CONST(Customer)) Customer.No. ELSE IF (Destination Type=CONST(Vendor)) Vendor.No. ELSE IF (Destination Type=CONST(Location)) Location.Code;
Refers To
Customer
Vendor
Location
Field types mismatch: Code10
CaptionML
ENU=Destination No.
41
Cubage
Decimal
CaptionML
ENU=Cubage
DecimalPlaces
0:5
42
Weight
Decimal
CaptionML
ENU=Weight
DecimalPlaces
0:5
44
Shipping Advice
Option
NotEditable
CaptionML
ENU=Shipping Advice
OptionCaptionML
ENU=Partial,Complete
OptionString
[Partial,Complete]
45
Shipment Date
Date
CaptionML
ENU=Shipment Date
46
Completely Picked
Boolean
NotEditable
CaptionML
ENU=Completely Picked
48
Not upd. by Src. Doc. Post.
Boolean
NotEditable
CaptionML
ENU=Not upd. by Src. Doc. Post.
49
Posting from Whse. Ref.
Integer
NotEditable
CaptionML
ENU=Posting from Whse. Ref.
900
Assemble to Order
Boolean
NotEditable
CaptionML
ENU=Assemble to Order
AccessByPermission
TableData 90=R

Keys

Name Fields  
0
No.
Line No.
Clustered
1
No.
Sorting Sequence No.
MaintainSQLIndex
2
No.
Item No.
MaintainSQLIndex
3
No.
Source Document
Source No.
MaintainSQLIndex
4
No.
Shelf No.
MaintainSQLIndex
5
No.
Bin Code
MaintainSQLIndex
6
No.
Due Date
MaintainSQLIndex
7
No.
Destination Type
Destination No.
MaintainSQLIndex
8
Source Type
Source Subtype
Source No.
Source Line No.
Assemble to Order
MaintainSIFTIndex
SumIndexFields
"Qty. Outstanding,Qty. Outstanding (Base)"
9
No.
Source Type
Source Subtype
Source No.
Source Line No.
MaintainSQLIndex
10
Item No.
Location Code
Variant Code
Due Date
MaintainSIFTIndex
SumIndexFields
"Qty. Outstanding (Base),Qty. Picked (Base),Qty. Shipped (Base)"
11
Bin Code
Location Code
MaintainSIFTIndex
SumIndexFields
"Cubage,Weight"

Refers To

From Field To Table To Field  
Bin Code BinCode
TableRelation
IF (Zone Code=FILTER('')) Bin.Code WHERE (Location Code=FIELD(Location Code)) ELSE IF (Zone Code=FILTER(<>'')) Bin.Code WHERE (Location Code=FIELD(Location Code), Zone Code=FIELD(Zone Code));
n:1
Destination No. CustomerNo.
TableRelation
IF (Destination Type=CONST(Customer)) Customer.No. ELSE IF (Destination Type=CONST(Vendor)) Vendor.No. ELSE IF (Destination Type=CONST(Location)) Location.Code;
n:1
Item No. ItemNo.
TableRelation
Item
n:1
Unit of Measure Code Item Unit of MeasureCode
TableRelation
"Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))
n:1
Variant Code Item VariantCode
TableRelation
"Item Variant".Code WHERE (Item No.=FIELD(Item No.))
n:1
Location Code LocationCode
TableRelation
Location
n:1
Destination No.
Field types mismatch
Code20		LocationCode
Field types mismatch
Code10
TableRelation
IF (Destination Type=CONST(Customer)) Customer.No. ELSE IF (Destination Type=CONST(Vendor)) Vendor.No. ELSE IF (Destination Type=CONST(Location)) Location.Code;
n:1
Destination No. VendorNo.
TableRelation
IF (Destination Type=CONST(Customer)) Customer.No. ELSE IF (Destination Type=CONST(Vendor)) Vendor.No. ELSE IF (Destination Type=CONST(Location)) Location.Code;
n:1
Zone Code ZoneCode
TableRelation
Zone.Code WHERE (Location Code=FIELD(Location Code))
n:1

Referenced By

From Table From Field To Field  
Registered Whse. Activity LineWhse. Document Line No. Line No.
1:n
Warehouse Activity LineWhse. Document Line No. Line No.
1:n
Whse. Worksheet LineWhse. Document Line No. Line No.
1:n