SchemaSpy Analysis of idempiere11.adempiere - ColumnsPurchasing | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:54 +0100 |
| |||||
|
idempiere11.adempiere contains 686 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_org | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_org | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org | ad_org_uu | varchar | 36 | √ | NULL::character varying | AD_Org_UU | |
ad_org | ad_replicationstrategy_id | numeric | 0 | √ | null | Data Replication Strategy | |
ad_org | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_org | createdby | numeric | 10 | User who created this records | |||
ad_org | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_org | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_org | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_org | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_org | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_org | updatedby | numeric | 10 | User who updated this records | |||
ad_org | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_activity | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_activity | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_activity | c_activity_id | numeric | 10 | Business Activity | |||
c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | C_Activity_UU | |
c_activity | created | timestamp | 29,6 | now() | Date this record was created | ||
c_activity | createdby | numeric | 10 | User who created this records | |||
c_activity | description | varchar | 255 | √ | null | Optional short description of the record | |
c_activity | help | varchar | 2000 | √ | null | Comment or Hint | |
c_activity | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_activity | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_activity | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_activity | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_activity | updatedby | numeric | 10 | User who updated this records | |||
c_activity | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_campaign | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_campaign | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_campaign | c_campaign_id | numeric | 10 | Marketing Campaign | |||
c_campaign | c_campaign_uu | varchar | 36 | √ | NULL::character varying | C_Campaign_UU | |
c_campaign | c_channel_id | numeric | 10 | √ | null | Sales Channel | |
c_campaign | costs | numeric | 0 | 0 | Costs in accounting currency | ||
c_campaign | created | timestamp | 29,6 | now() | Date this record was created | ||
c_campaign | createdby | numeric | 10 | User who created this records | |||
c_campaign | description | varchar | 255 | √ | null | Optional short description of the record | |
c_campaign | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
c_campaign | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_campaign | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_campaign | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_campaign | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
c_campaign | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_campaign | updatedby | numeric | 10 | User who updated this records | |||
c_campaign | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_elementvalue | accountsign | bpchar | 1 | Indicates the Natural Sign of the Account as a Debit or Credit | |||
c_elementvalue | accounttype | bpchar | 1 | Indicates the type of account | |||
c_elementvalue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_elementvalue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_elementvalue | bpartnertype | bpchar | 1 | √ | NULL::bpchar | Business Partner Type | |
c_elementvalue | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
c_elementvalue | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_elementvalue | c_element_id | numeric | 10 | Accounting Element | |||
c_elementvalue | c_elementvalue_id | numeric | 10 | Account Element | |||
c_elementvalue | c_elementvalue_uu | varchar | 36 | √ | NULL::character varying | C_ElementValue_UU | |
c_elementvalue | created | timestamp | 29,6 | now() | Date this record was created | ||
c_elementvalue | createdby | numeric | 10 | User who created this records | |||
c_elementvalue | description | varchar | 255 | √ | null | Optional short description of the record | |
c_elementvalue | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_elementvalue | isbankaccount | bpchar | 1 | √ | 'N'::bpchar | Indicates if this is the Bank Account | |
c_elementvalue | isdetailbpartner | bpchar | 1 | 'N'::bpchar | Manage Business Partners | ||
c_elementvalue | isdetailproduct | bpchar | 1 | 'N'::bpchar | Manage Products | ||
c_elementvalue | isdoccontrolled | bpchar | 1 | √ | 'N'::bpchar | Control account - If an account is controlled by a document, you cannot post manually to it | |
c_elementvalue | isforeigncurrency | bpchar | 1 | √ | 'N'::bpchar | Balances in foreign currency accounts are held in the nominated currency | |
c_elementvalue | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_elementvalue | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_elementvalue | postactual | bpchar | 1 | 'Y'::bpchar | Actual Values can be posted | ||
c_elementvalue | postbudget | bpchar | 1 | 'Y'::bpchar | Budget values can be posted | ||
c_elementvalue | postencumbrance | bpchar | 1 | 'Y'::bpchar | Post commitments to this account | ||
c_elementvalue | poststatistical | bpchar | 1 | 'Y'::bpchar | Post statistical quantities to this account? | ||
c_elementvalue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_elementvalue | updatedby | numeric | 10 | User who updated this records | |||
c_elementvalue | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
c_elementvalue | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
c_elementvalue | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_invoice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoice | 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_invoice | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoice | 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_invoice | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_invoice | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_invoice | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_invoice | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_invoice | c_currency_id | numeric | 10 | The Currency for this record | |||
c_invoice | c_doctype_id | numeric | 10 | Document type or rules | |||
c_invoice | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_invoice | c_dunninglevel_id | numeric | 10 | √ | null | Dunning Level | |
c_invoice | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | C_Invoice_UU | |
c_invoice | c_order_id | numeric | 10 | √ | null | Order | |
c_invoice | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_invoice | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_invoice | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_invoice | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_invoice | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoice | createdby | numeric | 10 | 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_invoice | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
c_invoice | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
c_invoice | dateacct | timestamp | 29,6 | Accounting Date | |||
c_invoice | dateinvoiced | timestamp | 29,6 | Date printed on Invoice | |||
c_invoice | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_invoice | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoice | docaction | bpchar | 2 | The targeted status of the document | |||
c_invoice | docstatus | bpchar | 2 | The current status of the document | |||
c_invoice | documentno | varchar | 30 | Document sequence number of the document | |||
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_invoice | generateto | bpchar | 1 | √ | null | Generate To | |
c_invoice | grandtotal | numeric | 0 | 0 | Total amount of document | ||
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | Invoice Collection Status | |
c_invoice | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoice | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
c_invoice | 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_invoice | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
c_invoice | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_invoice | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
c_invoice | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_invoice | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
c_invoice | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_invoice | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
c_invoice | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_invoice | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_invoice | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_invoice | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoice | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_invoice | processing | bpchar | 1 | √ | null | Process Now | |
c_invoice | ref_invoice_id | numeric | 10 | √ | null | Referenced Invoice | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | Related Invoice | |
c_invoice | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
c_invoice | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_invoice | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_invoice | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoice | updatedby | numeric | 10 | User who updated this records | |||
c_invoice | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoice | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
c_invoiceline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | Capital/Expense | |
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
c_invoiceline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoiceline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
c_invoiceline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoiceline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_invoiceline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoiceline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoiceline | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceLine_UU | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
c_invoiceline | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
c_invoiceline | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
c_invoiceline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
c_invoiceline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoiceline | createdby | numeric | 10 | User who created this records | |||
c_invoiceline | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
c_invoiceline | line | numeric | 10 | Unique line for this document | |||
c_invoiceline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | Total line amount incl. Tax | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
c_invoiceline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
c_invoiceline | priceactual | numeric | 0 | 0 | Actual Price | ||
c_invoiceline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
c_invoiceline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
c_invoiceline | pricelist | numeric | 0 | 0 | List Price | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoiceline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | Referenced Invoice Line | |
c_invoiceline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
c_invoiceline | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_invoiceline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoiceline | updatedby | numeric | 10 | User who updated this records | |||
c_invoiceline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoiceline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_order | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_order | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
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 | |
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 | |
c_order | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_order | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_order | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_order | c_currency_id | numeric | 10 | The Currency for this record | |||
c_order | c_doctype_id | numeric | 10 | Document type or rules | |||
c_order | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | Sales Opportunity | |
c_order | c_order_id | numeric | 10 | Order | |||
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | C_Order_UU | |
c_order | c_ordersource_id | numeric | 10 | √ | null | Order Source | |
c_order | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_order | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_order | c_pos_id | numeric | 10 | √ | null | Point of Sales Terminal | |
c_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_order | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_order | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_order | created | timestamp | 29,6 | now() | Date this record was created | ||
c_order | createdby | numeric | 10 | User who created this records | |||
c_order | dateacct | timestamp | 29,6 | Accounting Date | |||
c_order | dateordered | timestamp | 29,6 | Date of Order | |||
c_order | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
c_order | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
c_order | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
c_order | description | varchar | 255 | √ | null | Optional short description of the record | |
c_order | docaction | bpchar | 2 | The targeted status of the document | |||
c_order | docstatus | bpchar | 2 | The current status of the document | |||
c_order | documentno | varchar | 30 | Document sequence number of the document | |||
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_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
c_order | freightcostrule | bpchar | 1 | Method for charging Freight | |||
c_order | grandtotal | numeric | 0 | 0 | Total amount of document | ||
c_order | invoicerule | bpchar | 1 | Frequency and method of invoicing | |||
c_order | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_order | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | Credit has been approved | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
c_order | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | Privileged Rate | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | Selected | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_order | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_order | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
c_order | link_order_id | numeric | 10 | √ | null | This field links a sales order to the purchase order that is generated from it. | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | Category of the Freight | |
c_order | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_order | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
c_order | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
c_order | ordertype | varchar | 510 | √ | null | Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition) | |
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_order | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_order | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_order | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_order | priorityrule | bpchar | 1 | Priority of a document | |||
c_order | processed | bpchar | 1 | 'N'::bpchar | 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_order | processing | bpchar | 1 | √ | null | Process Now | |
c_order | promotioncode | varchar | 30 | √ | null | User entered promotion code at sales time | |
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | Quotation used for generating this order | |
c_order | ref_order_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
c_order | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_order | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | Rate Inquiry | |
c_order | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_order | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_order | updatedby | numeric | 10 | User who updated this records | |||
c_order | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_order | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_order | volume | numeric | 0 | √ | null | Volume of a product | |
c_order | weight | numeric | 0 | √ | null | Weight of a product | |
c_orderline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_orderline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_orderline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_orderline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_orderline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_orderline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_orderline | c_currency_id | numeric | 10 | The Currency for this record | |||
c_orderline | c_order_id | numeric | 10 | Order | |||
c_orderline | c_orderline_id | numeric | 10 | Sales Order Line | |||
c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | C_OrderLine_UU | |
c_orderline | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_orderline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_orderline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
c_orderline | c_tax_id | numeric | 10 | Tax identifier | |||
c_orderline | c_uom_id | numeric | 10 | Unit of Measure | |||
c_orderline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_orderline | createdby | numeric | 10 | User who created this records | |||
c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | Create Production | |
c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | Create Shipment | |
c_orderline | datedelivered | timestamp | 29,6 | √ | null | Date when the product was delivered | |
c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | Date printed on Invoice | |
c_orderline | dateordered | timestamp | 29,6 | Date of Order | |||
c_orderline | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
c_orderline | description | varchar | 255 | √ | null | Optional short description of the record | |
c_orderline | discount | numeric | 0 | √ | null | Discount in percent | |
c_orderline | freightamt | numeric | 0 | 0 | Freight Amount | ||
c_orderline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
c_orderline | line | numeric | 10 | Unique line for this document | |||
c_orderline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
c_orderline | link_orderline_id | numeric | 10 | √ | null | This field links a sales order line to the purchase order line that is generated from it. | |
c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
c_orderline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_orderline | m_promotion_id | numeric | 10 | √ | null | Promotion | |
c_orderline | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
c_orderline | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | Manufacturing Cost Collector | |
c_orderline | priceactual | numeric | 0 | 0 | Actual Price | ||
c_orderline | pricecost | numeric | 0 | √ | null | Price per Unit of Measure including all indirect costs (Freight, etc.) | |
c_orderline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
c_orderline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
c_orderline | pricelist | numeric | 0 | 0 | List Price | ||
c_orderline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_orderline | qtydelivered | numeric | 0 | 0 | Delivered Quantity | ||
c_orderline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
c_orderline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
c_orderline | qtylostsales | numeric | 0 | 0 | Quantity of potential sales | ||
c_orderline | qtyordered | numeric | 0 | 0 | Ordered Quantity | ||
c_orderline | qtyreserved | numeric | 0 | 0 | Reserved Quantity | ||
c_orderline | ref_orderline_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
c_orderline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
c_orderline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
c_orderline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_orderline | updatedby | numeric | 10 | User who updated this records | |||
c_orderline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_orderline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_project | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_project | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_project | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
c_project | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_project | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
c_project | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_project | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_project | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
c_project | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_project | c_currency_id | numeric | 10 | The Currency for this record | |||
c_project | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_project | c_phase_id | numeric | 10 | √ | null | Standard Phase of the Project Type | |
c_project | c_project_id | numeric | 10 | Financial Project | |||
c_project | c_project_uu | varchar | 36 | √ | NULL::character varying | C_Project_UU | |
c_project | c_projecttype_id | numeric | 10 | √ | null | Type of the project | |
c_project | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
c_project | committedqty | numeric | 0 | 0 | The (legal) commitment Quantity | ||
c_project | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_project | created | timestamp | 29,6 | now() | Date this record was created | ||
c_project | createdby | numeric | 10 | User who created this records | |||
c_project | datecontract | timestamp | 29,6 | √ | null | The (planned) effective date of this document. | |
c_project | datefinish | timestamp | 29,6 | √ | null | Finish or (planned) completion date | |
c_project | description | varchar | 255 | √ | null | Optional short description of the record | |
c_project | generateto | bpchar | 1 | √ | null | Generate To | |
c_project | invoicedamt | numeric | 0 | 0 | The amount invoiced | ||
c_project | invoicedqty | numeric | 0 | 0 | The quantity invoiced | ||
c_project | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_project | iscommitceiling | bpchar | 1 | 'N'::bpchar | The commitment amount/quantity is the chargeable ceiling | ||
c_project | iscommitment | bpchar | 1 | 'Y'::bpchar | Is this document a (legal) commitment? | ||
c_project | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_project | m_pricelist_version_id | numeric | 10 | √ | null | Identifies a unique instance of a Price List | |
c_project | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
c_project | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_project | note | varchar | 2000 | √ | null | Optional additional user defined information | |
c_project | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
c_project | plannedmarginamt | numeric | 0 | 0 | Project's planned margin amount | ||
c_project | plannedqty | numeric | 0 | 0 | Planned quantity for this project | ||
c_project | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_project | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_project | processing | bpchar | 1 | √ | null | Process Now | |
c_project | projectbalanceamt | numeric | 0 | 0 | Total Project Balance | ||
c_project | projectcategory | bpchar | 1 | √ | 'N'::bpchar | Project Category | |
c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | Project Line Level | ||
c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | Invoice Rule for the project | ||
c_project | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_project | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_project | updatedby | numeric | 10 | User who updated this records | |||
c_project | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_projectphase | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_projectphase | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_projectphase | c_order_id | numeric | 10 | √ | null | Order | |
c_projectphase | c_phase_id | numeric | 10 | √ | null | Standard Phase of the Project Type | |
c_projectphase | c_project_id | numeric | 10 | Financial Project | |||
c_projectphase | c_projectphase_id | numeric | 10 | Phase of a Project | |||
c_projectphase | c_projectphase_uu | varchar | 36 | √ | NULL::character varying | C_ProjectPhase_UU | |
c_projectphase | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
c_projectphase | created | timestamp | 29,6 | now() | Date this record was created | ||
c_projectphase | createdby | numeric | 10 | User who created this records | |||
c_projectphase | description | varchar | 255 | √ | null | Optional short description of the record | |
c_projectphase | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
c_projectphase | generateorder | bpchar | 1 | √ | null | Generate Order | |
c_projectphase | help | varchar | 2000 | √ | null | Comment or Hint | |
c_projectphase | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_projectphase | iscommitceiling | bpchar | 1 | 'N'::bpchar | The commitment amount/quantity is the chargeable ceiling | ||
c_projectphase | iscomplete | bpchar | 1 | 'N'::bpchar | It is complete | ||
c_projectphase | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_projectphase | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_projectphase | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
c_projectphase | priceactual | numeric | 0 | √ | 0 | Actual Price | |
c_projectphase | projinvoicerule | bpchar | 1 | √ | null | Invoice Rule for the project | |
c_projectphase | qty | numeric | 0 | √ | 0 | Quantity | |
c_projectphase | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
c_projectphase | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
c_projectphase | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_projectphase | updatedby | numeric | 10 | User who updated this records | |||
c_projecttask | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_projecttask | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_projecttask | c_projectphase_id | numeric | 10 | Phase of a Project | |||
c_projecttask | c_projecttask_id | numeric | 10 | Actual Project Task in a Phase | |||
c_projecttask | c_projecttask_uu | varchar | 36 | √ | NULL::character varying | C_ProjectTask_UU | |
c_projecttask | c_task_id | numeric | 10 | √ | null | Standard Project Type Task | |
c_projecttask | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
c_projecttask | created | timestamp | 29,6 | now() | Date this record was created | ||
c_projecttask | createdby | numeric | 10 | User who created this records | |||
c_projecttask | description | varchar | 255 | √ | null | Optional short description of the record | |
c_projecttask | help | varchar | 2000 | √ | null | Comment or Hint | |
c_projecttask | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_projecttask | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_projecttask | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_projecttask | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
c_projecttask | projinvoicerule | bpchar | 1 | √ | null | Invoice Rule for the project | |
c_projecttask | qty | numeric | 0 | √ | 0 | Quantity | |
c_projecttask | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
c_projecttask | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_projecttask | updatedby | numeric | 10 | User who updated this records | |||
m_inoutline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inoutline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inoutline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inoutline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inoutline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
m_inoutline | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inoutline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
m_inoutline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
m_inoutline | c_uom_id | numeric | 10 | Unit of Measure | |||
m_inoutline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
m_inoutline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutline | createdby | numeric | 10 | User who created this records | |||
m_inoutline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | Auto create production to fulfill shipment | |
m_inoutline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
m_inoutline | line | numeric | 10 | Unique line for this document | |||
m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_inoutline | m_inout_id | numeric | 10 | Material Shipment Document | |||
m_inoutline | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | M_InOutLine_UU | |
m_inoutline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_inoutline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_inoutline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
m_inoutline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
m_inoutline | pickedqty | numeric | 0 | √ | 0 | Picked Quantity | |
m_inoutline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | Over Receipt Quantity | |
m_inoutline | ref_inoutline_id | numeric | 10 | √ | null | Referenced Shipment Line | |
m_inoutline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
m_inoutline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_inoutline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
m_inoutline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutline | updatedby | numeric | 10 | User who updated this records | |||
m_inoutline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_inoutline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_matchinv | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_matchinv | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_matchinv | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
m_matchinv | created | timestamp | 29,6 | now() | Date this record was created | ||
m_matchinv | createdby | numeric | 10 | User who created this records | |||
m_matchinv | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
m_matchinv | datetrx | timestamp | 29,6 | Transaction Date | |||
m_matchinv | description | varchar | 255 | √ | null | Optional short description of the record | |
m_matchinv | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
m_matchinv | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_matchinv | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
m_matchinv | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
m_matchinv | m_matchinv_id | numeric | 10 | Match Shipment/Receipt to Invoice | |||
m_matchinv | m_matchinv_uu | varchar | 36 | √ | NULL::character varying | M_MatchInv_UU | |
m_matchinv | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_matchinv | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_matchinv | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_matchinv | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_matchinv | processing | bpchar | 1 | Process Now | |||
m_matchinv | qty | numeric | 0 | 0 | Quantity | ||
m_matchinv | ref_matchinv_id | numeric | 10 | √ | NULL::numeric | Referenced Match Invoice | |
m_matchinv | reversal_id | numeric | 10 | √ | NULL::numeric | ID of document reversal | |
m_matchinv | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_matchinv | updatedby | numeric | 10 | User who updated this records | |||
m_matchpo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_matchpo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_matchpo | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
m_matchpo | c_orderline_id | numeric | 10 | Sales Order Line | |||
m_matchpo | created | timestamp | 29,6 | now() | Date this record was created | ||
m_matchpo | createdby | numeric | 10 | User who created this records | |||
m_matchpo | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
m_matchpo | datetrx | timestamp | 29,6 | Transaction Date | |||
m_matchpo | description | varchar | 255 | √ | null | Optional short description of the record | |
m_matchpo | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
m_matchpo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_matchpo | isapproved | bpchar | 1 | √ | 'Y'::bpchar | Indicates if this document requires approval | |
m_matchpo | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
m_matchpo | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
m_matchpo | m_matchpo_id | numeric | 10 | Match Purchase Order to Shipment/Receipt and Invoice | |||
m_matchpo | m_matchpo_uu | varchar | 36 | √ | NULL::character varying | M_MatchPO_UU | |
m_matchpo | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_matchpo | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_matchpo | pricematchdifference | numeric | 0 | √ | null | Difference between Purchase and Invoice Price per matched line | |
m_matchpo | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_matchpo | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_matchpo | processing | bpchar | 1 | Process Now | |||
m_matchpo | qty | numeric | 0 | 0 | Quantity | ||
m_matchpo | ref_matchpo_id | numeric | 10 | √ | NULL::numeric | Referenced Match PO | |
m_matchpo | reversal_id | numeric | 10 | √ | NULL::numeric | ID of document reversal | |
m_matchpo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_matchpo | updatedby | numeric | 10 | User who updated this records | |||
m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product | createdby | numeric | 10 | User who created this records | |||
m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | ||
m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | downloadurl | varchar | 120 | √ | null | ||
m_product | group1 | varchar | 255 | √ | null | Group1 | |
m_product | group2 | varchar | 255 | √ | null | Group2 | |
m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
m_product | imageurl | varchar | 120 | √ | null | URL of image | |
m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the invoice | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | This part is Kanban controlled | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
m_product | istoformule | bpchar | 1 | √ | null | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
m_product | lowlevel | numeric | 10 | (0)::numeric | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited | ||
m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
m_product | processing | bpchar | 1 | √ | null | Process Now | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product | updatedby | numeric | 10 | User who updated this records | |||
m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
m_product | versionno | varchar | 20 | √ | null | Version Number | |
m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
m_product_po | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_po | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_po | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
m_product_po | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
m_product_po | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
m_product_po | costperorder | numeric | 0 | √ | 0 | Fixed Cost Per Order | |
m_product_po | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product_po | createdby | numeric | 10 | User who created this records | |||
m_product_po | deliverytime_actual | numeric | 10 | √ | null | Actual days between order and delivery | |
m_product_po | deliverytime_promised | numeric | 10 | √ | null | Promised days between order and delivery | |
m_product_po | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
m_product_po | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
m_product_po | discontinuedby | timestamp | 29,6 | √ | null | ||
m_product_po | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product_po | iscurrentvendor | bpchar | 1 | 'Y'::bpchar | Use this Vendor for pricing and stock replenishment | ||
m_product_po | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product_po | m_product_po_uu | varchar | 36 | √ | NULL::character varying | M_Product_PO_UU | |
m_product_po | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
m_product_po | order_min | numeric | 0 | √ | 0 | Minimum order quantity in UOM | |
m_product_po | order_pack | numeric | 0 | √ | 0 | Package order size in UOM (e.g. order set of 5 units) | |
m_product_po | priceeffective | timestamp | 29,6 | √ | null | Effective Date of Price | |
m_product_po | pricelastinv | numeric | 0 | √ | 0 | Price of the last invoice for the product | |
m_product_po | pricelastpo | numeric | 0 | √ | 0 | Price of the last purchase order for the product | |
m_product_po | pricelist | numeric | 0 | √ | 0 | List Price | |
m_product_po | pricepo | numeric | 0 | √ | 0 | Price based on a purchase order | |
m_product_po | qualityrating | numeric | 0 | √ | null | Method for rating vendors | |
m_product_po | royaltyamt | numeric | 0 | √ | 0 | (Included) Amount for copyright, etc. | |
m_product_po | upc | varchar | 20 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product_po | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product_po | updatedby | numeric | 10 | User who updated this records | |||
m_product_po | vendorcategory | varchar | 30 | √ | null | Product Category of the Business Partner | |
m_product_po | vendorproductno | varchar | 40 | Product Key of the Business Partner | |||
m_requisition | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_requisition | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_requisition | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
m_requisition | c_doctype_id | numeric | 10 | Document type or rules | |||
m_requisition | created | timestamp | 29,6 | now() | Date this record was created | ||
m_requisition | createdby | numeric | 10 | User who created this records | |||
m_requisition | datedoc | timestamp | 29,6 | now() | Date of the Document | ||
m_requisition | daterequired | timestamp | 29,6 | Date when required | |||
m_requisition | description | varchar | 255 | √ | null | Optional short description of the record | |
m_requisition | docaction | bpchar | 2 | The targeted status of the document | |||
m_requisition | docstatus | bpchar | 2 | The current status of the document | |||
m_requisition | documentno | varchar | 30 | Document sequence number of the document | |||
m_requisition | help | varchar | 2000 | √ | null | Comment or Hint | |
m_requisition | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_requisition | isapproved | bpchar | 1 | 'Y'::bpchar | Indicates if this document requires approval | ||
m_requisition | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
m_requisition | m_requisition_id | numeric | 10 | Material Requisition | |||
m_requisition | m_requisition_uu | varchar | 36 | √ | NULL::character varying | M_Requisition_UU | |
m_requisition | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_requisition | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_requisition | priorityrule | bpchar | 1 | Priority of a document | |||
m_requisition | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_requisition | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_requisition | processing | bpchar | 1 | √ | null | Process Now | |
m_requisition | totallines | numeric | 0 | 0 | Total of all document lines | ||
m_requisition | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_requisition | updatedby | numeric | 10 | User who updated this records | |||
m_requisitionline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_requisitionline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_requisitionline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
m_requisitionline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_requisitionline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
m_requisitionline | c_uom_id | numeric | 10 | √ | NULL::numeric | Unit of Measure | |
m_requisitionline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_requisitionline | createdby | numeric | 10 | User who created this records | |||
m_requisitionline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_requisitionline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_requisitionline | line | numeric | 10 | Unique line for this document | |||
m_requisitionline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
m_requisitionline | m_attributesetinstance_id | numeric | 0 | √ | null | Product Attribute Set Instance | |
m_requisitionline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_requisitionline | m_requisition_id | numeric | 10 | Material Requisition | |||
m_requisitionline | m_requisitionline_id | numeric | 10 | Material Requisition Line | |||
m_requisitionline | m_requisitionline_uu | varchar | 36 | √ | NULL::character varying | M_RequisitionLine_UU | |
m_requisitionline | priceactual | numeric | 0 | 0 | Actual Price | ||
m_requisitionline | qty | numeric | 0 | 0 | Quantity | ||
m_requisitionline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_requisitionline | updatedby | numeric | 10 | User who updated this records |