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

Table 4066 "GPRMOpen"

HybridGP · Microsoft.DataMigration.GP

Open in Claude4066.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 CUSTNMBR text[16] Customer Number caption
2 CPRCSTNM text[16] Corporate Customer Number caption
3 DOCNUMBR text[22] Document Number caption
4 CHEKNMBR text[22] Check Number caption
5 BACHNUMB text[16] Batch Number caption
6 BCHSOURC text[16] Batch Source caption
7 TRXSORCE text[14] TRX Source caption
8 RMDTYPAL Option RM Document Type-All caption
9 CSHRCTYP Option Cash Receipt Type caption
10 CBKIDCRD text[16] Checkbook ID Credit Card caption
11 CBKIDCSH text[16] Checkbook ID Cash caption
12 CBKIDCHK text[16] Checkbook ID Check caption
13 DUEDATE Date Due Date caption
14 DOCDATE Date Document Date caption
15 POSTDATE Date Post Date caption
16 PSTUSRID text[16] Post User ID caption
17 GLPOSTDT Date GL Posting Date caption
18 LSTEDTDT Date Last Edit Date caption
19 LSTUSRED text[16] Last User to Edit caption
20 ORTRXAMT Decimal Original Trx Amount caption
21 CURTRXAM Decimal Current Trx Amount caption
22 SLSAMNT Decimal Sales Amount caption
23 COSTAMNT Decimal Cost Amount caption
24 FRTAMNT Decimal Freight Amount caption
25 MISCAMNT Decimal Misc Amount caption
26 TAXAMNT Decimal Tax Amount caption
27 COMDLRAM Decimal Commission Dollar Amount caption
28 CASHAMNT Decimal Cash Amount caption
29 DISTKNAM Decimal Discount Taken Amount caption
30 DISAVAMT Decimal Discount Available Amount caption
31 DISAVTKN Decimal Discount Available Taken caption
32 DISCRTND Decimal Discount Returned caption
33 DISCDATE Date Discount Date caption
34 DSCDLRAM Decimal Discount Dollar Amount caption
35 DSCPCTAM Integer Discount Percent Amount caption
36 WROFAMNT Decimal Write Off Amount caption
37 TRXDSCRN text[32] Transaction Description caption
38 CSPORNBR text[22] Customer Purchase Order Number caption
39 SLPRSNID text[16] Salesperson ID caption
40 SLSTERCD text[16] Sales Territory Code caption
41 DINVPDOF Date Date Invoice Paid Off caption
42 PPSAMDED Decimal PPS Amount Deducted caption
43 GSTDSAMT Decimal GST Discount Amount caption
44 DELETE1 Boolean Delete caption
45 AGNGBUKT Integer Aging Bucket caption
46 VOIDSTTS Option Void Status caption
47 VOIDDATE Date Void Date caption
48 TAXSCHID text[16] Tax Schedule ID caption
49 CURNCYID text[16] Currency ID caption
50 PYMTRMID text[22] Payment Terms ID caption
51 SHIPMTHD text[16] Shipping Method caption
52 TRDISAMT Decimal Trade Discount Amount caption
53 SLSCHDID text[16] Sales Schedule ID caption
54 FRTSCHID text[16] Freight Schedule ID caption
55 MSCSCHID text[16] Misc Schedule ID caption
56 NOTEINDX Decimal Note Index caption
57 Tax_Date Date Tax Date caption
58 APLYWITH Boolean Apply Withholding caption
59 SALEDATE Date Sale Date caption
60 CORRCTN Boolean Correction caption
61 SIMPLIFD Boolean Simplified caption
62 Electronic Boolean —
63 ECTRX Boolean EC Transaction caption
64 BKTSLSAM Decimal Backout Sales Amount caption
65 BKTFRTAM Decimal Backout Freight Amount caption
66 BKTMSCAM Decimal Backout Misc Amount caption
67 BackoutTradeDisc Decimal Backout Trade Discount Amount caption
68 Factoring Boolean —
69 DIRECTDEBIT Boolean Direct Debit caption
70 ADRSCODE text[16] Address Code caption
71 EFTFLAG Boolean EFT Flag caption
72 DEX_ROW_TS DateTime —
73 DEX_ROW_ID Integer —

Keys

  • PK: CUSTNMBR, RMDTYPAL, DOCNUMBR
  • DueDate: DUEDATE
  • Key3: 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: "GPRMOpen"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources