History Recon Deposit Transaction (CB333555)

azurecurveProductsCashbook (1058)FinancialHistory Recon Deposit Transaction (CB333555)

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

Product: Cashbook (1058)
Series: Financial

Display Name: History Recon Deposit Transaction
Physical Name: CB333555
Technical Name: CB_History_Deposit_TRN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
2CB_Voided SearchCB_VoidedBooleanBoolean0
3INTERID SearchIntercompany IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].INTERID AS 'History Recon Deposit Transaction-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['History Recon Deposit Transaction'].INTERID = ['Company Master'].INTERID
4CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].CMPANYID AS 'History Recon Deposit Transaction-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['History Recon Deposit Transaction'].CMPANYID = ['Company Master'].CMPANYID
5CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
6CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger0
7CB_Exc_Inc SearchCB_Exc_IncDDLInteger0
8BANKNAME SearchBank NameSTR30String30
9CB_Branch_Number SearchCB_Branch_NumberSTR12String12
10CB_Trans_Type SearchCB_Trans_TypeSTR1String1
11CRCARDID SearchCredit Card IDSTR15String15
12CRCRDNUM SearchCredit Card NumberSTR20String20
13CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
14CB_Vat_Account_Number_1 SearchCB_Vat_Account_Number:Account_Segment_Pool1Account_Segment_Pool1String6
15CB_Vat_Account_Number_2 SearchCB_Vat_Account_Number:Account_Segment_Pool2Account_Segment_Pool2String6
16CB_Vat_Account_Number_3 SearchCB_Vat_Account_Number:Account_Segment_Pool3Account_Segment_Pool3String6
17CB_Vat_Account_Number_4 SearchCB_Vat_Account_Number:Account_Segment_Pool4Account_Segment_Pool4String6
18CB_Vat_Account_Number_5 SearchCB_Vat_Account_Number:Account_Segment_Pool5Account_Segment_Pool5String6
19CB_Vat_Account_Number_6 SearchCB_Vat_Account_Number:Account_Segment_Pool6Account_Segment_Pool6String6
20CB_Vat_Account_Number_7 SearchCB_Vat_Account_Number:Account_Segment_Pool7Account_Segment_Pool7String6
21CB_Vat_Account_Number_8 SearchCB_Vat_Account_Number:Account_Segment_Pool8Account_Segment_Pool8String6
22CB_Vat_Account_Number_9 SearchCB_Vat_Account_Number:Account_Segment_Pool9Account_Segment_Pool9String6
23CB_Vat_Account_Number_10 SearchCB_Vat_Account_Number:Account_Segment_Pool10Account_Segment_Pool10String6
24CB_Vat_Account_Index SearchCB_Vat_Account_IndexLI_14Long Integer14
25TIME1 SearchTimeTM6Time6
26RATECALC SearchRate Calc MethodINTInteger0
27EXPNDATE SearchExpiration DateDT_DateDate6
28RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].RATETPID AS 'History Recon Deposit Transaction-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['History Recon Deposit Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
29EXCHDATE SearchExchange DateDT_DateDate6
30BACHNUMB SearchBatch NumberSTR15_LBAUString15
31EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].EXGTBLID AS 'History Recon Deposit Transaction-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['History Recon Deposit Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
32XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
33payment_method Searchpayment methodpayment mothodInteger0
34DATE1 SearchDateDT6Date6
35CB_Type_Description SearchCB_Type_DescriptionSTR30String30
36ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
37ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
38ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
39ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
40ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
41ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
42ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
43ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
44ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
45ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
46ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].ACTINDX AS 'History Recon Deposit Transaction-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['History Recon Deposit Transaction'].ACTINDX = ['Account Index Master'].ACTINDX
47TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].TAXSCHID AS 'History Recon Deposit Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['History Recon Deposit Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
48CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
49CB_Type SearchCB_TypeCB_DDL_Type2Integer0
50CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['History Recon Deposit Transaction'].CUSTNMBR AS 'History Recon Deposit Transaction-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CB333555 AS ['History Recon Deposit Transaction']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['History Recon Deposit Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
51CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
52CB_Payer SearchCB_PayerSTR40String40
53ADDRESS1 SearchAddress 1STR60String60
54ADDRESS2 SearchAddress 2STR60String60
55ADDRES1 SearchAddress1STR25String25
56ADDRES2 SearchAddress2STR25String25
57CB_Tel_No SearchCB_Tel_NoSTR15String15
58Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency19
59depositnumber SearchDeposit NumberSTR20_Document_NumberString20
60CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString15
azurecurveProductsCashbook (1058)FinancialHistory Recon Deposit Transaction (CB333555)

Leave a Reply

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