| CUSTNMBR |
char(15)
''
|
Customer I...(more) Join Now
|
|
|
join ... more text available
|
| CPRCSTNM |
char(15)
''
|
Corporate ...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| CHEKNMBR |
char(21)
''
|
Check Numb...(more) Join Now
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| RMDTYPAL |
smallint
0
|
RM Documen...(more) Join Now
|
|
|
|
| CSHRCTYP |
smallint
0
|
Cash or Ch...(more) Join Now
|
|
|
|
| CBKIDCRD |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
|
| CBKIDCSH |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
|
| CBKIDCHK |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date: ...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| POSTDATE |
datetime
'1/1/1900'
|
Post Dateb...(more) Join Now
|
|
|
|
| PSTUSRID |
char(15)
''
|
Post User ...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| LSTEDTDT |
datetime
'1/1/1900'
|
Last Edit ...(more) Join Now
|
|
|
|
| LSTUSRED |
char(15)
''
|
Last User ...(more) Join Now
|
|
|
|
| ORTRXAMT |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
Current Tr...(more) Join Now
|
|
|
|
| SLSAMNT |
numeric(19,5)
0.00
|
Sales Amou...(more) Join Now
|
|
|
|
| COSTAMNT |
numeric(19,5)
0.00
|
Cost Amoun...(more) Join Now
|
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| MISCAMNT |
numeric(19,5)
0.00
|
Misc Amoun...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
|
| CASHAMNT |
numeric(19,5)
0.00
|
Cash Amoun...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISAVAMT |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISCRTND |
numeric(19,5)
0.00
|
Discount R...(more) Join Now
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Discount D...(more) Join Now
|
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| TRXDSCRN |
char(31)
''
|
Transactio...(more) Join Now
|
|
|
|
| CSPORNBR |
char(21)
''
|
Customer P...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
''
|
The salesp...(more) Join Now
|
|
|
join ... more text available
|
| SLSTERCD |
char(15)
''
|
Territory ...(more) Join Now
|
|
|
|
| DINVPDOF |
datetime
'1/1/1900'
|
Date Invoi...(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
|
|
|
|
| DELETE1 |
tinyint
0
|
Delete: ...(more) Join Now
|
|
|
|
| AGNGBUKT |
smallint
0
|
Aging buck...(more) Join Now
|
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
|
|
|
| VOIDDATE |
datetime
'1/1/1900'
|
Void Date...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
''
|
Sales Sche...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| SLSCHDID |
char(15)
''
|
Sales Sche...(more) Join Now
|
|
|
|
| FRTSCHID |
char(15)
''
|
Freight Sc...(more) Join Now
|
|
|
join ... more text available
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
|
|
join ... more text available
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| Tax_Date |
datetime
'1/1/1900'
|
Tax Date: ...(more) Join Now
|
|
|
|
| APLYWITH |
tinyint
0
|
Apply With...(more) Join Now
|
|
|
|
| SALEDATE |
datetime
'1/1/1900'
|
Sale Date:...(more) Join Now
|
|
|
|
| CORRCTN |
tinyint
0
|
Correction...(more) Join Now
|
|
|
|
| SIMPLIFD |
tinyint
0
|
Simplified...(more) Join Now
|
|
|
|
| Electronic |
tinyint
0
|
Electronic...(more) Join Now
|
|
|
|
| ECTRX |
tinyint
0
|
EC Transac...(more) Join Now
|
|
|
|
| BKTSLSAM |
numeric(19,5)
0.00
|
Backout Sa...(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
|
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| Factoring |
tinyint
0
|
....(more) Join Now
|
|
|
|
| DIRECTDEBIT |
tinyint
0
|
Direct Deb...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
|
|
|
| EFTFLAG |
tinyint
0
|
EFT Flag T...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|