Common use of FISCAL INVENTORY TEXT FILE Clause in Contracts

FISCAL INVENTORY TEXT FILE. The Contractor shall provide a monthly fiscal inventory of all CALNET 3 Services to CALNET 3 CMO on a text file. This text file shall include all Contractors CALNET 3 Froduct IDs. including ▇▇▇▇-each Customer's contracted services and features, that are being billed and provide volume of usage statistics and provide current quantities and service location information. For quantities that are usage based, the quantity reported shall represent the total usage for the month being reported. The text file shall represent a snapshot of the Contractor's total inventory on the last day of the Service Month being reported. o Made the following changes: • Page 68, section A.8.2, table C3MFISCINV o Made the following changes: Field Order Data Field Name Pop 1 Service Month R 2 CustomerCode R 3 Customer Name R 4 CALNET3 R 5 BAN R 6 SR Number R 57 Category R 68 Subcategory A 9 Section Number R 710 Service Type R 811 Feature Name R 912 Product ID R 103 TransportType A 144 ETN A 125 Circuit ID A 1316 WTN A 1418 Quantity R 19 Unit of Measure R 20 Contract NRC A 1521 Contract MRC A 1622 Special Pricing A 1724 Admin Fee Rate A • Page 69, section A.8.2, table C3MFISCINV (continued from previous page) o Made the following changes: Field Order Data Field Name Pop 1825 Customer MRC A 26 Customer Service Address 1 (A) A 27 Customer Service Address 2 (A) A 28 customer Service City (A) A 29 Customer Service State (A) A 30 Customer Service ZiP Code (A) A 31 Customer Service Address 1 (Z) A 32 Customer Service Address 2 (Z) A 33 Customer Service City (Z) A 34 Customer Service State (Z) A 35 CustomerService Zip Code (Z) A 19 Total Calls A 20 Total Calls Duration A 21 Total Usage A 22 Total contract MRC A 24 Total customer MRC A • Page 70, section A.8.3, table C3MSRVBILL o Made the following changes: Field Order Data Field Name Pop 1 Service Month R 2 Invoice Number R 3 Invoice Date R 4 CustomerCode R 5 CustomerName R 6 Customer Billing Name A 67 CALNET3 R 89 Subcategory A 910 BAN R 1011 BTN RA 1112 SR Number A 13 Section Number R 1214 Service Type R 1315 Feature Name R 1416 Product ID R 1517 TransportType A 1618 Circuit ID A 1719 WTN A 20 Node A 21 Customer Service Address 1 (A) A 22 CustomerService Address 2 (A) A 24 CustomerService State (A) A 25 CustomerService Zip Code (A) A 26 CustomerService Address 1 (Z) A 27 CustomerService Address 2 (Z) A 28 Customer Service Citv(Z) A 29 CustomerService State (Z) A 30 CustomerService Zip Code (Z) A 1831 Quantity R 1932 Unit of Measure R 2033 Service Quantity Changed A 2134 Change Date A 2236 Contract NRC A 2437 Contract MRC A 2538 Prorated Charge A Field Order Data Field Name Pop 2639 Special Pricing A 40 SP Trackina Number A 2741 Admin Fee Rate A 7842 Admin Fee A 43 Prorated Admin Fee A 2944 Customer MRC A 3045 Customer Prorated Charge A 3146 Total Contract NRC A 3247 Total Contract MRC A 3348 Total Prorated Charge A 3449 Total Admin Fee A 50 Total Prorated Admin Fee A 3551 Total Customer MRC A 3652 Total Customer Prorated Charge A 3753 Total Calls A 3854 Total Minutes A 3955 Adjustments A 4056 Adjustment Description A 4157 Total Taxes A 4258 Tax Index A 4359 Total Charge R • Page 72, section A.8.3.1, point #3, table C3MSRVTAX o Made the following changes: 2 Category R 3 Subcategory A 4 Invoice Number R 15 Tax Index R 26 Tax R 37 Tax Description R • Page 72, section A.8.5, first paragraph o Added the sentence: “Only services that are CALNET 3 contracted items (ie. CALNET 3 flag = “Y”) shall be included on this report.” • Page 73, section A.8.5, table C3MADMNFEE o Removed row 9 and renumbered row 10 to row 9 Field Order Data Field Name Pop 1 Service Month R 4 Subcategory A 5 Service Type R 6 Product ID R 7 Quantity R 8 Admin Fee Rate R 9 Admin Fee R 109 Total Admin Fee R • Page 74, section A.8.6, table C3MTRTKSLA o Made the following changes: Field Order Data Field Name Pop 1 Ticket NumberseSrvice Month AR 2 BAN R 3 bTn A 4 Invoice Number R 5 Invoice Date R 25 Category R 37 Subcategory A 48 Customer Code R 59 Customer Name R 10 SLA E 11 Service Type E 12 Feature Name E

FISCAL INVENTORY TEXT FILE. The Contractor shall provide a monthly fiscal inventory of all CALNET 3 Services to CALNET 3 CMO on a text file. This text file shall include all Contractors CALNET 3 Froduct IDs. Contractor's CALNE-T-3-P-robueMGs^ including ▇▇▇▇-each Customer's both each Customers contracted services and features, features that are being billed and provide volume of usage statistics and statisticsand provide current quantities and service location information. For quantities that are usage based, the quantity reported shall represent the total usage for the month being reported. The text file shall represent a snapshot of the Contractor's Contractor s total inventory on the last day of the Service Month being reported. o Made the following changes: • Page 68Pages 73-74 – Section B.8.2, section A.8.2, Point #3 data record table C3MFISCINV o Made the following changeschanges to page 73: Field Order Data Field Name Pop 1 Service Month R - 2 CustomerCode Customer Code R - 3 Customer Name R - 4 CALNET3 CALNET 3 R - 5 BAN R - 6 SR Number R - 57 Category R - 68 Subcategory A - 9 Section Number R - 710 Service Type R - 811 Feature Name R - 912 Product ID R 103 TransportType - 1013 Transport Type A 144 ETN - 1114 BTN A 125 - 1215 Circuit ID A - 1316 WTN WIN A - 1418 Quantity R 19 Unit of Measure R 20 Contract NRC A - 1521 Contract MRC A - o Made the following changes to table C3MFISCINV on page 74: 1622 Special Pricing A 1724 Admin Fee Rate A • Page 69, section A.8.2, table C3MFISCINV (continued from previous page) o Made the following changes: Field Order Data Field Name Pop 1825 Customer MRC A 26 Customer Service Address 1 (A) A 27 Customer Service Address 2 (A) A 28 customer Customer Service City (A) A 29 Customer Service State (A) A 30 Customer Service ZiP Zip Code (A) A 31 Customer Service Address 1 (Z) A 32 Customer Service Address 2 (Z) A 33 Customer Service City (Z) A 34 Customer Service State (Z) A 35 CustomerService Customer Service Zip Code (Z) A 19 Total Calls A 20 Total Calls Call Duration A 21 Total Usage A 22 Total contract Contract MRC A 23 Total Admin Fee A 24 Total customer Customer MRC A • Page 70Pages 75-76, section A.8.3Section B.8.3, table C3MSRVBILL o Made the following changeschanges to page 75: Field Order Data Field Name Pop 1 Service Month R 2 Invoice Number R 3 Invoice Date ▇▇▇▇ R 4 CustomerCode R 5 CustomerName Customer Name R 6 5 Customer Billing Name A 67 CALNET3 57 CALNET 3 R 78 Category R 89 Subcategory Sub category A 910 BAN R 1011 BTN RA 1112 A 11 12 SR Number A 13 Section Number R 1214 Service Type R 1315 Feature Name R 1416 4416 Product ID R 1517 TransportType Transport Type A 1618 1516 Circuit ID A 1719 4713 WTN A 18 20 Node A 21 Customer Service Address 1 (A1(A) A 22 CustomerService Customer Service Address 2 (A) A 23 Customer Service City (A) A 24 CustomerService Customer Service State (A) A 25 CustomerService Zip Customer ServiceZip Code (A) A 26 CustomerService Customer Service Address 1 (Z) A 27 CustomerService Customer Service Address 2 (Z) A 28 Customer Service Citv(ZCity (Z) A 29 CustomerService Customer Service State (Z) A 30 CustomerService Zip Customer ServiceZip Code (Z) A 1831 19 31 Quantity R 1932 2032 Unit of Measure R 2033 2133 Service Quantity Changed A 2134 2234 Change Date ▇▇▇▇ A 2236 2335 Change Type A 2436 Contract NRC A 2437 2537 Contract MRC A 2538 Prorated Charge A o Made the following changes to table C3MSRVBILL on page 76 (table continued from previous page): Field Order Data Field Name Pop 2639 2638 Prorated Charge A 27 39 Special Pricing A 40 SP Trackina Tracking Number A 2741 28 41 Admin Fee Rate A 7842 29 42 Admin Fee A 43 Prorated Admin Fee A 2944 30 44 Customer MRC A 3045 31 45 Customer Prorated Charge A 3146 3245 Total Contract NRC A 3247 Total Contract MRC A 3348 Total Prorated Charge A 3449 Total Admin Fee A 50 Total Prorated Admin Fee A 3551 Total Customer MRC A 3652 Total Customer Prorated Charge A 3753 Total Calls A 3854 Total Minutes A 3955 Adjustments A 4056 Adjustment Description A 4157 Total Taxes A 4258 Tax Index A 4359 Total Charge R • Page 72, section A.8.3.1, point #3, table C3MSRVTAX o Made the following changes: 2 Category R 3 Subcategory A 4 Invoice Number R 15 Tax Index R 26 Tax R 37 Tax Description R • Page 72, section A.8.5, first paragraph o Added the sentence: “Only services that are CALNET 3 contracted items (ie. CALNET 3 flag = “Y”) shall be included on this report.” • Page 73, section A.8.5, table C3MADMNFEE o Removed row 9 and renumbered row 10 to row 9 Field Order Data Field Name Pop 1 Service Month R 4 Subcategory A 5 Service Type R 6 Product ID R 7 Quantity R 8 Admin Fee Rate R 9 Admin Fee R 109 Total Admin Fee R • Page 74, section A.8.6, table C3MTRTKSLA o Made the following changes: Field Order Data Field Name Pop 1 Ticket NumberseSrvice Month AR 2 BAN R 3 bTn A 4 Invoice Number R 5 Invoice Date R 25 Category R 37 Subcategory A 48 Customer Code R 59 Customer Name R 10 SLA E 11 Service Type E 12 Feature Name EA