| 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
|
POP10300.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
|
| GLHDRVAL |
binary(4)
|
|
|
|
|
| PERIODID |
smallint
|
Period ID:...(more) Join Now
|
GL20000.PERIODID
|
|
|
| OPENYEAR |
smallint
|
Open Year:...(more) Join Now
|
GL20000.OPENYEAR
|
|
|
| CLOSEDYR |
smallint
|
|
|
|
|
| HISTRX |
tinyint
|
|
|
|
|
| REVPRDID |
smallint
|
|
|
|
|
| REVYEAR |
smallint
|
|
|
|
|
| REVCLYR |
smallint
|
|
|
|
|
| REVHIST |
tinyint
|
|
|
|
|
| ICTRX |
tinyint
|
IC TRX: T...(more) Join Now
|
GL20000.ICTRX
|
|
|
| ERRSTATE |
int
|
Error Stat...(more) Join Now
|
SY00500.ERRSTATE
|
|
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
CM20200.USERDEF1
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
CM20200.USERDEF2
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| User_Defined_Dollar_1 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_2 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_3 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_4 |
numeric(19,5)
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| USRDAT03 |
datetime
|
|
|
|
|
| User_Defined_Date2_4 |
datetime
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|