Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM90000
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM Transmission Log
Physical Name: CM90000
Technical Name: cmTransmissionLogSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 FILENAME 
File Name String STR45 45 2 EFTFileStatus EFTFileStatus Integer DDL_EFTFileStatus 0 3 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CM Transmission Log'].CHEKBKID AS 'CM Transmission Log-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM90000 AS ['CM Transmission Log']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM Transmission Log'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID4 TIME1 Time Time TM6 6 5 FilePath FilePath String STR255 255 6 EFTFileType EFTFileType Integer DDL_EFTFileType 0 7 EFTTransmissionType EFTTransmissionType Integer DDL_EFTTransmissionType 0 8 EFTFileGeneratedDate EFTFileGeneratedDate Date DATE_L 0 9 EFTFileGeneratedUserID EFTFileGeneratedUserID String User_ID 15 10 EFTFileSentDate EFTFileSentDate Date DATE 6 11 EFTFileSentUserID EFTFileSentUserID String User_ID 15