TABLE DETAIL REFERENCE: JournalEntry
(UK VERSION)
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False |
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYe C C | |
| RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
| IsAdjustment | -7 | BIT | 1 | True | True | True | False |
1
0
true
false
| |
| IsHomeCurrencyAdjustment | -7 | BIT | 1 | True | True | True | False |
1
0
true
false
| |
| IsAmountsEnteredInHomeCurrency | -7 | BIT | 1 | True | True | True | False |
1
0
true
false
| |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
