Sales Document Entity – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages SSales Document Entity

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

Page Name: Sales Document Entity
Page Number: 6402
Page Type: List

Source Table Name: Sales Header
Source Table Number: 36

Show/hide columns in the Sales Document Entity page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1754289560	id	2000000000	$systemId	true	False	true
1	947368694	documentType	1	Document Type	true	True	true
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	1896849897	sellToCustomerNumber	2	Sell-to Customer No.	true	True	true
3	1746060222	number	3	No.	true	True	true
4	1276002410	billToCustomerNumber	4	Bill-to Customer No.	true	True	true
5	171572542	billToName	5	Bill-to Name	true	True	true
6	780299152	billToName2	6	Bill-to Name 2	true	True	true
7	718158803	billToAddress	7	Bill-to Address	true	True	true
8	1260271287	billToAddress2	8	Bill-to Address 2	true	True	true
9	976018510	billToCity	9	Bill-to City	true	True	true
10	1138291843	billToContact	10	Bill-to Contact	true	True	true
11	218724863	yourReference	11	Your Reference	true	True	true
12	851376281	shipToCode	12	Ship-to Code	true	True	true
13	1388677821	shipToName	13	Ship-to Name	true	True	true
14	1714158247	shipToName2	14	Ship-to Name 2	true	True	true
15	329613014	shipToAddress	15	Ship-to Address	true	True	true
16	1529584936	shipToAddress2	16	Ship-to Address 2	true	True	true
17	945334029	shipToCity	17	Ship-to City	true	True	true
18	1550066444	shipToContact	18	Ship-to Contact	true	True	true
19	1009116943	orderDate	19	Order Date	true	True	true
20	1307721703	postingDate	20	Posting Date	true	True	true
21	1317243143	shipmentDate	21	Shipment Date	true	True	true
22	1093916605	postingDescription	22	Posting Description	true	True	true
23	2021280423	paymentTermsCode	23	Payment Terms Code	true	True	true
24	789328565	dueDate	24	Due Date	true	True	true
25	1308276543	paymentDiscountPercent	25	Payment Discount %	true	True	true
26	267389621	pmtDiscountDate	26	Pmt. Discount Date	true	True	true
27	1947816823	shipmentMethodCode	27	Shipment Method Code	true	True	true
28	1644406445	locationCode	28	Location Code	true	True	true
29	1704488905	shortcutDimension1Code	29	Shortcut Dimension 1 Code	true	True	true
30	381940130	shortcutDimension2Code	30	Shortcut Dimension 2 Code	true	True	true
31	1571008398	customerPostingGroup	31	Customer Posting Group	true	True	true
32	634809025	currencyCode	32	Currency Code	true	True	true
33	423605287	currencyFactor	33	Currency Factor	true	False	true
34	243646283	customerPriceGroup	34	Customer Price Group	true	True	true
35	2032358143	pricesIncludingVat	35	Prices Including VAT	true	True	true
36	1432722212	invoiceDiscCode	37	Invoice Disc. Code	true	True	true
37	1082266659	customerDiscGroup	40	Customer Disc. Group	true	True	true
38	259984906	languageCode	41	Language Code	true	True	true
39	199251811	salespersonCode	43	Salesperson Code	true	True	true
40	1834242693	orderClass	45	Order Class	true	True	true
41	1708671194	comment	46	Comment	true	False	true
42	1182222874	numberPrinted	47	No. Printed	true	False	true
43	1362622563	onHold	51	On Hold	true	True	true
44	99092428	appliesToDocType	52	Applies-to Doc. Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
45	1235581297	appliesToDocNumber	53	Applies-to Doc. No.	true	True	true
46	1262610816	balAccountNumber	55	Bal. Account No.	true	True	true
47	264231446	recalculateInvoiceDisc	56	Recalculate Invoice Disc.	true	False	true
48	1174856345	ship	57	Ship	true	False	true
49	1346544788	invoice	58	Invoice	true	True	true
50	1918987847	printPostedDocuments	59	Print Posted Documents	true	True	true
51	706582345	amount	60	Amount	true	False	true
52	1653974189	amountIncludingVAT	61	Amount Including VAT	true	False	true
53	200225116	shippingNumber	62	Shipping No.	true	True	true
54	380732026	postingNumber	63	Posting No.	true	True	true
55	1396862462	lastShippingNumber	64	Last Shipping No.	true	False	true
56	455635276	lastPostingNumber	65	Last Posting No.	true	False	true
57	1896761411	prepaymentNumber	66	Prepayment No.	true	True	true
58	2111024161	lastPrepaymentNumber	67	Last Prepayment No.	true	True	true
59	1166614669	premptCrMemoNumber	68	Prepmt. Cr. Memo No.	true	True	true
60	1192922537	lastPremtCrMemoNumber	69	Last Prepmt. Cr. Memo No.	true	True	true
61	938220444	vatRegistrationNumber	70	VAT Registration No.	true	True	true
62	884484689	combineShipments	71	Combine Shipments	true	True	true
63	578453036	reasonCode	73	Reason Code	true	True	true
64	1629128450	genBusPostingGroup	74	Gen. Bus. Posting Group	true	True	true
65	533119522	eu3PartyTrade	75	EU 3-Party Trade	true	True	true
66	1067063617	transactionType	76	Transaction Type	true	True	true
67	1066801761	transportMethod	77	Transport Method	true	True	true
68	2079421691	vatCountryRegionCode	78	VAT Country/Region Code	true	True	true
69	65683925	sellToCustomerName	79	Sell-to Customer Name	true	True	true
70	206249407	sellToCustomerName2	80	Sell-to Customer Name 2	true	True	true
71	506736550	sellToAddress	81	Sell-to Address	true	True	true
72	1724118092	sellToAddress2	82	Sell-to Address 2	true	True	true
73	1928942929	sellToCity	83	Sell-to City	true	True	true
74	1746487768	sellToContact	84	Sell-to Contact	true	True	true
75	639708648	billToPostCode	85	Bill-to Post Code	true	True	true
76	677020593	billToCounty	86	Bill-to County	true	True	true
77	1167575048	billToCountryRegionCode	87	Bill-to Country/Region Code	true	True	true
78	1583394021	sellToPostCode	88	Sell-to Post Code	true	True	true
79	424239630	sellToCounty	89	Sell-to County	true	True	true
80	983925405	sellToCountryRegionCode	90	Sell-to Country/Region Code	true	True	true
81	496634249	shipToPostCode	91	Ship-to Post Code	true	True	true
82	160072178	shipToCounty	92	Ship-to County	true	True	true
83	1180303729	shipToCountryRegionCode	93	Ship-to Country/Region Code	true	True	true
84	2088871229	balAccountType	94	Bal. Account Type	true	True	true
	Available options are: “G/L Account” “Bank Account”
85	2003009513	exitPoint	97	Exit Point	true	True	true
86	1727502939	correction	98	Correction	true	True	true
87	587216762	documentDate	99	Document Date	true	True	true
88	1993357916	externalDocumentNumber	100	External Document No.	true	True	true
89	738900294	area	101	Area	true	True	true
90	756442572	transactionSpecification	102	Transaction Specification	true	True	true
91	1061431533	paymentMethodCode	104	Payment Method Code	true	True	true
92	450911307	shippingAgentCode	105	Shipping Agent Code	true	True	true
93	1078427443	packageTrackingNumber	106	Package Tracking No.	true	True	true
94	1708757917	numberSeries	107	No. Series	true	False	true
95	1542563925	postingNumberSeries	108	Posting No. Series	true	True	true
96	281656481	shippingNumberSeries	109	Shipping No. Series	true	True	true
97	424271170	taxAreaCode	114	Tax Area Code	true	True	true
98	1403184785	taxLiable	115	Tax Liable	true	True	true
99	957434173	vatBusPostingGroup	116	VAT Bus. Posting Group	true	True	true
100	1167053539	reserve	117	Reserve	true	True	true
	Available options are: “Never” “Optional” “Always”
101	1630631527	appliesToId	118	Applies-to ID	true	True	true
102	1968820515	vatBaseDiscountPercent	119	VAT Base Discount %	true	True	true
103	1290662647	status	120	Status	true	False	true
	Available options are: “Open” “Released” “Pending Approval” “Pending Prepayment”
104	254857024	invoiceDiscountCalculation	121	Invoice Discount Calculation	true	False	true
	Available options are: “None” “%” “Amount”
105	7145174	invoiceDiscountValue	122	Invoice Discount Value	true	False	true
106	1260337028	sendIcDocument	123	Send IC Document	true	True	true
107	2025028939	icStatus	124	IC Status	true	True	true
	Available options are: “New” “Pending” “Sent”
108	1650746441	sellToIcPartnerCode	125	Sell-to IC Partner Code	true	False	true
109	366403844	billToIcPartnerCode	126	Bill-to IC Partner Code	true	False	true
110	541900806	icDirection	129	IC Direction	true	True	true
	Available options are: “Outgoing” “Incoming”
111	138610805	prepaymentPercent	130	Prepayment %	true	True	true
112	678775776	prepaymentNumberSeries	131	Prepayment No. Series	true	True	true
113	1736297654	compressPrepayment	132	Compress Prepayment	true	True	true
114	1822662320	prepaymentDueDate	133	Prepayment Due Date	true	True	true
115	748850216	prepmtCrMemoNumberSeries	134	Prepmt. Cr. Memo No. Series	true	True	true
116	670803437	prepmtPostingDescription	135	Prepmt. Posting Description	true	True	true
117	1344649307	prepmtPmtDiscountDate	138	Prepmt. Pmt. Discount Date	true	True	true
118	1863426071	prepmtPaymentTermsCode	139	Prepmt. Payment Terms Code	true	True	true
119	1731638417	prepmtPaymentDiscountPercent	140	Prepmt. Payment Discount %	true	True	true
120	810094500	quoteNumber	151	Quote No.	true	False	true
121	1707474095	quoteValidUntilDate	152	Quote Valid Until Date	true	True	true
122	154841956	quoteSentToCustomer	153	Quote Sent to Customer	true	False	true
123	778081422	quoteAccepted	154	Quote Accepted	true	True	true
124	870216310	quoteAcceptedDate	155	Quote Accepted Date	true	False	true
125	1914526945	jobQueueStatus	160	Job Queue Status	true	False	true
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
126	771407582	jobQueueEntryId	161	Job Queue Entry ID	true	False	true
127	1472922461	incomingDocumentEntryNumber	165	Incoming Document Entry No.	true	True	true
128	1499487854	workDescription	200	Work Description	true	True	true
129	405891305	amountShippedNotInvoicedInclVat	300	Amt. Ship. Not Inv. (LCY)	true	False	true
130	1671722558	amountShippedNotInvoiced	301	Amt. Ship. Not Inv. (LCY) Base	true	False	true
131	596467006	dimensionSetId	480	Dimension Set ID	true	False	true
132	1039346637	paymentServiceSetId	600	Payment Service Set ID	true	True	true
133	294497371	directDebitMandateId	1200	Direct Debit Mandate ID	true	True	true
134	1649031501	invoiceDiscountAmount	1305	Invoice Discount Amount	true	False	true
135	1720180248	numberOfArchivedVersions	5043	No. of Archived Versions	true	False	true
136	303491639	docNumberOccurrence	5048	Doc. No. Occurrence	true	True	true
137	1732978304	campaignNumber	5050	Campaign No.	true	True	true
138	1361759213	sellToContactNumber	5052	Sell-to Contact No.	true	True	true
139	1173210298	billToContactNumber	5053	Bill-to Contact No.	true	True	true
140	436484305	opportunityNumber	5055	Opportunity No.	true	True	true
141	1775296338	responsibilityCenter	5700	Responsibility Center	true	True	true
142	2134739451	shippingAdvice	5750	Shipping Advice	true	True	true
	Available options are: “Partial” “Complete”
143	1036151218	shippedNotInvoiced	5751	Shipped Not Invoiced	true	False	true
144	329672654	completelyShipped	5752	Completely Shipped	true	False	true
145	1128594675	postingFromWhseRef	5753	Posting from Whse. Ref.	true	True	true
146	287154952	locationFilter	5754	Location Filter	true	True	true
147	1031509074	shipped	5755	Shipped	true	False	true
148	2084733269	requestedDeliveryDate	5790	Requested Delivery Date	true	True	true
149	1805465610	promisedDeliveryDate	5791	Promised Delivery Date	true	True	true
150	1029601710	shippingTime	5792	Shipping Time	true	True	true
151	2107982634	outboundWhseHandlingTime	5793	Outbound Whse. Handling Time	true	True	true
152	1479533746	shippingAgentServiceCode	5794	Shipping Agent Service Code	true	True	true
153	525949509	lateOrderShipping	5795	Late Order Shipping	true	False	true
154	900936002	receive	5800	Receive	true	True	true
155	282113056	returnReceiptNumber	5801	Return Receipt No.	true	True	true
156	261984979	returnReceiptNumberSeries	5802	Return Receipt No. Series	true	True	true
157	1957625746	lastReturnReceiptNumber	5803	Last Return Receipt No.	true	False	true
158	364268169	allowLineDisc	7001	Allow Line Disc.	true	True	true
159	135672028	getShipmentUsed	7200	Get Shipment Used	true	False	true
160	379526015	assignedUserId	9000	Assigned User ID	true	True	true

Dynamics 365 BC Table Reference Pages SSales Document Entity

Show/hide columns in the Sales Document Entity page

Leave a Reply Cancel reply