Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS00201
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Creditor Master File
Physical Name: CIS00201
Technical Name: CIS_Vendor_2007_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CIS Creditor Master File'].VENDORID AS 'CIS Creditor Master File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CIS00201 AS ['CIS Creditor Master File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CIS Creditor Master File'].VENDORID = ['PM Vendor Master File'].VENDORID2 CISVerificationStatus CISVerificationStatus DDL_CIS_Verification_Status Integer 0 3 CISREGNBR CIS Registration Number STR13_LBAU String 13 4 SOCSCNUM Social Security Number STR15_Social_Security_Number String 15 5 CISCMPNYNBR CIS Company Number STR9_LBN String 9 6 CIS_Unique_Tax_Reference CIS Unique Tax Reference STR16_LBA String 16 7 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CIS Creditor Master File'].NOTEINDX AS 'CIS Creditor Master File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CIS00201 AS ['CIS Creditor Master File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CIS Creditor Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX