Module List > Module AA tables AAG2001T
You are currently viewing the COMPANY database.
Change

COMPANY..AAG2001T Table Definition

(COMPANY..aa CM Deposit Diff TEMP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CMRECNUM numeric(19,5)
0.00
Record Num...(more) Join Now UPR30300.CMRECNUM
depositnumber char(21)
''

RcpType smallint
0

RCPTNMBR char(21)
''
Receipt Nu...(more) Join Now SEE30303.RCPTNMBR
RCPTAMT numeric(19,5)
0.00
Receipt Am...(more) Join Now
BANKNAME char(31)
''
This field...(more) Join Now ME142802.BANKNAME
BNKBRNCH char(21)
''
This field...(more) Join Now ME142802.BNKBRNCH
UPDATED tinyint
0

MARKED tinyint
0

receiptdate datetime
'1/1/1900'

Checkbook_Amount numeric(19,5)
0.00
Checkbook ...(more) Join Now
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now POP10100.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Field Type...(more) Join Now SVC35600.XCHGRATE
Receiving_Exchange_Rate numeric(19,7)
0.00
Receiving ...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now POP10100.EXCHDATE
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
RTCLCMTD smallint
0
Rate calcu...(more) Join Now MC40300.RTCLCMTD
EXPNDATE datetime
'1/1/1900'
Expiration...(more) Join Now POP10330.EXPNDATE
RLGANLOS numeric(19,5)
0.00
Realized G...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now POP10100.CURNCYID
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now POP10100.CURRNIDX
join ... more text available
DECPLCUR smallint
0
Number of ...(more) Join Now
ORIGAMT numeric(19,5)
0.00

DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now SVC35600.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now POP10100.MCTRXSTT
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