| Table C_CommissionAmt |
| PRIMARY KEY | ||
|
C_CommissionAmt_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 | ||
|
C_CommissionRun_ID
NUMBER (10, 0) NOT NULL | C_CommissionRun | |
|
C_CommissionLine_ID
NUMBER (10, 0) NOT NULL | C_CommissionLine | |
|
ConvertedAmt
NUMBER default: 0 NOT NULL | Converted Actual Amt for Commission | |
|
ActualQty
NUMBER default: 0 NOT NULL | ||
|
CommissionAmt
NUMBER default: 0 NOT NULL | ||
FOREIGN KEY CComLine_CComAmt: C_CommissionLine_ID => C_CommissionLine CCommentRun_CCommissionAmt: C_CommissionRun_ID => C_CommissionRun | ||
REFERENCED BY C_CommissionDetail | ||