Where are the diagrams?

NAV Diagrams

Table 5768 Whse. Cross-Dock OpportunitySetup BC Server URL to get a link to the data

CaptionML
ENU=Whse. Cross-Dock Opportunity
LookupPageID
Page5783
DrillDownPageID
Page5783

Fields

# Name ・Caption Type  
1 PK
Source Template Name
Code10
NotEditable
CaptionML
ENU=Source Template Name
2 PK
Source Name/No.
Code20
NotEditable
CaptionML
ENU=Source Name/No.
3 PK
Source Line No.
Integer
NotEditable
CaptionML
ENU=Source Line No.
4 PK
Line No.
Integer
NotEditable
CaptionML
ENU=Line No.
5
From Source Type
Integer
NotEditable
CaptionML
ENU=From Source Type
6
From Source Subtype
Option
NotEditable
CaptionML
ENU=From 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]
7
From Source No.
Code20
NotEditable
CaptionML
ENU=From Source No.
8
From Source Line No.
Integer
NotEditable
CaptionML
ENU=From Source Line No.
9
From Source Subline No.
Integer
NotEditable
CaptionML
ENU=From Source Subline No.
10
From Source Document
Option
NotEditable
CaptionML
ENU=From Source Document
OptionCaptionML
ENU=,Sales Order,Sales Return Order,Purchase Order,Purchase Return Order,Inbound Transfer,Outbound Transfer,Prod. Consumption,Prod. Output,Item Ledger Entry,,,,,,,,,,,Assembly Consumption,Assembly Order
OptionString
[,Sales Order,Sales Return Order,Purchase Order,Purchase Return Order,Inbound Transfer,Outbound Transfer,Prod. Consumption,Prod. Output,Item Ledger Entry,,,,,,,,,,,Assembly Consumption,Assembly Order]
11
To Source Type
Integer
NotEditable
CaptionML
ENU=To Source Type
12
To Source Subtype
Option
NotEditable
CaptionML
ENU=To 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]
13
To Source No.
Code20
NotEditable
CaptionML
ENU=To Source No.
14
To Source Line No.
Integer
NotEditable
CaptionML
ENU=To Source Line No.
15
To Source Subline No.
Integer
NotEditable
CaptionML
ENU=To Source Subline No.
16
To Source Document
Option
BlankZero
CaptionML
ENU=To Source Document
OptionCaptionML
ENU=,Sales Order,,,,,,,Purchase Return Order,,Outbound Transfer,Prod. Order Comp.,,,,,,,,,Assembly Consumption,Assembly Order
OptionString
[,Sales Order,,,,,,,Purchase Return Order,,Outbound Transfer,Prod. Order Comp.,,,,,,,,,Assembly Consumption,Assembly Order]
17
Item No.
Code20
NotEditable
TableRelation
Item
Refers To
Item
CaptionML
ENU=Item No.
18
Variant Code
Code10
NotEditable
TableRelation
"Item Variant".Code WHERE (Item No.=FIELD(Item No.))
Refers To
Item Variant
CaptionML
ENU=Variant Code
19
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
20
Qty. per Unit of Measure
Decimal
NotEditable
CaptionML
ENU=Qty. per Unit of Measure
DecimalPlaces
0:5
InitValue
1
21
Location Code
Code10
NotEditable
TableRelation
Location
Refers To
Location
CaptionML
ENU=Location Code
24
Qty. Needed
Decimal
NotEditable
CaptionML
ENU=Qty. Needed
DecimalPlaces
0:5
25
Qty. Needed (Base)
Decimal
NotEditable
CaptionML
ENU=Qty. Needed (Base)
DecimalPlaces
0:5
26
Qty. to Cross-Dock
Decimal
CaptionML
ENU=Qty. to Cross-Dock
DecimalPlaces
0:5
27
Qty. to Cross-Dock (Base)
Decimal
CaptionML
ENU=Qty. to Cross-Dock (Base)
DecimalPlaces
0:5
28
Qty. Cross-Docked (Base)
Decimal
NotEditableFlowField
CalcFormula
Sum("Whse. Cross-Dock Opportunity"."Qty. to Cross-Dock (Base)" WHERE (Source Template Name=FIELD(Source Template Name), Source Name/No.=FIELD(Source Name/No.), Source Line No.=FIELD(Source Line No.), Location Code=FIELD(Location Code)));
CaptionML
ENU=Qty. Cross-Docked (Base)
DecimalPlaces
0:5
29
Total Qty. Needed (Base)
Decimal
FlowField
CalcFormula
Sum("Whse. Cross-Dock Opportunity"."Qty. Needed (Base)" WHERE (Source Template Name=FIELD(Source Template Name), Source Name/No.=FIELD(Source Name/No.), Source Line No.=FIELD(Source Line No.), Location Code=FIELD(Location Code)));
CaptionML
ENU=Total Qty. Needed (Base)
36
Reserved Quantity
Decimal
NotEditableFlowField
CalcFormula
-Sum("Reservation Entry".Quantity WHERE (Source ID=FIELD(To Source No.), Source Ref. No.=FIELD(To Source Line No.), Source Type=FIELD(To Source Type), Source Subtype=FIELD(To Source Subtype), Source Prod. Order Line=FIELD(To Source Subline No.), Reservation Status=CONST(Reservation)));
CaptionML
ENU=Reserved Quantity
DecimalPlaces
0:5
37
Reserved Qty. (Base)
Decimal
NotEditableFlowField
CalcFormula
-Sum("Reservation Entry".Quantity WHERE (Source ID=FIELD(To Source No.), Source Ref. No.=FIELD(To Source Line No.), Source Type=FIELD(To Source Type), Source Subtype=FIELD(To Source Subtype), Source Prod. Order Line=FIELD(To Source Subline No.), Reservation Status=CONST(Reservation)));
CaptionML
ENU=Reserved Qty. (Base)
DecimalPlaces
0:5
39
To-Src. 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=To-Src. Unit of Measure Code
40
To-Src. Qty. per Unit of Meas.
Decimal
NotEditable
CaptionML
ENU=To-Src. Qty. per Unit of Meas.
DecimalPlaces
0:5
InitValue
1
41
Due Date
Date
NotEditable
CaptionML
ENU=Due Date
42
Pick Qty.
Decimal
NotEditableNormal
CaptionML
ENU=Pick Qty.
DecimalPlaces
0:5
43
Pick Qty. (Base)
Decimal
NotEditableNormal
CaptionML
ENU=Pick Qty. (Base)
DecimalPlaces
0:5
44
Picked Qty.
Decimal
NotEditable
CaptionML
ENU=Picked Qty.
DecimalPlaces
0:5
45
Picked Qty. (Base)
Decimal
NotEditable
CaptionML
ENU=Picked Qty. (Base)
DecimalPlaces
0:5

Keys

Name Fields  
0
Source Template Name
Source Name/No.
Source Line No.
Line No.
ClusteredMaintainSIFTIndex
SumIndexFields
"Qty. to Cross-Dock,Qty. to Cross-Dock (Base)"
1
Item No.
Location Code
SumIndexFields
"Qty. to Cross-Dock,Qty. to Cross-Dock (Base),Qty. Needed,Qty. Needed (Base)"
2
From Source Type
From Source Subtype
From Source No.
From Source Line No.
From Source Subline No.
MaintainSIFTIndex
SumIndexFields
"Qty. Needed,Qty. Needed (Base)"
3
To Source Type
To Source Subtype
To Source No.
To Source Line No.
To Source Subline No.
MaintainSIFTIndex
SumIndexFields
"Qty. to Cross-Dock,Qty. to Cross-Dock (Base)"
4
Due Date

Refers To

From Field To Table To Field  
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
To-Src. 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