| PRIMARY KEY |
|
C_AcctSchema_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| 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) |
| |
|
GAAP
CHAR (2) NOT NULL |
| |
|
IsAccrual
CHAR (1) default: 'Y' CHECK ( IsAccrual in ( 'Y' , 'N' )) NOT NULL |
| |
|
CostingMethod
CHAR (1) NOT NULL |
| |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
AutoPeriodControl
CHAR (1) default: 'N' CHECK ( AutoPeriodControl in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Period_ID
NUMBER (10, 0) |
| C_Period |
|
Period_OpenHistory
NUMBER (10, 0) |
| |
|
Period_OpenFuture
NUMBER (10, 0) |
| |
|
Separator
CHAR (1) NOT NULL |
| |
|
HasAlias
CHAR (1) default: 'Y' CHECK ( HasAlias in ( 'Y' , 'N' )) NOT NULL |
| |
|
HasCombination
CHAR (1) default: 'Y' CHECK ( HasCombination in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsTradeDiscountPosted
CHAR (1) default: 'N' CHECK ( IsTradeDiscountPosted in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsDiscountCorrectsTax
CHAR (1) default: 'N' CHECK ( IsDiscountCorrectsTax in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
AD_Client_C_AcctSchema: AD_Client_ID => AD_Client
AD_Org_C_AcctSchema: AD_Org_ID => AD_Org
C_Currency_C_AcctSchema: C_Currency_ID => C_Currency
CPeriod_CAcctSchema: C_Period_ID => C_Period
|
REFERENCED BY
A_Asset_Acct,
A_Asset_Change_Amt,
A_Asset_Group_Acct,
AD_ClientInfo,
AD_ClientInfo,
AD_ClientInfo,
C_AcctSchema_Default,
C_AcctSchema_Element,
C_AcctSchema_GL,
C_BankAccount_Acct,
C_BP_Customer_Acct,
C_BP_Employee_Acct,
C_BP_Group_Acct,
C_BP_Vendor_Acct,
C_CashBook_Acct,
C_Charge_Acct,
C_Currency_Acct,
C_InterOrg_Acct,
C_Project_Acct,
C_RevenueRecognition_Plan,
C_Tax_Acct,
C_ValidCombination,
C_Withholding_Acct,
Fact_Acct,
Fact_Acct_Balance,
GL_Journal,
I_GLJournal,
M_Product_Acct,
M_Product_Category_Acct,
M_Product_Costing,
M_Warehouse_Acct,
PA_Report,
R_ResourcePlanCost |
|