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
:
