Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT26
Product: VAT Daybook (3096)
Series:
Display Name: vatDaybookITCCalculationTemp
Physical Name: EDCVAT26
Technical Name: vatDaybookITCCalculationTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 vatDbkModule_ID 
vatDbkModule_ID String STR6 6 2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 DOCNUMBR Document Number String STR20_Document_Number 20 4 vatDbkCurr_ITC_Amt vatDbkCurr_ ITC_ Amt Currency DLR19_$S2 19 5 vatDbkITCClaimRate vatDbkITCClaimRate Currency DLR5_%2 8 6 vatDbkVaried_ITC_Amt vatDbkVaried_ITC_Amt Currency DLR19_$S2 19 7 CustomerVendor_ID Customer/Vendor ID String STR15 15 8 Tax_Date Tax Date Date DT 8 9 DOCDATE Document Date Date DT 8 10 PSTGDATE Posting Date Date DT 8 11 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['vatDaybookITCCalculationTemp'].TAXDTLID AS 'vatDaybookITCCalculationTemp-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT26 AS ['vatDaybookITCCalculationTemp']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['vatDaybookITCCalculationTemp'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID12 VOIDSTTS Void Status Integer INT 0