Price Worksheet – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages PPrice Worksheet

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/page7022

Page Name: Price Worksheet
Page Number: 7022
Page Type: Worksheet

Source Table Name: Price Worksheet Line
Source Table Number: 7022

Show/hide columns in the Price Worksheet page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1341180143	PriceTypeFilter			true	true	true
	Available options are: “Any” “Sale” “Purchase”
1	1344124370	Defaults			true	false	true
2	309420624	SourceGroupFilter			true	true	true
	Available options are: “All” “Customer” “Vendor” “Job”
3	1959962292	ModifyExistingLines			true	true	true
4	501759224	Price List Code	1	Price List Code	true	false	p7022p7022UpdateMultiplePriceLists
5	1212005345	Existing Line	100	Existing Line	true	false	p7022p7022UpdateMultiplePriceLists
6	742633266	Status	30	Status	true	false	true
	Available options are: “Draft” “Active” “Inactive”
7	1971744339	CustomerSourceType			true	true	p7022p7022CustomerSourceTypeVisible
	Available options are: “All Customers” “Customer” “Customer Price Group” “Customer Disc. Group” “Campaign” “Contact”
8	2112279371	VendorSourceType			true	true	p7022p7022VendorSourceTypeVisible
	Available options are: “All Vendors” “Vendor” “Campaign” “Contact”
9	1439737104	JobSourceType			true	true	p7022p7022JobSourceGroup
	Available options are: “All Jobs” “Job” “Job Task”
10	1976800340	Parent Source No.	5	Parent Source No.	true	p7022p7022ParentSourceNoEditable	p7022p7022ParentSourceNoVisible
11	1074674960	Source No.	4	Source No.	true	p7022p7022SourceEditable	p7022p7022UseCustomLookup
12	2122635050	Assign-to Parent No.	35	Assign-to Parent No.	true	p7022p7022ParentSourceEditable	p7022p7022AssignToParentNoVisible
13	438976526	Assign-to No.	34	Assign-to No.	true	p7022p7022SourceEditable	not p7022p7022UseCustomLookup
14	1602097610	Asset Type	7	Asset Type	true	p7022p7022ProductTypeEditable	true
	Available options are: ” “ “Item” “Item Discount Group” “Resource” “Resource Group” “Service Cost” “G/L Account”
15	1577150659	Asset No.	8	Asset No.	true	p7022p7022PriceLineEditable	p7022p7022UseCustomLookup
16	704892010	Product No.	33	Product No.	true	p7022p7022PriceLineEditable	not p7022p7022UseCustomLookup
17	113578760	Variant Code	9	Variant Code	true	p7022p7022VariantCodeEditable	p7022p7022VariantCodeVisible
18	1687197322	Variant Code Lookup	36	Variant Code Lookup	true	p7022p7022VariantCodeEditable	p7022p7022VariantCodeLookupVisible
19	489771030	Work Type Code	11	Work Type Code	true	p7022p7022WorkTypeCodeEditable	p7022p7022ResourceAssetVisible
20	79463232	Currency Code	10	Currency Code	true	p7022p7022DateEditable	true
21	1152659456	Unit of Measure Code	15	Unit of Measure Code	true	p7022p7022PriceLineEditable	p7022p7022UoMVisible
22	159986734	Unit of Measure Code Lookup	37	Unit of Measure Code Lookup	true	p7022p7022PriceLineEditable	p7022p7022UoMLookupVisible
23	1486438881	Minimum Quantity	14	Minimum Quantity	true	p7022p7022PriceLineEditable	true
24	78774986	Amount Type	16	Amount Type	true	p7022p7022AmountTypeIsEditable	p7022p7022AmountTypeIsVisible
	Available options are: “Any” “Price” “Cost” “Discount”
25	1399037466	Existing Unit Price	101	Existing Unit Price	true	False	p7022p7022SalesPriceVisible
26	934553305	Unit Price	17	Unit Price	true	p7022p7022UnitPriceEditable	p7022p7022SalesPriceVisible
27	1747220244	Cost Factor	18	Cost Factor	true	p7022p7022UnitPriceEditable	p7022p7022SalesPriceVisible
28	1571122905	Existing Direct Unit Cost	102	Existing Direct Unit Cost	true	False	p7022p7022PurchPriceVisible
29	1501013686	Direct Unit Cost	31	Direct Unit Cost	true	p7022p7022UnitPriceEditable	p7022p7022PurchPriceVisible
30	1401553332	Existing Unit Cost	103	Existing Unit Cost	true	False	p7022p7022PurchPriceVisible
31	490526343	Unit Cost	19	Unit Cost	true	p7022p7022UnitPriceEditable	p7022p7022PurchPriceVisible
32	239419956	Line Discount %	20	Line Discount %	true	p7022p7022LineDiscountEditable	p7022p7022DiscountVisible
33	1431195318	Starting Date	12	Starting Date	true	p7022p7022DateEditable	true
34	333179951	Ending Date	13	Ending Date	true	p7022p7022DateEditable	true
35	625932598	Allow Line Disc.	21	Allow Line Disc.	true	p7022p7022PriceLineEditable	p7022p7022PriceVisible
36	1460626151	Allow Invoice Disc.	22	Allow Invoice Disc.	true	p7022p7022PriceLineEditable	p7022p7022PriceVisible
37	854756028	VAT Bus. Posting Gr. (Price)	24	VAT Bus. Posting Gr. (Price)	true	p7022p7022PriceLineEditable	false
38	2134423485	Price Includes VAT	23	Price Includes VAT	true	p7022p7022PriceLineEditable	false

Dynamics 365 BC Table Reference Pages PPrice Worksheet

Show/hide columns in the Price Worksheet page

Leave a Reply Cancel reply