History Recon Cheque Header (CB999004)

azurecurveProductsCashbook (1058)FinancialHistory Recon Cheque Header (CB999004)

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

Product: Cashbook (1058)
Series: Financial

Display Name: History Recon Cheque Header
Physical Name: CB999004
Technical Name: CB_History_Check_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Audit_Trail SearchCB_Audit_TrailSTR15String1615
2CB_Voided SearchCB_VoidedBooleanBoolean20
3CB_Cancelled_Check SearchCB_Cancelled_CheckCB_Canceled_CheckBoolean20
4CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
5CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger20
6CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].CHEKBKID AS 'History Recon Cheque Header-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['History Recon Cheque Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
7CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].CURRNIDX AS 'History Recon Cheque Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['History Recon Cheque Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
8CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].CURNCYID AS 'History Recon Cheque Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['History Recon Cheque Header'].CURNCYID = ['Currency Setup'].CURNCYID
9EXCHDATE SearchExchange DateDT_DateDate46
10XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
11RATECALC SearchRate Calc MethodINTInteger20
12RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].RATETPID AS 'History Recon Cheque Header-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['History Recon Cheque Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
13TIME1 SearchTimeTM6Time46
14CB_Line_No SearchCB_Line_NoSTR10String1210
15BACHNUMB SearchBatch NumberSTR15_LBAUString1615
16CB_Trans_Option SearchCB_Trans_OptionCB_DDL_OptionInteger20
17payment_method Searchpayment methodpayment mothodInteger20
18DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
19CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
20CB_Deposit_Date SearchCB_Deposit_DateDTDate48
21CB_Type SearchCB_TypeCB_DDL_Type2Integer20
22CB_Payee SearchCB_PayeeSTR40String4240
23VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].VENDORID AS 'History Recon Cheque Header-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['History Recon Cheque Header'].VENDORID = ['PM Vendor Master File'].VENDORID
24CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
25DSCRIPTN SearchDescriptionSTR30String3230
26EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['History Recon Cheque Header'].EXGTBLID AS 'History Recon Cheque Header-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB999004 AS ['History Recon Cheque Header']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['History Recon Cheque Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
27CB_Check_Amount SearchCB_Check_AmountDLR19_RBS0_UTR$Currency1019
28CB_Check_Total SearchCB_Check_TotalDLR19_RBS0_UTR$Currency1019
azurecurveProductsCashbook (1058)FinancialHistory Recon Cheque Header (CB999004)

Leave a Reply

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