テーブル情報
システム名 http://www.as-link.com/  作成者 秦 松甫 
サブシステム名 ERPlus@iDempiere3.1_daily  作成日 2016/3/7 
スキーマ名 adempiere  更新日  
論理テーブル名   RDBMS  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit 9.4.5 
物理テーブル名 c_validcombination     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_validcombination_id numeric(10) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'Y'
5 created timestamp without time zone Yes now()
6 createdby numeric(10) Yes
7 updated timestamp without time zone Yes now()
8 updatedby numeric(10) Yes
9 alias character varying(40)  
10 combination character varying(60)  
11 description character varying(255)  
12 isfullyqualified character(1) Yes 'Y'
13 c_acctschema_id numeric(10) Yes
14 account_id numeric(10) Yes
15 m_product_id numeric(10)  
16 c_bpartner_id numeric(10)  
17 ad_orgtrx_id numeric(10)  
18 c_locfrom_id numeric(10)  
19 c_locto_id numeric(10)  
20 c_salesregion_id numeric(10)  
21 c_project_id numeric(10)  
22 c_campaign_id numeric(10)  
23 c_activity_id numeric(10)  
24 user1_id numeric(10)  
25 user2_id numeric(10)  
26 c_subacct_id numeric(10)  
27 userelement1_id numeric(10)  
28 userelement2_id numeric(10)  
29 c_validcombination_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_validcombination_alias ad_client_id,alias    
2 c_validcombination_alt c_acctschema_id,ad_org_id,account_id,c_subacct_id,m_product_id,c_bpartner_id,ad_orgtrx_id,c_locfrom_id,c_locto_id,c_salesregion_id,c_project_id,c_campaign_id,c_activity_id,user1_id,user2_id,userelement1_id,userelement2_id Yes  
3 c_validcombination_pkey c_validcombination_id Yes  
4 c_validcombination_uu_idx c_validcombination_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adclient_vc ad_client_id adempiere.ad_client ad_client_id
2 adorg_vc ad_org_id adempiere.ad_org ad_org_id
3 adorgtrx_vc ad_orgtrx_id adempiere.ad_org ad_org_id
4 cacctschema_cvalidcombination c_acctschema_id adempiere.c_acctschema c_acctschema_id
5 cactivity_cvalidcombination c_activity_id adempiere.c_activity c_activity_id
6 cbpartner_vc c_bpartner_id adempiere.c_bpartner c_bpartner_id
7 celementvalueaccount_vc account_id adempiere.c_elementvalue c_elementvalue_id
8 celementvalueuser1_vc user1_id adempiere.c_elementvalue c_elementvalue_id
9 celementvalueuser2_vc user2_id adempiere.c_elementvalue c_elementvalue_id
10 cproject_vc c_project_id adempiere.c_project c_project_id
11 csalesregion_vc c_salesregion_id adempiere.c_salesregion c_salesregion_id
12 csubacct_cvalidcombination c_subacct_id adempiere.c_subacct c_subacct_id
13 mlocationfrom_vc c_locfrom_id adempiere.c_location c_location_id
14 mlocationto_vc c_locto_id adempiere.c_location c_location_id
15 mproduct_vc m_product_id adempiere.m_product m_product_id
16 socampaign_vc c_campaign_id adempiere.c_campaign c_campaign_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 aaccountnumber_adepreciationex c_validcombination_id adempiere.a_depreciation_exp a_account_number_acct
2 aaccumdepreciation_aassetacct c_validcombination_id adempiere.a_asset_acct a_accumdepreciation_acct
3 aaccumdepreciation_aassetchang c_validcombination_id adempiere.a_asset_change a_accumdepreciation_acct
4 aaccumdepreciation_aassetgroup c_validcombination_id adempiere.a_asset_group_acct a_accumdepreciation_acct
5 aaccumdepreciation_aassettrans c_validcombination_id adempiere.a_asset_transfer a_accumdepreciation_acct
6 aaccumdepreciation_iasset c_validcombination_id adempiere.i_asset a_accumdepreciation_acct
7 aaccumdepreciationnew_aassettr c_validcombination_id adempiere.a_asset_transfer a_accumdepreciation_new_acct
8 aasset_aassetgroupacct c_validcombination_id adempiere.a_asset_group_acct a_asset_acct
9 aasset_iasset c_validcombination_id adempiere.i_asset a_asset_acct
10 aassetnew_aassettransfer c_validcombination_id adempiere.a_asset_transfer a_asset_new_acct
11 aassetvc_aassetacct c_validcombination_id adempiere.a_asset_acct a_asset_acct
12 aassetvc_aassetchange c_validcombination_id adempiere.a_asset_change a_asset_acct
13 aassetvc_aassettransfer c_validcombination_id adempiere.a_asset_transfer a_asset_acct
14 adepreciation_aassetchange c_validcombination_id adempiere.a_asset_change a_depreciation_acct
15 adepreciation_aassettransfer c_validcombination_id adempiere.a_asset_transfer a_depreciation_acct
16 adepreciation_iasset c_validcombination_id adempiere.i_asset a_depreciation_acct
17 adepreciationnew_aassettransfe c_validcombination_id adempiere.a_asset_transfer a_depreciation_new_acct
18 adepreciationvc_aassetacct c_validcombination_id adempiere.a_asset_acct a_depreciation_acct
19 adepreciationvc_aassetgroupacc c_validcombination_id adempiere.a_asset_group_acct a_depreciation_acct
20 adisposalgain_aassetacct c_validcombination_id adempiere.a_asset_acct a_disposal_gain_acct
21 adisposalgain_aassetgroupacct c_validcombination_id adempiere.a_asset_group_acct a_disposal_gain_acct
22 adisposalloss_aassetacct c_validcombination_id adempiere.a_asset_acct a_disposal_loss_acct
23 adisposalloss_aassetchange c_validcombination_id adempiere.a_asset_change a_disposal_loss_acct
24 adisposalloss_aassetgroupacct c_validcombination_id adempiere.a_asset_group_acct a_disposal_loss_acct
25 adisposalloss_aassettransfer c_validcombination_id adempiere.a_asset_transfer a_disposal_loss_acct
26 adisposallossnew_aassettransfe c_validcombination_id adempiere.a_asset_transfer a_disposal_loss_new_acct
27 adisposalrevenue_aassetacct c_validcombination_id adempiere.a_asset_acct a_disposal_revenue_acct
28 adisposalrevenue_aassetchange c_validcombination_id adempiere.a_asset_change a_disposal_revenue_acct
29 adisposalrevenue_aassetgroupac c_validcombination_id adempiere.a_asset_group_acct a_disposal_revenue_acct
30 adisposalrevenue_aassettransfe c_validcombination_id adempiere.a_asset_transfer a_disposal_revenue_acct
31 adisposalrevenuenew_aassettran c_validcombination_id adempiere.a_asset_transfer a_disposal_revenue_new_acct
32 aliasvalidcombination_gljourna c_validcombination_id adempiere.gl_journalline alias_validcombination_id
33 arevaladepoffsetcur_aassetacct c_validcombination_id adempiere.a_asset_acct a_reval_adep_offset_cur_acct
34 arevaladepoffsetcur_aassetgrou c_validcombination_id adempiere.a_asset_group_acct a_reval_adep_offset_cur_acct
35 arevaladepoffsetprior_aassetac c_validcombination_id adempiere.a_asset_acct a_reval_adep_offset_prior_acct
36 arevaladepoffsetprior_aassetgr c_validcombination_id adempiere.a_asset_group_acct a_reval_adep_offset_prior_acct
37 arevalcostoffset_aassetacct c_validcombination_id adempiere.a_asset_acct a_reval_cost_offset_acct
38 arevalcostoffset_aassetgroupac c_validcombination_id adempiere.a_asset_group_acct a_reval_cost_offset_acct
39 arevalcostoffsetprior_aassetac c_validcombination_id adempiere.a_asset_acct a_reval_cost_offset_prior_acct
40 arevalcostoffsetprior_aassetgr c_validcombination_id adempiere.a_asset_group_acct a_reval_cost_offset_prior_acct
41 arevaldepexpoffset_aassetacct c_validcombination_id adempiere.a_asset_acct a_reval_depexp_offset_acct
42 arevaldepexpoffset_aassetgroup c_validcombination_id adempiere.a_asset_group_acct a_reval_depexp_offset_acct
43 chrevenue_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default ch_revenue_acct
44 chrevenue_cchargeacct c_validcombination_id adempiere.c_charge_acct ch_revenue_acct
45 commitmentoffset_cacctschemagl c_validcombination_id adempiere.c_acctschema_gl commitmentoffset_acct
46 commitmentoffsetsales_cacctsch c_validcombination_id adempiere.c_acctschema_gl commitmentoffsetsales_acct
47 craccou_adepreciationexp c_validcombination_id adempiere.a_depreciation_exp cr_account_id
48 creceivableservices_cacctschem c_validcombination_id adempiere.c_acctschema_default c_receivable_services_acct
49 creceivableservices_cbpcustome c_validcombination_id adempiere.c_bp_customer_acct c_receivable_services_acct
50 creceivableservices_cbpgroupac c_validcombination_id adempiere.c_bp_group_acct c_receivable_services_acct
51 cvalidcombinati_aassetchange c_validcombination_id adempiere.a_asset_change c_validcombination_id
52 cvalidcombination_ifajournal c_validcombination_id adempiere.i_fajournal c_validcombination_id
53 cvalidcombination_igljournal c_validcombination_id adempiere.i_gljournal c_validcombination_id
54 cvc_gljournalline c_validcombination_id adempiere.gl_journalline c_validcombination_id
55 draccou_adepreciationexp c_validcombination_id adempiere.a_depreciation_exp dr_account_id
56 hrattribute_hrattribute c_validcombination_id adempiere.hr_attribute hr_attribute_acct
57 hrconcept_hrconceptcategory c_validcombination_id adempiere.hr_concept_category hr_concept_acct
58 hrexpense_hrconceptacct c_validcombination_id adempiere.hr_concept_acct hr_expense_acct
59 hrrevenue_hrconceptacct c_validcombination_id adempiere.hr_concept_acct hr_revenue_acct
60 paveragecostvariance_cacctsche c_validcombination_id adempiere.c_acctschema_default p_averagecostvariance_acct
61 paveragecostvariance_mproducta c_validcombination_id adempiere.m_product_acct p_averagecostvariance_acct
62 paveragecostvariance_mproductc c_validcombination_id adempiere.m_product_category_acct p_averagecostvariance_acct
63 pburden_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_burden_acct
64 pburden_mproductacct c_validcombination_id adempiere.m_product_acct p_burden_acct
65 pburden_mproductcategoryacct c_validcombination_id adempiere.m_product_category_acct p_burden_acct
66 pcostadjustment_cacctschemadef c_validcombination_id adempiere.c_acctschema_default p_costadjustment_acct
67 pcostadjustment_mproductacct c_validcombination_id adempiere.m_product_acct p_costadjustment_acct
68 pcostadjustment_mproductcatego c_validcombination_id adempiere.m_product_category_acct p_costadjustment_acct
69 pcostofproduction_cacctschemad c_validcombination_id adempiere.c_acctschema_default p_costofproduction_acct
70 pcostofproduction_mproductacct c_validcombination_id adempiere.m_product_acct p_costofproduction_acct
71 pcostofproduction_mproductcate c_validcombination_id adempiere.m_product_category_acct p_costofproduction_acct
72 pfloorstock_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_floorstock_acct
73 pfloorstock_mproductacct c_validcombination_id adempiere.m_product_acct p_floorstock_acct
74 pfloorstock_mproductcategoryac c_validcombination_id adempiere.m_product_category_acct p_floorstock_acct
75 pinventoryclearing_cacctschema c_validcombination_id adempiere.c_acctschema_default p_inventoryclearing_acct
76 pinventoryclearing_mproductacc c_validcombination_id adempiere.m_product_acct p_inventoryclearing_acct
77 pinventoryclearing_mproductcat c_validcombination_id adempiere.m_product_category_acct p_inventoryclearing_acct
78 plabor_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_labor_acct
79 plabor_mproductacct c_validcombination_id adempiere.m_product_acct p_labor_acct
80 plabor_mproductcategoryacct c_validcombination_id adempiere.m_product_category_acct p_labor_acct
81 plandedcostclearingvc_cacctsch c_validcombination_id adempiere.c_acctschema_default p_landedcostclearing_acct
82 plandedcostclearingvc_mprcatac c_validcombination_id adempiere.m_product_category_acct p_landedcostclearing_acct
83 plandedcostclearingvc_mprodacc c_validcombination_id adempiere.m_product_acct p_landedcostclearing_acct
84 pmethodchangevariance_cacctsch c_validcombination_id adempiere.c_acctschema_default p_methodchangevariance_acct
85 pmethodchangevariance_mprodcat c_validcombination_id adempiere.m_product_category_acct p_methodchangevariance_acct
86 pmethodchangevariance_mproduct c_validcombination_id adempiere.m_product_acct p_methodchangevariance_acct
87 pmixvariance_cacctschemadefaul c_validcombination_id adempiere.c_acctschema_default p_mixvariance_acct
88 pmixvariance_mproductacct c_validcombination_id adempiere.m_product_acct p_mixvariance_acct
89 pmixvariance_mproductcategorya c_validcombination_id adempiere.m_product_category_acct p_mixvariance_acct
90 poutsideprocessing_cacctschema c_validcombination_id adempiere.c_acctschema_default p_outsideprocessing_acct
91 poutsideprocessing_mproductacc c_validcombination_id adempiere.m_product_acct p_outsideprocessing_acct
92 poutsideprocessing_mproductcat c_validcombination_id adempiere.m_product_category_acct p_outsideprocessing_acct
93 poverhead_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_overhead_acct
94 poverhead_mproductacct c_validcombination_id adempiere.m_product_acct p_overhead_acct
95 poverhead_mproductcategoryacct c_validcombination_id adempiere.m_product_category_acct p_overhead_acct
96 pratevariance_cacctschemadefau c_validcombination_id adempiere.c_acctschema_default p_ratevariance_acct
97 pratevariance_mproductacct c_validcombination_id adempiere.m_product_acct p_ratevariance_acct
98 pratevariance_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_ratevariance_acct
99 pscrap_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_scrap_acct
100 pscrap_mproductacct c_validcombination_id adempiere.m_product_acct p_scrap_acct
101 pscrap_mproductcategoryacct c_validcombination_id adempiere.m_product_category_acct p_scrap_acct
102 pusagevariance_cacctschemadefa c_validcombination_id adempiere.c_acctschema_default p_usagevariance_acct
103 pusagevariance_mproductacct c_validcombination_id adempiere.m_product_acct p_usagevariance_acct
104 pusagevariance_mproductcategor c_validcombination_id adempiere.m_product_category_acct p_usagevariance_acct
105 pwip_cacctschemadefault c_validcombination_id adempiere.c_acctschema_default p_wip_acct
106 pwip_mproductacct c_validcombination_id adempiere.m_product_acct p_wip_acct
107 pwip_mproductcategoryacct c_validcombination_id adempiere.m_product_category_acct p_wip_acct
108 use_hrconceptacct c_validcombination_id adempiere.hr_concept_acct user2_id
109 vc_account_test c_validcombination_id adempiere.test account_acct
110 vc_basset_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_asset_acct
111 vc_basset_cschemadefault c_validcombination_id adempiere.c_acctschema_default b_asset_acct
112 vc_bexpense_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_expense_acct
113 vc_bexpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default b_expense_acct
114 vc_binterestexp_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_interestexp_acct
115 vc_binterestexp_cschemadefault c_validcombination_id adempiere.c_acctschema_default b_interestexp_acct
116 vc_binterestrev_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_interestrev_acct
117 vc_binterestrev_cschemadefault c_validcombination_id adempiere.c_acctschema_default b_interestrev_acct
118 vc_bintransit_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_intransit_acct
119 vc_bintransit_cschemadefault c_validcombination_id adempiere.c_acctschema_default b_intransit_acct
120 vc_bpaymentselect_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_paymentselect_acct
121 vc_bpaymentselect_cschemadefau c_validcombination_id adempiere.c_acctschema_default b_paymentselect_acct
122 vc_brevaluationgain_cbankaccou c_validcombination_id adempiere.c_bankaccount_acct b_revaluationgain_acct
123 vc_brevaluationgain_cschemadef c_validcombination_id adempiere.c_acctschema_default b_revaluationgain_acct
124 vc_brevaluationloss_cbankaccou c_validcombination_id adempiere.c_bankaccount_acct b_revaluationloss_acct
125 vc_brevaluationloss_cschemadef c_validcombination_id adempiere.c_acctschema_default b_revaluationloss_acct
126 vc_bsettlementgain_cbankaccoun c_validcombination_id adempiere.c_bankaccount_acct b_settlementgain_acct
127 vc_bsettlementgain_cschemadefa c_validcombination_id adempiere.c_acctschema_default b_settlementgain_acct
128 vc_bsettlementloss_cbankaccoun c_validcombination_id adempiere.c_bankaccount_acct b_settlementloss_acct
129 vc_bsettlementloss_cschemadefa c_validcombination_id adempiere.c_acctschema_default b_settlementloss_acct
130 vc_bunallocatedcash_cbankaccou c_validcombination_id adempiere.c_bankaccount_acct b_unallocatedcash_acct
131 vc_bunallocatedcash_cschemadef c_validcombination_id adempiere.c_acctschema_default b_unallocatedcash_acct
132 vc_bunidentified_cbankaccount c_validcombination_id adempiere.c_bankaccount_acct b_unidentified_acct
133 vc_bunidentified_cschemadefaul c_validcombination_id adempiere.c_acctschema_default b_unidentified_acct
134 vc_cbasset_ccashbook c_validcombination_id adempiere.c_cashbook_acct cb_asset_acct
135 vc_cbasset_cschemadefault c_validcombination_id adempiere.c_acctschema_default cb_asset_acct
136 vc_cbcashtransfer_ccashbook c_validcombination_id adempiere.c_cashbook_acct cb_cashtransfer_acct
137 vc_cbcashtransfer_cschemadefau c_validcombination_id adempiere.c_acctschema_default cb_cashtransfer_acct
138 vc_cbdifferences_ccashbook c_validcombination_id adempiere.c_cashbook_acct cb_differences_acct
139 vc_cbdifferences_cschemadefaul c_validcombination_id adempiere.c_acctschema_default cb_differences_acct
140 vc_cbexpense_ccashbook c_validcombination_id adempiere.c_cashbook_acct cb_expense_acct
141 vc_cbexpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default cb_expense_acct
142 vc_cbreceipt_ccashbook c_validcombination_id adempiere.c_cashbook_acct cb_receipt_acct
143 vc_cbreceipt_cschemadefault c_validcombination_id adempiere.c_acctschema_default cb_receipt_acct
144 vc_chexpense_ccharge c_validcombination_id adempiere.c_charge_acct ch_expense_acct
145 vc_chexpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default ch_expense_acct
146 vc_cprepayment_cbpcustomer c_validcombination_id adempiere.c_bp_customer_acct c_prepayment_acct
147 vc_cprepayment_cbpgroup c_validcombination_id adempiere.c_bp_group_acct c_prepayment_acct
148 vc_cprepayment_cschemadefault c_validcombination_id adempiere.c_acctschema_default c_prepayment_acct
149 vc_creceivable_cbpcustomer c_validcombination_id adempiere.c_bp_customer_acct c_receivable_acct
150 vc_creceivable_cbpgroup c_validcombination_id adempiere.c_bp_group_acct c_receivable_acct
151 vc_creceivable_cschemadefault c_validcombination_id adempiere.c_acctschema_default c_receivable_acct
152 vc_currencybalancing_cschemagl c_validcombination_id adempiere.c_acctschema_gl currencybalancing_acct
153 vc_eexpense_cbpemployee c_validcombination_id adempiere.c_bp_employee_acct e_expense_acct
154 vc_eexpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default e_expense_acct
155 vc_eprepayment_cbpemployee c_validcombination_id adempiere.c_bp_employee_acct e_prepayment_acct
156 vc_eprepayment_cschemadefault c_validcombination_id adempiere.c_acctschema_default e_prepayment_acct
157 vc_incomesummary_cschemagl c_validcombination_id adempiere.c_acctschema_gl incomesummary_acct
158 vc_intercompanyduefrom_cintero c_validcombination_id adempiere.c_interorg_acct intercompanyduefrom_acct
159 vc_intercompanyduefrom_cschema c_validcombination_id adempiere.c_acctschema_gl intercompanyduefrom_acct
160 vc_intercompanydueto_cinterorg c_validcombination_id adempiere.c_interorg_acct intercompanydueto_acct
161 vc_intercompanydueto_cschemagl c_validcombination_id adempiere.c_acctschema_gl intercompanydueto_acct
162 vc_notinvoicedrec_cbpgroup c_validcombination_id adempiere.c_bp_group_acct notinvoicedreceivables_acct
163 vc_notinvoicedrec_cschemadefau c_validcombination_id adempiere.c_acctschema_default notinvoicedreceivables_acct
164 vc_notinvoicedreceipts_cbpgrou c_validcombination_id adempiere.c_bp_group_acct notinvoicedreceipts_acct
165 vc_notinvoicedreceipts_cschema c_validcombination_id adempiere.c_acctschema_default notinvoicedreceipts_acct
166 vc_notinvoicedrevenue_cbpgroup c_validcombination_id adempiere.c_bp_group_acct notinvoicedrevenue_acct
167 vc_notinvoicedrevenue_cschemad c_validcombination_id adempiere.c_acctschema_default notinvoicedrevenue_acct
168 vc_passet_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_asset_acct
169 vc_passet_mproduct c_validcombination_id adempiere.m_product_acct p_asset_acct
170 vc_passet_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_asset_acct
171 vc_paydiscountexp_cbpgroup c_validcombination_id adempiere.c_bp_group_acct paydiscount_exp_acct
172 vc_paydiscountexp_cschemadefau c_validcombination_id adempiere.c_acctschema_default paydiscount_exp_acct
173 vc_paydiscountrev_cbpgroup c_validcombination_id adempiere.c_bp_group_acct paydiscount_rev_acct
174 vc_paydiscountrev_cschemadefau c_validcombination_id adempiere.c_acctschema_default paydiscount_rev_acct
175 vc_pcogs_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_cogs_acct
176 vc_pcogs_mproduct c_validcombination_id adempiere.m_product_acct p_cogs_acct
177 vc_pcogs_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_cogs_acct
178 vc_pexpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_expense_acct
179 vc_pexpense_mproduct c_validcombination_id adempiere.m_product_acct p_expense_acct
180 vc_pexpense_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_expense_acct
181 vc_pinvoicepv_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_invoicepricevariance_acct
182 vc_pinvoicepv_mproduct c_validcombination_id adempiere.m_product_acct p_invoicepricevariance_acct
183 vc_pinvoicepv_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_invoicepricevariance_acct
184 vc_pjasset_cproject c_validcombination_id adempiere.c_project_acct pj_asset_acct
185 vc_pjasset_cschemadefault c_validcombination_id adempiere.c_acctschema_default pj_asset_acct
186 vc_pjwip_cproject c_validcombination_id adempiere.c_project_acct pj_wip_acct
187 vc_pjwip_cschemadefault c_validcombination_id adempiere.c_acctschema_default pj_wip_acct
188 vc_ppurchasepv_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_purchasepricevariance_acct
189 vc_ppurchasepv_mproduct c_validcombination_id adempiere.m_product_acct p_purchasepricevariance_acct
190 vc_ppurchasepv_mproductcategor c_validcombination_id adempiere.m_product_category_acct p_purchasepricevariance_acct
191 vc_ppvoffset_cschemagl c_validcombination_id adempiere.c_acctschema_gl ppvoffset_acct
192 vc_prevenue_crevenuerecognitio c_validcombination_id adempiere.c_revenuerecognition_plan p_revenue_acct
193 vc_prevenue_cschemadefault c_validcombination_id adempiere.c_acctschema_default p_revenue_acct
194 vc_prevenue_mproduct c_validcombination_id adempiere.m_product_acct p_revenue_acct
195 vc_prevenue_mproductcategory c_validcombination_id adempiere.m_product_category_acct p_revenue_acct
196 vc_ptdiscountgrant_cschemadefa c_validcombination_id adempiere.c_acctschema_default p_tradediscountgrant_acct
197 vc_ptdiscountgrant_mproduct c_validcombination_id adempiere.m_product_acct p_tradediscountgrant_acct
198 vc_ptdiscountgrant_mproductcat c_validcombination_id adempiere.m_product_category_acct p_tradediscountgrant_acct
199 vc_ptdiscountrec_cschemadefaul c_validcombination_id adempiere.c_acctschema_default p_tradediscountrec_acct
200 vc_ptdiscountrec_mproduct c_validcombination_id adempiere.m_product_acct p_tradediscountrec_acct
201 vc_ptdiscountrec_mproductcateg c_validcombination_id adempiere.m_product_category_acct p_tradediscountrec_acct
202 vc_realizedgain_ccurrency c_validcombination_id adempiere.c_currency_acct realizedgain_acct
203 vc_realizedgain_cschemadefault c_validcombination_id adempiere.c_acctschema_default realizedgain_acct
204 vc_realizedloss_ccurrency c_validcombination_id adempiere.c_currency_acct realizedloss_acct
205 vc_realizedloss_cschemadefault c_validcombination_id adempiere.c_acctschema_default realizedloss_acct
206 vc_retainedearning_cschemagl c_validcombination_id adempiere.c_acctschema_gl retainedearning_acct
207 vc_suspensebalancing_cschemagl c_validcombination_id adempiere.c_acctschema_gl suspensebalancing_acct
208 vc_suspenseerror_cschemagl c_validcombination_id adempiere.c_acctschema_gl suspenseerror_acct
209 vc_tcredit_cschemadefault c_validcombination_id adempiere.c_acctschema_default t_credit_acct
210 vc_tcredit_ctax c_validcombination_id adempiere.c_tax_acct t_credit_acct
211 vc_tdue_cschemadefault c_validcombination_id adempiere.c_acctschema_default t_due_acct
212 vc_tdue_ctax c_validcombination_id adempiere.c_tax_acct t_due_acct
213 vc_texpense_cschemadefault c_validcombination_id adempiere.c_acctschema_default t_expense_acct
214 vc_texpense_ctax c_validcombination_id adempiere.c_tax_acct t_expense_acct
215 vc_tliability_cschemadefault c_validcombination_id adempiere.c_acctschema_default t_liability_acct
216 vc_tliability_ctax c_validcombination_id adempiere.c_tax_acct t_liability_acct
217 vc_trec_cschemadefault c_validcombination_id adempiere.c_acctschema_default t_receivables_acct
218 vc_trec_ctax c_validcombination_id adempiere.c_tax_acct t_receivables_acct
219 vc_unearnedrevenue_cbpgroup c_validcombination_id adempiere.c_bp_group_acct unearnedrevenue_acct
220 vc_unearnedrevenue_crevenuerec c_validcombination_id adempiere.c_revenuerecognition_plan unearnedrevenue_acct
221 vc_unearnedrevenue_cschemadefa c_validcombination_id adempiere.c_acctschema_default unearnedrevenue_acct
222 vc_unrealizedgain_ccurrency c_validcombination_id adempiere.c_currency_acct unrealizedgain_acct
223 vc_unrealizedgain_cschemadefau c_validcombination_id adempiere.c_acctschema_default unrealizedgain_acct
224 vc_unrealizedloss_ccurrency c_validcombination_id adempiere.c_currency_acct unrealizedloss_acct
225 vc_unrealizedloss_cschemadefau c_validcombination_id adempiere.c_acctschema_default unrealizedloss_acct
226 vc_vliability_cbpgroup c_validcombination_id adempiere.c_bp_group_acct v_liability_acct
227 vc_vliability_cbpvendor c_validcombination_id adempiere.c_bp_vendor_acct v_liability_acct
228 vc_vliability_cschemadefault c_validcombination_id adempiere.c_acctschema_default v_liability_acct
229 vc_vliabilityservices_cbpgroup c_validcombination_id adempiere.c_bp_group_acct v_liability_services_acct
230 vc_vliabilityservices_cbpvendo c_validcombination_id adempiere.c_bp_vendor_acct v_liability_services_acct
231 vc_vliabilityservices_cschemad c_validcombination_id adempiere.c_acctschema_default v_liability_services_acct
232 vc_vprepayment_cbpgroup c_validcombination_id adempiere.c_bp_group_acct v_prepayment_acct
233 vc_vprepayment_cbpvendor c_validcombination_id adempiere.c_bp_vendor_acct v_prepayment_acct
234 vc_vprepayment_cschemadefault c_validcombination_id adempiere.c_acctschema_default v_prepayment_acct
235 vc_wdifferences_cschemadefault c_validcombination_id adempiere.c_acctschema_default w_differences_acct
236 vc_wdifferences_mwarehouse c_validcombination_id adempiere.m_warehouse_acct w_differences_acct
237 vc_winvactualadjust_cschemadef c_validcombination_id adempiere.c_acctschema_default w_invactualadjust_acct
238 vc_winvactualadjust_mwarehouse c_validcombination_id adempiere.m_warehouse_acct w_invactualadjust_acct
239 vc_winventory_cschemadefault c_validcombination_id adempiere.c_acctschema_default w_inventory_acct
240 vc_winventory_mwarehouse c_validcombination_id adempiere.m_warehouse_acct w_inventory_acct
241 vc_withholding_cschemadefault c_validcombination_id adempiere.c_acctschema_default withholding_acct
242 vc_withholding_cwithholding c_validcombination_id adempiere.c_withholding_acct withholding_acct
243 vc_wrevaluation_cschemadefault c_validcombination_id adempiere.c_acctschema_default w_revaluation_acct
244 vc_wrevaluation_mwarehouse c_validcombination_id adempiere.m_warehouse_acct w_revaluation_acct
245 vc_writeoff_cbpgroup c_validcombination_id adempiere.c_bp_group_acct writeoff_acct
246 vc_writeoff_cschemadefault c_validcombination_id adempiere.c_acctschema_default writeoff_acct


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 tablename c_validcombination
3 tableowner adempiere
4 tablespace
5 hasindexes True
6 hasrules False
7 hastriggers True