CE Tax Table History (CBEUH107)

azurecurveProductsCashbook (1058)FinancialCE Tax Table History (CBEUH107)

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

Product: Cashbook (1058)
Series: Financial

Display Name: CE Tax Table History
Physical Name: CBEUH107
Technical Name: CB_Euro_Vat_Table_Hist

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['CE Tax Table History'].ACTINDX AS 'CE Tax Table History-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CBEUH107 AS ['CE Tax Table History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['CE Tax Table History'].ACTINDX = ['Account Index Master'].ACTINDX
2CB_Vat_Not_Rounded SearchCB_Vat_Not_RoundedDLR19_RBS0_UTR$Currency1019
3CB_Exc_Inc SearchCB_Exc_IncDDLInteger20
4TXDTLPCT SearchTax Detail PercentDLR7_%5SCurrency107
5CB_Trans_Type SearchCB_Trans_TypeSTR1String21
6CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString1615
7TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['CE Tax Table History'].TAXDTLID AS 'CE Tax Table History-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CBEUH107 AS ['CE Tax Table History']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['CE Tax Table History'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
8ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
9ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
10ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
11ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
12ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
13ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
14ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
15ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
16ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
17ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
18BACHNUMB SearchBatch NumberSTR15_LBAUString1615
19DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
20CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
21XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
22TXDTLBSE SearchTax Detail BaseDDL_Tax_Detail_BaseInteger20
23Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency1019
24CB_Check_Vat_Amount SearchCB_Check_Vat_AmountCB_DLR19Currency1019
25CB_Orig_Vat_Amount SearchCB_Orig_Vat_AmountCB_DLR19Currency1019
azurecurveProductsCashbook (1058)FinancialCE Tax Table History (CBEUH107)

Leave a Reply

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