Element | Element Name | Table or File | SQL or Focus |
---|---|---|---|
TN001 | NOTES FILE KEY | TNFILE | NOTES_KEY |
TN005 | NOTES STATUS P/A | TNFILE | ASSET_STATUS |
TN010 | ASSET NUMBER | TNFILE | ASSET_NUM |
TN015 | ASSET CATEGORY | TNFILE | NOTE_CATEGORY |
TN020 | NOTE SEQUENCE | TNFILE | NOTE_SEQ_NUM |
TN030 | NOTE TEXT LINE 1 | TNFILE | NOTE_TEXT_1 |
TN035 | NOTE TEXT LINE 2 | TNFILE | NOTE_TEXT_2 |
TN040 | NOTE TEXT LINE 3 | TNFILE | NOTE_TEXT_3 |
TN045 | NOTE TEXT LINE 4 | TNFILE | NOTE_TEXT_4 |
TN070 | LAST MAINT DATE | TNFILE | DT_LAST_ACTV |
TN071 | LAST MAINT DATE-6 | TNFILE | DT_LAST_ACTV_6 |
©2000 All Rights Reserved