Table 46880 "BC14 Posted Sales Inv Header"

HybridBC14 · Microsoft.DataMigration.BC14Reimplementation · captioned “Posted Sales Invoice Header Migration Data” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Posted Sales Invoice Header Migration Data
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	No.	Code[20]	—
2	Sell-to Customer No.	Code[20]	—
3	Sell-to Customer Name	Text[100]	—
4	Bill-to Customer No.	Code[20]	—
5	Bill-to Name	Text[100]	—	DataClassification EndUserIdentifiableInformation
6	Bill-to Address	Text[100]	—	DataClassification EndUserIdentifiableInformation
7	Bill-to City	Text[30]	—
8	Bill-to Post Code	Code[20]	—
9	Bill-to Country/Region Code	Code[10]	—
10	Posting Date	Date	—
11	Document Date	Date	—
12	Due Date	Date	—
13	External Document No.	Code[35]	—
14	Your Reference	Text[35]	—
20	Currency Code	Code[10]	—
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]	—
51	Ship-to Address	Text[100]	—	DataClassification EndUserIdentifiableInformation
52	Ship-to City	Text[30]	—
53	Ship-to Post Code	Code[20]	—
54	Ship-to Country/Region Code	Code[10]	—
60	Amount	Decimal	—
61	Amount Including VAT	Decimal	—
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	—
91	Closed	Boolean	—
200	Gen. Bus. Posting Group	Code[20]	—
201	VAT Bus. Posting Group	Code[20]	—
202	Customer Posting Group	Code[20]	—

Keys

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

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