GPPOPReceiptLineHist #4062

Other table in Microsoft Dynamics 365 Business Central. 72 fields, 0 records in Cronus demo.

72
Fields
0
Records
2
Primary key
0
FlowFields
2
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: POP Receipt Number, Receipt Line Number.

All fields (72)

GPPOPReceiptLineHist — FIELDS
NO.FIELDTYPECLASSRELATION
1 POP Receipt Number PK Text Normal
2 Receipt Line Number PK Integer Normal
3 PO Number Text Normal
4 Item Number Text Normal
5 Item Description Text Normal
6 Vendor Item Number Text Normal
7 Vendor Item Description Text Normal
8 U Of M QTY In Base Decimal Normal
9 Actual Ship Date Date Normal
10 Comment ID Text Normal
11 Inventory Index Integer Normal
12 U Of M Text Normal
13 Unit Cost Decimal Normal
14 Extended Cost Decimal Normal
15 Location Code Text Normal
16 ReceiptLine Note ID Array 1 Decimal Normal
17 ReceiptLine Note ID Array 2 Decimal Normal
18 ReceiptLine Note ID Array 3 Decimal Normal
19 ReceiptLine Note ID Array 4 Decimal Normal
20 ReceiptLine Note ID Array 5 Decimal Normal
21 ReceiptLine Note ID Array 6 Decimal Normal
22 ReceiptLine Note ID Array 7 Decimal Normal
23 ReceiptLine Note ID Array 8 Decimal Normal
24 Non-Inventory Item Option Normal
25 Decimal Places Currency Option Normal
26 Decimal Places QTYS Option Normal
27 Item Tracking Option Option Normal
28 TRX Source Text Normal
29 Job Number Text Normal
30 Cost Code Text Normal
31 Cost Code Type Integer Normal
32 Currency Index Integer Normal
33 Originating Unit Cost Decimal Normal
34 Originating Extended Cost Decimal Normal
35 Originating Decimal Places Currency Option Normal
36 BOL_PRO Number Text Normal
37 Capital Item Boolean Normal
38 Product Indicator Integer Normal
39 Purchase IV Item Taxable Option Normal
40 Purchase Item Tax Schedule ID Text Normal
41 Purchase Site Tax Schedule ID Text Normal
42 Based On Invoice Total Boolean Normal
43 Tax Amount Decimal Normal
44 Originating Tax Amount Decimal Normal
45 Backout Tax Amount Decimal Normal
46 Originating Backout Tax Amount Decimal Normal
47 Purchase Price Variance Index Integer Normal
48 Shipping Method Text Normal
49 Landed Cost Group ID Text Normal
50 Landed Cost Warnings Integer Normal
51 Landed Cost Boolean Normal
52 Invoice Match Boolean Normal
53 Receipt Return Number Text Normal
54 Receipt Return Line Number Integer Normal
55 Invoice Return Number Text Normal
56 Invoice Return Line Number Integer Normal
57 IsLineIntrastat Boolean Normal
58 Project Number Text Normal
59 Cost Category ID Text Normal
60 TrackedDropShipped Boolean Normal
61 Originating Prepayment Amount Decimal Normal
62 Originating Discount Taken Amount Decimal Normal
63 Originating Trade Discount Amount Decimal Normal
64 Originating Freight Amount Decimal Normal
65 Originating Misc Amount Decimal Normal
66 Originating Prepayment Tax Amount Decimal Normal
67 DEX_ROW_ID Integer Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal