Module List >
Module BS tables
B3940101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..B3940101 Table Definition
(COMPANY..BSSI_GS_PM_1099)
Field Definitions:
What is the 'source' column?
| KEYSOURC |
char(41)
''
|
|
|
|
|
| CMPNYNAM |
char(65)
''
|
Company Na...(more) Join Now
|
POP10100.CMPNYNAM
|
|
|
| ADDRESS1 |
char(61)
''
|
Address 1 ...(more) Join Now
|
POP10100.ADDRESS1
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2 ...(more) Join Now
|
POP10100.ADDRESS2
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3 ...(more) Join Now
|
POP10100.ADDRESS3
|
|
|
| CITY |
char(35)
''
|
City City ...(more) Join Now
|
POP10100.CITY
|
|
|
| STATE |
char(29)
''
|
State Stat...(more) Join Now
|
POP10100.STATE
|
|
|
| ZIPCODE |
char(11)
''
|
ZipCode Th...(more) Join Now
|
POP10100.ZIPCODE
|
|
|
| TAXREGTN |
char(25)
''
|
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
POP10100.VENDORID
|
|
join ... more text available
|
| VNDCHKNM |
char(65)
''
|
|
|
|
|
| TEN99ADD1 |
char(61)
''
|
|
|
|
|
| TEN99ADD2 |
char(61)
''
|
|
|
|
|
| TEN99CITY |
char(35)
''
|
|
|
|
|
| TEN99STAT |
char(29)
''
|
|
|
|
|
| TEN99ZIP |
char(11)
''
|
|
|
|
|
| TXIDNMBR |
char(11)
''
|
|
|
|
|
| TEN99PFLD_1 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_2 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_3 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_4 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_5 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_6 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_7 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_8 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_9 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_10 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_11 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_12 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_13 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99PFLD_14 |
numeric(19,5)
0.00
|
|
|
|
|
| TEN99AYTD |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
Phone 1 Ph...(more) Join Now
|
POP10100.PHONE1
|
|
|
| BSSI_Facility_ID |
char(67)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|