Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVIM200
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_VATImport_HDR_SAVE
Physical Name: NCVIM200
Technical Name: NC_VATImport_HDR_SAVESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NC_Reference_ID 
NC Reference ID STR50 String 50 2 NC_Status NC Status INT1 Integer 1 3 JRNENTRY Journal Entry LI8_U0 Long Integer 8 4 BACHNUMB Batch Number STR15_LBAU String 15 5 TRXDATE TRX Date DT_Date Date 6 6 DOCDATE Document Date DT Date 8 7 Tax_Date Tax Date DT Date 8 8 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['NC_VATImport_HDR_SAVE'].SOURCDOC AS 'NC_VATImport_HDR_SAVE-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCVIM200 AS ['NC_VATImport_HDR_SAVE']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_VATImport_HDR_SAVE'].SOURCDOC = ['Source Document Master'].SOURCDOC9 REFRENCE Reference STR30 String 30 10 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_VATImport_HDR_SAVE'].CURNCYID AS 'NC_VATImport_HDR_SAVE-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCVIM200 AS ['NC_VATImport_HDR_SAVE']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_VATImport_HDR_SAVE'].CURNCYID = ['Currency Setup'].CURNCYID11 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 12 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['NC_VATImport_HDR_SAVE'].VENDORID AS 'NC_VATImport_HDR_SAVE-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
NCVIM200 AS ['NC_VATImport_HDR_SAVE']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['NC_VATImport_HDR_SAVE'].VENDORID = ['PM Vendor Master File'].VENDORID13 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_VATImport_HDR_SAVE'].TAXSCHID AS 'NC_VATImport_HDR_SAVE-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
NCVIM200 AS ['NC_VATImport_HDR_SAVE']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['NC_VATImport_HDR_SAVE'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID14 NC_Tax_Required NC Tax Required Boolean Boolean 0