Check Recurring (CB900037)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Check Recurring
Physical Name: CB900037
Technical Name: CB_Check_Recurring

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['Check Recurring'].EXGTBLID AS 'Check Recurring-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Check Recurring'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
26CB_Check_Amount SearchCB_Check_AmountDLR19_RBS0_UTR$Currency1019
27CB_Check_Total SearchCB_Check_TotalDLR19_RBS0_UTR$Currency1019
28CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
29CB_Use_Current SearchCB_Use_CurrentCBBoolean20
30CB_Exc_Inc SearchCB_Exc_IncDDLInteger20
31CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
32Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency1019
33ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
34ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
35ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
36ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
37ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
38ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
39ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
40ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
41ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
42ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
43ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Check Recurring'].ACTINDX AS 'Check Recurring-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Check Recurring'].ACTINDX = ['Account Index Master'].ACTINDX
44TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['Check Recurring'].TAXDTLID AS 'Check Recurring-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['Check Recurring'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
45TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Check Recurring'].TAXSCHID AS 'Check Recurring-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Check Recurring'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
46CB_Vat_Account_Index SearchCB_Vat_Account_IndexLI_14Long Integer414
47CB_Vat_Account_Number_1 SearchCB_Vat_Account_Number:Account_Segment_Pool1Account_Segment_Pool1String86
48CB_Vat_Account_Number_2 SearchCB_Vat_Account_Number:Account_Segment_Pool2Account_Segment_Pool2String86
49CB_Vat_Account_Number_3 SearchCB_Vat_Account_Number:Account_Segment_Pool3Account_Segment_Pool3String86
50CB_Vat_Account_Number_4 SearchCB_Vat_Account_Number:Account_Segment_Pool4Account_Segment_Pool4String86
51CB_Vat_Account_Number_5 SearchCB_Vat_Account_Number:Account_Segment_Pool5Account_Segment_Pool5String86
52CB_Vat_Account_Number_6 SearchCB_Vat_Account_Number:Account_Segment_Pool6Account_Segment_Pool6String86
53CB_Vat_Account_Number_7 SearchCB_Vat_Account_Number:Account_Segment_Pool7Account_Segment_Pool7String86
54CB_Vat_Account_Number_8 SearchCB_Vat_Account_Number:Account_Segment_Pool8Account_Segment_Pool8String86
55CB_Vat_Account_Number_9 SearchCB_Vat_Account_Number:Account_Segment_Pool9Account_Segment_Pool9String86
56CB_Vat_Account_Number_10 SearchCB_Vat_Account_Number:Account_Segment_Pool10Account_Segment_Pool10String86
57INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Check Recurring'].INTERID AS 'Check Recurring-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Check Recurring'].INTERID = ['Company Master'].INTERID
58CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Check Recurring'].CMPANYID AS 'Check Recurring-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CB900037 AS ['Check Recurring']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Check Recurring'].CMPANYID = ['Company Master'].CMPANYID

Leave a Reply

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