| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| PMVDMSGS |
binary(4)
0
|
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Source Doc...(more) Join Now
|
PM10000.DOCAMNT
|
|
|
| ORDOCAMT |
numeric(19,5)
0.00
|
Orig Docum...(more) Join Now
|
SOP10100.ORDOCAMT
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
PM10000.CURTRXAM
|
|
|
| ORCTRXAM |
numeric(19,5)
0.00
|
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
|
| DISCAMNT |
numeric(19,5)
0.00
|
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
PM10000.DISCDATE
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| TEN99AMNT |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| OR1099AM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10300.OR1099AM
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| ORWROFAM |
numeric(19,5)
0.00
|
|
|
|
|
| DISAMTAV |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| ODISAMTAV |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.ODISAMTAV
|
|
|
| PRCHAMNT |
numeric(19,5)
0.00
|
Purchases ...(more) Join Now
|
|
|
|
| OPURAMT |
numeric(19,5)
0.00
|
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Orig Trade...(more) Join Now
|
POP30300.ORTDISAM
|
|
|
| MSCCHAMT |
numeric(19,5)
0.00
|
Misc Charg...(more) Join Now
|
|
|
|
| ORMISCAMT |
numeric(19,5)
0.00
|
Orig Misc ...(more) Join Now
|
POP30300.ORMISCAMT
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| ORFRTAMT |
numeric(19,5)
0.00
|
Orig Freig...(more) Join Now
|
POP10300.ORFRTAMT
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Orig Tax A...(more) Join Now
|
POP10300.ORTAXAMT
|
|
|
| TTLPYMTS |
numeric(19,5)
0.00
|
Total Paym...(more) Join Now
|
|
|
|
| OTOTPAY |
numeric(19,5)
0.00
|
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
|
|
|
| CHANGED |
tinyint
0
|
Changed Se...(more) Join Now
|
POP10140.CHANGED
|
|
|
| PSTGSTUS |
smallint
0
|
Posting St...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| DEYDESCR |
char(31)
''
|
|
|
|
|
| VOIDDATE |
datetime
'1/1/1900'
|
Void Date ...(more) Join Now
|
CM20300.VOIDDATE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|