| PRIMARY KEY |
|
C_Charge_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) |
| |
|
ChargeAmt
NUMBER default: 0 NOT NULL |
| |
|
IsSameTax
CHAR (1) default: 'N' CHECK ( IsSameTax in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSameCurrency
CHAR (1) default: 'N' CHECK ( IsSameCurrency in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsTaxIncluded
CHAR (1) default: 'N' CHECK ( IsTaxIncluded in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_TaxCategory_ID
NUMBER (10, 0) |
| C_TaxCategory |
FOREIGN KEY
CTaxCategory_CCharge: C_TaxCategory_ID => C_TaxCategory
|
REFERENCED BY
C_BankStatementLine,
C_CashLine,
C_Charge_Acct,
C_Commission,
C_Invoice,
C_InvoiceLine,
C_Order,
C_OrderLine,
C_Payment,
I_BankStatement,
I_Payment,
M_InOut,
M_InventoryLine |
|