Check Header (CB770002)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Check Header
Physical Name: CB770002
Technical Name: CB_Check_HDR

Group Display Name: Bank Management
Group Technical Name: Bank Management

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EXPNDATE SearchExpiration DateDT_DateDate6
2CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
3CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger0
4CB_Cancelled_Check SearchCB_Cancelled_CheckCB_Canceled_CheckBoolean0
5CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Check Header'].CHEKBKID AS 'Check Header-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Check Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
6CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Check Header'].CURRNIDX AS 'Check Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Check Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
7CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Check Header'].CURNCYID AS 'Check Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Check Header'].CURNCYID = ['Currency Setup'].CURNCYID
8EXCHDATE SearchExchange DateDT_DateDate6
9XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
10RATECALC SearchRate Calc MethodINTInteger0
11RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Check Header'].RATETPID AS 'Check Header-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Check Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
12TIME1 SearchTimeTM6Time6
13CB_Line_No SearchCB_Line_NoSTR10String10
14BACHNUMB SearchBatch NumberSTR15_LBAUString15
15CB_Trans_Option SearchCB_Trans_OptionCB_DDL_OptionInteger0
16payment_method Searchpayment methodpayment mothodInteger0
17DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
18CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
19CB_Deposit_Date SearchCB_Deposit_DateDTDate8
20CB_Type SearchCB_TypeCB_DDL_Type2Integer0
21CB_Payee SearchCB_PayeeSTR40String40
22VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Check Header'].VENDORID AS 'Check Header-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Check Header'].VENDORID = ['PM Vendor Master File'].VENDORID
23CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
24DSCRIPTN SearchDescriptionSTR30String30
25EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Check Header'].EXGTBLID AS 'Check Header-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB770002 AS ['Check Header']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Check Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
26CB_Check_Amount SearchCB_Check_AmountDLR19_RBS0_UTR$Currency19
27CB_Check_Total SearchCB_Check_TotalDLR19_RBS0_UTR$Currency19

Leave a Reply

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