SchemaSpy Analysis of idempiere11.adempiere - ColumnsMaterial Confirmations | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:51 +0100 |
| |||||
|
idempiere11.adempiere contains 454 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
m_inoutconfirm | approvalamt | numeric | 0 | √ | null | Document Approval Amount | |
m_inventory | approvalamt | numeric | 0 | √ | null | Document Approval Amount | |
m_movement | approvalamt | numeric | 0 | √ | null | Document Approval Amount | |
m_movementconfirm | approvalamt | numeric | 0 | √ | 0 | Document Approval Amount | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
m_inout | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
m_movement | chargeamt | numeric | 0 | √ | null | Charge Amount | |
m_inoutline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
m_inoutlineconfirm | confirmedqty | numeric | 0 | 0 | Confirmation of a received quantity | ||
m_movementline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
m_movementlineconfirm | confirmedqty | numeric | 0 | 0 | Confirmation of a received quantity | ||
c_invoice | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
m_inventoryline | currentcostprice | numeric | 0 | √ | (0)::numeric | The currently used cost price | |
m_inoutlineconfirm | differenceqty | numeric | 0 | √ | null | Difference Quantity | |
m_movementlineconfirm | differenceqty | numeric | 0 | 0 | Difference Quantity | ||
m_inout | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
m_movement | freightamt | numeric | 0 | √ | null | Freight Amount | |
c_invoice | grandtotal | numeric | 0 | 0 | Total amount of 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 | |
m_inoutline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
m_movementline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
m_inventoryline | newcostprice | numeric | 0 | √ | (0)::numeric | New current cost price after processing of M_CostDetail | |
m_inoutline | pickedqty | numeric | 0 | √ | 0 | Picked Quantity | |
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_invoice | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_inout | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_inventory | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_movement | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_inventoryline | qtybook | numeric | 0 | 0 | Book Quantity | ||
m_inventoryline | qtycount | numeric | 0 | 0 | Counted Quantity | ||
m_inventoryline | qtycsv | numeric | 0 | 0 | Qty Csv | ||
c_invoiceline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
m_inoutline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
m_inventoryline | qtyinternaluse | numeric | 0 | √ | null | Internal Use Quantity removed from Inventory | |
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | Over Receipt Quantity | |
c_invoiceline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
m_inoutline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_inoutlineconfirm | scrappedqty | numeric | 0 | √ | null | The Quantity scrapped due to QA issues | |
m_movementline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_movementlineconfirm | scrappedqty | numeric | 0 | 0 | The Quantity scrapped due to QA issues | ||
m_inoutline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
m_inoutlineconfirm | targetqty | numeric | 0 | 0 | Target Movement Quantity | ||
m_movementline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
m_movementlineconfirm | targetqty | numeric | 0 | 0 | Target Movement Quantity | ||
c_invoiceline | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_invoice | totallines | numeric | 0 | 0 | Total of all document lines | ||
m_inout | volume | numeric | 0 | √ | null | Volume of a product | |
m_inout | weight | numeric | 0 | √ | null | Weight of a product | |
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
c_invoice | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
m_inventory | costingmethod | bpchar | 1 | √ | NULL::bpchar | Indicates how Costs will be calculated | |
m_inout | createconfirm | bpchar | 1 | √ | null | Create Confirm | |
c_invoice | createfrom | bpchar | 1 | √ | null | Process which will generate a new document lines based on an existing document | |
m_inout | createfrom | bpchar | 1 | √ | null | Process which will generate a new document lines based on an existing document | |
m_movement | 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 | |
m_inout | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
m_inout | createpackage | bpchar | 1 | √ | null | Create Package | |
m_inoutconfirm | createpackage | bpchar | 1 | √ | null | Create Package | |
m_inout | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
m_movement | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
m_inout | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
m_movement | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
m_inout | freightcostrule | bpchar | 1 | Method for charging Freight | |||
m_movement | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
m_inventory | generatelist | bpchar | 1 | √ | 'Y'::bpchar | Generate List | |
c_invoice | generateto | bpchar | 1 | √ | null | Generate To | |
m_inout | generateto | bpchar | 1 | √ | null | Generate To | |
m_inout | insurance | bpchar | 1 | √ | NULL::bpchar | Insurance | |
m_inventoryline | inventorytype | bpchar | 1 | 'D'::bpchar | Type of inventory difference | ||
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | Invoice Collection Status | |
c_invoice | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inout | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutlineconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inventory | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inventoryline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_movement | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_movementconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_movementline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_movementlineconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inout | isalternatereturnaddress | bpchar | 1 | 'N'::bpchar | Alternate Return Address | ||
c_invoice | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_inout | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_inoutconfirm | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_inventory | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_movement | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_movementconfirm | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | Auto create production to fulfill shipment | |
m_inoutconfirm | iscancelled | bpchar | 1 | 'N'::bpchar | The transaction was cancelled | ||
c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
m_inoutline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
c_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
m_inout | isdropship | bpchar | 1 | √ | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | |
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
m_inout | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
m_inoutconfirm | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
m_inout | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
m_movement | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
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_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
m_inout | 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 | ||
m_inout | 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 | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_invoice | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_inout | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_inventory | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_movement | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_inout | priorityrule | bpchar | 1 | Priority of a document | |||
m_movement | priorityrule | bpchar | 1 | √ | null | Priority of a document | |
c_invoice | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inout | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutlineconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inventory | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inventoryline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_movement | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_movementconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_movementline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_movementlineconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoice | processing | bpchar | 1 | √ | null | Process Now | |
m_inout | processing | bpchar | 1 | √ | null | Process Now | |
m_inoutconfirm | processing | bpchar | 1 | √ | null | Process Now | |
m_inventory | processing | bpchar | 1 | √ | null | Process Now | |
m_movement | processing | bpchar | 1 | √ | null | Process Now | |
m_movementconfirm | processing | bpchar | 1 | √ | null | Process Now | |
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
m_inout | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
m_inventory | updateqty | bpchar | 1 | √ | 'N'::bpchar | Update Quantities | |
m_inoutconfirm | confirmtype | bpchar | 2 | Type of confirmation | |||
c_invoice | docaction | bpchar | 2 | The targeted status of the document | |||
m_inout | docaction | bpchar | 2 | The targeted status of the document | |||
m_inoutconfirm | docaction | bpchar | 2 | The targeted status of the document | |||
m_inventory | docaction | bpchar | 2 | The targeted status of the document | |||
m_movement | docaction | bpchar | 2 | The targeted status of the document | |||
m_movementconfirm | docaction | bpchar | 2 | The targeted status of the document | |||
c_invoice | docstatus | bpchar | 2 | The current status of the document | |||
m_inout | docstatus | bpchar | 2 | The current status of the document | |||
m_inoutconfirm | docstatus | bpchar | 2 | The current status of the document | |||
m_inventory | docstatus | bpchar | 2 | The current status of the document | |||
m_movement | docstatus | bpchar | 2 | The current status of the document | |||
m_movementconfirm | docstatus | bpchar | 2 | The current status of the document | |||
m_inout | movementtype | bpchar | 2 | Method of moving the inventory | |||
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | Capital/Expense | |
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_invoice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoiceline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inout | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutlineconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inventory | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inventoryline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_movement | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_movementconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_movementline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_movementlineconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoiceline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inout | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutlineconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inventory | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inventoryline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_movement | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_movementconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_movementline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_movementlineconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoice | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inout | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inoutline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inventory | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_movement | 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 | |
m_inout | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
m_movement | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
c_invoice | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoiceline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inout | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inoutline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inventory | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_movement | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoice | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
m_inout | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
m_movement | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_invoice | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
m_inout | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
m_movement | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_invoice | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_invoiceline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inout | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inoutline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inventory | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_movement | 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_invoiceline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inout | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inoutline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inventoryline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_movement | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
m_inventory | c_conversiontype_id | numeric | 10 | √ | NULL::numeric | Currency Conversion Rate Type | |
c_invoice | c_currency_id | numeric | 10 | The Currency for this record | |||
m_inventory | c_currency_id | numeric | 10 | √ | NULL::numeric | The Currency for this record | |
c_invoice | c_doctype_id | numeric | 10 | Document type or rules | |||
m_inout | c_doctype_id | numeric | 10 | Document type or rules | |||
m_inventory | c_doctype_id | numeric | 10 | Document type or rules | |||
m_movement | 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_invoiceline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
m_inout | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
m_inoutconfirm | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
c_invoiceline | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
m_inoutlineconfirm | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
c_invoice | c_order_id | numeric | 10 | √ | null | Order | |
m_inout | c_order_id | numeric | 10 | √ | null | Order | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
m_inoutline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
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_invoiceline | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inout | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inoutline | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inventory | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_movement | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
m_inoutline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
m_inoutline | 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 | |
m_inoutline | c_uom_id | numeric | 10 | Unit of Measure | |||
c_invoice | createdby | numeric | 10 | User who created this records | |||
c_invoiceline | createdby | numeric | 10 | User who created this records | |||
m_inout | createdby | numeric | 10 | User who created this records | |||
m_inoutconfirm | createdby | numeric | 10 | User who created this records | |||
m_inoutline | createdby | numeric | 10 | User who created this records | |||
m_inoutlineconfirm | createdby | numeric | 10 | User who created this records | |||
m_inventory | createdby | numeric | 10 | User who created this records | |||
m_inventoryline | createdby | numeric | 10 | User who created this records | |||
m_movement | createdby | numeric | 10 | User who created this records | |||
m_movementconfirm | createdby | numeric | 10 | User who created this records | |||
m_movementline | createdby | numeric | 10 | User who created this records | |||
m_movementlineconfirm | createdby | numeric | 10 | User who created this records | |||
m_movement | dd_order_id | numeric | 10 | √ | null | Distribution Order | |
m_movementline | dd_orderline_id | numeric | 10 | √ | null | Distribution Order Line | |
m_inout | dropship_bpartner_id | numeric | 10 | √ | null | Business Partner to ship to | |
m_inout | dropship_location_id | numeric | 10 | √ | null | Business Partner Location for shipping to | |
m_inout | dropship_user_id | numeric | 10 | √ | null | Business Partner Contact for drop shipment | |
m_inout | fob | varchar | 10 | √ | NULL::character varying | Freight Terms | |
m_inout | freightcharges | varchar | 10 | √ | NULL::character varying | Freight Charges | |
c_invoiceline | line | numeric | 10 | Unique line for this document | |||
m_inoutline | line | numeric | 10 | Unique line for this document | |||
m_inventoryline | line | numeric | 10 | √ | null | Unique line for this document | |
m_movementline | line | numeric | 10 | √ | null | Unique line for this document | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_inventoryline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_movementline | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
m_movementline | m_attributesetinstanceto_id | numeric | 10 | √ | null | Target Product Attribute Set Instance | |
m_inout | m_inout_id | numeric | 10 | Material Shipment Document | |||
m_inoutconfirm | m_inout_id | numeric | 10 | Material Shipment Document | |||
m_inoutline | m_inout_id | numeric | 10 | Material Shipment Document | |||
m_inoutconfirm | m_inoutconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation | |||
m_inoutlineconfirm | m_inoutconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation | |||
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
m_inoutline | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
m_inoutlineconfirm | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
m_inoutlineconfirm | m_inoutlineconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation Line | |||
m_inoutconfirm | m_inventory_id | numeric | 10 | √ | null | Parameters for a Physical Inventory | |
m_inventory | m_inventory_id | numeric | 10 | Parameters for a Physical Inventory | |||
m_inventoryline | m_inventory_id | numeric | 10 | Parameters for a Physical Inventory | |||
m_movementconfirm | m_inventory_id | numeric | 10 | √ | null | Parameters for a Physical Inventory | |
m_inoutlineconfirm | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
m_inventoryline | m_inventoryline_id | numeric | 10 | Unique line in an Inventory document | |||
m_movementlineconfirm | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
m_inoutline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_inventoryline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_movementline | m_locator_id | numeric | 10 | Warehouse Locator | |||
m_movementline | m_locatorto_id | numeric | 10 | Location inventory is moved to | |||
m_movement | m_movement_id | numeric | 10 | Movement of Inventory | |||
m_movementconfirm | m_movement_id | numeric | 10 | Movement of Inventory | |||
m_movementline | m_movement_id | numeric | 10 | Movement of Inventory | |||
m_movementconfirm | m_movementconfirm_id | numeric | 10 | Inventory Move Confirmation | |||
m_movementlineconfirm | m_movementconfirm_id | numeric | 10 | Inventory Move Confirmation | |||
m_movementline | m_movementline_id | numeric | 10 | Inventory Move document Line | |||
m_movementlineconfirm | m_movementline_id | numeric | 10 | Inventory Move document Line | |||
m_movementlineconfirm | m_movementlineconfirm_id | numeric | 10 | Inventory Move Line Confirmation | |||
m_inventory | m_perpetualinv_id | numeric | 10 | √ | null | Rules for generating physical inventory | |
c_invoice | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_invoiceline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_inoutline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_inventoryline | m_product_id | numeric | 10 | Product, Service, Item | |||
m_movementline | m_product_id | numeric | 10 | Product, Service, Item | |||
c_invoice | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
m_inout | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
m_inoutline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
m_inout | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
m_movement | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
m_inout | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_inventory | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
m_movement | m_warehouse_id | numeric | 10 | √ | NULL::numeric | Storage Warehouse and Service Point | |
m_movement | m_warehouseto_id | numeric | 10 | √ | NULL::numeric | To Storage Warehouse and Service Point | |
m_inout | nopackages | numeric | 10 | √ | (1)::numeric | Number of packages shipped | |
m_inout | ref_inout_id | numeric | 10 | √ | null | Referenced Shipment | |
m_inoutline | ref_inoutline_id | numeric | 10 | √ | null | Referenced Shipment Line | |
c_invoice | ref_invoice_id | numeric | 10 | √ | null | Referenced Invoice | |
c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | Referenced Invoice Line | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | Related Invoice | |
m_inout | returnbpartner_id | numeric | 10 | √ | NULL::numeric | Return Partner | |
m_inout | returnlocation_id | numeric | 10 | √ | NULL::numeric | Return Location | |
m_inout | returnuser_id | numeric | 10 | √ | NULL::numeric | Return User/Contact | |
c_invoice | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_inout | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_inventory | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_movement | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_inoutline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
m_inventoryline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
m_movementline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
c_invoice | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
m_inout | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
m_movement | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_invoice | updatedby | numeric | 10 | User who updated this records | |||
c_invoiceline | updatedby | numeric | 10 | User who updated this records | |||
m_inout | updatedby | numeric | 10 | User who updated this records | |||
m_inoutconfirm | updatedby | numeric | 10 | User who updated this records | |||
m_inoutline | updatedby | numeric | 10 | User who updated this records | |||
m_inoutlineconfirm | updatedby | numeric | 10 | User who updated this records | |||
m_inventory | updatedby | numeric | 10 | User who updated this records | |||
m_inventoryline | updatedby | numeric | 10 | User who updated this records | |||
m_movement | updatedby | numeric | 10 | User who updated this records | |||
m_movementconfirm | updatedby | numeric | 10 | User who updated this records | |||
m_movementline | updatedby | numeric | 10 | User who updated this records | |||
m_movementlineconfirm | updatedby | numeric | 10 | User who updated this records | |||
c_invoice | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoiceline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_inout | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_inoutline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_inventory | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_movement | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoice | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_invoiceline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_inout | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_inoutline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_inventory | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_movement | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_inoutconfirm | confirmationno | varchar | 20 | √ | null | Confirmation Number | |
m_inoutlineconfirm | confirmationno | varchar | 20 | √ | null | Confirmation Number | |
c_invoice | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
m_inout | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
m_movement | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_invoice | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoiceline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inout | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutlineconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inventory | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inventoryline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_movement | created | timestamp | 29,6 | now() | Date this record was created | ||
m_movementconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
m_movementline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_movementlineconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoice | dateacct | timestamp | 29,6 | Accounting Date | |||
m_inout | 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 | |
m_inout | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
m_inout | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
m_inout | datereceived | timestamp | 29,6 | √ | null | Date a product was received | |
m_movement | datereceived | timestamp | 29,6 | √ | null | Date a product was received | |
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
m_inout | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
m_inventory | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
m_movement | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
m_inout | pickdate | timestamp | 29,6 | √ | null | Date/Time when picked for Shipment | |
c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
m_inout | shipdate | timestamp | 29,6 | √ | null | Shipment Date/Time | |
c_invoice | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoiceline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inout | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutlineconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inventory | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inventoryline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_movement | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_movementconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_movementline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_movementlineconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoice | documentno | varchar | 30 | Document sequence number of the document | |||
m_inout | documentno | varchar | 30 | Document sequence number of the document | |||
m_inoutconfirm | documentno | varchar | 30 | Document sequence number of the document | |||
m_inventory | documentno | varchar | 30 | Document sequence number of the document | |||
m_movement | documentno | varchar | 30 | Document sequence number of the document | |||
m_movementconfirm | documentno | varchar | 30 | Document sequence number of the document | |||
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | C_Invoice_UU | |
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceLine_UU | |
m_inout | m_inout_uu | varchar | 36 | √ | NULL::character varying | M_InOut_UU | |
m_inoutconfirm | m_inoutconfirm_uu | varchar | 36 | √ | NULL::character varying | M_InOutConfirm_UU | |
m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | M_InOutLine_UU | |
m_inoutlineconfirm | m_inoutlineconfirm_uu | varchar | 36 | √ | NULL::character varying | M_InOutLineConfirm_UU | |
m_inventory | m_inventory_uu | varchar | 36 | √ | NULL::character varying | M_Inventory_UU | |
m_inventoryline | m_inventoryline_uu | varchar | 36 | √ | NULL::character varying | M_InventoryLine_UU | |
m_movement | m_movement_uu | varchar | 36 | √ | NULL::character varying | M_Movement_UU | |
m_movementconfirm | m_movementconfirm_uu | varchar | 36 | √ | NULL::character varying | M_MovementConfirm_UU | |
m_movementline | m_movementline_uu | varchar | 36 | √ | NULL::character varying | M_MovementLine_UU | |
m_movementlineconfirm | m_movementlineconfirm_uu | varchar | 36 | √ | NULL::character varying | M_MovementLineConfirm_UU | |
m_inout | shipperaccount | varchar | 40 | √ | NULL::character varying | Shipper Account Number | |
m_inout | trackingno | varchar | 60 | √ | null | Number to track the shipment | |
c_invoice | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoiceline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inout | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutconfirm | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutlineconfirm | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inventory | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inventoryline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_movement | description | varchar | 255 | √ | null | Optional short description of the record | |
m_movementconfirm | description | varchar | 255 | √ | null | Optional short description of the record | |
m_movementline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_movementlineconfirm | description | varchar | 255 | √ | null | Optional short description of the record |