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

Table 4057 "GPPOPPOHist"

HybridGP · Microsoft.DataMigration.GP

Open in Claude4057.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 PONUMBER text[18] PO Number caption
2 POSTATUS Option PO Status caption
3 STATGRP Option Status Group caption
4 POTYPE Option PO Type caption
5 USER2ENT text[16] User To Enter caption
6 CONFIRM1 text[22] Confirm With caption
7 DOCDATE Date Document Date caption
8 LSTEDTDT Date Last Edit Date caption
9 LSTPRTDT Date Last Printed Date caption
10 PRMDATE Date Promised Date caption
11 PRMSHPDTE Date Promised Ship Date caption
12 REQDATE Date Required Date caption
13 REQTNDT Date Requisition Date caption
14 SHIPMTHD text[16] Shipping Method caption
15 TXRGNNUM text[26] Tax Registration Number caption
16 REMSUBTO Decimal Remaining Subtotal caption
17 SUBTOTAL Decimal Subtotal caption
18 TRDISAMT Decimal Trade Discount Amount caption
20 FRTAMNT Decimal Freight Amount caption
21 MSCCHAMT Decimal Misc Charges Amount caption
22 TAXAMNT Decimal Tax Amount caption
23 VENDORID text[16] Vendor ID caption
24 VENDNAME text[66] Vendor Name caption
25 MINORDER Decimal Minimum Order caption
26 VADCDPAD text[16] Vendor Address Code - Purchase Address caption
27 CMPANYID Integer Company ID caption
28 PRBTADCD text[16] Primary Billto Address Code caption
29 PRSTADCD text[16] Primary Shipto Address Code caption
30 CMPNYNAM text[66] Company Name caption
31 CONTACT text[62] Contact caption
32 ADDRESS1 text[62] Address 1 caption
33 ADDRESS2 text[62] Address 2 caption
34 ADDRESS3 text[62] Address 3 caption
35 CITY text[36] City caption
36 STATE text[30] State caption
37 ZIPCODE text[12] Zip Code caption
38 CCode text[8] Country Code caption
39 COUNTRY text[62] Country caption
40 PHONE1 text[22] Phone 1 caption
41 PHONE2 text[22] Phone 2 caption
42 PHONE3 text[22] Phone 3 caption
43 FAX text[22] Fax caption
44 PYMTRMID text[22] Payment Terms ID caption
45 DSCDLRAM Decimal Discount Dollar Amount caption
46 DSCPCTAM Integer Discount Percent Amount caption
47 DISAMTAV Decimal Discount Amount Available caption
48 DISCDATE Date Discount Date caption
49 DUEDATE Date Due Date caption
50 CUSTNMBR text[16] Customer Number caption
51 TIMESPRT Integer Times Printed caption
52 CREATDDT Date Created Date caption
53 MODIFDT Date Modified Date caption
54 PONOTIDS_1 Decimal PO Note ID Array caption
55 PONOTIDS_2 Decimal PO Note ID Array caption
56 PONOTIDS_3 Decimal PO Note ID Array caption
57 PONOTIDS_4 Decimal PO Note ID Array caption
58 PONOTIDS_5 Decimal PO Note ID Array caption
59 PONOTIDS_6 Decimal PO Note ID Array caption
60 PONOTIDS_7 Decimal PO Note ID Array caption
61 PONOTIDS_8 Decimal PO Note ID Array caption
62 PONOTIDS_9 Decimal PO Note ID Array caption
63 PONOTIDS_10 Decimal PO Note ID Array caption
64 PONOTIDS_11 Decimal PO Note ID Array caption
65 PONOTIDS_12 Decimal PO Note ID Array caption
66 PONOTIDS_13 Decimal PO Note ID Array caption
67 PONOTIDS_14 Decimal PO Note ID Array caption
68 PONOTIDS_15 Decimal PO Note ID Array caption
69 TRXSORCE text[14] TRX Source caption
70 COMMNTID text[16] Comment ID caption
71 CANCSUB Decimal Canceled Subtotal caption
72 CURNCYID text[16] Currency ID caption
73 CURRNIDX Integer Currency Index caption
74 RATETPID text[16] Rate Type ID caption
75 EXGTBLID text[16] Exchange Table ID caption
76 XCHGRATE Decimal Exchange Rate caption
77 EXCHDATE Date Exchange Date caption
78 TIME1 DateTime Time caption
79 RATECALC Option Rate Calc Method caption
80 DENXRATE Decimal Denomination Exchange Rate caption
81 MCTRXSTT Option MC Transaction State caption
82 OREMSUBT Decimal Originating Remaining Subtotal caption
83 ORSUBTOT Decimal Originating Subtotal caption
84 Originating_Canceled_Sub Decimal Originating Canceled Subtotal caption
85 ORTDISAM Decimal Originating Trade Discount Amount caption
86 ORFRTAMT Decimal Originating Freight Amount caption
87 OMISCAMT Decimal Originating Misc Charges Amount caption
88 ORTAXAMT Decimal Originating Tax Amount caption
89 ORDDLRAT Decimal Originating Discount Dollar Amount caption
90 ODISAMTAV Decimal Originating Discount Amount Available caption
91 BUYERID text[16] Buyer ID caption
92 ALLOWSOCMTS Boolean Allow SO Commitments caption
93 DISGRPER Integer Discount Grace Period caption
94 DUEGRPER Integer Due Date Grace Period caption
95 Revision_Number Integer Revision Number caption
96 TAXSCHID text[16] Tax Schedule ID caption
97 TXSCHSRC Option Tax Schedule Source caption
98 BSIVCTTL Boolean Based On Invoice Total caption
99 Purchase_Freight_Taxable Option Purchase Freight Taxable caption
100 Purchase_Misc_Taxable Option Purchase Misc Taxable caption
101 FRTSCHID text[16] Freight Schedule ID caption
102 MSCSCHID text[16] Misc Schedule ID caption
103 FRTTXAMT Decimal Freight Tax Amount caption
104 ORFRTTAX Decimal Originating Freight Tax Amount caption
105 MSCTXAMT Decimal Misc Tax Amount caption
106 ORMSCTAX Decimal Originating Misc Tax Amount caption
107 BCKTXAMT Decimal Backout Tax Amount caption
108 OBTAXAMT Decimal Originating Backout Tax Amount caption
109 BackoutFreightTaxAmt Decimal Backout Freight Tax Amount caption
110 OrigBackoutFreightTaxAmt Decimal Originating Backout Freight Tax Amount caption
111 BackoutMiscTaxAmt Decimal Backout Misc Tax Amount caption
112 OrigBackoutMiscTaxAmt Decimal Originating Backout Misc Tax Amount caption
113 Flags Integer —
114 POPCONTNUM text[22] POP Contract Number caption
115 CONTENDDTE Date Contract End Date caption
116 CNTRLBLKTBY Option Control Blanket By caption
117 PURCHCMPNYNAM text[66] Purchase Company Name caption
118 PURCHCONTACT text[62] Purchase Contact caption
119 PURCHADDRESS1 text[62] Purchase Address 1 caption
120 PURCHADDRESS2 text[62] Purchase Address 2 caption
121 PURCHADDRESS3 text[62] Purchase Address 3 caption
122 PURCHCITY text[36] Purchase City caption
123 PURCHSTATE text[30] Purchase State caption
124 PURCHZIPCODE text[12] Purchase Zip Code caption
125 PURCHCCode text[8] Purchase Country Code caption
126 PURCHCOUNTRY text[62] Purchase Country caption
127 PURCHPHONE1 text[22] Purchase Phone 1 caption
128 PURCHPHONE2 text[22] Purchase Phone 2 caption
129 PURCHPHONE3 text[22] Purchase Phone 3 caption
130 PURCHFAX text[22] Purchase Fax caption
131 BLNKTLINEEXTQTYSUM Decimal Total Blanket Line Ext Qty caption
132 Workflow_Approval_Status Option Workflow Approval Status caption
133 Workflow_Priority Option Workflow Priority caption
134 Workflow_Status Option Workflow Status caption
135 Print_Phone_NumberGB Option Print Phone Number GB caption
136 PrepaymentAmount Decimal Prepayment Amount caption
137 OriginatingPrepaymentAmt Decimal Originating Prepayment Amount caption
138 DEX_ROW_TS DateTime —
139 DEX_ROW_ID Integer —

Keys

  • PK: PONUMBER
  • DueDate: DUEDATE

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

Evidence 1 sources