Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT121
Product: Advanced VAT (2474)
Series: Purchasing
Display Name: NC_POP_Line_BETA
Physical Name: NCVAT121
Technical Name: NC_POP_Line_BETASeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NC_POP_Doc_Type 
NC POP Doc Type INT Integer 0 2 POPRCTNM POP Receipt Number STR17_POP_Number String 17 3 RCPTLNNM Receipt Line Number LI_Sequence_Number Long Integer 10 4 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_POP_Line_BETA'].TAXDTLID AS 'NC_POP_Line_BETA-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT121 AS ['NC_POP_Line_BETA']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_POP_Line_BETA'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID5 TRXAMNT TRX Amount DLR19_$S2 Currency 19 6 Originating_TRX_Amount Originating TRX Amount DLR17_RBSO_UTR$ Currency 17 7 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 8 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 9 NC_Change_Code NC Change Code STR20 String 20 10 NC_VAT_Treatment NC VAT Treatment NC_VAT_Treatment Integer 0 11 NC_Transaction_Status NC Transaction Status INT Integer 0 12 NC_Recoverable_Rate NC Recoverable Rate NC Recoverable Currency 8 13 NC_Tax_Base_Amount NC Tax Base Amount DLR19_RBSO_UTR$ Currency 19 14 NC_Originating_Tax_Base_ NC Originating Tax Base Amount DLR19_RBSO_UTR$ Currency 19 15 NC_Rec_Tax_Amount NC Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 16 NC_Originating_Rec_Tax_A NC Originating Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 17 NC_Unit_TRX_Amount NC Unit TRX Amount DLR19_RBSO_UTR$ Currency 19 18 NC_Originating_Unit_TRX_ NC Originating Unit TRX Amount DLR19_RBSO_UTR$ Currency 19 19 NC_Capital_Item_Message_ NC Capital Item Message Given boolean Boolean 0 20 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 17 21 ODISAMTAV Originating Discount Amount Available DLR17_RBS0_UTR$ Currency 17