Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT603
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_TaxReturnDetail_DetailDocDetail
Physical Name: NCVAT603
Technical Name: NC_TaxReturnDetail_DetailDocDetailSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID STR20_LBAU String 20 2 DOCNUMBR Document Number STR20_Document_Number String 20 3 DOCTYPE Document Type DDL_Document_Type Integer 0 4 NC_Original_Series NC Original Series INT Integer 0 5 RCTRXSEQ Recurring TRX Sequence 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_TaxReturnDetail_DetailDocDetail'].TAXDTLID AS 'NC_TaxReturnDetail_DetailDocDetail-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT603 AS ['NC_TaxReturnDetail_DetailDocDetail']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_TaxReturnDetail_DetailDocDetail'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID7 VOIDSTTS Void Status INT Integer 0 8 SQNCLINE Sequence Line DLR19_$S2 Currency 19 9 NC_Destination_Tax_Detai NC Destination Tax Detail ID STR15_Tax_Detail_ID String 15 10 SGMTNUMB Segment Number INT2 Integer 2 11 SGMNTID Segment ID STR66_Seg_ID String 66 12 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_TaxReturnDetail_DetailDocDetail'].ACTINDX AS 'NC_TaxReturnDetail_DetailDocDetail-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT603 AS ['NC_TaxReturnDetail_DetailDocDetail']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_TaxReturnDetail_DetailDocDetail'].ACTINDX = ['Account Index Master'].ACTINDX13 DOCDATE Document Date DT Date 8 14 DistRef Distribution Reference STR30 String 30 15 TRXAMNT TRX Amount DLR19_$S2 Currency 19 16 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 17 NC_Change_Code NC Change Code STR20 String 20 18 NC_Transaction_Status NC Transaction Status INT Integer 0 19 NC_VAT_Treatment NC VAT Treatment NC_VAT_Treatment Integer 0 20 NC_Recoverable_Rate NC Recoverable Rate NC Recoverable Currency 8 21 NC_Tax_Base_Amount NC Tax Base Amount DLR19_RBSO_UTR$ Currency 19 22 NC_Rec_Tax_Amount NC Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 23 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['NC_TaxReturnDetail_DetailDocDetail'].VENDORID AS 'NC_TaxReturnDetail_DetailDocDetail-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
NCVAT603 AS ['NC_TaxReturnDetail_DetailDocDetail']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['NC_TaxReturnDetail_DetailDocDetail'].VENDORID = ['PM Vendor Master File'].VENDORID24 Tax_Date Tax Date DT Date 8 25 PSTGDATE Posting Date DT Date 8 26 NC_POT_Amount NC POT Amount DLR19_RBSO_UTR$ Currency 19 27 REFRENCE Reference STR30 String 30