| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| PMNTNMBR |
char(21)
''
|
Payment Nu...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
Applied Am...(more) Join Now
|
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
|
|
|
| CHEKTOTL |
numeric(19,5)
0.00
|
Check Tota...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| VENDNAME |
char(65)
''
|
Vendor Nam...(more) Join Now
|
|
|
|
| COMMENT1 |
char(31)
''
|
Comment1: ...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Address 1:...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2:...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3:...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: Chec...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
State: Che...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: ...(more) Join Now
|
|
|
|
| VNDCHKNM |
char(65)
''
|
Vendor Che...(more) Join Now
|
|
|
|
| SOURCDOC |
char(11)
''
|
Source Doc...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISAMTAV |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| VOIDED |
tinyint
0
|
Voided: C...(more) Join Now
|
|
|
|
| REPRNTED |
smallint
0
|
Reprinted:...(more) Join Now
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| PGRAMSBJ |
smallint
0
|
Percent Of...(more) Join Now
|
|
|
|
| PPSTAXRT |
smallint
0
|
PPS Tax Ra...(more) Join Now
|
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| LDOCRMTC |
smallint
0
|
List Docum...(more) Join Now
|
|
|
|
| SDORMBY |
smallint
0
|
Sort Docum...(more) Join Now
|
|
|
|
| KEYFIELD |
char(21)
''
|
Key Field:...(more) Join Now
|
|
|
|
| AMWDSNBR |
char(61)
''
|
Amount in ...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(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
|
| PSTGSTUS |
smallint
0
|
Posting St...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
|
| PMWRKMSG |
binary(4)
0
|
PM WORK Me...(more) Join Now
|
|
|
|
| PMWRKMS2 |
binary(4)
0
|
PM WORK
M...(more) Join Now
|
|
|
|
| PMDSTMSG |
binary(4)
0
|
PM Distrib...(more) Join Now
|
|
|
|
| CHKCOMNT |
char(61)
''
|
Check Comm...(more) Join Now
|
|
|
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| STRGA255 |
char(255)
''
|
String A 2...(more) Join Now
|
|
|
|
| STRGB255 |
char(255)
''
|
String B 2...(more) Join Now
|
|
|
|
| SEPRMTNC |
tinyint
0
|
Separate R...(more) Join Now
|
|
|
|
| STBOVRFL |
tinyint
0
|
Stub Overf...(more) Join Now
|
|
|
|
| CTYSTZIP |
char(47)
''
|
City-State...(more) Join Now
|
|
|
|
| TotDocAmt |
numeric(19,5)
0.00
|
Total Docu...(more) Join Now
|
|
|
|
| TotAmtPaid |
numeric(19,5)
0.00
|
Total Amou...(more) Join Now
|
|
|
|
| TotCrdAmt |
numeric(19,5)
0.00
|
Total Cred...(more) Join Now
|
|
|
|
| TotalPaidTot |
numeric(19,5)
0.00
|
Total Paid...(more) Join Now
|
|
|
|
| TotNegTot |
numeric(19,5)
0.00
|
Total Nega...(more) Join Now
|
|
|
|
| TotCrdDocAmt |
numeric(19,5)
0.00
|
Total Cred...(more) Join Now
|
|
|
|
| TotTotDocAmt |
numeric(19,5)
0.00
|
Total Tota...(more) Join Now
|
|
|
|
| TotDiscTknAmt |
numeric(19,5)
0.00
|
Total Disc...(more) Join Now
|
|
|
|
| TotWOAmt |
numeric(19,5)
0.00
|
Total Writ...(more) Join Now
|
|
|
|
| TotPPSAmtDed |
numeric(19,5)
0.00
|
Total PPS ...(more) Join Now
|
|
|
|
| TotGSTDiscAmt |
numeric(19,5)
0.00
|
Total GST ...(more) Join Now
|
|
|
|
| TotDiscTknTot |
numeric(19,5)
0.00
|
Total Disc...(more) Join Now
|
|
|
|
| TotWOTot |
numeric(19,5)
0.00
|
Total Writ...(more) Join Now
|
|
|
|
| Outstanding_Amount |
numeric(19,5)
0.00
|
Outstandin...(more) Join Now
|
|
|
|
| Net_Paid_Amount |
numeric(19,5)
0.00
|
Net Amount...(more) Join Now
|
|
|
|
| Electronic |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| PONUMBER |
char
''
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|
| CARDNAME |
char
''
|
|
|
|
|
| AMTINWDS |
text
|
Amount in ...(more) Join Now
|
|
|
|
| PYENTTYP |
smallint
''
|
|
|
|
|