| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| 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
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
PM10000.CURTRXAM
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISCAMNT |
numeric(19,5)
0.00
|
|
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Discount D...(more) Join Now
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
PM10000.DISCDATE
|
|
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date: ...(more) Join Now
|
PM10000.DUEDATE
|
|
|
| PORDNMBR |
char(21)
''
|
Purchase O...(more) Join Now
|
|
|
|
| TEN99AMNT |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| DISAMTAV |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| TRXDSCRN |
char(31)
''
|
Transactio...(more) Join Now
|
|
|
|
| UN1099AM |
numeric(19,5)
0.00
|
Unapplied ...(more) Join Now
|
|
|
|
| BKTPURAM |
numeric(19,5)
0.00
|
Backout Pu...(more) Join Now
|
|
|
|
| BKTFRTAM |
numeric(19,5)
0.00
|
Backout Fr...(more) Join Now
|
|
|
|
| BKTMSCAM |
numeric(19,5)
0.00
|
Backout Mi...(more) Join Now
|
|
|
|
| VOIDED |
tinyint
0
|
Voided TRU...(more) Join Now
|
CM20100.VOIDED
|
|
|
| HOLD |
tinyint
0
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| DINVPDOF |
datetime
'1/1/1900'
|
Date Invoi...(more) Join Now
|
PM20000.DINVPDOF
|
|
|
| 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
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(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
|
| PYENTTYP |
smallint
0
|
0 = Check,...(more) Join Now
|
|
|
|
| CARDNAME |
char(15)
''
|
Card Name:...(more) Join Now
|
PM10000.CARDNAME
|
|
|
| PRCHAMNT |
numeric(19,5)
0.00
|
Purchases ...(more) Join Now
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| MSCCHAMT |
numeric(19,5)
0.00
|
Misc Charg...(more) Join Now
|
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| TTLPYMTS |
numeric(19,5)
0.00
|
Total Paym...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
PM10000.PYMTRMID
|
|
SY033... more text available
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
PM10000.TAXSCHID
|
|
join ... more text available
|
| PCHSCHID |
char(15)
''
|
Purchase S...(more) Join Now
|
|
|
|
| FRTSCHID |
char(15)
''
|
Freight
...(more) Join Now
|
|
|
join ... more text available
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
|
|
join ... more text available
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| PRCTDISC |
smallint
0
|
Percent Di...(more) Join Now
|
|
|
|
| RETNAGAM |
numeric(19,5)
0.00
|
Retainage ...(more) Join Now
|
|
|
|
| VOIDPDATE |
datetime
'1/1/1900'
|
Void GL Po...(more) Join Now
|
CM20300.VOIDPDATE
|
|
|
| ICTRX |
tinyint
0
|
IC TRX: Im...(more) Join Now
|
|
|
|
| Tax_Date |
datetime
'1/1/1900'
|
Tax Date: ...(more) Join Now
|
|
|
|
| PRCHDATE |
datetime
'1/1/1900'
|
Purchase D...(more) Join Now
|
|
|
|
| CORRCTN |
tinyint
0
|
Correction...(more) Join Now
|
|
|
|
| SIMPLIFD |
tinyint
0
|
Simplified...(more) Join Now
|
|
|
|
| APLYWITH |
tinyint
0
|
Apply With...(more) Join Now
|
|
|
|
| Electronic |
tinyint
0
|
|
|
|
|
| ECTRX |
tinyint
0
|
EC Transac...(more) Join Now
|
|
|
|
| DocPrinted |
tinyint
0
|
DocPrinted...(more) Join Now
|
|
|
|
| TaxInvReqd |
tinyint
0
|
Tax Invoic...(more) Join Now
|
|
|
|
| VNDCHKNM |
char(65)
''
|
Vendor Che...(more) Join Now
|
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| VADCDTRO |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
|
| TEN99TYPE |
smallint
0
|
1099 Type:...(more) Join Now
|
|
|
|
| TEN99BOXNUMBER |
smallint
0
|
1099 Box N...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| PONUMBER |
char
''
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
|