| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
|
|
join ... more text available
|
| RMDTYPAL |
smallint
0
|
RM Documen...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| CSHRCTYP |
smallint
0
|
Cash or Ch...(more) Join Now
|
|
|
|
| CHEKNMBR |
char(21)
''
|
Check Numb...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| CRCARDID |
char(15)
''
|
Credit Car...(more) Join Now
|
|
|
|
| DISAMCHK |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| NDSTAMNT |
numeric(19,5)
0.00
|
Non Distri...(more) Join Now
|
|
|
|
| TRXDSCRN |
char(31)
''
|
Transactio...(more) Join Now
|
|
|
|
| ONHOLD |
smallint
0
|
On Hold: E...(more) Join Now
|
|
|
|
| POSTED |
tinyint
0
|
Posted: En...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| LSTEDTDT |
datetime
'1/1/1900'
|
Last Edit ...(more) Join Now
|
|
|
|
| LSTUSRED |
char(15)
''
|
Last User ...(more) Join Now
|
|
|
|
| ORTRXAMT |
numeric(19,5)
0.00
|
Original T...(more) Join Now
|
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Writeoff A...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| RMTREMSG |
binary(4)
0
|
RM Trx Pos...(more) Join Now
|
|
|
|
| RMDPEMSG |
binary(4)
0
|
RM Dist Po...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| RMTREMSG2 |
binary(4)
0
|
RM TRX Pos...(more) Join Now
|
|
|
|
| PSTGSTUS |
smallint
0
|
Posting St...(more) Join Now
|
|
|
|
| EFTFLAG |
tinyint
0
|
EFT Flag T...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|