| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
POP10110.DOCTYPE
|
|
|
| RMDTYPAL |
smallint
0
|
RM Documen...(more) Join Now
|
RM20102.RMDTYPAL
|
|
|
| RMDNUMWK |
char(17)
''
|
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
RM20102.DOCNUMBR
|
|
|
| DOCPRFIX |
char(3)
''
|
|
|
|
|
| DOCDESCR |
char(31)
''
|
Document D...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
IV10201.DOCDATE
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
POP10100.CUSTNMBR
|
|
join ... more text available
|
| CUSTNAME |
char(65)
''
|
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
UPR00102.ADRSCODE
|
|
|
| SLPRSNID |
char(15)
''
|
Salesperso...(more) Join Now
|
PA01101.SLPRSNID
|
|
join ... more text available
|
| SALSTERR |
char(15)
''
|
Sales Terr...(more) Join Now
|
|
|
join ... more text available
|
| COMAPPTO |
smallint
0
|
Commission...(more) Join Now
|
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| NCOMAMNT |
numeric(19,5)
0.00
|
Non-Commis...(more) Join Now
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
POP10100.SHIPMTHD
|
|
join ... more text available
|
| CSTPONBR |
char(21)
''
|
|
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
POP10100.TAXSCHID
|
|
join ... more text available
|
| SLSCHDID |
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
|
| COSTAMNT |
numeric(19,5)
0.00
|
Cost Amoun...(more) Join Now
|
|
|
|
| SLSAMNT |
numeric(19,5)
0.00
|
Sales Amou...(more) Join Now
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
POP10100.TRDISAMT
|
|
|
| TRDDISCT |
smallint
0
|
|
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
SOP30200.FRTAMNT
|
|
|
| MISCAMNT |
numeric(19,5)
0.00
|
Misc Amoun...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
VAT10302.TAXAMNT
|
|
|
| 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
|
|
|
|
| TXENGCLD |
tinyint
0
|
Tax Engine...(more) Join Now
|
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Source Doc...(more) Join Now
|
TX30000.DOCAMNT
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
|
|
|
|
| CASHAMNT |
numeric(19,5)
0.00
|
Cash Amoun...(more) Join Now
|
RM50100.CASHAMNT
|
|
|
| CBKIDCSH |
char(15)
''
|
|
|
|
|
| CASHDATE |
datetime
'1/1/1900'
|
|
|
|
|
| DCNUMCSH |
char(21)
''
|
|
|
|
|
| CHEKAMNT |
numeric(19,5)
0.00
|
Check Amou...(more) Join Now
|
RM10301.CHEKAMNT
|
|
|
| CBKIDCHK |
char(15)
''
|
|
|
|
|
| CBKIDCRD |
char(15)
''
|
|
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
|
|
|
|
| DCNUMCHK |
char(21)
''
|
|
|
|
|
| CRCRDAMT |
numeric(19,5)
0.00
|
Credit Car...(more) Join Now
|
RM10301.CRCRDAMT
|
|
|
| CRCRDNAM |
char(15)
''
|
|
|
|
|
| RCTNCCRD |
char(21)
''
|
|
|
|
|
| CRCARDDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
|
|
|
| DCNUMCRD |
char(21)
''
|
|
|
|
|
| DISCRTND |
numeric(19,5)
0.00
|
Discount R...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
SOP30200.DISTKNAM
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
SOP30200.DISAVTKN
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
RM50100.WROFAMNT
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
POP10100.PYMTRMID
|
|
SY033... more text available
|
| DISAVAMT |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
|
| 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
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
POP10100.DSCPCTAM
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
POP10100.CURNCYID
|
|
join ... more text available
|
| POSTED |
tinyint
0
|
|
|
|
|
| LSTEDTDT |
datetime
'1/1/1900'
|
Last Edit ...(more) Join Now
|
|
|
|
| LSTUSRED |
char(15)
''
|
|
|
|
|
| RMTREMSG |
binary(4)
0
|
|
|
|
|
| RMDPEMSG |
binary(4)
0
|
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
RM20101.GLPOSTDT
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Date The system date at the time the transaction iso psted
|
B3950340.POSTEDDT
|
|
|
| PTDUSRID |
char(15)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|