Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
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 |
|
|
c_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
issotrx |
bpchar |
1 |
√ |
|
null |
|
|
documentno |
varchar |
30 |
√ |
|
null |
|
|
docstatus |
bpchar |
2 |
√ |
|
null |
|
|
c_doctype_id |
numeric |
10 |
√ |
|
null |
|
|
c_order_id |
numeric |
10 |
√ |
|
null |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
salesrep_id |
numeric |
10 |
√ |
|
null |
|
|
dateinvoiced |
timestamp |
29,6 |
√ |
|
null |
|
|
dateacct |
timestamp |
29,6 |
√ |
|
null |
|
|
c_paymentterm_id |
numeric |
10 |
√ |
|
null |
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
c_bpartner_location_id |
numeric |
10 |
√ |
|
null |
|
|
ad_user_id |
numeric |
10 |
√ |
|
null |
|
|
isselfservice |
bpchar |
1 |
√ |
|
null |
|
|
c_currency_id |
numeric |
10 |
√ |
|
null |
|
|
c_conversiontype_id |
numeric |
10 |
√ |
|
null |
|
|
grandtotal |
numeric |
0 |
√ |
|
null |
|
|
istaxincluded |
bpchar |
1 |
√ |
|
null |
|
|
c_campaign_id |
numeric |
10 |
√ |
|
null |
|
|
c_project_id |
numeric |
10 |
√ |
|
null |
|
|
c_activity_id |
numeric |
10 |
√ |
|
null |
|
|
ad_orgtrx_id |
numeric |
10 |
√ |
|
null |
|
|
user1_id |
numeric |
10 |
√ |
|
null |
|
|
user2_id |
numeric |
10 |
√ |
|
null |
|
|
c_locfrom_id |
numeric |
10 |
√ |
|
null |
|
|
c_locto_id |
numeric |
10 |
√ |
|
null |
|
|
c_salesregion_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_id |
numeric |
10 |
√ |
|
null |
|
|
c_acctschema_id |
numeric |
10 |
√ |
|
null |
|
|
account_id |
numeric |
10 |
√ |
|
null |
|
|
c_period_id |
numeric |
10 |
√ |
|
null |
|
|
gl_category_id |
numeric |
10 |
√ |
|
null |
|
|
gl_budget_id |
numeric |
10 |
√ |
|
null |
|
|
c_tax_id |
numeric |
10 |
√ |
|
null |
|
|
m_locator_id |
numeric |
10 |
√ |
|
null |
|
|
postingtype |
bpchar |
1 |
√ |
|
null |
|
|
amtsourcedr |
numeric |
0 |
√ |
|
null |
|
|
amtsourcecr |
numeric |
0 |
√ |
|
null |
|
|
amtacctdr |
numeric |
0 |
√ |
|
null |
|
|
amtacctcr |
numeric |
0 |
√ |
|
null |
|
|
c_uom_id |
numeric |
10 |
√ |
|
null |
|
|
qty |
numeric |
0 |
√ |
|
null |
|
|
ad_pinstance_id |
numeric |
10 |
√ |
|
null |
|
|
apar |
bpchar |
1 |
√ |
|
null |
|
|
openamt |
numeric |
0 |
√ |
|
null |
|
|
percent |
numeric |
0 |
√ |
|
null |
|
|
amtrevaldr |
numeric |
0 |
√ |
|
null |
|
|
amtrevalcr |
numeric |
0 |
√ |
|
null |
|
|
datereval |
timestamp |
29,6 |
√ |
|
null |
|
|
c_conversiontypereval_id |
numeric |
10 |
√ |
|
null |
|
|
amtsourcebalance |
numeric |
0 |
√ |
|
null |
|
|
amtacctbalance |
numeric |
0 |
√ |
|
null |
|
|
c_doctypereval_id |
numeric |
10 |
√ |
|
null |
|
|
amtrevaldrdiff |
numeric |
0 |
√ |
|
null |
|
|
amtrevalcrdiff |
numeric |
0 |
√ |
|
null |
|
|
isallcurrencies |
bpchar |
1 |
√ |
|
null |
|
|
amtacctopendr |
numeric |
0 |
√ |
|
null |
|
|
amtacctopencr |
numeric |
0 |
√ |
|
null |
|
|
amtacctopenbalance |
numeric |
0 |
√ |
|
null |
|
|
t_invoicegl_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
t_invoicegl_c_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
t_invoicegl_created |
timestamp |
29,6 |
√ |
|
null |
|
|
t_invoicegl_createdby |
numeric |
10 |
√ |
|
null |
|
|
t_invoicegl_grandtotal |
numeric |
0 |
√ |
|
null |
|
|
t_invoicegl_isactive |
bpchar |
1 |
√ |
|
null |
|
|
t_invoicegl_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
t_invoicegl_updatedby |
numeric |
10 |
√ |
|
null |
|
|
c_invoice_c_charge_id |
numeric |
10 |
√ |
|
null |
|
|
c_doctypetarget_id |
numeric |
10 |
√ |
|
null |
|
|
c_dunninglevel_id |
numeric |
10 |
√ |
|
null |
|
|
chargeamt |
numeric |
0 |
√ |
|
null |
|
|
c_payment_id |
numeric |
10 |
√ |
|
null |
|
|
dateordered |
timestamp |
29,6 |
√ |
|
null |
|
|
dateprinted |
timestamp |
29,6 |
√ |
|
null |
|
|
docaction |
bpchar |
2 |
√ |
|
null |
|
|
dunninggrace |
timestamp |
29,6 |
√ |
|
null |
|
|
generateto |
bpchar |
1 |
√ |
|
null |
|
|
invoicecollectiontype |
bpchar |
1 |
√ |
|
null |
|
|
isapproved |
bpchar |
1 |
√ |
|
null |
|
|
isdiscountprinted |
bpchar |
1 |
√ |
|
null |
|
|
isindispute |
bpchar |
1 |
√ |
|
null |
|
|
ispaid |
bpchar |
1 |
√ |
|
null |
|
|
ispayschedulevalid |
bpchar |
1 |
√ |
|
null |
|
|
isprinted |
bpchar |
1 |
√ |
|
null |
|
|
istransferred |
bpchar |
1 |
√ |
|
null |
|
|
m_pricelist_id |
numeric |
10 |
√ |
|
null |
|
|
m_rma_id |
numeric |
10 |
√ |
|
null |
|
|
paymentrule |
bpchar |
1 |
√ |
|
null |
|
|
poreference |
varchar |
20 |
√ |
|
null |
|
|
posted |
bpchar |
1 |
√ |
|
null |
|
|
processedon |
numeric |
0 |
√ |
|
null |
|
|
processing |
bpchar |
1 |
√ |
|
null |
|
|
ref_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
reversal_id |
numeric |
10 |
√ |
|
null |
|
|
sendemail |
bpchar |
1 |
√ |
|
null |
|
|
totallines |
numeric |
0 |
√ |
|
null |
|
|
a_asset_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_ad_orgtrx_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_ad_table_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_c_activity_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_c_campaign_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_c_currency_id |
numeric |
10 |
√ |
|
null |
|
|
c_subacct_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_dateacct |
timestamp |
29,6 |
√ |
|
null |
|
|
datetrx |
timestamp |
29,6 |
√ |
|
null |
|
|
fact_acct_description |
varchar |
255 |
√ |
|
null |
|
|
fact_acct_isactive |
bpchar |
1 |
√ |
|
null |
|
|
line_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_m_product_id |
numeric |
10 |
√ |
|
null |
|
|
record_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
fact_acct_updatedby |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_user1_id |
numeric |
10 |
√ |
|
null |
|
|
fact_acct_user2_id |
numeric |
10 |
√ |
|
null |
|
|
userelement1_id |
numeric |
10 |
√ |
|
null |
|
|
userelement2_id |
numeric |
10 |
√ |
|
null |
|
|
Analyzed at 2024-01-03 13:56 +0100
|