| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| PMNTNMBR |
char(21)
''
|
Payment Nu...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Document A...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| PYENTTYP |
smallint
0
|
|
|
|
|
| CHEKAMNT |
numeric(19,5)
0.00
|
Check Amou...(more) Join Now
|
|
|
|
| CARDNAME |
char(15)
''
|
Card Name:...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| TRXDSCRN |
char(31)
''
|
Transactio...(more) Join Now
|
|
|
|
| DISAMTAV |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Writeoff A...(more) Join Now
|
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
Applied Am...(more) Join Now
|
|
|
|
| PMWRKMSG |
binary(4)
0
|
PM WORK Me...(more) Join Now
|
|
|
|
| PMWRKMS2 |
binary(4)
0
|
PM WORK Me...(more) Join Now
|
|
|
|
| PMDSTMSG |
binary(4)
0
|
PM Distrib...(more) Join Now
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| PPSTAXRT |
smallint
0
|
PPS Tax Ra...(more) Join Now
|
|
|
|
| PGRAMSBJ |
smallint
0
|
Percent Of...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| MDFUSRID |
char(15)
''
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
|
| RETNAGAM |
numeric(19,5)
0.00
|
Retainage ...(more) Join Now
|
|
|
|
| Electronic |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| PONUMBER |
char
''
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|