Tax Table (CB800666)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Tax Table
Physical Name: CB800666
Technical Name: CB_Vat_Table

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
2ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Tax Table'].ACTINDX AS 'Tax Table-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB800666 AS ['Tax Table']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Tax Table'].ACTINDX = ['Account Index Master'].ACTINDX
3CB_Vat_Not_Rounded SearchCB_Vat_Not_RoundedDLR19_RBS0_UTR$Currency19
4CB_Exc_Inc SearchCB_Exc_IncDDLInteger0
5TXDTLPCT SearchTax Detail PercentDLR7_%5SCurrency7
6CB_Trans_Type SearchCB_Trans_TypeSTR1String1
7CB_Ref_No SearchCB_Ref_NoCB_STR15NoNegativeString15
8TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['Tax Table'].TAXDTLID AS 'Tax Table-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       CB800666 AS ['Tax Table']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['Tax Table'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
9ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
10ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
11ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
12ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
13ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
14ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
15ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
16ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
17ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
18ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
19BACHNUMB SearchBatch NumberSTR15_LBAUString15
20DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
21CB_Type_Description SearchCB_Type_DescriptionSTR30String30
22XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
23TXDTLBSE SearchTax Detail BaseDDL_Tax_Detail_BaseInteger0
24Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency19

Leave a Reply

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