SchemaSpy Analysis of idempiere11.adempiere - ColumnsCurrency | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:48 +0100 |
| |||||
|
idempiere11.adempiere contains 580 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
c_acctschema | costinglevel | bpchar | 1 | 'C'::bpchar | The lowest level to accumulate Costing Information | ||
gl_journalline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
gl_journalline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
i_conversion_rate | createreciprocalrate | bpchar | 1 | √ | 'N'::bpchar | Create Reciprocal Rate from current information | |
i_conversion_rate | i_isimported | bpchar | 1 | √ | 'N'::bpchar | Has this import been processed | |
i_gljournal | iscreatenewbatch | bpchar | 1 | √ | 'N'::bpchar | If selected a new batch is created | |
i_gljournal | iscreatenewjournal | bpchar | 1 | √ | 'N'::bpchar | If selected a new journal within the batch is created | |
gl_journal | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_conversion_rate | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_gljournal | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
c_acctschema | autoperiodcontrol | bpchar | 1 | 'N'::bpchar | If selected, the periods are automatically opened and closed | ||
c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
i_gljournal | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
c_acctschema | isadjustcogs | bpchar | 1 | 'N'::bpchar | Adjust Cost of Good Sold | ||
c_payment | isallocated | bpchar | 1 | 'N'::bpchar | Indicates if the payment has been allocated | ||
c_invoice | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_order | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_payment | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
gl_journal | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | Credit has been approved | ||
c_conversiontype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_payment | isdelayedcapture | bpchar | 1 | 'N'::bpchar | Charge after Shipment | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
c_acctschema | isdiscountcorrectstax | bpchar | 1 | 'N'::bpchar | Correct the tax for payment discount and charges | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
c_currency | isemumember | bpchar | 1 | 'N'::bpchar | This currency is member if the European Monetary Union | ||
c_currency | iseuro | bpchar | 1 | 'N'::bpchar | This currency is the Euro | ||
c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | Post the cost adjustment explicitly | ||
gl_journalline | isgenerated | bpchar | 1 | 'N'::bpchar | This Line is generated | ||
m_discountschemaline | isignoreiscurrentvendor | bpchar | 1 | 'N'::bpchar | take all PO prices into account | ||
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
c_payment | isonline | bpchar | 1 | 'N'::bpchar | Can be accessed online | ||
c_invoice | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | Override Currency Conversion Rate | ||
c_payment | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | Override Currency Conversion Rate | ||
c_invoice | ispaid | bpchar | 1 | 'N'::bpchar | The document is fully paid | ||
c_invoice | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
c_acctschema | ispostservices | bpchar | 1 | 'N'::bpchar | Differentiate between Services and Product Receivable/Payables | ||
c_payment | isprepayment | bpchar | 1 | 'N'::bpchar | The Payment/Receipt is a Prepayment | ||
c_invoice | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
c_order | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
gl_journal | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | Privileged Rate | ||
c_payment | isreconciled | bpchar | 1 | 'N'::bpchar | Payment is reconciled with bank statement | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | Selected | ||
c_invoice | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_payment | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_invoice | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | Generate postings for trade discounts | ||
c_invoice | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
c_order | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
c_payment | isvoided | bpchar | 1 | 'N'::bpchar | Voided | ||
c_invoice | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_order | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_payment | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
gl_journal | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_invoice | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_order | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_payment | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
gl_journalline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_order | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
i_conversion_rate | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_gljournal | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | Allow to post negative accounting values | |
c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | This flag controls if Adempiere must post when clearing (transit) and final accounts are the same | |
c_acctschema | hasalias | bpchar | 1 | 'Y'::bpchar | Ability to select (partial) account combinations by an Alias | ||
c_acctschema | hascombination | bpchar | 1 | 'Y'::bpchar | Combination of account elements are checked | ||
c_acctschema | isaccrual | bpchar | 1 | 'Y'::bpchar | Indicates if Accrual or Cash Based accounting will be used | ||
c_acctschema | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_conversion_rate | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_conversiontype | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_currency | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_currency_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoice | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_order | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_payment | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_journal | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_journalline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_discountschemaline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_payment | isoverunderpayment | bpchar | 1 | 'Y'::bpchar | Over-Payment (unallocated) or Under-Payment (partial payment) | ||
c_payment | isreceipt | bpchar | 1 | 'Y'::bpchar | This is a sales transaction (receipt) | ||
c_invoice | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
c_order | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
i_gljournal | amtacctcr | numeric | 0 | √ | 0 | Accounted Credit Amount | |
i_gljournal | amtacctdr | numeric | 0 | √ | 0 | Accounted Debit Amount | |
i_gljournal | amtsourcecr | numeric | 0 | √ | 0 | Source Credit Amount | |
i_gljournal | amtsourcedr | numeric | 0 | √ | 0 | Source Debit Amount | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_order | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_payment | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
gl_journal | controlamt | numeric | 0 | √ | 0 | If not zero, the Debit amount of the document must be equal this amount | |
i_gljournal | currencyrate | numeric | 0 | √ | 0 | Currency Conversion Rate | |
c_payment | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
c_currency | emurate | numeric | 0 | √ | 0 | Official rate to the Euro | |
c_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
m_discountschemaline | limit_fixed | numeric | 0 | √ | 0 | Fixed Limit Price (not calculated) | |
m_discountschemaline | list_fixed | numeric | 0 | √ | 0 | Fixes List Price (not calculated) | |
c_payment | overunderamt | numeric | 0 | √ | 0 | Over-Payment (unallocated) or Under-Payment (partial payment) Amount | |
gl_journalline | qty | numeric | 0 | √ | 0 | Quantity | |
i_gljournal | qty | numeric | 0 | √ | 0 | Quantity | |
m_discountschemaline | std_fixed | numeric | 0 | √ | 0 | Fixed Standard Price (not calculated) | |
c_payment | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_payment | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
gl_journalline | amtacctcr | numeric | 0 | 0 | Accounted Credit Amount | ||
gl_journalline | amtacctdr | numeric | 0 | 0 | Accounted Debit Amount | ||
gl_journalline | amtsourcecr | numeric | 0 | 0 | Source Credit Amount | ||
gl_journalline | amtsourcedr | numeric | 0 | 0 | Source Debit Amount | ||
gl_journal | currencyrate | numeric | 0 | 0 | Currency Conversion Rate | ||
gl_journalline | currencyrate | numeric | 0 | 0 | Currency Conversion Rate | ||
c_conversion_rate | dividerate | numeric | 0 | 0 | To convert Source number to Target number, the Source is divided | ||
c_invoice | grandtotal | numeric | 0 | 0 | Total amount of document | ||
c_order | grandtotal | numeric | 0 | 0 | Total amount of document | ||
m_discountschemaline | limit_addamt | numeric | 0 | 0 | Amount added to the converted/copied price before multiplying | ||
m_discountschemaline | limit_maxamt | numeric | 0 | 0 | Maximum difference to original limit price; ignored if zero | ||
m_discountschemaline | limit_minamt | numeric | 0 | 0 | Minimum difference to original limit price; ignored if zero | ||
m_discountschemaline | list_addamt | numeric | 0 | 0 | List Price Surcharge Amount | ||
m_discountschemaline | list_maxamt | numeric | 0 | 0 | Maximum margin for a product | ||
m_discountschemaline | list_minamt | numeric | 0 | 0 | Minimum margin for a product | ||
c_conversion_rate | multiplyrate | numeric | 0 | 0 | Rate to multiple the source by to calculate the target. | ||
c_payment | payamt | numeric | 0 | 0 | Amount being paid | ||
m_discountschemaline | std_addamt | numeric | 0 | 0 | Amount added to a price as a surcharge | ||
m_discountschemaline | std_maxamt | numeric | 0 | 0 | Maximum margin allowed for a product | ||
m_discountschemaline | std_minamt | numeric | 0 | 0 | Minimum margin allowed for a product | ||
gl_journal | totalcr | numeric | 0 | 0 | Total Credit in document currency | ||
gl_journal | totaldr | numeric | 0 | 0 | Total debit in document currency | ||
c_invoice | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_order | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_acctschema | created | timestamp | 29,6 | now() | Date this record was created | ||
c_conversion_rate | created | timestamp | 29,6 | now() | Date this record was created | ||
c_conversiontype | created | timestamp | 29,6 | now() | Date this record was created | ||
c_currency | created | timestamp | 29,6 | now() | Date this record was created | ||
c_currency_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoice | created | timestamp | 29,6 | now() | Date this record was created | ||
c_order | created | timestamp | 29,6 | now() | Date this record was created | ||
c_payment | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_journal | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_journalline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_discountschemaline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_acctschema | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_conversion_rate | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_conversiontype | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_currency | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_currency_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoice | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_order | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_payment | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journal | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journalline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_discountschemaline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journalline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
gl_journalline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
c_payment | a_city | varchar | 60 | √ | null | City or the Credit Card or Account Holder | |
c_payment | a_country | varchar | 40 | √ | null | Country | |
c_payment | a_email | varchar | 60 | √ | null | Email Address | |
c_payment | a_ident_dl | varchar | 20 | √ | null | Payment Identification - Driver License | |
c_payment | a_ident_ssn | varchar | 20 | √ | null | Payment Identification - Social Security No | |
c_payment | a_name | varchar | 60 | √ | null | Name on Credit Card or Account holder | |
c_payment | a_state | varchar | 40 | √ | null | State of the Credit Card or Account holder | |
c_payment | a_street | varchar | 60 | √ | null | Street address of the Credit Card or Account holder | |
c_payment | a_zip | varchar | 20 | √ | null | Zip Code of the Credit Card or Account Holder | |
i_gljournal | account_id | numeric | 10 | √ | null | Account used | |
c_payment | accountno | varchar | 20 | √ | null | Account Number | |
i_gljournal | accountvalue | varchar | 40 | √ | null | Key of Account Element | |
i_gljournal | acctschemaname | varchar | 60 | √ | null | Name of the Accounting Schema | |
i_conversion_rate | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_gljournal | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_conversion_rate | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_gljournal | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_gljournal | ad_orgdoc_id | numeric | 10 | √ | null | Document Organization (independent from account organization) | |
c_acctschema | ad_orgonly_id | numeric | 10 | √ | null | Create posting entries only for this organization | |
c_invoice | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_payment | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
i_gljournal | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoice | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_order | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_order | amountrefunded | numeric | 22,2 | √ | null | Amount Refunded | |
c_order | amounttendered | numeric | 22,2 | √ | null | Amount Tendered | |
i_gljournal | batchdescription | varchar | 255 | √ | null | Description of the Batch | |
i_gljournal | batchdocumentno | varchar | 30 | √ | null | Document Number of the Batch | |
c_order | bill_bpartner_id | numeric | 10 | √ | null | Business Partner to be invoiced | |
c_order | bill_location_id | numeric | 10 | √ | null | Business Partner Location for invoicing | |
c_order | bill_user_id | numeric | 10 | √ | null | Business Partner Contact for invoicing | |
i_gljournal | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_gljournal | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
c_invoice | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_order | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_payment | c_activity_id | numeric | 10 | √ | null | Business Activity | |
i_gljournal | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_payment | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
c_payment | c_bp_bankaccount_id | numeric | 10 | √ | null | Bank Account of the Business Partner | |
c_payment | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_gljournal | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
m_discountschemaline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_invoice | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_payment | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
i_gljournal | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_payment | c_cashbook_id | numeric | 10 | √ | null | Cash Book for recording petty cash transactions | |
c_invoice | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_order | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_invoice | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_payment | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
i_conversion_rate | c_conversion_rate_id | numeric | 10 | √ | null | Rate used for converting currencies | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_payment | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
i_conversion_rate | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
i_gljournal | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
gl_journal | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_conversion_rate | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_gljournal | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_conversion_rate | c_currency_id_to | numeric | 10 | √ | null | Target currency | |
i_gljournal | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
c_invoice | c_dunninglevel_id | numeric | 10 | √ | null | Dunning Level | |
c_payment | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
i_gljournal | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
i_gljournal | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
c_invoice | c_order_id | numeric | 10 | √ | null | Order | |
c_payment | c_order_id | numeric | 10 | √ | null | Order | |
c_order | c_ordersource_id | numeric | 10 | √ | null | Order Source | |
c_invoice | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_order | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_payment | c_paymentbatch_id | numeric | 10 | √ | null | Payment batch for EFT | |
c_acctschema | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
i_gljournal | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
c_order | c_pos_id | numeric | 10 | √ | null | Point of Sales Terminal | |
c_invoice | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_payment | c_project_id | numeric | 10 | √ | null | Financial Project | |
i_gljournal | c_project_id | numeric | 10 | √ | null | Financial Project | |
i_gljournal | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
gl_journalline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_gljournal | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
gl_journalline | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
i_gljournal | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
i_gljournal | categoryname | varchar | 60 | √ | null | Name of the Category | |
c_payment | checkno | varchar | 20 | √ | null | Check Number | |
m_discountschemaline | classification | varchar | 12 | √ | null | Classification for grouping | |
i_gljournal | clientvalue | varchar | 40 | √ | null | Key of the Tenant | |
i_conversion_rate | conversiontypevalue | varchar | 40 | √ | null | Key value for the Currency Conversion Rate Type | |
i_gljournal | conversiontypevalue | varchar | 40 | √ | null | Key value for the Currency Conversion Rate Type | |
c_payment | convertedamt | numeric | 0 | √ | null | Converted Amount | |
c_invoice | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_order | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
i_conversion_rate | createdby | numeric | 10 | √ | null | User who created this records | |
i_gljournal | createdby | numeric | 10 | √ | null | User who created this records | |
c_invoice | createfrom | bpchar | 1 | √ | null | Process which will generate a new document lines based on an existing document | |
c_payment | creditcardexpmm | numeric | 10 | √ | null | Expiry Month | |
c_payment | creditcardexpyy | numeric | 10 | √ | null | Expiry Year | |
c_payment | creditcardnumber | varchar | 20 | √ | null | Credit Card Number | |
c_payment | creditcardtype | bpchar | 1 | √ | null | Credit Card (Visa, MC, AmEx) | |
c_payment | creditcardvv | varchar | 4 | √ | null | Credit Card Verification code on credit card | |
c_invoice | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
c_payment | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
c_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
i_gljournal | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
c_invoice | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
c_acctschema | description | varchar | 255 | √ | null | Optional short description of the record | |
c_conversiontype | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoice | description | varchar | 255 | √ | null | Optional short description of the record | |
c_order | description | varchar | 255 | √ | null | Optional short description of the record | |
c_payment | description | varchar | 255 | √ | null | Optional short description of the record | |
gl_journalline | description | varchar | 255 | √ | null | Optional short description of the record | |
i_gljournal | description | varchar | 255 | √ | null | Optional short description of the record | |
i_conversion_rate | dividerate | numeric | 0 | √ | null | To convert Source number to Target number, the Source is divided | |
i_gljournal | doctypename | varchar | 60 | √ | null | Name of the Document Type | |
c_order | dropship_bpartner_id | numeric | 10 | √ | null | Business Partner to ship to | |
c_order | dropship_location_id | numeric | 10 | √ | null | Business Partner Location for shipping to | |
c_order | dropship_user_id | numeric | 10 | √ | null | Business Partner Contact for drop shipment | |
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_currency | emuentrydate | timestamp | 29,6 | √ | null | Date when the currency joined / will join the EMU | |
c_invoice | generateto | bpchar | 1 | √ | null | Generate To | |
gl_journal | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
i_gljournal | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
i_gljournal | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
i_gljournal | gl_journal_id | numeric | 10 | √ | null | General Ledger Journal | |
gl_journal | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
i_gljournal | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
i_gljournal | gl_journalline_id | numeric | 10 | √ | null | General Ledger Journal Line | |
m_discountschemaline | group1 | varchar | 255 | √ | null | Group1 | |
m_discountschemaline | group2 | varchar | 255 | √ | null | Group2 | |
i_conversion_rate | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_gljournal | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | Invoice Collection Status | |
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
i_conversion_rate | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_gljournal | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_conversion_rate | iso_code_to | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the To Currency | |
i_gljournal | journaldocumentno | varchar | 30 | √ | null | Document number of the Journal | |
i_gljournal | line | numeric | 10 | √ | null | Unique line for this document | |
c_order | link_order_id | numeric | 10 | √ | null | This field links a sales order to the purchase order that is generated from it. | |
c_acctschema | m_costtype_id | numeric | 10 | √ | null | Type of Cost (e.g. Current, Plan, Future) | |
m_discountschemaline | m_product_category_id | numeric | 10 | √ | null | Category of a Product | |
i_gljournal | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_discountschemaline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_invoice | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
c_order | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
c_payment | micr | varchar | 20 | √ | null | Combination of routing no, account and check no | |
i_conversion_rate | multiplyrate | numeric | 0 | √ | null | Rate to multiple the source by to calculate the target. | |
c_payment | oprocessing | bpchar | 1 | √ | null | This payment can be processed online | |
c_order | ordertype | varchar | 510 | √ | null | Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition) | |
i_gljournal | orgtrxvalue | varchar | 40 | √ | null | Key of the Transaction Organization | |
i_gljournal | orgvalue | varchar | 40 | √ | null | Key of the Organization | |
c_payment | orig_trxid | varchar | 20 | √ | null | Original Transaction ID | |
c_order | pay_bpartner_id | numeric | 10 | √ | null | Business Partner responsible for the payment | |
c_order | pay_location_id | numeric | 10 | √ | null | Location of the Business Partner responsible for the payment | |
c_acctschema | period_openfuture | numeric | 10 | √ | null | Number of days to be able to post to a future date (based on system date) | |
c_acctschema | period_openhistory | numeric | 10 | √ | null | Number of days to be able to post in the past (based on system date) | |
c_payment | ponum | varchar | 60 | √ | null | Purchase Order Number | |
c_invoice | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_order | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
i_gljournal | postingtype | bpchar | 1 | √ | null | The type of posted amount for the transaction | |
c_invoice | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_order | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_payment | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
gl_journal | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_acctschema | processing | bpchar | 1 | √ | null | Process Now | |
c_invoice | processing | bpchar | 1 | √ | null | Process Now | |
c_order | processing | bpchar | 1 | √ | null | Process Now | |
c_payment | processing | bpchar | 1 | √ | null | Process Now | |
gl_journal | processing | bpchar | 1 | √ | null | Process Now | |
i_conversion_rate | processing | bpchar | 1 | √ | null | Process Now | |
i_gljournal | processing | bpchar | 1 | √ | null | Process Now | |
i_gljournal | productvalue | varchar | 40 | √ | null | Key of the Product | |
i_gljournal | projectvalue | varchar | 40 | √ | null | Key of the Project | |
c_order | promotioncode | varchar | 30 | √ | null | User entered promotion code at sales time | |
c_payment | r_authcode | varchar | 20 | √ | null | Authorization Code returned | |
c_payment | r_authcode_dc | varchar | 20 | √ | null | Authorization Code Delayed Capture returned | |
c_payment | r_avsaddr | bpchar | 1 | √ | null | This address has been verified | |
c_payment | r_avszip | bpchar | 1 | √ | null | The Zip Code has been verified | |
c_payment | r_cvv2match | bpchar | 1 | √ | null | Credit Card Verification Code Match | |
c_payment | r_info | varchar | 2000 | √ | null | Response info | |
c_payment | r_pnref | varchar | 20 | √ | null | Payment reference | |
c_payment | r_pnref_dc | varchar | 20 | √ | null | Payment Reference Delayed Capture | |
c_payment | r_respmsg | varchar | 60 | √ | null | Response message | |
c_payment | r_result | varchar | 20 | √ | null | Result of transmission | |
c_currency_acct | realizedgain_acct | numeric | 10 | √ | null | Realized Gain Account | |
c_currency_acct | realizedloss_acct | numeric | 10 | √ | null | Realized Loss Account | |
c_invoice | ref_invoice_id | numeric | 10 | √ | null | Referenced Invoice | |
c_order | ref_order_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
c_payment | ref_payment_id | numeric | 10 | √ | null | Referenced Payment | |
c_invoice | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
c_payment | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
gl_journal | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
c_payment | routingno | varchar | 20 | √ | null | Bank Routing Number | |
c_invoice | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_order | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
i_gljournal | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
c_payment | swipe | varchar | 80 | √ | null | Track 1 and 2 of the Credit Card | |
c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
c_currency_acct | unrealizedgain_acct | numeric | 10 | √ | null | Unrealized Gain Account for currency revaluation | |
c_currency_acct | unrealizedloss_acct | numeric | 10 | √ | null | Unrealized Loss Account for currency revaluation | |
i_gljournal | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_conversion_rate | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_gljournal | updatedby | numeric | 10 | √ | null | User who updated this records | |
c_invoice | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_order | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_payment | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
i_gljournal | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoice | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_order | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_payment | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
i_gljournal | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
i_conversion_rate | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
c_conversion_rate | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
i_conversion_rate | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
c_payment | voiceauthcode | varchar | 20 | √ | null | Voice Authorization Code from credit card company | |
c_order | volume | numeric | 0 | √ | null | Volume of a product | |
c_order | weight | numeric | 0 | √ | null | Weight of a product | |
c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_conversion_rate | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_conversiontype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_order | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_journal | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_journalline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_discountschemaline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_conversion_rate | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_conversiontype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_order | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_journal | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_journalline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_discountschemaline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctschema | c_acctschema_id | numeric | 10 | Rules for accounting | |||
c_currency_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
gl_journal | c_acctschema_id | numeric | 10 | Rules for accounting | |||
c_invoice | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_invoice | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_order | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_conversion_rate | c_conversion_rate_id | numeric | 10 | Rate used for converting currencies | |||
c_conversion_rate | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
c_conversiontype | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
gl_journal | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
gl_journalline | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
m_discountschemaline | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
c_acctschema | c_currency_id | numeric | 10 | The Currency for this record | |||
c_conversion_rate | c_currency_id | numeric | 10 | The Currency for this record | |||
c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
c_currency_acct | c_currency_id | numeric | 10 | The Currency for this record | |||
c_invoice | c_currency_id | numeric | 10 | The Currency for this record | |||
c_order | c_currency_id | numeric | 10 | The Currency for this record | |||
c_payment | c_currency_id | numeric | 10 | The Currency for this record | |||
gl_journalline | c_currency_id | numeric | 10 | The Currency for this record | |||
c_conversion_rate | c_currency_id_to | numeric | 10 | Target currency | |||
c_invoice | c_doctype_id | numeric | 10 | Document type or rules | |||
c_order | c_doctype_id | numeric | 10 | Document type or rules | |||
c_payment | c_doctype_id | numeric | 10 | Document type or rules | |||
gl_journal | c_doctype_id | numeric | 10 | Document type or rules | |||
c_invoice | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_order | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_invoice | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_order | c_order_id | numeric | 10 | Order | |||
c_payment | c_payment_id | numeric | 10 | Payment identifier | |||
c_invoice | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_order | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
gl_journal | c_period_id | numeric | 10 | Period of the Calendar | |||
m_discountschemaline | conversiondate | timestamp | 29,6 | Date for selecting conversion rate | |||
c_acctschema | costingmethod | bpchar | 1 | Indicates how Costs will be calculated | |||
c_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
c_acctschema | createdby | numeric | 10 | User who created this records | |||
c_conversion_rate | createdby | numeric | 10 | User who created this records | |||
c_conversiontype | createdby | numeric | 10 | User who created this records | |||
c_currency | createdby | numeric | 10 | User who created this records | |||
c_currency_acct | createdby | numeric | 10 | User who created this records | |||
c_invoice | createdby | numeric | 10 | User who created this records | |||
c_order | createdby | numeric | 10 | User who created this records | |||
c_payment | createdby | numeric | 10 | User who created this records | |||
gl_journal | createdby | numeric | 10 | User who created this records | |||
gl_journalline | createdby | numeric | 10 | User who created this records | |||
m_discountschemaline | createdby | numeric | 10 | User who created this records | |||
c_invoice | dateacct | timestamp | 29,6 | Accounting Date | |||
c_order | dateacct | timestamp | 29,6 | Accounting Date | |||
c_payment | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journal | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journalline | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journal | datedoc | timestamp | 29,6 | Date of the Document | |||
c_invoice | dateinvoiced | timestamp | 29,6 | Date printed on Invoice | |||
c_order | dateordered | timestamp | 29,6 | Date of Order | |||
c_payment | datetrx | timestamp | 29,6 | Transaction Date | |||
c_order | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
c_order | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
c_currency | description | varchar | 255 | Optional short description of the record | |||
gl_journal | description | varchar | 255 | Optional short description of the record | |||
c_invoice | docaction | bpchar | 2 | The targeted status of the document | |||
c_order | docaction | bpchar | 2 | The targeted status of the document | |||
c_payment | docaction | bpchar | 2 | The targeted status of the document | |||
gl_journal | docaction | bpchar | 2 | The targeted status of the document | |||
c_invoice | docstatus | bpchar | 2 | The current status of the document | |||
c_order | docstatus | bpchar | 2 | The current status of the document | |||
c_payment | docstatus | bpchar | 2 | The current status of the document | |||
gl_journal | docstatus | bpchar | 2 | The current status of the document | |||
c_invoice | documentno | varchar | 30 | Document sequence number of the document | |||
c_order | documentno | varchar | 30 | Document sequence number of the document | |||
c_payment | documentno | varchar | 30 | Document sequence number of the document | |||
gl_journal | documentno | varchar | 30 | Document sequence number of the document | |||
c_order | freightcostrule | bpchar | 1 | Method for charging Freight | |||
c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
gl_journal | gl_category_id | numeric | 10 | General Ledger Category | |||
gl_journal | gl_journal_id | numeric | 10 | General Ledger Journal | |||
gl_journalline | gl_journal_id | numeric | 10 | General Ledger Journal | |||
gl_journalline | gl_journalline_id | numeric | 10 | General Ledger Journal Line | |||
i_conversion_rate | i_conversion_rate_id | numeric | 10 | Import Currency Conversion Rate | |||
i_gljournal | i_gljournal_id | numeric | 10 | Import General Ledger Journal | |||
c_order | invoicerule | bpchar | 1 | Frequency and method of invoicing | |||
c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
m_discountschemaline | limit_base | bpchar | 1 | Base price for calculation of the new price | |||
m_discountschemaline | limit_discount | numeric | 0 | Discount in percent to be subtracted from base, if negative it will be added to base price | |||
m_discountschemaline | limit_rounding | bpchar | 1 | Rounding of the final result | |||
gl_journalline | line | numeric | 10 | Unique line for this document | |||
m_discountschemaline | list_base | bpchar | 1 | Price used as the basis for price list calculations | |||
m_discountschemaline | list_discount | numeric | 0 | Discount from list price as a percentage | |||
m_discountschemaline | list_rounding | bpchar | 1 | Rounding rule for final list price | |||
m_discountschemaline | m_discountschema_id | numeric | 10 | Schema to calculate the trade discount percentage | |||
m_discountschemaline | m_discountschemaline_id | numeric | 10 | Line of the price list trade discount schema | |||
c_invoice | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_order | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_order | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
c_acctschema | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_conversiontype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_invoice | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_order | paymentrule | bpchar | 1 | How you pay the invoice | |||
gl_journal | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
c_order | priorityrule | bpchar | 1 | Priority of a document | |||
c_acctschema | separator | bpchar | 1 | Element Separator | |||
m_discountschemaline | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
m_discountschemaline | std_base | bpchar | 1 | Base price for calculating new standard price | |||
m_discountschemaline | std_discount | numeric | 0 | Discount percentage to subtract from base price | |||
m_discountschemaline | std_rounding | bpchar | 1 | Rounding rule for calculated price | |||
c_currency | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
c_payment | tendertype | bpchar | 1 | Method of Payment | |||
c_payment | trxtype | bpchar | 1 | Type of credit card transaction | |||
c_acctschema | updatedby | numeric | 10 | User who updated this records | |||
c_conversion_rate | updatedby | numeric | 10 | User who updated this records | |||
c_conversiontype | updatedby | numeric | 10 | User who updated this records | |||
c_currency | updatedby | numeric | 10 | User who updated this records | |||
c_currency_acct | updatedby | numeric | 10 | User who updated this records | |||
c_invoice | updatedby | numeric | 10 | User who updated this records | |||
c_order | updatedby | numeric | 10 | User who updated this records | |||
c_payment | updatedby | numeric | 10 | User who updated this records | |||
gl_journal | updatedby | numeric | 10 | User who updated this records | |||
gl_journalline | updatedby | numeric | 10 | User who updated this records | |||
m_discountschemaline | updatedby | numeric | 10 | User who updated this records | |||
c_conversion_rate | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
c_conversiontype | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
gl_journal | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
c_invoice | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | Rate Inquiry | |
i_gljournal | activityvalue | varchar | 40 | √ | NULL::character varying | Text key for Activity | |
c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
c_conversion_rate | c_conversion_rate_uu | varchar | 36 | √ | NULL::character varying | C_Conversion_Rate_UU | |
c_conversiontype | c_conversiontype_uu | varchar | 36 | √ | NULL::character varying | C_ConversionType_UU | |
c_currency_acct | c_currency_acct_uu | varchar | 36 | √ | NULL::character varying | C_Currency_Acct_UU | |
c_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | C_Invoice_UU | |
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | C_Order_UU | |
c_payment | c_payment_uu | varchar | 36 | √ | NULL::character varying | C_Payment_UU | |
i_gljournal | campaignvalue | varchar | 40 | √ | NULL::character varying | Text key of the Campaign | |
c_payment | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
c_payment | customerpaymentprofileid | varchar | 60 | √ | NULL::character varying | Customer Payment Profile ID | |
c_payment | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
m_discountschemaline | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
gl_journal | gl_journal_uu | varchar | 36 | √ | NULL::character varying | GL_Journal_UU | |
gl_journalline | gl_journalline_uu | varchar | 36 | √ | NULL::character varying | GL_JournalLine_UU | |
i_conversion_rate | i_conversion_rate_uu | varchar | 36 | √ | NULL::character varying | I_Conversion_Rate_UU | |
i_gljournal | i_gljournal_uu | varchar | 36 | √ | NULL::character varying | I_GLJournal_UU | |
c_payment | iban | varchar | 40 | √ | NULL::character varying | International Bank Account Number | |
m_discountschemaline | m_discountschemaline_uu | varchar | 36 | √ | NULL::character varying | M_DiscountSchemaLine_UU | |
c_payment | r_voidmsg | varchar | 255 | √ | NULL::character varying | Void Message | |
i_gljournal | salesregionvalue | varchar | 40 | √ | NULL::character varying | Text key of the Sales Region | |
c_payment | swiftcode | varchar | 20 | √ | NULL::character varying | Swift Code or BIC | |
m_discountschemaline | vendorcategory | varchar | 30 | √ | NULL::character varying | Product Category of the Business Partner | |
gl_journalline | account_id | numeric | 10 | √ | NULL::numeric | Account used | |
gl_journalline | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
gl_journalline | alias_validcombination_id | numeric | 10 | √ | NULL::numeric | Valid Account Alias List | |
gl_journalline | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
c_payment | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | Bank Transfer | |
gl_journalline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
gl_journalline | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
c_invoice | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_payment | c_depositbatch_id | numeric | 10 | √ | NULL::numeric | Deposit Batch | |
gl_journalline | c_locfrom_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved from | |
gl_journalline | c_locto_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved to | |
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | Sales Opportunity | |
c_payment | c_paymentprocessor_id | numeric | 10 | √ | NULL::numeric | Payment processor for electronic payments | |
c_payment | c_postendertype_id | numeric | 10 | √ | NULL::numeric | POS Tender Type | |
gl_journalline | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
gl_journalline | c_salesregion_id | numeric | 10 | √ | NULL::numeric | Sales coverage region | |
gl_journalline | c_subacct_id | numeric | 10 | √ | NULL::numeric | Sub account for Element Value | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | Category of the Freight | |
gl_journalline | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | Quotation used for generating this order | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | Related Invoice | |
gl_journalline | user1_id | numeric | 10 | √ | NULL::numeric | User defined list element #1 | |
gl_journalline | user2_id | numeric | 10 | √ | NULL::numeric | User defined list element #2 | |
i_conversion_rate | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_gljournal | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_conversion_rate | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_gljournal | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated |