Warehouse Receipt Line

Diagrams

Table

Warehouse Receipt Line

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	No. (No.)	Code20		Editable: No
2	Line No. (Line No.)	Integer		Editable: No
3	Source Type (Source Type)	Integer		Editable: No
4	Source Subtype (Source Subtype)	Option	[0,1,2,3,4,5,6,7,8,9,10]	Editable: No
6	Source No. (Source No.)	Code20		Editable: No
7	Source Line No. (Source Line No.)	Integer		Editable: No
9	Source Document (Source Document)	Option	[,Sales Order,,,Sales Return Order,Purchase Order,,,Purchase Return Order,Inbound Transfer]	Editable: No
10	Location Code (Location Code)	Code10	TableRelation: Location	Editable: No
11	Shelf No. (Shelf No.)	Code10
12	Bin Code (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));
13	Zone Code (Zone Code)	Code10	TableRelation: Zone.Code WHERE (Location Code=FIELD(Location Code))
14	Item No. (Item No.)	Code20	TableRelation: Item	Editable: No
15	Quantity (Quantity)	Decimal (0:5)		Editable: No
16	Qty. (Base) (Qty. (Base))	Decimal (0:5)		Editable: No
19	Qty. Outstanding (Qty. Outstanding)	Decimal (0:5)		Editable: No
20	Qty. Outstanding (Base) (Qty. Outstanding (Base))	Decimal (0:5)		Editable: No
21	Qty. to Receive (Qty. to Receive)	Decimal (0:5)
22	Qty. to Receive (Base) (Qty. to Receive (Base))	Decimal (0:5)
23	Qty. Received (Qty. Received)	Decimal (0:5)		Editable: No
24	Qty. Received (Base) (Qty. Received (Base))	Decimal (0:5)		Editable: No
29	Unit of Measure Code (Unit of Measure Code)	Code10	TableRelation: "Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))	Editable: No
30	Qty. per Unit of Measure (Qty. per Unit of Measure)	Decimal (0:5)	InitValue: 1	Editable: No
31	Variant Code (Variant Code)	Code10	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Item No.))	Editable: No
32	Description (Description)	Text50		Editable: No
33	Description 2 (Description 2)	Text50		Editable: No
34	Status (Status)	Option	[ ,Partially Received,Completely Received]	Editable: No
35	Sorting Sequence No. (Sorting Sequence No.)	Integer		Editable: No
36	Due Date (Due Date)	Date
37	Starting Date (Starting Date)	Date
38	Cubage (Cubage)	Decimal (0:5)
39	Weight (Weight)	Decimal (0:5)
48	Not upd. by Src. Doc. Post. (Not upd. by Src. Doc. Post.)	Boolean		Editable: No
49	Posting from Whse. Ref. (Posting from Whse. Ref.)	Integer		Editable: No
50	Qty. to Cross-Dock (Qty. to Cross-Dock)	Decimal (0:5)
51	Qty. to Cross-Dock (Base) (Qty. to Cross-Dock (Base))	Decimal (0:5)
52	Cross-Dock Zone Code (Cross-Dock Zone Code)	Code10	TableRelation: Zone.Code WHERE (Location Code=FIELD(Location Code), Cross-Dock Bin Zone=CONST(Yes));
53	Cross-Dock Bin Code (Cross-Dock Bin Code)	Code20	TableRelation: IF (Cross-Dock Zone Code=FILTER('')) Bin.Code WHERE (Location Code=FIELD(Location Code), Cross-Dock Bin=CONST(Yes)) ELSE IF (Cross-Dock Zone Code=FILTER(<>'')) Bin.Code WHERE (Location Code=FIELD(Location Code), Zone Code=FIELD(Cross-Dock Zone Code), Cross-Dock Bin=CONST(Yes));

Keys

#	Fields
0	No.,Line No. (No.,Line No.)	SumIndexFields: Qty. to Receive (Base)	Clustered: Yes MaintainSIFTIndex: No
1	Source Type,Source Subtype,Source No.,Source Line No. (Source Type,Source Subtype,Source No.,Source Line No.)	SumIndexFields: Qty. Outstanding (Base)	MaintainSIFTIndex: No
2	No.,Source Type,Source Subtype,Source No.,Source Line No. (No.,Source Type,Source Subtype,Source No.,Source Line No.)		MaintainSQLIndex: No
3	No.,Sorting Sequence No. (No.,Sorting Sequence No.)		MaintainSQLIndex: No
4	No.,Shelf No. (No.,Shelf No.)		MaintainSQLIndex: No
5	No.,Item No. (No.,Item No.)		MaintainSQLIndex: No
6	No.,Source Document,Source No. (No.,Source Document,Source No.)		MaintainSQLIndex: No
7	No.,Due Date (No.,Due Date)		MaintainSQLIndex: No
8	No.,Bin Code (No.,Bin Code)		MaintainSQLIndex: No
9	Item No.,Location Code,Variant Code (Item No.,Location Code,Variant Code)	SumIndexFields: Qty. Outstanding (Base)	MaintainSIFTIndex: No
10	Bin Code,Location Code (Bin Code,Location Code)	SumIndexFields: Cubage,Weight	MaintainSIFTIndex: No

Table Relations To Other Tables

Field	Related Table	Related Field
Cross-Dock Bin Code (Cross-Dock Bin Code)	Bin	Code (Code)	TableRelation: IF (Cross-Dock Zone Code=FILTER('')) Bin.Code WHERE (Location Code=FIELD(Location Code), Cross-Dock Bin=CONST(Yes)) ELSE IF (Cross-Dock Zone Code=FILTER(<>'')) Bin.Code WHERE (Location Code=FIELD(Location Code), Zone Code=FIELD(Cross-Dock Zone Code), Cross-Dock Bin=CONST(Yes));	1..n
Item No. (Item No.)	Item	No. (No.)	TableRelation: Item	1..n
Unit of Measure Code (Unit of Measure Code)	Item Unit of Measure	Code (Code)	TableRelation: "Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))	1..n
Variant Code (Variant Code)	Item Variant	Code (Code)	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Item No.))	1..n
Location Code (Location Code)	Location	Code (Code)	TableRelation: Location	1..n
Cross-Dock Zone Code (Cross-Dock Zone Code)	Zone	Code (Code)	TableRelation: Zone.Code WHERE (Location Code=FIELD(Location Code), Cross-Dock Bin Zone=CONST(Yes));	1..n

Table Relations From Other Tables

From Table	From Field

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

Warehouse Receipt Line

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables