| PRIMARY KEY |
|
C_Commission_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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
SalesRep
| C_BPartner |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
FrequencyType
CHAR (1) NOT NULL |
AD_Reference_ID=225 - Weekly,Monthly,Quarterly
| |
|
DocBasisType
CHAR (1) NOT NULL |
AD_Reference_ID=224 - Order, Invoice, Receipt
| |
|
ListDetails
CHAR (1) default: 'N' CHECK ( ListDetails in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Charge_ID
NUMBER (10, 0) NOT NULL |
| C_Charge |
|
DateLastRun
DATE |
| |
|
CreateFrom
CHAR (1) |
Create From another entity
| |
|
Processing
CHAR (1) |
| |
FOREIGN KEY
CBPartner_CCommission: C_BPartner_ID => C_BPartner
CCharge_CCommission: C_Charge_ID => C_Charge
CCurrency_CCommission: C_Currency_ID => C_Currency
|
REFERENCED BY
C_CommissionLine,
C_CommissionRun |
|