| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
|
|
join ... more text available
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| DATE1 |
datetime
'1/1/1900'
|
The date o...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| APFRDCNM |
char(21)
''
|
Apply From...(more) Join Now
|
|
|
|
| ApplyFromGLPostDate |
datetime
'1/1/1900'
|
Apply From...(more) Join Now
|
|
|
|
| FROMCURR |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
|
| APFRMAPLYAMT |
numeric(19,5)
0.00
|
Functional...(more) Join Now
|
|
|
|
| APFRMDISCTAKEN |
numeric(19,5)
0.00
|
Functional...(more) Join Now
|
|
|
|
| APFRMDISCAVAIL |
numeric(19,5)
0.00
|
Functional...(more) Join Now
|
|
|
|
| APFRMWROFAMT |
numeric(19,5)
0.00
|
Functional...(more) Join Now
|
|
|
|
| ActualApplyToAmount |
numeric(19,5)
0.00
|
Actual App...(more) Join Now
|
|
|
|
| ActualDiscTakenAmount |
numeric(19,5)
0.00
|
Actual Dis...(more) Join Now
|
|
|
|
| ActualDiscAvailTaken |
numeric(19,5)
0.00
|
Actual Dis...(more) Join Now
|
|
|
|
| ActualWriteOffAmount |
numeric(19,5)
0.00
|
Actual Wri...(more) Join Now
|
|
|
|
| APFRMEXRATE |
numeric(19,7)
0.00
|
Apply From...(more) Join Now
|
|
|
|
| APFRMDENRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| APFRMRTCLCMETH |
smallint
0
|
Apply From...(more) Join Now
|
|
|
|
| APFRMMCTRXSTT |
smallint
0
|
Apply From...(more) Join Now
|
|
|
|
| APTVCHNM |
char(21)
''
|
Apply To V...(more) Join Now
|
|
|
|
| APTODCTY |
smallint
0
|
Apply To D...(more) Join Now
|
|
|
|
| APTODCNM |
char(21)
''
|
Apply To D...(more) Join Now
|
|
|
|
| APTODCDT |
datetime
'1/1/1900'
|
Apply To D...(more) Join Now
|
|
|
|
| ApplyToGLPostDate |
datetime
'1/1/1900'
|
Apply To G...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| APPLDAMT |
numeric(19,5)
0.00
|
Applied Am...(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
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
|
| ORDATKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
|
| ORWROFAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| APTOEXRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| APTODENRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| APTORTCLCMETH |
smallint
0
|
Rate Calcu...(more) Join Now
|
|
|
|
| APTOMCTRXSTT |
smallint
0
|
Transactio...(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
|
|
|
|
| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| POSTED |
tinyint
0
|
Posted: A...(more) Join Now
|
|
|
|
| TEN99AMNT |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| RLGANLOS |
numeric(19,5)
0.00
|
Realized G...(more) Join Now
|
|
|
|
| APYFRMRNDAMT |
numeric(19,5)
0.00
|
Round Amou...(more) Join Now
|
|
|
|
| APYTORNDAMT |
numeric(19,5)
0.00
|
Round Amou...(more) Join Now
|
|
|
|
| APYTORNDDISC |
numeric(19,5)
0.00
|
Round Disc...(more) Join Now
|
|
|
|
| OAPYFRMRNDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OAPYTORNDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OAPYTORNDDISC |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| Settled_Gain_CreditCurrT |
numeric(19,5)
0.00
|
Settled Ga...(more) Join Now
|
|
|
|
| Settled_Loss_CreditCurrT |
numeric(19,5)
0.00
|
Settled Lo...(more) Join Now
|
|
|
|
| Settled_Gain_DebitCurrTr |
numeric(19,5)
0.00
|
Settled Ga...(more) Join Now
|
|
|
|
| Settled_Loss_DebitCurrTr |
numeric(19,5)
0.00
|
Settled Lo...(more) Join Now
|
|
|
|
| Settled_Gain_DebitDiscAv |
numeric(19,5)
0.00
|
Settled Ga...(more) Join Now
|
|
|
|
| Settled_Loss_DebitDiscAv |
numeric(19,5)
0.00
|
Settled Lo...(more) Join Now
|
|
|
|
| Revaluation_Status |
smallint
0
|
Revaluatio...(more) Join Now
|
|
|
|
| Credit1099Amount |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| DEFTEN99TYPE |
smallint
0
|
Default 10...(more) Join Now
|
|
|
|
| DEFTEN99BOXNUMBER |
smallint
0
|
Default 10...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|