Data Dictionary - Object Attachments

Table Name DA_UPLF_UPLOADFILE_DTL

Table Comment Object attachment

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

DA_UPLF_OUINSTANCE

int

NOT NULL

DA_UPLF_OUINSTANCE

Yes

No

DA_UPLF_COMPONENTNAME

varchar(20)

NOT NULL

DA_UPLF_COMPONENTNAME

Yes

No

DA_UPLF_FILENAME

char(50)

NOT NULL

DA_UPLF_FILENAME

Yes

No

DA_UPLF_UPLOADEDBY

char(30)

NOT NULL

DA_UPLF_UPLOADEDBY

No

No

DA_UPLF_UPLOADEDDATE

datetime

NOT NULL

DA_UPLF_UPLOADEDDATE

No

No

DA_UPLF_REFDOC_TYPE

char(40)

NULL

DA_UPLF_REFDOC_TYPE

No

No

DA_UPLF_REFDOC_NO

char(40)

NULL

DA_UPLF_REFDOC_NO

No

No

DA_UPLF_ACTIONIFEXISTS

char(5)

NULL

DA_UPLF_ACTIONIFEXISTS

No

No

DA_UPLF_SOURECPATH

char(255)

NOT NULL

DA_UPLF_SOURECPATH

No

No

DA_UPLF_FILESIZE

numeric(13,28)

NOT NULL

DA_UPLF_FILESIZE

No

No

DA_UPLF_AIRCRAFT_REG_NO

char(30)

NULL

DA_UPLF_AIRCRAFT_REG_NO

No

No

DA_UPLF_PARTNO

varchar(20)

NULL

DA_UPLF_PARTNO

No

No

DA_UPLF_SERIALNO

varchar(20)

NULL

DA_UPLF_SERIALNO

No

No

DA_UPLF_COMPONENTID

char(90)

NULL

DA_UPLF_COMPONENTID

No

No

DA_UPLF_SUPPLIER

char(16)

NULL

DA_UPLF_SUPPLIER

No

No

DA_UPLF_REPAIRAGENCY

char(16)

NULL

DA_UPLF_REPAIRAGENCY

No

No

DA_UPLF_DESTPATH

char(255)

NULL

DA_UPLF_DESTPATH

No

No

DA_UPLF_KEYCODE

char(2000)

NULL

DA_UPLF_KEYCODE

No

No

DA_UPLF_UNIQUEID

char(40)

NULL

DA_UPLF_UNIQUEID

No

No