Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVIM100
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_VATImport_HDR_INTF
Physical Name: NCVIM100
Technical Name: NC_VATImport_HDR_INTFSeq 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_INTF'].SOURCDOC AS 'NC_VATImport_HDR_INTF-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCVIM100 AS ['NC_VATImport_HDR_INTF']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_VATImport_HDR_INTF'].SOURCDOC = ['Source Document Master'].SOURCDOC
9 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_INTF'].CURNCYID AS 'NC_VATImport_HDR_INTF-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCVIM100 AS ['NC_VATImport_HDR_INTF']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_VATImport_HDR_INTF'].CURNCYID = ['Currency Setup'].CURNCYID
11 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_INTF'].VENDORID AS 'NC_VATImport_HDR_INTF-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
NCVIM100 AS ['NC_VATImport_HDR_INTF']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['NC_VATImport_HDR_INTF'].VENDORID = ['PM Vendor Master File'].VENDORID
13 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_INTF'].TAXSCHID AS 'NC_VATImport_HDR_INTF-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
NCVIM100 AS ['NC_VATImport_HDR_INTF']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['NC_VATImport_HDR_INTF'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
14 NC_Tax_Required NC Tax Required Boolean Boolean 0