How do I set up User Edits

To setup User Edits;

From the Start1 Menu - #1 (Customer Information), then # 19 (Riata), then #20 (Maintenance Items), then #15 (Set up User Edits) – Enter 9 to Add or 2 to Change

Or

From Riata Programs Menu – Select ‘User Edits’ then click on the button needed. (Add New, Delete, Edit, Etc.)

FIELD 01	FIELD 02	DESCRIPTION / FIELDS 03-08
	MAKE-NO-IFBALANCE	Setup this User Edit to keep Accounts as Active (not a permanent disconnect), if all Phones and ID's are Disconnected and any of them still have a Balance. Field 1 = ACCOUNT-PERMISC Field 2 = MAKE-NO-IFBALANCE Field 3 through 8 = Leave Blank This example would make it so that any Account with no Phone Numbers or ID’s and has a Balance will not be permanently disconnected. This is not implemented and my not be as of 10/06/2007
ACCOUNT-PERMDISC	MAKE-NO-IFBALANCE
ACCTTYPE1		Can change the names listed in the account type drop-down box to reflect your own companies account type. (ACCTTYPE1 through ACCTTYPE7) The example below would cause Active C to be in the dropdown box.
ACCTTYPE1		Active C
ACHNO***		This User Edit will replace the *** in the ACH file for '***CO', '***BL and '***AP' with ' CO', ' BL' and ' AP' when you create the Payroll Direct Deposit or the ACH/Credit Card file. Field 02-08: Leave blank The example below would cause ' CO' to be sent instead of '***CO'.
ACHNO***
ADJUSTMENT-%	TARIFF-ALL-MONTH	This user edit is used to enter the tariff codes when using the 'Adjustment Based on a Percentage of Recurring'. The tariff codes entered if doing an add will get 100%. If doing a subtract the tariff codes will get 0%. Field 1: ADJUSTMENT-% Field 2:TARIFF-ALL-MONTH Fields 3-8: have tariff codes. There can be 3 tariff codes per line. Key a period between tariff codes. If the tariff code is not 5 characters long, key leading/trailing blanks to make the length of 5. Example: ' ABC. ABCD.ABCDE'. One of the tariffs would need to be entered as a recurring tariff code on each of the customer’s phone number. This example would give a 100% on add or 0% on subtract for the tariff codes ABC, ABCD and ABCDE.
ADJUSTMENT-%	TARIFF-ALL-MONTH	Field3: ABCDE. ABC. ABCD
ALLDISC	TOLGRP	When the last number of an account is disconnected, this allows you to move that account into a specified toll group. The example below would move the account to the toll group specified.
ALLDISC	TOLGRP	425
APGLDESCRIPTION		This makes it so in AP Expense Posting; you can use the detail description rather than the heading description when making the G/L entries. If there is a detail description, a separate record will be generated and not grouped together with others with the same G/L. This example will cause separate G/L records if there is a detail description when doing AP Expense Posting.
APGLDESCRIPTION
APLOCATIONIFBUDGET		This User Edit would Require the 20 Character Special Code to be entered, if a Budget Code is also Required. If the Budget Code is required and you add this user edit the 20 character Special Code will also be Required. Fields 02-08: Leave blank The example below would cause the 20 character Special Code to be required.
APLOCATIONIFBUDGET
APNODUPEBUDGET		This code is used in AP Entry to not duplicate the budget code from the line above. If a budget code is needed, one will have to be selected. This example will stop the Budget Code from being automatically updated from the line above.
APNODUPEBUDGET
APNOPULLWOPROJECT		This code will stop the Project Code in Work Order Master from being pulled in to Accounts Payables Special Project Code. This is if you enter a Work Order as part of the A/P invoice. Key this code in the first field. Leave fields 2 - 8 blank. This example will make it so the W/O Project Code is not pulled in to A/P Entry Special Project Code.
APNOPULLWOPROJECT
APPOPAIDDETAIL		This user edit is used when you want to pull the paid quantity and amount from P/O into A/P entry. Leave fields 2 - 8 blank.
APPOPAIDDETAIL
APPROJECTREQUIRED		Use this to require a project number on any a/p entry that has the last 4 digits of the budget codes that are set up in fields 3-8.In his example any entries with budget code that ends in 2000 would require a project code.
APPROJECTREQUIRED		2000
ARGLACCOUNTS	accttype & Co#	This code is used to let the system know what G/L accounts you want to use for each account type & 1 digit company #. Field 3 has the A/R G/l account. Field 4 has the Bad Debt G/L account. Field 5 has the Cash G/L account. Field 6 has the Federal Tax G/L account. Field 7 has the State Tax G/L account. For account type 1(active accounts) the G/L accounts still come from the control file, #14 on system maintenance menu. Account type numbers are in the order that they are shown in your drop down box on the Main Account Riata screen. This is used by cash receipts, write-offs, and billing G/L entries. This example shows what accounts the system will use if you have an account type 2(not active), for company 4.
ARGLACCOUNTS	24	1180.75 5083.00 1120.10 4010.45 4010.46
AUTOCHECK-GOVID-NO		If you do not want service order entry or service order entry 2007 to automatically check for like government id's, use this edit.
AUTOCHECK-GOVID-NO
AUTOCHECK-NAME-NO		If you do not want service order entry or service order entry 2007 to automatically check for like Names, use this edit.
AUTOCHECK-NAME-NO
AUTOMATION-DRIVE		This has the Drive Letter that the automation programs use to store files in. Field 3 has the 1 character Drive Letter
AUTOMATION-DRIVE		Field 3:N
AZAR		This code will put the tariff code in for the AZAR pay per view events. The example below will use TARF1 for PPV pay per view events and TARF2 for PPVX pay per view events.
AZAR	PPV	TARF1 TARF2
AZAR		This code will put the tariff code in for the AZAR pay per view events for each city code that you set up. You will need to add the city code to the end of PPV for example PPVAA for city code AA. You will need to set up a default tariff in AZAR PPV and put the default tariff in field 3. The example below will use TARF1 for city code AA pay per view events.
AZAR	PPVAA	TARF1
BALANCE-DUE-ONLY	PRIOR-MONTH-CREDITS	If this user edit exists then when middle of the month payments and credits are applied to get a "New Current Balance" for the account, only one time credits what were marked as Prior Month Credits on the Non-Recurring Charges screen will be used. Credits not marked as Prior Month Credits will be ignored. Fields 3-8 are blank
BANK-RECONCILE	PAYROLL-NO-NAME	This user edit will be used to not include the name in the payroll reconcile file. The Check # will be output in place of the name. In the example below, the check # will be put in the reconcile file in place of the name.
BANK-RECONCILE	PAYROLL-NO-NAME
BANK-RECONCILIATION	01	This user edit is used to determine what Format is being used for the PC input file for reconciliation. Field1: BANK-RECONCILIATION Field2: (FORMAT) Fields3-8: BLANK In the example below the BANK-RECONCILIATION would use format 01.
BANK-RECONCILIATION	01
BARCODEWIDE		Allows you to print a barcode for the Account Number that is a larger print. This would be used if your scanner can't read the normal barcode. Because the barcode is larger, it has to start more to the left on the page. This code is checked when printing statements and late notices. Fields 02-08: Leave blank The example below will allow the bar code to be printed.
BARCODEWIDE
BARCODEWIDE2		Allows you to print a barcode for the Account Number that is a larger print. This would be used if your scanner can't read the normal barcode. This barcode is larger than the original but smaller than the BARCODEWIDE option. This code is checked when printing statements and late notices. Fields 02-08: Leave blank The example below will allow the bar code to be printed.
BARCODEWIDE2
BCGI-MISC *ENC		This user edit contains misc. information about BCGI. Field1: BCGI-MISC *ENC Field2: Field3: passcode Field4: site username Field5: site password Field6: timeout Example:
BCGI-MISC *ENC		mypasscode
		myusername
		mypassword
		100
BCGI-SITE		This user edit contains the site address for BCGI webcare. Field 1:BCGI-SITE Field 2: Fields 3-8: concatenated site address including https:// Example:
BCGI-SITE		https://care.bcgi.ne
		t/bcgiwebcare
BILLGLCOMOVE	xFROMy	This allows you to move to your A/R G/L account in one companies G/L the amounts that the Revenue was posted in another companies G/L. x is the 1 char to billing company 1 and y is the 1 char from company #. If you have 2 G/L Companies and you send all charges on 1 customer statement, and part of the revenue is posted to company 1 and part is posted to company 2 and the actual customer is a company 1 customer then you use this to move to company 1 1180.xx account everything that was posted to company 2 and then in company 2 g/l we credit 1180.xx and debit your offsetting g/l account #. The following example assumes billing company 1 goes to g/l company 12 and billing company 2 goes to g/l company 17. The following example would move to G/L company 12 any revenue for company 12 billing customers where you posted revenue to company 17. In Company 12 we would debit 1180.10 and credit 4010.66. In company 17 we would debit 4010.67 and credit 1180.10
BILLGLCOMOVE	1FROM2	12
		1180.10
		4010.66
		17
		4010.67
		1180.10
BILLINGGLCOTAXKEEP		This code tells the system that when making Billing G/L and you are moving only the Revenue Amounts to the individual G/L Companies, that you want to keep the Federal & State Taxes in the assigned Co. Example - if you want to move the total and taxes to G/L company 1 do NOT use this code. If you want to move just the total A/R but not the taxes, but keep the taxes in the assigned company G/L then enter this code. This only applies if you have selected Y to "Just Move Revenue To Other G/L Company "
BILLINGGLCOTAXKEEP
BILLINGNOTESTARTDATE		This will run a job in Step 2 of Month End Billing that will generate a note if the Start Bill Date on a Recurring Charges is in the future. The example below will cause a note to be printed on the statement if the date of the Recurring Charge is dated in the future.
BILLINGNOTESTARTDATE
BSTA5POMRENDPRT		This code will allow you to end the printing of the bill detail earlier to allow room for the OMR mark to indicate the last page for the bill. This is for statement format BSTA5P where two pages are printed on each side of paper. Indicate in number of inches where you want the printing to stop. This only affects the left side of the sheet of paper. Field 1 will have the code. Field 2 will be blank. Field 3 will have the value in Inches where the printing is to stop. Example: 6 inches would be 06000. There is an implied decimal position of 3. Leading zeros need to be keyed. Fields 4-8 will be blank. The following example will cause the detail to stop at 5 1/2 inches down.
BSTA5POMRENDPRT		05500
BSTA5PSPECIALFONT		This code will use a special font when printing detail for BSTA5P style statements. All printers are not the same. The font is a smaller print so everything will align and Total Charges will be in the total boxes. The example below will use a special font to print detail smaller so everything lines up. BSTA5P Statement format.
BSTA5PSPECIALFONT
BSTA6P-BILLTYPE-DESC		This User Edit will allow you to print a longer section header description on your statements. This is for those using BSTA6P as their statement program. Set up this User Edit for each bill type and/or billing cycle that needs a longer description to print or if you need a different Description for each Billing Cycle. This will print in place of the description from the Bill Type setup. (Leave Billing Cycle blank and All Billing cycles use this Description, except cycles identified in another BSTA6P-BILLTYPE-DESC user edit). Field 1 = BSTA6P-BILLTYPE-DESC Field 2 = 2 Character Bill Type Code followed by a decimal then 1 Character Billing Cycle Code (Example: CL.2 ) Fields 3-5 = Key in new description. (Use F2 to allow lower case letters) Fields 6-8 = Leave blank The example below would cause description 'Cellular Service' to print for bill type 'CL'
BSTA6P-BILLTYPE-DESC	CL.2	Cellular Service Bill Type and Billing Cycle 2
BSTA6P-MORE-DESC		Use this User Edit to Print all of the Description from Recurring & Non-Recurring Entries when printing Statements. In order for more of the description to print, the size of the letters had to be made smaller. This includes the Dates, Phone Number and Amount, if they are printing with the description. This example will print all of the Description from Recurring & Non-Recurring Entries on Statements.
BSTA6P-MORE-DESC
BSTA6P-SHOW-CIRCUIT#		This User Edit will let you print a Circuit ID# on statements.Works only if using statement program BSTA6P. You have the option of printing 3 different descriptions. 1) Circuit ID# from Physical Tab in Riata. 2) Description 1 from Facility Access Service Billing. 3) Description 2 from Facility Access Service Billing. You can print any or all of these descriptions. Field 1: BSTA6P-SHOW-CIRCUIT# Field 2: Leave Blank Field 3: Y (Key a 'Y' if you want to show the Circuit ID# from physical tab in Riata) Field 4: Y (Key a 'Y' if you want to show description 1 from Facility Access Service Billing) Field 5: Y (Key a 'Y' if you want to show description 2 from Facility Access Service Billing) Fields 6-8: Leave Blanks The following example will cause Circuit ID# information from all three places to print on the statement.
BSTA6P-SHOW-CIRCUIT#		Y Y Y
BSTA6PACCTEVERYPAGE		This code is used to print the Account Number on every page, including the front page. This prints at the bottom left of the page. This is used if you save statements to some kind of optical drive to identify a new statement. You can also include a 2 character alpha field along with the account. This would show as XX 123456. The XX is keyed in field 3. Field 2 is left blanks. This example will cause XX + Account Number to print at the bottom of each page of statements.
BSTA6PACCTEVERYPAGE		XX
BSTA6PCONVERTPHONE		This code does two things for statement format BSTA6P. 1. If the phone number is going to print as 000-000-0000, the account number will print in its place. An 'A' will print along with the account #. Example: A123456. This applies to the front page and the detail page of the statement. 2. When a Special ID # prints, it will print without the hyphens and it will start with an 'S'. Example: S2084361912. This applies to the front page and the detail page of the statement. The following example will cause 000-000 phone numbers to print the an 'A' + the account number instead. It also will cause special ID #'s to print without the hyphens and proceeded by an 'S'.
BSTA6PCONVERTPHONE
BSTA6POMRENDPRT		This code will allow you to end the printing of the bill detail earlier to allow room for the OMR mark to indicate the last page for the bill. This is for statement format BSTA6P. Field 1 will have the code. Field 2 will be blank. Field 3 will have the value in Inches where the printing is to stop. Example: 6 inches would be 06000. There is an implied decimal position of 3. Leading zeros need to be keyed. Fields 4-8 will be blank. The following example will cause the detail to stop at 5 1/2 inches down.
BSTA6POMRENDPRT		05500
BSTA7PBANKCOMPNO		This code will be used to set up the bank assigned company number to be put on the bank OCR scan line. This scan line is used if customers mail there statement stub to a bank rather than directly to you. Key this code in field 1. Field 2 is blank. Field 3 has the company number in the 4 leftmost positions. The following example will cause 9559 to be the bank assigned company number to be used on the OCR scan line for statement stubs.
BSTA7PBANKCOMPNO		9559
BSTA7PBILLTYPEDESC		This user edit will let you set up what description will print on the front page of the bill for Local Service. With this code you can have one description for Home Service and a different one for a Business Service and a different one if the customer has both Home and Business Service. Key this code in Field 1. Leave Field 2 blank. Field 3 has the description for Home Service. Field 4 has the description for Business Service. Field 5 has the description for customers that have both Home/Business service. Fields 6-8 leave blank. The following example will cause 'Home Phone Service' to print for customers with only home service. Print 'Business Phone Service' for customers with only business service. Print 'Home/Business Phone Service' for customers with both home & business services.
BSTA7PBILLTYPEDESC		Home Phone Service
		Business Phone Service
		Home/Business Phone Service
CABS-CARRIER-NEXT	BILL-#	This user edit will store the next Billing # and Invoice # for cabs Bills. The last 6 characters of the Bill # and Invoice # will be updated with the information entered here. The numbers entered in Field 3 and 4 will be incremented each time it is used. Example (Bill# in #15 'Key Billing Companies' has 'ABCDE' in the first 5 characters of Bill#. After this user edit is setup and cabs bills run the Bill# will have 'ABCDE000012'. The same applies for Invoice #) The Bill # and Invoice # are stored by Carrier, Feature Group, State and Jurisdiction. When Close Out Cabs File #12 is run the file is deleted and new Bill# and Invoice # are created the next time cabs or special access are run. To set this up: Field3: 6 character Bill # Field4: 6 character Invoice # The example below would have 12 for the next Bill # and 8 as the next Invoice #.
CABS-CARRIER-NEXT	BILL-#	Field3: 000012 Field4: 000008
CABS-CONVERT-C-TO-D		This user edit is used to convert feature group C records to feature group D records. To set this up: Field1: CABS-CONVERT-C-TO-D The example below would cause the feature group C records to be converted to feature group D records.
CABS-PDF-EMAIL	FROM-ADDRESS	This user edit is used to know the from address to use when sending the CABS statement PDF from the Creating CABS PDF Files program Field 1: CABS-PDF-EMAIL Field 2: FROM-ADDRESS Fields 3-4: The from address to use Fields 5-8: Leave Blank The example below will use "johnsmith@syringawireless.com" as the from address when sending the CABS Statement PDF to the carrier.
CABS-PDF-EMAIL	FROM-ADDRESS	Field 3: johnsmith@syringawir Field 4: eless.com
CABS-PDF-EMAIL	MESSAGE-TEXT-FILE	This user edit lets the system know where the message text file is located. This file will be used to fill the message portion of the email in the “CABS PDF Statements” program. Field 1: CABS-PDF-EMAIL Field 2: MESSAGE-TEXT-FILE Fields 3-8: the path and file to use for the message. In the example below, the system will look in the N:\CABS folder for the CABS_Email_Message.txt file and use the contents of the text file as the email text.
CABS-PDF-EMAIL	MESSAGE-TEXT-FILE	Field 3: N:\CABS\CABS_Email_M Field 4: essage.txt
CABS-PDF-EMAIL	SUBJECT-TEXT-FILE	This user edit lets the system know where the subject text file is located. This file will be used to fill the Subject portion of the email in the “CABS PDF Statements” program. Field 1: CABS-PDF-EMAIL Field 2: SUBJECT-TEXT-FILE Fields 3-8: the path and file to use for the Subject. In the example below, the system will look in the N:\CABS folder for the CABS_Email_Subject.txt file and use the contents of the text file as the email subject
CABS-PDF-EMAIL	SUBJECT-TEXT-FILE	Field 3: N:\CABS\CABS_Email_S Field 4: ubject.txt
CABS-SPECIAL-TANDEM	(2 char Tandem code)	This user edit is used to setup the special tandems for cabs billing.
		Field2: Enter the special tandem code (2 char) ie, SY
		Field3-8: will be the NPA to change from a period and the NPA to change to
		In the example below for tandem SY if the npa is 208 we will change to 211.
CABS-SPECIAL-TANDEM	SY	Field3: 208.211
CABSNO	The special cycle code like 2 or 3 etc. 1 character only	We have made it so you can specify if you have a Special Billing cycle that does not have any CABS Billing so that you do not get an error messages when you run #15 to close out the files for the month. This is only for Special Billing Cycles that most of you do not have at this time. The system then looks for these codes and creates the necessary files that are normally created as you do CABS Processing. Run #15, 'Key Edit Fields/Parameters' and set up a new edit code: Field 01: CABSNO Field 02: The special cycle code like 2 or 3, etc. 1 character only Field 03: CABSNO The example below would cause the necessary CABS files to be built in Billing Cycle 2 without having to run the month end CABS Reports.
CABSNO	2	CABSNO
CABSNOTERM0000		Use this code to tell the system to throw out all Terminating Traffic for Carrier 0000. It is probably a combination of data from the switch. Fields 2-8 are blank
CABSNOTERM0000
CALLER-ID-FROM	DIRECTORY	This user edit will get the name for Calling Name Delivery from the Directory file. In the example below the name in the Calling Name Delivery file would come from the directory file.
CALLER-ID-FROM	DIRECTORY
CALLING-PLAN-AUTO		This user edit will be used when you have 1 calling plan and need to automatically add a second calling plan. Field2: Blank Field3: From Tariff code 1 (enter the current calling plan tariff code) Field4: To Tariff code 1 (enter the new calling plan tariff code) Field5: From Tariff code 2 Field6: To Tariff code 2 Field7: From Tariff code 3 Field8: To Tariff code 3 Be sure to enter leading spaces on tariff codes. The following example will add NW1 to anyone that has TRF01, NW3 to anyone that has TRF2, NW4 to anyone that has TRF03
CALLING-PLAN-AUTO		Field2: Field3: TRF01 Field4: NW1 Field5: TRF2 Field6: NW3 Field7: TRF03 Field8: NW4
CALLNAMENLA		This code tells the system when sending calling name delivery information. You can send Non List numbers with presentation indicator 'A'. This example will cause the Non List numbers to be sent in the calling name delivery with presentation indicator 'A'.
CALLNAMENLA
CASH-RECEIPT	PREDEFINED-DESCRIPTN	This edit will fill a dropdown list box in Riata Cash Receipts with the predefined descriptions that are in Fields 3-8. After a predefined description is selected from the dropdown list it will be moved automatically to the Description detail field and saved with the Cash Receipt. Field 1: CASH-RECEIPT Field 2: PREDEFINED-DESCRIPTN Fields 3-8: Each field contains a description to display in the dropdown list Multiples of this user edit are allowed. In the example below the description dropdown list in Cash Receipts will contain “Deposit – Phone”, “Deposit – Internet”, and “Inventory Return”
CASH-RECEIPT	PREDEFINED-DESCRIPTN	Field 3: Deposit - Phone Field 4: Deposit - Internet Field 5: Inventory Return
CASH-RECEIPT-MONEYT	Location Code	This edit will allow you to add money types to the Cash Receipt dropdown list. In Field 2 enter the 2 character location code. In Fields 3, 5 & 7 enter the 1 character Money Type followed by the description. In Field 4,6 & 8 enter the G/L Account Number with the decimal point and extension (xxxx.xx). If you wish you may also enter the G/L Company number after this preceded by a hyphen. (example 1180.10AAAAA-10) Field 1: CASH-RECEIPT-MONEYT Field 2: Location Code Field 3: AMoney Type Description Field 4: G/L for Money Type in field 3 (-Company number) Field 5: BMoney Type Description Field 6: G/L for Money Type in field 5 (-Company number) Field 7: CMoney Type Description Field 8: G/L for Money Type in field 7 (-Company number) Field 3 & 4 work together, Field 5 & 6 work together, Field 7 & 8 Work Together. They all have the same concept. Field 3 has the code and description. Field 4 has the G/L Account # with the decimal point and then the extension; the company number may be added as well preceded by a hyphen. The Money type code is entered in the first space leaving 19 spaces on the same line for the description. The edit below will add each money type to the Cash Receipt Dropdown list. "This is Money Type A" and "This is Money Type F" will be displayed in the drop down list. Note: Each Money type code may be entered only once per location. If it is found again it will not be displayed. The following Money type codes are already in use by system: " "'(Blank) - Checks, "B" - Currency, "C" - Coin, "D" - Direct Deposit, "E" - Credit Card, "I" - Discover, "M" - Master Card, "V" - Visa or Master Card, "X" - American Express, and "1" - None. Note: If you would like to have an existing money type go to a different G/L from what is in the G/L control file, Enter it the same way and add the G/L with the extension on the line below the Code. (You may also indicate the G/L company number preceded by a hyphen) In the example below you will see the "This is Money Type A" and "This is Money Type F" in the dropdown list in Cash Receipts. You will also see it on the print out when that money type is used. When you close out 1130.30 in company 50 will be used for the "B" (Currency) money type.
CASH-RECEIPT-MONEYT	02	AThis is Money Type A 1130.10 FThis is Money Type F 1130.20 BCash 1130.30 -50
CASHRECEIPT		This explains where Information can be found when running the Cash Receipt Program. Field 01: CASHRECEIPT Field 02: Company or Location code (01, 82, 84, RP) Field 03: Company Logo .GIF Fields 04-05: LEAVE BLANK Field 06: Second Company Logo .GIF Fields 07-08: LEAVE BLANK The example below would Print the CTI.GIF Graphic (Logo) on the Customer's CashReceipt Receipt. *Note: Your Logo will need to be in the same folder as your RIATA Programs:(Usually this is your ‘RIATABILL’ Folder) Example: C:\RIATABILL\cti.gif OR C:\RIATABILL\riata.bmp
CASHRECEIPT	84	To Setup or Change Your Logo on Cash Receipt Receipts. In the ‘Edit File Information’ Screen; Place a 9 (Add) or 2 (Change) in front of CASHRECEIPT. In Field 03, Enter your Logo File Name (Example: cti.gif OR riata.bmp). Press Enter, then F3 to Exit. 'YOUR LOGO IS NOW ADDED OR CHANGED & WILL APPEAR ON ALL PRINTED CASH RECEIPTS'
CASHRECEIPT	EACH-USER-GL	If this user edit exists then when a CSR closes out cash receipts then it will automatically take them into post their entries to the G/L. There is still an authorization code that the accounting dept can set up for themselves to be able to have the Post Cash Receipts on their Riata Program Menu. That authorization code is not needed for each CSR. Fields 3-8 = 2 Character Company Number followed by the 8 Character Library
CASHRECEIPT	EACH-USER-GL	Field 3 = 01TNDATA 18TNDATA Field 4 = 02TNDATA Field 5 = Field 6 = Field 7 = Field 8 =
CASHRECEIPT	GL-ENTRIES-BY-MNYTYP	When posting cash receipts if you desire to have G/L entries broken down by money type, use this user edit. If the word "ALL" is entered in field 3, we will break down all entries by money type. If the word "CASH-ONLY" is entered in field 3, we will break down cash entries by money type. If the word "EXPENSE-AR-ONLY" is entered in field 3, we will break down AR entries by money type. Example:
CASHRECEIPT	GL-ENTRIES-BY-MNYTYP	CASH-ONLY
CASHRECEIPT	PDFSAVEPATH	This user edit indicates the location where the cash receipt PDF files will be saved. Fields 3-8 are added together to form the path. This is the default. Also see CASHRECEIPT-PDFSAVE which can be different by location.
CASHRECEIPT	PDFSAVEPATH	C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
CASHRECEIPT	SCAN-IGNORE-WARN	This edit will prevent some of the warning messages from being displayed when scanning in Cash Receipts. (Fields 3 through 8 - leave blank) These messages will not be displayed: "This Account has a Payment Promise." "This account has the following Recurring charge(s):" for NOTIFYTARIFF user edit and warning tariffs "The amount entered is negative. Please select "Net" if needed." "One of your line items has a credit balance. Please confirm you are happy with the way this payment is spread." "This Account has sub Accounts. You will need to make sure the Cash Receipt goes to the correct Account." These messages will still be displayed: "This Account has the following Error Tariff(s)" "This Account is in the Disconnect File." "This Account has a PERMANENT disconnect." "This Account has a TEMPORARY disconnect." "Make sure the company is correct": (if "//NEW" is found in the first or last name or the company is 0.) "The account type is not an "Active Account"." "This Account is expecting a deposit or some other type of special cash." The example below will skip some of the warning messages displayed when the user is scanning in Cash Receipts. Note: This edit works with the “Scan” check box in Cash Receipts entry screen 2. If the “Scan” is not checked this edit will not work and you will see all warning messages the customer has.
CASHRECEIPT	SCAN-IGNORE-WARN
CASHRECEIPT-DEPOSIT	TARIFF	This user edit will store the tariff code used when updating the Cash Receipt Deposits. The tariff code will be used when creating the non recurring charge. Field 1: CASHRECEIPT-DEPOSIT Field 2: TARIFF Field 3: Tariff Code In the example below, the tariff code TARF1 will be used for the non recurring charge.
CASHRECEIPT-DEPOSIT	TARIFF	Field 3: TARF1
CASHRECEIPT-PDFSAVE	BURLEY	This User edit will allow you to save your Cash Receipts PDF documents to a path based on location. You will need to have the "S2PCINFO" user edit already setup with the location in field 7 to use this. This would be used if you have different locations that use Riata Cash Receipts and want to save the PDF documents in a different folder for each location. To set this up: Field 1: CASHRECEIPT-PDFSAVE Field 2: Location (Same as field 7 of S2PCINFO) Field3-8: The path to save the PDF. In the Example below, the Cash Receipts PDF documents will be saved to N:\CashReceipts
CASHRECEIPT-PDFSAVE	BURLEY	N:\CashReceipts
CASHRECEIPTCSVCONVRT		This edit is used to remove the double quotes or single quotes from a .csv file so it can be read into Riata Cash Receipts. This edit will read the existing file and save to a new .csv file called CSVGOOD.csv. To set this up: Field 1: CASHRECEIPTCSVCONVRT Fields 2-3: Leave Blank Fields 4-8. The path to save the new file. In the example below, the system will read the .csv file selected , remove the double quotes, write the record to CSVGOOD.csv located on the C:\ drive. After the selected file has been converted, CSVGOOD.csv will be read into Riata Cash Receipts. Note: The CSVGOOD.csv file will be cleared each time this is ran.
CASHRECEIPTCSVCONVRT		C:\
CASHRECEIPTCSVIN	LINE1HEADING or Blank	This User Edit is used if you want to read .csv files (from Excel) into Cash Receipts. Fields 2-8 are used to know which Columns contain the Account Number, Sub-Account Number, Amount, Description and G/L Account Number. Field 2, enter 'LINE1HEADING' if the first line of your file is used for headings. If entered, the first line will be skipped. Or leave Field 2 Blank and all lines in the file will be read. Field 3 is the column that has the Account Number. Field 4 is the column that has the Sub-Account Number. Field 5 is the column that has the Amount (Dollars & Cents). Field 6 Leave Blank. Field 7 is the column that has the Description. Field 8 is the column that has the G/L Account Number. Note: If the Account and Account sub share the same column, leave Field 4 blank and place the column containing the Account Number and Sub-Account Number in field 3. The length of the Account and Sub-Account Numbers will need to match the Account # Length and Sub-Account # Length on the first screen of # 14 “Common Defaults” from the BAAMN1 menu. In the example below the Account Number is found in column "S", the Sub-Account Number is found in Column "T", the Amount is found in column "R", and the Description is found in Column "C" of your .csv (Excel) file.
CASHRECEIPTCSVIN	LINE1HEADING or Blank	Field 2: LINE1HEADING or Blank (Blank Reads First Line) Field 3: S Field 4: T Field 5: R Field 6: Field 7: C Field 8: D
CASHRECEIPTDEPOSITGL		This code is used to set up all the Deposit G/L Accounts. This would be used if you have different G/L Accounts for different companies. If you only have one account, it can be set up in the control file. If you use this method, you still need to have the question in the control file to update deposits from cash receipts. This is on screen 5. Leave field 2 blank. Fields 3-8 will have the g/l accounts. Only put one per line. Key the six digit account + the extension. Key leading zeros in the main account. The extension starts immediately after the main account. If you do not use the extension, just leave blank. Example: 999999xxxxx. The following example will cause any cash receipts with any of the G/L's listed to be considered deposits.
CASHRECEIPTDEPOSITGL		111111aaaaa 222222bbbbb 999999xxxxx
CASHRECEIPTFROMINQ		This User Edit is used to setup the 'Cash Receipt Defaults' when selecting the 'Enter Cash Receipts' button from Riata Inquiry. Defaults are only used if the Account has not ever had any Cash Receipts posted. Field 2 = Leave Blank Field 3 = First 3 characters is the REV (Revenue belongs to), next 2 characters is the TY (Service Type) and the next 1 character is the Deny Code. Example: Revenue Code ‘PRO’ and Service Type ‘CA’ and Deny Code ‘Y’ would be entered as; PROCAY Field 4 = G/L Account Number followed by the 5 character Sub Account Number without any spaces between. Example: xxxx.xxsssss or 4010.25ABCDE Field 5 through 8 = Leave Blank
CASHRECEIPTFROMINQ		Field 3 = PROCA1 Field 4 = 4010.25ABCED Field 5 through 8 =
CASHRECEIPTGLACCTS		This will load G/L Account within a range into the G/L Selection dropdown list box in the Cash Receipts program. Enter CASHRECEIPTGLACCTS' in field 1, leave field 2 blank, and add the G/L range in fields 3-8. This range consists of a “From” and “To” number separated by a hyphen. The example below will load any G/L accounts in the range(s) given including the “From” and “To” number. Note: The “From” and “To” numbers can not include G/L extensions.
CASHRECEIPTGLACCTS		0005.00-0010.00 1010.21-1099.99 4150.19-6500.00
CASHRECEIPTGLDROP		This is used in the Cash Receipts program to fill the G/L Drop-down list Boxes. To Set this Up: Enter 'CASHRECEIPTGL' in Field 1, leave Field 2 Blank, and Add the G/L description in Field 3 with the G/L Number & Extension in Field 4. The following will place the 'CUSTOMER DEPOSIT' description in the Drop-down. If it is selected '4040.00' will be placed in the G/L and '12345' will be placed in the Extension.
CASHRECEIPTGLDROP		CUSTOMER DEPOSIT
		4040.001235
CASHRECEIPTNONOTE		Used this edit to disable the 'Print description on statement' on the Cash Receipts detail screen. With the check box disabled the description entered will not go to the customers notes or print on the statement. The example below will make it so the user can not place a check in the 'Print description on statement' in Cash Receipts on the detail screen.
CASHRECEIPTNONOTE
CASHRECEIPTPULLDATES		Setup this User Edit to allow a Cash Receipts Cut-Off Date to be entered during Monthly Billing. (Cash Receipts entered after the date used in the Monthly Billing will not be on the Customers Statement for that month). Fields 2 through 8, leave blank.
CASHRECEIPTPULLDATES
CASHRECEIPTREF#		This code is used for cash receipt reference number so that it is easy to tell which G/L entries are in the same billing month. The system automatically sets this code up in #4 of month end billing. All Cash receipts for a billing month have the same reference #. Field 03 has the 2 digit reference #. Field 04 has # of Billing Cycles for active accounts.
CASHRECEIPTREF#
CASHRECEIPTTEXTIN	POSITIONS	This is used for the system to know the format for a Text (txt) File that you want to read into Cash Receipts. Fields 3-7 have the start position and then a - followed by the length to read in. Field 3 is for the position for the Account #, Field 4 is for the position for the Sub Account #, Field 5 is for the position for the Dollar Portion of the Amount, Field 6 is for the Cents Portion of the Amount, and Field 7 is for the position for the Description.
CASHRECEIPTTEXTIN	POSITIONS	Field 3: 1-8 (Account # Starts at Position 1 and is 8 characters long) Field 4: 11-4 (Sub-Account # Starts at Position 11 and is 4 characters long) Field 5: 20-9 (Dollar Amount Starts at Position 20 and is 9 characters long) Field 6: 30-2 (Cents for Amount Starts at Position 30 and is 2 characters long) Field 7: 40-20 (Description Starts at Position 40 and is 20 characters long)
CASHRECEIPTSNOBANKRC		This tells the system that you do not want it to make Bank Reconciliation entries from Cash Receipts. With this code G/L entries will be made but not Bank Reconciliation entries. Without it, they will both be made. Fields 2-8 are left blank.
CASHRECEIPTSRIATA		This code is used to tell the system that you are using Riata Cash Receipt Entry Program
CASH-SPECIAL1	CODES	This edit is used in Cash Receipts for setup in the Pre-Paid screen. This User Edit works with the CASH-SPECIAL1 DESC user edit and tells the system if the amount is apples to the customer account, who the revenue belongs to, and the G/L information. The first position in fields 3-8 is if the cash receipt is applied to the customer account. (Y or N) Position 2 will be a period Position 3-5 will be who the revenue belongs to. Position 6 will be a period Position 7 – 18 will be the G/L Account number (Including the period) and G/L extension. Note: if the Cash Receipt is not applied to the customer Account, you will need to enter a Valid G/L account. In the first example below, the Amount will be applied to the customer account and the revenue will go to PMT. In the second example the amount is not applied to the customer account and will go to “1180.01” Extension “ABC” in the G/L.
CASH-SPECIAL1	CODES	Field 3: Y.PMT. Field 4: N. . 1180.01ABC
CASH-SPECIAL1	DESC	Use this edit for the captions in the Pre-Paid screen. Field 3 will be the caption just below the Number of Days, field 4, will be the second field below and so on. The edit works with the CASH-SPECIAL1 CODES user edit. The caption in field 3 of this user edit coincides with field 3 of CASH-SPECIAL1 CODE. The same goes for fields 4 – 8. In the example below, the caption for the field just below the Number of Days field in the Pre-Paid program will be “Local $ Service”. Two down will be “Local $ Other”, and three down will be “BCGI”.
CASH-SPECIAL1	DESC	Field 3: Local $ Service Field 4:Local $ Other Field 5: BCGI
CBRSM7SS7TERM		This user edit is used when you need to include switch seconds in the elapsed time for terminating calls when creating category 11 records from SS7 records. To set this up, Field 1: CBRSM7SS7TERM Field 2 - 8: Leave Blank The example below would cause the switch seconds to be included in the elapsed time for terminating calls when creating Category 11 records from SS7 records.
CBRSM7SS7TERM
CELL-DROP-BNS		Use this edit to drop a number from BNS if it is a cellular. You can leave fields 3-8 blank and the system will look just at the tariff codes to tell if Cellular. If you enter npanxx.npanxx.npanxx in fields 3-8 the system will do a 2nd check and drop all records except for the npanxx's that you have entered. The example below would cause the cellular number to be dropped from BNS.
CELL-DROP-BNS
CELL-DROP-CNAM		Use this edit to drop a number from CNAM if it is a cellular. You can leave fields 3-8 blank and the system will look just at the tariff codes to tell if Cellular. If you enter npanxx.npanxx.npanxx in fields 3-8 the system will do a 2nd check and drop all records except for the npanxx's that you have entered. The example below would cause the cellular number to be dropped from CNAM except for NPA (208) NXX (434) and NPA (208) NXX (343).
CELL-DROP-CNAM	208434.208434
CELLPLAN1		This code is for PCS Plan setup. This is used if charging for Roam &Toll based on the total number of minutes used. Field 2 needs to have the PCS Plan Tariff Code. Fields 3-8 will have the minutes & amount to charge for the minutes. There are 3 parts to these lines. 1.Minutes 2.Charge 3.Increment '00100-0000.00-ALL' Will give 100 minutes for zero charge. '00500-0025.00-ALL' Will charge $25.00 for 500 minutes '99999-0010.00-00050' Will charge $10.00 for each 50 minutes for all the remaining minutes. This example will give the first 100 minutes free. Charge $10.00 for the next 200. Charge $5.00 for each additional 50 minutes. Plan tariff code is PCS20.
CELLPLAN1	PCS20	00100-0000.00-ALL 00200-0010.00-ALL 99999-0005.00-00050
CHANGE-REMOVE-NUMBER	CHECK-NON-RECURRING	This edit will automatically place a check in the "Move Non-Recurring Charges" in the Phone Number Change/Remove screen in service order entry when the user selects "Move to Different Account" Field 1: CHANGE-REMOVE-NUMBER Field 2: CHECK-NON-RECURRING In the example below, If the user selects to “Move to Different Account” from the “Phone number Change/Remove screen”, the system will check “Move Non-Recurring Charges”.
CHANGE-REMOVE-NUMBER	CHECK-NON-RECURRING
CHECKTARIFFMAINBILL#		This code tells Riata the tariffs that are associated with main billed numbers only. When the user clicks the update button on the phone tab program, if the number is billed to itself, and has any of the tariffs listed in fields 3-8, a message is displayed letting the user know the tariff is and gives and opportunity to stop the update. The tariffs are also displayed on the "Telephone Number and Location" screens in Service Order Entry and Inquiry in the special notify list. Field 1: CHECKTARIFFMAINBILL# Field 2: Leave blank +C811 In the example below if the number is billed to itself and it has TRF1, a message will be displayed letting the user know that the number has TRF1 and that it is not a main billed number.
CHECKTARIFFMAINBILL#		MBIL1.MBIL2.MBIL3. TRF1. TRF2. TRF3. TARF1.Tarf2.Tarf3.
CK800	TARIFF	Checks to see if a customer with an 800 number has a corresponding recurring 800 tariff and vice versa. The example below would verify that the customer has an 800 number.
CK800	TARIFF	800#
CKACCT1ST	Starting Account #	Can limit what is shown in the Company Code drop down-box in the Phone Tab Program (Screen B-03:A) and Account Tab Program (C-01:A) based on the first digit of the account #. This edit takes precedence over the Company Code based on the NPA NXX edit. In the example below, only Companies 2, 4 and 5 would be loaded in the Company list box on the Bill Info Tab if the first character in the account number is '4'. Please review CKACCT1STA also. If you use also CKCOMPCD you probably want to use CKACCT1STA
CKACCT1ST	4	2 4 5
CKACCT1STA	Starting Account #	This controls what is shown in the Company Code drop- down box in the Account Program based on the first digit of the account #. Field 01: CKACCT1STA Field 02: First character in the account number Fields 03-08: Company number (Left Justified) Note: CKACCT1ST applies to both the Phone and the Account programs. CKACCT1STA applies to the Account program only. The example below would cause Company 4 would be shown in the Company drop-down in account numbers beginning with '3'.
CKACCT1STA	3	4
CKBNSCODE	TARIFF	This checks to see when a customer has specified tariffs, that on the 'Other' tab, their BNS Code is 'Block 3^rd # and Collect'. The example below would cause the BNS Code field on the 'Other' tab to be checked to see if it is 'Block 3rd # & Collect' if the customer had a recurring tariff of DEN1+ or TOLRS.
CKBNSCODE	TARIFF	DEN1+ TOLRS
CKCOMPCD	NPANXX	Allows you to limit what is shown in the Company Code drop-down box based on a given NPA and NXX. Used to load drop-down. The example below would cause any phone # with 435528 to show only code 1 & 2.
CKCOMPCD	435528	1 2
CKCYCLE	CO and number	Only allows certain Billing Cycles to be available for selection once you have chosen a 'Company Code'. (Field 3 through 8, enter Billing Cycles) The example below would cause only Billing Cycle 2 & 6 to be available for Company 01.
CKCYCLE	CO1	2 6
CKMEMBERE		This is a special item for Emery Telcom for special account numbers. The example below would display a message on the Telephone Number and Location screen if the account is Company 1 and the member number is 011001 (Fictional) or is greater than 300,000.
CKMEMBERE
CKMEMBERS		This is a special item for South Central for special account numbers. Fields 2 and 3 are left blank. The example below would cause special South Central Member Number check to run.
CKMEMBERS
CKSAMELOCATION		Lets the user know if the Location address for a telephone number is being duplicated. This will check the address (on Location Tab) if the Service Order type is 'New Install' or 'Reconnect' and the address has a house number, street name, and city. Field 02-08: Leave blank Note: Phone numbers that are disconnected will not be displayed in the message. This only checks the phone number addresses. It will not check addresses for ID numbers. The example below would cause a message to pop up if the address is duplicated and will let the user know the account and phone number of the duplicated address.
CKSAMELOCATION
CKSVOPROBLEM		This is used to automatically start the Problem Service Order program. Field 01: CKSVOPROBLEM Field 02: Leave Blank Field 03: Number of minutes to delay (left justified) Fields 04-08: Leave Blank The example below would cause any problem Service Orders to automatically be displayed and then re-display every 20 minutes.
CKSVOPROBLEM		20
CKTAXCITY	NPANXX	Allows you to limit what is shown in the City drop-down box on the Tax tab based on a given NPA and NXX. Used to load drop-down. The example below would cause any phone # with 208436 to show only codes GU and ZZ.
CKTAXCITY	208436	GU ZZ
CKTAXSTATE	Company #	Can limit what is shown in the State tax drop-down box based on company. Used to load drop-down. The example below would cause any phone # with Company 2 to show only codes WY, MT & NM.
CKTAXSTATE	2	WY MT NM
CKTAXSTATED	NPANXX	Allows you to limit what is shown in the State Tax District drop-down box on the Tax tab based on a given NPA and NXX. Used to load drop-down. The example below would cause any phone # with 435528 to show only codes 1 and 2.
CKTAXSTATED	435528	01 MD
CKVACREADD	TARIFF	Lists the vacation tariffs and the minimum number of months between when they removed the tariff and when the tariff can be re-added. Fields 03-07: Vacation Tariffs Field 08: 2 digit # of months The example below would not allow the Internet Basic Package to be available again for 6 months.
CKVACREADD	TARIFF	NET2 06
COMMISSION-AMOUNTS		This user edit is for the generations of commissions in the sales report (T34BLSL01) Field2: Blank Fields3-6 Follow this structure: XXXXXXXXXXXX####.##P X's represent the description #'s represent the dollare amount P represents percentage. Q in it's place would represent Quantity. P would mean they get paid a percentage of the total (#) Q would mean they get paid the # amount per quantity Example:
COMMISSION-AMOUNTS		Field3: PRIMARY 5.00Q
		Field4: SHARE 2.50Q
		Field5: FEATURES 100.00P
		Field6: ACCESSORIES 10.00P
COMPANY#ESN		This is used to know which companies to use when searching for the Serial and Electronic Serial numbers in the phone file. This will prevent Pedestal 1 and 2 information from being displayed when looking for the Serial number and ESN. Field 1: COMPANY#ESN Field 2: Leave Blank Field 3: The companies that have Serial ESN numbers Field 4-8: Leave Blank In the example below only company 6 phone numbers that match the search criteria will be displayed.
COMPANY#ESN		6
COMPANYGL	G/L Co. #	Can validate Non-Recurring G/L accounts using a different G/L master. In the example below, if the customer has 3 for the Company number on the Bill Info tab and a non-recurring charge is added, the GL file for Company 05 will be used to validate the GL account on the tariff.
COMPANYGL	3	05
COMPAREFLDS		Compares fields in Phone Number Information against fields in Main Account Information when you update. The differences are shown to you in a window and you then have the option to go back and make changes or continue to update. The example below would cause the data in Phone Number Information to be compared with what is entered in the same fields in Main Account Information when you click 'Update' from 'Phone Number Information'.
COMPAREFLDS
CONFERENCECALLCHARGE		This code is used to determine which tariff codes to use for direct and toll free calls in a conference call. The tariff code in field 3 will be the tariff code for direct calls and the tariff code in field 4 will be the tariff code for toll free calls. Example:
CONFERENCECALLCHARGE		QDIRC QDIRD
CONFERENCECALLCHARGE	PMT	This user edit allows you to process conference calls using PMT's system. In the example below; field 3 is the the number of hours that are specified as a time unit. field 4 contains 3 tariff codes separated by periods: The first is the tariff code used for 1-10 users for 2 time units (1 hour in the example) The second is the tariff code used for an additional time unit (1/2 hour in the example) The third is the tariff code used for 5 additional users field 5 contains 2 tariff codes separated by periods: The first is the tariff code used for a combination of 5 users and an additional time unit (1/2 hour in the example) The second is the tariff code used for recording the call.
		field 3. 0.50
		field 4. CNU01.CNH01.CNU05
		field 5. CNH05.CNR01.
CONFERENCECALLCHARGE	R-QUICKCONNECT	This user edit allows you to process Conference calls for Range Telephone. Enter which Tariff Codes to use for Quick Connect Conference call. In Field 3, Enter the Rate to be charged per Minute in Dollar Amount form with 2 decimal places. In Field 4, Enter the Tariff Code that will be assigned to Quick Connect Conference Calls for Range Telephone Company. Field 2 = R-QUICKCONNECT Field 3 = Rate in Dollar Amount with 2 Decimals (0.50) Field 4 = Enter Assigned Tariff Code Field 5 through 8 = Leave Blank In the Example Shown Below, .50 Cents per Minute will be charged with Tariff Code 'RTFQC' for a Range Telephone 'Quick Connect' Conference Call.
CONFERENCECALLCHARGE	R-QUICKCONNECT	Field 3 = 0.50
		Field 4 = TRFQC
		Field 5 through 8 = Leave Blank
CONFERENCECALLCHARGE	R-QUICKPLAY	This user edit allows you to process Conference calls for Range Telephone. Enter which Tariff Codes to use for Quick Play Conference call. In Field 3, Enter the Rate to be charged per Minute in Dollar Amount form with 2 decimal places. In Field 4, Enter the Tariff Code that will be assigned to Quick Play Conference Calls for Range Telephone Company. Field 2 = R-QUICKPLAY Field 3 = Rate in Dollar Amount with 2 Decimals (0.50) Field 4 = Enter Assigned Tariff Code Field 5 through 8 = Leave Blank In the Example Shown Below, .51 Cents per Minute will be charged with Tariff Code 'TRFQP' for a Range Telephone 'Quick Play' Conference Call.
CONFERENCECALLCHARGE	R-QUICKPLAY	Field 3 = 0.51
		Field 4 = TRFQP
		Field 5 through 8 = Leave Blank
CONFERENCECALLCHARGE	R-QUICKRECORD	This user edit allows you to process Conference calls for Range Telephone. Enter which Tariff Codes to use for Quick Record Conference call. In Field 3, Enter the Rate to be charged per Minute in Dollar Amount form with 2 decimal places. In Field 4, Enter the Tariff Code that will be assigned to Quick Record Conference Calls for Range Telephone Company. Field 2 = R-QUICKRECORD Field 3 = Rate in Dollar Amount with 2 Decimals (0.52) Field 4 = Enter Assigned Tariff Code Field 5 through 8 = Leave Blank In the Example Shown Below, .52 Cents per Minute will be charged with Tariff Code 'TRFQR' for a Range Telephone 'Quick Record' Conference Call.
CONFERENCECALLCHARGE	R-QUICKRECORD	Field 3 = 0.52
		Field 4 = TRFQR
		Field 5 through 8 = Leave Blank
CONFERENCECALLXML		This code is used to determine the path to the xml files to be processed. We concatenate fields 3-8 to obtain the full path. Example:
CONFERENCECALLXML		C:\WINDOWS\SYSTEM\TE STING\FROM\THIS\PROG RAM\THAT\HAS\A\LONG\ PATH
CONTRACT	SIGNATURELOCATION	This code stores the location to the folder that will store the signatures obtained through the handheld signature device.
CONTRACT	SIGNATURELOCATION	C:\THIS\IS\A\LO
		NG\PATH\TO\A\LO
		CATION\TO\STORE\
		SIGNATURES\
CONTRACT	DOCUMENTLOCATION	This code is used to know the location of the contract documents that can be opened using Microsoft Word. Field 01: CONTRACT Field 02: DOCUMENTLOCATION Fields 03-08: Enter the location where the Contracts are located Put the first twenty characters in field 3 the next 20 in field 4 and so on. The maximum location length is 120 characters. The example below will look for the Contract Word documents in the N:\Shared Drive\Customer\Contracts folder.
CONTRACT	DOCUMENTLOCATION	Field3: N:\Shared Drive\Customer Field4: \Contracts
CONTRACTLENGTHTAR		This tells us the number of months to automatically place in the contract length field of the contract screen. Field 2 is the tariff code Field 3 is the number of months
CONTRACTLENGTHTAR	XXXXX	Field 3 = 24
CONTRACTTARIFFCODES		This ties tariff codes to contracts so we know to launch the contract program when a certain tariff code is selected. Field 2 is the contract type. Fields 3 - 8 are the tariff codes. Each tariff code is separated by a period. If more than 18 are linked to a contract you can have multiple user edits.
CONTRACTTARIFFCODES	CONT1	Field 3 = XXXXX.YYYYY.ZZZZZ Field 4 = XXXXX.YYYYY.ZZZZZ Field 5 = XXXXX.YYYYY.ZZZZZ Field 6 = XXXXX.YYYYY.ZZZZZ Field 7 = XXXXX.YYYYY.ZZZZZ Field 8 = XXXXX.YYYYY.ZZZZZ
CPNI		This edit is used to let the system know the default for CPNI and disable the “Not Selected” option. Field 2: Blank (Not Used) Field 3: Blank = “Not Selected” “Y” = “Give Out” “N” = “Do Not Give Out” Field 4: REQUIRED – will disable the “Not Selected” option Field 5 - 8: Not Used The following example will make “Give Out” the default and will disable the “Not selected” option.
CPNI		Field 3: Y Field 4: REQUIRED
CPNI-AUTHORIZATION		This edit is used to fill the Authorization dropdown box for CPNI verification. The user will need to select one from the list to continue viewing customer information in Riata. Field 1: CPNI-AUTHORIZATION Field 2: Leave Blank Field 3-8: In the Example below the dropdown box will be contain, “TRAINING”, “OUTSIDE PLANT”, “PHOTO ID”, “ANSWERED SECURITY”, and “KNEW PASSWORD” in the CPNI Authorization program. The user will need to select one in the list to continue and view/edit information in Riata.
CPNI-AUTHORIZATION		Field 1: CPNI-AUTHORIZATION Field 2: Field 3: TRAINING Field 4: OUTSIDE PLANT Field 5: PHOTO ID Field 6: ANSWERED SECURITY Field 7: KNEW PASSWORD Field 8:
CPNI-CHANGES	CPNI-GRIDS	This user edit is used to let the system know the folder to save the e-mail grid in the CPNI Changes program Field 1: CPNI-CHANGES Field 2: CPNI-GRIDS Field 3-8 The folder to save the CPNI grids to from the CPNI changes program In the example below, the CPNI Changes program will use "N:\Documents\CPNI Grids\" folder to save the e-mail grid.
CPNI-CHANGES	CPNI-GRIDS	Field 3: N:\Documents\CPNI Gr Field 4: ids\
CPNI-CHANGES	DOCUMENT-PATH	This user edit is used to let the system know the path and Microsoft Word document to use for the CPNI Changes program Field 1: CPNI-CHANGES Field 2: DOCUMENT-PATH Field 3-8 The path for the Microsoft Word document In the example below, the CPNI Changes program will use "N:\Documents\CPNI Merge document.doc" for the text document
CPNI-CHANGES	DOCUMENT-PATH	Field 3: N:\Documents\Merge d Field 4: ocument.doc
CPNI-CHANGES	EMAIL-SUBJECT	This user edit is used to let the system know what to put in the the subject line for the email in the CPNI Changes program Field 1: CPNI-CHANGES Field 2: EMAIL-SUBJECT Field 3-8 The subject for the email In the example below, the CPNI Changes program will use "Account information changes" for the subject of the email.
CPNI-CHANGES	EMAIL-SUBJECT	Field 3: Your account informa Field 4: tion has changed
CPNI-CHANGES	FROM-EMAIL-ADDRESS	This user edit is used to let the system know the "From Email Address" to use when Emails are sent to Customers for the CPNI Changes program Field 1: CPNI-CHANGES Field 2: FROM-EMAIL-ADDRESS Field 3-8 The from email address to use In the example below, the CPNI Changes program will use "cti3@pmt.org" for the from email address
CPNI-CHANGES	FROM-EMAIL-ADDRESS	Field 3: cti3@pmt.org
CPNI-CHANGES	MAIL-SERVER	This user edit is used to let the system know the email server for the CPNI Changes program. You will need to get the Email Server to Use from your Internal IT personal. Field 1: CPNI-CHANGES Field 2: MAIL-SERVER Field 3-8 The email server to use In the example below, the CPNI Changes program will use "smtp.pmt.org" for the email server
CPNI-CHANGES	MAIL-SERVER	Field 3: smtp.pmt.org
CPNI-CHANGES	MESSAGE-TEXT-PATH	This user edit is used to let the system know the path and file where the Email Message is located that is used for the CPNI Changes program Field 1: CPNI-CHANGES Field 2: MESSAGE-TEXT-PATH Field 3-8 The path for the message to use In the example below, the CPNI Changes program will use "N:\Documents\CPNI email.txt" for the text document
CPNI-CHANGES	MESSAGE-TEXT-PATH	Field 3: N:\CPNI\CPNI_changed Field 4: _email.txt
CPNI-NOT-SVO-ENTRY		This user edit is used to skip the CPNI authorization screen in Riata “Service Order Entry” and “2007 Service Order Entry”. It will, however, still require CPNI authorization in Riata Inquiry. The Example below will require CPNI authorization in Riata Inquiry but not in Riata Service Order Entry or 2007 Service Order Entry.
CPNI-NOT-SVO-ENTRY
CPNI-NOTES	ALWAYS-SHOW	We have created a new User Edit to show the CPNI notes by default in Customer Account Information and Phone Number Information screens in Riata Inquiry. Field 1: CPNI-NOTES Field 2: ALWAYS-SHOW In the example below, when the user goes to the Notes tab in Customer Account Information and Phone Number Information screens in Riata Inquiry the "Hide CPNI Notes" checkbox will be unchecked by Default.
CPNI-NOTES	ALWAYS-SHOW
CPNI-OPTION		This edit is used to let the system know to use the CPNI program in Riata Service Order Entry, Inquiry, and 2007 Service Order Entry. Field 01. . . . . CPNI-OPTION Field 02. . . . . Field 03. . . . . OPTION1 Field 04. . . . . Field 05. . . . . Field 06. . . . . Field 07. . . . . Field 08. . . . . In the Example below, when the user has selected a customer to work with, the CPNI screen will be displayed and the user will need to select a Authorization reason from the dropdown list.
CPNI-OPTION		Field 03. . . . . OPTION1 Field 04. . . . . Field 05. . . . . Field 06. . . . . Field 07. . . . . Field 08. . . . .
CPNI-QUESTION		This Edit is used for those companies that already have CPNI authorization questions set up on the "User Defined" screen. Only use this edit if you already have existing CPNI authorization question(s) set up. To set this up: Field 1: CPNI-QUESTON Field 2: Leave Blank Field 3: Enter the Code for the first CPNI question from User Defined Field 4: Enter the Code for the second CPNI question from User Defined Field 5: Enter the Code for the third CPNI question from User Defined Field 6: Enter the Code for the fourth CPNI question from User Defined Field 7: Leave Blank Field 8: Leave Blank Note: If you do not have the authorization questions set up for CPNI, you can set up to four questions using “User Defined Fields” on the BAAMN3 menu. You will need to use the following codes to set them up: Q#CPNIQ1, Q#CPNIQ2, Q#CPNIQ3, Q#CPNIQ4. Change the “Multiple” to “N” and the “Association Code” to “A” when setting up each of these codes. The example below will use an existing CPNI user defined question that was set up as: “CPNIAUTH” and display the existing User defined in the CPNI Authorization program.
CPNI-QUESTION		Field 3: CPNIAUTH
CPNI-QUESTION1	DEFAULT	This user edit is used to let the system know the default CPNI questions. If the customer does not have CPNI questions already set up, these questions will be displayed on the CPNI Authorization screen and the user can enter the answers for the customer. There is a sixty character maximum for the Security Question and Answer and you will need to enter the question mark at the end of the sentence. Field 1: CPNI-QUESTION1, or CPNI-QUESTION2, or CPNI-QUESTION3, or CPNI-QUESTION4 Field 2: Default Field 3-5: The question to ask. Note: you can enter up to 4 default security questions. Field 1 for the first question will be CPNI-QUESTION1. Field 1 for the second question will be CPNI-QUESTION2 Field 1 for the third question will be CPNI-QUESTION3. Field 1 for the fourth question will be CPNI-QUESTION4. “DEFAULT” will be in Field 2 and the default Question will be in Fields3-5 In the Example below, If the customer has no CPNI questions set up, the system will add "What is your mother's maiden name?" and the user can then enter the answer to the question
CPNI-QUESTION1	DEFAULT	Field 3: What is your mother' Field 4: s maiden name?
CREDIT-BUREAU-STATUS	CODES	This user edit is used to fill the credit Code Dropdown in the Credit Bureau Status program. Field 1: CREDIT-BUREAU-STATUS Field 2: CODES Field 3: Credit Code 10 long left justified Field 4: Description for the code in Field 3 Field 5: Credit Code 10 long left justified Field 6: Description for the code in Field 5 Field 7: Credit Code 10 long left justified Field 8: Description for the code in Field 7 The example below will display "New Account", "On-time payments", and "Excessive debt" in the dropdown list.
CREDIT-BUREAU-STATUS	CODES	Field 3: NEW Field 4: New Account Field 5: ONTIME Field 6: On-time payments Field 7: EXCESSIVE Field 8: Excessive debt
CREDIT-SCORE-SHOW		This User Edit will allow you to determine how the ‘Credit Score’ is displayed on the Customer Account Information in Riata Service Order Entry and Inquiry on the Other Tab. Field 1 = CREDIT-SCORE-SHOW Field 2 = Leave Blank Field 3 = Enter 1 or 2 or 3 or 4 or 5 (See details below) 1 = ‘Credit Score will NOT be displayed in Service Order Entry and Inquiry’ 2 = ‘Actual Credit Score IS displayed in Inquiry. And No Credit Score will be displayed in Service Order Entry. 3 = ‘LOW’ or ‘AVERAGE’ or ‘HIGH’ will be displayed in Inquiry, based on what is entered in Fields 4 & 5. And No Credit Score will be displayed in Service Order Entry. 4 = ‘Actual Credit Score IS displayed in Inquiry and Service Order Entry’ 5 = ‘LOW’ or ‘AVERAGE’ or ‘HIGH’ will be displayed in Inquiry, based on what is entered in Fields 4 & 5. And Actual Credit Score IS displayed in Service Order Entry. Field 4 = XXX (Enter a 3 digit Score – any score less than or equal to this number will be considered LOW) Field 5 = XXX (Enter a 3 digit Score – any score between the score entered in Field 4 and the one entered here will be considered AVERAGE - any score higher than the score entered here will be considered HIGH). Field 6 through 8 = Leave Blank In the Example below, The Actual Credit Score (580) will be displayed in Riata Service Order Entry. In Riata Inquiry a score below 499 will be displayed as "Low", a score between 499 and 599 will be displayed as "Average" and a score above 599 will be displayed as "High". Based on this Average will be displayed in Riata Inquiry for this example.
CREDIT-SCORE-SHOW		Field 1: CREDIT-SCORE-SHOW Field 2: Field 3: 5 Field 4: 499 Field 5: 599 Field 6:
CTITRANS-FOLDER		This is used for the system to know what drive letter you have assigned to CTITRANS Folder
		Example:
CTITRANS-FOLDER		T:
DEFAULTCIC	Company #	This sets up a default Own Toll Carrier PIC for the Current Inter and Intra PIC. This only applies for Our Own Toll Carrier CIC codes. The example below would cause Company 1's current Inter and Intra PIC to default to 0555 as their Own Toll Carrier.
DEFAULTCIC	1	0555
DELINQUENT	EXCLUDETARIFF	Setup this User Edit to 'Exclude' accounts with certain Tariff Codes when deciding who is Delinquent Enter up to 3 tariff codes in Fields 3 through 8. (xxxxx.xxxxx.xxxxx) Field 2 = EXCLUDETARIFF Field 3 through 8 = XXXXX.XXXXX.XXXXX In the Example below, accounts with Tariff Codes, TAR12, THR01 & TRFAB will be Exclude when running Delinquent Accounts.
DELINQUENT	EXCLUDETARIFF	Field 1 = DELINQUENT Field 2 = EXCLUDETARIFF Field 3 = TAR12.THR01.TRFAB
DELINQUENT	INCLUDETARIFF	Setup this User Edit to 'Include' accounts with certain Tariff Codes when deciding who is Delinquent. Enter up to 3 tariff codes in Fields 3 through 8. (xxxxx.xxxxx.xxxxx) Field 2 = INCLUDETARIFF Field 3 through 8 = XXXXX.XXXXX.XXXXX In the Example below, accounts with Tariff Codes, RAR12, TAR01 & SARAB will be Include when running Delinquent Accounts.
DELINQUENT	INCLUDETARIFF	Field 1 = DELINQUENT Field 2 = INCLUDETARIFF Field 3 = RAR12.TAR01.SARAB
DELINQUENTNOTICEMAX		This will allow you to Override the Maximum Amounts that is OK to Not get a Delinquent Notice. The Maximum Dollar Amounts are located on System Maintenance Menu, Option 14 (Key in Control File) page #3. This will allow you to have different thresholds if needed. Field 2 = Description Fields 3 = The Amount to check for $xxx.xx The Example below indicates on 'Wireless-Postpaid' if the balance is under $25.25 no delinquency notice is sent out.
DELINQUENTNOTICEMAX	WIRELESS-POSTPAID	Field 3 = 025.25 Field 4 = Field 5 = Field 6 = Field 7 = Field 8 =
DEPOSITACCOUNTNAME		This code will cause the system to enter the Customer Account # and Name in the G/L Detail for each Customer Deposit, instead of just the total for the G/L Account. This must be used in conjunction with the question in the control file Cash Receipt G/L Entry by Description (Y,N) Y
DEPOSITACCOUNTNAME
DIRECTORY	ADDRESSAPT	You now have the option to include the apartment # in the location address, when you are sending directory information to National Directory Assistance and OSC. Field 03: Y The example below would cause the apartment # to be included in the location address you send to National Directory Assistance.
DIRECTORY	ADDRESSAPT	Y
DIRECTORY	MEMBERNUMBER	This will allow you to exclude phone numbers that are sent to your directory company based upon the Member #. Fields 3-8 can have Member Numbers to exclude. They need to be entered with a period between each member number with leading zeroes. You will be able to put 3 numbers per line. The example below would cause any phone # with one of these member numbers to be dropped from the directory list.
DIRECTORY	MEMBERNUMBER	123456.000001.001122
DIRECTORY	NOPUBOPTION	This allows only published numbers to be sent to your directory company. Enter the option of what to send to your provider. 1 = Send non-pub and non-list 2 = Send only non-list N = Do not send non-pub or non-list. The example below would cause only published numbers to be sent to your directory company.
DIRECTORY	NOPUBOPTION	N
DIRECTORY	NPANXX	Allows you to control various options for Automatic Changes to be sent to your Directory Company. Enter the NPA-NXX for exchanges to NOT send to your directory company. Fields 03-08 are used with a period between each NPANXX so you can have multiple NPANXX's per line. The example below would cause any directory change from any of the listed exchanges to NOT be sent to the directory company.
DIRECTORY	NPANXX	208433.801345.208431 208.437
DIRECTORY	PROGRAM	This tells your system which directory provider you use. Enter the Program name for your directory provider. CTI uses this: JBDIRS1 = National Directory Assistance JBDIRS2 = OSC The example below will tell the system you use National Directory Assistance.
DIRECTORY	PROGRAM	JBDIRS1
DIRECTORY	RANGE	This will determine which changes you do NOT want to send to your directory company. Enter a Range of phone numbers that you do NOT want to send to your directory company. Fields 03-08 are used so you can have multiple ranges. The example below would cause any directory change from any of the phone numbers in the ranges specified to NOT be sent to the directory company.
DIRECTORY	RANGE	2084361912-2900 2084389000-9799
DIRECTORY	TARIFFCODE	This will allow you to exclude phone numbers that are sent to your directory company based upon Tariff Code. Fields 03-08 can have tariff codes to exclude. They need to be entered with a period between each tariff code with leading spaces. You will be able to put 3 numbers per line. The example below would cause any phone number with one of these Tariff Codes to be dropped from the directory list.
DIRECTORY	TARIFFCODE	ABCDE. XYZ.R111R
DIRECTORY-INCLUDE	SPECIAL-IDS	This User Edit will look to see if any Other Listing directory entries have been added to Special IDS. They will be pulled into the normal directory listing. Field 1 - DRECTORY-INCLUDE Field 2 - SPECIAL-IDS Fields 3 - 8 Leave Blanks This example will cause Special Id Other Listings to be pulled in to the regular Directory Listing.
DIRECTORY-INCLUDE	SPECIAL-IDS
DIRECTORY-SECTION	NPANXX	This will allow you to assign a Directory Section to an NPA+NXX combination when exporting the directory. Field 2 - enter the NPA and NXX, (entered without blanks or dash between). Field 3 - enter Directory Section Name. The example below would give all listings with NPA=208 and NXX=436 a directory section of "RUPERT" in the export.
DIRECTORY-SECTION	208436	RUPERT
DIRECTORYALLLOWERCAS		Use this field to have all fields in the directory show with lower case letters. The first letter of each word will be capital and the rest of the letters will be lower case. This involves the name and the address information. Code 'DIRECTORYLOOK4LOWER' will override this code. Key this code in field 1. Leave fields 2-8 blank. The following example will cause directory information to be forced to have lower case letters:
DIRECTORYALLLOWERCAS
DIRECTORYCITYSTATE		This code will cause the 2 character state code to be added to the rest of the address information for directory. This is only if you have selected Address 1, Address 2 or Location City for the Directory City field on the directory tab. Address 3 does this already. These codes generate an address from the bill to information from the account file instead of the location information. This example will cause the state to be included for the directory address if not using the location address.
DIRECTORYCITYSTATE
DIRECTORYDISCKEEP		This code allows you to have a phone # go into the directory even if it is disconnected. An example would be a snow bird. All other directory criteria is checked, so a Non-Pub # with one of these tariff codes will still not be in the directory. Field 1 will have the code Field 2 will be blanks Fields 3 - 8 will have the tariff codes that we look for. The following example will put anyone in the directory who has tariff code SNOWB or T9 if they are disconnected.
DIRECTORYDISCKEEP		SNOWB T9
DIRECTORYDROPCAPADDR		Use this code to drop the address information from a Caption Heading line in the file generated from the directory process. Leave lines 2 - 8 blanks. This example will cause the address to be dropped from a Caption Heading line in the temporary file generated from the directory process.
DIRECTORYDROPCAPADDR
DIRECTORYDROPCOMMA		This code is used to automatically drop commas when creating a directory listing. This will drop commas if the name is coming from the bill info tab or from the Directory Listing field on the directory tab. Any commas in the other listing directory information will not be changed. This example will cause certain commas to be dropped when creating a directory listing.
DIRECTORYDROPCOMMA
DIRECTORYFIRSTNAME		This makes it so that when we send directory off, we know what the first name is by looking for ~= This example will cause a '~=' to be put in front of the first name.
DIRECTORYFIRSTNAME
DIRECTORYINSTALLDATE		This code is used in the directory form within Riata to insure that the message box asking if you would like to update the install date to today's date always appears. This example will make sure that the message box always pops up.
DIRECTORYINSTALLDATE
DIRECTORYLOOK4LOWER		This code is used to control directory information. If this code is setup, we look to see if there is at least 1 lower case letter in the name or address coming from the phone information or directory listing. If there is, we do not change anything to lower case. Other Listings are not affected by this. They will stay just as they are keyed. This overrides codes 'DIRECTORYALLLOWERCAS' and 'DIRECTORYLOWERCASE'. Key this code in field 1. Leave fields 2-8 blank. The following example will make it so directory information coming from the phone information or directory listing to be checked for the presence of a lower case letter. If there is one, no converting from upper to lower case will be done. Other Listings will stay just as they are keyed.
DIRECTORYLOOK4LOWER
DIRECTORYLOWERCASE		This code will let you change the directory name to have lower case letters. The first letter of each word will be capitalized and the rest will be lower case. Code 'DIRECTORYLOOK4LOWER' will override this code. This will only change information that we are getting from the phone file. Information set up in the directory system will not be changed. Leave fields 2-8 blanks. We just look to see if the code is there. This example will cause the directory information to have lower case letters.
DIRECTORYLOWERCASE
DIRECTORYNEEDCITY		This makes it so that when we send directory off, we know what the city is by looking for ~@ This example will cause a '~@' to be put in front of the city name.
DIRECTORYNEEDCITY
DIRECTORYONLYOTHER		Use this code to only include information from Other Listings when doing a Directory Listing. Nothing from the phone number will be included. Normally if there is not an Other Listing for a phone number, the information is retrieved from the phone information. This code will stop this from happening. Key this code in field 1. Leave fields 2-8 blank. This example will cause only the Other Listings information to be included in a Directory Listing.
DIRECTORYONLYOTHER
DIRECTORYONLYPHONE		Use this code to only include information from the phone number when doing a Directory Listing. Nothing from the Other Listings will be included. This code will only get information from the phone number. Key this code in field 1. Leave fields 2-8 blank. This example will cause only phone number information to be included in a Directory Listing.
DIRECTORYONLYPHONE
DISCONNECT-REASON	COMMENTS-REQUIRED	This user edit will force the user to enter comments if the service order they are working on is a Disconnect service order or if all the charges for a Billing Type have been removed. In the example below, the user will need to enter comments if the service order type is a “Disconnect” or if all the charges have been removed for a billing type.
DISCONNECT-REASON	COMMENTS-REQUIRED
DISCONNECTAUTO	COMPANY	Set-Up this User Edit to identify what Company Numbers go with which Disconnect File Codes. If you want all companies to belong to just 1 selection then use A for All. ** Use this User Edit to Distinguish Land Lines, Wireless, Non-Regulated, Etc… Fields 3-8 have a 1 character code, then a period, then a 7 character description, then a period, then the company numbers tied to that code. In the 1st Example All Companies are tied to code A In the 2nd Example Code L has Companies 01236 with a Description of Land, and code M has 45789 with a Description of Miscell.
DISCONNECTAUTO	COMPANY	A.All .0123456789 L.Land .01236 M.Miscell.45789
DISCONNECTAUTO	DROPSWITCHCOMM3TLR	Set-Up this User Edit to identify Tariff Codes used to determine if a number should Not have a Switch Command generated. We generate the switch commands like we normally would then if the number has the Tariff Code; we look for the ‘Key Phrase’ listed in Field #8. If the command has the Key Phrase it is removed. (s=Switch Type, ccc=Code like TLU) Currently the only options for the ccc are TLU and TLR. If you believe you need more options than this please contact CTI. Fields 3-4 = Tariff Codes. You can put up to 3 per line. Enter a period between tariff codes; xxxxx.xxxxx.xxxxx. Field 8 = Key Phrase to look for in the Switch Command. **If you need to drop more Switch Commands Add another User Edit using the same codes in fields 1 & 2. In the example shown, if the Switch Type is 3 and the phone number in question has a tariff code of WTR or WTDU and one of the Switch Commands generated contained the Key Phrase ARW CDW, then the switch command would be removed.
DISCONNECTAUTO	DROPSWITCHCOMM3TLR	WTR. WTDU. ARW CDW
DISCONNECTAUTO	LAUNCH-FROM-CASH-REC	If this user edit exists, a drop down menu will appear on the cash receipts screen where the user indicates they wish to send a toll unrestrict, unsuspend, or undisconnect to the switch. The drop down menu will show the available switch types. (i.e. dms 10, dms 100 wired, or dms 100 wireless) Field 3 will contain the switch types you wish to be enabled in the drop down. Enter them in the first 3 characters of field 3. Example: If you want dms 100 and dms 100 wireless to show up enter 23 in field 3 If you want only dms 10 to show up, enter 1 in field 3 if you want all 3 to show up enter 123
DISCONNECTAUTO	LAUNCH-FROM-CASH-REC	23
DISCONNECTAUTO	MERGE-INTO-EXISTING	If this user edit exists the option to Retrieve from delinquent balance listing will show "Merge into existing". If it is not there, it will show "Keep as separate companies". "Merge into existing" will not remove the previous month. It will just add new accounts/phones from the new aging list and update dates of those which are already in both the new aging list and the old auto-disconnect program.
DISCONNECTAUTO	MERGE-INTO-EXISTING
DISCONNECTAUTO	NO-SWITCH-ERROR-XXXX	This user edit is used in the auto disconnect program. After we send commands to the switch, we scan through those commands to see how many of them have generated an error. If there is an error, we indicate as much to the user. However, there are some errors we do not wish to convey to the user. This is achieved by using this user edit. Multiples can be used with this user edit, however, they cannot be combined. Field1 DISCONNECTAUTO Field2 NO-SWITCH-ERROR-XXXX (The first X is the switch type (ie 3) the last 3 X's are the code TLR, TLU, SUS, etc) Fields 3-8 are key words we will look for in the command. If a command has all key words listed in fields 3-8, we will not display this error as an error. If both examples 1 and 2 are employed, we will look at each user edit entry as it's own command combination...We will not combine them into one. Example 1: If we are sending toll restrict commands to a switch type 3 and we get an error on an "adding" of "deny termination", the error will be ignored.
		Example 1:
DISCONNECTAUTO	NO-SWITCH-ERROR-3TLR	ADO
		DTM
		Example 2:
DISCONNECTAUTO	NO-SWITCH-ERROR-3TLR	ADO
		FMR
DISCONNECTAUTO	NODISCONNECT	Setup this User Edit to Identify the Tariff Codes, which indicate a Number should Not Be Disconnected in Auto Disconnect. Fields 3-8 = Tariff Codes. You can put up to 3 per line. Enter a period between tariff codes; xxxxx.xxxxx.xxxxx. **If more than 18 tariff codes are required, add a new user edit with Fields 1 & 2 being identical to this one.
DISCONNECTAUTO	NODISCONNECT	TAR01.TAR02.TAR03 TAR04.TAR05
DISCONNECTAUTO	NONOTICE	Setup this User Edit to Identify the Tariff Codes which indicate a Number Should NOT be sent a Notice when using Auto Disconnect. Fields 3-8 = Tariff Codes. You can put up to 3 per line. Enter a period between tariff codes; xxxxx.xxxxx.xxxxx. **If more than 18 tariff codes are required, add a new user edit with Fields 1 & 2 being identical to this one.
DISCONNECTAUTO	NONOTICE	TNO01.TNO02.TNO03 TNO04.TNO05
DISCONNECTAUTO	NOTOLLRESTRICT	Setup this User Edit to Identity the Tariff Codes which Indicate a Number Should NOT be sent a Toll Restrict when using Auto Disconnect. Fields 3-8 = Tariff Codes. You can put up to 3 per line. Enter a period between tariff codes; xxxxx.xxxxx.xxxxx. **If more than 18 tariff codes are required, add a new user edit with Fields 1 & 2 being identical to this one.
DISCONNECTAUTO	NOTOLLRESTRICT	TTO01.TTO02.TTO03. TTO04.TTO05
DISCONNECTAUTO	NOTUSINGDISCONNECT	Setup this User Edit if you are NOT using Disconnect on the Auto Disconnect program. Fields 3-8 will be blank
DISCONNECTAUTO	NOTUSINGDISCONNECT
DISCONNECTAUTO	NOTUSINGSUSPEND	Setup this User Edit if you are Not using Suspend on the Auto Disconnect program. Fields 3-8 will be blank
DISCONNECTAUTO	NOTUSINGSUSPEND
DISCONNECTAUTO	NOTUSINGTOLLRESTRICT	Setup this User Edit if you are NOT using Disconnect on the Auto Disconnect program. Fields 3-8 will be blank
DISCONNECTAUTO	NOTUSINGTOLLRESTRICT
DISCONNECTAUTO	STYPE-CASH-REC-REV	If this user edit exists, a drop down menu will appear on the cash receipts review screen where the user indicates they wish to update and launch auto disconnect. The drop down menu will show the available switch types. (i.e. dms 10, dms 100 wired, or dms 100 wireless) Field 3 will contain the switch types you wish to be enabled in the drop down. Enter them in the first 3 characters of field 3. Example: If you want dms 100 and dms 100 wireless to show up enter 23 in field 3 If you want only dms 10 to show up, enter 1 in field 3 if you want all 3 to show up enter 123
DISCONNECTAUTO	STYPE-CASH-REC-REV	23
DISCONNECTAUTO	XXXX	Setup this User Edit to Identify Tariff Codes that will be Added/Removed from the Recurring File and Tariff Codes that will be Added to the Non-Recurring File during Auto-Disconnects. The example shows TLR1 in the 2nd field. This indicates the tariff codes are for Toll Restrict for Phone Company 1. If you wish to list the Tariff Codes for Phone Company 2 on Toll Restricts, the code would be TLR2, etc... Other options are ‘SUS’ for Suspends and ‘DIS’ for Disconnects. These are always followed by the phone company number. Tariff Codes in Fields 3-6 will be separated by a period. Example: xxxxx.xxxxx.xxxxx Field 3 = The Tariff Codes Added to the Recurring File when a number is Toll Restricted, Suspended, or Disconnected (Based on Field 2). Field 4 = The Tariff Codes Added to the Non-Recurring File when a number is Toll Restricted, Suspended, or Disconnected. (Based on Field 2). Field 5 = The Tariff Codes Removed from the Recurring File when a number is Un-Toll Restricted, Un-Suspended, or Un-Disconnected. (Based on Field 2). Field 6 = The Tariff Codes Added to the Non-Recurring File when a number is Un-Toll Restricted, Un-Suspended, or Un-Disconnected. (Based on Field 2). **After the last "." if there is an NS, this means Not on Suspend. Field 7 = The first 5 Characters will be the Special Code, then a Period, then a 2 Character Restrict Transaction Code, then a 2 Character Restrict Status Code, then a Period, then a 2 Character Un-Restrict Transaction Code, then a 2 Character Un-Restrict Status Code followed by a Period. Example: xxxxx.xxxxx.xxxxx
DISCONNECTAUTO	TLR1	12345.XXXXX. ACD. RRRRR.88888. EE. 12345.XXXXX. ACD. QQQQQ.TTTTT.33333. 89898.3344.2255.
DISCONNECTAUTO	TLR-ALTERNATE	This user edit alows you to list an alternate wording for Toll Restrict and Toll Un-Restrict such as "Hotline" and "Un-Hotline". The wording will appear in Cash Receipts where the user is allowed to send a change upon receipt of cash for the account. Field 1: DISCONNECTAUTO Field 2: TLR-ALTERNATE Field 3: (Toll restrict replacement) Field 4: (Toll un-restrict replacement) Example
DISCONNECTAUTO	TLR-ALTERNATE	Hotline
		Un-Hotline
DISCONNECTTDSADD$		This code tells the system to charge each phone/id # a TDS Charge at the time you update the Accounts to TDS. Field 2 is left blank, field 3 has the tariff code for the charge. This example would add a non-recurring charge to all TDS phone/ID #'s using tariff code TDSCG
DISCONNECTTDSADD$		TDSCG
DISPATCH-FREQUENCY		Use this edit to select the number of minutes to wait to run the Dispatch Update again. Field 3 will have the number of minutes to wait. In the example below the number of minutes to wait will be 5.
DISPATCH-FREQUENCY		Field 3: 00005
DISPATCH-NEXT#		Use this edit to enter the next available Dispatch ID#. Field 3 will be the 10 digit Dispatch ID #. In the example below, the next available Dispatch ID# would be 100.
DISPATCH-NEXT#		Field 3 :0000000100
EXPERIAN	VALIDATIONNUMBER	Holds the last validation number we used to track experian credit scores in field 3
		EXPERIAN VALIDATIONNUMBER 00000008
EXPERIAN*ENC	MISC	Encrypted--Holds the username and password to experian and a number of centiseconds we wait before we timeout when obtaining a credit score
		EXPERIAN*ENC MISC username password 300
EXPERIAN*ENC	PATH	Encrypted---Path to the saved credit scores. Fields 3 - 8 concatenated together contain the path.
		C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
FASTPAY	URLPATH	Use this to enter the URL for ASP pages that are needed if you are using Fast Pay to bulk pay credit cards from Riata. If you URL is real long, use fields 3-8 and it will wrap around. In this example the ASP pages would be in http://www.cti-id.com/
FASTPAY	URLPATH	http://www.cti-id.com/
FED-TAX-REFUND		This user edit allows you to enter the Federal Tax Refund Statement message. You can enter two lines Field 3-5 will be for message 1 and Field 6-8 will be message 2. To set this up: Field 1: FED-TAX-REFUND Field 2: Leave Blank Field 3-5: Enter the message you want to print on the statement for line 1. Field 6-8: Enter the message you want to print on the statement for line 2. In the example below The federal tax you paid on Toll is : will be on line 1 and The years are: will be on line 2.
FED-TAX-REFUND		Field 3: The federal tax you Field 4: paid on toll is: Field 5: Field 6: The years are: Field 7: Field 8:
FREEMINUTESLEFTNO		This is used if you are giving some 1 time free minutes and on the statement you do NOT want them to see how many special free minutes they have left.
FREEPAYPERVIEWMOVIES		This User Edit allows you to enter the Number of Free Movies and the Minimum Dollar Amount allowed for a Pay Per View Movie to be considered Free. Enter the Recurring Tariff code that signifies the customer will receive Free Movies in Field 3. Enter the Minimum Amount allowed per movie to be considered Free in Field 4. *Any movie chosen that is over the entered amount will be Skipped and Not eligible to be Free. Enter the Non Recurring Tariff Codes that signify what Pay Per View Movies the Customer will receive for Free in Fields 6-8. *On these Non-Recurring Tariff’s, the amounts will be zeroed out and FREE will be added to the description Field 2 – Leave Blank Field 3 is the Recurring Tariff Code indicating Free Movies. Field 4 is the Number of Free Movies 001-999. Field 5 is the Minimum Amount allowed for each Free Movie to be considered Free. Fields 6-8 will have the Non Recurring Tariff Codes that you have assigned for Pay Per View Movies that are eligible to be Free. You can enter up to 3 Non Recurring Tariff Codes per line. Enter a period between each Tariff Code. Example: xxxxx.xxxxx.xxxxx.
FREPAYPERVIEWMOVIES		Field 2: Field 3: RECTF Field 4: 003 Field 5: 05.00 Field 6: NRCTF1.NRCTF2.NRCTF3 Field 7 -8:
FTPDIRPATH		This is the path to the location where the files reside on the FTP site. Use fields 3-8
FTPDIRPATH	SITENAME	thispathis/
		verylong/
		andin/is/
		notnormal
FTPLOCALPATH		This is the path to the location where you want the files copied when you pull them down from the FTP site. Use fields 3-8
FTPLOCALPATH	SITENAME	C:\thispathis
		verylong\
		andin\is
		notnormal
FTPSITE		This code is used for accessing an FTP site during Toll processing. Field 2 is a description of the site you will be connecting to. This is used in conjunction with FTPLOCALPATH and FTPDIRPATH. Field 3 will contain the address to the site (10.10.10.10) Field 4 will contain the username to the site Field 5 will contain the password to the site Field 6 will contain the port number...if the port is 21 you can leave it blank Field 7 indicates whether the FTP server requires passive mode or not. If the server does require passive mode, enter PASSIVE in this field...Otherwise leave it blank. Field 8 If the server is SFTP, use the following guidelines: Enter SFTP in field 8. If the server is not SFTP use the following guidelines: Indicates whether the FTP server requires ASCII transfer mode or not. If the server does require ASCII transfer mode, enter ASCII in this field...Otherwise leave it blank.
FTPSITE	SITENAME	192.168.0.1
		cti
		ctipassword
		5041
		PASSIVE
		ASCII
GETLISA-BILL-1	TARIFF	This user edit is used to enter the tariff codes used for the codes from the GetLisa file. F3 through F8: (In the first 14 Characters enter the GetLisa Code, followed by a decimal then in the last 5 characters enter the Tariff Code.) (make sure you enter leading spaces if needed on tariff codes) (the codes are case sensitive) In the example below Realtones would have tariff code REAL1, Voice Ringers would have tariff code VRN1, Wallpaper would have tariff code WP1.
GETLISA-BILL-1	TARIFF	F3: Realtones .REAL1 F4: Voice Ringers .VRN1 F5: Wallpaper . WP1
GLACHADDNINES	co#	Use this if your ACH File has to have an even # of records grouped by 10 for the bank to accept it. This adds the appropriate # of records with 99999's in it to meet their specs. In this example company 18 ACH files will have additional records added that are all 9's
GLACHADDNINES	18
GLCONTROLLIBRARY		This is used to control what is displayed in the drop down box for the 'Library' in G/L Control on the Riata Programs Menu. This User Edit must be setup in All of the Libraries that are available Choices. In Fields 3 through 8, enter the Library Name then if desired, enter the 2 digit Company Number in the last two spaces in the Field. (Company # = Space 19 & 20 of each field). If the Company Number is entered, when the Library is selected in G/L Control, the company # will be changed for you automatically. If the Company# is Not entered, when you select the Library in G/L Control you will need to change the Co # manually. Field 1 = GLCONTROLLIBRARY Field 2 = blank Field 3 = Library Name & 2 Digit Company# (Optional) Field 4 = Library Name & 2 Digit Company# (Optional) Field 5 = Library Name & 2 Digit Company# (Optional) Field 6 = Library Name & 2 Digit Company# (Optional) Field 7 = Library Name & 2 Digit Company# (Optional) Field 8 = Library Name & 2 Digit Company# (Optional) .
GLCONTROLLIBRARY		This Example will display Libraries; TNDATA in Co.#01, CVDATA & CADATA in Co.#02 in the G/L Control. Field 3 = TNDATA 01 Field 4 = CVDATA Field 5 = CADATA 02
HANKSVILLLE		This is used for South Central Setup for Hanksville. BCNTLWB file is also used for e-mail info, index 69. E-mail from, to and server is in BCNTLWB file under index 69. Field 03: xxxx for toll file # Field 04: Folder name like CTIHANKS Field 05: Mapped name to folder like R:\ The example below shows what can be entered for Hanksville.
HANKSVILLLE		0010 CTIHANKS R:\
INVENTORY-IMAGES	FOLDER	This is used to specify the folder holding the inventory image files Field 1: INVENTORY-IMAGES Field 2: FOLDER Fields 3-8: path to images folder The example below will cause inventory programs to look in folder S:\Inventory\Img for inventory pictures
INVENTORY-IMAGES	FOLDER	Fields 3-8: S:\Inventory\Img
INVENTORY-KEEP-0-QTY	IF-NO-SERIAL#	Use this edit to KEEP Inventory Detail items by location in the file. The system will not automatically delete them when they go to 0-Qty. You will then have to manually delete any of these items if you desire. Items with a serial number will still be deleted when the qty goes to 0. Fields 3-8 are left blank (That is a Zero-QTY not an oh-QTY) In the Example below those items would stay in your Inventory Detail File when the quantity goes to zero.
INVENTORY-KEEP-0-QTY	IF-NO-SERIAL#	Fields 3-8: S:\Inventory\Img
INVENTORY-LOCATIONS		Field 1: INVENTORY-LOCATIONS Field 2: Leave Blank Fields 3-8: xx yyyyyyyyyyyyyyyyy xx = The two character Location code to use 1 space yy = The Location description (The description can be 17 characters long) Note: Only the two character location code will be displayed in Riata Inquiry on the Phone Number Information screen on the Other Tab. In the Example below the Store Location on the Other Tab in teh Phone Number information screen will be populated with: 01 Idaho Falls RU Rupert BU Burley TF Twin Falls
INVENTORY-LOCATIONS		Field 3: 01 Idaho Falls Field 4: RU Rupert Field 5: BU Burley Field 6: TF Twin Falls
INVENTORY-NO-ONHAND	(Company #)	When you setup this user edit the paid for quantity will be copied to the on-hand quantity in the inventory master for the company # in Field 2 and the G/L Accounts (1-9) entered on Field 3 Field1: INVENTORY-NO-ONHAND Field2: (Company #) Field3: (G/L ACCOUNT (1-9) (you can enter 1 for G/L Account 1 or 123456789 for G/L Accounts 1,2,3,4,5,6,7,8,9, etc.) The following example would update the onhand quantity for company 01 G/L Account (1-9) 2, 6 and 7.
INVENTORY-NO-ONHAND	01	267
INVENTORY-NO-SERIAL		This user edit is used if you have not entered Serial Numbers for inventory Items In the example below, The Riata Inventory will make sure there is a Serial Number however we can not validate.
INVENTORY-NO-SERIAL
INVENTORY-PHYSICAL	GL-ACCOUNT	This is used for when doing physical inventory. The GL account for actual changes in inventory $. Field 5 USE-LOCATION causes the system to use 02 character Inventory location as the sub account field
		Example:
INVENTORY-PHYSICAL	GL-ACCOUNT	6710.10A
INVENTORY-QTY-ONLY		When you setup this user edit, we will Not track any Money on the G/L Account(s) entered in Field #3. The G/L Account(s) are compared to the G/L Account(s) entered in Inventory Master - 'G/L Acct (1-9). Field1: INVENTORY-QTY-ONLY Field2: Leave Blank Field3: Enter G/L Account (1-9) In the following Example; no money would be tracked for G/L Accounts 6 & 7.
INVENTORY-QTY-ONLY		Field 3 = 67
INVENTORY-SALE	SPREAD-MONTHS	This user edit will allow the user to bill inventory items sold to a customer over number of months. When the payment method is "Bill" and "Spread over multiple months" is checked, and the user closes the Inventory program , a screen will be displayed for each item sold showing the Tariff code, Description, total code, number of months, and spread amount. The user will have the opportunity to bill each item sold over multiple months. Field 1: INVENTORY-SALE Field 2: SPREAD-MONTHS Field 3: 2 digit number of months left justified Field 4: Tariff to add to the Non-Recurring Charges left justified with leading blanks if needed Note: This edit will automatically check the "Spread over multiple months” check box and place the Tariff and number of months to spread in their respective fields when the screen is displayed. You can spread the bill over multiple months without the edit set up by checking the checkbox and entering the number of months manually. The tariff code used will be the tariff set up in the G/L control file for inventory sales. In the example below, when an inventory item is sold and the payment method is "Bill" a screen will be displayed with "ISALE" for the tariff code and 12 in the number of months.
INVENTORY-SALE	SPREAD-MONTHS	Field 3: 12 Field 4: ISALE
INVENTORY-SALE	STATE-TAX-ALWAYS	This edit will leave the "Charge Tax" checked in the inventory program even if the customer has "No" for "Charge State Tax" on the "Tax" tab in the Phone Number Information screen. In the past is the customer had "No" selected for "Charge State Tax" the "Charge Tax" would have been unchecked. Note: The user is still able to uncheck the "Charge Tax" if they need to.
INVENTORY-SALE	TRACK-MANUAL-CHANGES	This edit will force a reason for the price change if the user checks “Manual” for the “Unit Sell” on the inventory detail screen. In the example below the user will be required to enter the reason the price has changed before they can update the item being sold in inventory.
INVENTORY-SALE	TRACK-MANUAL-CHANGES
INVENTORY8SERIAL		This is used for you to specify that when you run #8 on the Inventory Menu, you want to use the special program that allows you to easily enter the Location and the Serial # of the incoming items. Field 03: Y The example below would cause the special program to run.
INVENTORY8SERIAL		Y
INVENTORYMINMAXDEPTS		If this code is present when adding a new inventory item, you will have the option to add departments and the minimum / maximum quantities for those departments. The departments that will be added are listed in fields 3-8 of this code. The minimum & maximum quantity will be asked for when adding the inventory item. Field 2 of this code needs to have your company number. This is the 2 character number from workstation status. This will let you have different departments for different companies. Field 3 - 8 will have your departments. Key them with a period between. Example: AA.BB.CC. etc. You will have room for 7 on each of the 6 lines for a total of 42. This example would cause departments AA, BB, CC to be added for a new inventory item if the company number is 01.
INVENTORYMINMAXDEPTS	01	AA.BB.CC
INVENTORYSALE		This edit will print a graphic on the Inventory printout. To set this up, 'INVENTORYSALE' on the first line, leave the second line blank and the name of the GIF on the third line. The example below would print the CTI.GIF graphic on the Inventory printout. The GIF will need to be in the same folder as the users Riata programs.
INVENTORYSALE		CTI.GIF
INVENTORYSALENOINQ		This code lets Riata know that Inventory sales are not permitted from Inquiry With this code, the user will not be able to sell Inventory items from Riata Inquiry.
INVENTORYSALENOINQ
INVENTORYSALESTAXNOC		Use this to NOT use the city/local tax percents when calculating tax in the inventory sales module of Riata. With this code the City/Local Tax % is subtracted from the total %.
INVENTORYWASPFOLDER		This User Edit is used to tell the System where the Programs and Files are Stored for the Inventory Hand Held WASP Scanner device to record incoming Inventory and then Update the Inventory Usage. Field 2 leave blank, Fields 3-8 are added together to form the path.
		Field 3 through 8 = N:\wasp01
LNP-EMAIL	CC	This User edit is used for a Carbon Copy addresses when emailing from 2007 Service Order Entry. Field 1: LNP-EMAIL Field 2: CC Field 3-4: First Carbon Copy Address Field 5-6: Second Carbon Copy Address Field 7-8: Third Carbon Copy Address Note: Multiples are allowed In the example below when the email is sent a carbon copy will also be sent to: myronsmith@syringawireless.com janedoe@syringawireless.com jjones@syringawireless.com
LNP-EMAIL	CC	Field 3: myronsmith@syringawi Field 4: reless.com Field 5: janedoe@syringawirel Field 6: ess.com Fiedl 7: jjones@syringawirele Field 8: ss.com
LNP-EMAIL	INFO	This user edit is used in 2007 Service Order Entry to email the LNP to Syringa Wireless Field 1: LNP-EMAIL Field 2: INFO FieldS 3-4: EmailServer FieldS 5-6: From Address Fields 7-8: To Address In the example below, smtp.mytelephonecompany.com is the email server, the email will be from janedoe@syringqwireless.com and the email will be sent to johndoe@syringawireless.com.
LNP-EMAIL	INFO	Field 3: smtp.mytelephonecomp Field 4: any.com Fiedl 5: janedoe@syringawirel Field 6 ess.com Field 7: johndoe@syringawirel Field 8: ess.com
LOCATIONADDRESSNOPRT		This code will let you set up certain customers so their Location Address does not print on their statements. This is only if using BSTA6P as your statement print program. This stops the address from printing at the top of Local Service and on individual tariff codes if you have the flag set to print the location address. Key this code in field 1. Field 2 is blank. Fields 3-8 can have tariff codes. There can be 3 tariff codes per line. Key a period between tariff codes. If the tariff code is not 5 characters long, key leading/trailing blanks to make the length of 5. Example: ' ABC. ABCD.ABCDE'. One of the tariffs would need to be entered as a recurring tariff code on each of the customers phone number. The following example would cause the Location Address to be suppressed from printing on a customers bill with tariff code NOLOC or NADR.
LOCATIONADDRESSNOPRT		NOLOC. NADR
LOCATIONVALIDATE		This is used to make sure the address on the location tab in the phone program is found in the GEO file. If the address is not found in the GEO file and LOCATIONVALIDATE is in the edit file, the only way to approve the service order is to have "BAD IS OK" in the 911 Description field. The example below will check the address on the location tab in the phone program against the GEO file. If the address matches the user will be able to approve the service order.
LOCATIONVALIDATE
LOCKNOTES		This User Edit is used to prevent users from changing notes after the Service Order has been Updated and Approved Yes or No. If this User Edit is Setup, the user can create a new note but will not be able to change it once the Service Order has been Updated. This is usually used if using Geo or Atlas, to always send a new note if something needs changed.
LOCKNOTES
MINERVANOLEAD0		If this user edit is in field 1, when we call out to minerva, we will strip off all leading zeros from the account number to make up the minerva customer id. Examples: Riata Account: 000155 becomes Minerva customer ID: 155 Riata Account: 012566 sub 0001 becomes Minerva customer ID: 125660001 Note: The leading zeros are only stripped off the account, not the sub.
MINERVANOLEAD0
NECAPICCHANGE		This code allows you to enter the non recurring tariff codes used for Pic change. Field 01: NECAPICCHANGE Field 02: Leave blank Fields 03-08: xxxxx.xxxxx.xxxxx Fields 3-8 will have the Non Recurring tariff codes. You can put up to 3 per line. Enter a period between tariff codes, xxxxx.xxxxx.xxxxx.
NECAPICCHANGE		NRTF1.NRTF2.NRTF3.
NEWCREDITCLASS		This will automatically enter the credit class on the Other tab in the Account program on "New Install" service orders. Note: A, B, C, D are the only valid credit classes. The correct credit class for new customers will need to be entered in field three and left justified. Field 01: NEWCREDITCLASS Field 02: Leave blank Fields 03-08: Credit Class for New accounts In the example below, the Credit Class field in the Account Tab program on the "Other" tab will be populated with a "C"
NEWCREDITCLASS		C
NEXTNUMBERADDRESS		This user edit indicates the path to the web page that serves up the next available phone number. Fields 3-8 are added together to form the path.
		http://www.cti-id.co
		m/syringawireless/nu
		mberinformation.asp
NEXTNUMBERTIMEOUT		This user edit indicates the time in centi-seconds the program will wait before timing out while attempting to communicate with the webpage that serves up the next available phone number.
NEXTNUMBERTIMEOUT		300
NIGHTLY-SUMMARY	LOCATION-CODE	This user edit is used for the Nightly Summary. If field 3 has SPECIAL1 in it the Nightly Summary will use report group and if field 3 has NXX in it the Nightly Summary will use LNP NPA-NXX if imported or NPA-NXX, if field 3 has STORE will use assigned store, if field 3 has STORE-NXX will use assigned store and NPA-NXX. Field1: NIGHTLY-SUMMARY Field2: LOCATION-CODE Field3: (SPECIAL1, NXX, STORE, OR STORE-NXX) The following example would use the Report Group.
NIGHTLY-SUMMARY	LOCATION-CODE	SPECIAL1
NOCHANGETARIFF		This will control whether or not existing Recurring and Non-Recurring tariffs can be changed. If “NOCHANGETARIFF” is found, the user will not be able to change tariffs that have already been assigned. The user will still be able to change the cost, dates, and remove the charge. Fields 02-08: Leave blank In the example below would not allow the tariff code to be changed. You would still be able to change the cost, date, and remove the charge.
NOCHANGETARIFF
NODEFERPAY		This disables the Deferment options on the ‘Other’ tab of the Main Account Information. The example below would cause the ‘Deferment’ options on the ‘Other’ tab of the Main Account Information to be disabled so nothing can be entered.
NODEFERPAY
NOEBILL	TOLGRP	Only allows a customer to have their bill mailed out (not e-mailed) if they are part of a specified toll group. The example below would mail bills to only those with a 425 NPA.
NOEBILL	TOLGRP	425
NONLIST	TARIFF	Checks to see if a Non-List customer has a corresponding recurring Non-List tariff and vice versa. The example below would verify the customer has a non-listed number.
NONLIST	TARIFF	NL
NONPUB	TARIFF	Checks to see if a Non-Pub customer has a corresponding recurring Non-Pub tariff and vice versa. The example below would verify that the customer has a non-published number.
NONPUB	TARIFF	NP
NONPUBNONLISTRECUR		This will automatically update the “Current Non-Pub” for INTER and INTRA information on the PIC tab and the “Non-Pub/List” on the Directory tab. Verify the following has been set up: “How do I setup to check for a corresponding tariff when there is a Non-List customer?” and/or “How do I setup to check for a corresponding tariff when there is a Non-Pub customer?” Enter “” in Field 01: NONPUBNONLISTRECUR (press Enter twice to save the data) In the example below, if the customer currently has Publish selected for the Non-Pub/List on the Directory tab and a Non-List tariff is added to the customers recurring charges, the program will automatically change the Non-Pub/List to Non-List and change the Current Non-Pub on the PIC tab to 2: InDir Assist Not in Dir - NL. (the same would be true if a Non-Pub tariff is added.)
NONPUBNONLISTRECUR
NONPUBTYPE1		This will make the default for ‘Current Non-Pub’ on the PIC tab be ‘1: Not in Dir Assist, not in Dir – NP or NL’ instead of the regular default of ‘3: Not given out via Dir Assist, not in Dir – NP’. This happens when you change the ‘Non-Pub/List’ on the Directory tab to Non-Pub and then say ‘Yes’ to the question ‘Do you want me to change the PIC tab to match this so that carriers are notified?’ The example below would select Non-Pub type (1: Not in Dir Assist, not in Dir – NP or NL) for ‘Current Non-Pub’ when the ‘Non-Pub/List’ on the Directory tab is changed to Non-Publish.
NONPUBTYPE1
NONRECNOTEREQUIRED		This code is used to force a note to be taken each time the user wants to change the Non-Recurring charges in Riata without being in a pending service order. Key "NONRECNOTEREQUIRED" in field 1 and leave fields 2-8 blank. This example below will require a note to be taken each time the user clicks the "Change Charges" button on screen I-05:A to change the Non-Recurring charges.
NONRECNOTEREQUIRED
NOQWESTDIRECTORY		Disables the QWEST button in the Phone Tab Program and Other Listing Programs. The example below would cause the Qwest button to be disabled in the Phone Tab Program and Other Listing Programs.
NOQWESTDIRECTORY
NOTIFYTARIFF	ALLPHONES	Notifies the user if a customer has certain tariff codes. The tariff code, description, Phone/ID number, and File Type are displayed in the 'Special Notify' list for each Phone/ID number listed in the Telephone Number & Location screen that has the tariff. This can be seen from Service Order Entry and Customer Inquiry. Field 01: NOTIFYTARIFF Field 02: ALLPHONES Fields 03-08: Tariff code - Left justified with leading spaces The example below would display the Tariff for each Phone/ID Number listed in the telephone number and location screen that has the "WAIT" tariff code. Note - The Tariffs associated with "NOTIFYTARIFF" with "TARIFF" in field 2 will display only once for each tariff listed no matter how many Phone/ID numbers have the tariff. The Tariffs associated with "NOTIFYTARIFF" with "ALLPHONES" in field 2 will be shown for each Phone/ID Number displayed in the Telephone Number and Location screen that has the tariff.
NOTIFYTARIFF	ALLPHONES	WAIT
NOTIFYTARIFF	TARIFF	Notifies the user if a customer has certain tariff codes. The tariff codes and descriptions are listed in the lower box labeled 'Special Notify' on the Telephone Number & Location screen. This can be seen from both Service Order Entry and Customer Inquiry. The example below would cause the user to be notified that this account has these tariff codes.
NOTIFYTARIFF	TARIFF	SPC01 SPC02
NUMBER-POOLING	DEFAULTS	This User Edit is used to enter the Number Pooling Regular default type and the Disconnect Default type. Field 3 - Regular Default Type (4 Character) Field 4 - Disconnect Default Type (4 Character) In the example below the Regular default type will be 'REG1' and the Disconnect default type will be 'DIS1'.
NUMBER-POOLING	DEFAULTS	Field 3 = REG1 Field 4 = DIS1
NUMBER-POOLING	TYPE	This user edit is used to fill the “Type” dropdown list box in the “Number Tracker” program. Field 1: NUMBER-POOLING Field 2: TYPE Field 3: CODE.A Field 4: Description for the code in field 3. Field 5: CODE Field 6: Description for the code in field 5. Field 7: CODE Field 8: Description for the code in field 7. NOTE: The Code can be a maximum of 4 characters long, the description a maximum of 20 characters. NOTE: If you are using the "NUMBER-POOLING", "USE-IT" user edit, the Codes that are followed with a period and "A" will be displayed in the Available Numbers program. The decimal will be in the 5th position from the left and the "A" will be in the 6th position. In the example below "Number Pooling 1", "Number Pooling 2", and "Number Pooling 3" will be loaded into the dropdown list in the Number Tracker program. Only "Number Pooling 2" (COD2') numbers will be available in the Available number program if the "NUMBER-POOLING" "USE-IT" uer edit is set up.
NUMBER-POOLING	TYPE	COD1 Number Pooling 1 COD2.A Number Pooling 2 COD3 Number Pooling 3
ONLINEPAYEMAILNOTIFY		This code lets us know the CSR we need to send an e-mail to as a notification that a customer has paid their bill online. This way, if the customer has a toll restrict, or has been suspended, the CSR can look up their account and un-toll restrict, or un-suspend them. This does not mean that the money has been posted. The e-mail is sent the moment the customer pays online. The posting of online payments happens later. The e-mail address can overflow taking up fields 3-8
ONLINEPAYEMAILNOTIFY		csr@myne
		wteleco
		m.com
OPERATIONSREPORT	CHANGECITY	This code is used to display the correct spelling of the misspelled cities entered by the CSR's in the 911 location field. Field 3 contains the misspelled version of the city, Field 4 contains the correct spelling, Field 5 contains another misspelled version of another (or the same) city and Field 6 contains the correct spelling of that city (city in Field 5). Fields 7 and 8 follow the same pattern. If you need more, add a second user edit with the same values in Field 1 and Field 2 then different cities and their misspellings in fields 3-8 following the aforementioned pattern. Example
OPERATIONSREPORT	CHANGECITY	Field 3: HEUBURN Field 4: HEYBURN Field 5: HEYBORNS Field 6: HEYBURN Field 7: TF Field 8: TWIN FALLS
OPERATIONSREPORT	FGSAVEPATH	This code is used to determine the path to the saved flex-grids. We concatenate fields 3-8 to obtain the full path. Example:
OPERATIONSREPORT	FGSAVEPATH	N:\WINDOWS\SYSTEM\TE STING\FROM\THIS\PROG RAM\THAT\HAS\A\LONG\ PATH\
OPERATIONSREPORT	NOCITYNPANXX	This is used to list the NPA's an NXX's of cities you do not want displayed in the operations report. An example of this would be: You have been using the 208-200 exchange for all of your internet only customers. This is a fake exchange for you. However, this is a valid exchange (Idaho falls). You do not want all of your internet only customers showing up under Idaho Falls in the operations report. Enter 208200 in Field 3 and then all customers with that exchange will be listed with a blank city on the operations report. You can fill fields 3-8 with these exchanges. If you need more, add a second user edit with the same values in Field 1 and Field 2 then different exchanges in fields 3-8
OPERATIONSREPORT	NOCITYNPANXX	208200 208100 208436 208123
OPERATIONSREPORT	QOPR01	This is used to indicate the title of the operations report, whether it displays CABS information, and whether it displays Trouble Ticket Information. Field 1 contains OPERATIONSREPORT Field 2 contains the operations report in question (i.e. QOPR01 or QOPR02 etc.) Fields 3-4 contains the title of the report that will be displayed at the top of the report. These two fields are concatenated together. Field 5 indicates whether CABS information will be shown on this report. Leave blank if you want CABS information. If you do not want CABS information enter NOCABS Field 6 indicates whether Trouble Ticket information will be shown on this report. Leave blank if you want Trouble Ticket information. If you do not want Trouble Ticket information enter NOTROUBLE
OPERATIONSREPORT	QOPR02	Field 03. . . . . Detailed report of w Field 04. . . . . hat we earned n such Field 05. . . . . NOCABS Field 06. . . . . NOTROUBLE
OTHER-OPTIONS-WEB		This user edit is used to populate a list of web sites that are available if a person clicks the "other options" button within inquiry or service order entry. Field 1: OTHER-OPTIONS-WEB Field 2: Field 3: Title of the web site Fields 4-8: URL of the web site including http:// Example:
OTHER-OPTIONS-WEB		Google
OURLDB	TARIFF	When both intra and inter state carriers are 'Our Own Toll Carriers', allows you to add a specified tariff. The example below would cause the program to look and see if the default tariff code is in the customers recurring charges. If the tariff is not found, a message is displayed asking if the tariff should be added.
OURLDB	TARIFF	OURLD
OUTSIDEPLANTSENDIDS		Use this code to update and send ID's with the GEO nightly file. If this code is there the ID's will be sent and updated when the nightly file is run. If it is not there only the phone will be send and updated. Key this code in field 1. Leave fields 2-8 blank. This example will cause the ID's to be sent with the GEO nightly file and update from the GEO nightly file.
OUTSIDEPLANTSENDIDS
OWN-TOLL-CARRIER	ADDITIONAL	This edit User Edit will allow you to set up as many “Own Toll Carriers” as you need. Field 1: OWN-TOLL-CARRIER Field 2: ADDITIONAL Field 3: Own Toll Carrier Number Field 4: Own Toll Carrier Description for field 3 Field 5: Own Toll Carrier Number Field 6: Own Toll Carrier Description for field 5 Field 7: Own Toll Carrier Number Field 8: Own Toll Carrier Description for field 7 The example below will load the following Own Toll Carriers in the Carrier PIC dropdown on the PIC tab My Long Distance 1 My Long Distance 2 My Long Distance 3
OWN-TOLL-CARRIER	ADDITIONAL	Field 3: 0411 Field 4: My Long Distance 1 Field 5: 0412 Field 6: My Long Distance 2 Field 7: 0413 Field 8: My Long Distance 3
OWNER-NPA-NXX		This edit stores the NPA NXX combinations assigned to this owner. It is used for determining who the local calls belong to in T34BLLOCAL.exe. Field 2 is the description of the owner Fields 3 - 8 are the NPA NXX combinations assigned to the owner. They are period delimited. You can have multiple of these records if you need more space. Example:
OWNER-NPA-NXX		Field2: ALBION Field3: 208349.208527.208554 Field4: 208588.208638.208645 Field5: 208673.208698.208766 Field6: 208767.208824.208827 Field7: 208208.208209.208210 Field8: 208211.208212.208213
PASSWORD-SIGN-ON	BLANK-USER-NAME	With this user edit, the name on the password sign on screen will be blank. In the example below when the password program is displayed, the Name/User on the Password screen will be blank.
PASSWORD-SIGN-ON	BLANK-USER-NAME
PATRONAGE-REFUND-TRF	WRITEOFF-RECOVERY	Use this edit to enter the Patronage Refund tariff for write off recovery. In the example below the tariff code is TARF1. (remember the tariff code is five characters long with leading spaces)
PATRONAGE-REFUND-TRF	WRITEOFF-RECOVERY	Field3: TARF1
PAYROLL	PRINT-HISTORY	In Payroll History, this edit allows the user to change the column order and if the column is displayed when they click the "Show Predetermined Columns" button. For example if you would only like to see the Employee Number, Date, Regular Hours, and Notes, with nothing else displayed, you would enter 00.01.02.20 in Field #3 of this User Edit. . To set this up: Field 1: “PAYROLL’ Field 2: “PRINT-HISTORY” Field 3-5: Column number separated with a period. (00.01.02.) The column numbers are displayed at the top of each column in the first screen when the Employee History is displayed. . NOTE: Employee is Column #00 and will be displayed the first position regardless if entered or Not. Field 6-8: Leave Blank Note: The easiest way to enter the column order is to go into Payroll history and click the "Column Order" button in the Predetermined Columns screen, then enter the column order you would like to see. Enter "1" in the first column you would like to see after the Employee number, "2" in the second column and so on. In the example below there will be eight columns displayed when the user clicks the “Show Predetermined Columns” button. They will be “Employee, Date, Regular Hours, Time Code, Over Time Hours, G/L, Budget Code, and Notes.
PAYROLL	PRINT-HISTORY	Field 3: 00.01.02.07.03.08.09 Field 4: 20.
PAYROLL-CHECKS	HIDE-SS#	This user edit will allow only the last 4 characters of the social security number to print on the payroll checks and print **** on the first 4 characters of the Bank Account on the direct deposit checks. To set this up: Field1: PAYROLL-CHECKS Field2: HIDE-SS# The example below would cause the social security number to be hidden.
PAYROLL-CHECKS	HIDE-SS#
PAYROLL-ENTRY	PUNCH-IN-OUT	This user edit will allow the user to quickly punch in and out of Payroll Time entry. To use the user edit you will also need to set up the defaults for each user. Field 1: PAYROLL-ENTRY Field 2: PUNCH-IN-OUT When the default is set up for each user, use the following dates for the Payroll type. Type Default date Regular 01/01/00 Sick 01/02/00 Holiday 01/03/00 Vacation 01/04/00 Not Paid 01/05/00 The example below will all the user to quickly enter their time.
PAYROLL-ENTRY	PUNCH-IN-OUT
PAYROLL-ROUND-TIME		This User Edit will round the payroll time to the closest quarter hour when the supervisor is approving time in Payroll Time Entry. Also when the user selects "Payroll Time to AS400" a question is asked if the time should be rounded. In the Example below, a button will be visible and enabled on the daily total screen allowing the supervisor to round the time. When "Payroll Time to AS400" the user can select to round the time.
PAYROLL-ROUND-TIME
PAYROLL-TIME-CODE	ORIGINAL-CO#	This user edit is used in the Payroll program on the time entry screen and will only display the companies from the “PAYROLLTIMECODE” user edit if the company# selected matches the employee’s original company when the user clicks to reload for the selected company. Field 1: PAYROLL-TIME-CODE Field 2: ORIGINAL-CO# Fields 3-8: Leave Blank In the example below, the companies set up in the “PAYROLLTIMECODE” will not be displayed if the company the user has selected, and clicked “Reload for this Company”, does not match the employee’s original company.
PAYROLL-TIME-CODE	ORIGINAL-CO#
PAYROLL-TIME-FROMPC		If this edit is found, Riata will get the Payroll Punch In/Out date and time from the local PC. If this edit is not set up, the date and time will come from the AS/400. Fields 2-8: Leave Blank In the Example below the Payroll Punch In/Out program will get the date and time from the local PC. Note: This would normally be used if you have employees using Riata Punch In/Out Payroll across different time zones.
PAYROLL-TIME-FROMPC
PAYROLL-WO-BUDGET	DEFAULT-NO	This user edit will not compare the Budget Code in the Work order against the Budget Code the user has selected in Riata Payroll when the user clicks the update button. In the Example below, the budget code the user has selected will be used. We will not compare the budget code with the Default Budget Code in the Work order master.
PAYROLL-WO-BUDGET	DEFAULT-NO
PAYROLL-WO-DEFAULT	IN-PROGRESS-GL	This user edit will automatically change the G/L in Riata Payroll to the “Default In Progress G/L” for the Work Order selected. The following example will move the “Default In Progress G/L” from the Work Order o the G/L in Riata Payroll entry.
PAYROLL-WO-DEFAULT	IN-PROGRESS-GL
PAYROLLCHANGEHISTORY		This presence of this code will keep a history of Payroll Employee Master Changes. This includes Employee Master, Notes, Bank Account Information, Spread information and Special Savings Account Information. Fields 02-08: Leave blank The example below will cause a history of Payroll Employee Master changes to be kept.
PAYROLLCHANGEHISTORY
PAYROLLCHECK		This is used to print the heading you want for vacation, holiday, and sick leave on the payroll check stub. If you do not enter a user edit here the default headings will print for each. Field 1: PAYROLLCHECK Field 2: (VACATION,HOLIDAY OR SICK) Field 3: The 15 character heading to print Field 4-8: Leave Blank In the example below LEAVE will print on the payroll check stub instead of VACATION BAL.
PAYROLLCHECK	VACATION	LEAVE
PAYROLLMASTERBUDGET		This code is used to always default the payroll time entry budget code to the default budget code from the employee master. When entering payroll time, and the budget code is left blank, it will default to the budget code from the employee master. Put this code in field one. Leave fields 2-8 as blanks usually. If you enter the keyword "ONLYBLANKS" in field 03 then the system will only update those entries that do not have a budget code already. If you enter the keyword "OMITCERTAINGL" in field 04 then the system will not update the items for G/L accounts that you have told the system that budget codes are not required. Please review code PTIMECDBUDGETNOCHG also. The following example will cause the budget code in payroll time entry to default to the budget code from the employee master.
PAYROLLMASTERBUDGET
PAYROLLRYE01		This user edit will store the Payroll Labor G/L. This user edit is used by Rye to post all of the payroll labor to one account. Note: When entering the G/L Key leading zeros for the G/L. (12345 refers to the G/L Extension if you use it, leave it off if you do not use it) Field 1: PAYROLLRYE01 Field 2: Field 3: G/L In the example below, the G/L 6810.00 G/L Extension 12345 will be used.
PAYROLLRYE01		Field 3:6810.0012345
PAYROLLTIMECODE	Payroll Time Code	Allows you to control the G/L drop-down box based upon what time code they select when entering payroll time. Probably used with vacation and sick time. G/L Account Fields 03-08 are used so you can have multiple g/l accounts for each time code if needed. #15 'Add/Change Time Codes' can be used to know what time codes you have set up. When entering the G/L accounts do not enter the period, just key the 6 digit number and then the 5-character extension if you are using them with no spaces. The example below would cause only account 6710.12 W and 6822.13 to be in the G/L drop-down box whenever time code 02 is selected regardless of what you have selected for any employee to see for G/L Accounts.
PAYROLLTIMECODE	02	671012W 682213
PCS-ASSOCIATION-CLUB	DISCOUNT	This User Edit is used to give a Discount to members of an Association. This Discount is given if they have a minimum number of members signed up for the Cellular Service. The Discount could be a return for them providing access to members that you can contact. The Minimum Number of Phones required, the Discount Percentage and a Tariff Code are setup in this User Edit. The Tariff Code will need to be Setup in the Tariff Master. This is the Tariff Code used at Month End to show the Discount Information on the Customer Bill. Cellular clients only. Field 1 = PCS-ASSOCIATION-CLUB Field 2 = DISCOUNT Field 3 = Minimum Number of Phones.Discount Percentage.Tariff Code - 2 Digit Minimum Number of Phones Allowed, followed by a period - Example 99. = Minimum of 99 Phones - 4 Digit Discount Percentage, followed by a period - Example 1000. = 10% Discount (4 Decimal Positions) - 5 Character Tariff Code used to show the Discount on the Customer Billing Statement - Example ASDT6 *NOTE: If Tariff Code is less than 5 Characters, enter with preceding blanks. This Tariff Code Must be setup in the Tariff Master with NO Charges. Field 4 through 8 = Leave Blank The Example below will display; Minimum of 99 Phones, 10% Discount, Tariff Code ASDT6
PCS-ASSOCIATION-CLUB	DISCOUNT	Field 3 = 99.1000.ASDT6 Field 4 through 8 = Blank
PCS-BUSINESS-CLUB	DISCOUNT	This User Edit is used to give a Discount to a Business. This Discount is given if they have a minimum number of phones signed up for the Cellular Service. The Minimum Number of Phones required, the Discount Percentage and a Tariff Code are setup in this User Edit. The Tariff Code will need to be Setup in the Tariff Master. This is the Tariff Code used at Month End to show the Discount Information on the Customer Bill. Cellular Clients only. Field 1 = PCS-BUSINESS-CLUB Field 2 = DISCOUNT Field 3 = Minimum Number of Phones.Discount Percentage.Tariff Code - 2 Digit Minimum Number of Phones Allowed, followed by a period - Example 50. = Minimum of 50 Phones - 4 Digit Discount Percentage, followed by a period - Example 1000. = 10% Discount (4 Decimal Positions) - 5 Character Tariff Code used to show the Discount on the Customer Billing Statement - Example BRDS6 *NOTE: If Tariff Code is less than 5 Characters, enter with preceding blanks. This Tariff Code Must be setup in the Tariff Master with NO Charges. Field 4 through 8 = Leave Blank The Example below will display; Minimum of 50 Phones, 10% Discount, Tariff Code BRDS6
PCS-BUSINESS-CLUB	DISCOUNT	Field 3 = 50.1000.BRDS6 Field 4 through 8 = Blank
PCS-BUSINESS-CLUB	TARIFF	This User Edit is used to customers participating in a Business Club Plan. The Tariff Code must be added to the Customers Phone as a Recurring Charge. Field 1 = PCS-BUSINESS-CLUB Field 2 = TARIFF Field 3 = 5 Character Tariff Code (If the Tariff Code is less than 5 Characters, enter with preceding blanks) Field 4 through 8 = Leave Blank The Example below will display; Tariff Code BCLUB
PCS-BUSINESS-CLUB	TARIFF	Field 3 = BCLUB Field 4 through 8 = Blank
PCS-CIBER-DROP-TOLL		Use this User Edit to drop the toll portion of a roaming call. Use this if you are using Special Roaming Rates from the PCS plan setup and this rate includes toll. Field 1: PCS-CIBER-DROP-TOLL Fields 2-8: Leave blanks In the example below, all roaming toll would be dropped. Special Rates from the PCS plan would re-rate the airtime portion to include toll charges.
PCS-CIBER-DROP-TOLL
PCS-DAILY-PLAN		This user edit is used for the Daily Plan. All Tariff codes that are daily decrement need to be included in this User Edit. This is intended to suspend people on the day that money is due. See PCS-DAILY-PLAN HOTLINE-NOT-SUSPEND User Edit. Field 3: XXX or XX (Days before up to SMS) Field 4: XXX or XX (Days before Suspend (not used)) Field 5: XXX or XX (Days before OUT) Field 6-8: Tariff codes we will use to pull out recurring XXXXX.XXXXX.XXXXX
PCS-DAILY-PLAN
PCS-DAILY-PLAN	CREDIT-TARIFF	This user edit is used to enter the tariff code to use on Daily Plan credits. Field 3 = Tariff Code (enter leading spaces on Tariff Code) The following example would use TRF1 for the credit tariff.
PCS-DAILY-PLAN	CREDIT-TARIFF	TRF1
PCS-DAILY-PLAN	HOTLINE-NOT-SUSPEND	This user edit is used for the Daily Plan. See PCS-DAILY-PLAN User Edit. Field 3-8: XXXXX.XXXXX.XXXXX Fields 3-8 are used for the tariff codes of the plans that are to be hotlined NOT suspended when money is due.
PCS-DAILY-PLAN	HOTLINE-NOT-SUSPEND
PCS-DAILY-PLAN	NEED-AUL-BCGI	This user edit allows you to enter tariff codes that have hot line numbers that goto BCGI.
		Fields 3-8: will have the tariff codes. Enter the 5 character Tariff Code followed by a decimal. If you need room for more tariff codes, set up an additional user edit with fields 1-2 the same. **Remember to key leading blanks if the tariff code is less than 5 long. The following example will give BCGI for anyone with the tariff codes in field 3-8.
PCS-DAILY-PLAN	NEED-AUL-BCGI	FIELD 3 = XXXX1.XXXX2.XXXX3
PCS-DAILY-PLAN	SWITCH-CHECK	This user edit allows you to enter tariff codes for features that can be selected through Cash Receipts
		Fields 3-8: will have the tariff codes. Enter the 5 character Tariff Code followed by a decimal. If you need room for more tariff codes, set up an additional user edit with fields 1-2 the same. **Remember to key leading blanks if the tariff code is less than 5 long. The following example will verify tariff codes, TAR11,TAR22 & TAR33 in the Switch if turned on or off while doing Daily Plan in Cash Receipts.
PCS-DAILY-PLAN	SWITCH-CHECK	FIELD 3 = TAR11.TAR22.TAR33
PCS-DATA-ROAMING-MIN		This user edit will let you set up a minimum data size to charge for if making a data call while roaming. You can enter the size in KB or MB. Use the option that matches best how you set your PCS plans up. You can have different minimums based on a tariff code/PCS plan code or have just one minimum for all tariff codes. To have just one generic minimum, leave fields 4-8 blank. To set up by tariff code, key the tariff codes in these fields. You will have to key in multiple user edits with different tariff codes if you have different minimums. Remember to key leading blanks if the tariff code is less than 5 characters long. Separate tariff codes with a period. Field 1 = PCS-DATA-ROAMING-MIN Field 2 = Leave Blanks Field 3 = K2048 or M2 Fields 4-8 = Leave Blank for just one generic minimum or Key in tariff codes that this minimum applies to. (ATARF.1TARF. TAR) The following example would charge for a minimum of 2 megabytes for any roaming call where the PCS Plan is ATARF, 1TARF or TAR.
PCS-DATA-ROAMING-MIN		M2
		ATARF.1TARF. TAR
PCS-EMPLOYEE-CLUB	DISCOUNT	This User Edit is used to give a discount to employees of a business. This Discount is given if they have a minimum number of Employees signed up for the Cellular Service. The Discount could be a return for them providing access to Employees lists that you can contact. The Minimum Number of Phones required, the Discount Percentage and a Tariff Code are setup in this User Edit. The Tariff Code will need to be Setup in the Tariff Master. This is the Tariff Code used at Month End to show the Discount Information on the Customer Bill. Cellular clients only. Field 1 = PCS-EMPLOYEE-CLUB Field 2 = DISCOUNT Field 3 = Minimum Number of Phones.Discount Percentage.Tariff Code - 2 Digit Minimum Number of Phones Allowed, followed by a period - Example 25. = Minimum of 25 Phones - 4 Digit Discount Percentage, followed by a period - Example 1000. = 10% Discount - 5 Character Tariff Code used to show the Discount on the Customer Billing Statement - Example EMPL1 *NOTE: If Tariff Code is less than 5 Characters, enter with preceding blanks. This Tariff Code Must be setup in the Tariff Master with NO Charges. Field 4 through 8 = Leave Blank The Example below will display; Minimum of 25 Phones, 10% Discount, Tariff Code EMPL1
PCS-EMPLOYEE-CLUB	DISCOUNT	Field 3 = 25.1000.EMPL1 Field 4 through 8 = Blank
PCS8THSTATEPREFIX		This code lets you set up what the first 3 positions of the tariff code are for the 8th state option for PCS. The last 2 positions of the tariff code would be the 2 character state code. This is used if giving certain states free for a coverage area and an extra state of the customers choice. Key this code in Field 1. Leave Field 2 blank. Key the 3 character prefix in Field 3. This example would use ST8 as the prefix to look for tariff codes for the extra state on cellular plans.
PCS8THSTATEPREFIX		ST8
PCSCIBERCOMBINECHARG		This code allows you to combine Roaming Airtime and Toll into one record based on the cellular plan the customer has. This will combine the two records into one record to show on the bill. The toll charge is added to the airtime charge. There is a place in the plan setup to key a Roam Option of '01' or '02'. This identifies by plan what customers to combine the charges. Key this code in field 1. Leave the rest of the fields blank. This example will cause Roaming Airtime and Toll records to be combined into one record to show on the bill.
PCSCIBERCOMBINECHARG
PCSDEFAULTPLANTARIFF		This code lets you set up what the default plan tariff is if a customer does not have a plan selected as a recurring charge. Key this code in field 1. Field 2 can be left blank and all cycles will pick up the default. You can key a cycle code in field 2 to have a different default for each cycle. Key the default plan tariff code in field 3. Remember that if the tariff code is less than 5 characters long, leading blanks need to be keyed. This example will cause XYZ1 to be used as the default plan tariff code, for all cycles, when a plan is not specified as a recurring charge.
PCSDEFAULTPLANTARIFF		XYZ1
PCSPRINTDETAILIFOVER		This code will make cellular call detail print if the customer has gone over their plan free minutes. This would only apply if the call detail is normally suppressed from printing on the bill. Key this code in field 1. Leave fields 2-8 blank. The example below will cause cellular call detail that is normally suppressed to print on the bill.
PCSPRINTDETAILIFOVER
PDF-REPORTS	PATH	This user edit stores the path to the PDF reports. Field 1: PDF-REPORTS Field 2: PATH Fields 3-8: The path to the folder storing the reports. Example:
PDF-REPORTS	PATH	C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
PDFSTATEMENTSAVE		This user edit stores the path where the PDF Statements will be Saved. Field 1: PDFSTATEMENTSAVE Field 2: Leave Blank Fields 3 throught 8: The Path to the folder where the Statements will be Saved. Example:
PDFSTATEMENTSAVE		J:\CabsPDF
PDFSTATEMENTSOURCE		This user edit stores the path where the PDF Statements are Stored. Field 1: PDFSTATEMENTSOURCE Field 2: Leave Blank Fields 3 through 8: The path to the folder of PDF Statement Source. Example:
PDFSTATEMENTSOURCE		J:\CabsPDF
PHYSICALEQPCHANGE		This is one of the necessary settings needed to edit physical information from within the phone program of Inquiry. If this code is entered, a button on the physical tab will be enabled. Leave fields 02-08 blank.
PHYSICALEQPCHANGE
PLAN-SELECTOR	ADDITIONAL-IO.XXXX	This user edit is used to add IO fields to the plan selector tree (web only version for now). Within the plan selector builder, in the 94th tariff column, if the tariff code begins with a comma, then it means we need to add io fields to the plan selector. The next four characters of the "tariff code" following the comma will be the characters after "ADDITIONAL-IO." in the 2nd field of this user edit. There can be multiples of this user edit if there is need. Field1:PLAN-SELECTOR Field2:ADDITIONAL-IO.XXXX Field3:The title of the text box Field4:The first 10 characters are the user defined code we will write the contents of the io field to followed by a .R (for required), or a .O (for optional) Field5:Identical to Field 3 Field6:Identical to Field 4 Field7:Identical to Field 3 Field8:Identical to Field 4 Example:
PLAN-SELECTOR	ADDITIONAL-IO.XXXX	Title One
		Q#12345678.R
		Title Two
		Q#23456789.O
PLAN-SELECTOR	NON-RECURRING	This User Edit is used to determine the non-recurring tariff codes to display in the plan selector. Multiples of this user edit are allowed. Field 3" PHONE (Type of service…PHONE, CABLE, etc.) Fields 4-8: XXXXX.X.XXX.XXX.X Breakdown: 1-5 = Tariff code 7 = Service order type (A=All, C=Change, N=New, etc.) 9-11 = Maximum Quantity (001, 002, etc) 13-15 = Quantity for free (000, 001, 002, etc) 17 = Allow the CSR to change the price (Y, or N) Example:
PLAN-SELECTOR	NON-RECURRING	PHONE
		ABCDE.A.007.000.Y
		FGHIJ.N.012.003.N
PLAN-SELECTOR	SERVICES	This user edit is used to determine the description of the services that will be displayed in the services dropdown, the order they will appear in, their root plan selector node, their internal reference, and their service type code. Multiples of this user edit are allowed. Field1:PLAN-SELECTOR Field2:SERVICES Field3:01.Telephone (first two digits define the order of the service followed by a period. The rest is the service description) Field4:PHONE (The root node of the plan selector) Field5:telephone .PHN (1-16 Internal reference so we know what kind of service this is in code 17 period 18-20 Service Type Code) Field6:Same as Field 3 Field7:Same as Field 4 Field8:Same as Field 5 Example
PLAN-SELECTOR	SERVICES	03.Telephone
		PHONE
		telephone .PHN
		02.Cable TV
		CATV
		cable .CBL
PLAN-SELECTOR	TARIFF-QTY-FREE	This user edit is used to determine the tariff codes the customer gets "so many" for free...example (First STB is free...the rest will cost) Multiples of this user edit are allowed. Fields 3-8:XTAR1.999. (first five digits are the tariff code followed by a period. next three digits are the number the customer gets for free. Maximum allowed is 999. Example
PLAN-SELECTOR	TARIFF-QTY-FREE	XTAR1.999.
		XTAR2.005.
		XTAR3.001.
		XTAR4.692.
		XTAR5.524.
		XTAR6.009.
PLAN-SELECTOR	TARIFF-QUANTITIES	This user edit is used to determine the tariff codes that can have quantities greater than one in the web based plan selector. Multiples of this user edit are allowed. Field1:PLAN-SELECTOR Field2:TARIFF-QUANTITIES Fields 3-8:XTAR1.999.,XXXX (first five digits are the tariff code followed by a period. next three digits are the maximum quantity allowed. 999 means unlimited. You must also enter values greater than 0. The last 5 digits can be a comma followed by a 4 digit additional IO code. This is used if there are additional IO's that must be included here and they fluctuate based on quantity...and example would be additional email addresses. The custer wants 44 and so we need 44 additional IO's to enter the email addresses in.) Example
PLAN-SELECTOR	TARIFF-QUANTITIES
		XTAR2.005.
		XTAR3.001.,BLA1
		XTAR4.692.
		XTAR5.524.
		XTAR6.009.
PLAN-SELECTOR	TARIFF-WARNINGS	This User Edit is used to cause a message box to appear when the tariff is selected. It is meant to be a warning, but could assume other uses. Multiples of this user edit are allowed. If there are multiple entries for the same tariff code, the messages will be concatenated together Field 3 XXXXX.XXX (Tariff code, The order this portion of the warning will come up in if there is another entry for this same tariff code.) Fields 4-8: The message to be displayed in the message box. Example:
PLAN-SELECTOR	TARIFF-WARNINGS	CTALL.001.
		Please warn the cust
		omer that they will
		be billed for charge
		s incurred due to tr
		ansferring calls to
PLAN-SELECTOR	TARIFF-WARNINGS	CTALL.002.
		900 numbers. They a
		re doing this at the
		ir own risk.
PLAN-SELECTOR	TARIFF-WARNINGS	ABCDE.001.
		This is another warn
		ing
PLAN-SELECTOR	TAX-LOCATION-LIMITS	This User Edit limits the plan selector by filtering out all tariff codes that do not belong in a given tax location. Field 3: xx.xx.xx (City tax code, District (county) tax code, state tax code) Fields 4-8: 12345.ABCDE.ASDFJ. You can have multiples of this tariff code. Example: If you wanted the TFRES tariff code to be the only tariff code available to people in the city of TF, district TF, State ID, you would enter it in field 4 with the city, district, and state in field 3. If there were other tariff codes on the same level of the plan selector, they would not be displayed. Example: If you wanted the TF911 tariff code to be the only tariff code available to people who live in twin falls county, you would place spaces where the city code would go, TF in the district, and ID in the state. Even though your plan selector reads (...........PHONE|Residence|MI911|CA911|TF911............) they would only have the TF911 option available to them. Example:
PLAN-SELECTOR	TAX-LOCATION-LIMITS	Field 3: TF.TF.ID Field 4: TFRES.
PLAN-SUMMARY	CONVERT-EXCHANGE	This user edit is used to enter the NXX and Location Code to use for that NXX. When the location code is blank what ever is keyed in here for that NXX. (You can have multiple records for this user edit) F3 through F8: 436.ABC.437.DEF (You will enter the NXX a period, location code, a period, NXX, a period, location code) In the example below if the location code is blank and the NXX is 436 the location code will be changed to ABC, and if the NXX is 437 the location will be changed to DEF.
PLAN-SUMMARY	CONVERT-EXCHANGE	F3: 436.ABC.437.DEF
PLAN-SUMMARY	GRACE-PERIOD-DAYS	This User Edit indicates the Grace Period (Number of Days) a Customer can use a Plan and still being able to cancel without a penalty. Field 1: PLAN-SUMMARY Field 2: GRACE-PERIOD-DAYS Field 3: Enter 2 Digit Number Grace Period The example below indicates a 15 Day Grace Period. The Customer will be able to have, able to Try-Out a Plan for 15 Days before being committed to the Plan.
PLAN-SUMMARY	GRACE-PERIOD-DAYS	Field 3: 15
PLAN-SUMMARY-DROP-1	Location #	Setup this User Edit to Drop Account Numbers from the Summary Report. Enter location number in Field 2 and in Fields 3 through 8, enter the Account Number(s) you do not want to be counted and included in the Summary Report. Enter 1 account number per field. This can be used to removed Test Accounts so they are not counted or shown on the Summary Report. This is also used to know which account numbers are Company Owned account numbers and are moved to location 91 if needed. Syringa Wireless (BNTPL4) uses field 2 with location code. Generic (BNTPL7) always uses 01 in field 2 and then the account numbers. Multiples of this user edit are allowed. Field1:PLAN-SUMMARY-DROP-1 Field2:Location Number Field3:Account Number Field4:Account Number Field5:Account Number Field6:Account Number Field7:Account Number Field8:Account Number Example: In the example below, In Location 01 - Account Number 123456 & 7891234 will not be counted or included in the Summary Report
PLAN-SUMMARY-DROP-1	01	123456
		7891234
PLAN-SUMMARY-SECTION	Section Code#	This user edit assigns text descriptions to the five special section codes S01-S05 used in the Summary by Location Report. Field1:PLAN-SUMMARY-SECTION Field2:Section Code S01...S05 Fields3-8:Text Description of Section Example: In the example below, the section for S03 will appear in the Summary Report as "Section C"
PLAN-SUMMARY-SECTION	S03	Section C
PLANTINFO1		Allows you to specify if you want to see "Other" Outside Plant Provider info such as LCE & Cable Pair on the B-03:A screen (Telephone Number and Location screen). Field 01: PLANTINFO1 Fields 03-08: Leave blank The example below will cause the LCE & Cable Pair to show.
PLANTINFO1
PONODELETE		Setup this User Edit to 'Not' allow any Purchase Orders to be Deleted from Purchase Order Entry. Fields 02-08: Leave blank The example below will Not allow any Purchase Orders to be Deleted in Purchase Order Entry.
PONODELETE
PONOSHADING		Allows you to not print the shading in the boxes on the Purchase Order if you are using Purchase Order Print Program SPOPL1 or SPOPL2. Fields 02-08: Leave blank
PONOSHADING
PRINT-SPOOL-#-PDF		This User Edit is used to generate the spool file number when printing pdf files Field 3 will be the number to be generated and updated. In the Example below the spool file number for the pdf file that prints would be 000000001.
PRINT-SPOOL-#-PDF		Field 3 = 000000001
PRINTTOLLSUMMARY		If this code is set up, a Toll Summary by Phone and by Toll ID # will print on the statement. Can also print by Department if they are set up. Fields 02-08: Leave blank The fact that this code is present will print the summary. The example below would cause the toll summary by Toll ID # to print on the customer's bill.
PRINTTOLLSUMMARY
PROMISEPAYCLOSE$		This is used to delete Payment Promises if the amount paid is close to the amount promised. Four numeric characters need to be entered and left justified. If using an amount less than $10.00, enter leading zeros. This will be checked when posting cash receipts. Field 03: Dollar amount of how close it needs to be The example below would cause anyone within $00.75 to be close enough and have the Payment Promise deleted.
PROMISEPAYCLOSE$		0075
PROMO-BUNDLE-01		This user edit is used to enter Promo tariff bundles. Works with PROMO-BUNDLE-02. F2: 2 Digit order number, a period and Tariff Code for the bundle. (Order Number is used so you can control the order we look for these tariff codes, so one bundle can feed another bundle. F3: Quantity (enter the minimum quantity (3 digit key leading zeros) of F4 through F8 tariff codes needed.) a period, (Y, N) check savings, a period, 999.99 savings amount. (Check savings if a 'Y' if the amount the customer is charged is less than the savings amount the bundle tariff will not be added) F4 - F8: Tariff Codes (TARF1.TARF2.TARF3) (3 Tariff Codes separated by a period on each line) You can have multiple records for each bundle tariff code F2. You can only have up to 20 different bundle tariff codes. In the example below the Bundle Tariff code BUN01 would be added if the quantity of F4-F8 tariff codes the customer had were greater than or equal to 5 and removed if less than 5 and PROMO-BUNDLE-02 had the correct amount of must have tariff codes and the charge was not less than 10.00.
PROMO-BUNDLE-01	01.BUN01	F3: 005.Y.010.00 F4: TARF1.TARF2.TARF3 F5: TARF4.TARF5.TARF6 F6: TARF7.
PROMO-BUNDLE-02		This user edit is used with PROMO-BUNDLE-01, this user edit is used to enter the tariff codes the customer must have before the bundle tariff can be added. If the correct quantity of must have tariff codes are not there the bundle will not be added. PROMO-BUNDLE-01 with out enough tariff codes the bundle tariff will be removed if the customer already has it. F2: 2 Digit order, a period, Tariff Code for the bundle. F3: Quantity (enter the minimum quantity (3 digit key leading zeros) of F4 through F8 tariff codes needed.) F4 - F8: Tariff Codes (TARF1.TARF2.TARF3) (3 Tariff Codes seperated by a period on each line) You can have multiple records for each bundle tariff code F2. You can only have up to 20 different bundle tariff codes. In the example below the Bundle Tariff code BUN01 would be added if the quantity of F4-F8 tariff codes the customer had were greater than or equal to 2 and removed if less than 2.
PROMO-BUNDLE-02	01.BUN01	F3: 002 F4: SPCL1.SPCL2.SPCL3
PRORATE-FULL		Field 1 = PRORATE-FULL Field 2 = Field 3 through 8 = Tariff Codes to always prorate at their full amount regardless of the number of days of proration. Example: ABCDE.12345. 987. E+C1163
PRORATE-FULL		X1234.Y5678.ZABCD
PRSPECIALCOGL1		This edit is used in the Payroll program. This edit will only load specific GL's from the General Ledger Master in the GL dropdown based on the company selected. For Company Descriptions containing ... will be loaded I: “-ISP” L: “-LD” T: “-TVISION” In the example below, if the user has selected company "L", only G/L ‘s that have “-LD” in the description will be loaded into the dropdown list box. Note: The Entry code for the G/L still determines if the G/L is loaded into the dropdown for the employee. The User Edit "PAYROLLTIMECODE" will take precedence over this edit.
PRSPECIALCOGL1
PTIMECDBUDGETNOCHG		Use this to not change the budget code on payroll entries if they have the time codes that are entered in fields 3-8. This is used in conjunction with PAYROLLMASTERBUDGET. In this example any entries with time code 06 would stay just the way they were entered.
PTIMECDBUDGETNOCHG		06
PURCHASE-ORDER-DET	INFO	Determines the amount of detail that will be shown on the purchase order PDF. Field1: PURCHASE-ORDER-DET Field2: INFO Field3: X Field 3 explanation: if X = 1, or blank, or the user edit doesn't exist, all detail is shown. If X = 2, only display due date, requested by, and description. Example:
PURCHASE-ORDER-DET	INFO	1
QB-PATH-FROM-CTI		This user edit stores the path to the pre-built CTI QB txt files. Field1: QB-PATH-FROM-CTI Field2: Blank Fields3-8: Path to files Example
		C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
QWESTCABSFILENAME		This User Edit will replace 'FILE' the first 4 characters of the pc file with the cabs records to send off to be what is in field 3. Field 02: Leave blank Field 03: 4 Character File name Fields 4-8: Leave blank The example below would cause the file name to be PNTE2231.S20 instead of FILE2231.S20.
QWESTCABSFILENAME		Field 2: Field 3: PNTE
RECEIPTPRINTERFONT		This User Edit will allow you to Change the Font on the Customer Receipt that is Printed from Cash Receipts. Field 1: RECEIPTPRINTERFONT Field 2: Leave blank Field 3: Font Name Fields4-8 Leave blank In example below, Lucida Console will be the font used when printing a Customers Receipt in Cash Receipts.
RECEIPTPRINTERFONT		Lucida Console
RECURDISCOUNTTARIFF		This code lets you set up discounts for customers that have multiple services. This is based on what tariff codes the customer has. You will set up the tariff codes to look for. You also will set up the number of tariffs a customer has to have to qualify for the discount. This can be set up in steps. Example: 3 tariffs were found gets 10% discount, 5 tariffs found gets 20% discount. The amounts from the tariffs are accumulated and a new non recurring record is generate with the discount amount. As mentioned there are 2 parts to this, tariff set up and discount percent set up. Tariff Setup- Field 2 needs to have TARIFFCODES Fields 3-8 will have the tariff codes. You can put up to 3 per line. Enter a period between tariff codes, xxxxx.xxxxx.xxxxx. If you need more lines, do a 9 to add a new code. Use the same codes in fields 1 & 2. Discount- Field 2 needs to have PERCENTS (Add a new RECURDISCOUNTTARIFF code) Fields 3-8 have the step/percent/tariff code to use for billing. The period is just a seperater not part of the percent. 03.1000.DSCTF This would give a 10% discount for 3 tariffs found. DSCTF is the tariff for billing. 05.2000.DSCTF This would give a 20% discount for 5 tariffs found. " You can have as many steps as you want. You can also add another code for more. Note that the percent is a 4 decimal position field. This example will give a 10% discount for 3 tariffs found and 20% discount for 5 tariffs found. Tariff code DSCTF would be used for billing.
RECURDISCOUNTTARIFF	TARIFFCODES	ABCDE.FGHIJ.KLMNO PQRST.UVWXY
RECURDISCOUNTTARIFF	PERCENTS	03.1000.DSCTF 05.2000.DSCTF
RECURDISCOUNTTARIFF	OPTION2-MUST-HAVE	This user edit goes along with OPTION2-QUALIFY to give a list of tariff codes to check to match up with the qualifying tariff. Field 3 must match the qualifying tariff setup in the other user edit. If you need room for more tariff codes, set up a new user edit. Field 1 = RECURDISCOUNTTARIFF Field 2 = OPTION2-MUST-HAVE Field 3 = XQUAL (Must match up with field 3 from OPTION2-QUALIFYING user edit. Fields 4 - 8 = List of tariffs to check. Can key 3 per line, seperated by a period. The following example would provide a list of tariffs to check for Qualifying tariff XQUAL (See OPTION2-QUALIFY user edit)
RECURDISCOUNTTARIFF	OPTION2-MUST-HAVE	XQUAL XLST1.XLST2.XLST3 XLST4.XLST5
RECURDISCOUNTTARIFF	OPTION2-QUALIFY	This user edit will let you give a customer a discount if they have a qualifying tariff code and another tariff from a list of codes(Setup in another user edit). The two tariff codes can be on separate phone numbers but must be on the same account. There can be multiple discounts given but there must be a qualifying tariff to match one from the list. User Edit RECURDISCOUNT/OPTION2-MUST-HAVE will have the list of tariffs to check. Field 1 = RECURDISCOUNTTARIFF Field 2 = OPTION2-QUALIFY Field 3 = XQUAL (Qualifying tariff code) Field 4 = XBILL (Tariff code for billing) Field 5 = 00500 (Discount amount. 2 Decimal places) Fields 6 - 8 leave blank The following example below would give a $5.00 discount if a phone number on an account had a qualifying tariff of XQUAL and use XBILL tariff as the billing tariff code.
RECURDISCOUNTTARIFF	OPTION2-QUALIFY	XQUAL XBILL 00500
RECURDISCONTTARIFF	OPTION3-%-CREDIT	This user edit will give a percentage of monthly charges for specified number of months. The setup of this user edit is like OPTION3-TOTAL-CREDIT except a percentage is keyed rather than a dollar amount. The 'P' at the end of field 4 indicates that it is a percentage. There is no decimal places with the percentage. 000015 would = 15%. Field 3 is the qualifying tariff code and has to be on each customer that gets the discount. The OPTION3-TOTAL-CREDIT user edit must be set up for this user edit to work. If you don't want to give a total credit, set it up with zeros in the months and total credit. The following example would give a 15% credit for months 3-6 for the monthly charges.
RECURDISCOUNTTARIFF	OPTION3-%-CREDIT	XQUAL
		03-06.000015.XBILLD.P
		ZZHBO.ZZCMB
RECURDISCOUNTTARIFF	OPTION3-TOTAL-CREDIT	This User Edit can be used to give discounts for recurring/non-recurring charges. Could be used for doing promotions. A set dollar amount can be given over 1 or more months, and then a percentage of the monthly charges for more months. There are 3 user edits that make this discount possible. They all have 'OPTION3' as the start of field 2. They are all connected by a qualifying tariff code keyed in field 3. This tariff has to be added to each customer that qualifies for the discount. At month end billing time, all charges from recurring/non-recurring are subtracted from the total credit amount and given as a discount. This is done for the specified number of months or until the amount has been used up. Additional credit can be given through a percentage using user edit OPTION3-%-CREDIT. If you do not want to do a Total Credit but want to do a percentage for some months, set this user edit up with 00-00 for number of months and 000000 for the total amount. Then set up OPTION3-%-CREDIT with the number of months and percentage. Field 1 = RECURDISCOUNTTARIFF Field 2 = OPTION3-TOTAL-CREDIT Field 3 = XQUAL (Qualifying tariff code) Field 4 = 01-02.005000.XBILL.D (#of months, Total $ amount(2 decimals), Tariff code for billing, D=Dollar amount) Field 5 -8 List of tariff codes that qualify for the discount. Separated by a period. Key leading blanks if tariff code is not 5 long. The following example will give a total of $50.00 credit over the first 2 months for tariffs ZZHBO and ZZCMB.
RECURDISCOUNTTARIFF	OPTION3-TOTAL-CREDIT	XQUAL
		01-02.005000.XBILLD.D
		ZZHBO.ZZCMB
RECURDISCOUNTTARIFF	OPTION3-TRF-MAXIMUM	This user edit goes along with the other OPTION3 user edits. If you are giving credit for HBO(ZZHBO) and it is part of another tariff that has services combined(ZZCMB), this will let you set up amounts to use for discount purposes. There are two parts to this, a dollar amount and a percentage. The maximum dollar amount will be used when looking at recurring charges. This amount will normally be the amount normally charged for HBO. The percentage is used when looking at non-recurring charges. Key the percentage amount that HBO is of the combined tariff code. Field 3 is the qualifying tariff code and has to be on each customer that gets the discount. The OPTION3-TOTAL-CREDIT user edit must be set up for this edit to work. The following example will use, for tariff ZZCMB, $9.95 as the maximum amount to use for discounts if the charge is a recurring charge. It will use 35% of the charge from a non-recurring record.
RECURDISCOUNTTARIFF	OPTION3-TRF-MAXIMUM	XQUAL
		ZZCMB.000995.035
RECURDISCOUNTTARIFF	OPTION4-MUST-HAVE	This user edit goes along with OPTION4-QUALIFY to give a list of tariff codes to check to match up with the qualifying tariff. Field 3 must match the qualifying tariff setup in the other user edit. If you need room for more tariff codes, set up a new user edit. Field 1 = RECURDISCOUNTTARIFF Field 2 = OPTION4-MUST-HAVE Field 3 = XQUAL (Must match up with field 3 from OPTION4-QUALIFYING user edit. Fields 4 - 8 = List of tariffs to check. Can key 3 per line, separated by a period. The following example would provide a list of tariffs to check for Qualifying tariff XQUAL (See OPTION4-QUALIFY user edit)
RECURDISCOUNTTARIFF	OPTION4-MUST-HAVE	XQUAL XLST1.XLST2.XLST3 XLST4.XLST5
RECURDISCOUNTTARIFF	OPTION4-QUALIFY	This user edit will let you give a customer a discount if they have a qualifying tariff code and another tariff from a list of codes(Setup in another user edit). The two tariff codes can be on separate phone numbers but must be on the same account. There can be multiple discounts given but there must be a qualifying tariff to match one from the list. User Edit RECURDISCOUNT/OPTION4-MUST-HAVE will have the list of tariffs to check. This discount is a percentage of the cost. Field 1 = RECURDISCOUNTTARIFF Field 2 = OPTION4-QUALIFY Field 3 = XQUAL (Qualifying tariff code) Field 4 = XBILL (Tariff code for billing) Field 5 = 0500 (Discount percentage. 4 Decimal places) Fields 6 - 8 leave blank The following example below would give a 5% discount if a phone number on an account had a qualifying tariff of XQUAL and use XBILL tariff as the billing tariff code.
RECURDISCOUNTTARIFF	OPTION4-QUALIFY	XQUAL XBILL 0500
RECURENDBILLDATELSDT		This code is used when determining when a recurring charge with an End Date will stop billing. Normally the End Date is compared against the SVO Cutoff From Date. With this new user edit code, the Local Service From Bill date will be used instead. Key this code in field 1. Leave fields 2-8 blank. This example will cause the Local Service From Bill Date, instead of the SVO Cutoff Date, to be used when determining when a recurring tariff with an End Bill Date will stop billing.
RECURENDBILLDATELSDT
RECURRING-CHARGE-%		This User Edit allows you to give a Discount for Recurring Charges. This could be used to give Employees a Discount without setting up 2 sets of Tariff Codes with different amounts. The discount is figured during Step 6 of Month End Billing. The original Recurring Charges will show their normal charge and a Non-Recurring record is generated for the Discount Amount. A new Tariff Code would need to be set up for each discount that you want to use. This Tariff Code would be added to Recurring Charges for each phone number that gets the discount. There are two methods to choose from. - 1. Use ALL to indicate the Discount to be applied to All Tariff Codes EXCEPT the Tariff Codes entered in Fields 4 through 8. - 2. Use SELECT to indicate the Discount to be applied to Only the Tariff Codes entered in Fields 4 through 8. The method is entered into Field 3. If using the 'ALL' method, key 3 extra spaces to make it the same size as if 'SELECT' is used. The discount and tariff code for billing are also part of field 3. If no output tariff code is keyed, the tariff code from field 2 is used for output. In fields 4 through 8, enter up to 3 tariffs per line, Separated by a decimal. (Key leading blanks if the Tariff Code is not 5 long). If more room is needed for more tariff codes, add a second user edit with the same information in fields 1-3. To set this up: Field 1 = RECURRING-CHARGE-% Field 2 = Tariff Code that was setup for each Discount Amount. Example: XXXXX This will be used to look at Recurring Charges to see which Customers Qualify for the Discount. Field 3 = Discount Percent.Method.Tariff Code for Billing. Example: 015.ALL .ZBL15 or 005.SELECT. The Discount Percent is 3 digits long followed by a decimal. (Example; 100 = 100% and 005 = 5%) The Method would be ‘ALL ’ or ‘SELECT’. (If ALL is used, key 3 spaces after so it is 6 characters followed by a decimal. The Tariff Code for Billing can be a Tariff you set up or can be left blank and the Tariff Code entered in Field #2 will be used. ** Remember to key leading spaces if the tariff code is not 5 long. Field 4 through 8 = Tariff Codes to Include or Exclude based on the Method Used. Example: ABCDE.12345. 987. Enter the 5 character Tariff Code followed by a decimal. If you need room for more tariff codes, set up an additional user edit with fields 1-3 the same. **Remember to key leading blanks if the tariff code is less than 5 long. This example would give a 15% discount to all recurring tariff codes except X1234, Y5678, and ZABCD. ZBL15 would be used as the tariff code to show the discount on the bill.
RECURRING-CHARGE-%	ZPR15	015.ALL .ZBL15 X1234.Y5678.ZABCD
REMINDERNOTICE		This code is used to select the customers to get reminder notices. In field 3 you would enter the code to determine who gets reminder notices. The codes are 90DELQ, 60DELQ, 30DELQ AND CURRDELQ. Example: 90DELQ - If the 90 day balance = 0 the customer will get a reminder notice, if not they will get Disconnect notice. 60DELQ - If the 60 & 90 day balance = 0 the customer will get a reminder notice, if not they will get Disconnect notice. 30DELQ - If the 30, 60 & 90 day balance = 0 the customer will get a reminder notice, if not they will get Disconnect notice. CURRDELQ - If the Current, 30, 60, & 90 day balance = 0 the customer will get a reminder notice, if not they will get disconnect notice.
REPORTGROUPREQUIRED		A report group will need to be selected before you can update a service order. The example below would cause a report group to be required before a Service Order can be updated.
REPORTGROUPREQUIRED
RIATA-SECURITY	BY-COMPANY	This user edit will limit what customers can be viewed in Riata based on the customers company number. This is used in conjunction with the security file settings for the user. To view a customer that is in company 1 the user must have an "A" for that company in the Security file. With this user edit set up and the security file as follows, the user will only be able to see the customers in company 4 Company 1: Company 2: Company 3: Company 4: A Company 5: Company 6: Company 7: Company 8: Company 9:
RIATA-SECURITY	BY-COMPANY
RIATA-STATEMENT-CO#		This User Edit will allow you to print company specific overlays when printing an AS400 statement from Riata. If this code is setup, the company # will be retrieved from the account to know which overlay to print. Use this if you have multiple companies and you have different statement overlays for them. Field 1 = RIATA-STATEMENT-CO# Fields 2-8 = Leave blank The example below will let the Riata AS400 statement printing to go look for the company # from the account to know which overlay to use.
RIATA-STATEMENT-CO#
S2CASH-REQ-TARIFFS		This user edit is used in 2007 Service Order Entry. Another user edit (S2SERVICETYPEDEF01) sets the default cash that is required on each service order. If the user has the tariff code listed in the S2CASH-REQ-TARIFFS these settings will override the default. Note, you can have multiple entries of this user edit. Example: Field 1 S2CASH-REQ-TARIFFS Field 2 blank Fields 3-8 xxxxx.N.N.N.N (tariff code, Recurring cash required, Non-Recurring cash required, Deposit cash required, Equipment only required)
S2CASH-REQ-TARIFFS		ABCDE.N.N.N.Y.
S2ONE-TIME-CHARGES		This edit tells the system which charges are one time charges (Non Recurring) in the "2007 Service Order Entry" program. This edit allows the user to easily select the one time charges for the customer. Field 1: S2ONE-TIME-CHARGES Field 2: Fields 3 - 8: One time charges separated by a period. In the example below, the following charges will be displayed in the One Time Charges list and will be checked if the customer already has them. QQ033, QQ034, QQ035, QQ036. Note: Make sure each charge take up 5 spaces and has a period when entering.
S2ONE-TIME-CHARGES		Field 3: QQ033.QQ034. ABC. Field 4: QQ036.
S2SPECIAL-REC-CHARGE		This edit tells the system which charges are “Special Recurring Charges” in the "2007 Service Order Entry" program. This edit allows the user to easily select the special recurring charges for the customer. Field 1: S2SPECIAL-REC-CHARGE Field 2: Fields 3 – 8: Special Recurring Charges separated by a period. In the example below, the following charges will be displayed in the Special Recurring Charges list and will be checked if the customer already has them. SPR01, SPR02, 123, SPR03. CWT. Note: Make sure each charge take up 5 spaces and has a period when entering.
S2SPECIAL-REC-CHARGE		Field 3: SPR01.SPR02. 123. Field 4: SPR03. CWT.
SALES-COMMISSION	IGNORE-CODE	This user edit will fill the “Ignore Code” dropdown in the Commission Report program To set this up: Field 1: SALES-COMMISSION Field 2: IGNORE-CODE Field 3-8: X Description (Code then a space the a description for the code) The “Code” will be stored in the file. You will see the Description the code represents in the program In the example below, the user will see and be able to select “Sale” and “Return” in the dropdown and “S” or “R” will be the code stored in the file.
SALES-COMMISSION	IGNORE-CODE	S Sale R Return
SALES-REPORT-EXCHANG		This edit is used in the Sales Report to display the Exchange in the location column.
SALES-REPORT-EXCHANG
SALES-REPORT-TARIFF		This edit is used in the Sales Report. The "Plan" Tariffs will come from the Salesman Commission Level 2 Codes file (BSLLV2) instead of the Recurring file Selection file (BRC01). You will need to set up a level 2 code to have this work: From the Start 1 menu: 1. Enter 23 System Maintenance 2. Enter 23 Goto Maintenance Menu #2 3. Enter 23 Go to More Maintenance Items 4. Enter 17 Salesman Commission/Operations Rpt 5. Enter 2 for Level 2 Codes and press Cmd 5 6. Enter a 9 to add and enter "QCOMMSN01" for the Level 2 code 7. Enter the description, Level 1 code, and the tariffs needed The following example will display only tariffs found in the Salesman Commission Level 2 Codes file that have "QCOMMSN01" in the Level 2 Code
SALES-REPORT-TARIFF
SALESMAN-PERMANENT	REQUIRED	This User Edit will require that the "Permanent Sales Person" on the Phone Number information screen and 2007 Service Order Entry be selected before the service order can be updated. In the example below the "Permanent Sales Person" will be required before the user can update the service order.
SALESMAN-PERMANENT	REQUIRED
SALESMANCOM#OFMONTHS		This code lets you setup the # of months a cellular phone must stay active for commission to be paid. If a phone is disconnected before the # of months, it will show on the commission report to back out the commission. Key this code in field 1. Leave field 2 blank. Key the # of months in field 3. This needs to be 3 numbers long. Key leading zeros. Example: 6 months would be keyed 006, 12 months would be 012. The following example would cause cellular phones that disconnect within 6 months to show on the Salesman Commission Activation/Disconnect Report.
SALESMANCOM#OFMONTHS		006
SALESPERSONEACHSVO		This edit enables you to require the user to enter the Sales Person code before the Service Order is updated on a Phone or ID number based on the customers company number or NPA-NXX. Field 01: SALESPERSONEACHSVO Field 02: Leave Blank Field 03: Enter the Companies that require a Sales Person Code Fields 4 - 8 The NPA/NXX that require a Sales Person Code separated by a period. In the Example below, if the customer is assigned to company 3 or 6, or the customers NPA-NXX is 208152 or 406854 or 307291, the Sales Person code must be entered before the Service Order can be updated.
SALESPERSONEACHSVO		Field 3: 36 Field 4: 208152.406854.307291
SALESPERSONLABEL		This User Edit is used to change the caption of the Sales Person 1 and 2 codes in the Phone Number Information screen in Service Order Entry and Inquiry on the other tab and in the Inventory Withdrawal-Resell screen.. Field 02: Leave blank Field 03: The caption for Sales Person 1 Field 04: The caption for Sales Person 2 Fields 05-08: Leave blank Note: “Sales Person 1” and “Sales Person 2” are the defaults and will be the captions if this edit is not found or if field 3 or 4 is blank. In the example below, “Sales Person 1” will be replaced with “Sales Representative” and “Sales Person 2” will be replaced with “Verified By”
SALESPERSONLABEL		Field 2: Field 3: Sales Representative Field 4: Verified By
SCHOOLS-LIBRARY	ADJUSTMENT-TARIFFS	This user edit will allow the tariff codes entered to be printed on the SCHOOL/LIBRARY DISCOUNT CALCULATION report flagged with an * and the amount for the tariffs entered will not be added to the total. Fields 3-8: You can enter 3 tariff codes per line with a period between the tariff codes. Make sure you enter leading spaces if needed. If you need to add more than 18 tariffs, add another entry of SCHOOLS-LIBRARY ADJUSTMENT-TARIFFS with the needed tariff codes. In the example below, TRF1 to TRF3 and TARF1 to TARF3 will be printed on the SCHOOL/LIBRARY DISCOUNT CALCULATION report flagged with an * but not added to the amount.
SCHOOLS-LIBRARY	ADJUSTMENT-TARIFFS	FIELD 3: TRF1. TRF2. TRF3 FIELD 4: TARF1.TARF2.TARF3
SEND300015		This is used to send a larger file that has 1500 characters of notes in the 15 minute file. If SEND300015 is found, more notes are sent. Make sure CTI helps you get file format changes made before using this. The example below will be send this larger file.
SEND300015
SENDDESC15		This is used to send the service order description in a separate field, position 510-559 in 15 minute file. If SENDDESC15 is found, the service order description will be sent in those positions. The example below the service order description will be sent in those positions.
SENDDESC15
SENDNOCHANGEAUTO15		This is used to not automatically change the flag in the 15 minutes service order file if a change has been made to the service order. We look at what was sent last time and if anything has changed, we automatically set the flag for you. If you have this set up then you are required to make sure you manually select the service order has changed check box on the service order master and we do nothing automatically.
SENDNOCHANGEAUTO15
SENDNODESC15		This is used to not send the service order description with the notes in the 15 minute file. If SENDNODESC15 is found the service order description will not be sent with the notes. The example below the service order description not to be sent with the notes in the 15 minute file.
SENDNODESC15
SIGNATURE	FILENUMBER	This code is used to track the next file number for signatures. It increments by one every time we attempt to obtain a signature through the handheld signature device.
SIGNATURE	FILENUMBER	0000000006
SMS-BATCH-DOMAIN		This edit is used to default the @ Domain Name field in the batch sms program. Field1: SMS-BATCH-DOMAIN Field2: Fields3-8 the domain name the sms messages will be sent from. (i.e. syringawireless.com) Note: This is the end portion of the email address the sms messages will come from...Only enter information appearing on the right side of the @ sign in the email address. Example:
SMS-BATCH-DOMAIN		syringawireless.com
SMS-BATCH-FILENAME		This edit is used when Importing QB files, and provides descriptions and filenames for commonly used files Field 1: SMS-BATCH-FILENAME Field 2: Field 3: Description 1 Field 4: Filename 1 Field 5: Description 2 Field 6: Filename 2 Field 7: Description 3 Field 8: Filename 3 In the example below are three filenames and their descriptions.
SMS-BATCH-FILENAME		Field 3: Description For First File Field 4: ZZFILE1 Field 5: Description For Second File Field 6: ZZFILE2 Field 7: Description For Third File Field 8: ZZFILE3
SMS-BATCH-TARIFF		This edit is used when building switch commands, and provides descriptions and codes for commonly used tariffs Field 1: SMS-BATCH-TARIFF Field 2: Field 3: Description 1 Field 4: [tariff] . [tariff] . [tariff] Field 5: Checkbox "Has Tariffs" is checked? (Y=checked) Field 6: Description 2 Field 7: [tariff] . [tariff] . [tariff] Field 8: Checkbox "Has Tariffs" is checked? (Y=checked) In the example below are two groups of tariffs, their descriptions and each "Has Tariffs" checkbox settings
SMS-BATCH-TARIFF		Field 3: First Group Field 4: TRF1A . TRF1B . TRF1C Field 5: Y Field 6: Second Group Field 7: TRF2A . TRF2B . TRF2C Field 8: (blank) (blank = do not check checkbox)
SMS-COMPANY-CODE	4 character company code	This edit is used when pulling in the SMS information from the .act file. Field 1: SMS-COMPANY-CODE Field 2: four character company code Field 3-4: “.com” name to look for in the file Field 5-6: the path to save the file for the company Field 7: Blank Field 8: Blank In the example below we will look for ALLWEST.COM when reading through the file. Any matches will be displayed in the list to the right of ALLW. When the save button is clicked, we will save the information to C:\ALLW folder. Note: The path in fields 5 and 6 will need to be set up before the program is ran.
SMS-COMPANY-CODE	ALLW	Field 3: ALLWEST.COM Field 4: Field 5: C:\ALLW
SMS-CONF-PAGE		This user edit indicates the URL we receive confirmation from as to the status of the SMS message just sent through T34BLMULTSMS. Fields 3-8 combined contain the URL
SMS-CONF-PAGE		http://smsc2.interop technologies.com/cgi -bin/message.cgi
SMS-DROP-NUMBERS		This user edit is used to enter the Phone numbers to use when Dropping Free SMS Records. Multiples of this user edit are allowed. Field3-8: XXXXXXXXXX (10 character phone #) In the example below phone # 208-456-1111 would have the SMS records dropped.
SMS-DROP-NUMBERS		Field3: 2084561111
SMS-START-PAGE		This user edit indicates the URL we point to when sending SMS messages through T34BLMULTSMS. Fields 3-8 combined contain the URL
SMS-START-PAGE		http://216.83.73.200
		/syringawireless/t34
		alooksms.asp
STATEMENT-FORCE	FED-TAXES	This User Edit will force any Federal Taxes for statements to be put in their own section of the statement. The tax amounts are pulled out of the other sections and put in a new section based on the Revenue Belongs To and Bill Type from the tariff code from field 3 of this user edit. Field 1: STATEMENT-FORCE Field 2: FED-TAXES Field 3: 12345 Fields 4-8: Leave Blanks This example will cause any Federal Taxes on statements to be pulled out of other sections and put into another section based on the Revenue Belongs To and Bill Type from tariff code 12345.
STATEMENT-FORCE	FED-TAXES	12345
STATEMENT-FORCE	STATE-TAXES	This User Edit will force any State Taxes for statements to be put in their own section of the statement. The tax amounts are pulled out of the other sections and put in a new section based on the Revenue Belongs To and Bill Type from the tariff code from field 3 of this user edit. Field 1: STATEMENT-FORCE Field 2: STATE-TAXES Field 3: 12345 Fields 4-8: Leave Blanks This example will cause any State Taxes on statements to be pulled out of other sections and put into another section based on the Revenue Belongs To and Bill Type from tariff code 12345.
STATEMENT-FORCE	STATE-TAXES	12345
STATEMENT-FORCE-SORT		This User Edit will allow you to force tariff codes to have specific Revenue Belongs To and Bill Type codes for statement printing. This could change the order and group they are printed with on the statements. You will enter the tariff codes that will be affected by this sort. Field 1: STATEMENT-FORCE-SORT Field 2: Leave Blank Field 3: XXX.YY (XXX=Revenue code to use YY=Bill Type code to use) Field 4-8: XXXXX. YYYY. ZZ List tariff codes that this sort applies to. Can key 3 tariff codes per line. Seperate tariffs with a period. If tariff codes are less than 5 characters long, key leading spaces. The following example will change the Revenue code to CTI and the Bill Type code to CL for the tariff codes listed.
STATEMENT-FORCE-SORT		CTI.CL
		12345. ABCD. XYZ
STATEMENT-GOV-DATES		This User Edit will make the Local Service Dates on statements show a month prior to the current months dates. This could be used for customers that you don't want to advance bill for service, like government customers. Along with this, the phone has to be set up to Prorate as Government and to not charge Federal taxes. The following example will cause local service dates to print 1 month prior to the current on statements.
STATEMENT-GOV-DATES
STATEMENT-PULL-PRIOR	MONTHS-ADJUSTMENTS	This user edit will make it so that Adjustments to Prior Months statements will be pulled out of the normal changes section of statements and shown in it's own area. On the front page the adjustments will show just below any payments made. On the detail pages, they will show at the top of the page before any other detail prints. Field 1- STATEMENT-PULL-PRIOR Field 2- MONTHS-ADJUSTMENTS Fields 3-8 Leave blank The following example will pull Prior Months Adjustments from the changes section of a statement and show them in their own areas.
STATEMENT-PULL-PRIOR	MONTHS-ADJUSTMENTS
STATEMENTS-UPDATE	MAILOUT-FLAG	This User Edit is used at Month End Billing time to determine what type of bill a customer will get. Example: Paper or E-Bill. This is based on if the customer has tariff codes to suppress the printing of call detail on the bill. Each phone on the account will be checked for the Print Detail/No Detail tariff codes. If all numbers are printing detail, a paper bill will be generated. If all are not printing detail, an E-Bill will generate. If there is a combination, both a paper and an E-Bill will generate. This is mainly for Cellular bills. Leave fields 3 - 8 blank. This example will cause a check to be done at month end to see what type of bill a customer should get. Paper, E-Bill or Both.
STATEMENTS-UPDATE	MAILOUT-FLAG
STORE-LOCATION	REQUIRED	This User Edit will force the user to select the Store Location on the "Other" tab in the Phone Number Information screen. The example below will make the user select something from the "Store Location" dropdown before they can update the information.
STORE-LOCATION	REQUIRED
STORE-NPA-NXX		This edit stores the NPA NXX combinations assigned to the stores. It is used for determining who the local calls belong to in T34BLLOCAL.exe. Field 2 is left blank Fields 3 - 8 are the NPA NXX combinations assigned to the store. They are period delimited. You can have multiple of these records if you need more space. Example:
STORE-NPA-NXX		Field3: 208349.208527.208554 Field4: 208588.208638.208645 Field5: 208673.208698.208766 Field6: 208767.208824.208827 Field7: 208208.208209.208210 Field8: 208211.208212.208213
SURCHARGE-ADD-TAX		This user edit is used to allow taxes to be calculated on surcharges. Fields 2-8: Leave Blank In the Example below the taxes would be calculated for surcharge amounts..
SURCHARGE-ADD-TAX
SVO-MASTER-NO-RS		This user edit will prevent "Reconnect" and "Suspend" from being added to the Service Order Type dropdown list on the Service Order Master Screen In the example below when the user clicks the Service Order Type dropdown list, "Reconnect" and "Suspend" will not be an option to select
SVO-MASTER-NO-RS
SVOAPPROVESTAGE		Will only let Service Orders at a certain stage be approved. If SVOAPPROVESTAGE is not found, the program runs as it always has. If it is found, the Service Order must have one of the stages listed in Fields 03-08 to be approved. (If the Service Order is to be removed/deleted, the stage does not matter). Field 01: SVOAPPROVESTAGE Field 02: Leave blank Field 03-08: Approval stages The example below would cause the Service Order to have 'All Done' or 'Send to Geo' as a Stage before it could be approved.
SVOAPPROVESTAGE		ALL DONE SEND TO GEO
SVOCONTROL		This controls what items must be completed before the service order can be approved. You may set up to 7 different items. The CSR who sets up the service order puts a check box next to the items that need to be done. This makes is to the 'Who has Control' is not a step by step process. The example below would require any marked items be completed before the service order can be approved.
SVOCONTROL
SVODESCNOTE		This is used to automatically add a note using the service order description. If SVODESCNOTE is found and the service order does not already have a note we will create a note for the service order using what is in the description field in the service order master screen (C-03:A) The example below would automatically create a note from the SVO description when the user clicks the update button on the Service Order Master screen (C-03:A).
SVODESCNOTE
SVOENTGUZIPREQ		If this user edit exists the generally used zip code in the quick service order must be populated with one of the zip codes in the list. Fields 2-8 are blank
SVOINTERNETCHANGE		This is used to allow the user to change the User Name, Type, and Internet Service Provider for existing Internet information. Without this edit, the User Name, Type, and Internet Service Provider will be disabled and can not be changed. In the example below, the user will be able to change the User Name, Type, and Internet Service Provider. NOTE: Do not use this edit if you automatically talk to your e-mail server.
SVOINTERNETCHANGE
SVOMAINBILL		We have created a new Edit to load the Type of Main Bill dropdown box in the Phone Number Information Screen in service order entry. Use this edit if you want to have the 01 and 02 options displayed in the dropdown box. To set this up, Field 1: SVOMAINBILL Field 2: Leave Blank Field 3: 00 (Displays "00-Combined Rating And Billing" in the dropdown box) Field 4: 01 (Displays "01-Combine for Rating, Bill Separately" in the dropdown box) Field 5: 02 (Displays "02-Separate for Rating, Combine for Billing" in the dropdown box) The 00 option will always be displayed in the dropdown. To have the 01 option displayed enter 01 in field 4. To have the 02 option displayed enter 02 in field 5. In the example below, there will only be 2 items displayed in the Type of Main Bill on the Phone Number Information screen on the Bill Info tab.
SVOMAINBILL		Flield 3: 00 Field 4: Field 5: 02
SVOPRINT$		This is used to print the total before taxes and the total after taxes for the Recurring Charges as well as the Non-Recurring Charges when the service order is printed. Field 01: SVOPRINT$ Fields 02-08: Leave blank. The example below will cause the Recurring and Non-Recurring Charges to print on the service order with totals.
SVOPRINT$
SVOPRINTMAIL		This will print the Mailing Address (from the Account) below the 911 description when the Service Order is printed . Field 01: SVOPRINTMAIL Fields 02-08: Leave blank. The example below will cause the Mailing Address to be printed below the 911 description on the Service Order.
SVOPRINTMAIL
SVOPRINTNEWSUB		This Code is used to print the new Sub LOC, LCE, Cable Pair, and Pedestal information from you outside plant provider when the Service Order is printed. Key "SVOPRINTNEWSUB" in field 1. Leave fields 2-8 blank. This example will print the new Sub LOC, LCE, Cable Pair, and Pedestal information after the 'Tech Information' when the Service Order is printed from the Phone Program.
SVOPRINTNEWSUB
SVOSTAGE	Stage Code	This allows you to control the Stage drop-down box based upon the selected Service Order Type 2. Stage Description - 'Stage Code' shows in the Stage drop-down box. Use the 2-character code from the Service Order Type 2 Code drop-down box for Fields 03-08, using multiple character codes per line, separated by a period. Always enter the period after the code. You can do the same for each of the Stages. If you set nothing up, then all Stage Descriptions/Stage Codes are shown. Field 01: SVOSTAGE Field 02: Stage Code Fields 03-08: Service Order Type 2 Code The example below would cause only Stage Code GEO to show in the Stage Description box when any of the Service Order Type 2 Codes RE, EO, L or RZ are selected in the drop-down box.
SVOSTAGE	GEO	RE.EO. L.RZ.
SVOTYPE2	Service Order Type Code	Allows you to control the Service Order Type 2 drop-down box based upon the service order type. Use the Service Order Type 2 Codes you have set up to be in the drop-down box for this Service Order Type Code. Fields 03-08 are used with multiple 2 character codes per line separated by a period. Always enter the period after the code. Service order Type Codes are: N=New Install, C=Change, D=Disconnect, S=Suspend, R=Reconnect You can view what Type 2 codes you have set up by running #4 ' Service Order Type 2 Codes'. These are 2-character codes so leading and trailing blanks are critical if they are used. You can do the same for each of the service order types. If you set nothing up then all Type 2 codes are shown. Field 01: SVOTYPE2 Field 02: Service Order Type Code Fields 03-08: Service Order Type 2 Codes The example below would cause only the Type 2 code descriptions associated with codes, RE, EO, L, & RZ to be the drop-down box whenever there is a Change Service Order.
SVOTYPE2	C	RE.EO. L.RZ.
SWITCH-AUTO-BATCH		Use this user edit to enter the automatic batch tariff codes for switch commands. This is used to select the tariff codes to use to create the batch switch commands to send to the switch. You can use tariff codes from the SWITCH-COMMAND-MERGE user edit. Fields 3-8; enter the tariff codes that have the switch commands you want to send in the batch.(3 5 char tariff codes separated by a period) This example will cause tariff codes 12345 and ABCDE to be used to create the batch switch commands to send to switch.
SWITCH-AUTO-BATCH		Field 2 = Leave Blank Field 3 = TAR12.12345.ABCDE. Field 4 = B1234. TR3.
SWITCH-CODE		This user edit is used to fill the “Switch Code” dropdown list box in Riata. Field 1: SWITCH-CODE Field 2: Field 3: CODE Field 4: Description for the code in field 3. Field 5: CODE Field 6: Description for the code in field 5. Field 7: CODE Field 8: Description for the code in field 7. The Code can be a maximum of 3 characters long left justified, the description a maximum of 20 characters. In the example below "Switch Code 1", "Switch Code 2", and "Switch Code 3" will be loaded into the dropdown list box.
SWITCH-CODE		001 Switch Code 1 008 Switch Code 2 011 Switch Code 3
SWITCH-COMMAND-CGN	NPA-NXX	Use this user edit to enter the NPA-NXX and tariff for a Customer Group Number Field 2; enter the NPA-NXX Field 3; enter the Tariff Code Field 4; enter the Customer Group Number This example will cause 125 to be sent to the switch for Customer Group Number for 208-454 and tariff code A345C.
SWITCH-COMMAND-CGN	208-454	Field 3 = A345C Field 4 = 125
SWITCH-COMMAND-DROP		This User Edit lists a switch command which will be dropped if the customer has 1 or more of the tariff codes also listed in this user edit. Field 2 contains the switch type in position 1 then a dash, then a 3 character code. 'ALL' means it will be done in all cases. If there is a different code, it will only be used by certain programs. An example of a different code would be 'SP1'. Fields 3-4 contain the switch command to drop. Fields 5-8 contain the tariff codes (separated by periods) which will cause the switch command to be dropped. In the example below, any switch command containing the word FMR will be dropped if the customer has one or more of the following tariff codes: 12345, ABCDE, 45678, FGHIJ, 91011, KLMNO, or 12131 This tariff code may have multiples if their are more than 9 tariff codes needed.
SWITCH-COMMAND-DROP	3-ALL	Field 3 FMR
		Field 4
		Field 5 12345.ABCDE.45678
		Field 6 FGHIJ.91011.KLMNO
		Field 7 12131.
SWITCH-COMMAND-MERGE	Switch Type	Use this user edit to merge tariff codes for switch commands. This is used when you have multiple tariff codes that use the exact same switch commands such as when you have 3 tariff codes that all mean Block SMS. Field 2; enter the Switch Type Field 3; enter the Tariff Code that has the Switch Command you want to use Fields 4-8; enter the tariff codes that have the same switch commands as the tariff code in field 3. This example will cause tariff codes 12345 and ABCDE and 56789 and DEFGH to use the same switch commands as ZZZZ1 for switch type 3.
SWITCH-COMMAND-MERGE	3	Field 2 = 3 Field 3 = ZZZZ1 Field 4 = 12345.ABCDE.56789 Field 5 = DEFGH
SWITCH-T7000	PATH-SAVE	This user edit indicates the location where the T7000 xml files will be saved. Fields 3-8 are added together to form the path.
SWITCH-T7000	PATH-SAVE	C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
SWITCHCOMMANDADD		Setup this User Edit to Automatically add Switch Commands if a combination of Tariff Codes exist. We also automatically remove that Switch Command if the combination of Tariff Codes is no longer in place. Note**The order of Switch Commands is very important. Switch Commands tied to Tariff Codes in Fields 3 & 4 of the User Edit must have a switch order in the range of 10-90. Switch Commands tied to the Tariff Code in Field 5 must have a switch order in the range of 01-05. Switch Commands tied to the $$$01 Tariff Code in Field 6 must have a switch order of 95 and Switch Commands tied to the $$$02 in Field 6 must have a switch order of 05. Example; If a customer has Caller ID and Call Waiting ... We will automatically add SCWID to the Switch. If thereafter, Caller ID is removed, we will automatically remove SCWID from the switch. ** Contact Josh Tatton before Setting up this User Edit. Field 2 = Switch Type Field 3 = Incompatible Tariff Codes (xxxxx.xxxxx.xxxxx) (If the customer has this combination of Tariffs) Field 4 = .... Continuation of Incompatible Tariff Codes (xxxxx.xxxxx.xxxxx) (If the customer has this combination of Tariffs) Field 5 = Tariff Code that Removes the Tariff Code we automatically added. Field 6 = 'Fake Tariff Codes' automatically add & automatically remove the special Switch Command. Field 7 = A description of the Special Command being added to the Switch Field 8 = Leave Blank
SWITCHCOMMANDADD	2	Field 3 = CWT.CNAMD. Field 4 = . . Field 5 = NOSCD Field 6 = $$$01.$$$02. Field 7 = Call Waiting ID Field 8 =
SWITCHCOMMANDCHECK	2LCE	This code will allow you to enter the tariff codes used if the customer has 2 LCE's and you do not want to send switch commands when doing the Auto Disconnect. In this example the if the customer has tariff codes that are in field 3 - 8 the switch commands will not be sent. Field 3-8 will be the Tariff codes.
SWITCHCOMMANDCHECK	2LCE	ABCDE.FGHIJK.LMNOP. QRSTU.VWXYZ.
SWITCHCOMMANDCHECK	REMOTECALLFWD	This code will allow you to enter the tariff codes used if the customer has Remote Call Forward and you do not want to send switch commands when doing the Auto Disconnect. In this example the if the customer has tariff codes that are in field 3 - 8 the switch commands will not be sent. Field 3-8 will be the Tariff codes.
SWITCHCOMMANDCHECK	REMOTECALLFWD	ABCDE.FGHIJK.LMNOP. QRSTU.VWXYZ.
SWITCHCOMMANDCHECK	SECONDARYDN	This code will allow you to enter the tariff codes used if the customer has Secondary DN and you do not want to send switch commands when doing the Auto Disconnect. In this example the if the customer has tariff codes that are in field 3 - 8 the switch commands will not be sent. Field 3-8 will be the Tariff codes.
SWITCHCOMMANDCHECK	SECONDARYDN	ABCDE.FGHIJK.LMNOP. QRSTU.VWXYZ.
SWITCHCOMMANDCHECK	TRUNKHUNT	This code will allow you to enter the tariff codes used if the customer has Trunk Hunt and you do not want to send switch commands when doing the Auto Disconnect. In this example the if the customer has tariff codes that are in field 3 - 8 the switch commands will not be sent. Field 3-8 will be the Tariff codes.
SWITCHCOMMANDCHECK	TRUNKHUNT	ABCDE.FGHIJK.LMNOP. QRSTU.VWXYZ.
SWITCHCOMMANDCHECK	VIRTUALDIRECTORY	This code will allow you to enter the tariff codes used if the customer has Virtual Directory and you do not want to send switch commands when doing the Auto Disconnect. In this example the if the customer has tariff codes that are in field 3 - 8 the switch commands will not be sent. Field 3-8 will be the Tariff codes.
SWITCHCOMMANDCHECK	VIRTUALDIRECTORY	ABCDE.FGHIJK.LMNOP. QRSTU.VWXYZ.
SWITCHCOMMANDLTG		Use this to send different Line treatment groups for a range of numbers when using the Auto Disconnect. You will use this if you need to send different switch restrict/unrestricted line treatment group for a range of numbers. In this example the within the phone number range of 123-456-1200 to 123-456-1300 the restrict line treatment group will be 188 and the unrestricted line treatment group will be 180. Field 3 will be the From Phone number. Field 4 will be the To Phone number. Field 5 will be the Restrict Line Treatment group. Field 6 will be the Unrestricted Line Treatment group.
SWITCHCOMMANDLTG		123-456-1200 123-456-1300 188 180
SWITCHINFOKEEP		This will keep the information on the switch when you are doing a Suspend/Reconnect. Field 2 Leave blank Fields 3-8 are usually blank, unless you have some special tariff codes that you add/remove when you suspend/reconnect that you want to use to generate a switch command. You can enter 3 tariff codes per line with a period between the tariff codes for a total of 18. Make sure you enter leading spaces if needed. If you add some tariff codes here and you do a suspend order and add a tariff code to the recurring charges on the service order, that tariff code must have 0 cost to create a switch command. The example below will cause the Suspend or Reconnect to be the only information sent to the switch except any switch commands associated with tariff codes ABCDE or 12345 or XYZ will still be sent to the switch.
SWITCHINFOKEEP		ABCDE.12345. XYZ.
SWITCHMAXXTARIFF		These are tariff codes you want to send to switchmaxx when sending customer data XML. Field 2 Leave blank Fields 3-8 You can enter 3 tariff codes per line with a period between the tariff codes. Make sure you enter leading spaces if needed. If you need to add more than 18 tariffs, add another entry of SWITCHMAXXTARIFF with the needed tariff codes. The example below will allow the following tariff codes to be sent to switchmaxx.
SWITCHMAXXTARIFF		ABCDE.12345. XYZ.
SWITCHNAMES		This is used for you to specify which Switch you are accessing when you process your own switch toll that is pushed to a particular folder. You can have up to 6 switch names. Fields 03-08: Switch names The example below would cause these 3 names to show in the drop down box when processing your BMC switch toll.
SWITCHNAMES		Rupert DMS 100 Paul DMS 10 Burley DMS 100
SWITCHNOPIC	2	Use this code to set up the "PIC" they will use to indicate to the switch program there is No Carrier. Example:
SWITCHNOPIC	2	Key
		Switch Type
		9999 Fake PIC displayed in Riata…we will replace this with the value of line 4 (NILC in this case)
		NILC What replaces the fake pic
SWITCHPASSWORDCHGDAT	SWITCHTYPE	This tells us when we should start flashing a message warning you to change your switch password. Field2: is the switch type (i.e. 2 for DMS100 WIRED) Field3: is the date the switch password was last changed. Field4: is the number of days before we warn you. See the example below:
SWITCHPASSWORDCHGDAT	2	Field 1 = SWITCHPASSWORDCHGDAT Field 2 = 2 Field 3 = 08/01/2006 Field 4 = 60
SWITCHRETURNCHECK		The User Edit is setup to determine what look for in the Switch Query and the Message to display to the User. For Example; if you are looking for all customers that have 'RR' (RR=Rural Route) in the Switch, and therefore they can not have 'Caller ID' (because it is not available to them), then you would enter RR in Field 3, and 'Caller ID Not Available' in Field 5 and 'CALID' Tariff (Caller ID Tariff) in Field 7. Also, in the last 3 spaces of Field 7 you must enter .S(space). In this example, Switch Query would display a 'Stop' message (this is triggered by the .S(space) in Field 7) notifying the User to make sure they review the following messages. Then all customers that have an RR would be displayed with the message 'Caller ID Not Available) and if the customer has tariff code 'CALID' it is Not allowed. **Contact Josh Tatton before Setting-up this User Edit. Field 2 = Switch Type Field 3 = Phrase or Characters you are looking for..... Field 4 = ....Continuation of Phrase or Characters you are looking for. Field 5 = The Message to the User when the Phrase or Characters are found... Field 6 = ....Continuation of the Message to the User when the Phrase or Characters are found. Field 7 = Tariff Codes to Look for that are Not Allowed + Stop Notify Command (xxxxx.xxxxx.xxxxxx.S ) Field 8 = ....Additional Tariff Codes that are Not Allowed (xxxxx.xxxxx.xxxxx.) Below is exactly what would be entered in the Example explained above.
SWITCHRETURNCHECK	2	Field 3 = RR Field 4 = Field 5 = Caller ID Not Available Field 6 = Field 7 = CALID. . .S Field 8 =
SWMXORDERDIR		This is the directory that contains the switchmaxx orders. Fields 3-8 are concatenated to form the directory path.
SWMXORDERDIR		C:\thispathis
		verylong\
		andin\is
		notnormal
SWMXORDERNUMBER		This is an incrementing number we use to send an order number to switchmax. It increments every time we process an order. Field 3 contains the number.
SWMXORDERNUMBER		0000000001
SWMXORDERSTATDIR		This is the directory that contains the switchmax orders statuses. Switchmaxx will monitor this directory to verify the status of an order. Fields 3-8 are concatenated to form the directory path.
SWMXORDERSTATDIR		C:\thispathis
		verylong\
		andin\is
		notnormal
SYRINGA-WIRLESS	OWNER-EXCLUDE	You will use this user edit to enter the Tariff Codes to drop when pulling Syringa Wireless Non-Recurring Owner file. Field 1 = SYRINGA-WIRELESS Field 2 = OWNER-EXCLUDE Field 3-8: You can enter 3 tariff codes per line with a period between the tariff codes. Make sure you enter leading spaces if needed. If you need to add more than 18 tariffs, add another entry of SYRINGA-WIRLESS OWNER-EXCLUDE with the needed tariff codes. In the example below Tariff Codes TRF1, TRF2, and TRF3 will be excluded from the Non-Recurring Owner file.
SYRINGA-WIRLESS	OWNER-EXCLUDE	TRF1. TRF2. TRF3
TARIFF-CHANGE-NOTE		This user edit will require will require you to enter a note before you can change or add a tariff code. You will have to enter a note telling why you are changing/adding the tariff code, before you can change/add the tariff code. Fields 3-8 are blank In the example below you would be required to enter a note before changing or adding a tariff.
TARIFF-CHANGE-NOTE
TARIFF-SPECIAL-RATE	DISCOUNT01	This User Edit will allow you to charge an amount to one of the tariffs in the first group if you have at least one in both group 1 and group 2, or if in group 1 and no tariffs are entered in group 2. Between the from and to date, or the special date 2000-01-01. Field 3 = xxxxx.xxxxx.xxxxx (Enter Tariff Code(s) with a decimal between each). Group 1 Field 4 = xxxxx.xxxxx.xxxxx (Enter Tariff Code(s) with a decimal between each). Group 2 Field 5 = xxx.xx (Enter the Amount. Field 6 = YYYY-MM-DD.X.X (Enter the From Date, a decimal then Y, N to use special date 2000-01-01, a decimal then Y,N check the contract has not expired) Field 7 = YYYY-MM-DD (Enter the To Date) In the following Example; The first Tariff in group 1 tariff codes will be charged the amount if the phone number had at least one of the tariff codes in group 1 and group 2, with a start billing date between 2008-01-01 and 2008-01-30 or special date of 2000-01-01 and contract has not expired.
TARIFF-SPECIAL-RATE	DISCOUNT01	Field 2 = Discount01 Field 3 = QQ128.QQ136.QQ137 Field 4 = QQ138.QQ139.QQ140 Field 5 = 010.93 Field 6 = 2008-01-01.Y.Y Field 7 = 2008-01-30
TARIFF-SPECIAL-RATE	MAX01	This User Edit will allow you to charge a flat rate for a group of Tariff Codes. This User Edit correlates to the Salesman Commission / Operations Report – Level 2 Codes. Field 1 = TARIFF-SPECIAL-RATE Field 2 = MAX01 Field 3 = Enter a Code that relates to the Level 2 Code (Example: ADDONSTATE) Field 4 = Enter the Number of Tariffs at Regular Rate. Any quantity greater than this number triggers the Special Rate. (Example; enter 002 if the Special Rate is triggered with the 3rd Tariff Code.) Field 5 = Enter Total Cost for All xxx.xx then enter a decimal, then enter Y or N (Y= change only if it would save the customer $$), then enter (optional) A or O (A = Additional amount if over the Field 4 number of tariff codes or O = Only if regular amount is over the additional amount), then enter (optional) xxx.xx for amount to charge for overage. Example: 010.00.Y.A.002.00 This shows, $10.00 for First Quantity, then Y to change if it would save the customer money, then A for additional amount if over the Field 4 number of Tariff Codes, then $2.00 for the amount to charge for overage. Field 6 = Enter Which Tariff Code gets the Cost (Optional – If blank, then 1st one gets the Cost) Field 7 = Enter Optional Tariff Codes (xxxxx.xxxxx.xxxxx) They must also have one of these to Qualify. Field 8 = Leave Blank In the following Example; For Level 2 Code ‘ADDONSTATE’ will Charge a one time rate of $10.99 for all Tariff Codes in this Level 2 Code. And the Charge will be Displayed on Tariff Code ‘QQ1GA’. Note: The number entered into Field 4 = 4 and there are 8 Tariff Codes entered into this Level 2 Code. Therefore the number of Tariff Codes is More than 4 and the customer will receive a one time charge of $10.99 for all Tariff Codes.
TARIFF-SPECIAL-RATE	MAX01	Field 3 = ADDONSTATE Field 4 = 004 Field 5 = 010.99.Y Field 6 = QQ1GA
TARIFF-SPECIAL-RATE	TIERED-1	This User Edit will allow you to charge a rate based on the number of phones and what Tariff Codes each phone has. You will enter the Tariff Codes in Field 3 (Maximum of 3 Tariff Codes). In Field 4, you will enter the number of Phones for the account and what will be charged based on how many phones have the Tariff Code(s) entered in Field 3. Field 3 = xxxxx.xxxxx.xxxxx (Enter Tariff Code(s) with a decimal between each). Field 4 = xx,xxx.xx.xx,xxx.xx (Enter XX (Indicates the number of phones) followed by a decimal (.) then enter the dollar amount you want to charge for that number of phones (3 digit dollar . and 2 digit cents) followed by a Decimal then enter the next sequence xx,xxx.xx. Continue with the same sequence as needed in Fields 5 through 8. In the following Example; The first (01) phone within an Account that has Tariff Codes QQ128 or QQ136; will be charged $49.95. If a second phone (02) has either Tariff then that Phone will be charged $45.95. And if the Account as more than 2 phones (up to 99) those Phones will be charged $39.95.
TARIFF-SPECIAL-RATE	TIERED-1	Field 2 = TIERED-1 Field 3 = QQ128.QQ136. Field 4 = 01,049.95.02,045.95 Field 5 = 99,039.95.
TARIFFS-GRANDFATHER		This edit tells the system which tariff codes are grandfathered (People who have them can still have them, but they can no longer be assigned) Field 1: TARIFFS-GRANDFATHER Field 2: Fields 3 - 8: Grandfathered tariffs separated by a period. In the example below, the following charges are grandfathered. QQ033, QQ034, ABC, QQ036. Note: Make sure each charge takes up 5 spaces and has a period when entering. Note2: If you need to enter more than 18 tariff codes, you may have multiple listings of this user edit.
TARIFFS-GRANDFATHER		Field 3: QQ033.QQ034. ABC. Field 4: QQ036.
TARIFFTIE	CO and number or NPANXX	Allows you to tie tariff codes together where, if one is added, you will be given a message that others may need to be added. Also, if you remove one of the tariffs, you will be given a message that the others may need to be removed. The example below would cause only tariffs CWT, CWF and/or 3WC to be required if C01 is used.
TARIFFTIE	C01	CWT CWF 3WC
TARIFFTIE2	CO number or NPANXX	TARIFFTIE2 is used when you have multiple tariff codes that all need another tariff code. Example – You have 4 internet tariff codes that, if any of the 4 are selected, you also need a 2^nd tariff code of SPEC1. If you have PLAN1 or PLAN2 or PLAN3 or PLAN4, you want to make sure they also have SPEC1. With TARIFFTIE2, SPEC1 would be what we call the “mother” tariff code, and the “children” tariff codes would be the PLAN1, PLAN2, PLAN3, PLAN4. This edit makes sure a ‘Mother’ tariff is present if the customer has ‘Children’ tariffs and it checks for at least one “children” if a “mother” tariff code is found. Field 03: Mother Tariff Field 04-08: CHLD1.CHLD2.CHLD3. Note for Field 03: The Mother Tariff will need to be in the first five from the left. If the tariff is not five characters long, you will need to place leading spaces so the total length is 5 and left justified. Note for fields 04-08: Each tariff needs to fill five spaces and is separated by a period. If the tariff code is less than five characters long, place spaces to the left of the tariff so the total length is five characters, then place a period after each tariff. You will be able to get three tariffs with separating periods in Fields 04-08 with two spaces at the end of each line. TARIFFTIE is used to make sure that if they have one of the tariff codes, it checks for all the tariff codes you have specified. TARIFFTIE2 is used to make sure that you have at least one of the “children” tariff codes, but not necessarily all of the “children” tariff codes. In the example below, if the customer had the CATTL tariff, they would have to have one of the tariffs in Fields 04 or 05. If the customer has one of the tariffs in Fields 04 or 05, they have to have the CATTL tariff.
TARIFFTIE2	CO1	Field3: CATTL Field4: CATBU.CATHB.CATPL. Field5: CATRP.
TARIFFTIE3		We have added a new Edit to the Recurring Charges program in Service Order Entry. This edit will allow you to display a message if the customer's tariff contains what is in Field 3. The message will be displayed when the user clicks the update button on the Recurring charges detail screen. (B-04:B) Field 1: TARIFFTIE3 Field 2: Leave Blank Field 3: Search Characters (Max 5 long, Left justified) Field 4-8: The message to display Example, if the customer has tariff "ABCDE" and field 3 of TARIFFTIE3 contains "BCD" the message in fields 4 - 8 will be displayed. If the Customer has "ACBDE' the message would not be displayed.
TARIFFTIE3		Field 3: BCD Field 4: This message will be Field 5: displayed if the cu Field 6: stomer has "BCD" in Field 7: the tariff code being Field 8: g updated.
TOLLOWNCARRIERPULL		This is used to Create Toll Billing records from your own switch since you will not get CDR's from anyone. You need help from CTI to implement this. Field 3 has which CIC code to for look in switch records. The example below would cause all toll for carrier 0222 from your switch to be pulled out for all customers who are pic'd to 0222 as your own long distance carrier. A CDR is created to be billed as your own long distance.
TOLLOWNCARRIERPULL		0222
TOLLOWNCARRIERPULLSW		This user edit is used to pull our own toll carrier from our switch file. Field 03: Carrier to pull. Field 04-08: Leave blank. The example below will cause the carrier 5108 calls to be pulled.
TOLLOWNCARRIERPULLSW		5108
TOLLMAXCALLINGPLANS		This User Edit gives you the ability to Exclude certain Customers from the ‘Toll Maximum Report’. This could be used to Exclude Customers who have Unlimited Toll Calling Plans and you don’t care how much Toll they have used. To set this up: Field 1: TOLLMAXCALLINGPLANS Field 2: Leave Blank Field 3-8: Tariff Codes to Exclude (xxxxx.xxxxx.xxxxx) **Remember to key leading spaces if the Tariff Code is not 5 long. In the example below Tariff Codes ABCDE, XYZ and 123AB will be Excluded from the Toll Maximum Report.
TOLLMAXCALLINGPLANS		Field 3: ABCDE. XYZ.123AB Field 4: Field 5: Field 6: Field 7: Field 8:
TOLLPROCESSSOURCECPY		Use this to tell the system to copy your files for toll processing back to the source folder where it came from and then the date folder. Usually you will only use this for data from your own switch where the switch folks want access to see what you have processed. Field 2 will have the codes for type of toll to use on this. If this is not set up then the system copies it to drive & folder that you specify to copy the history to. In this example toll from your own switch 001 with 003 Special no translation would be compiled back to the source drive & folder of where it came from,
TOLLPROCESSSOURCECPY	001001003
TOLLREASONREQUIRED		Forces the user to select a Reason code. This will make sure there is a reason code selected if one is required when credit is being given on a toll call. We have also added this to the Non-Recurring Entry screen. The example below would require the user to select a Reason Code when giving credit on a toll call.
TOLLREASONREQUIRED
TOLL-REVENUE-SPREAD	Carrier Number	User Edit that will Allocate the Base Charge for your own Long Distance Calling Plans, based upon the Bill Minutes by Phone Number. For Example: If a plan cost is $12.00, today all the $12.00 goes to the INTER-State Revenue G/L Account. By Customer, if they have a 50/50 split of minutes, then $6.00 would go to INTRA-State Revenue G/L Account and $6.00 would go to INTER-State Revenue G/L Account. Or by Customer, if they have an 80/20 split of minutes, then $9.60 would go to INTRA-State Revenue G/L Account and $2.40 would go to INTER-State Revenue G/L Account. Or by Customer, if they have a 100/0 split of minutes, then $12.00 would go to INTRA-State Revenue G/L Account and $0.00 would go to INTER-State Revenue G/L Account. Field 2 = Carrier Number (Own Long Distance Carrier) Field 3 = INTRA-State Revenue G/L Account Number Field 4 = INTER-State Revenue G/L Account Number Field 5 = Special Revenue (Used for New Mexico ONLY) Field 6 through 8 = Leave Blank In the example below, Carrier Number 5108 will post INTRA-State to G/L Account Number 1111.11AA and INTER-State to G/L Account 2222.22EE and use G/L 3333.33PC for New Mexico Only.
TOLL-REVENUE-SPREAD	5108	1111.11AA 2222.22EE 3333.33PC
TREETRFALLOWEDTYPES	NPANXX	This edit is used to limit the types allowed in the tariff tree. If this edit is listed with the exchange, only the types listed in fields 3 - 8 will be visible in the tree. If more than 6 are needed, you may enter another edit with the same exchange. This allows for an unlimited number of types.
TREETRFALLOWEDTYPES	208555	Field 3 = LAND Field 4 = WIRELESS Field 5 = INTERNET Field 6 = CABLE
TROUBLEOLD		Uses the old Telco/3400 Trouble and Clearing codes with cascading options. The example below would cause Riata to use the old green screen trouble ticket format.
TROUBLEOLD
TROUBLETYPES		This is used if you would like to add multiple types (i.e. Internet, wireless, CATV) of trouble tickets. Field 01: TROUBLETYPES Field 02: Leave blank Fields 03-08: c-NAME (left justified) c = The one character code previously set up in #12 "Trouble /Clearing Codes" for the type of Trouble/Clearing code. NAME = The name you want displayed in the dropdown box where the user selects the trouble type. To set up the different Trouble types: START1 (main menu), enter #1 “Customer Information’ #19 ‘Riata’, #20 ‘Maintenance Items’, #20 ‘More Options’, and #12 'Trouble/Clearing Codes'. Enter the code you want to use then press cmd5. Enter a "T" in the index, press enter, then enter the Trouble codes needed. Press "Enter" twice to save. You will be taken back to the Index screen, enter a "C", for clearing codes then press enter. Enter the clearing codes. The example below will cause the trouble/clearing codes for wireless trouble type to be displayed.
TROUBLETYPES		W-Wireless
UBET-TOLL	CODE1	This user edit is for Uintah Basin EAS. You will enter the From LNP Npa-Nxx, LNP To Npa-Nxx and the code associated. When you have these setup the code will be updated in the call file being processed. The codes are A=X, B=NA, C=E, D=LWI, E=LWO, F=WLI, G=WLO, H=WTR, I=OWTR, J=AE, K=AA,CA, A*, L=EA, M=EE,IE,(etc.) Field 01: UBET-TOLL Field 02: CODE1 Field 03-08: NPANXX-NPA-NXX.A In the example below if the LNP From NPA-NXX = 435-822 and LNP To NPA-NXX =435-738 the code will be F.
UBET-TOLL	CODE1	435822-435738.F
USERDEFINEDSCREEN	Axx or Pxx xx=tab #	Allows you to put User Defined Fields on the tab you specify. Set up your User Defined Codes by using #4 'User Defined Fields'. (From the Start1 Menu; Select 1, 19, 20, 20, 4) A=Main Account Tabs P=Phone # or ID # Tabs B=Both This will determine where the fields are displayed. Then go to #15 'Edit Key Fields/Parameters' and set up which tab # you want the field to be displayed on. There is a maximum of 2 User Defined fields per screen. Field 02: Tab # to display field Fields 03 & 04: User Defined code Fields 05 through 08: Leave Blank The example below would cause the user defined code DIRADDR to show on the 2nd tab of the Phone # information which would be the Location tab.
USERDEFINEDSCREEN	P02	DIRADDR
USF-COST	1 Digit Company Number	We have created a new User Edit (USF-COST) that will give you the ability to identify the Base Cost to Calculate USF by Tariff Code. For Example: If you have a Tariff Code that cost $45.90 and $20.95 is NOT Charged USF and $24.95 is Charged USF you would setup the following new User Edit as shown. Field 2 = 1 Digit Company Number (1 through 9) Field 3 = Tariff Code (xxxxx) Field 4 = Field 4 = 6 digit Cost that is NOT Charged USF (enter dollar amount including decimal ‘xxxx.xx’) Field 5 = 6 digit Cost that IS Charged USF (enter dollar amount including decimal ‘xxxx.xx’) Field 6 = Enter CREDIT-TAXES if you want to Credit Federal & State Tax to Field #4. Field 7 & 8 = Leave Blank In the example below, Tariff Code ABC12 charge of $45.90 - $20.95 will NOT charge USF and $24.95 will Charge USF.
USF-COST	1	ABC12 0020.95 0024.95
VERISIGN-COMBINE-BNS	WITH-CALLING-NAME	This User Edit will automatically combine BNS changes with Calling Name Delivery changes. If this edit is present, the BNS process is called from the 911 processing that does the Calling Name processing. Field 1 - VERISIGN-COMBINE-BNS Field2 - WITH-CALLING-NAME Fields 3-8 Leave Blank The example below will cause BNS changes to be combined with Calling Name Delivery changes and put into one file.
VERISIGN-COMBINE-BNS	WITH-CALLING-NAME
VOICEMAIL-NPA-NXX		This user edit will let you set up the Voicemail NPA/NXX's based on the MIN. You will enter the MIN NPA/NXX in Field3 and the Voicemail NPA/NXX in Field 4. Field1: VOICEMAIL-NPA-NXX Field2: Leave Blank Field3: MIN NPA/NXX Field4: Voicemail NPA/NXX Multiples of this user edit are allowed. In the example below if the Voicemail NPA/NXX will be 222-123 for MIN NPA/NXX 222-345.
VOICEMAIL-NPA-NXX		Field3: 222345 Field4: 222123 Field5-8: Blank
VOICEMAIL-SETTINGS		This user edit will enable the drop menu item under the query button on the first screen of Riata inquiry. It therefore allows the user to query the voice mail server. Field1: VOICEMAIL-SETTINGS Field2: BLANK Field3: IP address of the voice mail server Field4: Port number of the voice mail server Field5: username Field6: password
VOICEMAIL-SETTINGS		192.168.1.1
		23
		xxusername
		xxpassword
WEB-SERVICE	WAIT-PROGRESS	This user edit stores the length of time to wait before checking to see if a web service process has completed. It also stores the number of times the system will check to see if the process has finished before it notifies the user the process is taking too long. FIELD1-WEB-SERVICE FIELD2-WAIT-PROGRESS FIELD3-Number in milliseconds to wait before checking again. FIELD4-Number of times to check before notifying. See Example:
WEB-SERVICE	WAIT-PROGRESS	3000
		10
WEBTROUBLETICKETS	PATH	Use this to enter the URL of the web trouble tickets. Use fields 3-8 and include the http:// or https://
WEBTROUBLETICKETS	PATH	http://216.83.73.200 :61110/TroubleTicket s/login.aspx
WELLSFARGOBATCH	PDFSAVEPATH	This user edit indicates the location where the PDF files will be saved when processing batch files from Wells Fargo. Fields 3-8 are added together to form the path.
WELLSFARGOBATCH	PDFSAVEPATH	C:\TESTING\HOLD\THIS
		\IS\A\REALLY\LONG\FO
		LDER\NAME\THAT\WOULD
		\NOT\BE\NORMALLY\USE
		BUT\FOR\THIS\EXAMPLE
		\WE\WILL\USE\IT
WIRELESS-OCN-CHANGE	0123	This User Edit will let you change certain OCN's to a new OCN in call type records. This will look at and change the Line portion of the phone number. If you have more original OCN's, set up an additional User Edit with fields 1 & 2 the same. Field 1- WIRELESS-OCN-CHANGE Field2- 0123 (This will be the new OCN) Field3- 1111.2222.3333.4444 (Original OCN's. Seperated by period) Fields 4-8 Same as Field 3. The following example will cause the Line portion of the phone number in a TCALL format record to 0123 if the original Line number was 1111, 2222, 3333 or 4444.
WIRELESS-OCN-CHANGE	0123	1111.2222.3333.4444
WRITEOFFGLMOVETO		This code is used to tell the system a range of G/L accounts to move to a particular g/l account. Such as Revenue and Expense accounts that you want moved to 1 g/l account such as Bad Debt Expense. This will leave g/l account number outside the range you set up just the way they are, such as A/P carriers, or surcharges. Field 2 is blank. Field 3 has the g/l account to move to. Fields 4-8 have the Account number ranges to move. Multiple records (up to a total of 19) are allowed. This example would move all g/l entries between account 5000.00 and 5999.99 and 7000.00 to 7010.00 to g/l account 5083.00
WRITEOFFGLMOVETO		5083.00 5000.00-5999.99 7010.00-7010.00
WRITEOFFGLMOVETO1		This code is used to tell the system the G/L account to move to a particular g/l account. Such as Revenue and Expense accounts that you want moved to a g/l account such as Bad Debt Expense. This will leave g/l account numbers not set up just the way they are. Field 2 is a 1 char company # or 'A' for all companies. Field 3 has the g/l account to move from. Field 4 has the g/l account to move to. Field 5 has the g/l account to move from. Field 6 has the g/l account to move to. Field 7 has the g/l account to move from. Field 8 has the g/l account to move to. Field 3 and 4 go together. Fields 5 and 6 go together. Fields 7 and 8 go together. Multiple records (up to a total of 33) are allowed. This example would move g/l accounts 5500.00 to 8000.00 and 4500.00 ABCDE to 6400.00 WO only in company 1.
WRITEOFFGLMOVETO1	1	Field3: 5500.00 Field4: 8000.00 Field5: 4500.00ABCDE Field6: 6400.00WO
ZIPCODES		This edit is used to load the Zip code list on the location tab on the Phone Number Information screen. Enter the Zip Code followed by a decimal then 2 character State abbreviation in Field #3, then in Field #4 enter the City associated with Field #3. In Field #5 enter the next Zip Code followed by a decimal then 2 character State abbreviation, then in Field #6 enter the City associated with Field #5. In Field #7 enter the next Zip Code followed by a decimal then 2 character State abbreviation, then in Field #8 enter the City associated with Field #7. You may enter as many ZIPCODES User Edits as you need. The list down box will automatically sort by Zip Code, regardless what order you enter them. Field 1 = ZIPCODES Field 2 = blank Field 3 = 99999.ST Field 4 = City Name Field 5 = 99999.ST Field 6 = City Name Field 7 = 99999.ST Field 8 = City Name The example below will display “83318 Burley”, “83347 Paul”, and “83350 Rupert” in the list box.
ZIPCODES		Field 3 = 83350.ID Field 4 = Rupert Field 5 = 83318.ID Field 6 = Burley Field 7 = 83347.ID Field 8 = Paul
400IP		This code tells Riata what the IP Address of the AS/400 is and if needed, what Drive to use for CTI Automation. Field 01= 400IP Field 02 = Leave Blank Field 03 = Enter AS/400 IP Address (Example; 192.168.0.1) Field 04 through 08 = continuation of IP if needed. If using any CTI automation programs, use an IP, not a name.
400IP		Field 3 = 192.168.0.1
911NOTSEND	TARIFF	Allows you to select 911 addresses not to send. You will be able to key in 6 different tariff codes to check for when pulling 911 addresses to send. Addresses dropped from the file will be printed on the B911NS list. Field 01: 911NOTSEND Field 02: Tariff Fields 03-08: Tariff codes to drop (Make sure that you enter leading spaces for the tariff codes). Once you have the codes set up, you will need to do the following: From the START1 (main menu), enter #1, then #18 'Pull E911/Call Name Delv Chngs'. When you run this, if you have '911NOTSEND' setup will check for the tariff codes you entered there. If you do not set it up, everything will run as it always has. The example below would cause the address information of any number with a recurring tariff code of NP (Not Published) to not be sent to 911.
911NOTSEND	TARIFF	NP
911ONDISCONNECT		This is used to send a 911 change on Service Order type 'D' (disconnect), not when removing a Phone #. Fields 02-08: Leave blank The example below would cause a 911 change to be sent when the Service Order is a Disconnect.
911ONDISCONNECT
911-POSTDIRECTIONAL		This edit is used to enable "Post Directional" field in the Phone Number information screen in Riata Service Order Entry on the Location Tab.
911-POSTDIRECTIONAL