| SOPTYPE |
smallint
0
|
Values sto...(more) Join Now
|
|
|
|
| SOPNUMBE |
char(21)
''
|
The number...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
PA01301.LNITMSEQ
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
RM20101.CUSTNMBR
|
|
join ... more text available
|
| CUSTNAME |
char(65)
''
|
Customer N...(more) Join Now
|
RM10301.CUSTNAME
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
|
| RMDTYPAL |
smallint
0
|
RM Documen...(more) Join Now
|
|
|
|
| PYMTTYPE |
smallint
0
|
Payment Ty...(more) Join Now
|
|
|
|
| AMNTPAID |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
|
|
|
| OAMTPAID |
numeric(19,5)
0.00
|
Amount Rem...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| CHEKNMBR |
char(21)
''
|
Check Numb...(more) Join Now
|
PM10000.CHEKNMBR
|
|
|
| CARDNAME |
char(15)
''
|
Card Name:...(more) Join Now
|
PM10000.CARDNAME
|
|
|
| RCTNCCRD |
char(21)
''
|
Receipt Nu...(more) Join Now
|
RM10301.RCTNCCRD
|
|
|
| EXPNDATE |
datetime
'1/1/1900'
|
Expiration...(more) Join Now
|
CM20200.EXPNDATE
|
|
|
| AUTHCODE |
char(15)
''
|
Receipt Nu...(more) Join Now
|
SOP10103.AUTHCODE
|
|
|
| PYMNTDAT |
datetime
'1/1/1900'
|
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| CASHINDEX |
int
0
|
Cash Index...(more) Join Now
|
SOP10103.CASHINDEX
|
|
|
| DEPINDEX |
int
0
|
Deposits I...(more) Join Now
|
SOP10103.DEPINDEX
|
|
|
| DELETE1 |
tinyint
0
|
Delete: ...(more) Join Now
|
SOP10103.DELETE1
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
CM20000
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
CM20200.XCHGRATE
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
CM20200.DENXRATE
|
|
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
|
| RTCLCMTD |
smallint
0
|
Rate Calcu...(more) Join Now
|
CM20200.RTCLCMTD
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
CM20200.EXGTBLID
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
CM20200.EXCHDATE
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
CM20200.MCTRXSTT
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time see ...(more) Join Now
|
CM20200.TIME1
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|