Laserfiche WebLink
ActionsWithSummaryPayments.xlsx <br /> Field Description <br /> invoiceNumber* The unique numeric identifier for this row <br /> RelatedToAlarmedLoc* Y/N value. If this action is related to an alarmed location enter Y or to an alarm <br /> company enter N <br /> AccountNumber* The alarmed location or alarm company Account number this person is related <br /> to <br /> ActionType* Name of letter or action performed (e.g. false alarm, renewal, delinquent notice. <br /> Etc.) <br /> ActionDate* The date this letter or action was performed <br /> DateLetterSent The dates this letter or action was mailed <br /> Charge* The total amount charged for this action. Otherwise, 0.00 <br /> PaidToDate* The total amount that has been paid to date. If charge = 0 then 0.00 <br /> RefundToDate* The total amount that has been refunded to date. If charge = 0 then 0.00 <br /> AdjudicationToDate* The total amount that has been waived/adjudicated to date. If charge = 0 then <br /> 0.00 <br /> Notes Any special notes related to this single action <br /> InAbeyance Y/N or 1/0 If a charge was placed for this letter or action and if this charge is <br /> being held in abeyance until a hearing is performed on it <br /> CaseNumberA The unique Case/Incident#from the CAD if this is an alarm incident, otherwise <br /> blank. This CaseNumber is the link to the AlarmCalls.xlsx <br /> created The date this letter or action was created. May be same as actionDate <br /> updated The date this letter or action was last updated. May be same as actionDate <br /> Lien Date The date this charge was liened if applicable <br /> CollectionDate The date this charge was sent to collections if applicable <br /> Every letter sent and/or every false alarm call processed must have a row in this `Actions' Excel form. <br /> Each row must have a unique numeric identifier. Each row must have the related AccountNumber and <br /> RelatedToAlarmedLoc field included. <br /> If the row is an alarm call, the CaseNumber column must be filled in. The CaseNumber column is used as <br /> the link between this Actions Excel and the AlarmCall Excel, so if it is filled in the CaseNumber must be <br /> unique. <br /> If the row is not an alarm call, the CaseNumber column must be blank <br /> A The Case Number is required if this action is a false alarm call. <br /> Page 25 of 27 False Alarm Management Services <br /> Contract Agreement <br />