Collections – Plans (CN00800)

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_Plans

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CollectionPlanID SearchCollectionPlanIDSTR15_LBAUString1615
2DSCRIPTN SearchDescriptionSTR30String3230
3CN_Plan_Action_1 SearchCN_Plan_Action[1]Action PromisedString1816
4CN_Plan_Action_2 SearchCN_Plan_Action[2]Action PromisedString1816
5CN_Plan_Action_3 SearchCN_Plan_Action[3]Action PromisedString1816
6CN_Plan_Action_4 SearchCN_Plan_Action[4]Action PromisedString1816
7CN_Plan_Action_5 SearchCN_Plan_Action[5]Action PromisedString1816
8CN_Plan_Action_6 SearchCN_Plan_Action[6]Action PromisedString1816
9CN_Plan_Action_7 SearchCN_Plan_Action[7]Action PromisedString1816
10CN_Plan_Action_8 SearchCN_Plan_Action[8]Action PromisedString1816
11CN_Plan_Action_9 SearchCN_Plan_Action[9]Action PromisedString1816
12CN_Plan_Action_10 SearchCN_Plan_Action[10]Action PromisedString1816
13CN_Plan_Action_11 SearchCN_Plan_Action[11]Action PromisedString1816
14CN_Plan_Action_12 SearchCN_Plan_Action[12]Action PromisedString1816
15CN_Plan_Action_13 SearchCN_Plan_Action[13]Action PromisedString1816
16CN_Plan_Action_14 SearchCN_Plan_Action[14]Action PromisedString1816
17CN_Plan_Action_15 SearchCN_Plan_Action[15]Action PromisedString1816
18CN_Plan_Action_16 SearchCN_Plan_Action[16]Action PromisedString1816
19CN_Plan_Action_17 SearchCN_Plan_Action[17]Action PromisedString1816
20CN_Plan_Action_18 SearchCN_Plan_Action[18]Action PromisedString1816
21CN_Plan_Action_19 SearchCN_Plan_Action[19]Action PromisedString1816
22CN_Plan_Action_20 SearchCN_Plan_Action[20]Action PromisedString1816
23CN_Plan_Days_1 SearchCN_Plan_Days[1]INT3_RUOInteger23
24CN_Plan_Days_2 SearchCN_Plan_Days[2]INT3_RUOInteger23
25CN_Plan_Days_3 SearchCN_Plan_Days[3]INT3_RUOInteger23
26CN_Plan_Days_4 SearchCN_Plan_Days[4]INT3_RUOInteger23
27CN_Plan_Days_5 SearchCN_Plan_Days[5]INT3_RUOInteger23
28CN_Plan_Days_6 SearchCN_Plan_Days[6]INT3_RUOInteger23
29CN_Plan_Days_7 SearchCN_Plan_Days[7]INT3_RUOInteger23
30CN_Plan_Days_8 SearchCN_Plan_Days[8]INT3_RUOInteger23
31CN_Plan_Days_9 SearchCN_Plan_Days[9]INT3_RUOInteger23
32CN_Plan_Days_10 SearchCN_Plan_Days[10]INT3_RUOInteger23
33CN_Plan_Days_11 SearchCN_Plan_Days[11]INT3_RUOInteger23
34CN_Plan_Days_12 SearchCN_Plan_Days[12]INT3_RUOInteger23
35CN_Plan_Days_13 SearchCN_Plan_Days[13]INT3_RUOInteger23
36CN_Plan_Days_14 SearchCN_Plan_Days[14]INT3_RUOInteger23
37CN_Plan_Days_15 SearchCN_Plan_Days[15]INT3_RUOInteger23
38CN_Plan_Days_16 SearchCN_Plan_Days[16]INT3_RUOInteger23
39CN_Plan_Days_17 SearchCN_Plan_Days[17]INT3_RUOInteger23
40CN_Plan_Days_18 SearchCN_Plan_Days[18]INT3_RUOInteger23
41CN_Plan_Days_19 SearchCN_Plan_Days[19]INT3_RUOInteger23
42CN_Plan_Days_20 SearchCN_Plan_Days[20]INT3_RUOInteger23
43CN_Plan_OverdueDays_1 SearchCN_Plan_OverdueDays[1]INT3_S0Integer23
44CN_Plan_OverdueDays_2 SearchCN_Plan_OverdueDays[2]INT3_S0Integer23
45CN_Plan_OverdueDays_3 SearchCN_Plan_OverdueDays[3]INT3_S0Integer23
46CN_Plan_OverdueDays_4 SearchCN_Plan_OverdueDays[4]INT3_S0Integer23
47CN_Plan_OverdueDays_5 SearchCN_Plan_OverdueDays[5]INT3_S0Integer23
48CN_Plan_OverdueDays_6 SearchCN_Plan_OverdueDays[6]INT3_S0Integer23
49CN_Plan_OverdueDays_7 SearchCN_Plan_OverdueDays[7]INT3_S0Integer23
50CN_Plan_OverdueDays_8 SearchCN_Plan_OverdueDays[8]INT3_S0Integer23
51CN_Plan_OverdueDays_9 SearchCN_Plan_OverdueDays[9]INT3_S0Integer23
52CN_Plan_OverdueDays_10 SearchCN_Plan_OverdueDays[10]INT3_S0Integer23
53CN_Plan_OverdueDays_11 SearchCN_Plan_OverdueDays[11]INT3_S0Integer23
54CN_Plan_OverdueDays_12 SearchCN_Plan_OverdueDays[12]INT3_S0Integer23
55CN_Plan_OverdueDays_13 SearchCN_Plan_OverdueDays[13]INT3_S0Integer23
56CN_Plan_OverdueDays_14 SearchCN_Plan_OverdueDays[14]INT3_S0Integer23
57CN_Plan_OverdueDays_15 SearchCN_Plan_OverdueDays[15]INT3_S0Integer23
58CN_Plan_OverdueDays_16 SearchCN_Plan_OverdueDays[16]INT3_S0Integer23
59CN_Plan_OverdueDays_17 SearchCN_Plan_OverdueDays[17]INT3_S0Integer23
60CN_Plan_OverdueDays_18 SearchCN_Plan_OverdueDays[18]INT3_S0Integer23
61CN_Plan_OverdueDays_19 SearchCN_Plan_OverdueDays[19]INT3_S0Integer23
62CN_Plan_OverdueDays_20 SearchCN_Plan_OverdueDays[20]INT3_S0Integer23
63PutOnHoldStep SearchPutOnHoldStepINT2Integer22
64NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
65CN_Plan_Allow_Skips SearchCN_Plan_Allow_SkipsCN_Plan_Allow_Skips_CBBoolean20
66CN_Plan_End_Option SearchCN_Plan_End_OptionCN_Plan_End_OptionInteger20
67CN_Plan_Minimum SearchCN_Plan_MinimumDLR17_RBS0_STRCurrency1017
68CN_PlaNoteInvoicesOption SearchCN_PlanNoteInvoicesOptionCN_PlanNoteInvoicesOption_DDLInteger20

Leave a Reply

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