View idempiere9.adempiere.t_invoicegl_v
Gain/Loss

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
c_invoice_id numeric 10  √  null Invoice Identifier
issotrx bpchar 1  √  null This is a Sales Transaction
documentno varchar 30  √  null Document sequence number of the document
docstatus bpchar 2  √  null The current status of the document
c_doctype_id numeric 10  √  null Document type or rules
c_order_id numeric 10  √  null Order
description varchar 255  √  null Optional short description of the record
salesrep_id numeric 10  √  null Sales Representative or Company Agent
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateacct timestamp 29,6  √  null Accounting Date
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
c_currency_id numeric 10  √  null The Currency for this record
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
grandtotal numeric 0  √  null Total amount of document
istaxincluded bpchar 1  √  null Tax is included in the price
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_locto_id numeric 10  √  null Location that inventory was moved to
c_salesregion_id numeric 10  √  null Sales coverage region
fact_acct_id numeric 10  √  null Accounting Fact
c_acctschema_id numeric 10  √  null Rules for accounting
account_id numeric 10  √  null Account used
c_period_id numeric 10  √  null Period of the Calendar
gl_category_id numeric 10  √  null General Ledger Category
gl_budget_id numeric 10  √  null General Ledger Budget
c_tax_id numeric 10  √  null Tax identifier
m_locator_id numeric 10  √  null Warehouse Locator
postingtype bpchar 1  √  null The type of posted amount for the transaction
amtsourcedr numeric 0  √  null Source Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtacctdr numeric 0  √  null Accounted Debit Amount
amtacctcr numeric 0  √  null Accounted Credit Amount
c_uom_id numeric 10  √  null Unit of Measure
qty numeric 0  √  null Quantity
ad_pinstance_id numeric 10  √  null Instance of the process
apar bpchar 1  √  null Include Receivables and/or Payables transactions
openamt numeric 0  √  null Open item amount
percent numeric 0  √  null Percentage
amtrevaldr numeric 0  √  null Revaluated Dr Amount
amtrevalcr numeric 0  √  null Revaluated Cr Amount
datereval timestamp 29,6  √  null Date of Revaluation
c_conversiontypereval_id numeric 10  √  null Revaluation Currency Conversion Type
amtsourcebalance numeric 0  √  null Source Balance Amount
amtacctbalance numeric 0  √  null Accounted Balance Amount
c_doctypereval_id numeric 10  √  null Document Type for Revaluation Journal
amtrevaldrdiff numeric 0  √  null Revaluated Dr Amount Difference
amtrevalcrdiff numeric 0  √  null Revaluated Cr Amount Difference
isallcurrencies bpchar 1  √  null Report not just foreign currency Invoices
amtacctopendr numeric 0  √  null Open Debit in document currency & rate
amtacctopencr numeric 0  √  null Open Credit in document currency & rate
amtacctopenbalance numeric 0  √  null Open Balance in document currency & rate
t_invoicegl_ad_org_id numeric 10  √  null t_invoicegl_ad_org_id
t_invoicegl_c_invoice_id numeric 10  √  null t_invoicegl_c_invoice_id
t_invoicegl_created timestamp 29,6  √  null t_invoicegl_created
t_invoicegl_createdby numeric 10  √  null t_invoicegl_createdby
t_invoicegl_grandtotal numeric 0  √  null t_invoicegl_grandtotal
t_invoicegl_isactive bpchar 1  √  null t_invoicegl_isactive
t_invoicegl_updated timestamp 29,6  √  null t_invoicegl_updated
t_invoicegl_updatedby numeric 10  √  null t_invoicegl_updatedby
c_invoice_c_charge_id numeric 10  √  null c_invoice_c_charge_id
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_dunninglevel_id numeric 10  √  null Dunning Level
chargeamt numeric 0  √  null Charge Amount
c_payment_id numeric 10  √  null Payment identifier
dateordered timestamp 29,6  √  null Date of Order
dateprinted timestamp 29,6  √  null Date the document was printed.
docaction bpchar 2  √  null The targeted status of the document
dunninggrace timestamp 29,6  √  null Dunning Grace Date
generateto bpchar 1  √  null Generate To
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
isapproved bpchar 1  √  null Indicates if this document requires approval
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
isindispute bpchar 1  √  null Document is in dispute
ispaid bpchar 1  √  null The document is paid
ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
isprinted bpchar 1  √  null Indicates if this document / line is printed
istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_rma_id numeric 10  √  null Return Material Authorization
paymentrule bpchar 1  √  null How you pay the invoice
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
posted bpchar 1  √  null Posting status
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
processing bpchar 1  √  null Process Now
ref_invoice_id numeric 10  √  null Referenced Invoice
reversal_id numeric 10  √  null ID of document reversal
sendemail bpchar 1  √  null Enable sending Document EMail
totallines numeric 0  √  null Total of all document lines
a_asset_id numeric 10  √  null Asset used internally or by customers
fact_acct_ad_org_id numeric 10  √  null fact_acct_ad_org_id
fact_acct_ad_orgtrx_id numeric 10  √  null fact_acct_ad_orgtrx_id
fact_acct_ad_table_id numeric 10  √  null fact_acct_ad_table_id
fact_acct_c_activity_id numeric 10  √  null fact_acct_c_activity_id
fact_acct_c_bpartner_id numeric 10  √  null fact_acct_c_bpartner_id
fact_acct_c_campaign_id numeric 10  √  null fact_acct_c_campaign_id
fact_acct_c_currency_id numeric 10  √  null fact_acct_c_currency_id
c_subacct_id numeric 10  √  null Sub account for Element Value
fact_acct_dateacct timestamp 29,6  √  null fact_acct_dateacct
datetrx timestamp 29,6  √  null Transaction Date
fact_acct_description varchar 255  √  null fact_acct_description
fact_acct_isactive bpchar 1  √  null fact_acct_isactive
line_id numeric 10  √  null Transaction line ID (internal)
fact_acct_m_product_id numeric 10  √  null fact_acct_m_product_id
record_id numeric 10  √  null Direct internal record ID
fact_acct_updated timestamp 29,6  √  null fact_acct_updated
fact_acct_updatedby numeric 10  √  null fact_acct_updatedby
fact_acct_user1_id numeric 10  √  null fact_acct_user1_id
fact_acct_user2_id numeric 10  √  null fact_acct_user2_id
userelement1_id numeric 10  √  null User defined accounting Element
userelement2_id numeric 10  √  null User defined accounting Element

Analyzed at 2021-12-25 14:56 +0100