gl_journalline_id |
numeric |
10 |
|
|
|
i_fajournal.gl_journalline_id
|
gljournalline_ifajournal R |
i_gljournal.gl_journalline_id
|
gljourbelline_igljournal N |
|
|
ad_client_id |
numeric |
10 |
|
|
|
|
|
ad_org_id |
numeric |
10 |
|
|
|
|
ad_org.ad_org_id
|
adorg_gljournalline R |
|
isactive |
bpchar |
1 |
|
|
'Y'::bpchar |
|
|
created |
timestamp |
29,6 |
|
|
now() |
|
|
createdby |
numeric |
10 |
|
|
|
|
|
updated |
timestamp |
29,6 |
|
|
now() |
|
|
updatedby |
numeric |
10 |
|
|
|
|
|
gl_journal_id |
numeric |
10 |
|
|
|
|
gl_journal.gl_journal_id
|
gljournal_gljournalline C |
|
line |
numeric |
10 |
|
|
|
|
|
isgenerated |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
amtsourcedr |
numeric |
0 |
|
|
0 |
|
|
amtsourcecr |
numeric |
0 |
|
|
0 |
|
|
c_currency_id |
numeric |
10 |
|
|
|
|
c_currency.c_currency_id
|
ccurrency_gljournalline R |
|
currencyrate |
numeric |
0 |
|
|
0 |
|
|
dateacct |
timestamp |
29,6 |
|
|
|
|
|
amtacctdr |
numeric |
0 |
|
|
0 |
|
|
amtacctcr |
numeric |
0 |
|
|
0 |
|
|
c_uom_id |
numeric |
10 |
√ |
|
null |
|
c_uom.c_uom_id
|
cuom_gljournalline R |
|
qty |
numeric |
0 |
√ |
|
0 |
|
|
c_validcombination_id |
numeric |
10 |
√ |
|
null |
|
|
c_conversiontype_id |
numeric |
10 |
|
|
|
|
|
processed |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
a_asset_group_id |
numeric |
10 |
√ |
|
null |
|
|
a_asset_id |
numeric |
10 |
√ |
|
null |
|
|
a_createasset |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
a_processed |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
gl_journalline_uu |
varchar |
36 |
√ |
|
NULL::character varying |
|
|
ad_orgtrx_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
ad_org.ad_org_id
|
adorgtrx_gljournalline R |
|
account_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
c_activity_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
c_activity.c_activity_id
|
cactivity_gljournalline R |
|
c_bpartner_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
c_bpartner.c_bpartner_id
|
cbpartner_gljournalline R |
|
c_campaign_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
c_campaign.c_campaign_id
|
ccampaign_gljournalline R |
|
c_locfrom_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
c_locto_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
c_project_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
c_project.c_project_id
|
cproject_gljournalline R |
|
c_salesregion_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
c_subacct_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
m_product_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
m_product.m_product_id
|
mproduct_gljournalline R |
|
user1_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
user2_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
alias_validcombination_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|