Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900002
Product: Cashbook (1058)
Series: Financial
Display Name: Sundry Creditors
Physical Name: CB900002
Technical Name: CB_Sundry_CreditorsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTINDX 
Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Sundry Creditors'].ACTINDX AS 'Sundry Creditors-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB900002 AS ['Sundry Creditors']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Sundry Creditors'].ACTINDX = ['Account Index Master'].ACTINDX2 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 3 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 4 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 5 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 6 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 7 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 8 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 9 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 10 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 11 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 12 ADDRESS1 Address 1 STR60 String 60 13 ADDRESS2 Address 2 STR60 String 60 14 ADDRES1 Address1 STR25 String 25 15 ADDRES2 Address2 STR25 String 25 16 CB_Tel_No CB_Tel_No STR15 String 15 17 CB_Payee CB_Payee STR40 String 40