Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT005
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_GLTrans_LINE
Physical Name: NCVAT005
Technical Name: NC_GLTrans_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 JRNENTRY 
Journal Entry LI8_U0 Long Integer 8 2 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_GLTrans_LINE'].ACTINDX AS 'NC_GLTrans_LINE-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT005 AS ['NC_GLTrans_LINE']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_GLTrans_LINE'].ACTINDX = ['Account Index Master'].ACTINDX3 SQNCLINE Sequence Line DLR19_$S2 Currency 19 4 DistRef Distribution Reference STR30 String 30 5 TRXAMNT TRX Amount DLR19_$S2 Currency 19 6 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_GLTrans_LINE'].TAXDTLID AS 'NC_GLTrans_LINE-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT005 AS ['NC_GLTrans_LINE']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_GLTrans_LINE'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID7 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 8 NC_Change_Code NC Change Code STR20 String 20 9 NC_Transaction_Status NC Transaction Status INT Integer 0 10 NC_VAT_Treatment NC VAT Treatment NC_VAT_Treatment Integer 0 11 NC_Tax_Base_Amount NC Tax Base Amount DLR19_RBSO_UTR$ Currency 19 12 NC_Rec_Tax_Amount NC Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 13 NC_Recoverable_Rate NC Recoverable Rate NC Recoverable Currency 8 14 DTA_GL_Status DTA GL Status INT1 Integer 1