Table 40102 "GP POPPOHeader"

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

Properties

Property	Value
Extensible	false
DataClassification	CustomerContent
ObsoleteState	Removed
ObsoleteTag	25.0
ObsoleteReason	Replaced by table GP POP10100.

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
1	PONUMBER	Text[18]	—
2	POSTATUS	Option	—
3	STATGRP	Integer	—
4	POTYPE	Option	—
5	USER2ENT	Text[16]	—
6	CONFIRM1	Text[22]	—
7	DOCDATE	Date	—
8	LSTEDTDT	Date	—
9	LSTPRTDT	Date	—
10	PRMDATE	Date	—
11	PRMSHPDTE	Date	—
12	REQDATE	Date	—
13	REQTNDT	Date	—
14	SHIPMTHD	Text[16]	—
15	TXRGNNUM	Text[26]	—
16	REMSUBTO	Decimal	—
17	SUBTOTAL	Decimal	—
18	TRDISAMT	Decimal	—
19	FRTAMNT	Decimal	—
20	MSCCHAMT	Decimal	—
21	TAXAMNT	Decimal	—
22	VENDORID	Text[16]	—
23	VENDNAME	Text[66]	—
24	MINORDER	Decimal	—
25	VADCDPAD	Text[16]	—
26	CMPANYID	Integer	—
27	PRBTADCD	Text[16]	—
28	PRSTADCD	Text[16]	—
29	CMPNYNAM	Text[66]	—
30	CONTACT	Text[62]	—
31	ADDRESS1	Text[62]	—
32	ADDRESS2	Text[62]	—
33	ADDRESS3	Text[62]	—
34	CITY	Text[36]	—
35	STATE	Text[30]	—
36	ZIPCODE	Text[12]	—
37	CCode	Text[8]	—
38	COUNTRY	Text[62]	—
39	PHONE1	Text[22]	—
40	PHONE2	Text[22]	—
41	PHONE3	Text[22]	—
42	FAX	Text[22]	—
43	PYMTRMID	Text[22]	—
44	DSCDLRAM	Decimal	—
45	DSCPCTAM	Integer	—
46	DISAMTAV	Decimal	—
47	DISCDATE	Date	—
48	DUEDATE	Date	—
49	TRDPCTPR	Text[25]	—
50	CUSTNMBR	Text[16]	—
51	TIMESPRT	Integer	—
52	CREATDDT	Date	—
53	MODIFDT	Date	—
54	PONOTIDS_1	Decimal	—
55	PONOTIDS_2	Decimal	—
56	PONOTIDS_3	Decimal	—
57	PONOTIDS_4	Decimal	—
58	PONOTIDS_5	Decimal	—
59	PONOTIDS_6	Decimal	—
60	PONOTIDS_7	Decimal	—
61	PONOTIDS_8	Decimal	—
62	PONOTIDS_9	Decimal	—
63	PONOTIDS_10	Decimal	—
64	PONOTIDS_11	Decimal	—
65	PONOTIDS_12	Decimal	—
66	PONOTIDS_13	Decimal	—
67	PONOTIDS_14	Decimal	—
68	PONOTIDS_15	Decimal	—
69	COMMNTID	Text[16]	—
70	CANCSUB	Decimal	—
71	CURNCYID	Text[16]	—
72	CURRNIDX	Integer	—
73	RATETPID	Text[16]	—
74	EXGTBLID	Text[16]	—
75	XCHGRATE	Decimal	—
76	EXCHDATE	Date	—
77	TIME1	Date	—
78	RATECALC	Integer	—
79	DENXRATE	Decimal	—
80	MCTRXSTT	Integer	—
81	OREMSUBT	Decimal	—
82	ORSUBTOT	Decimal	—
83	Originating_Canceled_Sub	Decimal	—
84	ORTDISAM	Decimal	—
85	ORFRTAMT	Decimal	—
86	OMISCAMT	Decimal	—
87	ORTAXAMT	Decimal	—
88	ORDDLRAT	Decimal	—
89	ODISAMTAV	Decimal	—
90	BUYERID	Text[16]	—
91	ONORDAMT	Decimal	—
92	ORORDAMT	Decimal	—
93	HOLD	Boolean	—
94	ONHOLDDATE	Date	—
95	ONHOLDBY	Text[16]	—
96	HOLDREMOVEDATE	Date	—
97	HOLDREMOVEBY	Text[16]	—
98	ALLOWSOCMTS	Boolean	—
99	DISGRPER	Integer	—
100	DUEGRPER	Integer	—
101	Revision_Number	Integer	—
102	Change_Order_Flag	Integer	—
103	PO_Field_Changes	Blob	—
104	PO_Status_Orig	Option	—
105	TAXSCHID	Text[16]	—
106	TXSCHSRC	Integer	—
107	TXENGCLD	Boolean	—
108	BSIVCTTL	Boolean	—
109	Purchase_Freight_Taxable	Option	—
110	Purchase_Misc_Taxable	Option	—
111	FRTSCHID	Text[16]	—
112	MSCSCHID	Text[16]	—
113	FRTTXAMT	Decimal	—
114	ORFRTTAX	Decimal	—
115	MSCTXAMT	Decimal	—
116	ORMSCTAX	Decimal	—
117	BCKTXAMT	Decimal	—
118	OBTAXAMT	Decimal	—
119	BackoutFreightTaxAmt	Decimal	—
120	OrigBackoutFreightTaxAmt	Decimal	—
121	BackoutMiscTaxAmt	Decimal	—
122	OrigBackoutMiscTaxAmt	Decimal	—
123	Flags	Integer	—
124	BackoutTradeDiscTax	Decimal	—
125	OrigBackoutTradeDiscTax	Decimal	—
126	POPCONTNUM	Text[22]	—
127	CONTENDDTE	Date	—
128	CNTRLBLKTBY	Integer	—
129	PURCHCMPNYNAM	Text[66]	—
130	PURCHCONTACT	Text[62]	—
131	PURCHADDRESS1	Text[62]	—
132	PURCHADDRESS2	Text[62]	—
133	PURCHADDRESS3	Text[62]	—
134	PURCHCITY	Text[36]	—
135	PURCHSTATE	Text[30]	—
136	PURCHZIPCODE	Text[12]	—
137	PURCHCCode	Text[8]	—
138	PURCHCOUNTRY	Text[62]	—
139	PURCHPHONE1	Text[22]	—
140	PURCHPHONE2	Text[22]	—
141	PURCHPHONE3	Text[22]	—
142	PURCHFAX	Text[22]	—
143	BLNKTLINEEXTQTYSUM	Decimal	—
144	CBVAT	Boolean	—
145	Workflow_Approval_Status	Option	—
146	Workflow_Priority	Option	—
147	Workflow_Status	Option	—
148	Print_Phone_NumberGB	Integer	—
149	PrepaymentAmount	Decimal	—
150	OriginatingPrepaymentAmt	Decimal	—
151	DEX_ROW_TS	DateTime	—
152	DEX_ROW_ID	Integer	—

Keys

PK: PONUMBER (clustered)

Deprecations

object: Removed 25.0 (#if not CLEANSCHEMA25), “Replaced by table GP POP10100.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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