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
95 COLUMNS | TOP
812 | 01 | F0101 Address Book Master
14 INDICIES | TOP
812 | 01 | F0101 Address Book Master
1: Address # (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 1 |
AN8 |
Address Number |
Ascending |
2: Compressed Description
| Element | Alias | Description | Sequence |
|---|
| 1 |
DC |
Description - Compressed |
Ascending |
3: Long Address Number
| Element | Alias | Description | Sequence |
|---|
| 1 |
ALKY |
Long Address Number |
Ascending |
4: Tax Id
| Element | Alias | Description | Sequence |
|---|
| 1 |
TAX |
Tax ID |
Ascending |
5: Address Type 1 Desc Compresse
| Element | Alias | Description | Sequence |
|---|
| 1 |
AT1 |
Search Type |
Ascending |
| 2 |
DC |
Description - Compressed |
Ascending |
6: Reportin Codes 1n4 Desc Compr
| Element | Alias | Description | Sequence |
|---|
| 1 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 2 |
AC04 |
Category Code - Address Book 04 |
Ascending |
| 3 |
DC |
Description - Compressed |
Ascending |
7: Reporting Codes 1n3 Desc Comp
| Element | Alias | Description | Sequence |
|---|
| 1 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 2 |
AC03 |
Category Code - Address Book 03 |
Ascending |
| 3 |
DC |
Description - Compressed |
Ascending |
8: Reporting Codes 1n2 Desc Comp
| Element | Alias | Description | Sequence |
|---|
| 1 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 2 |
AC02 |
Category Code - Address Book 02 |
Ascending |
| 3 |
DC |
Description - Compressed |
Ascending |
9: Reporting Code 1 Desc Comp.
| Element | Alias | Description | Sequence |
|---|
| 1 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 2 |
DC |
Description - Compressed |
Ascending |
10: Add Type 1 Rpt Cde 1n4 DC
| Element | Alias | Description | Sequence |
|---|
| 1 |
AT1 |
Search Type |
Ascending |
| 2 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 3 |
AC04 |
Category Code - Address Book 04 |
Ascending |
| 4 |
DC |
Description - Compressed |
Ascending |
11: Add Type 1 Rpt Cde 1n3 DC
| Element | Alias | Description | Sequence |
|---|
| 1 |
AT1 |
Search Type |
Ascending |
| 2 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 3 |
AC03 |
Category Code - Address Book 03 |
Ascending |
| 4 |
DC |
Description - Compressed |
Ascending |
12: Add Type 1 Rpt Cde 1n2 DC
| Element | Alias | Description | Sequence |
|---|
| 1 |
AT1 |
Search Type |
Ascending |
| 2 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 3 |
AC02 |
Category Code - Address Book 02 |
Ascending |
| 4 |
DC |
Description - Compressed |
Ascending |
13: Add Type 1 Rpt Cde 1 Desc Com
| Element | Alias | Description | Sequence |
|---|
| 1 |
AT1 |
Search Type |
Ascending |
| 2 |
AC01 |
Category Code - Address Book 01 |
Ascending |
| 3 |
DC |
Description - Compressed |
Ascending |
14: Address No Tax Id2
| Element | Alias | Description | Sequence |
|---|
| 1 |
AN8 |
Address Number |
Ascending |
| 2 |
TX2 |
Tax ID - Additional - Individual |
Ascending |
ERPRef.com