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

Table 40143 "GP PM30300"

HybridGP · Microsoft.DataMigration.GP

Open in Claude40143.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 VENDORID Text[15] —
2 DOCDATE DateTime —
3 DATE1 DateTime —
4 GLPOSTDT DateTime —
5 TIME1 DateTime —
6 VCHRNMBR Text[21] —
7 DOCTYPE Integer —
8 APFRDCNM Text[21] —
9 ApplyFromGLPostDate DateTime —
10 FROMCURR Text[15] —
11 APFRMAPLYAMT Decimal —
12 APFRMDISCTAKEN Decimal —
13 APFRMDISCAVAIL Decimal —
14 APFRMWROFAMT Decimal —
15 ActualApplyToAmount Decimal —
16 ActualDiscTakenAmount Decimal —
17 ActualDiscAvailTaken Decimal —
18 ActualWriteOffAmount Decimal —
19 APFRMEXRATE Decimal —
20 APFRMDENRATE Decimal —
21 APFRMRTCLCMETH Integer —
22 APFRMMCTRXSTT Integer —
23 APTVCHNM Text[21] —
24 APTODCTY Integer —
25 APTODCNM Text[21] —
26 APTODCDT DateTime —
27 ApplyToGLPostDate DateTime —
28 CURNCYID Text[15] —
29 CURRNIDX Integer —
30 APPLDAMT Decimal —
31 DISTKNAM Decimal —
32 DISAVTKN Decimal —
33 WROFAMNT Decimal —
34 ORAPPAMT Decimal —
35 ORDISTKN Decimal —
36 ORDATKN Decimal —
37 ORWROFAM Decimal —
38 APTOEXRATE Decimal —
39 APTODENRATE Decimal —
40 APTORTCLCMETH Integer —
41 APTOMCTRXSTT Integer —
42 PPSAMDED Decimal —
43 GSTDSAMT Decimal —
44 TAXDTLID Text[15] —
45 POSTED Boolean —
46 TEN99AMNT Decimal —
47 RLGANLOS Decimal —
48 APYFRMRNDAMT Decimal —
49 APYTORNDAMT Decimal —
50 APYTORNDDISC Decimal —
51 OAPYFRMRNDAMT Decimal —
52 OAPYTORNDAMT Decimal —
53 OAPYTORNDDISC Decimal —
54 Settled_Gain_CreditCurrT Decimal —
55 Settled_Loss_CreditCurrT Decimal —
56 Settled_Gain_DebitCurrTr Decimal —
57 Settled_Loss_DebitCurrTr Decimal —
58 Settled_Gain_DebitDiscAv Decimal —
59 Settled_Loss_DebitDiscAv Decimal —
60 Revaluation_Status Integer —
61 Credit1099Amount Decimal —
62 DEFTEN99TYPE Integer —
63 DEFTEN99BOXNUMBER Integer —
64 DEX_ROW_ID Integer —

Keys

  • Key1: APTVCHNM, APTODCTY, VCHRNMBR, DOCTYPE (clustered)
  • Key2: VENDORID, DOCTYPE, VCHRNMBR, POSTED

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

Evidence 1 sources