Business License FAQ.

Data Dictionary

.
01/07/02                     NEMRC Customer Support                       Page 1
04:22 pm                       Filename: BLMAST                                 
                     File Description: License Master File                     

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    L_NUMBER       C      6     0   LICENSE NUMBER                          
   2    L_STATUS       C      1     0   STATUS ACTIVE OR INACTIVE               
   3    L_IN_OUT       C      1     0   INSIDE OR OUTSIDE                       
   4    L_LNAME        C     30     0   LAST NAME                               
   5    L_FNAME        C     20     0   FIRST NAME                              
   6    L_MINIT        C      1     0   MIDDLE INITIAL                          
   7    L_BNAME        C     50     0   BUSINESS NAME                           
   8    L_FEDID        C     10     0   FEDERAL ID                              
   9    L_SSN          C     11     0   SSN                                     
  10    L_CLASS        C      1     0   BUSINESS CLASS                          
  11    L_BADD1        C     40     0   BUSINESS ADDRESS 1                      
  12    L_BADD2        C     40     0   BUSINESS ADDRESS 2                      
  13    L_BCITY        C     25     0   BUSINESS CITY                           
  14    L_BSTATE       C     15     0   BUSINESS STATE                          
  15    L_BZIP         C     10     0   BUSINESS ZIP CODE                       
  16    L_MADD1        C     40     0   MAILING ADDRESS 1                       
  17    L_MADD2        C     40     0   MAILING ADDRESS 2                       
  18    L_MCITY        C     25     0   MAILING CITY                            
  19    L_MSTATE       C     15     0   MAILING STATE                           
  20    L_MZIP         C     10     0   MAILING ZIP CODE                        
  21    L_OWNERT       C      1     0   OWNER TYPE                              
  22    L_SIC          C      4     0   SIC CODE                                
  23    L_BASIS        C      1     0   BASIS OF LICENSE AMOUNT                 
  24    L_MINGROSS     N     12     0   MINIMUM GROSS                           
  25    L_TAX          N      9     2   TAX TO BE PAID                          
  26    L_PAYDATE      D      8     0   DATE PAID                               
  27    L_EXPIRE       D      8     0   EXPIRATION DATE                         
  28    L_FREQ         C      1     0   FREQUENCY OF BILLING                    
  29    L_FOUNDED      D      8     0   DATE BUSINESS WAS FOUNDED               
  30    L_CEASE        D      8     0   DATE OUT OF BUSINESS                    
  31    L_CONTRACT     C      6     0   CONTRACTORS LICENSE NUMBER              
  32    L_DOWNAREA     C      5     0   DOWNTOWN AREA                           
  33    L_DOWNTYPE     C      5     0   DOWNTOWN TYPE FIELD                     
  34    L_DELFLAG      C      1     0   DELFLAG                                 
  35    L_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  35 FIELDS =  470

                                Related Indexes                                

BLMAST  : L_DELFLAG+L_NUMBER                                                    
BLOWNE  : L_DELFLAG+L_LNAME                                                     
BLNAME  : L_DELFLAG+l_BNAME                                                     .
01/07/02                     NEMRC Customer Support                       Page 1
04:22 pm                       Filename: BLSICS                                 
                          File Description: Sics File                          

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    S_SIC          C      4     0   SIC CODE (BUSINESS CODE)                
   2    S_NAME         C     40     0   BUSINESS TYPE                           
   3    S_DELFLAG      C      1     0   "*" IF DELETED                          
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL   3 FIELDS =   45

                                Related Indexes                                

BLSICS  : S_DELFLAG+S_SIC                                                       .
01/07/02                     NEMRC Customer Support                       Page 1
04:22 pm                       Filename: BLSYST                                 
                         File Description: Install file                         

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    S_VERSION      C      4     0   VERSION OF DATA                         
   2    S_OLDVER       C      4     0   PREVIOUS INSTALLED VERSION OF THE MODULE
   3    S_UPVER        D      8     0   DATE THE NEW VERSION WAS INSTALLED      
   4    S_LICENSE      C      1     0   USE DEFAULT NEMRC LICENSE FORM?         
   5    S_RENEWAL      C      1     0   USE DEFAULT NEMRC RENEWAL FORM?         
   6    S_STATUS       C      9     0   BUSINESS STATUS VALIDATION STRING       
   7    S_STATUS1      C     12     0   BUSINESS STATUS CODE 1: USER-DEFINED    
   8    S_STATUS2      C     12     0   BUSINESS STATUS CODE 2: USER-DEFINED    
   9    S_STATUS3      C     12     0   BUSINESS STATUS CODE 3: USER-DEFINED    
  10    S_STATUS4      C     12     0   BUSINESS STATUS CODE 4: USER-DEFINED    
  11    S_STATUS5      C     12     0   BUSINESS STATUS CODE 5: USER-DEFINED    
  12    S_STATUS6      C     12     0   BUSINESS STATUS CODE 6: USER-DEFINED    
  13    S_STATUS7      C     12     0   BUSINESS STATUS CODE 7: USER-DEFINED    
  14    S_STATUS8      C     12     0   BUSINESS STATUS CODE 8: USER-DEFINED    
  15    S_STATUS9      C     12     0   BUSINESS STATUS CODE 9: USER-DEFINED    
  16    S_FREQ         C      9     0   BILLING FREQUENCY VALIDATION STRING     
  17    S_FREQ1        C     12     0   BILLING FREQUENCY CODE 1: USER-DEFINED  
  18    S_FREQ2        C     12     0   BILLING FREQUENCY CODE 2: USER-DEFINED  
  19    S_FREQ3        C     12     0   BILLING FREQUENCY CODE 3: USER-DEFINED  
  20    S_FREQ4        C     12     0   BILLING FREQUENCY CODE 4: USER-DEFINED  
  21    S_FREQ5        C     12     0   BILLING FREQUENCY CODE 5: USER-DEFINED  
  22    S_FREQ6        C     12     0   BILLING FREQUENCY CODE 6: USER-DEFINED  
  23    S_FREQ7        C     12     0   BILLING FREQUENCY CODE 7: USER-DEFINED  
  24    S_FREQ8        C     12     0   BILLING FREQUENCY CODE 8: USER-DEFINED  
  25    S_FREQ9        C     12     0   BILLING FREQUENCY CODE 9: USER-DEFINED  
  26    S_INOUT        C      9     0   IN/OUT CODE VALIDATION STRING           
  27    S_INOUT1       C     12     0   IN/OUT CODE 1: USER-DEFINED             
  28    S_INOUT2       C     12     0   IN/OUT CODE 2: USER-DEFINED             
  29    S_INOUT3       C     12     0   IN/OUT CODE 3: USER-DEFINED             
  30    S_INOUT4       C     12     0   IN/OUT CODE 4: USER-DEFINED             
  31    S_INOUT5       C     12     0   IN/OUT CODE 5: USER-DEFINED             
  32    S_INOUT6       C     12     0   IN/OUT CODE 6: USER-DEFINED             
  33    S_INOUT7       C     12     0   IN/OUT CODE 7: USER-DEFINED             
  34    S_INOUT8       C     12     0   IN/OUT CODE 8: USER-DEFINED             
  35    S_INOUT9       C     12     0   IN/OUT CODE 9: USER-DEFINED             
  36    S_F05          C     30     0   F5                                      
  37    S_F06          C     30     0   F6                                      
  38    S_F07          C     30     0   F7                                      
  39    S_F08          C     30     0   F8                                      
  40    S_F09          C     30     0   F9                                      
  41    S_F10          C     30     0   F10                                     
  42    S_F11          C     30     0   F11                                     
  43    S_F12          C     30     0   F12                                     
  44    S_LICOMM0      C     60     0   LICENSE COMMENT 0                       
  45    S_LICOMM1      C     60     0   LICENSE COMMENT 1                       
  46    S_LICOMM2      C     60     0   LICENSE COMMENT 2                       
  47    S_LICOMM3      C     60     0   LICENSE COMMENT 3                       
  48    S_LICOMM4      C     60     0   LICENSE COMMENT 4                       
  49    S_LICOMM5      C     60     0   LICENSE COMMENT 5                       
  50    S_LICOMM6      C     60     0   LICENSE COMMENT 6                       
  51    S_LICOMM7      C     60     0   LICENSE COMMENT 7                       
  52    S_LICOMM8      C     60     0   LICENSE COMMENT 8                       
  53    S_LICOMM9      C     60     0   LICENSE COMMENT 9                       
  54    S_RNCOMM0      C     60     0   RENEWAL COMMENT 0                       
  55    S_RNCOMM1      C     60     0   RENEWAL COMMENT 1                       
  56    S_RNCOMM2      C     60     0   RENEWAL COMMENT 2                       
  57    S_RNCOMM3      C     60     0   RENEWAL COMMENT 3                       
  58    S_RNCOMM4      C     60     0   RENEWAL COMMENT 4                       
  59    S_RNCOMM5      C     60     0   RENEWAL COMMENT 5                       
  60    S_RNCOMM6      C     60     0   RENEWAL COMMENT 6                       
  61    S_RNCOMM7      C     60     0   RENEWAL COMMENT 7                       
  62    S_RNCOMM8      C     60     0   RENEWAL COMMENT 8                       
  63    S_RNCOMM9      C     60     0   RENEWAL COMMENT 9                       
  64    S_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  64 FIELDS = 1811

        :                                                                                                               
							

© NEMRC 2010-2022 | Privacy Policy