Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GST00105
Product: Project Accounting (258)
Series:
Display Name: PA Purchasing Tax History
Physical Name: GST00105
Technical Name: GST_PA_PO_Receivings_Tax_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PAVIDN 
PA Vendor Invoice Document No. String STR17_LBAU 17 2 RCPTLNNM Receipt Line Number Long Integer LI_Sequence_Number 10 3 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['PA Purchasing Tax History'].TAXDTLID AS 'PA Purchasing Tax History-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
GST00105 AS ['PA Purchasing Tax History']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['PA Purchasing Tax History'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID4 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PA Purchasing Tax History'].ACTINDX AS 'PA Purchasing Tax History-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GST00105 AS ['PA Purchasing Tax History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PA Purchasing Tax History'].ACTINDX = ['Account Index Master'].ACTINDX5 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 6 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 7 TAXPURCH Taxable Purchases Currency DLR19_RBS0_UTR$ 19 8 ORGTXPCH Originating Taxable Purchases Currency DLR19_RBS0_UTR$ 19 9 TOTPURCH Total Purchases Currency DLR19_RBS0_UTR$ 19 10 ORTOTPUR Originating Total Purchases Currency DLR19_RBSO_UTR$ 19 11 TRXSORCE TRX Source String STR13 13 12 POP_Tax_Note_ID_Array POP Tax Note ID Array DLR14 Currency 14 13 POP_Tax_Note_ID_Array_1 POP Tax Note ID Array[1] Currency DLR14 14 14 POP_Tax_Note_ID_Array_2 POP Tax Note ID Array[2] Currency DLR14 14 15 PCTAXAMT Purchases Tax Amount Currency DLR19_RBSO_UTR$ 19 16 FRTTXAMT Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 17 MSCTXAMT Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 18 TXDTTPUR Tax Detail Total Purchases Currency DLR19_RBS0_UTR$ 19 19 TDTTXPUR Tax Detail Total Taxable Purchases Currency DLR19_RBS0_UTR$ 19 20 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PA Purchasing Tax History'].CURRNIDX AS 'PA Purchasing Tax History-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
GST00105 AS ['PA Purchasing Tax History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Purchasing Tax History'].CURRNIDX = ['Currency Setup'].CURRNIDX21 BKOUTTAX Backout Tax Boolean YN 0 22 ORPURTAX Originating Purchases Tax Amount Currency DLR19_RBSO_UTR$ 19 23 ORFRTTAX Originating Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 24 ORMSCTAX Originating Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 25 PAOTDTP PA Originating Tax Detail Total Purchases Currency DLR19_RBS0_UTR$ 19 26 PAOTDTT PA Originating Tax Detail Total Taxable Purchases Currency DLR19_RBS0_UTR$ 19