Recon Receipts Transaction (CB330222)

azurecurveProductsCashbook (1058)FinancialRecon Receipts Transaction (CB330222)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Recon Receipts Transaction
Physical Name: CB330222
Technical Name: CB_Recon_Cash_Rec_TRN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CB_Audit_Trail SearchCB_Audit_TrailSTR15String15
2CB_Voided SearchCB_VoidedBooleanBoolean0
3CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].CURRNIDX AS 'Recon Receipts Transaction-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Recon Receipts Transaction'].CURRNIDX = ['Currency Setup'].CURRNIDX
4CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer4
5CB_Cash_Rec_Batch_Number SearchCB_Cash_Rec_Batch_NumberSTR30String30
6CB_Checkbook_Currency SearchCB_Checkbook_CurrencySTR15_Currency_IDString15
7CB_Printed SearchCB_PrintedbooleanBoolean0
8USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].USERID AS 'Recon Receipts Transaction-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Recon Receipts Transaction'].USERID = ['Users Master'].USERID
9CB_Receipt_Total SearchCB_Receipt_TotalDLR19_RBS0_STR$Currency19
10CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].CURNCYID AS 'Recon Receipts Transaction-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Recon Receipts Transaction'].CURNCYID = ['Currency Setup'].CURNCYID
11CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
12CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger0
13CB_Exc_Inc SearchCB_Exc_IncDDLInteger0
14CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].CHEKBKID AS 'Recon Receipts Transaction-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Recon Receipts Transaction'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
15BANKNAME SearchBank NameSTR30String30
16CB_Trans_Type SearchCB_Trans_TypeSTR1String1
17CRCARDID SearchCredit Card IDSTR15String15
18CRCRDNUM SearchCredit Card NumberSTR20String20
19CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
20CB_Branch_Number SearchCB_Branch_NumberSTR12String12
21CB_Vat_Account_Number_1 SearchCB_Vat_Account_Number:Account_Segment_Pool1Account_Segment_Pool1String6
22CB_Vat_Account_Number_2 SearchCB_Vat_Account_Number:Account_Segment_Pool2Account_Segment_Pool2String6
23CB_Vat_Account_Number_3 SearchCB_Vat_Account_Number:Account_Segment_Pool3Account_Segment_Pool3String6
24CB_Vat_Account_Number_4 SearchCB_Vat_Account_Number:Account_Segment_Pool4Account_Segment_Pool4String6
25CB_Vat_Account_Number_5 SearchCB_Vat_Account_Number:Account_Segment_Pool5Account_Segment_Pool5String6
26CB_Vat_Account_Number_6 SearchCB_Vat_Account_Number:Account_Segment_Pool6Account_Segment_Pool6String6
27CB_Vat_Account_Number_7 SearchCB_Vat_Account_Number:Account_Segment_Pool7Account_Segment_Pool7String6
28CB_Vat_Account_Number_8 SearchCB_Vat_Account_Number:Account_Segment_Pool8Account_Segment_Pool8String6
29CB_Vat_Account_Number_9 SearchCB_Vat_Account_Number:Account_Segment_Pool9Account_Segment_Pool9String6
30CB_Vat_Account_Number_10 SearchCB_Vat_Account_Number:Account_Segment_Pool10Account_Segment_Pool10String6
31CB_Vat_Account_Index SearchCB_Vat_Account_IndexLI_14Long Integer14
32TIME1 SearchTimeTM6Time6
33RATECALC SearchRate Calc MethodINTInteger0
34EXPNDATE SearchExpiration DateDT_DateDate6
35RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].RATETPID AS 'Recon Receipts Transaction-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Recon Receipts Transaction'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
36EXCHDATE SearchExchange DateDT_DateDate6
37EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].EXGTBLID AS 'Recon Receipts Transaction-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Recon Receipts Transaction'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
38XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
39payment_method Searchpayment methodpayment mothodInteger0
40DATE1 SearchDateDT6Date6
41PSTGDATE SearchPosting DateDTDate8
42CB_Type_Description SearchCB_Type_DescriptionSTR30String30
43ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
44ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
45ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
46ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
47ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
48ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
49ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
50ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
51ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
52ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
53ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].TAXSCHID AS 'Recon Receipts Transaction-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Recon Receipts Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
55TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].TAXDTLID AS 'Recon Receipts Transaction-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['Recon Receipts Transaction'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
56CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
57CB_Type SearchCB_TypeCB_DDL_Type2Integer0
58CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Recon Receipts Transaction'].CUSTNMBR AS 'Recon Receipts Transaction-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CB330222 AS ['Recon Receipts Transaction']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Recon Receipts Transaction'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
59CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
60CB_Payer SearchCB_PayerSTR40String40
61CB_Tel_No SearchCB_Tel_NoSTR15String15
62Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency19
63CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString15
azurecurveProductsCashbook (1058)FinancialRecon Receipts Transaction (CB330222)

Leave a Reply

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