Table 10002 "Document Header" (MX)

MX country layer · Microsoft.eServices.EDocument · BC29-30 · source at ea08af5e · facts from BC29

An object of the MX localization, not part of W1.

Properties

Property	Value
Caption	Document Header
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
2	Sell-to/Buy-from No.	Code[20]	—
3	No.	Code[20]	—
4	Bill-to/Pay-To No.	Code[20]	—
5	Bill-to/Pay-To Name	Text[100]	—
6	Bill-to/Pay-To Name 2	Text[50]	—
7	Bill-to/Pay-To Address	Text[100]	—
8	Bill-to/Pay-To Address 2	Text[50]	—
9	Bill-to/Pay-To City	Text[30]	—
10	Bill-to/Pay-To Contact	Text[100]	—
17	Ship-to/Buy-from City	Text[30]	—
19	Order Date	Date	—
20	Posting Date	Date	—
23	Payment Terms Code	Code[10]	—
28	Location Code	Code[10]	—
32	Currency Code	Code[10]	—
33	Currency Factor	Decimal	—
60	Amount	Decimal	—
61	Amount Including VAT	Decimal	—
79	Sell-to/Buy-From Name	Text[100]	—
80	Sell-to/Buy-From Name 2	Text[50]	—
81	Sell-to/Buy-From Address	Text[100]	—
82	Sell-to/Buy-From Address 2	Text[50]	—
83	Sell-to/Buy-From City	Text[30]	—
84	Sell-to/Buy-From Contct	Text[100]	—
85	Bill-to/Pay-To Post Code	Code[20]	—
86	Bill-to/Pay-To County	Text[30]	—
87	Bill-to/Pay-To Country Code	Code[10]	—
88	Sell-to/Buy-from Post Code	Code[20]	—
89	Sell-to/Buy-from County	Text[30]	—
90	Sell-to/Buy-from Country Code	Code[10]	—
91	Ship-to/Buy-from Post Code	Code[20]	—
92	Ship-to/Buy-from County	Text[30]	—
93	Ship-to/Buy-from Country Code	Code[10]	—
99	Document Date	Date	—
104	Payment Method Code	Code[10]	—
10039	Identifier IdCCP	Text[50]	—	not editable
10044	Transport Operators	Integer	—	FlowField: count(“CFDI Transport Operator” where(“Document Table ID” = field(“Document Table ID”), “Document No.” = field(“No.”)))
10045	Transit-from Date/Time	DateTime	—
10046	Transit Hours	Integer	—
10047	Transit Distance	Decimal	—
10048	Insurer Name	Text[50]	—
10049	Insurer Policy Number	Text[30]	—
10050	Foreign Trade	Boolean	—
10051	Vehicle Code	Code[20]	—	TableRelation Fixed Asset
10052	Trailer 1	Code[20]	—	TableRelation “Fixed Asset” where(“SAT Trailer Type” = filter(<> ‘’))
10053	Trailer 2	Code[20]	—	TableRelation “Fixed Asset” where(“SAT Trailer Type” = filter(<> ‘’))
10054	Transit-from Location	Code[10]	—	TableRelation Location where(“Use As In-Transit” = const(false))
10055	Transit-to Location	Code[10]	—	TableRelation Location where(“Use As In-Transit” = const(false))
10056	Medical Insurer Name	Text[50]	—
10057	Medical Ins. Policy Number	Text[30]	—
10058	SAT Weight Unit Of Measure	Code[10]	—
10059	SAT International Trade Term	Code[10]	—	TableRelation SAT International Trade Term
10060	Exchange Rate USD	Decimal	—
10061	SAT Customs Regime	Code[10]	—	TableRelation SAT Customs Regime
10062	SAT Transfer Reason	Code[10]	—	TableRelation SAT Transfer Reason
27000	CFDI Purpose	Code[10]	—	TableRelation SAT Use Code
27001	CFDI Relation	Code[10]	—	TableRelation SAT Relationship Type
27004	CFDI Export Code	Code[10]	—	TableRelation CFDI Export Code
27005	CFDI Period	Option	—	OptionCaption: Diario,Semanal,Quincenal,Mensual
27009	SAT Address ID	Integer	—
27010	Document Table ID	Integer	—
27012	CFDI Certificate of Origin No.	Text[50]	—

Keys

Key1: No. (clustered)

Triggers

OnInsert

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: "Document Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A MX country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.