Table 4058 "GPPOPPOLineHist"

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
1	PONUMBER	text[18]	PO Number caption
2	ORD	Integer	Ord caption
3	POLNESTA	Option	PO Line Status caption
4	POTYPE	Option	PO Type caption
5	ITEMNMBR	text[32]	Item Number caption
6	ITEMDESC	text[102]	Item Description caption
7	VENDORID	text[16]	Vendor ID caption
8	VNDITNUM	text[32]	Vendor Item Number caption
9	VNDITDSC	text[102]	Vendor Item Description caption
10	NONINVEN	Option	Non-Inventory Item caption
11	LOCNCODE	text[12]	Location Code caption
12	UOFM	text[10]	U Of M caption
13	UMQTYINB	Decimal	U Of M QTY In Base caption
14	QTYORDER	Decimal	QTY Ordered caption
15	QTYCANCE	Decimal	QTY Canceled caption
16	UNITCOST	Decimal	Unit Cost caption
17	EXTDCOST	Decimal	Extended Cost caption
18	INVINDX	Integer	Inventory Index caption
19	REQDATE	Date	Required Date caption
20	PRMDATE	Date	Promised Date caption
21	PRMSHPDTE	Date	Promised Ship Date caption
22	REQSTDBY	text[22]	Requested By caption
23	COMMNTID	text[16]	Comment ID caption
24	DOCTYPE	Option	Document Type caption
25	POLNEARY_1	Decimal	PO Line Note ID Array caption
26	POLNEARY_2	Decimal	PO Line Note ID Array caption
27	POLNEARY_3	Decimal	PO Line Note ID Array caption
28	POLNEARY_4	Decimal	PO Line Note ID Array caption
29	POLNEARY_5	Decimal	PO Line Note ID Array caption
30	POLNEARY_6	Decimal	PO Line Note ID Array caption
31	POLNEARY_7	Decimal	PO Line Note ID Array caption
32	POLNEARY_8	Decimal	PO Line Note ID Array caption
33	POLNEARY_9	Decimal	PO Line Note ID Array caption
34	DECPLCUR	Option	Decimal Places Currency caption
35	DECPLQTY	Option	Decimal Places QTYS caption
36	BRKFLD1	Integer	Break Field 1 caption
37	JOBNUMBR	text[18]	Job Number caption
38	COSTCODE	text[28]	Cost Code caption
39	COSTTYPE	Integer	Cost Code Type caption
40	CURRNIDX	Integer	Currency Index caption
41	ORUNTCST	Decimal	Originating Unit Cost caption
42	OREXTCST	Decimal	Originating Extended Cost caption
43	LINEORIGIN	Option	Line Origin caption
44	FREEONBOARD	Option	Free On Board caption
45	ODECPLCU	Option	Originating Decimal Places Currency caption
46	Product_Indicator	Integer	Product Indicator caption
47	Source_Document_Number	text[12]	Source Document Number caption
48	Source_Document_Line_Num	Integer	Source Document Line Number caption
49	RELEASEBYDATE	Date	Release By Date caption
50	Released_Date	Date	Released Date caption
51	Purchase_IV_Item_Taxable	Option	Purchase IV Item Taxable caption
52	Purchase_Item_Tax_Schedu	text[16]	Purchase Item Tax Schedule ID caption
53	Purchase_Site_Tax_Schedu	text[16]	Purchase Site Tax Schedule ID caption
54	PURCHSITETXSCHSRC	Integer	Purchase Site Tax Schedule Source caption
55	BSIVCTTL	Boolean	Based On Invoice Total caption
56	TAXAMNT	Decimal	Tax Amount caption
57	ORTAXAMT	Decimal	Originating Tax Amount caption
58	BCKTXAMT	Decimal	Backout Tax Amount caption
59	OBTAXAMT	Decimal	Originating Backout Tax Amount caption
60	Landed_Cost_Group_ID	text[16]	Landed Cost Group ID caption
61	SHIPMTHD	text[16]	Shipping Method caption
62	LineNumber	Integer	—
63	ORIGPRMDATE	Date	Original Promised Date caption
64	FSTRCPTDT	Date	First Receipt Date caption
65	LSTRCPTDT	Date	Last Receipt Date caption
66	RELEASE	Integer	Release caption
67	ADRSCODE	text[16]	Address Code caption
68	CMPNYNAM	text[66]	Company Name caption
69	CONTACT	text[62]	Contact caption
70	ADDRESS1	text[62]	Address 1 caption
71	ADDRESS2	text[62]	Address 2 caption
72	ADDRESS3	text[62]	Address 3 caption
73	CITY	text[36]	City caption
74	STATE	text[30]	State caption
75	ZIPCODE	text[12]	Zip Code caption
76	CCode	text[8]	Country Code caption
77	COUNTRY	text[62]	Country caption
78	PHONE1	text[22]	Phone 1 caption
79	PHONE2	text[22]	Phone 2 caption
80	PHONE3	text[22]	Phone 3 caption
81	FAX	text[22]	Fax caption
82	ADDRSOURCE	Integer	Address Source caption
83	Flags	Integer	—
84	ProjNum	text[16]	Project Number caption
85	CostCatID	text[16]	Cost Category ID caption
86	ITMTRKOP	Option	Item Tracking Option caption
87	VCTNMTHD	Option	Valuation Method caption
88	Print_Phone_NumberGB	Option	Print Phone Number GB caption
89	DEX_ROW_TS	DateTime	—
90	DEX_ROW_ID	Integer	—

Keys

PK: PONUMBER, ORD, BRKFLD1

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