SchemaSpy Analysis of idempiere11.adempiere - ColumnsOrder Management Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:52 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 1253 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
m_productpricevendorbreak breakvalue numeric 0 Low Value of trade discount break level
c_charge chargeamt numeric 0 0 Charge Amount
c_order chargeamt numeric 0  √  0 Charge Amount
c_payment chargeamt numeric 0  √  0 Charge Amount
m_shippingtransaction codamount numeric 0  √  null COD Amount
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_payment convertedamt numeric 0  √  null Converted Amount
c_payment currencyrate numeric 0  √  null Currency Conversion Rate
m_shippingtransaction customsvalue numeric 0  √  null Customs Value
c_orderline discount numeric 0  √  null Discount in percent
c_paymentterm discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
c_orderpayschedule discountamt numeric 0 Calculated amount of discount
c_payment discountamt numeric 0  √  0 Calculated amount of discount
m_shippingtransaction dryiceweight numeric 0  √  null Dry Ice Weight
c_orderpayschedule dueamt numeric 0 Amount of the payment due
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_order freightamt numeric 0  √  0 Freight Amount
c_orderline freightamt numeric 0 0 Freight Amount
m_shippingtransaction freightamt numeric 0  √  null Freight Amount
c_order grandtotal numeric 0 0 Total amount of document
m_shippingtransaction handlingcharge numeric 0  √  null Handling Charge
m_shipperlabelscfg height numeric 0  √  null Height
m_shippingtransaction height numeric 0  √  null Height
m_shippingtransactionline height numeric 0  √  null Height
m_shippingtransaction insuredamount numeric 0  √  null Insured Amount
c_project invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
m_shippingtransaction length numeric 0  √  null Length
m_shippingtransactionline length numeric 0  √  null Length
c_orderline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
m_distributionlistline minqty numeric 0 0 Minimum quantity for the business partner
m_distributionrunline minqty numeric 0 0 Minimum quantity for the business partner
t_distributionrundetail minqty numeric 0 0 Minimum quantity for the business partner
c_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment payamt numeric 0 0 Amount being paid
c_pospayment payamt numeric 0 Amount being paid
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_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
m_shippingtransaction price numeric 0  √  null Price
m_shippingtransactionline price numeric 0  √  null Price
c_orderline priceactual numeric 0 0 Actual Price
m_shippingtransaction priceactual numeric 0  √  null 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
m_productprice pricelimit numeric 0 0 Lowest price for a product
m_productpricevendorbreak pricelimit numeric 0 Lowest price for a product
c_orderline pricelist numeric 0 0 List Price
m_productprice pricelist numeric 0 0 List Price
m_productpricevendorbreak pricelist numeric 0 List Price
m_productprice pricestd numeric 0 0 Standard Price
m_productpricevendorbreak pricestd numeric 0 Standard Price
c_order processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_payment processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_project projectbalanceamt numeric 0 0 Total Project Balance
t_distributionrundetail qty numeric 0 0 Quantity
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_tax rate numeric 0 Rate or Tax or Exchange
m_distributionlistline ratio numeric 0  √  null Relative Ratio for Distributions
t_distributionrundetail ratio numeric 0 Relative Ratio for Distributions
m_distributionlist ratiototal numeric 0  √  null Total of relative weight in a distribution
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
c_servicelevel servicelevelinvoiced numeric 0 Quantity of product or service invoiced
c_servicelevel servicelevelprovided numeric 0 Quantity of service or product provided
c_servicelevelline servicelevelprovided numeric 0 Quantity of service or product provided
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
m_shippingtransaction surcharges numeric 0  √  null Surcharges
c_ordertax taxamt numeric 0 0 Tax Amount for a document
c_payment taxamt numeric 0  √  0 Tax Amount for a document
m_rmatax taxamt numeric 0 Tax Amount for a document
c_ordertax taxbaseamt numeric 0 0 Base for calculating the tax amount
m_rmatax taxbaseamt numeric 0 Base for calculating the tax amount
c_order totallines numeric 0 0 Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_distributionrunline totalqty numeric 0 0 Total Quantity
m_product unitsperpallet numeric 0  √  null Units Per Pallet
c_order volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
c_order weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
m_shipperpackaging weight numeric 0  √  null Weight of a product
m_shipperpackagingcfg weight numeric 0  √  null Weight of a product
m_shippingtransaction weight numeric 0  √  null Weight of a product
m_shippingtransactionline weight numeric 0  √  null Weight of a product
m_shipperlabelscfg width numeric 0  √  null Width
m_shippingtransaction width numeric 0  √  null Width
m_shippingtransactionline width numeric 0  √  null Width
c_payment writeoffamt numeric 0  √  0 Amount to write-off
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
m_shippingtransaction cashondelivery bpchar 1 'N'::bpchar COD
c_pospayment checkstatus bpchar 1  √  NULL::bpchar Check Status
ad_user connectionprofile bpchar 1  √  null How a Java Tenant connects to the server(s)
c_order copyfrom bpchar 1  √  null Copy From Record
c_project copyfrom bpchar 1  √  null Copy From Record
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_shippercfg copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_shipper createfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
c_orderline createproduction bpchar 1  √  'N'::bpchar Create Production
c_orderline createshipment bpchar 1  √  'N'::bpchar Create Shipment
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_pospayment creditcardtype bpchar 1  √  NULL::bpchar Credit Card (Visa, MC, AmEx)
m_shippingtransaction deliveryconfirmation bpchar 1 'N'::bpchar EMail Delivery confirmation
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_order deliveryrule bpchar 1 Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_order deliveryviarule bpchar 1 How the order will be delivered
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_order freightcostrule bpchar 1 Method for charging Freight
c_project generateto bpchar 1  √  null Generate To
m_shippingtransaction insurance bpchar 1  √  NULL::bpchar Insurance
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_order invoicerule bpchar 1 Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
m_shippingtransaction isaccessible bpchar 1 'N'::bpchar Accessible
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_shippingacct isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_charge isactive bpchar 1 'Y'::bpchar The record is active in the system
c_order isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderpayschedule isactive bpchar 1 'Y'::bpchar The record is active in the system
c_ordersource isactive bpchar 1 'Y'::bpchar The record is active in the system
c_ordertax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payment isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
c_pospayment isactive bpchar 1 'Y'::bpchar The record is active in the system
c_postendertype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_project isactive bpchar 1 'Y'::bpchar The record is active in the system
c_revenuerecognition isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevelline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_tax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxcategory isactive bpchar 1 'Y'::bpchar The record is active in the system
m_commodityshipment isactive bpchar 1 'Y'::bpchar The record is active in the system
m_distributionlist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_distributionlistline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_distributionrun isactive bpchar 1 'Y'::bpchar The record is active in the system
m_distributionrunline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist_version isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productprice isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productpricevendorbreak isactive bpchar 1 'Y'::bpchar The record is active in the system
m_rmatax isactive bpchar 1 'Y'::bpchar The record is active in the system
m_rmatype isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipper isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippercfg isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperlabels isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperlabelscfg isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperpackaging isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperpackagingcfg isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperpickuptypes isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shipperpickuptypescfg isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippingprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippingprocessorcfg isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippingtransaction isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippingtransactionline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
t_distributionrundetail isactive bpchar 1 'Y'::bpchar The record is active in the system
m_shippingtransaction isaddedhandling bpchar 1 'N'::bpchar Added Handling
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
c_payment isallocated bpchar 1 'N'::bpchar Indicates if the payment has been allocated
m_shippingtransaction isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
c_order isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_payment isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_shippingtransaction iscargoaircraftonly bpchar 1 'N'::bpchar Cargo Aircraft Only
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?
m_distributionrun iscreatesingleorder bpchar 1 'N'::bpchar For all shipments create one Order
c_order iscreditapproved bpchar 1 'N'::bpchar Credit has been approved
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_tax isdefault bpchar 1 'N'::bpchar Default value
c_taxcategory isdefault bpchar 1 'N'::bpchar Default value
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_shipperlabels isdefault bpchar 1 'N'::bpchar Default value
m_shipperlabelscfg isdefault bpchar 1 'N'::bpchar Default value
m_shipperpackaging isdefault bpchar 1 'N'::bpchar Default value
m_shipperpackagingcfg isdefault bpchar 1 'N'::bpchar Default value
m_shipperpickuptypes isdefault bpchar 1 'N'::bpchar Default value
m_shipperpickuptypescfg isdefault bpchar 1 'N'::bpchar Default value
c_payment isdelayedcapture bpchar 1 'N'::bpchar Charge after Shipment
c_order isdelivered bpchar 1 'N'::bpchar Delivered
c_orderline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_order isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_tax isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
c_order isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_shippingtransaction isdryice bpchar 1 'N'::bpchar Dry Ice
c_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
m_shippingtransaction isdutiable bpchar 1 'N'::bpchar Dutiable
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
m_shippingtransaction isfuturedayshipment bpchar 1 'N'::bpchar Future Day Shipment
c_postendertype isguarantee bpchar 1 'N'::bpchar Guarantee for a Credit
m_shippingtransaction ishazmat bpchar 1 'N'::bpchar Hazardous Materials
m_shippingtransaction isholdatlocation bpchar 1 'N'::bpchar Hold At Location
m_shippingtransaction isignorezipnotfound bpchar 1 'N'::bpchar Ignore Zip Not Found
m_shippingtransaction isignorezipstatenotmatch bpchar 1 'N'::bpchar Ignore Zip State Not Match
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
m_shippercfg isinternational bpchar 1 'N'::bpchar International
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
c_order isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
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
ad_user islocked bpchar 1 'N'::bpchar Locked
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_payment isonline bpchar 1 'N'::bpchar Can be accessed online
m_shippercfg isonline bpchar 1 'N'::bpchar Can be accessed online
c_payment isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_payment isoverunderpayment bpchar 1 'Y'::bpchar Over-Payment (unallocated) or Under-Payment (partial payment)
m_product isownbox bpchar 1 'N'::bpchar Own Box
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_order ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_pospayment ispostdated bpchar 1 'N'::bpchar Post Dated
c_postendertype ispostdated bpchar 1 'N'::bpchar Post Dated
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_payment isprepayment bpchar 1 'N'::bpchar The Payment/Receipt is a Prepayment
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar Is Present For Product
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
c_order isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_order ispriviledgedrate bpchar 1 'N'::bpchar Privileged Rate
m_shippingtransaction ispriviledgedrate bpchar 1 'N'::bpchar Privileged Rate
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
c_payment isreceipt bpchar 1 'Y'::bpchar This is a sales transaction (receipt)
c_payment isreconciled bpchar 1 'N'::bpchar Payment is reconciled with bank statement
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
m_shippercfg isresidential bpchar 1 'N'::bpchar Residential
m_shippingtransaction isresidential bpchar 1 'Y'::bpchar Residential
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_tax issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
c_charge issamecurrency bpchar 1 'N'::bpchar Same Currency
c_charge issametax bpchar 1 'N'::bpchar Use the same tax as the main transaction
m_shippercfg issaturdaydelivery bpchar 1 'N'::bpchar Saturday Delivery
m_shippingtransaction issaturdaydelivery bpchar 1 'N'::bpchar Saturday Delivery
m_shippingtransaction issaturdaypickup bpchar 1 'N'::bpchar Saturday Pickup
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_payment isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
c_order issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_project issummary bpchar 1 'N'::bpchar This is a summary entity
c_tax issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_tax istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
c_charge istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_order istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_ordertax istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_rmatax istaxincluded bpchar 1 Tax is included in the price
c_revenuerecognition istimebased bpchar 1 Time based Revenue Recognition rather than Service Level based
m_product istoformule bpchar 1  √  null
c_order istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_orderpayschedule isvalid bpchar 1 Element is valid
c_paymentterm isvalid bpchar 1 'N'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
m_shippingtransaction isverbalconfirmation bpchar 1 'N'::bpchar Verbal Confirmation
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
c_payment isvoided bpchar 1 'N'::bpchar Voided
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
m_shipperlabels labelprintmethod bpchar 1  √  NULL::bpchar Label Print Method
m_shipperlabelscfg labelprintmethod bpchar 1  √  NULL::bpchar Label Print Method
c_paymentterm netday bpchar 1  √  null Day when payment is due net
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_order paymentrule bpchar 1 How you pay the invoice
m_shippingtransaction paymentrule bpchar 1  √  NULL::bpchar How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
c_order posted bpchar 1 'N'::bpchar Posting status
c_payment posted bpchar 1 'N'::bpchar Posting status
c_order priorityrule bpchar 1 Priority of a document
m_pricelist_version proccreate bpchar 1  √  null Create
c_order processed bpchar 1 'N'::bpchar The document has been processed
c_orderline processed bpchar 1 'N'::bpchar The document has been processed
c_orderpayschedule processed bpchar 1 The document has been processed
c_ordertax processed bpchar 1 'N'::bpchar The document has been processed
c_payment processed bpchar 1 'N'::bpchar The document has been processed
c_pospayment processed bpchar 1 The document has been processed
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_servicelevel processed bpchar 1  √  'N'::bpchar The document has been processed
c_servicelevelline processed bpchar 1  √  'N'::bpchar The document has been processed
m_rmatax processed bpchar 1 The document has been processed
m_shippingtransaction processed bpchar 1 'N'::bpchar The document has been processed
m_shippingtransactionline processed bpchar 1 'N'::bpchar The document has been processed
ad_user processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_orderpayschedule processing bpchar 1  √  NULL::bpchar Process Now
c_payment processing bpchar 1  √  null Process Now
c_paymentterm processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
c_servicelevel processing bpchar 1  √  null Process Now
m_distributionlist processing bpchar 1  √  null Process Now
m_distributionrun processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
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_payment r_avsaddr bpchar 1  √  null This address has been verified
c_payment r_avszip bpchar 1  √  null The Zip Code has been verified
c_payment r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
c_bpartner rating bpchar 1  √  null Classification or Importance
c_revenuerecognition recognitionfrequency bpchar 1  √  null Recognition frequency
c_tax requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_warehouse separator bpchar 1 Element Separator
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_tax sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_tax taxpostingindicator bpchar 1  √  '0'::bpchar Type of input tax (deductible and non deductible)
c_payment tendertype bpchar 1 Method of Payment
c_pospayment tendertype bpchar 1  √  NULL::bpchar Method of Payment
c_postendertype tendertype bpchar 1  √  NULL::bpchar Method of Payment
c_payment trxtype bpchar 1 Type of credit card transaction
m_shippingtransaction action varchar 2 Indicates the Action to be performed
c_order docaction bpchar 2 The targeted status of the document
c_payment docaction bpchar 2 The targeted status of the document
c_order docstatus bpchar 2 The current status of the document
c_payment docstatus bpchar 2 The current status of the document
m_shippingtransaction notificationtype varchar 2  √  NULL::character varying Type of Notifications
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_user ad_client_id numeric 10 Tenant for this installation.
c_bp_shippingacct ad_client_id numeric 10 Tenant for this installation.
c_bpartner ad_client_id numeric 10 Tenant for this installation.
c_bpartner_location ad_client_id numeric 10 Tenant for this installation.
c_charge ad_client_id numeric 10 Tenant for this installation.
c_order ad_client_id numeric 10 Tenant for this installation.
c_orderline ad_client_id numeric 10 Tenant for this installation.
c_orderpayschedule ad_client_id numeric 10 Tenant for this installation.
c_ordersource ad_client_id numeric 10 Tenant for this installation.
c_ordertax ad_client_id numeric 10 Tenant for this installation.
c_payment ad_client_id numeric 10 Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Tenant for this installation.
c_pospayment ad_client_id numeric 10 Tenant for this installation.
c_postendertype ad_client_id numeric 10 Tenant for this installation.
c_project ad_client_id numeric 10 Tenant for this installation.
c_revenuerecognition ad_client_id numeric 10 Tenant for this installation.
c_servicelevel ad_client_id numeric 10 Tenant for this installation.
c_servicelevelline ad_client_id numeric 10 Tenant for this installation.
c_tax ad_client_id numeric 10 Tenant for this installation.
c_taxcategory ad_client_id numeric 10 Tenant for this installation.
m_commodityshipment ad_client_id numeric 10 Tenant for this installation.
m_distributionlist ad_client_id numeric 10 Tenant for this installation.
m_distributionlistline ad_client_id numeric 10 Tenant for this installation.
m_distributionrun ad_client_id numeric 10 Tenant for this installation.
m_distributionrunline ad_client_id numeric 10 Tenant for this installation.
m_pricelist ad_client_id numeric 10 Tenant for this installation.
m_pricelist_version ad_client_id numeric 10 Tenant for this installation.
m_product ad_client_id numeric 10 Tenant for this installation.
m_productprice ad_client_id numeric 10 Tenant for this installation.
m_productpricevendorbreak ad_client_id numeric 10 Tenant for this installation.
m_rmatax ad_client_id numeric 10 Tenant for this installation.
m_rmatype ad_client_id numeric 10 Tenant for this installation.
m_shipper ad_client_id numeric 10 Tenant for this installation.
m_shippercfg ad_client_id numeric 10 Tenant for this installation.
m_shipperlabels ad_client_id numeric 10 Tenant for this installation.
m_shipperlabelscfg ad_client_id numeric 10 Tenant for this installation.
m_shipperpackaging ad_client_id numeric 10 Tenant for this installation.
m_shipperpackagingcfg ad_client_id numeric 10 Tenant for this installation.
m_shipperpickuptypes ad_client_id numeric 10 Tenant for this installation.
m_shipperpickuptypescfg ad_client_id numeric 10 Tenant for this installation.
m_shippingprocessor ad_client_id numeric 10 Tenant for this installation.
m_shippingprocessorcfg ad_client_id numeric 10 Tenant for this installation.
m_shippingtransaction ad_client_id numeric 10 Tenant for this installation.
m_shippingtransactionline ad_client_id numeric 10 Tenant for this installation.
m_warehouse ad_client_id numeric 10 Tenant for this installation.
t_distributionrundetail ad_client_id numeric 10 Tenant for this installation.
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_user ad_org_id numeric 10 Organizational entity within tenant
c_bp_shippingacct ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_org_id numeric 10 Organizational entity within tenant
c_bpartner_location ad_org_id numeric 10 Organizational entity within tenant
c_charge ad_org_id numeric 10 Organizational entity within tenant
c_order ad_org_id numeric 10 Organizational entity within tenant
c_orderline ad_org_id numeric 10 Organizational entity within tenant
c_orderpayschedule ad_org_id numeric 10 Organizational entity within tenant
c_ordersource ad_org_id numeric 10 Organizational entity within tenant
c_ordertax ad_org_id numeric 10 Organizational entity within tenant
c_payment ad_org_id numeric 10 Organizational entity within tenant
c_paymentterm ad_org_id numeric 10 Organizational entity within tenant
c_pospayment ad_org_id numeric 10 Organizational entity within tenant
c_postendertype ad_org_id numeric 10 Organizational entity within tenant
c_project ad_org_id numeric 10 Organizational entity within tenant
c_revenuerecognition ad_org_id numeric 10 Organizational entity within tenant
c_servicelevel ad_org_id numeric 10 Organizational entity within tenant
c_servicelevelline ad_org_id numeric 10 Organizational entity within tenant
c_tax ad_org_id numeric 10 Organizational entity within tenant
c_taxcategory ad_org_id numeric 10 Organizational entity within tenant
m_commodityshipment ad_org_id numeric 10 Organizational entity within tenant
m_distributionlist ad_org_id numeric 10 Organizational entity within tenant
m_distributionlistline ad_org_id numeric 10 Organizational entity within tenant
m_distributionrun ad_org_id numeric 10 Organizational entity within tenant
m_distributionrunline ad_org_id numeric 10 Organizational entity within tenant
m_pricelist ad_org_id numeric 10 Organizational entity within tenant
m_pricelist_version ad_org_id numeric 10 Organizational entity within tenant
m_product ad_org_id numeric 10 Organizational entity within tenant
m_productprice ad_org_id numeric 10 Organizational entity within tenant
m_productpricevendorbreak ad_org_id numeric 10 Organizational entity within tenant
m_rmatax ad_org_id numeric 10 Organizational entity within tenant
m_rmatype ad_org_id numeric 10 Organizational entity within tenant
m_shipper ad_org_id numeric 10 Organizational entity within tenant
m_shippercfg ad_org_id numeric 10 Organizational entity within tenant
m_shipperlabels ad_org_id numeric 10 Organizational entity within tenant
m_shipperlabelscfg ad_org_id numeric 10 Organizational entity within tenant
m_shipperpackaging ad_org_id numeric 10 Organizational entity within tenant
m_shipperpackagingcfg ad_org_id numeric 10 Organizational entity within tenant
m_shipperpickuptypes ad_org_id numeric 10 Organizational entity within tenant
m_shipperpickuptypescfg ad_org_id numeric 10 Organizational entity within tenant
m_shippingprocessor ad_org_id numeric 10 Organizational entity within tenant
m_shippingprocessorcfg ad_org_id numeric 10 Organizational entity within tenant
m_shippingtransaction ad_org_id numeric 10 Organizational entity within tenant
m_shippingtransactionline ad_org_id numeric 10 Organizational entity within tenant
m_warehouse ad_org_id numeric 10 Organizational entity within tenant
t_distributionrundetail ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_order ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_orderline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_payment ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
c_tax ad_rule_id numeric 10  √  null Rule
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
c_order ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_shippingtransaction ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_user authenticationtype varchar 10  √  NULL::character varying Authentication Type
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
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
m_shippingtransaction bill_location_id numeric 10  √  NULL::numeric Business Partner Location for invoicing
c_order bill_user_id numeric 10  √  null Business Partner Contact for invoicing
m_shippingtransaction boxcount numeric 10  √  1 Box Count
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_order c_activity_id numeric 10  √  null Business Activity
c_orderline c_activity_id numeric 10  √  null Business Activity
c_payment c_activity_id numeric 10  √  null Business Activity
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
c_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_payment c_banktransfer_id numeric 10  √  NULL::numeric Bank Transfer
c_payment c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bp_shippingacct c_bp_shippingacct_id numeric 10 Business Partner Shipping Account
m_shippingtransaction c_bp_shippingacct_id numeric 10  √  NULL::numeric Business Partner Shipping Account
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bp_shippingacct c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_charge c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_order c_bpartner_id numeric 10 Identifies a Business Partner
c_orderline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_payment c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_distributionlistline c_bpartner_id numeric 10 Identifies a Business Partner
m_distributionrun c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_productpricevendorbreak c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_shipper c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_shippingtransaction c_bpartner_id numeric 10  √  NULL::numeric Identifies a Business Partner
t_distributionrundetail c_bpartner_id numeric 10 Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bp_shippingacct c_bpartner_location_id numeric 10  √  NULL::numeric Identifies the (ship to) address for this Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_order c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_orderline c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_project c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
m_distributionlistline c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
m_distributionrun c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
m_shippingtransaction c_bpartner_location_id numeric 10  √  NULL::numeric Identifies the (ship to) address for this Business Partner
t_distributionrundetail c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_project c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
c_order c_campaign_id numeric 10  √  null Marketing Campaign
c_orderline c_campaign_id numeric 10  √  null Marketing Campaign
c_payment c_campaign_id numeric 10  √  null Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
c_payment c_cashbook_id numeric 10  √  null Cash Book for recording petty cash transactions
c_order c_cashline_id numeric 10  √  null Cash Journal Line
c_order c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_charge c_charge_id numeric 10 Additional document charges
c_order c_charge_id numeric 10  √  null Additional document charges
c_orderline c_charge_id numeric 10  √  null Additional document charges
c_payment c_charge_id numeric 10  √  null Additional document charges
c_charge c_chargetype_id numeric 10  √  null Charge Type
c_order c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_payment c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_tax c_country_id numeric 10  √  null Country
c_tax c_countrygroupfrom_id numeric 10  √  NULL::numeric Country Group From
c_tax c_countrygroupto_id numeric 10  √  NULL::numeric Country Group To
c_order c_currency_id numeric 10 The Currency for this record
c_orderline c_currency_id numeric 10 The Currency for this record
c_payment c_currency_id numeric 10 The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
m_pricelist c_currency_id numeric 10 The Currency for this record
m_shippingtransaction c_currency_id numeric 10  √  NULL::numeric The Currency for this record
c_payment c_depositbatch_id numeric 10  √  NULL::numeric Deposit Batch
c_order c_doctype_id numeric 10 Document type or rules
c_payment c_doctype_id numeric 10 Document type or rules
c_order c_doctypetarget_id numeric 10 Target document type for conversing documents
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_payment c_invoice_id numeric 10  √  null Invoice Identifier
m_shippingtransaction c_invoice_id numeric 10  √  NULL::numeric Invoice Identifier
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
c_bpartner_location c_location_id numeric 10  √  null Location or Address
m_warehouse c_location_id numeric 10 Location or Address
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_order c_order_id numeric 10 Order
c_orderline c_order_id numeric 10 Order
c_orderpayschedule c_order_id numeric 10 Order
c_ordertax c_order_id numeric 10 Order
c_payment c_order_id numeric 10  √  null Order
c_pospayment c_order_id numeric 10 Order
m_shippingtransaction c_order_id numeric 10  √  NULL::numeric Order
c_orderline c_orderline_id numeric 10 Sales Order Line
c_orderpayschedule c_orderpayschedule_id numeric 10 Order Payment Schedule
c_order c_ordersource_id numeric 10  √  null Order Source
c_ordersource c_ordersource_id numeric 10 Order Source
c_order c_payment_id numeric 10  √  null Payment identifier
c_payment c_payment_id numeric 10 Payment identifier
c_pospayment c_payment_id numeric 10  √  NULL::numeric Payment identifier
c_payment c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_payment c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_order c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_orderpayschedule c_payschedule_id numeric 10  √  NULL::numeric Payment Schedule Template
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_order c_pos_id numeric 10  √  null Point of Sales Terminal
c_pospayment c_pospayment_id numeric 10 POS Payment
c_payment c_postendertype_id numeric 10  √  NULL::numeric POS Tender Type
c_pospayment c_postendertype_id numeric 10 POS Tender Type
c_postendertype c_postendertype_id numeric 10 POS Tender Type
c_order c_project_id numeric 10  √  null Financial Project
c_orderline c_project_id numeric 10  √  null Financial Project
c_payment c_project_id numeric 10  √  null Financial Project
c_project c_project_id numeric 10 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_project c_projecttype_id numeric 10  √  null Type of the project
c_tax c_region_id numeric 10  √  null Identifies a geographical Region
c_revenuerecognition c_revenuerecognition_id numeric 10 Method for recording revenue
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_servicelevel c_revenuerecognition_plan_id numeric 10 Plan for recognizing or recording revenue
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
c_servicelevel c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevelline c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevelline c_servicelevelline_id numeric 10 Product Revenue Recognition Service Level Line
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_orderline c_tax_id numeric 10 Tax identifier
c_ordertax c_tax_id numeric 10 Tax identifier
c_tax c_tax_id numeric 10 Tax identifier
m_rmatax c_tax_id numeric 10 Tax identifier
c_charge c_taxcategory_id numeric 10  √  null Tax Category
c_tax c_taxcategory_id numeric 10 Tax Category
c_taxcategory c_taxcategory_id numeric 10 Tax Category
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_ordertax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_tax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
m_rmatax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_orderline c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
m_shippingtransaction c_uom_length_id numeric 10  √  NULL::numeric Standard Unit of Measure for Length
m_shippingtransactionline c_uom_length_id numeric 10  √  NULL::numeric Standard Unit of Measure for Length
m_shippingtransaction c_uom_weight_id numeric 10  √  NULL::numeric Standard Unit of Measure for Weight
m_shippingtransactionline c_uom_weight_id numeric 10  √  NULL::numeric Standard Unit of Measure for Weight
m_commodityshipment countryofmanufacture_id numeric 10 NULL::numeric Country Of Manufacture
ad_user createdby numeric 10 User who created this records
c_bp_shippingacct createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_bpartner_location createdby numeric 10 User who created this records
c_charge createdby numeric 10 User who created this records
c_order createdby numeric 10 User who created this records
c_orderline createdby numeric 10 User who created this records
c_orderpayschedule createdby numeric 10 User who created this records
c_ordersource createdby numeric 10 User who created this records
c_ordertax createdby numeric 10 User who created this records
c_payment createdby numeric 10 User who created this records
c_paymentterm createdby numeric 10 User who created this records
c_pospayment createdby numeric 10 User who created this records
c_postendertype createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
c_revenuerecognition createdby numeric 10 User who created this records
c_servicelevel createdby numeric 10 User who created this records
c_servicelevelline createdby numeric 10 User who created this records
c_tax createdby numeric 10 User who created this records
c_taxcategory createdby numeric 10 User who created this records
m_commodityshipment createdby numeric 10 User who created this records
m_distributionlist createdby numeric 10 User who created this records
m_distributionlistline createdby numeric 10 User who created this records
m_distributionrun createdby numeric 10 User who created this records
m_distributionrunline createdby numeric 10 User who created this records
m_pricelist createdby numeric 10 User who created this records
m_pricelist_version createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_productprice createdby numeric 10 User who created this records
m_productpricevendorbreak createdby numeric 10 User who created this records
m_rmatax createdby numeric 10 User who created this records
m_rmatype createdby numeric 10 User who created this records
m_shipper createdby numeric 10 User who created this records
m_shippercfg createdby numeric 10 User who created this records
m_shipperlabels createdby numeric 10 User who created this records
m_shipperlabelscfg createdby numeric 10 User who created this records
m_shipperpackaging createdby numeric 10 User who created this records
m_shipperpackagingcfg createdby numeric 10 User who created this records
m_shipperpickuptypes createdby numeric 10 User who created this records
m_shipperpickuptypescfg createdby numeric 10 User who created this records
m_shippingprocessor createdby numeric 10 User who created this records
m_shippingprocessorcfg createdby numeric 10 User who created this records
m_shippingtransaction createdby numeric 10 User who created this records
m_shippingtransactionline createdby numeric 10 User who created this records
m_warehouse createdby numeric 10 User who created this records
t_distributionrundetail createdby numeric 10 User who created this records
c_payment creditcardexpmm numeric 10  √  null Expiry Month
c_payment creditcardexpyy numeric 10  √  null Expiry Year
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
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
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
c_revenuerecognition fixedrecogday numeric 10  √  NULL::numeric Day of the period recognition occurs
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
m_shippingtransaction fob varchar 10  √  NULL::character varying Freight Terms
m_shippingtransaction freightcharges varchar 10  √  NULL::character varying Freight Charges
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
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_shippingtransaction holdaddress_id numeric 10  √  NULL::numeric Hold Address
m_shippingprocessorcfg hostport numeric 10 Host Communication Port
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
c_orderline line numeric 10 Unique line for this document
m_distributionrunline line numeric 10 Unique line for this document
c_order link_order_id numeric 10  √  null This field links a sales order to the purchase order that is generated from it.
c_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_bpartner logo_id numeric 10  √  NULL::numeric Logo
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
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_commodityshipment m_commodityshipment_id numeric 10 Commodity Shipment
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_pricelist_version m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_distributionlist m_distributionlist_id numeric 10 Distribution Lists allow to distribute products to a selected list of partners
m_distributionlistline m_distributionlist_id numeric 10 Distribution Lists allow to distribute products to a selected list of partners
m_distributionrunline m_distributionlist_id numeric 10 Distribution Lists allow to distribute products to a selected list of partners
t_distributionrundetail m_distributionlist_id numeric 10 Distribution Lists allow to distribute products to a selected list of partners
m_distributionlistline m_distributionlistline_id numeric 10 Distribution List Line with Business Partner and Quantity/Percentage
t_distributionrundetail m_distributionlistline_id numeric 10 Distribution List Line with Business Partner and Quantity/Percentage
m_distributionrun m_distributionrun_id numeric 10 Distribution Run create Orders to distribute products to a selected list of partners
m_distributionrunline m_distributionrun_id numeric 10 Distribution Run create Orders to distribute products to a selected list of partners
t_distributionrundetail m_distributionrun_id numeric 10 Distribution Run create Orders to distribute products to a selected list of partners
m_distributionrunline m_distributionrunline_id numeric 10 Distribution Run Lines define Distribution List, the Product and Quantities
t_distributionrundetail m_distributionrunline_id numeric 10 Distribution Run Lines define Distribution List, the Product and Quantities
c_order m_freightcategory_id numeric 10  √  NULL::numeric Category of the Freight
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_shippingtransaction m_inout_id numeric 10  √  NULL::numeric Material Shipment Document
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_shippingtransaction m_package_id numeric 10  √  NULL::numeric Shipment Package
m_shippingtransactionline m_packagemps_id numeric 10  √  NULL::numeric Package MPS
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_order m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_version_base_id numeric 10  √  null Source for Price list calculations
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_pricelist_version m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productprice m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productpricevendorbreak m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_product m_product_category_id numeric 10 Category of a Product
c_orderline m_product_id numeric 10  √  null Product, Service, Item
c_servicelevel m_product_id numeric 10 Product, Service, Item
m_commodityshipment m_product_id numeric 10  √  NULL::numeric Product, Service, Item
m_distributionrunline m_product_id numeric 10 Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_productprice m_product_id numeric 10 Product, Service, Item
m_productpricevendorbreak m_product_id numeric 10 Product, Service, Item
t_distributionrundetail m_product_id numeric 10 Product, Service, Item
m_productprice m_productprice_id numeric 10 NULL::numeric Intersection between a Product and a Price List Version
m_productpricevendorbreak m_productpricevendorbreak_id numeric 10 Product Price Break
c_orderline m_promotion_id numeric 10  √  null Promotion
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
m_rmatax m_rma_id numeric 10 Return Material Authorization
m_rmatype m_rmatype_id numeric 10 Return Material Authorization Type
c_order m_shipper_id numeric 10  √  null Method or manner of product delivery
c_orderline m_shipper_id numeric 10  √  null Method or manner of product delivery
m_shipper m_shipper_id numeric 10 Method or manner of product delivery
m_shipperlabels m_shipper_id numeric 10 Method or manner of product delivery
m_shipperpackaging m_shipper_id numeric 10 Method or manner of product delivery
m_shipperpickuptypes m_shipper_id numeric 10 Method or manner of product delivery
m_shippingtransaction m_shipper_id numeric 10 Method or manner of product delivery
m_shipper m_shippercfg_id numeric 10  √  NULL::numeric Shipper Configuration
m_shippercfg m_shippercfg_id numeric 10 Shipper Configuration
m_shipperlabelscfg m_shippercfg_id numeric 10 Shipper Configuration
m_shipperpackagingcfg m_shippercfg_id numeric 10 Shipper Configuration
m_shipperpickuptypescfg m_shippercfg_id numeric 10 Shipper Configuration
m_shipperlabels m_shipperlabels_id numeric 10 Shipper Labels
m_shippingtransaction m_shipperlabels_id numeric 10  √  NULL::numeric Shipper Labels
m_shipperlabels m_shipperlabelscfg_id numeric 10 Shipper Labels Configuration
m_shipperlabelscfg m_shipperlabelscfg_id numeric 10 Shipper Labels Configuration
m_shipperpackaging m_shipperpackaging_id numeric 10 Shipper Packaging
m_shippingtransaction m_shipperpackaging_id numeric 10  √  NULL::numeric Shipper Packaging
m_shipperpackaging m_shipperpackagingcfg_id numeric 10 Shipper Packaging Configuration
m_shipperpackagingcfg m_shipperpackagingcfg_id numeric 10 Shipper Packaging Configuration
m_shipperpickuptypes m_shipperpickuptypes_id numeric 10 Shipper Pickup Types
m_shippingtransaction m_shipperpickuptypes_id numeric 10  √  NULL::numeric Shipper Pickup Types
m_shipperpickuptypes m_shipperpickuptypescfg_id numeric 10 Shipper Pickup Types Configuration
m_shipperpickuptypescfg m_shipperpickuptypescfg_id numeric 10 Shipper Pickup Types Configuration
c_bp_shippingacct m_shippingprocessor_id numeric 10  √  NULL::numeric Shipping Processor
m_shipper m_shippingprocessor_id numeric 10  √  NULL::numeric Shipping Processor
m_shippingprocessor m_shippingprocessor_id numeric 10 Shipping Processor
m_shippingtransaction m_shippingprocessor_id numeric 10  √  NULL::numeric Shipping Processor
m_shippercfg m_shippingprocessorcfg_id numeric 10  √  NULL::numeric Shipping Processor Configuration
m_shippingprocessor m_shippingprocessorcfg_id numeric 10 Shipping Processor Configuration
m_shippingprocessorcfg m_shippingprocessorcfg_id numeric 10 Shipping Processor Configuration
m_shippingtransaction m_shippingtransaction_id numeric 10 Shipping Transaction
m_shippingtransactionline m_shippingtransaction_id numeric 10 Shipping Transaction
m_shippingtransactionline m_shippingtransactionline_id numeric 10 Shipping Transaction Line
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_orderline m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_shippingtransaction m_warehouse_id numeric 10  √  NULL::numeric Storage Warehouse and Service Point
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
c_paymentterm netdays numeric 10 Net Days in which payment is due
c_revenuerecognition nomonths numeric 10  √  null Number of Months
c_bpartner numberemployees numeric 10  √  null Number of employees
c_tax parent_tax_id numeric 10  √  null Parent Tax indicates a tax that is made up of multiple taxes
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_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_orderline pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
m_shippingprocessorcfg proxyport numeric 10  √  NULL::numeric Port of your proxy server
c_order quotationorder_id numeric 10  √  NULL::numeric Quotation used for generating this order
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
c_order ref_order_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_orderline ref_orderline_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_payment ref_payment_id numeric 10  √  null Referenced Payment
m_shippingtransaction returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_shippingtransaction returnlocation_id numeric 10  √  NULL::numeric Return Location
m_shippingtransaction returnuser_id numeric 10  √  NULL::numeric Return User/Contact
c_payment reversal_id numeric 10  √  null ID of document reversal
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
c_orderline s_resourceassignment_id numeric 10  √  null Resource Assignment
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_order salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_shippingtransaction salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
m_shippingtransactionline seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
c_tax taxindicator varchar 10  √  null Short form for Tax to be printed on documents
c_tax to_country_id numeric 10  √  null Receiving Country
c_tax to_region_id numeric 10  √  null Receiving Region
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
ad_user updatedby numeric 10 User who updated this records
c_bp_shippingacct updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner_location updatedby numeric 10 User who updated this records
c_charge updatedby numeric 10 User who updated this records
c_order updatedby numeric 10 User who updated this records
c_orderline updatedby numeric 10 User who updated this records
c_orderpayschedule updatedby numeric 10 User who updated this records
c_ordersource updatedby numeric 10 User who updated this records
c_ordertax updatedby numeric 10 User who updated this records
c_payment updatedby numeric 10 User who updated this records
c_paymentterm updatedby numeric 10 User who updated this records
c_pospayment updatedby numeric 10 User who updated this records
c_postendertype updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
c_revenuerecognition updatedby numeric 10 User who updated this records
c_servicelevel updatedby numeric 10 User who updated this records
c_servicelevelline updatedby numeric 10 User who updated this records
c_tax updatedby numeric 10 User who updated this records
c_taxcategory updatedby numeric 10 User who updated this records
m_commodityshipment updatedby numeric 10 User who updated this records
m_distributionlist updatedby numeric 10 User who updated this records
m_distributionlistline updatedby numeric 10 User who updated this records
m_distributionrun updatedby numeric 10 User who updated this records
m_distributionrunline updatedby numeric 10 User who updated this records
m_pricelist updatedby numeric 10 User who updated this records
m_pricelist_version updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_productprice updatedby numeric 10 User who updated this records
m_productpricevendorbreak updatedby numeric 10 User who updated this records
m_rmatax updatedby numeric 10 User who updated this records
m_rmatype updatedby numeric 10 User who updated this records
m_shipper updatedby numeric 10 User who updated this records
m_shippercfg updatedby numeric 10 User who updated this records
m_shipperlabels updatedby numeric 10 User who updated this records
m_shipperlabelscfg updatedby numeric 10 User who updated this records
m_shipperpackaging updatedby numeric 10 User who updated this records
m_shipperpackagingcfg updatedby numeric 10 User who updated this records
m_shipperpickuptypes updatedby numeric 10 User who updated this records
m_shipperpickuptypescfg updatedby numeric 10 User who updated this records
m_shippingprocessor updatedby numeric 10 User who updated this records
m_shippingprocessorcfg updatedby numeric 10 User who updated this records
m_shippingtransaction updatedby numeric 10 User who updated this records
m_shippingtransactionline updatedby numeric 10 User who updated this records
m_warehouse updatedby numeric 10 User who updated this records
t_distributionrundetail updatedby numeric 10 User who updated this records
c_order user1_id numeric 10  √  null User defined list element #1
c_orderline user1_id numeric 10  √  null User defined list element #1
c_payment user1_id numeric 10  √  null User defined list element #1
c_order user2_id numeric 10  √  null User defined list element #2
c_orderline user2_id numeric 10  √  null User defined list element #2
c_payment user2_id numeric 10  √  null User defined list element #2
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_product classification varchar 12  √  null Classification for grouping
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
c_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment accountno varchar 20  √  null Account Number
c_pospayment accountno varchar 20  √  NULL::character varying Account Number
c_payment checkno varchar 20  √  null Check Number
c_pospayment checkno varchar 20  √  NULL::character varying Check Number
c_taxcategory commoditycode varchar 20  √  null Commodity code used for tax calculation
c_payment creditcardnumber varchar 20  √  null Credit Card Number
c_pospayment creditcardnumber varchar 20  √  NULL::character varying Credit Card Number
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_pospayment depositgroup varchar 20  √  NULL::character varying Deposit Group
c_payment micr varchar 20  √  null Combination of routing no, account and check no
c_pospayment micr varchar 20  √  NULL::character varying Combination of routing no, account and check no
c_payment orig_trxid varchar 20  √  null Original Transaction ID
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_payment r_authcode varchar 20  √  null Authorization Code returned
c_payment r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
c_payment r_pnref varchar 20  √  null Payment reference
c_payment r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
c_payment r_result varchar 20  √  null Result of transmission
c_payment routingno varchar 20  √  null Bank Routing Number
c_pospayment routingno varchar 20  √  NULL::character varying Bank Routing Number
c_payment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
c_pospayment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
c_bpartner taxid varchar 20  √  null Tax Identification
ad_user userpin varchar 20  √  null User PIN
m_product versionno varchar 20  √  null Version Number
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
c_pospayment voiceauthcode varchar 20  √  NULL::character varying Voice Authorization Code from credit card company
c_order amountrefunded numeric 22,2  √  null Amount Refunded
c_order amounttendered numeric 22,2  √  null Amount Tendered
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_user created timestamp 29,6 now() Date this record was created
c_bp_shippingacct created timestamp 29,6 statement_timestamp() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner_location created timestamp 29,6 now() Date this record was created
c_charge created timestamp 29,6 now() Date this record was created
c_order created timestamp 29,6 now() Date this record was created
c_orderline created timestamp 29,6 now() Date this record was created
c_orderpayschedule created timestamp 29,6 statement_timestamp() Date this record was created
c_ordersource created timestamp 29,6 statement_timestamp() Date this record was created
c_ordertax created timestamp 29,6 now() Date this record was created
c_payment created timestamp 29,6 now() Date this record was created
c_paymentterm created timestamp 29,6 now() Date this record was created
c_pospayment created timestamp 29,6 statement_timestamp() Date this record was created
c_postendertype created timestamp 29,6 statement_timestamp() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
c_revenuerecognition created timestamp 29,6 now() Date this record was created
c_servicelevel created timestamp 29,6 now() Date this record was created
c_servicelevelline created timestamp 29,6 now() Date this record was created
c_tax created timestamp 29,6 now() Date this record was created
c_taxcategory created timestamp 29,6 now() Date this record was created
m_commodityshipment created timestamp 29,6 statement_timestamp() Date this record was created
m_distributionlist created timestamp 29,6 now() Date this record was created
m_distributionlistline created timestamp 29,6 now() Date this record was created
m_distributionrun created timestamp 29,6 now() Date this record was created
m_distributionrunline created timestamp 29,6 now() Date this record was created
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist_version created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_productprice created timestamp 29,6 now() Date this record was created
m_productpricevendorbreak created timestamp 29,6 statement_timestamp() Date this record was created
m_rmatax created timestamp 29,6 statement_timestamp() Date this record was created
m_rmatype created timestamp 29,6 now() Date this record was created
m_shipper created timestamp 29,6 now() Date this record was created
m_shippercfg created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperlabels created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperlabelscfg created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperpackaging created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperpackagingcfg created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperpickuptypes created timestamp 29,6 statement_timestamp() Date this record was created
m_shipperpickuptypescfg created timestamp 29,6 statement_timestamp() Date this record was created
m_shippingprocessor created timestamp 29,6 statement_timestamp() Date this record was created
m_shippingprocessorcfg created timestamp 29,6 statement_timestamp() Date this record was created
m_shippingtransaction created timestamp 29,6 statement_timestamp() Date this record was created
m_shippingtransactionline created timestamp 29,6 statement_timestamp() Date this record was created
m_warehouse created timestamp 29,6 now() Date this record was created
t_distributionrundetail created timestamp 29,6 now() Date this record was created
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
c_order dateacct timestamp 29,6 Accounting Date
c_payment dateacct timestamp 29,6 Accounting Date
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_orderline datedelivered timestamp 29,6  √  null Date when the product was delivered
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_orderline dateinvoiced timestamp 29,6  √  null Date printed on Invoice
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
c_order dateordered timestamp 29,6 Date of Order
c_orderline dateordered timestamp 29,6 Date of Order
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
c_order dateprinted timestamp 29,6  √  null Date the document was printed.
c_order datepromised timestamp 29,6  √  null Date Order was promised
c_orderline datepromised timestamp 29,6  √  null Date Order was promised
c_pospayment datepromised timestamp 29,6  √  null Date Order was promised
m_shippingtransaction datereceived timestamp 29,6  √  null Date a product was received
c_payment datetrx timestamp 29,6 Transaction Date
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_orderpayschedule discountdate timestamp 29,6 Last Date for payments with discount
c_orderpayschedule duedate timestamp 29,6 Date when the payment is due
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
m_shippingtransaction homedeliverypremiumdate timestamp 29,6  √  null Date
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
m_shippingtransaction latestpickuptime timestamp 29,6  √  null Latest Pickup Time
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_servicelevelline servicedate timestamp 29,6 Date service was provided
m_shippingtransaction shipdate timestamp 29,6  √  null Shipment Date/Time
ad_user updated timestamp 29,6 now() Date this record was updated
c_bp_shippingacct updated timestamp 29,6 statement_timestamp() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner_location updated timestamp 29,6 now() Date this record was updated
c_charge updated timestamp 29,6 now() Date this record was updated
c_order updated timestamp 29,6 now() Date this record was updated
c_orderline updated timestamp 29,6 now() Date this record was updated
c_orderpayschedule updated timestamp 29,6 statement_timestamp() Date this record was updated
c_ordersource updated timestamp 29,6 statement_timestamp() Date this record was updated
c_ordertax updated timestamp 29,6 now() Date this record was updated
c_payment updated timestamp 29,6 now() Date this record was updated
c_paymentterm updated timestamp 29,6 now() Date this record was updated
c_pospayment updated timestamp 29,6 statement_timestamp() Date this record was updated
c_postendertype updated timestamp 29,6 statement_timestamp() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
c_revenuerecognition updated timestamp 29,6 now() Date this record was updated
c_servicelevel updated timestamp 29,6 now() Date this record was updated
c_servicelevelline updated timestamp 29,6 now() Date this record was updated
c_tax updated timestamp 29,6 now() Date this record was updated
c_taxcategory updated timestamp 29,6 now() Date this record was updated
m_commodityshipment updated timestamp 29,6 statement_timestamp() Date this record was updated
m_distributionlist updated timestamp 29,6 now() Date this record was updated
m_distributionlistline updated timestamp 29,6 now() Date this record was updated
m_distributionrun updated timestamp 29,6 now() Date this record was updated
m_distributionrunline updated timestamp 29,6 now() Date this record was updated
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist_version updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_productprice updated timestamp 29,6 now() Date this record was updated
m_productpricevendorbreak updated timestamp 29,6 statement_timestamp() Date this record was updated
m_rmatax updated timestamp 29,6 statement_timestamp() Date this record was updated
m_rmatype updated timestamp 29,6 now() Date this record was updated
m_shipper updated timestamp 29,6 now() Date this record was updated
m_shippercfg updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperlabels updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperlabelscfg updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperpackaging updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperpackagingcfg updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperpickuptypes updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shipperpickuptypescfg updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shippingprocessor updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shippingprocessorcfg updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shippingtransaction updated timestamp 29,6 statement_timestamp() Date this record was updated
m_shippingtransactionline updated timestamp 29,6 statement_timestamp() Date this record was updated
m_warehouse updated timestamp 29,6 now() Date this record was updated
t_distributionrundetail updated timestamp 29,6 now() Date this record was updated
c_tax validfrom timestamp 29,6 Valid from including this date (first day)
m_pricelist_version validfrom timestamp 29,6 Valid from including this date (first day)
m_shippingtransaction deliveryconfirmationtype varchar 30  √  NULL::character varying Delivery Confirmation Type
c_order documentno varchar 30 Document sequence number of the document
c_payment documentno varchar 30 Document sequence number of the document
m_shippingtransaction dothazardclassordivision varchar 30  √  NULL::character varying Dot Hazard Class or Division
m_commodityshipment exportlicensenum varchar 30  √  NULL::character varying Export License Number
m_commodityshipment harmonizedcode varchar 30 Harmonized Code
m_shippingtransaction homedeliverypremiumphone varchar 30  √  NULL::character varying Phone Number
m_shippingtransaction homedeliverypremiumtype varchar 30  √  NULL::character varying Home Delivery Premium Type
m_shippingtransaction poreference varchar 30  √  NULL::character varying Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order promotioncode varchar 30  √  null User entered promotion code at sales time
m_product sku varchar 30  √  null Stock Keeping Unit
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
c_bp_shippingacct c_bp_shippingacct_uu varchar 36  √  NULL::character varying C_BP_ShippingAcct_UU
c_bpartner_location c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_charge c_charge_uu varchar 36  √  NULL::character varying C_Charge_UU
c_order c_order_uu varchar 36  √  NULL::character varying C_Order_UU
c_orderline c_orderline_uu varchar 36  √  NULL::character varying C_OrderLine_UU
c_orderpayschedule c_orderpayschedule_uu varchar 36  √  NULL::character varying C_OrderPaySchedule_UU
c_ordersource c_ordersource_uu varchar 36  √  NULL::character varying C_OrderSource_UU
c_ordertax c_ordertax_uu varchar 36  √  NULL::character varying C_OrderTax_UU
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
c_pospayment c_pospayment_uu varchar 36  √  NULL::character varying C_POSPayment_UU
c_postendertype c_postendertype_uu varchar 36  √  NULL::character varying C_POSTenderType_UU
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_revenuerecognition c_revenuerecognition_uu varchar 36  √  NULL::character varying C_RevenueRecognition_UU
c_servicelevel c_servicelevel_uu varchar 36  √  NULL::character varying C_ServiceLevel_UU
c_servicelevelline c_servicelevelline_uu varchar 36  √  NULL::character varying C_ServiceLevelLine_UU
c_tax c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_taxcategory c_taxcategory_uu varchar 36  √  NULL::character varying C_TaxCategory_UU
m_commodityshipment m_commodityshipment_uu varchar 36  √  NULL::character varying M_CommodityShipment_UU
m_distributionlist m_distributionlist_uu varchar 36  √  NULL::character varying M_DistributionList_UU
m_distributionlistline m_distributionlistline_uu varchar 36  √  NULL::character varying M_DistributionListLine_UU
m_distributionrun m_distributionrun_uu varchar 36  √  NULL::character varying M_DistributionRun_UU
m_distributionrunline m_distributionrunline_uu varchar 36  √  NULL::character varying M_DistributionRunLine_UU
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying M_PriceList_Version_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_productprice m_productprice_uu varchar 36  √  NULL::character varying M_ProductPrice_UU
m_productpricevendorbreak m_productpricevendorbreak_uu varchar 36  √  NULL::character varying M_ProductPriceVendorBreak_UU
m_rmatax m_rmatax_uu varchar 36  √  NULL::character varying M_RMATax_UU
m_rmatype m_rmatype_uu varchar 36  √  NULL::character varying M_RMAType_UU
m_shipper m_shipper_uu varchar 36  √  NULL::character varying M_Shipper_UU
m_shippercfg m_shippercfg_uu varchar 36  √  NULL::character varying M_ShipperCfg_UU
m_shipperlabels m_shipperlabels_uu varchar 36  √  NULL::character varying M_ShipperLabels_UU
m_shipperlabelscfg m_shipperlabelscfg_uu varchar 36  √  NULL::character varying M_ShipperLabelsCfg_UU
m_shipperpackaging m_shipperpackaging_uu varchar 36  √  NULL::character varying M_ShipperPackaging_UU
m_shipperpackagingcfg m_shipperpackagingcfg_uu varchar 36  √  NULL::character varying M_ShipperPackagingCfg_UU
m_shipperpickuptypes m_shipperpickuptypes_uu varchar 36  √  NULL::character varying M_ShipperPickupTypes_UU
m_shipperpickuptypescfg m_shipperpickuptypescfg_uu varchar 36  √  NULL::character varying M_ShipperPickupTypesCfg_UU
m_shippingprocessor m_shippingprocessor_uu varchar 36  √  NULL::character varying M_ShippingProcessor_UU
m_shippingprocessorcfg m_shippingprocessorcfg_uu varchar 36  √  NULL::character varying M_ShippingProcessorCfg_UU
m_shippingtransaction m_shippingtransaction_uu varchar 36  √  NULL::character varying M_ShippingTransaction_UU
m_shippingtransactionline m_shippingtransactionline_uu varchar 36  √  NULL::character varying M_ShippingTransactionLine_UU
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
t_distributionrundetail t_distributionrundetail_uu varchar 36  √  NULL::character varying T_DistributionRunDetail_UU
c_payment a_country varchar 40  √  null Country
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_bp_shippingacct dutiesshipperaccount varchar 40  √  NULL::character varying Duties Shipper Account
m_shippingtransaction dutiesshipperaccount varchar 40  √  NULL::character varying Duties Shipper Account
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user fax varchar 40  √  null Facsimile number
c_bpartner_location fax varchar 40  √  null Facsimile number
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
c_pospayment iban varchar 40  √  NULL::character varying International Bank Account Number
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
ad_user phone varchar 40  √  null Identifies a telephone number
c_bpartner_location phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner_location phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_bp_shippingacct shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_shippingtransaction shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_shippercfg shippingservicecode varchar 40  √  NULL::character varying Service Code
ad_user title varchar 40  √  null Name this entity is referred to as
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_ordersource value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_postendertype value varchar 40 Search key for the record in the format required - must be unique
c_project value varchar 40 Search key for the record in the format required - must be unique
m_shipperlabelscfg value varchar 40 Search key for the record in the format required - must be unique
m_shipperpackagingcfg value varchar 40 Search key for the record in the format required - must be unique
m_shipperpickuptypescfg value varchar 40 Search key for the record in the format required - must be unique
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
c_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_email varchar 60  √  null Email Address
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_pospayment a_name varchar 60  √  NULL::character varying Name on Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
ad_user bpname varchar 60  √  NULL::character varying BP Name
m_shippingprocessor connectionkey varchar 60  √  NULL::character varying Connection Key
m_shippingprocessor connectionpassword varchar 60 Connection Password
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_payment customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_payment customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile ID
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_payment customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
m_shippingprocessorcfg hostaddress varchar 60 Host Address URL or DNS
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user name varchar 60 Alphanumeric identifier of the entity
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_charge name varchar 60 Alphanumeric identifier of the entity
c_ordersource name varchar 60 Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_postendertype name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
c_revenuerecognition name varchar 60 Alphanumeric identifier of the entity
c_tax name varchar 60 Alphanumeric identifier of the entity
c_taxcategory name varchar 60 Alphanumeric identifier of the entity
m_distributionlist name varchar 60 Alphanumeric identifier of the entity
m_distributionrun name varchar 60 Alphanumeric identifier of the entity
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist_version name varchar 60 Alphanumeric identifier of the entity
m_rmatype name varchar 60 Alphanumeric identifier of the entity
m_shipper name varchar 60 NULL::character varying Alphanumeric identifier of the entity
m_shippercfg name varchar 60 Alphanumeric identifier of the entity
m_shipperlabels name varchar 60 NULL::character varying Alphanumeric identifier of the entity
m_shipperlabelscfg name varchar 60 Alphanumeric identifier of the entity
m_shipperpackaging name varchar 60 NULL::character varying Alphanumeric identifier of the entity
m_shipperpackagingcfg name varchar 60 Alphanumeric identifier of the entity
m_shipperpickuptypes name varchar 60 Alphanumeric identifier of the entity
m_shipperpickuptypescfg name varchar 60 Alphanumeric identifier of the entity
m_shippingprocessor name varchar 60 NULL::character varying Alphanumeric identifier of the entity
m_shippingprocessorcfg name varchar 60 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_payment ponum varchar 60  √  null Purchase Order Number
m_shippingprocessorcfg proxyaddress varchar 60  √  NULL::character varying Address of your proxy server
m_shippingprocessorcfg proxylogon varchar 60  √  NULL::character varying Logon of your proxy server
m_shippingprocessorcfg proxypassword varchar 60  √  NULL::character varying Password of your proxy server
c_payment r_respmsg varchar 60  √  null Response message
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_shippingprocessorcfg servicepath varchar 60  √  NULL::character varying Service Path
m_shippingprocessorcfg shippingprocessorclass varchar 60  √  NULL::character varying Shipping Processor Class
m_shippingprocessor userid varchar 60 User ID or account number
c_payment swipe varchar 80  √  null Track 1 and 2 of the Credit Card
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_bpartner name varchar 120 Alphanumeric identifier of the entity
m_shippercfg trackingurl varchar 120  √  NULL::character varying URL of the shipper to track shipments
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_user description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_charge description varchar 255  √  null Optional short description of the record
c_order description varchar 255  √  null Optional short description of the record
c_orderline description varchar 255  √  null Optional short description of the record
c_ordersource description varchar 255  √  null Optional short description of the record
c_payment description varchar 255  √  null Optional short description of the record
c_paymentterm description varchar 255  √  null Optional short description of the record
c_postendertype description varchar 255  √  NULL::character varying Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_revenuerecognition description varchar 255  √  null Optional short description of the record
c_servicelevel description varchar 255  √  null Optional short description of the record
c_servicelevelline description varchar 255  √  null Optional short description of the record
c_tax description varchar 255  √  null Optional short description of the record
c_taxcategory description varchar 255  √  null Optional short description of the record
m_commodityshipment description varchar 255  √  NULL::character varying Optional short description of the record
m_distributionlist description varchar 255  √  null Optional short description of the record
m_distributionlistline description varchar 255  √  null Optional short description of the record
m_distributionrun description varchar 255  √  null Optional short description of the record
m_distributionrunline description varchar 255  √  null Optional short description of the record
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist_version description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_rmatype description varchar 255  √  null Optional short description of the record
m_shippercfg description varchar 255  √  NULL::character varying Optional short description of the record
m_shipperlabelscfg description varchar 255  √  NULL::character varying Optional short description of the record
m_shipperpackagingcfg description varchar 255  √  NULL::character varying Optional short description of the record
m_shipperpickuptypescfg description varchar 255  √  NULL::character varying Optional short description of the record
m_shippingprocessorcfg description varchar 255  √  NULL::character varying Optional short description of the record
m_shippingtransaction description varchar 255  √  NULL::character varying Optional short description of the record
m_shippingtransactionline description varchar 255  √  NULL::character varying Optional short description of the record
m_warehouse description varchar 255  √  null Optional short description of the record
ad_user emailuserpw varchar 255  √  null Password of your email user id
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
ad_user lastresult varchar 255  √  null Result of last contact
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
m_shippingtransactionline mastertrackingno varchar 255  √  NULL::character varying Master Tracking No
m_product name varchar 255 Alphanumeric identifier of the entity
m_shippingtransaction notificationmessage varchar 255  √  NULL::character varying Notification Message
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
m_shippingtransaction receivedinfo varchar 255  √  NULL::character varying Information of the receipt of the package (acknowledgement)
c_bp_shippingacct shippermeter varchar 255  √  NULL::character varying Shipper Meter
c_bpartner so_description varchar 255  √  null Description to be used on orders
m_shippingtransaction trackinginfo varchar 255  √  NULL::character varying Tracking Info
m_shippingtransaction trackingno varchar 255  √  NULL::character varying Number to track the shipment
m_shippingtransactionline trackingno varchar 255  √  NULL::character varying Number to track the shipment
c_order ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
m_product value varchar 510 Search key for the record in the format required - must be unique
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user securityquestion varchar 1024  √  null Security Question
ad_user comments varchar 2000  √  null Comments or additional information
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
m_product documentnote varchar 2000  √  null Additional information for a Document
c_ordersource help varchar 2000  √  null Comment or Hint
c_pospayment help varchar 2000  √  NULL::character varying Comment or Hint
c_postendertype help varchar 2000  √  NULL::character varying Comment or Hint
m_distributionlist help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
m_rmatype help varchar 2000  √  null Comment or Hint
c_project note varchar 2000  √  null Optional additional user defined information
c_payment r_info varchar 2000  √  null Response info
m_shippingtransaction rateinquirymessage varchar 2000  √  NULL::character varying
m_shippingtransaction shippingrespmessage varchar 2000  √  NULL::character varying Response Message