| Table C_CommissionDetail |
| PRIMARY KEY | ||
|
C_CommissionDetail_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_CommissionAmt_ID
NUMBER (10, 0) NOT NULL | C_CommissionAmt | |
|
Reference
NVARCHAR2 (60) | ||
|
C_OrderLine_ID
NUMBER (10, 0) | C_OrderLine | |
|
C_InvoiceLine_ID
NUMBER (10, 0) | C_InvoiceLine | |
|
Info
NVARCHAR2 (60) | ||
|
C_Currency_ID
NUMBER (10, 0) NOT NULL | C_Currency | |
|
ActualAmt
NUMBER default: 0 NOT NULL | ||
|
ConvertedAmt
NUMBER default: 0 NOT NULL | ||
|
ActualQty
NUMBER default: 0 NOT NULL | ||
FOREIGN KEY CCommissionAmt_CComDetail: C_CommissionAmt_ID => C_CommissionAmt CCurrency_CCommissionDetail: C_Currency_ID => C_Currency CInvoiceLine_CCommissionDet: C_InvoiceLine_ID => C_InvoiceLine COrderLine_CCommissionDetail: C_OrderLine_ID => C_OrderLine | ||