Payments Report (CB991115)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB991115

Product: Cashbook (1058)
Series: Financial

Display Name: Payments Report
Physical Name: CB991115
Technical Name: CB_Payments_Report

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
2CB_Trans_Option SearchCB_Trans_OptionCB_DDL_OptionInteger20
3payment_method Searchpayment methodpayment mothodInteger20
4INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Payments Report'].INTERID AS 'Payments Report-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Payments Report'].INTERID = ['Company Master'].INTERID
5CB_Audit_Trail SearchCB_Audit_TrailSTR15String1615
6USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payments Report'].USERID AS 'Payments Report-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payments Report'].USERID = ['Users Master'].USERID
7CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Payments Report'].CURRNIDX AS 'Payments Report-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Payments Report'].CURRNIDX = ['Currency Setup'].CURRNIDX
8CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer24
9BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency1019
10CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Payments Report'].CURNCYID AS 'Payments Report-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Payments Report'].CURNCYID = ['Currency Setup'].CURNCYID
11CB_Checkbook_Currency SearchCB_Checkbook_CurrencySTR15_Currency_IDString1615
12BACHDATE SearchBatch DateDTDate48
13BCHCOMNT SearchBatch CommentSTR60String6260
14RATECALC SearchRate Calc MethodINTInteger20
15CB_Cancelled_Check SearchCB_Cancelled_CheckCB_Canceled_CheckBoolean20
16CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
17CB_Type SearchCB_TypeCB_DDL_Type2Integer20
18CB_Payee SearchCB_PayeeSTR40String4240
19DSCRIPTN SearchDescriptionSTR30String3230
20DATE1 SearchDateDT6Date46
21EXCHDATE SearchExchange DateDT_DateDate46
22EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Payments Report'].EXGTBLID AS 'Payments Report-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Payments Report'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
23XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
24RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Payments Report'].RATETPID AS 'Payments Report-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Payments Report'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
25CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
26CB_Line_No SearchCB_Line_NoSTR10String1210
27ACTNUMST SearchAccount Number StringSTR128_LBUString130128
28CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
29CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger20
30CB_Check_Total SearchCB_Check_TotalDLR19_RBS0_UTR$Currency1019
31CB_Functional_Dist SearchCB_Functional_DistDLR19_RBS0_STR$Currency1019
32CB_Functional_Tax SearchCB_Functional_TaxDLR19_RBS0_STR$Currency1019
33CB_Check_Dist SearchCB_Check_DistDLR19_RBS0_STR$Currency1019
34CB_Check_Tax SearchCB_Check_TaxDLR19_RBS0_STR$Currency1019
35CB_Transaction_Dist SearchCB_Transaction_DistDLR19_RBS0_STR$Currency1019
36CB_Transaction_Tax SearchCB_Transaction_TaxDLR19_RBS0_STR$Currency1019
37TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Payments Report'].TAXSCHID AS 'Payments Report-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Payments Report'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
38CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Payments Report'].CHEKBKID AS 'Payments Report-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB991115 AS ['Payments Report']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Payments Report'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
39BACHNUMB SearchBatch NumberSTR15_LBAUString1615

Leave a Reply

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