GL50101 - Allocation Amounts Temporary
Query Builder
| 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 | |
| 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 | |
| INTERID | Intercompany ID |
String | 6 | View | |
| ACTNUMST | Account Number String |
String | 130 | View | |
| ACTDESCR | Account Description |
String | 52 | View | |
| CRDTAMNT | Credit Amount |
Currency | 10 | View | |
| DEBITAMT | Debit Amount |
Currency | 10 | View | |
| ORCRDAMT | Originating Credit Amount |
Currency | 10 | View | |
| ORDBTAMT | Originating Debit Amount |
Currency | 10 | View | |
| ORCTRNUM | Originating Control Number |
String | 22 | View | |
| ORDOCNUM | Originating Document Number |
String | 22 | View | |
| ORMSTRID | Originating Master ID |
String | 32 | View | |
| ORMSTRNM | Originating Master Name |
String | 66 | View | |
| ORTRXTYP | Originating TRX Type |
Integer | 2 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View |