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 TypeSQL DB LengthKeyable Length
1NC_Propose_Rule_ID SearchNC Propose Rule IDSTR15_Bank_IDString1615
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_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 DDLInteger20
19NC_Tolerance_Acct_STR SearchNC_Tolerance_Acct_STRNC_STR128String130128
20NC_Tolerance_Value SearchNC_Tolerance_ValueNC_BalanceCurrency1015
21NC_Tolerance_Percent SearchNC_Tolerance_PercentINT4_%2Integer24

Leave a Reply

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