Table 4077 "GPSOPTrxAmountsHist"

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	SOPTYPE	Option	SOP Type caption
2	SOPNUMBE	text[22]	SOP Number caption
3	LNITMSEQ	Integer	Line Item Sequence caption
4	CMPNTSEQ	Integer	Component Sequence caption
5	ITEMNMBR	text[32]	Item Number caption
6	ITEMDESC	text[102]	Item Description caption
7	NONINVEN	Option	Non-Inventory Item caption
8	DROPSHIP	Integer	Drop Ship caption
9	UOFM	text[10]	U Of M caption
10	LOCNCODE	text[12]	Location Code caption
11	UNITCOST	Decimal	Unit Cost caption
12	ORUNTCST	Decimal	Originating Unit Cost caption
13	UNITPRCE	Decimal	Unit Price caption
14	ORUNTPRC	Decimal	Originating Unit Price caption
15	XTNDPRCE	Decimal	Extended Price caption
16	OXTNDPRC	Decimal	Originating Extended Price caption
17	REMPRICE	Decimal	Remaining Price caption
18	OREPRICE	Decimal	Originating Remaining Price caption
19	EXTDCOST	Decimal	Extended Cost caption
20	OREXTCST	Decimal	Originating Extended Cost caption
21	MRKDNAMT	Decimal	Markdown Amount caption
22	ORMRKDAM	Decimal	Originating Markdown Amount caption
23	MRKDNPCT	Integer	Markdown Percent caption
24	MRKDNTYP	Option	Markdown Type caption
25	INVINDX	Integer	Inventory Index caption
26	CSLSINDX	Integer	Cost Of Sales Index caption
27	SLSINDX	Integer	Sales Index caption
28	MKDNINDX	Integer	Markdown Index caption
29	RTNSINDX	Integer	Returns Index caption
30	INUSINDX	Integer	In Use Index caption
31	INSRINDX	Integer	In Service Index caption
32	DMGDINDX	Integer	Damaged Index caption
33	ITMTSHID	text[16]	Item Tax Schedule ID caption
34	IVITMTXB	Option	IV Item Taxable caption
35	BKTSLSAM	Decimal	Backout Sales Amount caption
36	ORBKTSLS	Decimal	Originating Backout Sales Amount caption
37	TAXAMNT	Decimal	Tax Amount caption
38	ORTAXAMT	Decimal	Originating Tax Amount caption
39	TXBTXAMT	Decimal	Taxable Tax Amount caption
40	OTAXTAMT	Decimal	Originating Taxable Tax Amount caption
41	BSIVCTTL	Boolean	Based On Invoice Total caption
42	TRDISAMT	Decimal	Trade Discount Amount caption
43	ORTDISAM	Decimal	Originating Trade Discount Amount caption
44	DISCSALE	Decimal	Discount Available Sales caption
45	ORDAVSLS	Decimal	Originating Discount Available Sales caption
46	QUANTITY	Decimal	QTY caption
47	ATYALLOC	Decimal	QTY Allocated caption
48	QTYINSVC	Decimal	QTY In Service caption
49	QTYINUSE	Decimal	QTY In Use caption
50	QTYDMGED	Decimal	QTY Damaged caption
51	QTYRTRND	Decimal	QTY Returned caption
52	QTYONHND	Decimal	QTY On Hand caption
53	QTYCANCE	Decimal	QTY Canceled caption
54	QTYCANOT	Decimal	QTY Canceled Other caption
55	QTYORDER	Decimal	QTY Ordered caption
56	QTYPRBAC	Decimal	QTY Prev Back Ordered caption
57	QTYPRBOO	Decimal	QTY Prev BO On Order caption
58	QTYPRINV	Decimal	QTY Prev Invoiced caption
59	QTYPRORD	Decimal	QTY Prev Ordered caption
60	QTYPRVRECVD	Decimal	QTY Prev Received caption
61	QTYRECVD	Decimal	QTY Received caption
62	QTYREMAI	Decimal	QTY Remaining caption
63	QTYREMBO	Decimal	QTY Remaining On BO caption
64	QTYTBAOR	Decimal	QTY To Back Order caption
65	QTYTOINV	Decimal	QTY To Invoice caption
66	QTYTORDR	Decimal	QTY To Order caption
67	QTYFULFI	Decimal	QTY Fulfilled caption
68	QTYSLCTD	Decimal	QTY Selected caption
69	QTYBSUOM	Decimal	QTY In Base U Of M caption
70	EXTQTYAL	Decimal	Existing Qty Available caption
71	EXTQTYSEL	Decimal	Existing Qty Selected caption
72	ReqShipDate	Date	Requested Ship Date caption
73	FUFILDAT	Date	Fulfillment Date caption
74	ACTLSHIP	Date	Actual Ship Date caption
75	SHIPMTHD	text[16]	Shipping Method caption
76	SALSTERR	text[16]	Sales Territory caption
77	SLPRSNID	text[16]	Salesperson ID caption
78	PRCLEVEL	text[12]	PriceLevel caption
79	COMMNTID	text[16]	Comment ID caption
80	BRKFLD1	Integer	Break Field 1 caption
81	BRKFLD2	Integer	Break Field 2 caption
82	BRKFLD3	Integer	Break Field 3 caption
83	CURRNIDX	Integer	Currency Index caption
84	TRXSORCE	text[14]	TRX Source caption
85	DOCNCORR	text[22]	Document Number Corrected caption
86	ORGSEQNM	Integer	Original Sequence Number Corrected caption
87	ITEMCODE	text[16]	Item Code caption
88	PURCHSTAT	Option	Purchasing Status caption
89	DECPLQTY	Option	Decimal Places QTYS caption
90	DECPLCUR	Option	Decimal Places Currency caption
91	ODECPLCU	Option	Originating Decimal Places Currency caption
92	EXCEPTIONALDEMAND	Boolean	Exceptional Demand caption
93	TAXSCHID	text[16]	Tax Schedule ID caption
94	TXSCHSRC	Option	Tax Schedule Source caption
95	PRSTADCD	text[16]	Primary Shipto Address Code caption
96	ShipToName	text[66]	—
97	CNTCPRSN	text[62]	Contact Person caption
98	ADDRESS1	text[62]	Address 1 caption
99	ADDRESS2	text[62]	Address 2 caption
100	ADDRESS3	text[62]	Address 3 caption
101	CITY	text[36]	City caption
102	STATE	text[30]	State caption
103	ZIPCODE	text[12]	Zip Code caption
104	CCode	text[8]	Country Code caption
105	COUNTRY	text[62]	Country caption
106	PHONE1	text[22]	Phone 1 caption
107	PHONE2	text[22]	Phone 2 caption
108	PHONE3	text[22]	Phone 3 caption
109	FAXNUMBR	text[22]	Fax Number caption
110	Flags	Integer	—
111	CONTNBR	text[12]	Contract Number caption
112	CONTLNSEQNBR	Decimal	Contract Line SEQ Number caption
113	CONTSTARTDTE	Date	Contract Start Date caption
114	CONTENDDTE	Date	Contract End Date caption
115	CONTITEMNBR	text[32]	Contract Item Number caption
116	CONTSERIALNBR	text[22]	Contract Serial Number caption
117	ISLINEINTRA	Boolean	IsLineIntrastat caption
118	Print_Phone_NumberGB	Option	Print Phone Number GB caption
119	DEX_ROW_TS	DateTime	—
120	DEX_ROW_ID	Integer	—

Keys

PK: SOPNUMBE, SOPTYPE, CMPNTSEQ, LNITMSEQ
Key2: SOPTYPE, SOPNUMBE

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