Collections – Query Master (CN00600)

azurecurveProductsCollections Management (1157)SalesCollections - Query Master (CN00600)

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

Product: Collections Management (1157)
Series: Sales

Display Name: Collections - Query Master
Physical Name: CN00600
Technical Name: CN_Query_MSTR

Group Display Name: Collection Query
Group Technical Name: CollectionQuery

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Query_ID SearchQuery IDSTR15_LBAUString1615
2Query_Description SearchQuery DescriptionSTR30String3230
3STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
4STCUSTNM SearchStart Customer NameSTR64_Customer_NameString6664
5STTCLSID SearchStart Class IDSTR15_LBAUString1615
6STTUDEF1 SearchStart User Defined 1STR20String2220
7STSPRSID SearchStart Salesperson IDSTR15_LBAUString1615
8STSLSTER SearchStart Sales TerritorySTR15_LBAUString1615
9StartPrefContactMethod SearchStart Preferred Contact MethodpaDDLPreferredContactMethodInteger20
10CNStartTimeZone SearchCN Start Time ZoneINTInteger20
11STRTUDEF SearchStart User DefinedSTR20String2220
12STUDDAT1 SearchStart User Defined Date 1DATEDate46
13STUDTAB1 SearchStart User Defined Table 1STR20String2220
14ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
15ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString6664
16ENDCLSID SearchEnd Class IDSTR15_LBAUString1615
17ENUSRDF1 SearchEnd User Defined 1STR20String2220
18ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString1615
19ENSLSTER SearchEnd Sales TerritorySTR15_LBAUString1615
20CNEndTimeZone SearchCN End Time ZoneDDL_Time_ZoneInteger20
21EndPrefContactMethod SearchEnd Preferred Contact MethodpaDDLPreferredContactMethodInteger20
22ENUSRDEF SearchEnd User DefinedSTR20String2220
23ENDUDDT1 SearchEnd User Defined Date 1DATEDate46
24ENDUDTBL SearchEnd User Defined Table 1STR20String2220
25StartCreditControlCycle SearchCN Start Credit Control CycleCN_DDL_CreditControlCycleInteger20
26EndCreditControlCyle SearchCN End Credit Control CycleCN_DDL_CreditControlCycleInteger20
27CONNAACT SearchConsolidate National Account ActivityCB_Conslidate_NA_ActivityBoolean20
28DateSelection SearchDate SelectionINT1Integer21
29QRYSTCDTPER SearchQuery Start Credit Limit PeriodINTInteger20
30QryEndCrLimitPeriod SearchQuery End Credit Limit PeriodINTInteger20
31QRYSTCDTAMT SearchQuery Start Credit Limit AmountDLR17_QTY_RBS0_STRCurrency1017
32QryEndCreditLimitAmt SearchQuery End Credit Limit AmountDLR17_RBSO_STR$Currency1017
33QryStartDateToken SearchQuery Start Date TokenCN_DDL_Date_TokensInteger20
34QryEndDateToken SearchQuery End Date TokenCN_DDL_Date_TokensInteger20
35STRTNGDT SearchStarting DateDTDate48
36ENDINGDT SearchEnding DateDTDate48
37Starting_Trx_Days SearchStarting Trx DaysINT3Integer23
38Ending_Trx_Days SearchEnding Trx DaysINT3Integer23
39Start_Caller_ID SearchStart Caller IDSTR15_User_IDString1615
40Start_Contact_Date SearchStart Contact DateDATEDate46
41Start_Action_Assigned_To SearchStart Action Assigned ToSTR15_User_IDString1615
42Start_Action_Promised SearchStart Action PromisedAction PromisedString1816
43Start_Action_Date SearchStart Action DateDATEDate46
44SNOTPRTY SearchStart Note PriorityDDLInteger20
45QRYACTCOM SearchQuery Action CompletedINTInteger20
46End_Caller_ID SearchEnd Caller IDSTR15_User_IDString1615
47End_Contact_Date SearchEnd Contact DateDATEDate46
48End_Action_Assigned_To SearchEnd Action Assigned ToSTR15_User_IDString1615
49End_Action_Promised SearchEnd Action PromisedAction PromisedString1816
50End_Action_Date SearchEnd Action DateDATEDate46
51ENOTPRTY SearchEnd Note PriorityDDLInteger20
52QCMFLAG SearchQuery Credit Manager FlagBooleanBoolean20
53Start_Credit_Manager SearchStart Credit ManagerSTR15_LBAUString1615
54End_Credit_Manager SearchEnd Credit ManagerSTR15_LBAUString1615
55CUSTCSTS SearchCustomer Commitment StatusCustomer Commitment StatusInteger20
56QueryBalanceReturned SearchQuery Balance ReturnedCN_DDL_BalanceReturnedInteger20
57QueryExcludeOlderBalance SearchQuery Exclude Older BalancesCN_CBExcludeOlderBalancesBoolean20
58QryExcludeifPaymentMade SearchQuery Exclude if Payment MadeCBBoolean20
59QueryNumberofDays SearchQuery Number of DaysINT3Integer23
60QueryNoteExists SearchQuery Note ExistsCN_DDL_NoteExistsInteger20
61STUDTAB2 SearchStart User Defined Table 2STR20String2220
62ENDUDTBL2 SearchEnd User Defined Table 2STR20String2220
63USERLANG SearchUser Language IDINTInteger20
64CN_Credit_LevelStart SearchStart CN Credit LevelCN_DDL_CreditLevelInteger20
65CN_Credit_LevelEnd SearchEnd CN Credit LevelCN_DDL_CreditLevelInteger20
66Query_Exclude_Partial_Pa SearchQuery Exclude Partial PaymentsQuery Exclude Partial Payments CBBoolean20
67CN_BalanceOverCreditLim SearchCN_BalanceOverCreditLimitBooleanBoolean20
68StartNoteStatus SearchStartNoteStatusNoteStatusDDLInteger20
69EndNoteStatus SearchEndNoteStatusNoteStatusDDLInteger20
70QueryInvoiceDocumentID SearchQuery Invoice Document IDSTR15_LBAUString1615
71Start_Collection_Plan_ID SearchStart Collection Plan IDSTR15_LBAUString1615
72End_Collection_Plan_ID SearchEnd Collection Plan IDSTR15_LBAUString1615
73CN_Query_Type SearchCN_Query_TypeGBInteger20
74TXTFIELD SearchText FieldTX32000Text232000
azurecurveProductsCollections Management (1157)SalesCollections - Query Master (CN00600)

Leave a Reply

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