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 TypeLength
1NC_Trx_Type SearchNC_Trx_TypeSTR9String9
2DSCRIPTN SearchDescriptionSTR30String30
3CB_Date SearchCB DateCB_DateBoolean0
4CB_Reference SearchCB ReferenceCB_ReferenceBoolean0
5CB_Cheque_Number SearchCB Cheque NumberCB_Cheque_NumberBoolean0
6CB_Transaction_Type SearchCB Transaction TypeCB_Transaction_TypeBoolean0
7NC_Start_Day SearchNC_Start_DayINT4Integer4
8NC_End_Day SearchNC_End_DayINT4Integer4
9NC_Start_Statement SearchNC_Start_StatementINT3Integer3
10NC_End_Statement SearchNC_End_StatementINT3Integer3
11NC_Start_Dynamics SearchNC_Start_DynamicsINT3Integer3
12NC_End_Dynamics SearchNC_End_DynamicsINT3Integer3
13NC_Start_State_Cheque SearchNC_Start_State_ChequeINT3Integer3
14NC_End_State_Cheque SearchNC_End_State_ChequeINT3Integer3
15NC_Start_Dynam_Cheque SearchNC_Start_Dynam_ChequeINT3Integer3
16NC_End_Dynam_Cheque SearchNC_End_Dynam_ChequeINT3Integer3
17SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
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 DDLInteger0

Leave a Reply

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