Table C_PaymentTerm
Diagram I
PRIMARY KEY
C_PaymentTerm_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
Value
NVARCHAR2 (40)
NOT NULL
Name
NVARCHAR2 (60)
NOT NULL
Description
NVARCHAR2 (255)
DocumentNote
NVARCHAR2 (2000)
AfterDelivery
CHAR (1)
default: 'N'
CHECK ( AfterDelivery in ( 'Y' , 'N' ))
NOT NULL
IsDueFixed
CHAR (1)
default: 'N'
CHECK ( IsDueFixed in ( 'Y' , 'N' ))
NOT NULL
NetDays
NUMBER (10, 0)
NOT NULL
NetDay
CHAR (1)
GraceDays
NUMBER (10, 0)
NOT NULL
FixMonthCutoff
NUMBER (10, 0)
FixMonthDay
NUMBER (10, 0)
FixMonthOffset
NUMBER (10, 0)
DiscountDays
NUMBER (10, 0)
NOT NULL
Discount
NUMBER
NOT NULL
DiscountDays2
NUMBER (10, 0)
NOT NULL
Discount2
NUMBER
NOT NULL
IsNextBusinessDay
CHAR (1)
default: 'Y'
CHECK ( IsNextBusinessDay in ( 'Y' , 'N' ))
IsDefault
CHAR (1)
default: 'N'
CHECK ( IsDefault in ( 'Y' , 'N' ))
IsValid
CHAR (1)
default: 'N'
CHECK ( IsValid in ( 'Y' , 'N' ))
NOT NULL
Processing
CHAR (1)
REFERENCED BY
C_BPartner
,
C_BPartner
,
C_Invoice
,
C_Order
,
C_PaymentTerm_Trl
,
C_PaySchedule
,
C_Project
,
C_Withholding
,
I_Invoice
,
I_Order