Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB888002
Product: Cashbook (1058)
Series: Financial
Display Name: Check Transaction Group Display Name: Bank Management
Physical Name: CB888002
Technical Name: CB_Check_TRN
Group Technical Name: Bank Management
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SEQNUMBR | Sequence Number | LI_Sequence_Number | Long Integer | 10 | |
2 | INTERID | Intercompany ID | STR5_IC_ID | String | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['Check Transaction'].INTERID AS 'Check Transaction-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB888002 AS ['Check Transaction']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Check Transaction'].INTERID = ['Company Master'].INTERID | ||||||
3 | CMPANYID | Company ID | INT5 | Integer | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['Check Transaction'].CMPANYID AS 'Check Transaction-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CB888002 AS ['Check Transaction']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Check Transaction'].CMPANYID = ['Company Master'].CMPANYID | ||||||
4 | CB_Exc_Inc | CB_Exc_Inc | DDL | Integer | 0 | |
5 | CB_Vat_Account_Index | CB_Vat_Account_Index | LI_14 | Long Integer | 14 | |
6 | CB_Vat_Account_Number_1 | CB_Vat_Account_Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
7 | CB_Vat_Account_Number_2 | CB_Vat_Account_Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
8 | CB_Vat_Account_Number_3 | CB_Vat_Account_Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
9 | CB_Vat_Account_Number_4 | CB_Vat_Account_Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
10 | CB_Vat_Account_Number_5 | CB_Vat_Account_Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
11 | CB_Vat_Account_Number_6 | CB_Vat_Account_Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
12 | CB_Vat_Account_Number_7 | CB_Vat_Account_Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
13 | CB_Vat_Account_Number_8 | CB_Vat_Account_Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
14 | CB_Vat_Account_Number_9 | CB_Vat_Account_Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
15 | CB_Vat_Account_Number_10 | CB_Vat_Account_Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
16 | BACHNUMB | Batch Number | STR15_LBAU | String | 15 | |
17 | CHEKNMBR | Check Number | STR20_Document_Number | String | 20 | |
18 | CB_Line_No | CB_Line_No | STR10 | String | 10 | |
19 | TAXSCHID | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Check Transaction'].TAXSCHID AS 'Check Transaction-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB888002 AS ['Check Transaction']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Check Transaction'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
20 | TAXDTLID | Tax Detail ID | STR15_Tax_Detail_ID | String | 15 | |
Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hideSELECT
['Check Transaction'].TAXDTLID AS 'Check Transaction-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
CB888002 AS ['Check Transaction']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Check Transaction'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
21 | ACTNUMBR_1 | Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
22 | ACTNUMBR_2 | Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
23 | ACTNUMBR_3 | Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
24 | ACTNUMBR_4 | Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
25 | ACTNUMBR_5 | Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
26 | ACTNUMBR_6 | Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
27 | ACTNUMBR_7 | Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
28 | ACTNUMBR_8 | Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
29 | ACTNUMBR_9 | Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
30 | ACTNUMBR_10 | Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
31 | ACTINDX | Account Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Check Transaction'].ACTINDX AS 'Check Transaction-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB888002 AS ['Check Transaction']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Check Transaction'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
32 | CB_Type_Description | CB_Type_Description | STR30 | String | 30 | |
33 | CB_Trans_Amount | CB_Trans_Amount | CB_DLR19 | Currency | 19 | |
34 | Vat_Amount | Vat_Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
35 | CB_Balanced | CB_Balanced | Boolean | Boolean | 0 |