| PRIMARY KEY |
|
PA_Report_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| AD_Org |
|
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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
PA_ReportLineSet_ID
NUMBER (10, 0) NOT NULL |
| PA_ReportLineSet |
|
PA_ReportColumnSet_ID
NUMBER (10, 0) NOT NULL |
| PA_ReportColumnSet |
|
C_AcctSchema_ID
NUMBER (10, 0) NOT NULL |
| C_AcctSchema |
|
C_Calendar_ID
NUMBER (10, 0) NOT NULL |
| C_Calendar |
|
ListSources
CHAR (1) default: 'N' CHECK ( ListSources in ( 'Y' , 'N' )) NOT NULL |
| |
|
ListTrx
CHAR (1) default: 'N' CHECK ( ListTrx in ( 'Y' , 'N' )) NOT NULL |
| |
|
Processing
CHAR (1) NOT NULL |
| |
|
AD_PrintFormat_ID
NUMBER (10, 0) |
| AD_PrintFormat |
FOREIGN KEY
ADOrg_PAReport: AD_Org_ID => AD_Org
ADPrintFormat_PAReport: AD_PrintFormat_ID => AD_PrintFormat
CAcctSchema_PAReport: C_AcctSchema_ID => C_AcctSchema
CCalendar_PAReport: C_Calendar_ID => C_Calendar
PAReport_ColumnSet: PA_ReportColumnSet_ID => PA_ReportColumnSet
PAReport_LineSet: PA_ReportLineSet_ID => PA_ReportLineSet
|