Warehouse table in Microsoft Dynamics 365 Business Central. 53 fields, 0 records in Cronus demo.
The Warehouse Source Filter table (ID 5771) is part of the Warehouse area in Microsoft Dynamics 365 Business Central. It contains 53 fields, with a primary key of Code, Type. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Code, Type.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Warehouse Source Filter table through TableRelation properties.