Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.
Select SQL
Insert SQL
Update SQL
Create SQL
89 COLUMNS | TOP
910 | 09 | F0911R WF - Account Ledger Reconciliation
6 INDICIES | TOP
910 | 09 | F0911R WF - Account Ledger Reconciliation
1: Document Company Type + (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCT |
Document Type |
Ascending |
| 2 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 3 |
KCO |
Document Company |
Ascending |
| 4 |
DGJ |
Date - For G/L (and Voucher) - Julian |
Descending |
| 5 |
JELN |
Journal Entry Line Number |
Ascending |
| 6 |
LT |
Ledger Types |
Ascending |
| 7 |
EXTL |
Line Extension Code |
Ascending |
2: Account ID
| Element | Alias | Description | Sequence |
|---|
| 1 |
AID |
Account ID |
Ascending |
| 2 |
R1 |
Reference 1 - JE Voucher Invoice etc. |
Ascending |
3: RCND LT AID ICUT DCT DOC JELN+
| Element | Alias | Description | Sequence |
|---|
| 1 |
RCND |
Reconciled Code |
Ascending |
| 2 |
LT |
Ledger Types |
Ascending |
| 3 |
AID |
Account ID |
Ascending |
| 4 |
ICUT |
Batch Type |
Ascending |
| 5 |
DCT |
Document Type |
Ascending |
| 6 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 7 |
JELN |
Journal Entry Line Number |
Ascending |
| 8 |
ALT5 |
G/L Posting Code - Alternate 5 |
Ascending |
| 9 |
OFM |
Auto Offset Method (S Y or B) |
Ascending |
4: RCND LT DCT DOC SFX ICUT ICU+
| Element | Alias | Description | Sequence |
|---|
| 1 |
RCND |
Reconciled Code |
Ascending |
| 2 |
LT |
Ledger Types |
Ascending |
| 3 |
DCT |
Document Type |
Ascending |
| 4 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 5 |
SFX |
Document Pay Item |
Ascending |
| 6 |
ICUT |
Batch Type |
Ascending |
| 7 |
ICU |
Batch Number |
Ascending |
| 8 |
KCO |
Document Company |
Ascending |
| 9 |
SFXE |
Pay Item Extension Number |
Ascending |
| 10 |
RC5 |
File Line Identifier 5.0 |
Ascending |
5: AUDIT+ AID R3 DKC DGJ DOC+
| Element | Alias | Description | Sequence |
|---|
| 1 |
PID |
Program ID |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 3 |
JOBN |
Work Station ID |
Ascending |
| 4 |
UPMJ |
Date - Updated |
Ascending |
| 5 |
UPMT |
Time - Last Updated |
Ascending |
| 6 |
AID |
Account ID |
Ascending |
| 7 |
R3 |
Reference 3 - Account Reconciliation |
Ascending |
| 8 |
DKC |
Date - Check Cleared |
Ascending |
| 9 |
DGJ |
Date - For G/L (and Voucher) - Julian |
Ascending |
| 10 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 11 |
JELN |
Journal Entry Line Number |
Ascending |
6: RCND LT AID DCT DOC KCO ALT5
| Element | Alias | Description | Sequence |
|---|
| 1 |
RCND |
Reconciled Code |
Ascending |
| 2 |
LT |
Ledger Types |
Ascending |
| 3 |
AID |
Account ID |
Ascending |
| 4 |
DCT |
Document Type |
Ascending |
| 5 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 6 |
KCO |
Document Company |
Ascending |
| 7 |
ALT5 |
G/L Posting Code - Alternate 5 |
Ascending |
ERPRef.com