NC_Rules_MSTR (NCABR206)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_Rules_MSTR
Physical Name: NCABR206
Technical Name: NC_Rules_MSTR_11004_PHASEDOUT

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1NC_Trx_Type SearchNC_Trx_TypeSTR9String109
2DSCRIPTN SearchDescriptionSTR30String3230
3CB_Date SearchCB DateCB_DateBoolean20
4CB_Reference SearchCB ReferenceCB_ReferenceBoolean20
5CB_Cheque_Number SearchCB Cheque NumberCB_Cheque_NumberBoolean20
6CB_Transaction_Type SearchCB Transaction TypeCB_Transaction_TypeBoolean20
7NC_Start_Day SearchNC_Start_DayINT4Integer24
8NC_End_Day SearchNC_End_DayINT4Integer24
9NC_Start_Statement SearchNC_Start_StatementINT3Integer23
10NC_End_Statement SearchNC_End_StatementINT3Integer23
11NC_Start_Dynamics SearchNC_Start_DynamicsINT3Integer23
12NC_End_Dynamics SearchNC_End_DynamicsINT3Integer23
13NC_Start_State_Cheque SearchNC_Start_State_ChequeINT3Integer23
14NC_End_State_Cheque SearchNC_End_State_ChequeINT3Integer23
15NC_Start_Dynam_Cheque SearchNC_Start_Dynam_ChequeINT3Integer23
16NC_End_Dynam_Cheque SearchNC_End_Dynam_ChequeINT3Integer23
17SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['NC_Rules_MSTR'].SOURCDOC AS 'NC_Rules_MSTR-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       NCABR206 AS ['NC_Rules_MSTR']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['NC_Rules_MSTR'].SOURCDOC = ['Source Document Master'].SOURCDOC
18NC_Multiple_Match_Action SearchNC Multiple Match ActionNC Multiple Match Action DDLInteger20

Leave a Reply

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