Table 4097 "GP Vendor Transactions"

HybridGP · Microsoft.DataMigration.GP · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Extensible	false

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	Id	Text[40]	Id Number caption	DataClassification CustomerContent
2	VENDORID	Text[16]	Vendor ID caption	TableRelation Table 23 “Vendor”; DataClassification CustomerContent
3	DOCNUMBR	Text[22]	Document Number caption	DataClassification CustomerContent
4	DOCDATE	Date	Document Date caption	DataClassification CustomerContent
5	DUEDATE	Date	Due Date caption	DataClassification CustomerContent
6	CURTRXAM	Decimal	Transaction Amount caption	DataClassification CustomerContent
7	DOCTYPE	Integer	Document Type caption	DataClassification CustomerContent
8	GLDocNo	Text[30]	General Ledger Document Number caption	DataClassification CustomerContent
9	TransType	Option	Transaction Type caption	DataClassification CustomerContent
11	PYMTRMID	Text[21]	Payment Terms ID caption	DataClassification CustomerContent
12	VCHRNMBR	Text[22]	Voucher Number caption	DataClassification CustomerContent

Keys

Key1: Id (clustered)
Key2: PYMTRMID
Key3: VENDORID, TransType

Relations

VENDORID: TableRelation Table 23 “Vendor”

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