| PRIMARY KEY |
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
|
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 |
| |
|
IsDiscountLineAmt
CHAR (1) default: 'Y' CHECK ( IsDiscountLineAmt in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Calendar_ID
NUMBER (10, 0) |
| C_Calendar |
|
C_AcctSchema1_ID
NUMBER (10, 0) |
| C_AcctSchema |
|
Acct2_Active
CHAR (1) default: 'N' CHECK ( Acct2_Active in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_AcctSchema2_ID
NUMBER (10, 0) |
| C_AcctSchema |
|
Acct3_Active
CHAR (1) default: 'N' CHECK ( Acct3_Active in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_AcctSchema3_ID
NUMBER (10, 0) |
| C_AcctSchema |
|
C_UOM_Volume_ID
NUMBER (10, 0) |
| C_UOM |
|
C_UOM_Weight_ID
NUMBER (10, 0) |
| C_UOM |
|
C_UOM_Length_ID
NUMBER (10, 0) |
| C_UOM |
|
C_UOM_Time_ID
NUMBER (10, 0) |
| C_UOM |
|
AD_Tree_Menu_ID
NUMBER (10, 0) |
| AD_Tree |
|
AD_Tree_Org_ID
NUMBER (10, 0) |
| AD_Tree |
|
AD_Tree_BPartner_ID
NUMBER (10, 0) |
| AD_Tree |
|
AD_Tree_Project_ID
NUMBER (10, 0) |
| AD_Tree |
|
AD_Tree_SalesRegion_ID
NUMBER (10, 0) |
| AD_Tree |
|
AD_Tree_Product_ID
NUMBER (10, 0) |
| AD_Tree |
|
M_ProductFreight_ID
NUMBER (10, 0) |
Default Product for Freightcosts
| |
|
C_BPartnerCashTrx_ID
NUMBER (10, 0) |
| |
|
M_PriceList_ID
NUMBER (10, 0) |
| M_PriceList |
|
PA_Goal_ID
NUMBER (10, 0) |
| PA_Goal |
|
KeepLogDays
NUMBER (10, 0) |
| |
FOREIGN KEY
ADClient_ADClientInfo: AD_Client_ID => AD_Client
ADTreeBPartner_ADClientInfo: AD_Tree_BPartner_ID => AD_Tree
ADTreeMenu_ADClientInfo: AD_Tree_Menu_ID => AD_Tree
ADTreeOrg_ADClientInfo: AD_Tree_Org_ID => AD_Tree
ADTreeProduct_ADClientInfo: AD_Tree_Product_ID => AD_Tree
ADTreeProject_ADClientInfo: AD_Tree_Project_ID => AD_Tree
ADTreeSalesReg_ADClientInfo: AD_Tree_SalesRegion_ID => AD_Tree
C_UOM_Length_AD_ClientInfo: C_UOM_Length_ID => C_UOM
C_UOM_Time_AD_ClientInfo: C_UOM_Time_ID => C_UOM
C_UOM_Volume_AD_ClientInfo: C_UOM_Volume_ID => C_UOM
C_UOM_Weight_AD_ClientInfo: C_UOM_Weight_ID => C_UOM
CAcctSchema1_ADClientInfo: C_AcctSchema1_ID => C_AcctSchema
CAcctSchema2_ADClientInfo: C_AcctSchema2_ID => C_AcctSchema
CAcctSchema3_ADClientInfo: C_AcctSchema3_ID => C_AcctSchema
CCalendar_ADClientInfo: C_Calendar_ID => C_Calendar
MPriceList_ADClientInfo: M_PriceList_ID => M_PriceList
PAGoal_AD_ClientInfo: PA_Goal_ID => PA_Goal
|