Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
ATTACHMENT_ID |
|
VARCHAR(40) |
NO |
Name: Attachment ID Description: Indentifies the attachment for the completed task if appropriate. |
ATTACHMENT_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Attachment Type Description: The attachment type related to task. |
ATTACHMENT_DATA |
|
PICTURE |
YES |
Name: Attachment Data Description: The attachment stored in database. |
ATTACHMENT_FILE_DIRECTORY_NAME |
|
VARCHAR(254) |
YES |
Name: Attachment Directory Description: The directory where file is located. |
ATTACHMENT_DESC |
|
VARCHAR(30) |
YES |
Name: Attachment Description Description: The users description of attachment. |
FILE_TYPE_CD |
|
VARCHAR(4) |
YES |
Name: Type of File Description: Indicates type of file. Examples would be DOC, GIF, PNG, PDF, etc. |
ATTACHMENT_FILE_NAME |
|
VARCHAR(254) |
YES |
Name: Attachment File Name Description: The physical name of file. |
ADVANCE_ID |
|
VARCHAR(40) |
YES |
Name: Advance ID Description: The unique identifier for the advance. |
EXP_AUTH_ID |
|
VARCHAR(10) |
YES |
Name: Expense Authorization ID Description: The unique identifier for the expense authorization. |
EXP_RPT_ID |
|
VARCHAR(10) |
YES |
Name: Expense Report ID Description: The unique identifier for the expense report. |
EA_EXPENSE_ID |
|
NUMERIC(10, 0) |
YES |
Name: EA Expense ID Description: The unique identifier for expense on expense authorization. |
EA_ALLOCATION_ID |
|
NUMERIC(10, 0) |
YES |
Name: EA Allocation ID Description: The unique identifier for charge on expense authorization. |
ER_EXPENSE_ID |
|
NUMERIC(10, 0) |
YES |
Name: ER Expense ID Description: The unique identifier for expense on expense authorization. |
ER_ALLOCATION_ID |
|
NUMERIC(10, 0) |
YES |
Name: ER Allocation ID Description: The unique identifier for charge on expense report. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
|
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
BARCODE_ID |
|
VARCHAR(20) |
YES |
Name: BARCODE ID Description: This field contains the barcode ID printed on the attachment coversheet. |