Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('account_payment_term_line_id_seq'::regclass) |
|
|
|||||
| nb_days | int4 | 10 | √ | null |
|
|
Days |
||||
| payment_id | int4 | 10 | null |
|
|
Payment Terms |
|||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
||||
| value | varchar | 2147483647 | null |
|
|
Value |
|||||
| delay_type | varchar | 2147483647 | null |
|
|
Delay Type |
|||||
| value_amount | numeric | 0 | √ | null |
|
|
Due |
||||
| create_date | timestamp | 29,6 | √ | null |
|
|
Created on |
||||
| write_date | timestamp | 29,6 | √ | null |
|
|
Last Updated on |
||||
| days_next_month | varchar | 2 | √ | null |
|
|
Days on the next month |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| account_payment_term_line_pkey | Primary key | Asc | id |
| account_payment_term_line__payment_id_index | Performance | Asc | payment_id |
Relationships
Close relationships within degrees of separation
