The Customer Premises Equipment file is a CHILD of the Customer/Location file [telco.tps] and includes a sub-file or sub-child database for specific components that are related to equipment or systems.

---

Field Name                        Attributes

 

CompanyID               LONG

RefNum                  LONG [Reserved]

AccountNo               STRING(41)

Name                    STRING(72)

LocationOfEquip         STRING(40)

Vendor                  STRING(40)

Manufacturer            STRING(40)

TypeOfCPE               STRING(40)

ModelID                 STRING(40)

Description             STRING(80)

RoomNumber              STRING(20)

SoftwareRelease         STRING(20)

SoftwareDate            LONG

DateInstalled           LONG

AcquisitionType         STRING(20)

WarrantyExpiry          LONG

MaintenancePlanNo       STRING(20)

MaintenanceExpiry       LONG

ConfigurationDetail     STRING(256)

BackupPowerDevice       STRING(20)

RemoteAccessNumber      STRING(20)

RemoteAccessExt         STRING(20)

RemoteAccessLogin       STRING(20)

RemoteAccessPasscode    STRING(20)

CusSysID                LONG

CPEID                   LONG

IPAddress               STRING(255)

AgreementNo             LONG

PrimaryMSC              BYTE

OnMSC                   BYTE

MSContractStart         LONG

MSContractTerm          DECIMAL(3,0)

MSAnnualFee             DECIMAL(9,2)

CalcMSCEnd              BYTE

AssignedToResource      STRING(60)

NameOfPlan              STRING(40)

PaymentOption           STRING(20)

OptionPayment           DECIMAL(9,2)

Page url: http://www.telcomgr.com/index.html?cpe_file.htm