Sales Invoice – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages SSales Invoice

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

Page Name: Sales Invoice
Page Number: 43
Page Type: Document

Source Table Name: Sales Header
Source Table Number: 36

Show/hide columns in the Sales Invoice page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1827849883	No.	3	No.	true	True	p43p43DocNoVisible
1	989948567	Sell-to Customer No.	2	Sell-to Customer No.	true	True	true
2	1858586927	Sell-to Customer Name	79	Sell-to Customer Name	true	True	true
3	805088801	VAT Registration No.	70	VAT Registration No.	true	false	false
4	650104500	Posting Description	22	Posting Description	true	True	false
5	1896960108	Sell-to Address	81	Sell-to Address	true	True	true
6	1037457230	Sell-to Address 2	82	Sell-to Address 2	true	True	true
7	712938171	Sell-to City	83	Sell-to City	true	True	true
8	755489960	Sell-to County	89	Sell-to County	true	True	true
9	1766492271	Sell-to Post Code	88	Sell-to Post Code	true	True	true
10	1064464184	Sell-to Country/Region Code	90	Sell-to Country/Region Code	true	True	true
11	1082328483	Sell-to Contact No.	5052	Sell-to Contact No.	true	True	true
12	1204525770	SellToPhoneNo			true	false	true
13	872955554	SellToMobilePhoneNo			true	false	true
14	2066910307	SellToEmail			true	false	true
15	93919506	Sell-to Contact	84	Sell-to Contact	true	Sell-to Customer No. <> ‘	true
16	1006619424	Your Reference	11	Your Reference	true	True	true
17	1965685186	ShpfyOrderNo	30101	Shpfy Order No.	true	False	false
18	203782847	Document Date	99	Document Date	true	True	true
19	851165298	Posting Date	20	Posting Date	true	True	true
20	1907028069	VAT Reporting Date	179	VAT Reporting Date	true	p43p43VATDateEnabled	p43p43VATDateEnabled
21	2067489906	Due Date	24	Due Date	true	True	true
22	544898328	Incoming Document Entry No.	165	Incoming Document Entry No.	true	True	false
23	1895141809	External Document No.	100	External Document No.	true	True	true
24	1756774030	Salesperson Code	43	Salesperson Code	true	True	true
25	675165541	Campaign No.	5050	Campaign No.	true	True	true
26	2029896637	Responsibility Center	5700	Responsibility Center	true	True	true
27	1569847946	Assigned User ID	9000	Assigned User ID	true	True	true
28	1953804854	Status	120	Status	true	False	true
	Available options are: “Open” “Released” “Pending Approval” “Pending Prepayment”
29	1434607480	Job Queue Status	160	Job Queue Status	true	False	p43p43JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
30	3108805	WorkDescription			true	true	true
31	1096172008	Currency Code	32	Currency Code	true	True	true
32	837650793	Company Bank Account Code	163	Company Bank Account Code	true	True	true
33	467319542	Shipment Date	21	Shipment Date	true	True	true
34	1559901991	Quote No.	151	Quote No.	true	False	true
35	140418186	Prices Including VAT	35	Prices Including VAT	true	True	true
36	210236412	VAT Bus. Posting Group	116	VAT Bus. Posting Group	true	True	true
37	914661793	Customer Posting Group	31	Customer Posting Group	true	p43p43IsPostingGroupEditable	true
38	1691060368	Payment Terms Code	23	Payment Terms Code	true	True	true
39	1650052674	Payment Method Code	104	Payment Method Code	true	True	p43p43IsPaymentMethodCodeVisible
40	1841284125	Reason Code	73	Reason Code	true	True	false
41	1080535908	EU 3-Party Trade	75	EU 3-Party Trade	true	True	true
42	1399706254	SelectedPayments			p43p43PaymentServiceEnabled	False	true
43	1564806754	Shortcut Dimension 1 Code	29	Shortcut Dimension 1 Code	true	True	true
44	926728829	Shortcut Dimension 2 Code	30	Shortcut Dimension 2 Code	true	True	true
45	1657843544	Payment Discount %	25	Payment Discount %	true	True	true
46	1998329308	Pmt. Discount Date	26	Pmt. Discount Date	true	True	true
47	1760329534	Journal Templ. Name	178	Journal Templ. Name	true	True	p43p43IsJournalTemplNameVisible
48	1056334270	Direct Debit Mandate ID	1200	Direct Debit Mandate ID	true	True	true
49	1895114	Location Code	28	Location Code	true	True	true
50	178472960	ShippingOptions			true	true	true
	Available options are: “Default (Sell-to Address)” “Alternate Shipping Address” “Custom Address”
51	446494045	Ship-to Code	12	Ship-to Code	true	p43p43ShipToOptions = 1	true
52	460452231	Ship-to Name	13	Ship-to Name	true	p43p43ShipToOptions = 2	true
53	1125111408	Ship-to Address	15	Ship-to Address	true	p43p43ShipToOptions = 2	true
54	608729422	Ship-to Address 2	16	Ship-to Address 2	true	p43p43ShipToOptions = 2	true
55	240087831	Ship-to City	17	Ship-to City	true	p43p43ShipToOptions = 2	true
56	1644280340	Ship-to County	92	Ship-to County	true	p43p43ShipToOptions = 2	true
57	1642870067	Ship-to Post Code	91	Ship-to Post Code	true	p43p43ShipToOptions = 2	true
58	1248573116	Ship-to Country/Region Code	93	Ship-to Country/Region Code	true	p43p43ShipToOptions = 2	true
59	563731774	Ship-to Contact	18	Ship-to Contact	true	True	true
60	564080640	Shipment Method Code	27	Shipment Method Code	true	True	true
61	370429180	Shipping Agent Code	105	Shipping Agent Code	true	True	true
62	529847321	Shipping Agent Service Code	5794	Shipping Agent Service Code	true	True	true
63	301482928	Package Tracking No.	106	Package Tracking No.	true	True	true
64	956585154	BillToOptions			true	true	true
	Available options are: “Default (Customer)” “Another Customer” “Custom Address”
65	1493103976	Bill-to Name	5	Bill-to Name	p43p43BillToOptions = 1	p43p43BillToOptions = 1	true
66	1945300999	Bill-to Address	7	Bill-to Address	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
67	2039241963	Bill-to Address 2	8	Bill-to Address 2	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
68	1810913832	Bill-to City	9	Bill-to City	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
69	2065853259	Bill-to County	86	Bill-to County	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
70	1064303686	Bill-to Post Code	85	Bill-to Post Code	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
71	1980974589	Bill-to Country/Region Code	87	Bill-to Country/Region Code	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
72	1876269224	Bill-to Contact No.	5053	Bill-to Contact No.	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
73	332709529	Bill-to Contact	10	Bill-to Contact	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	( p43p43BillToOptions = 2 ) or ( Bill-to Customer	true
74	1950542769	BillToContactPhoneNo			true	false	true
75	1885923897	BillToContactMobilePhoneNo			true	false	true
76	764508886	BillToContactEmail			true	false	true
77	1311664525	Transaction Specification	102	Transaction Specification	true	True	true
78	386047238	Transaction Type	76	Transaction Type	true	True	true
79	1632886050	Transport Method	77	Transport Method	true	True	true
80	1412699742	Exit Point	97	Exit Point	true	True	true
81	847323243	Area	101	Area	true	True	true
82	1857669323	Language Code	41	Language Code	true	True	false
83	26896009	Format Region	42	Format Region	true	True	false

Dynamics 365 BC Table Reference Pages SSales Invoice

Show/hide columns in the Sales Invoice page

Leave a Reply Cancel reply