Table 40905 "Hist. Payables 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	Voucher No.	Code[35]	Specifies the value of the Voucher No. field. via Page 41008 “Hist. Payables Document”	NotBlank
3	Vendor No.	Code[35]	Specifies the value of the Vendor No. field. via Page 41008 “Hist. Payables Document”	NotBlank
4	Vendor Name	Text[100]	Specifies the value of the Vendor Name field. via Page 41008 “Hist. Payables Document”
5	Document Type	enum “Hist. Payables Doc. Type”	Specifies the value of the Document Type field. via Page 41008 “Hist. Payables Document”	enum Enum 40904 “Hist. Payables Doc. Type”; NotBlank
6	Document No.	Code[35]	Specifies the value of the Document No. field. via Page 41008 “Hist. Payables Document”	NotBlank
7	Document Date	Date	Specifies the value of the Document Date field. via Page 41008 “Hist. Payables Document”
8	Document Amount	Decimal	Specifies the value of the Document Amount field. via Page 41008 “Hist. Payables Document”
9	Currency Code	Code[10]	Specifies the value of the Currency field. via Page 41008 “Hist. Payables Document”
10	Current Trx. Amount	Decimal	Specifies the value of the Current Trx. Amount field. via Page 41008 “Hist. Payables Document”
11	Disc. Taken Amount	Decimal	Specifies the value of the Disc. Taken Amount field. via Page 41008 “Hist. Payables Document”
12	Batch No.	Code[35]	Specifies the value of the Batch No. field. via Page 41008 “Hist. Payables Document”
13	Batch Source	Text[50]	Specifies the value of the Batch Source field. via Page 41008 “Hist. Payables Document”
14	Due Date	Date	Specifies the value of the Due Date field. via Page 41008 “Hist. Payables Document”
15	Purchase No.	Code[35]	Specifies the value of the Purchase No. field. via Page 41008 “Hist. Payables Document”
16	Audit Code	Code[35]	Specifies the value of the Audit Code field. via Page 41008 “Hist. Payables Document”
17	Trx. Description	Text[50]	Specifies the value of the Trx. Description field. via Page 41008 “Hist. Payables Document”
18	Post Date	Date	Specifies the value of the Post Date field. via Page 41008 “Hist. Payables Document”
19	User	Text[50]	Specifies the value of the User field. via Page 41008 “Hist. Payables Document”
20	Misc. Amount	Decimal	Specifies the value of the Misc. Amount field. via Page 41008 “Hist. Payables Document”
21	Freight Amount	Decimal	Specifies the value of the Freight Amount field. via Page 41008 “Hist. Payables Document”
22	Tax Amount	Decimal	Specifies the value of the Tax Amount field. via Page 41008 “Hist. Payables Document”
23	Total Payments	Decimal	Specifies the value of the Total Payments field. via Page 41008 “Hist. Payables Document”
24	Voided	Boolean	Specifies the value of the Voided field. via Page 41008 “Hist. Payables Document”
25	Invoice Paid Off Date	Date	Specifies the value of the Invoice Paid Off Date field. via Page 41008 “Hist. Payables Document”
26	Ship Method	Text[50]	Specifies the value of the Ship Method field. via Page 41008 “Hist. Payables Document”
27	1099 Amount	Decimal	Specifies the value of the 1099 Amount field. via Page 41008 “Hist. Payables Document”
28	Write Off Amount	Decimal	Specifies the value of the Write Off Amount field. via Page 41008 “Hist. Payables Document”
29	Trade Discount Amount	Decimal	Specifies the value of the Trade Discount Amount field. via Page 41008 “Hist. Payables Document”
30	Payment Terms ID	Text[50]	Specifies the value of the Payment Terms ID field. via Page 41008 “Hist. Payables Document”
31	1099 Type	Text[50]	Specifies the value of the 1099 Type field. via Page 41008 “Hist. Payables Document”
32	1099 Box Number	Text[50]	Specifies the value of the 1099 Box Number field. via Page 41008 “Hist. Payables Document”
33	PO Number	Code[35]	Specifies the value of the PO Number field. via Page 41008 “Hist. Payables Document”

Keys

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

Pages and codeunits on this table

Page 41008 “Hist. Payables Document” (source table)
Page 41017 “Hist. Payables Documents” (source table)
Page 41025 “Hist. Payables 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. Payables Document"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.