Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
date_driven |
VARCHAR2 |
3 |
|
|
|
|
Date driven |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
days_till_1st_payment |
NUMBER |
|
39 |
0 |
|
|
Days until first payment |
days_until_due |
NUMBER |
|
39 |
0 |
|
|
Days until net due |
discount_days |
NUMBER |
|
39 |
0 |
|
|
Days until discount expires |
frequency_id |
VARCHAR2 |
20 |
|
|
|
|
Frequency ID |
installment_count |
NUMBER |
|
39 |
0 |
|
|
Installment count |
is_installment |
VARCHAR2 |
3 |
|
|
|
|
Is installment |
is_pay_tax_upfront |
VARCHAR2 |
3 |
|
|
|
|
Whether the tax is included with the first installment |
is_preferred |
VARCHAR2 |
1 |
|
|
|
|
Preferred |
is_split_evenly |
VARCHAR2 |
3 |
|
|
|
|
Whether the payment terms are split evenly |
isinactive |
VARCHAR2 |
3 |
|
|
|
|
Item is inactive |
minimum_days |
NUMBER |
|
39 |
0 |
|
|
Minimum days |
name |
VARCHAR2 |
31 |
|
|
|
|
Name |
payment_terms_extid |
VARCHAR2 |
255 |
|
|
|
|
Payment terms external ID |
payment_terms_id |
NUMBER |
|
39 |
0 |
|
|
Payment terms ID |
percentage_discount |
NUMBER |
|
10 |
5 |
|
|
Percentage discount |
repeat_every |
NUMBER |
|
39 |
0 |
|
|
Repeat every |