Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
Navigation_ID | Navigation List ID |
String | 16 | View | |
Table_Number | Table Number |
Integer | 2 | View | |
Field_Number | Field Number |
Integer | 2 | View | |
Navigation_Field_Name | Navigation List Field Name |
String | 82 | View | |
Navigation_Display_Name | Navigation Display Name |
String | 82 | View | |
Default_Display | Default Display |
Boolean | 2 | View | |
Display_Field | Display Field |
Boolean | 2 | View | |
Preview_Field | Preview Field |
Boolean | 2 | View | |
FIELDTYPE | Field Type |
Long Integer | 4 | View | |
NAV_Field_String_Format | Navigation List Field String Format |
Integer | 2 | View | |
String_Mask | String Mask |
String | 32 | View | |
DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
Show_Currency_Symbol | Show Currency Symbol |
Boolean | 2 | View | |
Show_Percentage_Symbol | Show Percentage Symbol |
Boolean | 2 | View | |
Show_Thousands_Separator | Show Thousands Separator |
Boolean | 2 | View | |
Display_As_Account | Display As Account |
Boolean | 2 | View | |
TBLPHYSNM | Table Physical Name |
String | 52 | View | |
Display_Blank_Dates | Display Blank Dates |
Boolean | 2 | View | |
Display_As_Negative | Display As Negative |
Boolean | 2 | View | |
Display_As_Note | Display As Note |
Boolean | 2 | View | |
Negative_Table | Negative Table |
Integer | 2 | View | |
Negative_Field | Negative Field |
Integer | 2 | View | |
Decimal_Table | Decimal Table |
Integer | 2 | View | |
Decimal_Field | Decimal Field |
Integer | 2 | View | |
Decimal_Places_Method | Decimal Places Method |
Integer | 2 | View | |
TXTFIELD | Text Field |
Text | 2 | View |