Table 40903 "Hist. Sales 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	Sales Trx. Type	enum “Hist. Sales Trx. Type”	Sales Type caption	enum Enum 40900 “Hist. Sales Trx. Type”; NotBlank
3	Sales Header No.	Code[35]	—	TableRelation Table 40902 “Hist. Sales Trx. Header” (“Hist. Sales Trx. Header”.“No.”); NotBlank
4	Line Item Sequence No.	Integer	—	NotBlank
5	Component Sequence	Integer	—	NotBlank
6	Item No.	Code[35]	Specifies the value of the Item No. field. via Page 41003 “Hist. Sales Trx. Lines”
7	Item Description	Text[100]	Specifies the value of the Item Description field. via Page 41003 “Hist. Sales Trx. Lines”
8	Unit of Measure	Code[35]	Specifies the value of the Unit of Measure field. via Page 41003 “Hist. Sales Trx. Lines”
9	Unit Cost	Decimal	Specifies the value of the Unit Cost field. via Page 41003 “Hist. Sales Trx. Lines”
10	Unit Price	Decimal	Specifies the value of the Unit Price field. via Page 41003 “Hist. Sales Trx. Lines”
11	Quantity	Decimal	Specifies the value of the Quantity field. via Page 41003 “Hist. Sales Trx. Lines”
12	Ext. Cost	Decimal	Specifies the value of the Ext. Cost field. via Page 41003 “Hist. Sales Trx. Lines”
13	Ext. Price	Decimal	Specifies the value of the Ext. Price field. via Page 41003 “Hist. Sales Trx. Lines”
14	Tax Amount	Decimal	Specifies the value of the Tax Amount field. via Page 41003 “Hist. Sales Trx. Lines”
15	Location Code	Code[35]	Specifies the value of the Location Code field. via Page 41003 “Hist. Sales Trx. Lines”
16	Ship-to Name	Text[65]	Specifies the value of the Ship-to Name field. via Page 41003 “Hist. Sales Trx. Lines”

Keys

PK: Primary Key (clustered)
Key2: Sales Trx. Type, Sales Header No.

Relations

Sales Header No.: TableRelation Table 40902 “Hist. Sales Trx. Header”

Pages and codeunits on this table

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