Table 4763 "Whse Demo Data Setup"

ContosoCoffeeDemoDataset · Microsoft.DemoData.Warehousing · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
DataClassification	CustomerContent
ObsoleteState	Removed
ObsoleteTag	26.0
ObsoleteReason	The table is moved to “Warehouse Module Setup” table

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	Primary Key	Integer	—	DataClassification SystemMetadata
2	Is DemoData Populated	Boolean	—	DataClassification SystemMetadata
8	Starting Year	Integer	—
9	Working Date	Date	—
17	Company Type	Option	—
24	Adjust for Payment Discount	Boolean	—
31	Retail Code	code[20]	Retail - Gen. Prod. Posting Group caption	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
34	Domestic Code	code[10]	Domestic - VAT Posting Group caption	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
35	Resale Code	code[20]	Resale - Inventory Posting Group caption	TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group)
36	VAT Prod. Posting Group Code	code[20]	—	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
38	Price Factor	Decimal	—
39	Rounding Precision	Decimal	—
40	Customer No.	Code[20]	—	TableRelation Table 18 “Customer”
41	Cust. Posting Group	Code[20]	—	TableRelation Table 92 “Customer Posting Group” (Customer Posting Group)
42	Cust. Gen. Bus. Posting Group	Code[20]	—	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
50	Vendor No.	Code[20]	—	TableRelation Table 23 “Vendor”
51	Vendor Posting Group	Code[20]	—	TableRelation Table 93 “Vendor Posting Group” (Vendor Posting Group)
52	Vend. Gen. Bus. Posting Group	Code[20]	Vend. Gen. Bus. Posting Group caption	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
60	Item 1 No.	Code[20]	—	TableRelation Table 27 “Item”
61	Item 2 No.	Code[20]	—	TableRelation Table 27 “Item”
62	Item 3 No.	Code[20]	—	TableRelation Table 27 “Item”
63	Customer VAT Bus. Code	code[20]	Customer - VAT Business Posting Group caption	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
64	Vendor VAT Bus. Code	code[20]	Vendor - VAT Business Posting Group caption	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
70	Location Bin	Code[10]	—	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
80	Location Adv Logistics	Code[10]	Location Advanced caption	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
90	Location Directed Pick	Code[10]	Location Directed Pick and Put-away caption	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
100	Location In-Transit	Code[10]	—	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(true)))

Keys

Key1: Primary Key (clustered)

Relations

Location Adv Logistics: TableRelation Table 14 “Location”
Location Bin: TableRelation Table 14 “Location”
Location Directed Pick: TableRelation Table 14 “Location”
Location In-Transit: TableRelation Table 14 “Location”
Customer No.: TableRelation Table 18 “Customer”
Vendor No.: TableRelation Table 23 “Vendor”
Cust. Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Vend. Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Retail Code: TableRelation Table 251 “Gen. Product Posting Group”
Item 1 No.: TableRelation Table 27 “Item”
Item 2 No.: TableRelation Table 27 “Item”
Item 3 No.: TableRelation Table 27 “Item”
Customer VAT Bus. Code: TableRelation Table 323 “VAT Business Posting Group”
Domestic Code: TableRelation Table 323 “VAT Business Posting Group”
Vendor VAT Bus. Code: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group Code: TableRelation Table 324 “VAT Product Posting Group”
Cust. Posting Group: TableRelation Table 92 “Customer Posting Group”
Vendor Posting Group: TableRelation Table 93 “Vendor Posting Group”
Resale Code: TableRelation Table 94 “Inventory Posting Group”

Deprecations

object: Removed 26.0 (#if not CLEANSCHEMA26), “The table is moved to “Warehouse Module Setup” table”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Whse Demo Data Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.