Enquiry Transactions (CBINT935)

azurecurveProductsCashbook (1058)SystemEnquiry Transactions (CBINT935)

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

Product: Cashbook (1058)
Series: System

Display Name: Enquiry Transactions
Physical Name: CBINT935
Technical Name: CB_INTER_Enquiry

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Intercompany_ID SearchCB_Intercompany_IDSTR5_IC_IDString65
2RcpType SearchReceipt TypeDDL_Document_TypeInteger20
3CB_Func_CTL_AMT SearchCB_Func_CTL_AMTDLR19_RBS0_STR$Currency1019
4CB_Orig_CTL_AMT SearchCB_Orig_CTL_AMTDLR19_RBS0_STR$Currency1019
5CB_Printed_String SearchCB_Printed_StringSTR10String1210
6BACHNUMB SearchBatch NumberSTR15_LBAUString1615
7CB_Period SearchCB_PeriodSTR10String1210
8SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
9CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer24
10CB_Func_Paid_Amt SearchCB_Func_Paid_AmtDLR19_$S2Currency1019
11CB_Func_Received_Amt SearchCB_Func_Received_AmtDLR19_$S2Currency1019
12CB_Orig_Paid_Amt SearchCB_Orig_Paid_AmtDLR19_$S2Currency1019
13CB_Orig_Received_Amt SearchCB_Orig_Received_AmtDLR19_$S2Currency1019
14CB_Status SearchCB_StatusINTInteger20
15CBVoidedCancelled SearchCB_Voided_CancelledSTR20String2220
16CB_Updated SearchCB_UpdatedbooleanBoolean20
17CB_Transaction_Person SearchCB_Transaction_PersonSTR50String5250
18CB_Transaction_Person_Na SearchCB_Transaction_Person_NameSTR30String3230
19INTERID 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
       CBINT935 AS ['Enquiry Transactions']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Enquiry Transactions'].INTERID = ['Company Master'].INTERID
20DEPDATE SearchDeposit DateDTDate48
21depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
22CB_Audit_Trail SearchCB_Audit_TrailSTR15String1615
23CB_Reconciled_Date SearchCB_Reconciled_DateDATEDate46
24CB_Recon_CTL_AMT SearchCB_Recon_CTL_AMTDLR19_RBS0_STR$Currency1019
25CB_Trans_Type SearchCB_Trans_TypeSTR1String21
26CB_Recon_Source SearchCB_Recon_SourceDDLInteger20
27CURRNIDX 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
       CBINT935 AS ['Enquiry Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Enquiry Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX
28CHEKBKID 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
       CBINT935 AS ['Enquiry Transactions']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Enquiry Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
29CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
30DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
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)SystemEnquiry Transactions (CBINT935)

Leave a Reply

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