MC Deposit Report table (CB990114)

azurecurveProductsCashbook (1058)FinancialMC Deposit Report table (CB990114)

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

Product: Cashbook (1058)
Series: Financial

Display Name: MC Deposit Report table
Physical Name: CB990114
Technical Name: CB_Deposit_Report

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
2INTERID SearchIntercompany IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['MC Deposit Report table'].INTERID AS 'MC Deposit Report table-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['MC Deposit Report table'].INTERID = ['Company Master'].INTERID
3CB_Audit_Trail SearchCB_Audit_TrailSTR15String15
4USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['MC Deposit Report table'].USERID AS 'MC Deposit Report table-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['MC Deposit Report table'].USERID = ['Users Master'].USERID
5CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['MC Deposit Report table'].CURRNIDX AS 'MC Deposit Report table-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['MC Deposit Report table'].CURRNIDX = ['Currency Setup'].CURRNIDX
6CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer4
7depositnumber SearchDeposit NumberSTR20_Document_NumberString20
8CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString15
9BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency19
10CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['MC Deposit Report table'].CURNCYID AS 'MC Deposit Report table-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['MC Deposit Report table'].CURNCYID = ['Currency Setup'].CURNCYID
11CB_Checkbook_Currency SearchCB_Checkbook_CurrencySTR15_Currency_IDString15
12BACHDATE SearchBatch DateDTDate8
13BCHCOMNT SearchBatch CommentSTR60String60
14RATECALC SearchRate Calc MethodINTInteger0
15CB_Cancelled_Check SearchCB_Cancelled_CheckCB_Canceled_CheckBoolean0
16CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
17CB_Type SearchCB_TypeCB_DDL_Type2Integer0
18CB_Payee SearchCB_PayeeSTR40String40
19DSCRIPTN SearchDescriptionSTR30String30
20DATE1 SearchDateDT6Date6
21EXCHDATE SearchExchange DateDT_DateDate6
22EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['MC Deposit Report table'].EXGTBLID AS 'MC Deposit Report table-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['MC Deposit Report table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
23XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
24RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['MC Deposit Report table'].RATETPID AS 'MC Deposit Report table-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['MC Deposit Report table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
25CB_Type_Description SearchCB_Type_DescriptionSTR30String30
26ACTNUMST SearchAccount Number StringSTR128_LBUString128
27CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
28CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger0
29CB_Deposit_Total SearchCB_Deposit_TotalDLR19_RBS0_STR$Currency19
30CB_Functional_Dist SearchCB_Functional_DistDLR19_RBS0_STR$Currency19
31CB_Functional_Tax SearchCB_Functional_TaxDLR19_RBS0_STR$Currency19
32CB_Check_Dist SearchCB_Check_DistDLR19_RBS0_STR$Currency19
33CB_Check_Tax SearchCB_Check_TaxDLR19_RBS0_STR$Currency19
34CB_Transaction_Dist SearchCB_Transaction_DistDLR19_RBS0_STR$Currency19
35CB_Transaction_Tax SearchCB_Transaction_TaxDLR19_RBS0_STR$Currency19
36TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['MC Deposit Report table'].TAXSCHID AS 'MC Deposit Report table-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['MC Deposit Report table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
37CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['MC Deposit Report table'].CHEKBKID AS 'MC Deposit Report table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB990114 AS ['MC Deposit Report table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['MC Deposit Report table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
38BACHNUMB SearchBatch NumberSTR15_LBAUString15
azurecurveProductsCashbook (1058)FinancialMC Deposit Report table (CB990114)

Leave a Reply

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