Purchase Document Entity – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages PPurchase Document Entity

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

Page Name: Purchase Document Entity
Page Number: 6404
Page Type: List

Source Table Name: Purchase Header
Source Table Number: 38

Show/hide columns in the Purchase Document Entity page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	175590062	id	2000000000	$systemId	true	False	true
1	255831708	documentType	1	Document Type	true	True	true
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	395516628	buyFromVendorNumber	2	Buy-from Vendor No.	true	True	true
3	843963784	number	3	No.	true	True	true
4	60904735	payToVendorNumber	4	Pay-to Vendor No.	true	True	true
5	1049173393	payToName	5	Pay-to Name	true	True	true
6	1805833691	payToName2	6	Pay-to Name 2	true	True	true
7	1187986666	payToAddress	7	Pay-to Address	true	True	true
8	273101252	payToAddress2	8	Pay-to Address 2	true	True	true
9	292095359	payToCity	9	Pay-to City	true	True	true
10	502408712	payToContact	10	Pay-to Contact	true	True	true
11	1384832025	yourReference	11	Your Reference	true	True	true
12	797431791	shipToCode	12	Ship-to Code	true	True	true
13	500163915	shipToName	13	Ship-to Name	true	True	true
14	244500641	shipToName2	14	Ship-to Name 2	true	True	true
15	176954028	shipToAddress	15	Ship-to Address	true	True	true
16	1050528050	shipToAddress2	16	Ship-to Address 2	true	True	true
17	1022507525	shipToCity	17	Ship-to City	true	True	true
18	826590802	shipToContact	18	Ship-to Contact	true	True	true
19	1646333385	orderDate	19	Order Date	true	True	true
20	1235277407	postingDate	20	Posting Date	true	True	true
21	1844352331	expectedReceiptDate	21	Expected Receipt Date	true	True	true
22	1314360747	postingDescription	22	Posting Description	true	True	true
23	756036529	paymentTermsCode	23	Payment Terms Code	true	True	true
24	615093005	dueDate	24	Due Date	true	True	true
25	1184823511	paymentDiscountPercent	25	Payment Discount %	true	True	true
26	1459668627	pmtDiscountDate	26	Pmt. Discount Date	true	True	true
27	964686817	shipmentMethodCode	27	Shipment Method Code	true	True	true
28	2041475931	locationCode	28	Location Code	true	True	true
29	1229570785	shortcutDimension1Code	29	Shortcut Dimension 1 Code	true	True	true
30	888322580	shortcutDimension2Code	30	Shortcut Dimension 2 Code	true	True	true
31	1439542080	vendorPostingGroup	31	Vendor Posting Group	true	True	true
32	1904111849	currencyCode	32	Currency Code	true	True	true
33	1293006863	currencyFactor	33	Currency Factor	true	False	true
34	661455785	pricesIncludingVat	35	Prices Including VAT	true	True	true
35	1525411358	invoiceDiscCode	37	Invoice Disc. Code	true	True	true
36	493946148	languageCode	41	Language Code	true	True	true
37	1882288231	purchaserCode	43	Purchaser Code	true	True	true
38	1045887091	orderClass	45	Order Class	true	True	true
39	29610848	comment	46	Comment	true	False	true
40	1178000928	numberPrinted	47	No. Printed	true	False	true
41	888925515	onHold	51	On Hold	true	True	true
42	1149397338	appliesToDocType	52	Applies-to Doc. Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
43	293766535	appliesToDocNumber	53	Applies-to Doc. No.	true	True	true
44	1531451882	balAccountNumber	55	Bal. Account No.	true	True	true
45	1094306244	recalculateInvoiceDisc	56	Recalculate Invoice Disc.	true	False	true
46	2094929560	receive	57	Receive	true	True	true
47	577494098	invoice	58	Invoice	true	True	true
48	250190799	printPostedDocuments	59	Print Posted Documents	true	True	true
49	1770134943	amount	60	Amount	true	False	true
50	1243933029	amountIncludingVat	61	Amount Including VAT	true	False	true
51	1527665602	receivingNumber	62	Receiving No.	true	True	true
52	1955197344	postingNumber	63	Posting No.	true	True	true
53	1241134252	lastReceivingNumber	64	Last Receiving No.	true	False	true
54	1123965458	lastPostingNumber	65	Last Posting No.	true	False	true
55	235319926	vendorOrderNumber	66	Vendor Order No.	true	True	true
56	1673063708	vendorShipmentNumber	67	Vendor Shipment No.	true	True	true
57	719988219	vendorInvoiceNumber	68	Vendor Invoice No.	true	True	true
58	1132027455	vendorCrMemoNumber	69	Vendor Cr. Memo No.	true	True	true
59	7280482	vatRegistrationNumber	70	VAT Registration No.	true	True	true
60	1413487905	sellToCustomerNumber	72	Sell-to Customer No.	true	True	true
61	592886458	reasonCode	73	Reason Code	true	True	true
62	1755115700	genBusPostingGroup	74	Gen. Bus. Posting Group	true	True	true
63	658528967	transactionType	76	Transaction Type	true	True	true
64	302111303	transportMethod	77	Transport Method	true	True	true
65	644535987	vatCountryRegionCode	78	VAT Country/Region Code	true	True	true
66	1746290344	buyFromVendorName	79	Buy-from Vendor Name	true	True	true
67	1208198870	buyFromVendorName2	80	Buy-from Vendor Name 2	true	True	true
68	283050395	buyFromAddress	81	Buy-from Address	true	True	true
69	1268004945	buyFromAddress2	82	Buy-from Address 2	true	True	true
70	848304372	buyFromCity	83	Buy-from City	true	True	true
71	1091199563	buyFromContact	84	Buy-from Contact	true	True	true
72	1044750549	payToPostCode	85	Pay-to Post Code	true	True	true
73	176505506	payToCounty	86	Pay-to County	true	True	true
74	1542451405	payToCountryRegionCode	87	Pay-to Country/Region Code	true	True	true
75	1991585890	buyFromPostCode	88	Buy-from Post Code	true	True	true
76	294139543	buyFromCounty	89	Buy-from County	true	True	true
77	486582482	buyFromCountryRegionCode	90	Buy-from Country/Region Code	true	True	true
78	1659994623	shipToPostCode	91	Ship-to Post Code	true	True	true
79	1137329896	shipToCounty	92	Ship-to County	true	True	true
80	357342487	shipToCountryRegionCode	93	Ship-to Country/Region Code	true	True	true
81	969533685	balAccountType	94	Bal. Account Type	true	True	true
	Available options are: “G/L Account” “Bank Account”
82	59896810	orderAddressCode	95	Order Address Code	true	True	true
83	1543002029	entryPoint	97	Entry Point	true	True	true
84	988364627	correction	98	Correction	true	True	true
85	1049172080	documentDate	99	Document Date	true	True	true
86	769513612	area	101	Area	true	True	true
87	652717658	transactionSpecification	102	Transaction Specification	true	True	true
88	873523979	paymentMethodCode	104	Payment Method Code	true	True	true
89	146104533	numberSeries	107	No. Series	true	False	true
90	1392138323	postingNumberSeries	108	Posting No. Series	true	True	true
91	943461405	receivingNumberSeries	109	Receiving No. Series	true	True	true
92	74838692	taxAreaCode	114	Tax Area Code	true	True	true
93	1023537431	taxLiable	115	Tax Liable	true	True	true
94	1003414805	vatBusPostingGroup	116	VAT Bus. Posting Group	true	True	true
95	494536993	appliesToId	118	Applies-to ID	true	True	true
96	97365	vatBaseDiscountPercent	119	VAT Base Discount %	true	True	true
97	1641341055	status	120	Status	true	False	true
	Available options are: “Open” “Released” “Pending Approval” “Pending Prepayment”
98	1287000170	invoiceDiscountCalculation	121	Invoice Discount Calculation	true	False	true
	Available options are: “None” “%” “Amount”
99	1731660612	invoiceDiscountValue	122	Invoice Discount Value	true	False	true
100	441511310	sendIcDocument	123	Send IC Document	true	True	true
101	1381114493	icStatus	124	IC Status	true	True	true
	Available options are: “New” “Pending” “Sent”
102	1200500394	buyFromIcPartnerCode	125	Buy-from IC Partner Code	true	False	true
103	845537753	payToIcPartnerCode	126	Pay-to IC Partner Code	true	False	true
104	1473357124	icDirection	129	IC Direction	true	True	true
	Available options are: “Outgoing” “Incoming”
105	163787403	prepaymentNumber	130	Prepayment No.	true	True	true
106	998580599	lastPrepaymentNumber	131	Last Prepayment No.	true	True	true
107	1505161165	prepmtCrMemoNumber	132	Prepmt. Cr. Memo No.	true	True	true
108	73917551	lastPrepmtCrMemoNumber	133	Last Prepmt. Cr. Memo No.	true	True	true
109	290261613	prepaymentPercent	134	Prepayment %	true	True	true
110	1388302806	prepaymentNumberSeries	135	Prepayment No. Series	true	True	true
111	1599668736	compressPrepayment	136	Compress Prepayment	true	True	true
112	631806634	prepaymentDueDate	137	Prepayment Due Date	true	True	true
113	479606274	prepmtCrMemoNumberSeries	138	Prepmt. Cr. Memo No. Series	true	True	true
114	1932094885	prepmtPostingDescription	139	Prepmt. Posting Description	true	True	true
115	255870659	prepmtPmtDiscountDate	142	Prepmt. Pmt. Discount Date	true	True	true
116	1023699233	prepmtPaymentTermsCode	143	Prepmt. Payment Terms Code	true	True	true
117	941715879	prepmtPaymentDiscountPercent	144	Prepmt. Payment Discount %	true	True	true
118	1313341602	quoteNumber	151	Quote No.	true	False	true
119	484643241	jobQueueStatus	160	Job Queue Status	true	False	true
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
120	2109483612	jobQueueEntryId	161	Job Queue Entry ID	true	False	true
121	1170952219	incomingDocumentEntryNumber	165	Incoming Document Entry No.	true	True	true
122	169910808	creditorNumber	170	Creditor No.	true	True	true
123	69825002	paymentReference	171	Payment Reference	true	True	true
124	48439435	aRcdNotInvExVatLcy	300	A. Rcd. Not Inv. Ex. VAT (LCY)	true	True	true
125	255477768	amtRcdNotInvoicedLcy	301	Amt. Rcd. Not Invoiced (LCY)	true	True	true
126	812486004	dimensionSetId	480	Dimension Set ID	true	False	true
127	569993355	invoiceDiscountAmount	1305	Invoice Discount Amount	true	False	true
128	1780703838	numberOfArchivedVersions	5043	No. of Archived Versions	true	False	true
129	1684733775	docNumberOccurrence	5048	Doc. No. Occurrence	true	True	true
130	2046463158	campaignNumber	5050	Campaign No.	true	True	true
131	2029504880	buyFromContactNumber	5052	Buy-from Contact No.	true	True	true
132	633650717	payToContactNumber	5053	Pay-to Contact No.	true	True	true
133	2046003004	responsibilityCenter	5700	Responsibility Center	true	True	true
134	301993264	completelyReceived	5752	Completely Received	true	False	true
135	1730013605	postingFromWhseRef	5753	Posting from Whse. Ref.	true	True	true
136	1217424734	locationFilter	5754	Location Filter	true	True	true
137	402932613	requestedReceiptDate	5790	Requested Receipt Date	true	True	true
138	1956528000	promisedReceiptDate	5791	Promised Receipt Date	true	True	true
139	1156849355	leadTimeCalculation	5792	Lead Time Calculation	true	True	true
140	337558381	inboundWhseHandlingTime	5793	Inbound Whse. Handling Time	true	True	true
141	361341457	vendorAuthorizationNumber	5800	Vendor Authorization No.	true	True	true
142	500839770	returnShipmentNumber	5801	Return Shipment No.	true	True	true
143	1115954617	returnShipmentNumberSeries	5802	Return Shipment No. Series	true	True	true
144	1722896015	ship	5803	Ship	true	True	true
145	515720568	lastReturnShipmentNumber	5804	Last Return Shipment No.	true	False	true
146	372398505	assignedUserId	9000	Assigned User ID	true	True	true
147	1639619728	pendingApprovals	9001	Pending Approvals	true	True	true

Dynamics 365 BC Table Reference Pages PPurchase Document Entity

Show/hide columns in the Purchase Document Entity page

Leave a Reply Cancel reply