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 TypeSQL DB LengthKeyable Length
1BANKID SearchBank IDSTR15_Bank_IDString1615
2NC_Statement_Number SearchNC_Statement_NumberLong IntLong Integer48
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
4NC_String_10_1 SearchNC String 10[1]STR10String1210
5NC_String_10_2 SearchNC String 10[2]STR10String1210
6NC_String_10_3 SearchNC String 10[3]STR10String1210
7NC_String_10_4 SearchNC String 10[4]STR10String1210
8NC_String_30_1 SearchNC String 30[1]STR30String3230
9NC_String_30_2 SearchNC String 30[2]STR30String3230
10NC_String_30_3 SearchNC String 30[3]STR30String3230
11NC_String_30_4 SearchNC String 30[4]STR30String3230
12NC_String_30_5 SearchNC String 30[5]STR30String3230
13NC_String_30_6 SearchNC String 30[6]STR30String3230
14NC_String_80_1 SearchNC String 80[1]STR80String8280
15NC_String_80_2 SearchNC String 80[2]STR80String8280
16NC_LongInt_1 SearchNC LongInt[1]Long IntLong Integer48
17NC_LongInt_2 SearchNC LongInt[2]Long IntLong Integer48
18NC_LongInt_3 SearchNC LongInt[3]Long IntLong Integer48
19NC_LongInt_4 SearchNC LongInt[4]Long IntLong Integer48
20NC_LongInt_5 SearchNC LongInt[5]Long IntLong Integer48
21NC_LongInt_6 SearchNC LongInt[6]Long IntLong Integer48
22NC_Dollar_1 SearchNC Dollar[1]Dollar19Currency1019
23NC_Dollar_2 SearchNC Dollar[2]Dollar19Currency1019
24NC_Date8 SearchNC Date8DATE_LONGDate48
25ACTINDX SearchAccount IndexLI_14Long Integer414
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 *