Sales Order Subform – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages SSales Order Subform

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

Page Name: Sales Order Subform
Page Number: 46
Page Type: ListPart

Source Table Name: Sales Line
Source Table Number: 37

Show/hide columns in the Sales Order Subform page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	364865599	Type	5	Type	true	True	true
	Available options are: ” “ “G/L Account” “Item” “Resource” “Fixed Asset” “Charge (Item)” “Allocation Account”
1	814941532	FilteredTypeField			true	p46p46CurrPageIsEditable	p46p46IsFoundation
2	972859360	No.	6	No.	true	True	true
3	1509956458	Item Reference No.	5725	Item Reference No.	true	True	p46p46ItemReferenceVisible
4	811192294	ShpfyOrderNo	30101	Shpfy Order No.	true	False	false
5	218648126	IC Partner Code	130	IC Partner Code	true	True	false
6	660806716	IC Partner Ref. Type	107	IC Partner Ref. Type	true	True	false
	Available options are: ” “ “G/L Account” “Item” “Charge (Item)” “Cross Reference” “Common Item No.” “Vendor Item No.”
7	1374169752	IC Partner Reference	108	IC Partner Reference	true	True	false
8	433955213	IC Item Reference	138	IC Item Reference No.	true	True	false
9	513552739	Variant Code	5402	Variant Code	true	True	false
10	1494376759	Substitution Available	5702	Substitution Available	true	False	false
11	964659180	Purchasing Code	5711	Purchasing Code	true	True	false
12	1269250440	Nonstock	5710	Nonstock	true	False	false
13	151226040	Gen. Bus. Posting Group	74	Gen. Bus. Posting Group	true	True	false
14	308518541	Gen. Prod. Posting Group	75	Gen. Prod. Posting Group	true	True	false
15	1736039647	VAT Bus. Posting Group	89	VAT Bus. Posting Group	true	True	false
16	1756271716	VAT Prod. Posting Group	90	VAT Prod. Posting Group	true	True	false
17	1514923321	Description	11	Description	true	True	true
18	1228097067	Description 2	12	Description 2	true	True	false
19	494767290	Drop Shipment	73	Drop Shipment	true	True	false
20	1060732736	Special Order	5713	Special Order	true	False	false
21	1561537212	Return Reason Code	6608	Return Reason Code	true	True	false
22	1951575695	Location Code	7	Location Code	not p46p46IsBlankNumber	not p46p46IsBlankNumber	p46p46LocationCodeVisible
23	2038997161	Bin Code	5403	Bin Code	true	True	false
24	992669115	Control50	96	Reserve	true	True	false
	Available options are: “Never” “Optional” “Always”
25	1979040212	Quantity	15	Quantity	not p46p46IsCommentLine	not p46p46IsCommentLine	true
26	1357293007	Qty. to Assemble to Order	900	Qty. to Assemble to Order	true	True	true
27	919741688	Reserved Quantity	95	Reserved Quantity	true	False	true
28	761795115	Unit of Measure Code	5407	Unit of Measure Code	p46p46UnitofMeasureCodeIsChangeable	p46p46UnitofMeasureCodeIsChangeable	true
29	864122584	Unit of Measure	13	Unit of Measure	true	True	false
30	1569145101	Unit Cost (LCY)	23	Unit Cost (LCY)	true	True	false
31	1002471391	SalesPriceExist			true	False	false
32	1873835716	Unit Price	22	Unit Price	not p46p46IsBlankNumber	not p46p46IsBlankNumber	true
33	932306691	Tax Liable	86	Tax Liable	true	false	false
34	1187591048	Tax Area Code	85	Tax Area Code	true	True	true
35	2047332632	Tax Group Code	87	Tax Group Code	not p46p46IsCommentLine	not p46p46IsCommentLine	true
36	1019255337	Line Discount %	27	Line Discount %	not p46p46IsBlankNumber	not p46p46IsBlankNumber	true
37	2087727043	Line Amount	103	Line Amount	not p46p46IsBlankNumber	not p46p46IsBlankNumber	true
38	1321235993	Allocation Account No.	2675	Selected Alloc. Account No.	true	True	p46p46UseAllocationAccountNumber
39	1095997092	SalesLineDiscExists			true	False	false
40	1687244552	Line Discount Amount	28	Line Discount Amount	true	True	false
41	1023612009	Prepayment %	109	Prepayment %	true	True	false
42	891878493	Prepmt. Line Amount	110	Prepmt. Line Amount	true	True	false
43	136446562	Prepmt. Amt. Inv.	111	Prepmt. Amt. Inv.	true	False	false
44	498518796	Allow Invoice Disc.	32	Allow Invoice Disc.	true	True	false
45	759041111	Inv. Discount Amount	69	Inv. Discount Amount	true	False	false
46	311067045	Inv. Disc. Amount to Invoice	105	Inv. Disc. Amount to Invoice	true	False	false
47	1727652852	Qty. to Ship	18	Qty. to Ship	true	True	true
48	1105219175	Quantity Shipped	60	Quantity Shipped	true	False	true
49	1112952297	Qty. to Invoice	17	Qty. to Invoice	true	True	true
50	918034641	Quantity Invoiced	61	Quantity Invoiced	true	False	true
51	1974000293	Prepmt Amt to Deduct	121	Prepmt Amt to Deduct	true	True	false
52	1356649527	Prepmt Amt Deducted	122	Prepmt Amt Deducted	true	False	false
53	39909954	Allow Item Charge Assignment	5800	Allow Item Charge Assignment	true	True	false
54	1618145759	Qty. to Assign	5801	Qty. to Assign	true	False	true
55	1607600699	Item Charge Qty. to Handle	5812	Item Charge Qty. to Handle	true	False	true
56	244577667	Qty. Assigned	5802	Qty. Assigned	true	False	true
57	88769911	Requested Delivery Date	5790	Requested Delivery Date	true	True	false
58	645973372	Promised Delivery Date	5791	Promised Delivery Date	true	True	false
59	1293041027	Planned Delivery Date	5794	Planned Delivery Date	true	True	true
60	1779856857	Planned Shipment Date	5795	Planned Shipment Date	true	True	true
61	180003389	Shipment Date	10	Shipment Date	true	True	true
62	1020243151	Shipping Agent Code	5796	Shipping Agent Code	true	True	false
63	1659552052	Shipping Agent Service Code	5797	Shipping Agent Service Code	true	True	false
64	1226424296	Shipping Time	5792	Shipping Time	true	True	false
65	283552291	Work Type Code	52	Work Type Code	true	True	false
66	1814516112	Whse. Outstanding Qty.	5749	Whse. Outstanding Qty.	true	False	false
67	1000663316	Whse. Outstanding Qty. (Base)	5750	Whse. Outstanding Qty. (Base)	true	False	false
68	347197638	ATO Whse. Outstanding Qty.	902	ATO Whse. Outstanding Qty.	true	False	false
69	1453883903	ATO Whse. Outstd. Qty. (Base)	903	ATO Whse. Outstd. Qty. (Base)	true	False	false
70	216820122	Outbound Whse. Handling Time	5793	Outbound Whse. Handling Time	true	True	false
71	1747524221	Blanket Order No.	97	Blanket Order No.	true	True	false
72	200152739	Blanket Order Line No.	98	Blanket Order Line No.	true	True	false
73	1978665660	FA Posting Date	5600	FA Posting Date	true	True	false
74	1783969763	Depr. until FA Posting Date	5605	Depr. until FA Posting Date	true	True	false
75	14766150	Depreciation Book Code	5602	Depreciation Book Code	true	True	false
76	835866332	Use Duplication List	5613	Use Duplication List	true	True	false
77	847937097	Duplicate in Depreciation Book	5612	Duplicate in Depreciation Book	true	True	false
78	104810130	Appl.-from Item Entry	5811	Appl.-from Item Entry	true	True	false
79	1163489099	Appl.-to Item Entry	38	Appl.-to Item Entry	true	True	false
80	1775267237	Deferral Code	1700	Deferral Code	( Type <> 4 ) AND ( Type <> 0 )	True	false
81	1459709947	Shortcut Dimension 1 Code	40	Shortcut Dimension 1 Code	true	True	p46p46DimVisible1
82	1101229272	Shortcut Dimension 2 Code	41	Shortcut Dimension 2 Code	true	True	p46p46DimVisible2
83	1792312919	ShortcutDimCode3			true	true	p46p46DimVisible3
84	1396170166	ShortcutDimCode4			true	true	p46p46DimVisible4
85	2033866783	ShortcutDimCode5			true	true	p46p46DimVisible5
86	120776932	ShortcutDimCode6			true	true	p46p46DimVisible6
87	758473549	ShortcutDimCode7			true	true	p46p46DimVisible7
88	348010662	ShortcutDimCode8			true	true	p46p46DimVisible8
89	730488641	Document No.	3	Document No.	true	false	false
90	795747754	Line No.	4	Line No.	true	false	false
91	1284510869	Gross Weight	34	Gross Weight	true	True	false
92	981409648	Net Weight	35	Net Weight	true	True	false
93	1862106583	Unit Volume	37	Unit Volume	true	True	false
94	1676379836	Units per Parcel	36	Units per Parcel	true	True	false
95	1938796159	Attached to Line No.	80	Attached to Line No.	true	False	false
96	1600053555	Attached Lines Count	7011	Attached Lines Count	true	False	p46p46AttachingLinesEnabled
97	977814817	TotalSalesLine.Line Amount			true	false	true
98	308617479	Invoice Discount Amount			true	p46p46InvDiscAmountEditable	true
99	44148420	Invoice Disc. Pct.			true	p46p46InvDiscAmountEditable	true
100	1382980858	Total Amount Excl. VAT			true	false	true
101	368455538	Total VAT Amount			true	false	true
102	762172116	Total Amount Incl. VAT			true	false	true

Dynamics 365 BC Table Reference Pages SSales Order Subform

Show/hide columns in the Sales Order Subform page

Leave a Reply Cancel reply