| PRIMARY KEY |
|
PA_ReportColumn_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 |
| |
|
PA_ReportColumnSet_ID
NUMBER (10, 0) NOT NULL |
| PA_ReportColumnSet |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
SeqNo
NUMBER (10, 0) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
IsPrinted
CHAR (1) default: 'Y' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
PostingType
CHAR (1) NOT NULL |
| |
|
GL_Budget_ID
NUMBER (10, 0) |
| GL_Budget |
|
ColumnType
CHAR (1) NOT NULL |
(R)elativePeriod - (C)alculation - (S)egmentElementType
| |
|
RelativePeriod
NUMBER (10, 0) |
| |
|
CurrencyType
CHAR (1) |
(S)ource or (A)ccounted
| |
|
CalculationType
CHAR (1) |
(A)dd - (S)ubtract - (P)ercentage
| |
|
AmountType
CHAR (2) |
(D)r only - (C)r only - (B)alance
| |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
IsAdHocConversion
CHAR (1) default: 'N' CHECK ( IsAdHocConversion in ( 'Y' , 'N' )) |
| |
|
Oper_1_ID
NUMBER (10, 0) |
| PA_ReportColumn |
|
Oper_2_ID
NUMBER (10, 0) |
| PA_ReportColumn |
|
ElementType
CHAR (2) |
| |
|
Org_ID
NUMBER (10, 0) |
| AD_Org |
|
C_ElementValue_ID
NUMBER (10, 0) |
| C_ElementValue |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
C_Location_ID
NUMBER (10, 0) |
| C_Location |
|
C_SalesRegion_ID
NUMBER (10, 0) |
| C_SalesRegion |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
FOREIGN KEY
ADOrg_PAReportColumn: Org_ID => AD_Org
CActivity_PAReportColumn: C_Activity_ID => C_Activity
CBPartner_PAReportColumn: C_BPartner_ID => C_BPartner
CCampaign_PAReportColumn: C_Campaign_ID => C_Campaign
CCurrency_PAReportColumn: C_Currency_ID => C_Currency
CElementValue_PAReportColumn: C_ElementValue_ID => C_ElementValue
CLocation_PAReportColumn: C_Location_ID => C_Location
CProject_PAReportColumn: C_Project_ID => C_Project
CSalesRegion_PAReportColumn: C_SalesRegion_ID => C_SalesRegion
GLBudget_PAReportColumn: GL_Budget_ID => GL_Budget
MProduct_PAReportColumn: M_Product_ID => M_Product
PAReportColumn_Oper1: Oper_1_ID => PA_ReportColumn
PAReportColumn_Oper2: Oper_2_ID => PA_ReportColumn
PAReportColumnSet_Column: PA_ReportColumnSet_ID => PA_ReportColumnSet
|
REFERENCED BY
PA_ReportColumn,
PA_ReportColumn |
|