Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS00200
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Creditor Master File
Physical Name: CIS00200
Technical Name: CIS_Vendor_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
CIS00200 AS ['CIS Creditor Master File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CIS Creditor Master File'].VENDORID = ['PM Vendor Master File'].VENDORID2 CISDOC CIS Document Type DDL_CIS_Verification Status Integer 0 3 CISREGNBR CIS Registration Number STR13_LBAU String 13 4 CISSTRTDT CIS Start Date DT Date 8 5 CISEXPDT CIS Expiry Date DT Date 8 6 SOCSCNUM Social Security Number STR15_Social_Security_Number String 15 7 CISCMPNYNBR CIS Company Number STR9_LBN String 9 8 CISREPNAME CIS Representative Name STR16_LBA String 16 9 CISCONNAME CIS Name of Concern STR26_LBA String 26 10 CISTRDAS CIS Trading As STR26_LBA String 26 11 CISINSPBY CIS Inspected By STR16_LBA String 16 12 CISINSPDT CIS Inspection Date DT Date 8 13 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
CIS00200 AS ['CIS Creditor Master File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CIS Creditor Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX