Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
SQNCLINE | Sequence Line |
Currency | 10 | View | |
ACTINDX | Account Index |
Long Integer | 4 | View | |
OFFINDX | Offset Account Index |
Long Integer | 4 | View | |
TRXAMNT | TRX Amount |
Currency | 10 | View | |
GLLINMSG | GL LINE Messages |
Long Integer | 4 | View | |
GLLINMS2 | GL LINE Messages2 |
Long Integer | 4 | View | |
TRXDATE | TRX Date |
Date | 4 | View | |
ACCTTYPE | Account Type Field values: |
Integer | 2 | View | |
DSCRIPTN | Description |
String | 32 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
FUNCRIDX | Functional Currency Index |
Integer | 2 | View | |
ORIGAMT | Originating Amount |
Currency | 10 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CUSTNAME | Customer Name |
String | 66 | View | |
DOCDATE | Document Date |
Date | 4 | View |