ad_printformat

336 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_printformat_id numeric 10 null
ad_package_exp_detail.ad_printformat_id adprintformat_adpackageexpdeta R
ad_pinstance.ad_printformat_id adprintformat_adpinstance R
ad_printform.distrib_order_printformat_id distriborderprintformat_adprin R
ad_printform.invoice_printformat_id adprintformat_forminvoice R
ad_printform.manuf_order_printformat_id manuforderprintformat_adprintf R
ad_printform.order_printformat_id adprintformat_formorder R
ad_printform.project_printformat_id adprintformat_formproject R
ad_printform.remittance_printformat_id adprintformat_formremittance R
ad_printform.shipment_printformat_id adprintformat_formshipment R
ad_printformat_trl.ad_printformat_id adprintformat_trl R
ad_printformatitem.ad_printformat_id adprintformat_printformatitem C
ad_printformatitem.ad_printformatchild_id adprintformat_printformatchild N
ad_printgraph.ad_printformat_id adprintformat_adprintgraph R
ad_process.ad_printformat_id adprintformat_adprocess R
ad_process_drillrule.ad_printformat_id adprintformat_addrillrule R
ad_scheduler.ad_printformat_id adprintformat_adscheduler R
c_bankaccountdoc.check_printformat_id adprintformat_cbankaccountdoc R
c_bpartner.invoice_printformat_id adprintformatinv_cbpartner R
c_doctype.ad_printformat_id adprintformat_cdoctype R
c_dunninglevel.dunning_printformat_id adprintformat_cdunninglevel R
c_rfq_topic.ad_printformat_id adprintformat_arfqtopic N
cof_rv_processosdejanela.ad_printformat_id Implied Constraint R
hr_payroll.ad_printformat_id adprintformat_hrpayroll R
hr_process.ad_printformat_id adprintformat_hrprocess R
pa_dashboardcontent.ad_printformat_id adprintformat_padashboardconte R
pa_report.ad_printformat_id adprintformat_pareport N
rv_printformatdetail.ad_printformat_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
istablebased bpchar 1 'Y'::bpchar
isform bpchar 1 'N'::bpchar
ad_table_id numeric 10 null
ad_table.ad_table_id adtable_adprintformat R
ad_printpaper_id numeric 10 null
ad_printpaper.ad_printpaper_id adprintpaper_adprintformat R
ad_printcolor_id numeric 10 null
ad_printcolor.ad_printcolor_id adprintcolor_adprintformat R
ad_printfont_id numeric 10 null
ad_printfont.ad_printfont_id ad_printfont_adprintformat R
isstandardheaderfooter bpchar 1 'Y'::bpchar
headermargin numeric 10 null
footermargin numeric 10 null
createcopy bpchar 1 √ null
ad_reportview_id numeric 10 √ null
ad_reportview.ad_reportview_id adprintview_adprintformat R
ad_printtableformat_id numeric 10 √ null
ad_printtableformat.ad_printtableformat_id adprintformattable_format R
printername varchar 40 √ null
isdefault bpchar 1 'N'::bpchar
jasperprocess_id numeric 10 √ null
ad_process.ad_process_id jasperprocess_adprintformat R
classname varchar 240 √ null
args varchar 510 √ null
ad_printformat_uu varchar 36 √ NULL::character varying
ad_window_id numeric 10 √ NULL::numeric
ad_window.ad_window_id adwindow_adprintformat R
cof_processing bpchar 1 √ NULL::bpchar
cof_istemplatedocx bpchar 1 'N'::bpchar
isbreakpageperrecord bpchar 1 'Y'::bpchar
ad_printheaderfooter_id numeric 10 √ NULL::numeric
ad_printheaderfooter.ad_printheaderfooter_id adprintheaderfooter_adprintfor R
filenamepattern varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
ad_printformat_pkey Primary key Asc ad_printformat_id
ad_printformat_name Must be unique Asc/Asc/Asc ad_client_id + ad_table_id + name
ad_printformat_table Performance Asc ad_table_id
ad_printformat_uu_idx Must be unique Asc ad_printformat_uu

Check Constraints

Constraint Name Constraint
ad_printformat_isform_check ((isform = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformat_isbreakpageperrecord_check ((isbreakpageperrecord = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformat_isstandardheaderfooter_check ((isstandardheaderfooter = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformat_cof_istemplatedocx_check ((cof_istemplatedocx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformat_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformat_istablebased_check ((istablebased = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation