Table 40907 "Hist. Inventory Trx. Line"

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	Audit Code	Code[35]	—	NotBlank
3	Document Type	enum “Hist. Inventory Doc. Type”	—	enum Enum 40905 “Hist. Inventory Doc. Type”; NotBlank
4	Document No.	Code[35]	—	NotBlank
5	Line Item Sequence	Integer	—	NotBlank
6	Date	Date	—
7	Source Description	Text[50]	Specifies the value of the Source Description field. via Page 41011 “Hist. Inventory Trx. Lines”
8	Customer No.	Code[35]	Specifies the value of the Customer No. field. via Page 41011 “Hist. Inventory Trx. Lines”
9	Item No.	Code[35]	Specifies the value of the Item No. field. via Page 41011 “Hist. Inventory Trx. Lines”
10	Unit of Measure	Code[35]	Specifies the value of the Unit of Measure field. via Page 41011 “Hist. Inventory Trx. Lines”
11	Quantity	Decimal	Specifies the value of the Quantity field. via Page 41011 “Hist. Inventory Trx. Lines”
12	Unit Cost	Decimal	Specifies the value of the Unit Cost field. via Page 41011 “Hist. Inventory Trx. Lines”
13	Ext. Cost	Decimal	Specifies the value of the Ext. Cost field. via Page 41011 “Hist. Inventory Trx. Lines”
14	Location Code	Code[35]	Specifies the value of the Location Code field. via Page 41011 “Hist. Inventory Trx. Lines”
15	Transfer To Location Code	Code[35]	Specifies the value of the Transfer To Location Code field. via Page 41011 “Hist. Inventory Trx. Lines”
16	Reason Code	Code[40]	Specifies the value of the Reason Code field. via Page 41011 “Hist. Inventory Trx. Lines”

Keys

PK: Primary Key (clustered)
Key2: Document Type, Document No.

Pages and codeunits on this table

Page 41011 “Hist. Inventory Trx. 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. Inventory Trx. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.