Table 46882 "BC14 Arch. Sales Inv. Header"

HybridBC14HistoricalData · Microsoft.DataMigration.BC14Reimplementation.HistoricalData · captioned “BC14 Archived Sales Invoice Header” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	BC14 Archived Sales Invoice Header
DataClassification	CustomerContent
LookupPageId	BC14 Arch. Sales Inv. List
DrillDownPageId	BC14 Arch. Sales Inv. List

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	No.	Code[20]	Specifies the document number. via Page 46884 “BC14 Arch. Sales Inv. Card”
2	Sell-to Customer No.	Code[20]	Specifies the sell-to customer number. via Page 46884 “BC14 Arch. Sales Inv. Card”
3	Sell-to Customer Name	Text[100]	Specifies the sell-to customer name. via Page 46884 “BC14 Arch. Sales Inv. Card”
4	Bill-to Customer No.	Code[20]	Specifies the bill-to customer number. via Page 46884 “BC14 Arch. Sales Inv. Card”
5	Bill-to Name	Text[100]	Specifies the bill-to name. via Page 46884 “BC14 Arch. Sales Inv. Card”
6	Bill-to Address	Text[100]	Specifies the bill-to address. via Page 46884 “BC14 Arch. Sales Inv. Card”
7	Bill-to City	Text[30]	Specifies the bill-to city. via Page 46884 “BC14 Arch. Sales Inv. Card”
8	Bill-to Post Code	Code[20]	Specifies the bill-to post code. via Page 46884 “BC14 Arch. Sales Inv. Card”
9	Bill-to Country/Region Code	Code[10]	—
10	Posting Date	Date	Specifies the posting date. via Page 46884 “BC14 Arch. Sales Inv. Card”
11	Document Date	Date	Specifies the document date. via Page 46884 “BC14 Arch. Sales Inv. Card”
12	Due Date	Date	Specifies the due date. via Page 46884 “BC14 Arch. Sales Inv. Card”
13	External Document No.	Code[35]	Specifies the external document number. via Page 46884 “BC14 Arch. Sales Inv. Card”
14	Your Reference	Text[35]	—
20	Currency Code	Code[10]	Specifies the currency code. via Page 46883 “BC14 Arch. Sales Inv. List”
21	Currency Factor	Decimal	—
30	Salesperson Code	Code[20]	—
31	Shortcut Dimension 1 Code	Code[20]	—
32	Shortcut Dimension 2 Code	Code[20]	—
40	Payment Terms Code	Code[10]	—
41	Payment Method Code	Code[10]	—
50	Ship-to Name	Text[100]	Specifies the ship-to name. via Page 46884 “BC14 Arch. Sales Inv. Card”
51	Ship-to Address	Text[100]	Specifies the ship-to address. via Page 46884 “BC14 Arch. Sales Inv. Card”
52	Ship-to City	Text[30]	Specifies the ship-to city. via Page 46884 “BC14 Arch. Sales Inv. Card”
53	Ship-to Post Code	Code[20]	Specifies the ship-to post code. via Page 46884 “BC14 Arch. Sales Inv. Card”
54	Ship-to Country/Region Code	Code[10]	—
60	Amount	Decimal	Specifies the total amount. via Page 46884 “BC14 Arch. Sales Inv. Card”
61	Amount Including VAT	Decimal	Specifies the total amount including VAT. via Page 46884 “BC14 Arch. Sales Inv. Card”
70	Order No.	Code[20]	—
71	Pre-Assigned No.	Code[20]	—
80	User ID	Code[50]	—	DataClassification EndUserPseudonymousIdentifiers
81	Source Code	Code[10]	—
90	Remaining Amount	Decimal	Specifies the remaining amount. via Page 46884 “BC14 Arch. Sales Inv. Card”
91	Closed	Boolean	Specifies if the invoice is closed. via Page 46884 “BC14 Arch. Sales Inv. Card”
100	Migrated On	DateTime	Specifies when the invoice was migrated from BC14. via Page 46884 “BC14 Arch. Sales Inv. Card”

Keys

PK: No. (clustered)
Customer: Sell-to Customer No., Posting Date
PostingDate: Posting Date

Relations

drill-down page Page 46883 “BC14 Arch. Sales Inv. List”
lookup page Page 46883 “BC14 Arch. Sales Inv. List”

Pages and codeunits on this table

Page 46883 “BC14 Arch. Sales Inv. List” (source table)
Page 46884 “BC14 Arch. Sales Inv. Card” (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: "BC14 Arch. Sales Inv. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.