Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | √ | null |
|
|
|||||
| ad_org_id | numeric | 10 | √ | null |
|
|
|||||
| isactive | bpchar | 1 | √ | null |
|
|
|||||
| created | timestamp | 29,6 | √ | null |
|
|
|||||
| createdby | numeric | 10 | √ | null |
|
|
|||||
| updated | timestamp | 29,6 | √ | null |
|
|
|||||
| updatedby | numeric | 10 | √ | null |
|
|
|||||
| ad_printformat_id | numeric | 10 | √ | null |
|
|
|||||
| name | varchar | 60 | √ | null |
|
|
|||||
| description | varchar | 255 | √ | null |
|
|
|||||
| istablebased | bpchar | 1 | √ | null |
|
|
|||||
| isform | bpchar | 1 | √ | null |
|
|
|||||
| ad_table_id | numeric | 10 | √ | null |
|
|
|||||
| ad_reportview_id | numeric | 10 | √ | null |
|
|
|||||
| ad_printpaper_id | numeric | 10 | √ | null |
|
|
|||||
| default_ad_printcolor_id | numeric | 10 | √ | null |
|
|
|||||
| default_ad_printfont_id | numeric | 10 | √ | null |
|
|
|||||
| bpchar | 1 | √ | null |
|
|
||||||
| ad_printtableformat_id | numeric | 10 | √ | null |
|
|
|||||
| headermargin | numeric | 10 | √ | null |
|
|
|||||
| numeric | 10 | √ | null |
|
|
||||||
| printername | varchar | 40 | √ | null |
|
|
|||||
| isdefault | bpchar | 1 | √ | null |
|
|
|||||
| ad_printformatitem_id | numeric | 10 | √ | null |
|
|
|||||
| itemname | varchar | 60 | √ | null |
|
|
|||||
| printname | varchar | 2000 | √ | null |
|
|
|||||
| printnamesuffix | varchar | 60 | √ | null |
|
|
|||||
| isprinted | bpchar | 1 | √ | null |
|
|
|||||
| printareatype | bpchar | 1 | √ | null |
|
|
|||||
| seqno | numeric | 10 | √ | null |
|
|
|||||
| printformattype | bpchar | 1 | √ | null |
|
|
|||||
| ad_column_id | numeric | 10 | √ | null |
|
|
|||||
| ad_printformatchild_id | numeric | 10 | √ | null |
|
|
|||||
| imageisattached | bpchar | 1 | √ | null |
|
|
|||||
| imageurl | varchar | 120 | √ | null |
|
|
|||||
| isrelativeposition | bpchar | 1 | √ | null |
|
|
|||||
| isnextline | bpchar | 1 | √ | null |
|
|
|||||
| xspace | numeric | 10 | √ | null |
|
|
|||||
| yspace | numeric | 10 | √ | null |
|
|
|||||
| xposition | numeric | 10 | √ | null |
|
|
|||||
| yposition | numeric | 10 | √ | null |
|
|
|||||
| maxwidth | numeric | 10 | √ | null |
|
|
|||||
| isheightoneline | bpchar | 1 | √ | null |
|
|
|||||
| maxheight | numeric | 10 | √ | null |
|
|
|||||
| isfixedwidth | bpchar | 1 | √ | null |
|
|
|||||
| issetnlposition | bpchar | 1 | √ | null |
|
|
|||||
| issuppressnull | bpchar | 1 | √ | null |
|
|
|||||
| belowcolumn | numeric | 10 | √ | null |
|
|
|||||
| fieldalignmenttype | bpchar | 1 | √ | null |
|
|
|||||
| linealignmenttype | bpchar | 1 | √ | null |
|
|
|||||
| ad_printcolor_id | numeric | 10 | √ | null |
|
|
|||||
| ad_printfont_id | numeric | 10 | √ | null |
|
|
|||||
| isorderby | bpchar | 1 | √ | null |
|
|
|||||
| sortno | numeric | 10 | √ | null |
|
|
|||||
| isgroupby | bpchar | 1 | √ | null |
|
|
|||||
| ispagebreak | bpchar | 1 | √ | null |
|
|
|||||
| isnextpage | bpchar | 1 | √ | null |
|
|
|||||
| issummarized | bpchar | 1 | √ | null |
|
|
|||||
| isaveraged | bpchar | 1 | √ | null |
|
|
|||||
| iscounted | bpchar | 1 | √ | null |
|
|
|||||
| ismincalc | bpchar | 1 | √ | null |
|
|
|||||
| ismaxcalc | bpchar | 1 | √ | null |
|
|
|||||
| isvariancecalc | bpchar | 1 | √ | null |
|
|
|||||
| isdeviationcalc | bpchar | 1 | √ | null |
|
|
|||||
| isrunningtotal | bpchar | 1 | √ | null |
|
|
|||||
| runningtotallines | numeric | 10 | √ | null |
|
|
|||||
| ad_printgraph_id | numeric | 10 | √ | null |
|
|