Module List > Module Company/System tables SY03100
You are currently viewing the COMPANY database.
Change

COMPANY..SY03100 Table Definition

(COMPANY..Credit Card Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PYBLGRBX smallint
0

RCVBGRBX smallint
0

CARDNAME char(15)
''

CBPAYBLE tinyint
0

CBRCVBLE tinyint
0

CKBKNUM1 char(15)
''

CKBKNUM2 char(15)
''

ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
VENDORID char(15)
''
Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
LSTUSRED char(15)
''
Last User ...(more) Join Now RM20101.LSTUSRED
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
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