GPSOPTrxAmountsHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPSOPTrxAmountsHist

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4077

Table Type: Company

Table Name: GPSOPTrxAmountsHist
Database Table Name:

Table Number: 4077

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how GPSOPTrxAmountsHist can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GPSOPTrxAmountsHist]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [GPSOPTrxAmountsHist].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [GPSOPTrxAmountsHist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GPSOPTrxAmountsHist].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GPSOPTrxAmountsHist table

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