Table 40902 "Hist. Sales Trx. Header"

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	No.	Code[35]	Specifies the value of the No. field. via Page 41007 “Hist. Sales Trx.”	NotBlank
3	Sales Trx. Type	enum “Hist. Sales Trx. Type”	Specifies the value of the Sales Type field. via Page 41007 “Hist. Sales Trx.”	enum Enum 40900 “Hist. Sales Trx. Type”; NotBlank
4	Sales Trx. Status	enum “Hist. Sales Trx. Status”	Specifies the value of the Sales Trx. Status field. via Page 41007 “Hist. Sales Trx.”	enum Enum 40901 “Hist. Sales Trx. Status”; NotBlank
5	Currency Code	Code[10]	Specifies the value of the Currency Code field. via Page 41007 “Hist. Sales Trx.”	NotBlank
6	Sub Total	Decimal	Specifies the value of the Sub Total field. via Page 41007 “Hist. Sales Trx.”
7	Tax Amount	Decimal	Specifies the value of the Ext. Price field. via Page 41007 “Hist. Sales Trx.”
8	Trade Disc. Amount	Decimal	Specifies the value of the Trade Discount Amount field. via Page 41007 “Hist. Sales Trx.”
9	Freight Amount	Decimal	Specifies the value of the Freight Amount field. via Page 41007 “Hist. Sales Trx.”
10	Misc. Amount	Decimal	Specifies the value of the Miscellaneous Amount field. via Page 41007 “Hist. Sales Trx.”
11	Payment Recv. Amount	Decimal	Specifies the value of the Payment Received Amount field. via Page 41007 “Hist. Sales Trx.”
12	Disc. Taken Amount	Decimal	Specifies the value of the Discount Taken Amount field. via Page 41007 “Hist. Sales Trx.”
13	Total	Decimal	Specifies the value of the Total field. via Page 41007 “Hist. Sales Trx.”
14	Document Date	Date	Specifies the value of the Document Date field. via Page 41007 “Hist. Sales Trx.”	NotBlank
15	Due Date	Date	Specifies the value of the Due Date field. via Page 41007 “Hist. Sales Trx.”
16	Actual Ship Date	Date	Specifies the value of the Actual Ship Date field. via Page 41007 “Hist. Sales Trx.”
17	Customer No.	Text[35]	Specifies the value of the Customer No. field. via Page 41007 “Hist. Sales Trx.”
18	Customer Name	Text[100]	Specifies the value of the Customer Name field. via Page 41007 “Hist. Sales Trx.”
19	Ship-to Code	Code[35]	Specifies the value of the Ship-to Code field. via Page 41007 “Hist. Sales Trx.”
20	Ship-to Name	Text[100]	Specifies the value of the Ship-to Name field. via Page 41007 “Hist. Sales Trx.”
21	Ship-to Address	Text[100]	Specifies the value of the Ship-to Address field. via Page 41007 “Hist. Sales Trx.”
22	Ship-to Address 2	Text[50]	Specifies the value of the Ship-to Address 2 field. via Page 41007 “Hist. Sales Trx.”
23	Ship-to City	Text[50]	Specifies the value of the Ship-to City field. via Page 41007 “Hist. Sales Trx.”
24	Ship-to State	Text[50]	Specifies the value of the Ship-to State field. via Page 41007 “Hist. Sales Trx.”
25	Ship-to Zipcode	Text[20]	Specifies the value of the Ship-to Zipcode field. via Page 41007 “Hist. Sales Trx.”
26	Ship-to Country	Text[50]	Specifies the value of the Ship-to Country field. via Page 41007 “Hist. Sales Trx.”
27	Contact Person Name	Text[100]	Specifies the value of the Contact Person Name field. via Page 41007 “Hist. Sales Trx.”
28	Salesperson No.	Code[35]	Specifies the value of the Salesperson No. field. via Page 41007 “Hist. Sales Trx.”
29	Sales Territory	Text[50]	Specifies the value of the Sales Territory field. via Page 41007 “Hist. Sales Trx.”
30	Customer Purchase No.	Code[35]	Specifies the value of the Customer Purchase No. field. via Page 41007 “Hist. Sales Trx.”
31	Original No.	Code[35]	Specifies the value of the Original No. field. via Page 41007 “Hist. Sales Trx.”
32	Ship Method	Text[50]	Specifies the value of the Ship Method field. via Page 41007 “Hist. Sales Trx.”
33	Audit Code	Code[35]	Specifies the value of the Audit Code field. via Page 41007 “Hist. Sales Trx.”

Keys

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

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 40903 “Hist. Sales Trx. Line”: Sales Header No.

Pages and codeunits on this table

Page 41002 “Hist. Sales Trx. Headers” (source table)
Page 41007 “Hist. Sales Trx.” (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. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.