| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| VCHNUMWK |
char(17)
''
|
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
POP10100.VENDORID
|
|
join ... more text available
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
RM20102.DOCNUMBR
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
POP10110.DOCTYPE
|
|
|
| SOURCDOC |
char(11)
''
|
span style...(more) Join Now
|
GL30000.SOURCDOC
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Source Doc...(more) Join Now
|
TX30000.DOCAMNT
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
IV10201.DOCDATE
|
|
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| VADDCDPR |
char(15)
''
|
|
|
|
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
POP10100.PYMTRMID
|
|
SY033... more text available
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
POP10100.TAXSCHID
|
|
join ... more text available
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date T...(more) Join Now
|
POP10100.DUEDATE
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Discount D...(more) Join Now
|
SY03300.DSCDLRAM
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
|
| PRCHAMNT |
numeric(19,5)
0.00
|
Purchases ...(more) Join Now
|
|
|
|
| CHRGAMNT |
numeric(19,5)
0.00
|
Charge Amo...(more) Join Now
|
PM10000.CHRGAMNT
|
|
|
| CASHAMNT |
numeric(19,5)
0.00
|
Cash Amoun...(more) Join Now
|
RM50100.CASHAMNT
|
|
|
| CAMCBKID |
char(15)
''
|
|
|
|
|
| CDOCNMBR |
char(21)
''
|
|
|
|
|
| CAMTDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CAMPMTNM |
char(21)
''
|
|
|
|
|
| CHEKAMNT |
numeric(19,5)
0.00
|
Check Amou...(more) Join Now
|
RM10301.CHEKAMNT
|
|
|
| CHAMCBID |
char(15)
''
|
|
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CAMPYNBR |
char(21)
''
|
|
|
|
|
| CRCRDAMT |
numeric(19,5)
0.00
|
Credit Car...(more) Join Now
|
RM10301.CRCRDAMT
|
|
|
| CCAMPYNM |
char(21)
''
|
|
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| CARDNAME |
char(15)
''
|
|
|
|
|
| CCRCTNUM |
char(21)
''
|
|
|
|
|
| CRCARDDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
POP10100.CURNCYID
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| TRXDSCRN |
char(31)
''
|
|
|
|
|
| UN1099AM |
numeric(19,5)
0.00
|
Unapplied ...(more) Join Now
|
PM50100.UN1099AM
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
POP10100.TRDISAMT
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
VAT10302.TAXAMNT
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
SOP30200.FRTAMNT
|
|
|
| TEN99AMNT |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| MSCCHAMT |
numeric(19,5)
0.00
|
Misc Charg...(more) Join Now
|
|
|
|
| PORDNMBR |
char(21)
''
|
Purchase O...(more) Join Now
|
JC00701.PORDNMBR
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
POP10100.SHIPMTHD
|
|
join ... more text available
|
| DISAMTAV |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
POP30100.DISAMTAV
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
SOP30200.DISTKNAM
|
|
|
| APDSTKAM |
numeric(19,5)
0.00
|
Applied Di...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
RM50100.WROFAMNT
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
RM50104.CURTRXAM
|
|
|
| TXENGCLD |
tinyint
0
|
Tax Engine...(more) Join Now
|
|
|
|
| PMWRKMSG |
binary(4)
0
|
|
|
|
|
| PMDSTMSG |
binary(4)
0
|
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| PGRAMSBJ |
smallint
0
|
|
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| PPSTAXRT |
smallint
0
|
|
|
|
|
| POSTED |
tinyint
0
|
|
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
PM30600.VCHRNMBR
|
|
|
| CNTRLTYP |
smallint
0
|
|
|
|
|
| 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 Date The system date at the time the transaction iso psted
|
B3950340.POSTEDDT
|
|
|
| PTDUSRID |
char(15)
''
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| BKTFRTAM |
numeric(19,5)
0.00
|
Backout Fr...(more) Join Now
|
|
|
|
| BKTMSCAM |
numeric(19,5)
0.00
|
Backout Mi...(more) Join Now
|
|
|
|
| BKTPURAM |
numeric(19,5)
0.00
|
Backout Pu...(more) Join Now
|
|
|
|
| PCHSCHID |
char(15)
''
|
|
|
|
|
| FRTSCHID |
char(15)
''
|
Freight Sc...(more) Join Now
|
POP10100.FRTSCHID
|
|
join ... more text available
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
POP10100.MSCSCHID
|
|
join ... more text available
|
| PRINTED |
tinyint
0
|
|
|
|
|
| PRCTDISC |
smallint
0
|
|
|
|
|
| RETNAGAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|