Warehouse Source Filter #5771

Warehouse table in Microsoft Dynamics 365 Business Central. 53 fields, 0 records in Cronus demo.

53
Fields
0
Records
2
Primary key
0
FlowFields
18
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code, Type.

All fields (53)

Warehouse Source Filter — FIELDS
NO.FIELDTYPECLASSRELATION
1 Code PK Code Normal
2 Description Text Normal
3 Item No. Filter Code Normal → Item #27
4 Variant Code Filter Code Normal → Item Variant #5401
5 Unit of Measure Filter Code Normal → Unit of Measure #204
6 Sell-to Customer No. Filter Code Normal → Customer #18
7 Buy-from Vendor No. Filter Code Normal → Vendor #23
8 Customer No. Filter Code Normal → Customer #18
10 Planned Delivery Date Filter Date FlowFilter
11 Shipment Method Code Filter Code Normal → Shipment Method #10
12 Shipping Agent Code Filter Code Normal → Shipping Agent #291
13 Shipping Advice Filter Code Normal
15 Do Not Fill Qty. to Handle Boolean Normal
16 Show Filter Request Boolean Normal
17 Shipping Agent Service Filter Code Normal → Shipping Agent Services #5790
18 In-Transit Code Filter Code Normal → Location #14
19 Transfer-from Code Filter Code Normal → Location #14
20 Transfer-to Code Filter Code Normal → Location #14
21 Planned Shipment Date Filter Date FlowFilter
22 Planned Receipt Date Filter Date FlowFilter
23 Expected Receipt Date Filter Date FlowFilter
24 Outbound Date Filter Date FlowFilter
25 Inbound Date Filter Date FlowFilter
28 Sales Shipment Date Filter Date FlowFilter
45 Project No. Code Normal → Job #167
96 Reserved from Stock Option Normal
98 Source No. Filter Code Normal
99 Source Document Code Normal
100 Type PK Option Normal
101 Sales Orders Boolean Normal
102 Sales Return Orders Boolean Normal
103 Purchase Orders Boolean Normal
104 Purchase Return Orders Boolean Normal
105 Inbound Transfers Boolean Normal
106 Outbound Transfers Boolean Normal
108 Partial Boolean Normal
109 Complete Boolean Normal
110 Service Orders Boolean Normal
1001 Project Task No. Filter Code Normal → Job Task #1001
5401 Prod. Order No. Code Normal → Production Order #5405
7300 Planned Delivery Date Text Normal
7301 Planned Shipment Date Text Normal
7302 Planned Receipt Date Text Normal
7303 Expected Receipt Date Text Normal
7304 Shipment Date Text Normal
7305 Receipt Date Text Normal
7306 Sales Shipment Date Text Normal
99000754 Prod. Order Line No. Filter Text Normal → Prod. Order Line #5406
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (14)

Tables referenced by fields on the Warehouse Source Filter table through TableRelation properties.

Item
#27 · Inventory · via Item No. Filter
Item Variant
#5401 · Other · via Variant Code Filter
Unit of Measure
#204 · Other · via Unit of Measure Filter
Customer
#18 · Sales · via Sell-to Customer No. Filter, Customer No. Filter
Vendor
#23 · Purchasing · via Buy-from Vendor No. Filter
Shipment Method
#10 · General Ledger · via Shipment Method Code Filter
Shipping Agent
#291 · Other · via Shipping Agent Code Filter
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Filter
Location
#14 · General Ledger · via In-Transit Code Filter, Transfer-from Code Filter, Transfer-to Code Filter
Job
#167 · Other · via Project No.
Job Task
#1001 · Jobs · via Project Task No. Filter
Production Order
#5405 · Other · via Prod. Order No.
Prod. Order Line
#5406 · Other · via Prod. Order Line No. Filter