Enquiry Transactions (CB900035)

azurecurveProductsCashbook (1058)FinancialEnquiry Transactions (CB900035)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Enquiry Transactions
Physical Name: CB900035
Technical Name: CB_Enquiry

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RcpType SearchReceipt TypeDDL_Document_TypeInteger20
2CB_Func_CTL_AMT SearchCB_Func_CTL_AMTDLR19_RBS0_STR$Currency1019
3CB_Orig_CTL_AMT SearchCB_Orig_CTL_AMTDLR19_RBS0_STR$Currency1019
4CB_Printed_String SearchCB_Printed_StringSTR10String1210
5BACHNUMB SearchBatch NumberSTR15_LBAUString1615
6CB_Period SearchCB_PeriodSTR10String1210
7SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
8CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer24
9CB_Func_Paid_Amt SearchCB_Func_Paid_AmtDLR19_$S2Currency1019
10CB_Func_Received_Amt SearchCB_Func_Received_AmtDLR19_$S2Currency1019
11CB_Orig_Paid_Amt SearchCB_Orig_Paid_AmtDLR19_$S2Currency1019
12CB_Orig_Received_Amt SearchCB_Orig_Received_AmtDLR19_$S2Currency1019
13CB_Status SearchCB_StatusINTInteger20
14CBVoidedCancelled SearchCB_Voided_CancelledSTR20String2220
15CB_Updated SearchCB_UpdatedbooleanBoolean20
16CB_Transaction_Person SearchCB_Transaction_PersonSTR50String5250
17CB_Transaction_Person_Na SearchCB_Transaction_Person_NameSTR30String3230
18INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Enquiry Transactions'].INTERID AS 'Enquiry Transactions-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB900035 AS ['Enquiry Transactions']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Enquiry Transactions'].INTERID = ['Company Master'].INTERID
19DEPDATE SearchDeposit DateDTDate48
20depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
21CB_Audit_Trail SearchCB_Audit_TrailSTR15String1615
22CB_Reconciled_Date SearchCB_Reconciled_DateDATEDate46
23CB_Recon_CTL_AMT SearchCB_Recon_CTL_AMTDLR19_RBS0_STR$Currency1019
24CB_Trans_Type SearchCB_Trans_TypeSTR1String21
25CB_Recon_Source SearchCB_Recon_SourceDDLInteger20
26CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Enquiry Transactions'].CURRNIDX AS 'Enquiry Transactions-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB900035 AS ['Enquiry Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Enquiry Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX
27CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Enquiry Transactions'].CHEKBKID AS 'Enquiry Transactions-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB900035 AS ['Enquiry Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Enquiry Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
28CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
29CB_Type SearchCB_TypeCB_DDL_Type2Integer20
30CB_Document_Number_25 SearchCB_Document_Number_25CB_Document_Number_25String2625
31DATE1 SearchDateDT6Date46
32CB_Recon_Paid_AMT SearchCB_Recon_Paid_AMTDLR19_RBS0_UTR$Currency1019
33CB_Recon_Received_AMT SearchCB_Recon_Received_AMTDLR19_RBS0_UTR$Currency1019
azurecurveProductsCashbook (1058)FinancialEnquiry Transactions (CB900035)

Leave a Reply

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