Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB911115
Product: Cashbook (1058)
Series: Financial
Display Name: Payments Import table
Physical Name: CB911115
Technical Name: CB_PM_ImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Print_Cheque_Batch 
CB_Print_Cheque_Batch CB Boolean 0 2 CB_Check_Number_Default CB_Check_Number_Default CB_Check_Number_Default Integer 0 3 CB_Name_Of_Import CB_Name_Of_Import STR100 String 100 4 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Payments Import table'].CHEKBKID AS 'Payments Import table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB911115 AS ['Payments Import table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Payments Import table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID5 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Payments Import table'].CURNCYID AS 'Payments Import table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB911115 AS ['Payments Import table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Payments Import table'].CURNCYID = ['Currency Setup'].CURNCYID6 payment_method payment method payment mothod Integer 0 7 CB_Deposit_Date CB_Deposit_Date DT Date 8 8 CB_Type CB_Type CB_DDL_Type2 Integer 0 9 s CB_Description STR2000 String 200 10 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 11 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 12 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 13 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 14 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 15 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 16 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 17 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 18 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 19 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 20 CB_Type_Description CB_Type_Description STR30 String 30 21 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
['Payments Import table'].TAXSCHID AS 'Payments Import table-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB911115 AS ['Payments Import table']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Payments Import table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID22 CB_File_Path_Name CB_File_Path_Name STR255 String 255 23 CB_Not_In_File_1 CB_Not_In_File[1] CB_Not_In_File Boolean 0 24 CB_Not_In_File_2 CB_Not_In_File[2] CB_Not_In_File Boolean 0 25 CB_Not_In_File_3 CB_Not_In_File[3] CB_Not_In_File Boolean 0 26 CB_Not_In_File_4 CB_Not_In_File[4] CB_Not_In_File Boolean 0 27 CB_Not_In_File_5 CB_Not_In_File[5] CB_Not_In_File Boolean 0 28 CB_Not_In_File_6 CB_Not_In_File[6] CB_Not_In_File Boolean 0 29 CB_Not_In_File_7 CB_Not_In_File[7] CB_Not_In_File Boolean 0 30 CB_Not_In_File_8 CB_Not_In_File[8] CB_Not_In_File Boolean 0 31 CB_Not_In_File_9 CB_Not_In_File[9] CB_Not_In_File Boolean 0 32 CB_Use_If_Blank_1 CB_Use_If_Blank[1] CB_Not_In_File Boolean 0 33 CB_Use_If_Blank_2 CB_Use_If_Blank[2] CB_Not_In_File Boolean 0 34 CB_Use_If_Blank_3 CB_Use_If_Blank[3] CB_Not_In_File Boolean 0 35 CB_Use_If_Blank_4 CB_Use_If_Blank[4] CB_Not_In_File Boolean 0 36 CB_Use_If_Blank_5 CB_Use_If_Blank[5] CB_Not_In_File Boolean 0 37 CB_Use_If_Blank_6 CB_Use_If_Blank[6] CB_Not_In_File Boolean 0 38 CB_Use_If_Blank_7 CB_Use_If_Blank[7] CB_Not_In_File Boolean 0 39 CB_Use_If_Blank_8 CB_Use_If_Blank[8] CB_Not_In_File Boolean 0 40 CB_Use_If_Blank_9 CB_Use_If_Blank[9] CB_Not_In_File Boolean 0