ad_pinstance

150 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_pinstance_id numeric 10 null
ad_pinstance_log.ad_pinstance_id adpinstance_pilog C
ad_pinstance_para.ad_pinstance_id adpinstance_adpinstancepara C
ad_verifymigration.ad_pinstance_id adpinstance_adverifymigration C
cof_selection.ad_pinstance_id Implied Constraint R
mp_prognosis.ad_pinstance_id adpinstance_mpprognosis R
rv_pp_product_bomline.ad_pinstance_id Implied Constraint R
rv_t_1099extract.ad_pinstance_id Implied Constraint R
t_1099extract.ad_pinstance_id Implied Constraint R
t_aging.ad_pinstance_id adpinstance_taging C
t_bankregister.ad_pinstance_id Implied Constraint R
t_bom_indented.ad_pinstance_id Implied Constraint R
t_bomline.ad_pinstance_id Implied Constraint R
t_bomline_costs.ad_pinstance_id Implied Constraint R
t_cashflow.ad_pinstance_id Implied Constraint R
t_cof_fluxoplanofinanceiro.ad_pinstance_id adpinstance_tcoffluxoplanofina C
t_cof_relatoriocompra.ad_pinstance_id adpinstance_tcofrelatoriocompr C
t_cof_relatoriomrp.ad_pinstance_id adpinstance_tcofrelatoriomrp C
t_inventorytrxsummary.ad_pinstance_id adpinstance_tinventorytrxsumma C
t_inventoryvalue.ad_pinstance_id adpinstance_tinventoryvalue C
t_invoicegl.ad_pinstance_id adpinstance_tinvoicegl C
t_invoicegl_v.ad_pinstance_id Implied Constraint R
t_itensaproduzir.ad_pinstance_id adpinstance_coftitensaproduzir C
t_itensnaovendidosaclientes.ad_pinstance_id adpinstance_titensnaovendidosa C
t_moveclient.ad_pinstance_id Implied Constraint R
t_mrp_crp.ad_pinstance_id Implied Constraint R
t_reconciliation.ad_pinstance_id Implied Constraint R
t_replenish.ad_pinstance_id adpinstance_treplenish C
t_report.ad_pinstance_id adpinstance_treport C
t_reportstatement.ad_pinstance_id adpinstance_treportstatement C
t_rv_reconciliation.ad_pinstance_id Implied Constraint R
t_spool.ad_pinstance_id adpinstance_tspool C
t_transaction.ad_pinstance_id adpinstance_ttransaction C
t_trialbalance.ad_pinstance_id ad_pinstance_t_trialbalance C
ad_process_id numeric 10 null
ad_process.ad_process_id adprocess_adpinstance R
record_id numeric 10 null
isprocessing bpchar 1 'N'::bpchar
created timestamp 29,6 now()
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_pinstance R
updated timestamp 29,6 statement_timestamp()
result numeric 10 √ null
errormsg varchar 2000 √ null
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
createdby numeric 10 √ null
updatedby numeric 10 null
isactive bpchar 1 √ 'Y'::bpchar
ad_pinstance_uu varchar 36 √ NULL::character varying
isrunasjob bpchar 1 √ 'N'::bpchar
notificationtype varchar 2 √ NULL::character varying
name varchar 60 √ NULL::character varying
reporttype varchar 5 √ NULL::character varying
ad_printformat_id numeric 10 √ NULL::numeric
ad_printformat.ad_printformat_id adprintformat_adpinstance R
issummary bpchar 1 √ NULL::bpchar
ad_language_id numeric 10 √ NULL::numeric
ad_language.ad_language_id adlanguage_adpinstance R
ad_session_id numeric 10 √ NULL::numeric
ad_session.ad_session_id adsession_adpinstance R

Indexes

Constraint Name Type Sort Column(s)
ad_pinstance_pkey Primary key Asc ad_pinstance_id
ad_pinstance_last_ix Performance Asc/Asc/Asc/Asc/Asc ad_user_id + ad_process_id + ad_client_id + isactive + name
ad_pinstance_record Performance Asc/Asc ad_process_id + record_id
ad_pinstance_uu_idx Must be unique Asc ad_pinstance_uu

Check Constraints

Constraint Name Constraint
ad_pinstance_isprocessing_check ((isprocessing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_pinstance_issummary_check ((issummary = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation