NC_Propose_Rules_MSTR (NCABR404)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_Propose_Rules_MSTR
Physical Name: NCABR404
Technical Name: NC_Propose_Rules_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1NC_Propose_Rule_ID SearchNC Propose Rule IDSTR15_Bank_IDString15
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_Propose_Rules_MSTR'].SOURCDOC AS 'NC_Propose_Rules_MSTR-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       NCABR404 AS ['NC_Propose_Rules_MSTR']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['NC_Propose_Rules_MSTR'].SOURCDOC = ['Source Document Master'].SOURCDOC
18NC_Multiple_Match_Action SearchNC Multiple Match ActionNC Multiple Match Action DDLInteger0
19NC_Tolerance_Acct_STR SearchNC_Tolerance_Acct_STRNC_STR128String128
20NC_Tolerance_Value SearchNC_Tolerance_ValueNC_BalanceCurrency15
21NC_Tolerance_Percent SearchNC_Tolerance_PercentINT4_%2Integer4

Leave a Reply

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