Table C_PaySchedule
PRIMARY KEY
C_PaySchedule_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_PaymentTerm_ID
NUMBER (10, 0)
NOT NULL
C_PaymentTerm
Percentage
NUMBER
NOT NULL
NetDays
NUMBER (10, 0)
NOT NULL
NetDay
CHAR (1)
GraceDays
NUMBER (10, 0)
NOT NULL
DiscountDays
NUMBER (10, 0)
NOT NULL
Discount
NUMBER
NOT NULL
IsValid
CHAR (1)
default: 'N'
CHECK ( IsValid in ( 'Y' , 'N' ))
NOT NULL
FOREIGN KEY
CPaymentTerm_CPaySchedule: C_PaymentTerm_ID =>
C_PaymentTerm
REFERENCED BY
C_InvoicePaySchedule