Table C_Withholding
Description:
Withholding Certificate
PRIMARY KEY
C_Withholding_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_PaymentTerm_ID
NUMBER (10, 0)
NOT NULL
C_PaymentTerm
IsTaxWithholding
CHAR (1)
default: 'Y'
CHECK ( IsTaxWithholding in ( 'Y' , 'N' ))
NOT NULL
Withhold tax amount only
IsTaxProrated
CHAR (1)
default: 'N'
CHECK ( IsTaxProrated in ( 'Y' , 'N' ))
NOT NULL
If no Tax Withholding, do I subtract part of the tax too
IsPaidTo3Party
CHAR (1)
default: 'Y'
CHECK ( IsPaidTo3Party in ( 'Y' , 'N' ))
NOT NULL
Beneficiary
NUMBER (10, 0)
IsPercentWithholding
CHAR (1)
default: 'Y'
CHECK ( IsPercentWithholding in ( 'Y' , 'N' ))
NOT NULL
Percent
NUMBER
default: 0
FixAmt
NUMBER
default: 0
ThresholdMin
NUMBER
default: 0
ThresholdMax
NUMBER
default: 0
MinAmt
NUMBER
default: 0
MaxAmt
NUMBER
default: 0
FOREIGN KEY
CPaymentTerm_CWithholding: C_PaymentTerm_ID =>
C_PaymentTerm
REFERENCED BY
C_BP_Withholding
,
C_Withholding_Acct