Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK10502
Product: Project Accounting (258)
Series:
Display Name: PDK Employee Expense Tax WORK
Physical Name: PDK10502
Technical Name: PDK_Employee_Expense_Tax_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PDK_EE_Trx_Type 
PDK EE Trx Type Integer PDK_DDL_Trx_Type 0 2 PDK_EE_No PDK EE No. String PDK_Document_Number 30 3 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 4 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['PDK Employee Expense Tax WORK'].TAXDTLID AS 'PDK Employee Expense Tax WORK-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
PDK10502 AS ['PDK Employee Expense Tax WORK']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['PDK Employee Expense Tax WORK'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID5 EMPLOYID Employee ID String STR15_Employee_ID 15 6 BKOUTTAX Backout Tax Boolean YN 0 7 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 8 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 9 PAREIMBURSTAXAMT PA Reimbursable Tax Amount Currency PA_DLR17_RBS0_STR$ 17 10 PAORIGREIMTAXAMT PA Originating Reimbursable Tax Amount Currency PA_DLR17_RBS0_STR$ 17 11 FRTTXAMT Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 12 ORFRTTAX Originating Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 13 MSCTXAMT Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 14 ORMSCTAX Originating Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 15 PCTAXAMT Purchases Tax Amount Currency DLR19_RBSO_UTR$ 19 16 ORPURTAX Originating Purchases Tax Amount Currency DLR19_RBSO_UTR$ 19 17 TXDTTPUR Tax Detail Total Purchases Currency DLR19_RBS0_UTR$ 19 18 ORTOTPUR Originating Total Purchases Currency DLR19_RBSO_UTR$ 19 19 TDTTXPUR Tax Detail Total Taxable Purchases Currency DLR19_RBS0_UTR$ 19 20 ORTXBPUR Originating Total Taxable Purchases Currency DLR19_RBSO_UTR$ 19 21 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PDK Employee Expense Tax WORK'].ACTINDX AS 'PDK Employee Expense Tax WORK-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PDK10502 AS ['PDK Employee Expense Tax WORK']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PDK Employee Expense Tax WORK'].ACTINDX = ['Account Index Master'].ACTINDX22 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PDK Employee Expense Tax WORK'].CURRNIDX AS 'PDK Employee Expense Tax WORK-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PDK10502 AS ['PDK Employee Expense Tax WORK']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PDK Employee Expense Tax WORK'].CURRNIDX = ['Currency Setup'].CURRNIDX