Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900050
Product: Cashbook (1058)
Series: Financial
Display Name: Voiding Report Table
Physical Name: CB900050
Technical Name: CB_Voiding_Report_TableSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Orig_Audit_Trail 
CB_Orig_Audit_Trail STR15 String 15 2 CB_Checkbook_Currency_In CB_Checkbook_Currency_Index INT5 Integer 4 3 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Voiding Report Table'].CURRNIDX AS 'Voiding Report Table-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Voiding Report Table'].CURRNIDX = ['Currency Setup'].CURRNIDX4 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Voiding Report Table'].CURNCYID AS 'Voiding Report Table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Voiding Report Table'].CURNCYID = ['Currency Setup'].CURNCYID5 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 6 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 7 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 8 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 9 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 10 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 11 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 12 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 13 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 14 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 15 CB_Ref_No CB_Ref_No CB_STR15NoNegative String 15 16 CB_Type CB_Type CB_DDL_Type2 Integer 0 17 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Voiding Report Table'].CHEKBKID AS 'Voiding Report Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Voiding Report Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID18 DSCRIPTN Description STR30 String 30 19 CB_Payment_Method_String CB_Payment_Method_String STR30 String 30 20 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['Voiding Report Table'].TAXSCHID AS 'Voiding Report Table-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Voiding Report Table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID21 CB_Voided_Doc_No CB_Voided_Doc_No STR20 String 20 22 ACTNUMST Account Number String STR128_LBU String 128 23 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Voiding Report Table'].INTERID AS 'Voiding Report Table-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Voiding Report Table'].INTERID = ['Company Master'].INTERID24 CB_Payee CB_Payee STR40 String 40 25 DOCNUMBR Document Number STR20_Document_Number String 20 26 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Voiding Report Table'].USERID AS 'Voiding Report Table-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CB900050 AS ['Voiding Report Table']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Voiding Report Table'].USERID = ['Users Master'].USERID27 DATE1 Date DT6 Date 6 28 CB_Transaction_String CB_Transaction_String STR30 String 30 29 CB_Orig_Vat_Amount CB_Orig_Vat_Amount CB_DLR19 Currency 19 30 CB_Orig_Trans_Amount CB_Orig_Trans_Amount CB_DLR19 Currency 19 31 CB_Orig_Exc_Amount CB_Orig_Exc_Amount CB_DLR19 Currency 19 32 CB_Check_Trans_Amount CB_Check_Trans_Amount CB_DLR19 Currency 19 33 CB_Check_Exc_Amount CB_Check_Exc_Amount CB_DLR19 Currency 19 34 CB_Check_Vat_Amount CB_Check_Vat_Amount CB_DLR19 Currency 19 35 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 36 CB_Exc_Amount CB_Exc_Amount CB_DLR19 Currency 19 37 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 38 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 39 RATECALC Rate Calc Method INT Integer 0 40 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 41 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 42 CB_Transaction_Date CB_Transaction_Date DATE Date 6 43 CB_Audit_Trail CB_Audit_Trail STR15 String 15