Payments Import table (CB911115)

azurecurveProductsCashbook (1058)FinancialPayments Import table (CB911115)

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_Import

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Print_Cheque_Batch SearchCB_Print_Cheque_BatchCBBoolean20
2CB_Check_Number_Default SearchCB_Check_Number_DefaultCB_Check_Number_DefaultInteger20
3CB_Name_Of_Import SearchCB_Name_Of_ImportSTR100String102100
4CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
5CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
6payment_method Searchpayment methodpayment mothodInteger20
7CB_Deposit_Date SearchCB_Deposit_DateDTDate48
8CB_Type SearchCB_TypeCB_DDL_Type2Integer20
9s SearchCB_DescriptionSTR2000String202200
10ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
11ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
12ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
13ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
14ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
15ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
16ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
17ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
18ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
19ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
20CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
21TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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'].TAXSCHID
22CB_File_Path_Name SearchCB_File_Path_NameSTR255String256255
23CB_Not_In_File_1 SearchCB_Not_In_File[1]CB_Not_In_FileBoolean20
24CB_Not_In_File_2 SearchCB_Not_In_File[2]CB_Not_In_FileBoolean20
25CB_Not_In_File_3 SearchCB_Not_In_File[3]CB_Not_In_FileBoolean20
26CB_Not_In_File_4 SearchCB_Not_In_File[4]CB_Not_In_FileBoolean20
27CB_Not_In_File_5 SearchCB_Not_In_File[5]CB_Not_In_FileBoolean20
28CB_Not_In_File_6 SearchCB_Not_In_File[6]CB_Not_In_FileBoolean20
29CB_Not_In_File_7 SearchCB_Not_In_File[7]CB_Not_In_FileBoolean20
30CB_Not_In_File_8 SearchCB_Not_In_File[8]CB_Not_In_FileBoolean20
31CB_Not_In_File_9 SearchCB_Not_In_File[9]CB_Not_In_FileBoolean20
32CB_Use_If_Blank_1 SearchCB_Use_If_Blank[1]CB_Not_In_FileBoolean20
33CB_Use_If_Blank_2 SearchCB_Use_If_Blank[2]CB_Not_In_FileBoolean20
34CB_Use_If_Blank_3 SearchCB_Use_If_Blank[3]CB_Not_In_FileBoolean20
35CB_Use_If_Blank_4 SearchCB_Use_If_Blank[4]CB_Not_In_FileBoolean20
36CB_Use_If_Blank_5 SearchCB_Use_If_Blank[5]CB_Not_In_FileBoolean20
37CB_Use_If_Blank_6 SearchCB_Use_If_Blank[6]CB_Not_In_FileBoolean20
38CB_Use_If_Blank_7 SearchCB_Use_If_Blank[7]CB_Not_In_FileBoolean20
39CB_Use_If_Blank_8 SearchCB_Use_If_Blank[8]CB_Not_In_FileBoolean20
40CB_Use_If_Blank_9 SearchCB_Use_If_Blank[9]CB_Not_In_FileBoolean20
azurecurveProductsCashbook (1058)FinancialPayments Import table (CB911115)

Leave a Reply

Your email address will not be published. Required fields are marked *