Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR035
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Statement_Document_TEMP
Physical Name: NCABR035
Technical Name: NC_Statement_Document_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['NC_Statement_Document_TEMP'].USERID AS 'NC_Statement_Document_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Statement_Document_TEMP'].USERID = ['Users Master'].USERID2 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 3 MKDTOPST Marked To Post CB Boolean 0 4 DOCTYPE Document Type DDL_Document_Type Integer 0 5 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_Statement_Document_TEMP'].ACTINDX AS 'NC_Statement_Document_TEMP-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Statement_Document_TEMP'].ACTINDX = ['Account Index Master'].ACTINDX6 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['NC_Statement_Document_TEMP'].CUSTNMBR AS 'NC_Statement_Document_TEMP-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['NC_Statement_Document_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['NC_Statement_Document_TEMP'].VENDORID AS 'NC_Statement_Document_TEMP-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['NC_Statement_Document_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID8 REFRENCE Reference STR30 String 30 9 CHEKNMBR Check Number STR20_Document_Number String 20 10 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 11 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_Statement_Document_TEMP'].TAXDTLID AS 'NC_Statement_Document_TEMP-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_Statement_Document_TEMP'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID12 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 13 PSTGSTUS Posting Status INT Integer 0 14 DOCNUMBR Document Number STR20_Document_Number String 20 15 BANKID Bank ID STR15_Bank_ID String 15 16 NC_Trx_Date NC_Trx_Date DATE Date 6 17 NC_Trx_Type NC_Trx_Type STR9 String 9 18 NC_Reference NC_Reference STR30 String 30 19 NC_BL_Amount NC_BL_Amount NC_BL_Amount Currency 15 20 NCCHQNUM NC_Cheque_Number STR20_Document_Number String 20 21 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 22 NC_Statement_Number NC_Statement_Number Long Int Long Integer 8