Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN00800
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Plans
Physical Name: CN00800
Technical Name: CN_PlansSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CollectionPlanID 
CollectionPlanID STR15_LBAU String 15 2 DSCRIPTN Description STR30 String 30 3 CN_Plan_Action_1 CN_Plan_Action[1] Action Promised String 16 4 CN_Plan_Action_2 CN_Plan_Action[2] Action Promised String 16 5 CN_Plan_Action_3 CN_Plan_Action[3] Action Promised String 16 6 CN_Plan_Action_4 CN_Plan_Action[4] Action Promised String 16 7 CN_Plan_Action_5 CN_Plan_Action[5] Action Promised String 16 8 CN_Plan_Action_6 CN_Plan_Action[6] Action Promised String 16 9 CN_Plan_Action_7 CN_Plan_Action[7] Action Promised String 16 10 CN_Plan_Action_8 CN_Plan_Action[8] Action Promised String 16 11 CN_Plan_Action_9 CN_Plan_Action[9] Action Promised String 16 12 CN_Plan_Action_10 CN_Plan_Action[10] Action Promised String 16 13 CN_Plan_Action_11 CN_Plan_Action[11] Action Promised String 16 14 CN_Plan_Action_12 CN_Plan_Action[12] Action Promised String 16 15 CN_Plan_Action_13 CN_Plan_Action[13] Action Promised String 16 16 CN_Plan_Action_14 CN_Plan_Action[14] Action Promised String 16 17 CN_Plan_Action_15 CN_Plan_Action[15] Action Promised String 16 18 CN_Plan_Action_16 CN_Plan_Action[16] Action Promised String 16 19 CN_Plan_Action_17 CN_Plan_Action[17] Action Promised String 16 20 CN_Plan_Action_18 CN_Plan_Action[18] Action Promised String 16 21 CN_Plan_Action_19 CN_Plan_Action[19] Action Promised String 16 22 CN_Plan_Action_20 CN_Plan_Action[20] Action Promised String 16 23 CN_Plan_Days_1 CN_Plan_Days[1] INT3_RUO Integer 3 24 CN_Plan_Days_2 CN_Plan_Days[2] INT3_RUO Integer 3 25 CN_Plan_Days_3 CN_Plan_Days[3] INT3_RUO Integer 3 26 CN_Plan_Days_4 CN_Plan_Days[4] INT3_RUO Integer 3 27 CN_Plan_Days_5 CN_Plan_Days[5] INT3_RUO Integer 3 28 CN_Plan_Days_6 CN_Plan_Days[6] INT3_RUO Integer 3 29 CN_Plan_Days_7 CN_Plan_Days[7] INT3_RUO Integer 3 30 CN_Plan_Days_8 CN_Plan_Days[8] INT3_RUO Integer 3 31 CN_Plan_Days_9 CN_Plan_Days[9] INT3_RUO Integer 3 32 CN_Plan_Days_10 CN_Plan_Days[10] INT3_RUO Integer 3 33 CN_Plan_Days_11 CN_Plan_Days[11] INT3_RUO Integer 3 34 CN_Plan_Days_12 CN_Plan_Days[12] INT3_RUO Integer 3 35 CN_Plan_Days_13 CN_Plan_Days[13] INT3_RUO Integer 3 36 CN_Plan_Days_14 CN_Plan_Days[14] INT3_RUO Integer 3 37 CN_Plan_Days_15 CN_Plan_Days[15] INT3_RUO Integer 3 38 CN_Plan_Days_16 CN_Plan_Days[16] INT3_RUO Integer 3 39 CN_Plan_Days_17 CN_Plan_Days[17] INT3_RUO Integer 3 40 CN_Plan_Days_18 CN_Plan_Days[18] INT3_RUO Integer 3 41 CN_Plan_Days_19 CN_Plan_Days[19] INT3_RUO Integer 3 42 CN_Plan_Days_20 CN_Plan_Days[20] INT3_RUO Integer 3 43 CN_Plan_OverdueDays_1 CN_Plan_OverdueDays[1] INT3_S0 Integer 3 44 CN_Plan_OverdueDays_2 CN_Plan_OverdueDays[2] INT3_S0 Integer 3 45 CN_Plan_OverdueDays_3 CN_Plan_OverdueDays[3] INT3_S0 Integer 3 46 CN_Plan_OverdueDays_4 CN_Plan_OverdueDays[4] INT3_S0 Integer 3 47 CN_Plan_OverdueDays_5 CN_Plan_OverdueDays[5] INT3_S0 Integer 3 48 CN_Plan_OverdueDays_6 CN_Plan_OverdueDays[6] INT3_S0 Integer 3 49 CN_Plan_OverdueDays_7 CN_Plan_OverdueDays[7] INT3_S0 Integer 3 50 CN_Plan_OverdueDays_8 CN_Plan_OverdueDays[8] INT3_S0 Integer 3 51 CN_Plan_OverdueDays_9 CN_Plan_OverdueDays[9] INT3_S0 Integer 3 52 CN_Plan_OverdueDays_10 CN_Plan_OverdueDays[10] INT3_S0 Integer 3 53 CN_Plan_OverdueDays_11 CN_Plan_OverdueDays[11] INT3_S0 Integer 3 54 CN_Plan_OverdueDays_12 CN_Plan_OverdueDays[12] INT3_S0 Integer 3 55 CN_Plan_OverdueDays_13 CN_Plan_OverdueDays[13] INT3_S0 Integer 3 56 CN_Plan_OverdueDays_14 CN_Plan_OverdueDays[14] INT3_S0 Integer 3 57 CN_Plan_OverdueDays_15 CN_Plan_OverdueDays[15] INT3_S0 Integer 3 58 CN_Plan_OverdueDays_16 CN_Plan_OverdueDays[16] INT3_S0 Integer 3 59 CN_Plan_OverdueDays_17 CN_Plan_OverdueDays[17] INT3_S0 Integer 3 60 CN_Plan_OverdueDays_18 CN_Plan_OverdueDays[18] INT3_S0 Integer 3 61 CN_Plan_OverdueDays_19 CN_Plan_OverdueDays[19] INT3_S0 Integer 3 62 CN_Plan_OverdueDays_20 CN_Plan_OverdueDays[20] INT3_S0 Integer 3 63 PutOnHoldStep PutOnHoldStep INT2 Integer 2 64 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Collections - Plans'].NOTEINDX AS 'Collections - Plans-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CN00800 AS ['Collections - Plans']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Collections - Plans'].NOTEINDX = ['Record Notes Master'].NOTEINDX65 CN_Plan_Allow_Skips CN_Plan_Allow_Skips CN_Plan_Allow_Skips_CB Boolean 0 66 CN_Plan_End_Option CN_Plan_End_Option CN_Plan_End_Option Integer 0 67 CN_Plan_Minimum CN_Plan_Minimum DLR17_RBS0_STR Currency 17 68 CN_PlaNoteInvoicesOption CN_PlanNoteInvoicesOption CN_PlanNoteInvoicesOption_DDL Integer 0