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_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NC_Propose_Rule_ID 
NC Propose Rule ID STR15_Bank_ID String 15 2 DSCRIPTN Description STR30 String 30 3 CB_Date CB Date CB_Date Boolean 0 4 CB_Reference CB Reference CB_Reference Boolean 0 5 CB_Cheque_Number CB Cheque Number CB_Cheque_Number Boolean 0 6 CB_Transaction_Type CB Transaction Type CB_Transaction_Type Boolean 0 7 NC_Start_Day NC_Start_Day INT4 Integer 4 8 NC_End_Day NC_End_Day INT4 Integer 4 9 NC_Start_Statement NC_Start_Statement INT3 Integer 3 10 NC_End_Statement NC_End_Statement INT3 Integer 3 11 NC_Start_Dynamics NC_Start_Dynamics INT3 Integer 3 12 NC_End_Dynamics NC_End_Dynamics INT3 Integer 3 13 NC_Start_State_Cheque NC_Start_State_Cheque INT3 Integer 3 14 NC_End_State_Cheque NC_End_State_Cheque INT3 Integer 3 15 NC_Start_Dynam_Cheque NC_Start_Dynam_Cheque INT3 Integer 3 16 NC_End_Dynam_Cheque NC_End_Dynam_Cheque INT3 Integer 3 17 SOURCDOC Source Document STR10_Source_Document String 10 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'].SOURCDOC18 NC_Multiple_Match_Action NC Multiple Match Action NC Multiple Match Action DDL Integer 0 19 NC_Tolerance_Acct_STR NC_Tolerance_Acct_STR NC_STR128 String 128 20 NC_Tolerance_Value NC_Tolerance_Value NC_Balance Currency 15 21 NC_Tolerance_Percent NC_Tolerance_Percent INT4_%2 Integer 4