BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 4053 "GPPMHist"

HybridGP · Microsoft.DataMigration.GP

Open in Claude4053.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

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

Properties

Property Value
Extensible false
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 VCHRNMBR text[22] Voucher Number caption
2 VENDORID text[16] Vendor ID caption
3 DOCTYPE Option Document Type caption
4 DOCDATE Date Document Date caption
5 DOCNUMBR text[22] Document Number caption
6 DOCAMNT Decimal Document Amount caption
7 CURTRXAM Decimal Current Trx Amount caption
8 DISTKNAM Decimal Discount Taken Amount caption
9 DISCAMNT Decimal Discount Amount caption
10 DSCDLRAM Decimal Discount Dollar Amount caption
11 BACHNUMB text[16] Batch Number caption
12 TRXSORCE text[14] TRX Source caption
13 BCHSOURC text[16] Batch Source caption
14 DISCDATE Date Discount Date caption
15 DUEDATE Date Due Date caption
16 PORDNMBR text[22] Purchase Order Number caption
17 TEN99AMNT Decimal 1099 Amount caption
18 WROFAMNT Decimal Write Off Amount caption
19 DISAMTAV Decimal Discount Amount Available caption
20 TRXDSCRN text[32] Transaction Description caption
21 UN1099AM Decimal Unapplied 1099 Amount caption
22 BKTPURAM Decimal Backout Purchases Amount caption
23 BKTFRTAM Decimal Backout Freight Amount caption
24 BKTMSCAM Decimal Backout Misc Amount caption
25 VOIDED Boolean Voided caption
26 HOLD Boolean Hold caption
27 CHEKBKID text[16] Checkbook ID caption
28 DINVPDOF Date Date Invoice Paid Off caption
29 PPSAMDED Decimal PPS Amount Deducted caption
30 PPSTAXRT Integer PPS Tax Rate caption
31 PGRAMSBJ Integer Percent Of Gross Amount Subject caption
32 GSTDSAMT Decimal GST Discount Amount caption
33 POSTEDDT Date Posted Date caption
34 PTDUSRID text[16] Posted User ID caption
35 MODIFDT Date Modified Date caption
36 MDFUSRID text[16] Modified User ID caption
37 PYENTTYP Option Payment Entry Type caption
38 CARDNAME text[16] Card Name caption
39 PRCHAMNT Decimal Purchases Amount caption
40 TRDISAMT Decimal Trade Discount Amount caption
41 MSCCHAMT Decimal Misc Charges Amount caption
42 FRTAMNT Decimal Freight Amount caption
43 TAXAMNT Decimal Tax Amount caption
44 TTLPYMTS Decimal Total Payments caption
45 CURNCYID text[16] Currency ID caption
46 PYMTRMID text[22] Payment Terms ID caption
47 SHIPMTHD text[16] Shipping Method caption
48 TAXSCHID text[16] Tax Schedule ID caption
49 PCHSCHID text[16] Purchase Schedule ID caption
50 FRTSCHID text[16] Freight Schedule ID caption
51 MSCSCHID text[16] Misc Schedule ID caption
52 PSTGDATE Date Posting Date caption
53 DISAVTKN Decimal Discount Available Taken caption
54 CNTRLTYP Integer Control Type caption
55 NOTEINDX Decimal Note Index caption
56 PRCTDISC Integer Percent Discount caption
57 RETNAGAM Decimal Retainage Amount caption
58 VOIDPDATE Date Void GL Posting Date caption
59 ICTRX Boolean IC TRX caption
60 Tax_Date Date Tax Date caption
61 PRCHDATE Date Purchase Date caption
62 CORRCTN Boolean Correction caption
63 SIMPLIFD Boolean Simplified caption
64 APLYWITH Boolean Apply Withholding caption
65 Electronic Boolean —
66 ECTRX Boolean EC Transaction caption
67 DocPrinted Boolean —
68 TaxInvReqd Boolean Tax Invoice Required caption
69 VNDCHKNM text[66] Vendor Check Name caption
70 BackoutTradeDisc Decimal Backout Trade Discount Amount caption
71 CBVAT Boolean Cash Based VAT caption
72 VADCDTRO text[16] Vendor Address Code - Remit To caption
73 TEN99TYPE Option 1099 Type caption
74 TEN99BOXNUMBER Integer 1099 Box Number caption
75 PONUMBER text[18] PO Number caption
76 Workflow_Status Option Workflow Status caption
77 InvoiceReceiptDate Date Invoice Receipt Date caption
78 DEX_ROW_TS DateTime —
79 DEX_ROW_ID Integer —

Keys

  • PK: DOCTYPE, VCHRNMBR
  • DueDate: DUEDATE
  • Key3: DEX_ROW_ID
  • Key4: PYMTRMID

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

Evidence 1 sources