Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1103
Product: Cashbook (1058)
Series: Financial
Display Name: CE Transaction Types
Physical Name: CBEU1103
Technical Name: CB_Euro_Transaction_TypesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Cash_Numbering 
CB_Cash_Numbering Boolean Boolean 0 2 CB_Pay_Rec CB_Pay_Rec STR5 String 5 3 CB_Trx_Type_String CB_Trx_Type_String STR30 String 30 4 CB_Ledger_Type CB_Ledger_Type INT3 Integer 3 5 CB_Uses_Vat CB_Uses_Vat boolean Boolean 0 6 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
['CE Transaction Types'].TAXSCHID AS 'CE Transaction Types-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CBEU1103 AS ['CE Transaction Types']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['CE Transaction Types'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID7 CB_Trx_Type_String_Lcase CB_Trx_Type_String_Lcase STR30 String 30