Table 40904 "Hist. Receivables Document"

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	Customer No.	Code[35]	Specifies the value of the Customer No. field. via Page 41006 “Hist. Receivables Document”	NotBlank
3	Customer Name	Text[100]	Specifies the value of the Customer Name field. via Page 41006 “Hist. Receivables Document”
4	Document Type	enum “Hist. Receivables Doc. Type”	Specifies the value of the Document Type field. via Page 41006 “Hist. Receivables Document”	enum Enum 40903 “Hist. Receivables Doc. Type”; NotBlank
5	Document No.	Code[35]	Specifies the value of the Document No. field. via Page 41006 “Hist. Receivables Document”	NotBlank
6	Batch No.	Code[35]	Specifies the value of the Batch No. field. via Page 41006 “Hist. Receivables Document”
7	Batch Source	Text[50]	Specifies the value of the Batch Source field. via Page 41006 “Hist. Receivables Document”
8	Audit Code	Code[35]	Specifies the value of the Audit Code field. via Page 41006 “Hist. Receivables Document”
9	Trx. Description	Text[50]	Specifies the value of the Trx. Description field. via Page 41006 “Hist. Receivables Document”
10	Document Date	Date	Specifies the value of the Document Date field. via Page 41006 “Hist. Receivables Document”
11	Due Date	Date	Specifies the value of the Due Date field. via Page 41006 “Hist. Receivables Document”
12	Post Date	Date	Specifies the value of the Post Date field. via Page 41006 “Hist. Receivables Document”
13	User	Text[50]	Specifies the value of the User field. via Page 41006 “Hist. Receivables Document”
14	Currency Code	Code[10]	Specifies the value of the Currency field. via Page 41006 “Hist. Receivables Document”
15	Orig. Trx. Amount	Decimal	Specifies the value of the Orig. Trx. Amount field. via Page 41006 “Hist. Receivables Document”
16	Current Trx. Amount	Decimal	Specifies the value of the Current Trx. Amount field. via Page 41006 “Hist. Receivables Document”
17	Sales Amount	Decimal	Specifies the value of the Sales Amount field. via Page 41006 “Hist. Receivables Document”
18	Cost Amount	Decimal	Specifies the value of the Cost Amount field. via Page 41006 “Hist. Receivables Document”
19	Freight Amount	Decimal	Specifies the value of the Freight Amount field. via Page 41006 “Hist. Receivables Document”
20	Misc. Amount	Decimal	Specifies the value of the Misc. Amount field. via Page 41006 “Hist. Receivables Document”
21	Tax Amount	Decimal	Specifies the value of the Tax Amount field. via Page 41006 “Hist. Receivables Document”
22	Disc. Taken Amount	Decimal	Specifies the value of the Disc. Taken Amount field. via Page 41006 “Hist. Receivables Document”
23	Customer Purchase No.	Code[35]	Specifies the value of the Customer Purchase No. field. via Page 41006 “Hist. Receivables Document”
24	Salesperson No.	Code[35]	Specifies the value of the Salesperson No. field. via Page 41006 “Hist. Receivables Document”
25	Sales Territory	Text[50]	Specifies the value of the Sales Territory field. via Page 41006 “Hist. Receivables Document”
26	Ship Method	Text[50]	Specifies the value of the Ship Method field. via Page 41006 “Hist. Receivables Document”
27	Cash Amount	Decimal	Specifies the value of the Cash Amount field. via Page 41006 “Hist. Receivables Document”
28	Commission Dollar Amount	Decimal	Specifies the value of the Commission Dollar Amount field. via Page 41006 “Hist. Receivables Document”
29	Invoice Paid Off Date	Date	Specifies the value of the Invoice Paid Off Date field. via Page 41006 “Hist. Receivables Document”
30	Payment Terms ID	Text[50]	Specifies the value of the Payment Terms ID field. via Page 41006 “Hist. Receivables Document”
31	Write Off Amount	Decimal	Specifies the value of the Write Off Amount field. via Page 41006 “Hist. Receivables Document”

Keys

PK: Primary Key (clustered)
Key2: Document Type, Document No.
Key3: Customer No.

Pages and codeunits on this table

Page 41006 “Hist. Receivables Document” (source table)
Page 41016 “Hist. Receivables Documents” (source table)
Page 41026 “Hist. Recv. Document List” (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. Receivables Document"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.