Purchase Document Line Entity – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages PPurchase Document Line Entity

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

Page Name: Purchase Document Line Entity
Page Number: 6405
Page Type: ListPart

Source Table Name: Purchase Line
Source Table Number: 39

Show/hide columns in the Purchase Document Line Entity page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	362797339	documentType	1	Document Type	true	True	true
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
1	1089489963	buyFromVendorNumber	2	Buy-from Vendor No.	true	False	true
2	1091055910	documentNumber	3	Document No.	true	True	true
3	839073569	lineNumber	4	Line No.	true	True	true
4	627503950	type	5	Type	true	True	true
	Available options are: ” “ “G/L Account” “Item” “Resource” “Fixed Asset” “Charge (Item)” “Allocation Account”
5	138846879	number	6	No.	true	True	true
6	1607648158	locationCode	7	Location Code	true	True	true
7	271141493	postingGroup	8	Posting Group	true	False	true
8	153503148	expectedReceiptDate	10	Expected Receipt Date	true	True	true
9	1843458716	description	11	Description	true	True	true
10	28936866	description2	12	Description 2	true	True	true
11	33405035	unitOfMeasure	13	Unit of Measure	true	True	true
12	434987175	quantity	15	Quantity	true	True	true
13	375983187	outstandingQuantity	16	Outstanding Quantity	true	False	true
14	2002807692	qtyToInvoice	17	Qty. to Invoice	true	True	true
15	1133766302	qtyToReceive	18	Qty. to Receive	true	True	true
16	1990779502	directUnitCost	22	Direct Unit Cost	true	True	true
17	1182356281	unitCostLcy	23	Unit Cost (LCY)	true	True	true
18	1899598098	vatPercent	25	VAT %	true	False	true
19	687835498	lineDiscountPercent	27	Line Discount %	true	True	true
20	1868740019	lineDiscountAmount	28	Line Discount Amount	true	True	true
21	1918490682	amount	29	Amount	true	False	true
22	494511828	amountIncludingVat	30	Amount Including VAT	true	False	true
23	1463659911	unitPriceLcy	31	Unit Price (LCY)	true	True	true
24	432517135	allowInvoiceDisc	32	Allow Invoice Disc.	true	True	true
25	397140680	grossWeight	34	Gross Weight	true	True	true
26	332551499	netWeight	35	Net Weight	true	True	true
27	1651333201	unitsPerParcel	36	Units per Parcel	true	True	true
28	547810660	unitVolume	37	Unit Volume	true	True	true
29	1450390939	applToItemEntry	38	Appl.-to Item Entry	true	True	true
30	310948074	shortcutDimension1Code	40	Shortcut Dimension 1 Code	true	True	true
31	1261270717	shortcutDimension2Code	41	Shortcut Dimension 2 Code	true	True	true
32	948160826	jobNumber	45	Job No.	true	True	true
33	547733352	indirectCostPercent	54	Indirect Cost %	true	True	true
34	1954932043	recalculateInvoiceDisc	56	Recalculate Invoice Disc.	true	False	true
35	926786460	outstandingAmount	57	Outstanding Amount	true	False	true
36	729118357	qtyRcdNotInvoiced	58	Qty. Rcd. Not Invoiced	true	False	true
37	1612863625	amtRcdNotInvoiced	59	Amt. Rcd. Not Invoiced	true	False	true
38	1001473542	quantityReceived	60	Quantity Received	true	False	true
39	549556892	quantityInvoiced	61	Quantity Invoiced	true	False	true
40	797624307	receiptNumber	63	Receipt No.	true	False	true
41	20418419	receiptLineNumber	64	Receipt Line No.	true	False	true
42	600642065	profitPercent	67	Profit %	true	False	true
43	967731922	payToVendorNumber	68	Pay-to Vendor No.	true	False	true
44	1594687766	invDiscountAmount	69	Inv. Discount Amount	true	False	true
45	1003724304	vendorItemNumber	70	Vendor Item No.	true	True	true
46	739386017	salesOrderNumber	71	Sales Order No.	true	False	true
47	538207423	salesOrderLineNumber	72	Sales Order Line No.	true	False	true
48	2021082917	dropShipment	73	Drop Shipment	true	False	true
49	1829543885	genBusPostingGroup	74	Gen. Bus. Posting Group	true	True	true
50	372106312	genProdPostingGroup	75	Gen. Prod. Posting Group	true	True	true
51	645056640	vatCalculationType	77	VAT Calculation Type	true	False	true
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
52	824990390	transactionType	78	Transaction Type	true	True	true
53	902617798	transportMethod	79	Transport Method	true	True	true
54	738188878	attachedToLineNumber	80	Attached to Line No.	true	False	true
55	1581620710	entryPoint	81	Entry Point	true	True	true
56	1559149493	area	82	Area	true	True	true
57	1778794595	transactionSpecification	83	Transaction Specification	true	True	true
58	1527914997	taxAreaCode	85	Tax Area Code	true	True	true
59	56612808	taxLiable	86	Tax Liable	true	True	true
60	1992892339	taxGroupCode	87	Tax Group Code	true	True	true
61	1949159892	useTax	88	Use Tax	true	True	true
62	562319730	vatBusPostingGroup	89	VAT Bus. Posting Group	true	True	true
63	434444545	vatProdPostingGroup	90	VAT Prod. Posting Group	true	True	true
64	1422617216	currencyCode	91	Currency Code	true	False	true
65	204624354	outstandingAmountLcy	92	Outstanding Amount (LCY)	true	False	true
66	1076565073	amtRcdNotInvoicedLcy	93	Amt. Rcd. Not Invoiced (LCY)	true	False	true
67	589106829	reservedQuantity	95	Reserved Quantity	true	False	true
68	2118283556	blanketOrderNumber	97	Blanket Order No.	true	True	true
69	309049078	blanketOrderLineNumber	98	Blanket Order Line No.	true	True	true
70	786967280	vatBaseAmount	99	VAT Base Amount	true	False	true
71	633214367	unitCost	100	Unit Cost	true	False	true
72	684250693	systemCreatedEntry	101	System-Created Entry	true	False	true
73	520086104	lineAmount	103	Line Amount	true	True	true
74	1318058862	vatDifference	104	VAT Difference	true	False	true
75	1034270832	invDiscAmountToInvoice	105	Inv. Disc. Amount to Invoice	true	False	true
76	1298327962	vatIdentifier	106	VAT Identifier	true	False	true
77	538527633	icPartnerRefType	107	IC Partner Ref. Type	true	True	true
	Available options are: ” “ “G/L Account” “Item” “Charge (Item)” “Cross Reference” “Common Item No.” “Vendor Item No.”
78	929459595	icPartnerReference	108	IC Partner Reference	true	True	true
79	1270884036	prepaymentPercent	109	Prepayment %	true	True	true
80	1875808858	prepmtLineAmount	110	Prepmt. Line Amount	true	True	true
81	283262701	prepmtAmtInv	111	Prepmt. Amt. Inv.	true	False	true
82	921743871	prepmtAmtInclVat	112	Prepmt. Amt. Incl. VAT	true	False	true
83	690611253	prepaymentAmount	113	Prepayment Amount	true	False	true
84	1676294094	prepmtVatBaseAmt	114	Prepmt. VAT Base Amt.	true	False	true
85	572897457	prepaymentVatPercent	115	Prepayment VAT %	true	False	true
86	1178276958	prepmtVatCalcType	116	Prepmt. VAT Calc. Type	true	False	true
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
87	490550799	prepaymentVatIdentifier	117	Prepayment VAT Identifier	true	False	true
88	935579024	prepaymentTaxAreaCode	118	Prepayment Tax Area Code	true	True	true
89	1997024701	prepaymentTaxLiable	119	Prepayment Tax Liable	true	True	true
90	1978772640	prepaymentTaxGroupCode	120	Prepayment Tax Group Code	true	True	true
91	357756800	prepmtAmtToDeduct	121	Prepmt Amt to Deduct	true	True	true
92	24676222	prepmtAmtDeducted	122	Prepmt Amt Deducted	true	False	true
93	237574999	prepaymentLine	123	Prepayment Line	true	False	true
94	621357666	prepmtAmountInvInclVat	124	Prepmt. Amount Inv. Incl. VAT	true	False	true
95	864022649	prepmtAmountInvLcy	129	Prepmt. Amount Inv. (LCY)	true	False	true
96	1137335237	icPartnerCode	130	IC Partner Code	true	True	true
97	1772552276	prepmtVatAmountInvLcy	132	Prepmt. VAT Amount Inv. (LCY)	true	False	true
98	252492949	prepaymentVatDifference	135	Prepayment VAT Difference	true	False	true
99	657564154	prepmtVatDiffToDeduct	136	Prepmt VAT Diff. to Deduct	true	False	true
100	2081453084	prepmtVatDiffDeducted	137	Prepmt VAT Diff. Deducted	true	False	true
101	1520124328	outstandingAmtExVatLcy	140	Outstanding Amt. Ex. VAT (LCY)	true	True	true
102	77078002	aRcdNotInvExVatLcy	141	A. Rcd. Not Inv. Ex. VAT (LCY)	true	True	true
103	1507840317	dimensionSetId	480	Dimension Set ID	true	False	true
104	2366437	jobTaskNumber	1001	Job Task No.	true	True	true
105	1109328219	jobLineType	1002	Job Line Type	true	True	true
	Available options are: ” “ “Budget” “Billable” “Both Budget and Billable”
106	205131582	jobUnitPrice	1003	Job Unit Price	true	True	true
107	4687342	jobTotalPrice	1004	Job Total Price	true	False	true
108	925926209	jobLineAmount	1005	Job Line Amount	true	True	true
109	2144622886	jobLineDiscountAmount	1006	Job Line Discount Amount	true	True	true
110	1696561227	jobLineDiscountPercent	1007	Job Line Discount %	true	True	true
111	931472112	jobUnitPriceLcy	1008	Job Unit Price (LCY)	true	False	true
112	207232556	jobTotalPriceLcy	1009	Job Total Price (LCY)	true	False	true
113	535472295	jobLineAmountLcy	1010	Job Line Amount (LCY)	true	False	true
114	347740724	jobLineDiscAmountLcy	1011	Job Line Disc. Amount (LCY)	true	False	true
115	1872265217	jobCurrencyFactor	1012	Job Currency Factor	true	True	true
116	388876041	jobCurrencyCode	1013	Job Currency Code	true	True	true
117	93411019	jobPlanningLineNumber	1019	Job Planning Line No.	true	True	true
118	1129118595	jobRemainingQty	1030	Job Remaining Qty.	true	True	true
119	214640392	jobRemainingQtyBase	1031	Job Remaining Qty. (Base)	true	True	true
120	1985138328	deferralCode	1700	Deferral Code	true	True	true
121	300748000	returnsDeferralStartDate	1702	Returns Deferral Start Date	true	True	true
122	113135302	prodOrderNumber	5401	Prod. Order No.	true	False	true
123	1601118184	variantCode	5402	Variant Code	true	True	true
124	2135732766	binCode	5403	Bin Code	true	True	true
125	889255770	qtyPerUnitOfMeasure	5404	Qty. per Unit of Measure	true	False	true
126	884512920	unitOfMeasureCode	5407	Unit of Measure Code	true	True	true
127	1382501540	quantityBase	5415	Quantity (Base)	true	True	true
128	1107821015	outstandingQtyBase	5416	Outstanding Qty. (Base)	true	False	true
129	219502545	qtyToInvoiceBase	5417	Qty. to Invoice (Base)	true	True	true
130	1420905637	qtyToReceiveBase	5418	Qty. to Receive (Base)	true	True	true
131	1234707534	qtyRcdNotInvoicedBase	5458	Qty. Rcd. Not Invoiced (Base)	true	False	true
132	1963866908	qtyReceivedBase	5460	Qty. Received (Base)	true	False	true
133	138718426	qtyInvoicedBase	5461	Qty. Invoiced (Base)	true	False	true
134	2128683799	reservedQtyBase	5495	Reserved Qty. (Base)	true	False	true
135	1828976745	faPostingDate	5600	FA Posting Date	true	True	true
136	1174520235	faPostingType	5601	FA Posting Type	true	True	true
	Available options are: ” “ “Acquisition Cost” “Maintenance” “Appreciation”
137	1643425009	depreciationBookCode	5602	Depreciation Book Code	true	True	true
138	762645410	salvageValue	5603	Salvage Value	true	True	true
139	93855664	deprUntilFaPostingDate	5605	Depr. until FA Posting Date	true	True	true
140	752385995	deprAcquisitionCost	5606	Depr. Acquisition Cost	true	True	true
141	47601374	maintenanceCode	5609	Maintenance Code	true	True	true
142	463760253	insuranceNumber	5610	Insurance No.	true	True	true
143	60478554	budgetedFaNumber	5611	Budgeted FA No.	true	True	true
144	297564938	duplicateInDepreciationBook	5612	Duplicate in Depreciation Book	true	True	true
145	1502972985	useDuplicationList	5613	Use Duplication List	true	True	true
146	1273894285	responsibilityCenter	5700	Responsibility Center	true	False	true
147	1003129303	itemReferenceNumber	5725	Item Reference No.	true	True	true
148	1021041153	itemRefUnitOfMeasure	5726	Item Reference Unit of Measure	true	True	true
149	298320516	itemReferenceType	5727	Item Reference Type	true	True	true
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
150	1719050225	itemReferenceTypeNumber	5728	Item Reference Type No.	true	True	true
151	1108308534	itemCategoryCode	5709	Item Category Code	true	True	true
152	80275477	nonstock	5710	Nonstock	true	True	true
153	583073519	purchasingCode	5711	Purchasing Code	true	False	true
154	1582105955	specialOrder	5713	Special Order	true	True	true
155	1608792934	specialOrderSalesNumber	5714	Special Order Sales No.	true	True	true
156	156647304	specialOrderSalesLineNumber	5715	Special Order Sales Line No.	true	True	true
157	1677514952	whseOutstandingQtyBase	5750	Whse. Outstanding Qty. (Base)	true	False	true
158	243146311	completelyReceived	5752	Completely Received	true	False	true
159	636079666	requestedReceiptDate	5790	Requested Receipt Date	true	True	true
160	1746002561	promisedReceiptDate	5791	Promised Receipt Date	true	True	true
161	1095637690	leadTimeCalculation	5792	Lead Time Calculation	true	True	true
162	1541077300	inboundWhseHandlingTime	5793	Inbound Whse. Handling Time	true	True	true
163	1843879082	plannedReceiptDate	5794	Planned Receipt Date	true	True	true
164	222399704	orderDate	5795	Order Date	true	True	true
165	1525318249	allowItemChargeAssignment	5800	Allow Item Charge Assignment	true	True	true
166	949333044	qtyToAssign	5801	Qty. to Assign	true	False	true
167	537228458	qtyAssigned	5802	Qty. Assigned	true	False	true
168	571230099	returnQtyToShip	5803	Return Qty. to Ship	true	True	true
169	573268680	returnQtyToShipBase	5804	Return Qty. to Ship (Base)	true	True	true
170	1534313657	returnQtyShippedNotInvd	5805	Return Qty. Shipped Not Invd.	true	False	true
171	621850071	retQtyShpdNotInvdBase	5806	Ret. Qty. Shpd Not Invd.(Base)	true	False	true
172	2111901831	returnShpdNotInvd	5807	Return Shpd. Not Invd.	true	False	true
173	2131022977	returnShpdNotInvdLcy	5808	Return Shpd. Not Invd. (LCY)	true	False	true
174	579587631	returnQtyShipped	5809	Return Qty. Shipped	true	False	true
175	321096394	returnQtyShippedBase	5810	Return Qty. Shipped (Base)	true	False	true
176	1349022755	returnShipmentNumber	6600	Return Shipment No.	true	False	true
177	1213706915	returnShipmentLineNumber	6601	Return Shipment Line No.	true	False	true
178	1334759577	returnReasonCode	6608	Return Reason Code	true	True	true
179	1587255454	subtype	6609	Subtype	true	True	true
	Available options are: ” “ “Item – Inventory” “Item – Service” “Comment”
180	1766804197	routingNumber	99000750	Routing No.	true	True	true
181	654985788	operationNumber	99000751	Operation No.	true	False	true
182	1698939011	workCenterNumber	99000752	Work Center No.	true	False	true
183	453473128	finished	99000753	Finished	true	True	true
184	34626472	prodOrderLineNumber	99000754	Prod. Order Line No.	true	False	true
185	1230333018	overheadRate	99000755	Overhead Rate	true	True	true
186	568391298	mpsOrder	99000756	MPS Order	true	True	true
187	214557430	planningFlexibility	99000757	Planning Flexibility	true	True	true
	Available options are: “Unlimited” “None”
188	689047775	safetyLeadTime	99000758	Safety Lead Time	true	True	true
189	1058966842	routingReferenceNumber	99000759	Routing Reference No.	true	True	true

Dynamics 365 BC Table Reference Pages PPurchase Document Line Entity

Show/hide columns in the Purchase Document Line Entity page

Leave a Reply Cancel reply