Table 40909 "Hist. Purchase Recv. Line"
DynamicsGPHistoricalData · Microsoft.DataMigration.GP.HistoricalData
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 1 connected objects and pages
DynamicsGPHistoricalData · Microsoft.DataMigration.GP.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key | Integer | — | AutoIncrement |
| 2 | Receipt No. | Code[35] | — | NotBlank |
| 3 | Line No. | Integer | — | NotBlank |
| 4 | PO Number | Code[35] | Specifies the value of the PO Number field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 5 | Item No. | Code[35] | Specifies the value of the Item No. field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 6 | Item Desc. | Text[100] | Specifies the value of the Item Desc. field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 7 | Vendor Item No. | Text[50] | Specifies the value of the Vendor Item No. field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 8 | Vendor Item Desc. | Text[100] | Specifies the value of the Vendor Item Desc. field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 9 | Base UofM Qty. | Decimal | Specifies the value of the Base UofM Qty. field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 10 | Actual Ship Date | Date | Specifies the value of the Actual Ship Date field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 11 | Unit of Measure | Code[35] | Specifies the value of the Unit of Measure field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 12 | Unit Cost | Decimal | Specifies the value of the Unit Cost field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 13 | Ext. Cost | Decimal | Specifies the value of the Ext. Cost field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 14 | Tax Amount | Decimal | Specifies the value of the Tax Amount field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 15 | Location Code | Code[35] | Specifies the value of the Location Code field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 16 | Audit Code | Code[35] | Specifies the value of the Audit Code field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 17 | Ship Method | Text[50] | Specifies the value of the Ship Method field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 18 | Orig. Unit Cost | Decimal | Specifies the value of the Orig. Unit Cost field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 19 | Orig. Ext. Cost | Decimal | Specifies the value of the Orig. Ext. Cost field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 20 | Orig. Disc. Taken Amount | Decimal | Specifies the value of the Orig. Disc. Taken Amount field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 21 | Orig. Trade Disc. Amount | Decimal | Specifies the value of the Orig. Trade Disc. Amount field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 22 | Orig. Freight Amount | Decimal | Specifies the value of the Orig. Freight Amount field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 23 | Orig. Misc. Amount | Decimal | Specifies the value of the Orig. Misc. Amount field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 24 | Quantity Shipped | Decimal | Specifies the value of the Quantity Shipped field. via Page 41015 “Hist. Purchase Recv. Lines” | |
| 25 | Quantity Invoiced | Decimal | Specifies the value of the Quantity Invoiced field. via Page 41015 “Hist. Purchase Recv. Lines” |
Keys
- PK: Primary Key (clustered)
- key2: Receipt No.
Pages and codeunits on this table
- Page 41015 “Hist. Purchase Recv. Lines” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Hist. Purchase Recv. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.