NC_StatementUD_MSTR (NCABR412)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_StatementUD_MSTR
Physical Name: NCABR412
Technical Name: NC_StatementUD_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BANKID SearchBank IDSTR15_Bank_IDString15
2NC_Statement_Number SearchNC_Statement_NumberLong IntLong Integer8
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
4NC_String_10_1 SearchNC String 10[1]STR10String10
5NC_String_10_2 SearchNC String 10[2]STR10String10
6NC_String_10_3 SearchNC String 10[3]STR10String10
7NC_String_10_4 SearchNC String 10[4]STR10String10
8NC_String_30_1 SearchNC String 30[1]STR30String30
9NC_String_30_2 SearchNC String 30[2]STR30String30
10NC_String_30_3 SearchNC String 30[3]STR30String30
11NC_String_30_4 SearchNC String 30[4]STR30String30
12NC_String_30_5 SearchNC String 30[5]STR30String30
13NC_String_30_6 SearchNC String 30[6]STR30String30
14NC_String_80_1 SearchNC String 80[1]STR80String80
15NC_String_80_2 SearchNC String 80[2]STR80String80
16NC_LongInt_1 SearchNC LongInt[1]Long IntLong Integer8
17NC_LongInt_2 SearchNC LongInt[2]Long IntLong Integer8
18NC_LongInt_3 SearchNC LongInt[3]Long IntLong Integer8
19NC_LongInt_4 SearchNC LongInt[4]Long IntLong Integer8
20NC_LongInt_5 SearchNC LongInt[5]Long IntLong Integer8
21NC_LongInt_6 SearchNC LongInt[6]Long IntLong Integer8
22NC_Dollar_1 SearchNC Dollar[1]Dollar19Currency19
23NC_Dollar_2 SearchNC Dollar[2]Dollar19Currency19
24NC_Date8 SearchNC Date8DATE_LONGDate8
25ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_StatementUD_MSTR'].ACTINDX AS 'NC_StatementUD_MSTR-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCABR412 AS ['NC_StatementUD_MSTR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_StatementUD_MSTR'].ACTINDX = ['Account Index Master'].ACTINDX

Leave a Reply

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