SchemaSpy Analysis of idempiere9.adempiere - ColumnsPOS Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:53 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 472 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_printcolor ad_client_id numeric 10 Client/Tenant for this installation.
ad_printcolor ad_org_id numeric 10 Organizational entity within client
ad_printcolor ad_printcolor_id numeric 10 Color used for printing and display
ad_printcolor ad_printcolor_uu varchar 36  √  NULL::character varying AD_PrintColor_UU
ad_printcolor code varchar 2000 Validation Code
ad_printcolor created timestamp 29,6 now() Date this record was created
ad_printcolor createdby numeric 10 User who created this records
ad_printcolor isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_printcolor isdefault bpchar 1 'N'::bpchar Default value
ad_printcolor name varchar 60 Alphanumeric identifier of the entity
ad_printcolor updated timestamp 29,6 now() Date this record was updated
ad_printcolor updatedby numeric 10 User who updated this records
ad_user ad_client_id numeric 10 Client/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 client
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
ad_user bpname varchar 60  √  NULL::character varying BP Name
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
ad_user comments varchar 2000  √  null Comments or additional information
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
ad_user created timestamp 29,6 now() Date this record was created
ad_user createdby numeric 10 User who created this records
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_user description varchar 255  √  null Optional short description of the record
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_user fax varchar 40  √  null Facsimile number
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
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
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
ad_user islocked bpchar 1 'N'::bpchar Locked
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
ad_user lastresult varchar 255  √  null Result of last contact
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
ad_user name varchar 60 Alphanumeric identifier of the entity
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
ad_user processing bpchar 1  √  null Process Now
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user securityquestion varchar 1024  √  null Security Question
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_user title varchar 40  √  null Name this entity is referred to as
ad_user updated timestamp 29,6 now() Date this record was updated
ad_user updatedby numeric 10 User who updated this records
ad_user userpin varchar 20  √  null User PIN
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
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
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner createdby numeric 10 User who created this records
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_bpartner description varchar 255  √  null Optional short description of the record
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_bpartner numberemployees numeric 10  √  null Number of employees
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
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_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_bpartner taxid varchar 20  √  null Tax Identification
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_doctype ad_client_id numeric 10 Client/Tenant for this installation.
c_doctype ad_org_id numeric 10 Organizational entity within client
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
c_doctype c_doctype_id numeric 10 Document type or rules
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
c_doctype created timestamp 29,6 now() Date this record was created
c_doctype createdby numeric 10 User who created this records
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
c_doctype description varchar 255  √  null Optional short description of the record
c_doctype docbasetype bpchar 3 Logical type of document
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
c_doctype documentcopies numeric 10 Number of copies to be printed
c_doctype documentnote varchar 2000  √  null Additional information for a Document
c_doctype gl_category_id numeric 10 General Ledger Category
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
c_doctype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Pricelist
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
c_doctype updated timestamp 29,6 now() Date this record was updated
c_doctype updatedby numeric 10 User who updated this records
c_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_country varchar 40  √  null Country
c_payment a_email varchar 60  √  null Email Address
c_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
c_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment accountno varchar 20  √  null Account Number
c_payment ad_client_id numeric 10 Client/Tenant for this installation.
c_payment ad_org_id numeric 10 Organizational entity within client
c_payment ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_payment c_activity_id numeric 10  √  null Business Activity
c_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_payment c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_payment c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_payment c_campaign_id numeric 10  √  null Marketing Campaign
c_payment c_cashbook_id numeric 10  √  null Cash Book for recording petty cash transactions
c_payment c_charge_id numeric 10  √  null Additional document charges
c_payment c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_payment c_currency_id numeric 10 The Currency for this record
c_payment c_depositbatch_id numeric 10  √  NULL::numeric Deposit Batch
c_payment c_doctype_id numeric 10 Document type or rules
c_payment c_invoice_id numeric 10  √  null Invoice Identifier
c_payment c_order_id numeric 10  √  null Order
c_payment c_payment_id numeric 10 Payment identifier
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
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_payment c_postendertype_id numeric 10  √  NULL::numeric POS Tender Type
c_payment c_project_id numeric 10  √  null Financial Project
c_payment chargeamt numeric 0  √  0 Charge Amount
c_payment checkno varchar 20  √  null Check Number
c_payment convertedamt numeric 0  √  null Converted Amount
c_payment created timestamp 29,6 now() Date this record was created
c_payment 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_payment creditcardnumber varchar 20  √  null Credit Card Number
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_payment currencyrate numeric 0  √  null Currency Conversion Rate
c_payment customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_payment customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile ID
c_payment customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_payment dateacct timestamp 29,6 Accounting Date
c_payment datetrx timestamp 29,6 Transaction Date
c_payment description varchar 255  √  null Optional short description of the record
c_payment discountamt numeric 0  √  0 Calculated amount of discount
c_payment docaction bpchar 2 The targeted status of the document
c_payment docstatus bpchar 2 The current status of the document
c_payment documentno varchar 30 Document sequence number of the document
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
c_payment isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payment isallocated bpchar 1 'N'::bpchar Indicates if the payment has been allocated
c_payment isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_payment isdelayedcapture bpchar 1 'N'::bpchar Charge after Shipment
c_payment 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)
c_payment isprepayment bpchar 1 'N'::bpchar The Payment/Receipt is a Prepayment
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_payment isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_payment isvoided bpchar 1 'N'::bpchar Voided
c_payment micr varchar 20  √  null Combination of routing no, account and check no
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_payment orig_trxid varchar 20  √  null Original Transaction ID
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_payment ponum varchar 60  √  null Purchase Order Number
c_payment posted bpchar 1 'N'::bpchar Posting status
c_payment processed bpchar 1 'N'::bpchar 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_payment processing bpchar 1  √  null Process Now
c_payment r_authcode varchar 20  √  null Authorization Code returned
c_payment r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
c_payment r_avsaddr bpchar 1  √  null This address has been verified
c_payment r_avszip bpchar 1  √  null The Zip Code has been verified
c_payment r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
c_payment r_info varchar 2000  √  null Response info
c_payment r_pnref varchar 20  √  null Payment reference
c_payment r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
c_payment r_respmsg varchar 60  √  null Response message
c_payment r_result varchar 20  √  null Result of transmission
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
c_payment ref_payment_id numeric 10  √  null Referenced Payment
c_payment reversal_id numeric 10  √  null ID of document reversal
c_payment routingno varchar 20  √  null Bank Routing Number
c_payment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
c_payment swipe varchar 80  √  null Track 1 and 2 of the Credit Card
c_payment taxamt numeric 0  √  0 Tax Amount for a document
c_payment tendertype bpchar 1 Method of Payment
c_payment trxtype bpchar 1 Type of credit card transaction
c_payment updated timestamp 29,6 now() Date this record was updated
c_payment updatedby numeric 10 User who updated this records
c_payment user1_id numeric 10  √  null User defined list element #1
c_payment user2_id numeric 10  √  null User defined list element #2
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
c_payment writeoffamt numeric 0  √  0 Amount to write-off
c_pos ad_client_id numeric 10 Client/Tenant for this installation.
c_pos ad_org_id numeric 10 Organizational entity within client
c_pos autologoutdelay numeric 10  √  NULL::numeric Automatically logout if terminal inactive for this period
c_pos c_bankaccount_id numeric 10  √  null Account at the Bank
c_pos c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
c_pos c_cashbook_id numeric 10  √  null Cash Book for recording petty cash transactions
c_pos c_doctype_id numeric 10  √  null Document type or rules
c_pos c_pos_id numeric 10 Point of Sales Terminal
c_pos c_pos_uu varchar 36  √  NULL::character varying C_POS_UU
c_pos c_poskeylayout_id numeric 10  √  null POS Function Key Layout
c_pos cashdrawer varchar 120  √  null CashDrawer
c_pos created timestamp 29,6 now() Date this record was created
c_pos createdby numeric 10 User who created this records
c_pos description varchar 255  √  null Optional short description of the record
c_pos help varchar 2000  √  null Comment or Hint
c_pos isactive bpchar 1 'Y'::bpchar The record is active in the system
c_pos ismodifyprice bpchar 1 'N'::bpchar Allow modifying the price
c_pos m_pricelist_id numeric 10 Unique identifier of a Price List
c_pos m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_pos name varchar 60 Alphanumeric identifier of the entity
c_pos osk_keylayout_id numeric 10  √  NULL::numeric The key layout to use for on screen keyboard for text fields.
c_pos osnp_keylayout_id numeric 10  √  NULL::numeric The key layout to use for on screen number pad for numeric fields.
c_pos printername varchar 60  √  null Name of the Printer
c_pos salesrep_id numeric 10 Sales Representative or Company Agent
c_pos updated timestamp 29,6 now() Date this record was updated
c_pos updatedby numeric 10 User who updated this records
c_poskey ad_client_id numeric 10 Client/Tenant for this installation.
c_poskey ad_image_id numeric 10  √  NULL::numeric Image or Icon
c_poskey ad_org_id numeric 10 Organizational entity within client
c_poskey ad_printcolor_id numeric 10  √  null Color used for printing and display
c_poskey ad_printfont_id numeric 10  √  NULL::numeric Maintain Print Font
c_poskey c_poskey_id numeric 10 POS Function Key
c_poskey c_poskey_uu varchar 36  √  NULL::character varying C_POSKey_UU
c_poskey c_poskeylayout_id numeric 10 POS Function Key Layout
c_poskey created timestamp 29,6 now() Date this record was created
c_poskey createdby numeric 10 User who created this records
c_poskey description varchar 255  √  null Optional short description of the record
c_poskey isactive bpchar 1 'Y'::bpchar The record is active in the system
c_poskey m_product_id numeric 10  √  null Product, Service, Item
c_poskey name varchar 60 Alphanumeric identifier of the entity
c_poskey qty numeric 0  √  null Quantity
c_poskey seqno numeric 10 0 Method of ordering records; lowest number comes first
c_poskey spanx numeric 10  √  NULL::numeric Number of columns spanned
c_poskey spany numeric 10  √  NULL::numeric Number of rows spanned
c_poskey subkeylayout_id numeric 10  √  NULL::numeric Key Layout to be displayed when this key is pressed
c_poskey text varchar 22  √  NULL::character varying Description
c_poskey updated timestamp 29,6 now() Date this record was updated
c_poskey updatedby numeric 10 User who updated this records
c_poskeylayout ad_client_id numeric 10 Client/Tenant for this installation.
c_poskeylayout ad_org_id numeric 10 Organizational entity within client
c_poskeylayout ad_printcolor_id numeric 10  √  NULL::numeric Color used for printing and display
c_poskeylayout ad_printfont_id numeric 10  √  NULL::numeric Maintain Print Font
c_poskeylayout c_poskeylayout_id numeric 10 POS Function Key Layout
c_poskeylayout c_poskeylayout_uu varchar 36  √  NULL::character varying C_POSKeyLayout_UU
c_poskeylayout columns numeric 10  √  NULL::numeric Number of columns
c_poskeylayout created timestamp 29,6 now() Date this record was created
c_poskeylayout createdby numeric 10 User who created this records
c_poskeylayout description varchar 255  √  null Optional short description of the record
c_poskeylayout help varchar 2000  √  null Comment or Hint
c_poskeylayout isactive bpchar 1 'Y'::bpchar The record is active in the system
c_poskeylayout name varchar 60 Alphanumeric identifier of the entity
c_poskeylayout poskeylayouttype bpchar 1  √  NULL::bpchar The type of Key Layout
c_poskeylayout updated timestamp 29,6 now() Date this record was updated
c_poskeylayout updatedby numeric 10 User who updated this records
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
m_pricelist c_currency_id numeric 10 The Currency for this record
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist createdby numeric 10 User who created this records
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist updatedby numeric 10 User who updated this records
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product created timestamp 29,6 now() Date this record was created
m_product createdby numeric 10 User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product istoformule bpchar 1  √  null
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product name varchar 255 Alphanumeric identifier of the entity
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product updated timestamp 29,6 now() Date this record was updated
m_product updatedby numeric 10 User who updated this records
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_org_id numeric 10 Organizational entity within client
m_warehouse c_location_id numeric 10 Location or Address
m_warehouse created timestamp 29,6 now() Date this record was created
m_warehouse createdby numeric 10 User who created this records
m_warehouse description varchar 255  √  null Optional short description of the record
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_warehouse name varchar 60 Alphanumeric identifier of the entity
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_warehouse separator bpchar 1 Element Separator
m_warehouse updated timestamp 29,6 now() Date this record was updated
m_warehouse updatedby numeric 10 User who updated this records
m_warehouse value varchar 40 Search key for the record in the format required - must be unique