| USERID |
char
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Database_Operation |
smallint
|
|
|
|
|
| Database_Operation_Group |
int
|
|
|
|
|
| Database_Oper_GrSQNC |
smallint
|
|
|
|
|
| KEYNUMBR |
smallint
|
|
|
|
|
| BACHNUMB |
char
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char
|
Batch Sour...(more) Join Now
|
|
|
|
| PMNTNMBR |
char
|
|
|
|
|
| CHEKBKID |
char
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| DOCDATE |
datetime
|
The date a...(more) Join Now
|
RM20101.DOCDATE
|
|
|
| DOCNUMBR |
char
|
Document N...(more) Join Now
|
RM20102.DOCNUMBR
|
|
|
| APPLDAMT |
numeric
|
|
|
|
|
| CURTRXAM |
numeric
|
|
|
|
|
| CHEKTOTL |
numeric
|
|
|
|
|
| VENDORID |
char
|
Vendor ID:...(more) Join Now
|
PM00200.VENDORID
|
|
join ... more text available
|
| VENDNAME |
char
|
Vendor Nam...(more) Join Now
|
RVLPD026.VENDNAME
|
|
|
| COMMENT1 |
char
|
|
|
|
|
| ADDRESS1 |
char
|
|
|
|
|
| ADDRESS2 |
char
|
|
|
|
|
| ADDRESS3 |
char
|
|
|
|
|
| CITY |
char
|
|
|
|
|
| STATE |
char
|
|
|
|
|
| ZIPCODE |
char
|
|
|
|
|
| COUNTRY |
char
|
|
|
|
|
| VNDCHKNM |
char
|
|
|
|
|
| SOURCDOC |
char
|
span style...(more) Join Now
|
GL30000.SOURCDOC
|
|
|
| DISTKNAM |
numeric
|
Discount T...(more) Join Now
|
RM20102.DISTKNAM
|
|
|
| DISAMTAV |
numeric
|
Discount A...(more) Join Now
|
PTE30500.DISAMTAV
|
|
|
| WROFAMNT |
numeric
|
Write Off ...(more) Join Now
|
PA01101.WROFAMNT
|
|
|
| CURNCYID |
char
|
Currency I...(more) Join Now
|
RM20102.CURNCYID
|
|
join ... more text available
|
| VOIDED |
tinyint
|
|
|
|
|
| REPRNTED |
smallint
|
|
|
|
|
| GSTDSAMT |
numeric
|
GST Discou...(more) Join Now
|
ICJC9001.GSTDSAMT
|
|
|
| PGRAMSBJ |
smallint
|
|
|
|
|
| PPSTAXRT |
smallint
|
|
|
|
|
| PPSAMDED |
numeric
|
PPS Amount...(more) Join Now
|
ICJC9001.PPSAMDED
|
|
|
| LDOCRMTC |
smallint
|
|
|
|
|
| SDORMBY |
smallint
|
|
|
|
|
| KEYFIELD |
char
|
|
|
|
|
| AMWDSNBR |
char
|
|
|
|
|
| NOTEINDX |
numeric
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| VCHRNMBR |
char
|
Voucher Nu...(more) Join Now
|
PP100101.VCHRNMBR
|
|
|
| CNTRLTYP |
smallint
|
|
|
|
|
| DOCTYPE |
smallint
|
Document T...(more) Join Now
|
PM30300.DOCTYPE
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| MDFUSRID |
char
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
SOP10100.PSTGSTUS
|
|
|
| POSTEDDT |
datetime
|
Posted Date The system date at the time the transaction iso psted
|
B3950340.POSTEDDT
|
|
|
| PTDUSRID |
char
|
|
|
|
|
| PMWRKMSG |
binary
|
|
|
|
|
| PMWRKMS2 |
binary
|
|
|
|
|
| PMDSTMSG |
binary
|
|
|
|
|
| CHKCOMNT |
char
|
|
|
|
|
| PSTGDATE |
datetime
|
|
|
|
|
| STRGA255 |
char
|
|
|
|
|
| STRGB255 |
char
|
|
|
|
|
| SEPRMTNC |
tinyint
|
|
|
|
|
| STBOVRFL |
tinyint
|
|
|
|
|
| CTYSTZIP |
char
|
|
|
|
|
| TotDocAmt |
numeric
|
|
|
|
|
| TotAmtPaid |
numeric
|
|
|
|
|
| TotCrdAmt |
numeric
|
|
|
|
|
| TotalPaidTot |
numeric
|
|
|
|
|
| TotNegTot |
numeric
|
|
|
|
|
| TotCrdDocAmt |
numeric
|
|
|
|
|
| TotTotDocAmt |
numeric
|
|
|
|
|
| TotDiscTknAmt |
numeric
|
|
|
|
|
| TotWOAmt |
numeric
|
|
|
|
|
| TotPPSAmtDed |
numeric
|
|
|
|
|
| TotGSTDiscAmt |
numeric
|
|
|
|
|
| TotDiscTknTot |
numeric
|
|
|
|
|
| TotWOTot |
numeric
|
|
|
|
|
| Outstanding_Amount |
numeric
|
|
|
|
|
| Net_Paid_Amount |
numeric
|
|
|
|
|
| Electronic |
tinyint
|
|
|
|
|
| PONUMBER |
char
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| AMTINWDS |
text
|
|
|
|
|