Table 5771 "Warehouse Source Filter"

Base Application · Microsoft.Warehouse.Request · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Warehouse Source Filter
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Code Δ BC28	Code[10]	Specifies the code that identifies the filter record.	NotBlank
2	Description Δ BC28	Text[100]	Specifies the description of filter combinations in the Source Document Filter Card window to retrieve lines from source documents.
3	Item No. Filter Δ BC28	Code[100]	Specifies the item number used to filter the source documents to get.	TableRelation Table 27 “Item”
4	Variant Code Filter Δ BC28	Code[100]	Specifies the item variant used to filter the source documents to get.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code)
5	Unit of Measure Filter Δ BC28	Code[100]	Specifies the unit of measure used to filter the source documents to get.	TableRelation Table 204 “Unit of Measure” (Unit of Measure)
6	Sell-to Customer No. Filter Δ BC28	Code[100]	Specifies the sell-to customer number used to filter the source documents to get.	TableRelation Table 18 “Customer”
7	Buy-from Vendor No. Filter Δ BC28	Code[100]	Specifies the buy-from vendor number used to filter the source documents to get.	TableRelation Table 23 “Vendor”
8	Customer No. Filter Δ BC28	Code[100]	Specifies which customers are included when you use the Filters to Get Source Docs. window to retrieve source document lines.	TableRelation Table 18 “Customer”
10	Planned Delivery Date Filter	Date	—	FlowFilter
11	Shipment Method Code Filter Δ BC28	Code[100]	Specifies the shipment method code used to filter the source documents to get.	TableRelation Table 10 “Shipment Method” (Shipment Method)
12	Shipping Agent Code Filter Δ BC28	Code[100]	Specifies the shipping agent code used to filter the source documents.	TableRelation Table 291 “Shipping Agent” (Shipping Agent)
13	Shipping Advice Filter	Code[100]	—
15	Do Not Fill Qty. to Handle Δ BC28	Boolean	Specifies that inventory quantities are assigned when you get outbound source document lines for shipment.
16	Show Filter Request Δ BC28	Boolean	Specifies if the Filters to Get Source Docs. window appears when you choose Use Filters to Get Source Docs on a warehouse shipment or receipt.
17	Shipping Agent Service Filter Δ BC28	Code[100]	Specifies the shipping agent service used to filter the source documents.	TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code)
18	In-Transit Code Filter Δ BC28	Code[100]	Specifies the in-transit code used to filter the source documents.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(true)))
19	Transfer-from Code Filter Δ BC28	Code[100]	Specifies the transfer-from code used to filter the source documents.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
20	Transfer-to Code Filter Δ BC28	Code[100]	Specifies the transfer-to code used to filter the source documents to get.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
21	Planned Shipment Date Filter	Date	—	FlowFilter
22	Planned Receipt Date Filter	Date	—	FlowFilter
23	Expected Receipt Date Filter	Date	—	FlowFilter
24	Shipment Date Filter	Date	Outbound Date Filter caption	FlowFilter
25	Receipt Date Filter	Date	Inbound Date Filter caption	FlowFilter
28	Sales Shipment Date Filter	Date	—	FlowFilter
45	Job No. Δ BC24	Code[20]	Project No. caption	TableRelation Table 167 “Job”
96	Reserved From Stock	Enum “Reservation From Stock”	Reserved from Stock caption	enum Enum 342 “Reservation From Stock”
98	Source No. Filter Δ BC28	Code[100]	Specifies the number, or number range, that is used to filter the source documents to get.
99	Source Document	Code[250]	—
100	Type	Option	—	OptionCaption: Inbound,Outbound
101	Sales Orders Δ BC28	Boolean	Specifies that sales orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Shipment window.
102	Sales Return Orders Δ BC28	Boolean	Specifies that sales return orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Shipment window.
103	Purchase Orders Δ BC28	Boolean	Specifies that purchase orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Receipt window.
104	Purchase Return Orders Δ BC28	Boolean	Specifies that purchase return orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Shipment window.
105	Inbound Transfers Δ BC28	Boolean	Specifies that inbound transfer orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Receipt.
106	Outbound Transfers Δ BC28	Boolean	Specifies that outbound transfer orders are retrieved when you choose Use Filters to Get Src. Docs in the Warehouse Shipment window.
108	Partial Δ BC28	Boolean	Specifies the Shipping Advice field on sales orders must contain Partial when you choose Use Filters to Get Src. Docs.
109	Complete Δ BC28	Boolean	Specifies the Shipping Advice field on sales orders must contain Complete when you choose Use Filters to Get Src. Docs.
1001	Job Task No. Filter Δ BC24	Code[100]	Project Task No. Filter caption	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
7300	Planned Delivery Date	Text[250]	—
7301	Planned Shipment Date	Text[250]	—
7302	Planned Receipt Date	Text[250]	—
7303	Expected Receipt Date	Text[250]	—
7304	Shipment Date	Text[250]	—
7305	Receipt Date	Text[250]	—
7306	Sales Shipment Date	Text[250]	—

Keys

Key1: Type, Code (clustered)

Events published

OnAfterSetFilters(var GetSourceBatch: Report "Get Source Documents"; var WarehouseSourceFilter: Record "Warehouse Source Filter") (integration)
OnSetFiltersOnSourceTables(var WarehouseSourceFilter: Record "Warehouse Source Filter"; var GetSourceDocuments: Report "Get Source Documents"; var WarehouseRequest: Record "Warehouse Request") (integration)
- subscribers: Codeunit 5991 “Sales Warehouse Mgt.” OnSetFiltersOnSourceTables, Codeunit 5992 “Purchases Warehouse Mgt.” OnSetFiltersOnSourceTables, Codeunit 5993 “Transfer Warehouse Mgt.” OnSetFiltersOnSourceTables, Codeunit 5995 “Service Warehouse Mgt.” OnSetFiltersOnSourceTables
OnAfterCheckType(var WarehouseSourceFilter: Record "Warehouse Source Filter") + BC25 (integration)
- subscribers: Codeunit 5995 “Service Warehouse Mgt.” OnAfterCheckType
OnSetFiltersOnAfterSetSourceFilters(var WarehouseSourceFilter: Record "Warehouse Source Filter"; var WarehouseRequest: Record "Warehouse Request") + BC25 (integration)
- subscribers: Codeunit 5995 “Service Warehouse Mgt.” OnSetFiltersOnAfterSetSourceFilters

Procedures

SetFilters(var GetSourceDocuments: Report "Get Source Documents"; LocationCode: Code[10])

Plus 4 local procedures.

Relations

Shipment Method Code Filter: TableRelation Table 10 “Shipment Method”
Job Task No. Filter: TableRelation Table 1001 “Job Task”
In-Transit Code Filter: TableRelation Table 14 “Location”
Transfer-from Code Filter: TableRelation Table 14 “Location”
Transfer-to Code Filter: TableRelation Table 14 “Location”
Job No.: TableRelation Table 167 “Job”
Customer No. Filter: TableRelation Table 18 “Customer”
Sell-to Customer No. Filter: TableRelation Table 18 “Customer”
Unit of Measure Filter: TableRelation Table 204 “Unit of Measure”
Buy-from Vendor No. Filter: TableRelation Table 23 “Vendor”
Item No. Filter: TableRelation Table 27 “Item”
Shipping Agent Code Filter: TableRelation Table 291 “Shipping Agent”
Variant Code Filter: TableRelation Table 5401 “Item Variant”
Shipping Agent Service Filter: TableRelation Table 5790 “Shipping Agent Services”

Pages and codeunits on this table

Page 5784 “Filters to Get Source Docs.” (source table)
Page 5786 “Source Document Filter Card” (source table)

Extended by

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Warehouse Source Filter"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.