Module List > Module BS tables B3940301
You are currently viewing the COMPANY database.
Change

COMPANY..B3940301 Table Definition

(COMPANY..BSSI_GS_PM_1099_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3