Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT021
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_GLTrans_HDR
Physical Name: NCVAT021
Technical Name: NC_GLTrans_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 JRNENTRY 
Journal Entry LI8_U0 Long Integer 8 2 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['NC_GLTrans_HDR'].VENDORID AS 'NC_GLTrans_HDR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
NCVAT021 AS ['NC_GLTrans_HDR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['NC_GLTrans_HDR'].VENDORID = ['PM Vendor Master File'].VENDORID3 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['NC_GLTrans_HDR'].TAXSCHID AS 'NC_GLTrans_HDR-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
NCVAT021 AS ['NC_GLTrans_HDR']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['NC_GLTrans_HDR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID