| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| JRNENTRY |
int
|
Journal En...(more) Join Now
|
GL20000.JRNENTRY
|
|
|
| RCTRXSEQ |
numeric(19,5)
|
Recurring ...(more) Join Now
|
GL20000.RCTRXSEQ
|
|
|
| SOURCDOC |
char(11)
|
Field values:
1= Invoice
2= Finance Charge
3= Miscellaneous Charges
4= Return
5= Credit Memo
|
PP000001.SOURCDOC
|
|
|
| REFRENCE |
char(31)
|
Reference:...(more) Join Now
|
POP30300.REFRENCE
|
|
|
| TRXDATE |
datetime
|
TrxDate Transaction Date used when the transaction was posted
|
CM20502.TRXDATE
|
|
|
| RVRSNGDT |
datetime
|
|
|
|
|
| RCRNGTRX |
tinyint
|
|
|
|
|
| BALFRCLC |
smallint
|
|
|
|
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
RM10301.PSTGSTUS
|
|
|
| LASTUSER |
char(15)
|
Last User:...(more) Join Now
|
GL20000.LASTUSER
|
|
|
| LSTDTEDT |
datetime
|
Last Date ...(more) Join Now
|
GL20000.LSTDTEDT
|
|
|
| USWHPSTD |
char(15)
|
User Who P...(more) Join Now
|
GL20000.USWHPSTD
|
|
|
| TRXTYPE |
smallint
|
|
|
|
|
| SQNCLINE |
numeric(19,5)
|
Sequence L...(more) Join Now
|
VAT10302.SQNCLINE
|
|
|
| GLHDRMSG |
binary(4)
|
|
|
|
|
| GLHDRMS2 |
binary(4)
|
|
|
|
|
| TRXSORCE |
char(13)
|
Transactio...(more) Join Now
|
|
|
|
| SERIES |
smallint
|
Series: I...(more) Join Now
|
SY00500.SERIES
|
|
|
| ORTRXTYP |
smallint
|
Originatin...(more) Join Now
|
GL20000.ORTRXTYP
|
|
|
| ORCTRNUM |
char(21)
|
Originatin...(more) Join Now
|
GL20000.ORCTRNUM
|
|
|
| ORMSTRID |
char(31)
|
Originatin...(more) Join Now
|
GL20000.ORMSTRID
|
|
|
| ORMSTRNM |
char(65)
|
Originatin...(more) Join Now
|
GL20000.ORMSTRNM
|
|
|
| ORDOCNUM |
char(21)
|
Originatin...(more) Join Now
|
GL20000.ORDOCNUM
|
|
|
| ORPSTDDT |
datetime
|
Originatio...(more) Join Now
|
GL20000.ORPSTDDT
|
|
|
| ORTRXSRC |
char(13)
0
|
Originatin...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
|
Currency I...(more) Join Now
|
CM20000
|
|
join ... more text available
|
| NOTEINDX |
numeric(19,5)
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_CB6 |
tinyint
|
|
|
|
|
| WSReserved_CB7 |
tinyint
|
|
|
|
|
| WSReserved_CB10 |
tinyint
|
|
|
|
|
| OPENYEAR |
smallint
|
Open Year:...(more) Join Now
|
GL20000.OPENYEAR
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|