| PRIMARY KEY |
|
AD_PrintFormatItem_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
AD_PrintFormat_ID
NUMBER (10, 0) NOT NULL |
| AD_PrintFormat |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
PrintName
NVARCHAR2 (2000) |
| |
|
PrintNameSuffix
NVARCHAR2 (60) |
| |
|
IsPrinted
CHAR (1) default: 'Y' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSuppressNull
CHAR (1) default: 'N' CHECK ( IsSuppressNull in ( 'Y' , 'N' )) NOT NULL |
| |
|
PrintAreaType
CHAR (1) NOT NULL |
| |
|
SeqNo
NUMBER (10, 0) NOT NULL |
| |
|
PrintFormatType
CHAR (1) NOT NULL |
| |
|
AD_Column_ID
NUMBER (10, 0) |
| AD_Column |
|
AD_PrintFormatChild_ID
NUMBER (10, 0) |
| AD_PrintFormat |
|
AD_PrintGraph_ID
NUMBER (10, 0) |
| AD_PrintGraph |
|
IsRelativePosition
CHAR (1) default: 'Y' CHECK ( IsRelativePosition in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsNextLine
CHAR (1) default: 'Y' CHECK ( IsNextLine in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsNextPage
CHAR (1) default: 'N' CHECK ( IsNextPage in ( 'Y' , 'N' )) NOT NULL |
| |
|
BelowColumn
NUMBER (10, 0) |
| |
|
IsSetNLPosition
CHAR (1) default: 'N' CHECK ( IsSetNLPosition in ( 'Y' , 'N' )) NOT NULL |
| |
|
Xspace
NUMBER (10, 0) NOT NULL |
| |
|
Yspace
NUMBER (10, 0) NOT NULL |
| |
|
Xposition
NUMBER (10, 0) NOT NULL |
| |
|
Yposition
NUMBER (10, 0) NOT NULL |
| |
|
MaxWidth
NUMBER (10, 0) NOT NULL |
| |
|
IsHeightOneLine
CHAR (1) default: 'Y' CHECK ( IsHeightOneLine in ( 'Y' , 'N' )) NOT NULL |
| |
|
MaxHeight
NUMBER (10, 0) NOT NULL |
| |
|
IsFixedWidth
CHAR (1) default: 'N' CHECK ( IsFixedWidth in ( 'Y' , 'N' )) NOT NULL |
| |
|
FieldAlignmentType
CHAR (1) NOT NULL |
| |
|
LineAlignmentType
CHAR (1) NOT NULL |
| |
|
AD_PrintColor_ID
NUMBER (10, 0) |
| AD_PrintColor |
|
AD_PrintFont_ID
NUMBER (10, 0) |
| AD_PrintFont |
|
IsOrderBy
CHAR (1) default: 'N' CHECK ( IsOrderBy in ( 'Y' , 'N' )) NOT NULL |
| |
|
SortNo
NUMBER (10, 0) NOT NULL |
| |
|
IsGroupBy
CHAR (1) default: 'N' CHECK ( IsGroupBy in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPageBreak
CHAR (1) default: 'N' CHECK ( IsPageBreak in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSummarized
CHAR (1) default: 'N' CHECK ( IsSummarized in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsCounted
CHAR (1) default: 'N' CHECK ( IsCounted in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsAveraged
CHAR (1) default: 'N' CHECK ( IsAveraged in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsMinCalc
CHAR (1) default: 'N' CHECK ( IsMinCalc in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsMaxCalc
CHAR (1) default: 'N' CHECK ( IsMaxCalc in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsVarianceCalc
CHAR (1) default: 'N' CHECK ( IsVarianceCalc in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsDeviationCalc
CHAR (1) default: 'N' CHECK ( IsDeviationCalc in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsRunningTotal
CHAR (1) default: 'N' CHECK ( IsRunningTotal in ( 'Y' , 'N' )) NOT NULL |
| |
|
RunningTotalLines
NUMBER (10, 0) |
| |
|
ImageIsAttached
CHAR (1) default: 'N' CHECK ( ImageIsAttached in ( 'Y' , 'N' )) NOT NULL |
| |
|
ImageURL
NVARCHAR2 (120) |
| |
FOREIGN KEY
ADColumn_ADPrintFormatItem: AD_Column_ID => AD_Column
ADPrintColor_ADPrintFormatItem: AD_PrintColor_ID => AD_PrintColor
ADPrintFont_ADPrintFormatItem: AD_PrintFont_ID => AD_PrintFont
ADPrintFormat_PrintFormatChild: AD_PrintFormatChild_ID => AD_PrintFormat
ADPrintFormat_PrintFormatItem: AD_PrintFormat_ID => AD_PrintFormat
ADPrintGraph_PrintFormatItem: AD_PrintGraph_ID => AD_PrintGraph
|
REFERENCED BY
AD_PrintFormatItem_Trl,
AD_PrintGraph,
AD_PrintGraph,
AD_PrintGraph,
AD_PrintGraph,
AD_PrintGraph,
AD_PrintGraph |
|