Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CMRECNUM | Record Number |
Currency | 10 | View | |
SEQUENCE1 | Sequence |
Currency | 10 | View | |
JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
TRXDATE | TRX Date |
Date | 4 | View | |
SOURCDOC | Source Document 1= Invoice |
String | 12 | View | |
REFRENCE | Reference |
String | 32 | View | |
ACTNUMBR_1 | Account Number:Account_Segment_Pool1 |
String | 10 | View | |
ACTNUMBR_2 | Account Number:Account_Segment_Pool2 |
String | 10 | View | |
ACTNUMBR_3 | Account Number:Account_Segment_Pool3 |
String | 10 | View | |
ACTNUMBR_4 | Account Number:Account_Segment_Pool4 |
String | 10 | View | |
ACTNUMBR_5 | Account Number:Account_Segment_Pool5 |
String | 10 | View | |
ACTINDX | Account Index |
Long Integer | 4 | View | |
ACTDESCR | Account Description |
String | 52 | View | |
ACCATNUM | Account Category Number 1 = Cash |
Integer | 2 | View | |
ACCTTYPE | Account Type Field values: |
Integer | 2 | View | |
DEBITAMT | Debit Amount |
Currency | 10 | View | |
CRDTAMNT | Credit Amount |
Currency | 10 | View | |
DSCRIPTN | Description |
String | 32 | View |