SchemaSpy Analysis of idempiere11.adempiere - ColumnsPOS | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:53 +0100 |
| |||||
|
idempiere11.adempiere contains 474 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
ad_printcolor | ad_client_id | numeric | 10 | |||
ad_printcolor | ad_org_id | numeric | 10 | |||
ad_printcolor | ad_printcolor_id | numeric | 10 | |||
ad_printcolor | ad_printcolor_uu | varchar | 36 | √ | NULL::character varying | |
ad_printcolor | code | varchar | 2000 | |||
ad_printcolor | created | timestamp | 29,6 | now() | ||
ad_printcolor | createdby | numeric | 10 | |||
ad_printcolor | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_printcolor | isdefault | bpchar | 1 | 'N'::bpchar | ||
ad_printcolor | name | varchar | 60 | |||
ad_printcolor | updated | timestamp | 29,6 | now() | ||
ad_printcolor | updatedby | numeric | 10 | |||
ad_user | ad_client_id | numeric | 10 | |||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | |
ad_user | ad_org_id | numeric | 10 | |||
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | |
ad_user | ad_user_id | numeric | 10 | |||
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | |
ad_user | birthday | timestamp | 29,6 | √ | null | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | |
ad_user | c_bpartner_id | numeric | 10 | √ | null | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | |
ad_user | c_greeting_id | numeric | 10 | √ | null | |
ad_user | c_job_id | numeric | 10 | √ | null | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | |
ad_user | comments | varchar | 2000 | √ | null | |
ad_user | connectionprofile | bpchar | 1 | √ | null | |
ad_user | created | timestamp | 29,6 | now() | ||
ad_user | createdby | numeric | 10 | |||
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | |
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | |
ad_user | description | varchar | 255 | √ | null | |
ad_user | varchar | 60 | √ | null | ||
ad_user | emailuser | varchar | 60 | √ | null | |
ad_user | emailuserpw | varchar | 255 | √ | null | |
ad_user | emailverify | varchar | 40 | √ | null | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | |
ad_user | failedlogincount | numeric | 10 | (0)::numeric | ||
ad_user | fax | varchar | 40 | √ | null | |
ad_user | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | ||
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | |
ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | ||
ad_user | isshipto | bpchar | 1 | 'N'::bpchar | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | ||
ad_user | lastcontact | timestamp | 29,6 | √ | null | |
ad_user | lastresult | varchar | 255 | √ | null | |
ad_user | ldapuser | varchar | 60 | √ | null | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | |
ad_user | name | varchar | 60 | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | ||
ad_user | password | varchar | 1024 | √ | null | |
ad_user | phone | varchar | 40 | √ | null | |
ad_user | phone2 | varchar | 40 | √ | null | |
ad_user | processing | bpchar | 1 | √ | null | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | |
ad_user | securityquestion | varchar | 1024 | √ | null | |
ad_user | supervisor_id | numeric | 10 | √ | null | |
ad_user | title | varchar | 40 | √ | null | |
ad_user | updated | timestamp | 29,6 | now() | ||
ad_user | updatedby | numeric | 10 | |||
ad_user | userpin | varchar | 20 | √ | null | |
ad_user | value | varchar | 40 | √ | null | |
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | |
c_bpartner | ad_client_id | numeric | 10 | |||
c_bpartner | ad_language | varchar | 6 | √ | null | |
c_bpartner | ad_org_id | numeric | 10 | |||
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | |
c_bpartner | c_bp_group_id | numeric | 10 | |||
c_bpartner | c_bpartner_id | numeric | 10 | |||
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | |
c_bpartner | c_dunning_id | numeric | 10 | √ | null | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | |
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | |
c_bpartner | created | timestamp | 29,6 | now() | ||
c_bpartner | createdby | numeric | 10 | |||
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | |
c_bpartner | description | varchar | 255 | √ | null | |
c_bpartner | documentcopies | numeric | 10 | √ | null | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | |
c_bpartner | duns | varchar | 11 | √ | null | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | |
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | |
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | |
c_bpartner | naics | varchar | 6 | √ | null | |
c_bpartner | name | varchar | 120 | |||
c_bpartner | name2 | varchar | 60 | √ | null | |
c_bpartner | numberemployees | numeric | 10 | √ | null | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | |
c_bpartner | po_discountschema_id | numeric | 10 | √ | null | |
c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | |
c_bpartner | poreference | varchar | 20 | √ | null | |
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | |
c_bpartner | rating | bpchar | 1 | √ | null | |
c_bpartner | referenceno | varchar | 40 | √ | null | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | |
c_bpartner | salesvolume | numeric | 10 | √ | null | |
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | |
c_bpartner | so_description | varchar | 255 | √ | null | |
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | |
c_bpartner | taxid | varchar | 20 | √ | null | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | |
c_bpartner | updated | timestamp | 29,6 | now() | ||
c_bpartner | updatedby | numeric | 10 | |||
c_bpartner | url | varchar | 120 | √ | null | |
c_bpartner | value | varchar | 40 | |||
c_doctype | ad_client_id | numeric | 10 | |||
c_doctype | ad_org_id | numeric | 10 | |||
c_doctype | ad_printformat_id | numeric | 10 | √ | null | |
c_doctype | c_doctype_id | numeric | 10 | |||
c_doctype | c_doctype_uu | varchar | 36 | √ | NULL::character varying | |
c_doctype | c_doctypedifference_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeinvoice_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeproforma_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeshipment_id | numeric | 10 | √ | null | |
c_doctype | created | timestamp | 29,6 | now() | ||
c_doctype | createdby | numeric | 10 | |||
c_doctype | definitesequence_id | numeric | 10 | √ | null | |
c_doctype | description | varchar | 255 | √ | null | |
c_doctype | docbasetype | bpchar | 3 | |||
c_doctype | docnosequence_id | numeric | 10 | √ | null | |
c_doctype | docsubtypeinv | varchar | 2 | √ | NULL::character varying | |
c_doctype | docsubtypeso | bpchar | 2 | √ | null | |
c_doctype | documentcopies | numeric | 10 | |||
c_doctype | documentnote | varchar | 2000 | √ | null | |
c_doctype | gl_category_id | numeric | 10 | |||
c_doctype | hascharges | bpchar | 1 | 'N'::bpchar | ||
c_doctype | hasproforma | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | ischargeorproductmandatory | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | iscreatecounter | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isdefault | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isdefaultcounterdoc | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isdocnocontrolled | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isindexed | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isintransit | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | isoverwritedateoncomplete | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | isoverwriteseqoncomplete | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | ispickqaconfirm | bpchar | 1 | 'N'::bpchar | ||
c_doctype | ispreparesplitdocument | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isshipconfirm | bpchar | 1 | 'N'::bpchar | ||
c_doctype | issotrx | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | issplitwhendifference | bpchar | 1 | 'N'::bpchar | ||
c_doctype | name | varchar | 60 | |||
c_doctype | printname | varchar | 60 | |||
c_doctype | updated | timestamp | 29,6 | now() | ||
c_doctype | updatedby | numeric | 10 | |||
c_payment | a_city | varchar | 60 | √ | null | |
c_payment | a_country | varchar | 40 | √ | null | |
c_payment | a_email | varchar | 60 | √ | null | |
c_payment | a_ident_dl | varchar | 20 | √ | null | |
c_payment | a_ident_ssn | varchar | 20 | √ | null | |
c_payment | a_name | varchar | 60 | √ | null | |
c_payment | a_state | varchar | 40 | √ | null | |
c_payment | a_street | varchar | 60 | √ | null | |
c_payment | a_zip | varchar | 20 | √ | null | |
c_payment | accountno | varchar | 20 | √ | null | |
c_payment | ad_client_id | numeric | 10 | |||
c_payment | ad_org_id | numeric | 10 | |||
c_payment | ad_orgtrx_id | numeric | 10 | √ | null | |
c_payment | c_activity_id | numeric | 10 | √ | null | |
c_payment | c_bankaccount_id | numeric | 10 | √ | null | |
c_payment | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | |
c_payment | c_bp_bankaccount_id | numeric | 10 | √ | null | |
c_payment | c_bpartner_id | numeric | 10 | √ | null | |
c_payment | c_campaign_id | numeric | 10 | √ | null | |
c_payment | c_cashbook_id | numeric | 10 | √ | null | |
c_payment | c_charge_id | numeric | 10 | √ | null | |
c_payment | c_conversiontype_id | numeric | 10 | √ | null | |
c_payment | c_currency_id | numeric | 10 | |||
c_payment | c_depositbatch_id | numeric | 10 | √ | NULL::numeric | |
c_payment | c_doctype_id | numeric | 10 | |||
c_payment | c_invoice_id | numeric | 10 | √ | null | |
c_payment | c_order_id | numeric | 10 | √ | null | |
c_payment | c_payment_id | numeric | 10 | |||
c_payment | c_payment_uu | varchar | 36 | √ | NULL::character varying | |
c_payment | c_paymentbatch_id | numeric | 10 | √ | null | |
c_payment | c_paymentprocessor_id | numeric | 10 | √ | NULL::numeric | |
c_payment | c_postendertype_id | numeric | 10 | √ | NULL::numeric | |
c_payment | c_project_id | numeric | 10 | √ | null | |
c_payment | chargeamt | numeric | 0 | √ | 0 | |
c_payment | checkno | varchar | 20 | √ | null | |
c_payment | convertedamt | numeric | 0 | √ | null | |
c_payment | created | timestamp | 29,6 | now() | ||
c_payment | createdby | numeric | 10 | |||
c_payment | creditcardexpmm | numeric | 10 | √ | null | |
c_payment | creditcardexpyy | numeric | 10 | √ | null | |
c_payment | creditcardnumber | varchar | 20 | √ | null | |
c_payment | creditcardtype | bpchar | 1 | √ | null | |
c_payment | creditcardvv | varchar | 4 | √ | null | |
c_payment | currencyrate | numeric | 0 | √ | null | |
c_payment | customeraddressid | varchar | 60 | √ | NULL::character varying | |
c_payment | customerpaymentprofileid | varchar | 60 | √ | NULL::character varying | |
c_payment | customerprofileid | varchar | 60 | √ | NULL::character varying | |
c_payment | dateacct | timestamp | 29,6 | |||
c_payment | datetrx | timestamp | 29,6 | |||
c_payment | description | varchar | 255 | √ | null | |
c_payment | discountamt | numeric | 0 | √ | 0 | |
c_payment | docaction | bpchar | 2 | |||
c_payment | docstatus | bpchar | 2 | |||
c_payment | documentno | varchar | 30 | |||
c_payment | iban | varchar | 40 | √ | NULL::character varying | |
c_payment | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_payment | isallocated | bpchar | 1 | 'N'::bpchar | ||
c_payment | isapproved | bpchar | 1 | 'N'::bpchar | ||
c_payment | isdelayedcapture | bpchar | 1 | 'N'::bpchar | ||
c_payment | isonline | bpchar | 1 | 'N'::bpchar | ||
c_payment | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | ||
c_payment | isoverunderpayment | bpchar | 1 | 'Y'::bpchar | ||
c_payment | isprepayment | bpchar | 1 | 'N'::bpchar | ||
c_payment | isreceipt | bpchar | 1 | 'Y'::bpchar | ||
c_payment | isreconciled | bpchar | 1 | 'N'::bpchar | ||
c_payment | isselfservice | bpchar | 1 | 'N'::bpchar | ||
c_payment | isvoided | bpchar | 1 | 'N'::bpchar | ||
c_payment | micr | varchar | 20 | √ | null | |
c_payment | oprocessing | bpchar | 1 | √ | null | |
c_payment | orig_trxid | varchar | 20 | √ | null | |
c_payment | overunderamt | numeric | 0 | √ | 0 | |
c_payment | payamt | numeric | 0 | 0 | ||
c_payment | ponum | varchar | 60 | √ | null | |
c_payment | posted | bpchar | 1 | 'N'::bpchar | ||
c_payment | processed | bpchar | 1 | 'N'::bpchar | ||
c_payment | processedon | numeric | 0 | √ | null | |
c_payment | processing | bpchar | 1 | √ | null | |
c_payment | r_authcode | varchar | 20 | √ | null | |
c_payment | r_authcode_dc | varchar | 20 | √ | null | |
c_payment | r_avsaddr | bpchar | 1 | √ | null | |
c_payment | r_avszip | bpchar | 1 | √ | null | |
c_payment | r_cvv2match | bpchar | 1 | √ | null | |
c_payment | r_info | varchar | 2000 | √ | null | |
c_payment | r_pnref | varchar | 20 | √ | null | |
c_payment | r_pnref_dc | varchar | 20 | √ | null | |
c_payment | r_respmsg | varchar | 60 | √ | null | |
c_payment | r_result | varchar | 20 | √ | null | |
c_payment | r_voidmsg | varchar | 255 | √ | NULL::character varying | |
c_payment | ref_payment_id | numeric | 10 | √ | null | |
c_payment | reversal_id | numeric | 10 | √ | null | |
c_payment | routingno | varchar | 20 | √ | null | |
c_payment | swiftcode | varchar | 20 | √ | NULL::character varying | |
c_payment | swipe | varchar | 80 | √ | null | |
c_payment | taxamt | numeric | 0 | √ | 0 | |
c_payment | tendertype | bpchar | 1 | |||
c_payment | trxtype | bpchar | 1 | |||
c_payment | updated | timestamp | 29,6 | now() | ||
c_payment | updatedby | numeric | 10 | |||
c_payment | user1_id | numeric | 10 | √ | null | |
c_payment | user2_id | numeric | 10 | √ | null | |
c_payment | voiceauthcode | varchar | 20 | √ | null | |
c_payment | writeoffamt | numeric | 0 | √ | 0 | |
c_pos | ad_client_id | numeric | 10 | |||
c_pos | ad_org_id | numeric | 10 | |||
c_pos | autologoutdelay | numeric | 10 | √ | NULL::numeric | |
c_pos | c_bankaccount_id | numeric | 10 | √ | null | |
c_pos | c_bpartnercashtrx_id | numeric | 10 | √ | null | |
c_pos | c_cashbook_id | numeric | 10 | √ | null | |
c_pos | c_doctype_id | numeric | 10 | √ | null | |
c_pos | c_pos_id | numeric | 10 | |||
c_pos | c_pos_uu | varchar | 36 | √ | NULL::character varying | |
c_pos | c_poskeylayout_id | numeric | 10 | √ | null | |
c_pos | cashdrawer | varchar | 120 | √ | null | |
c_pos | created | timestamp | 29,6 | now() | ||
c_pos | createdby | numeric | 10 | |||
c_pos | description | varchar | 255 | √ | null | |
c_pos | help | varchar | 2000 | √ | null | |
c_pos | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_pos | ismodifyprice | bpchar | 1 | 'N'::bpchar | ||
c_pos | m_pricelist_id | numeric | 10 | |||
c_pos | m_warehouse_id | numeric | 10 | |||
c_pos | name | varchar | 60 | |||
c_pos | osk_keylayout_id | numeric | 10 | √ | NULL::numeric | |
c_pos | osnp_keylayout_id | numeric | 10 | √ | NULL::numeric | |
c_pos | printername | varchar | 60 | √ | null | |
c_pos | salesrep_id | numeric | 10 | |||
c_pos | updated | timestamp | 29,6 | now() | ||
c_pos | updatedby | numeric | 10 | |||
c_poskey | ad_client_id | numeric | 10 | |||
c_poskey | ad_image_id | numeric | 10 | √ | NULL::numeric | |
c_poskey | ad_org_id | numeric | 10 | |||
c_poskey | ad_printcolor_id | numeric | 10 | √ | null | |
c_poskey | ad_printfont_id | numeric | 10 | √ | NULL::numeric | |
c_poskey | c_poskey_id | numeric | 10 | |||
c_poskey | c_poskey_uu | varchar | 36 | √ | NULL::character varying | |
c_poskey | c_poskeylayout_id | numeric | 10 | |||
c_poskey | created | timestamp | 29,6 | now() | ||
c_poskey | createdby | numeric | 10 | |||
c_poskey | description | varchar | 255 | √ | null | |
c_poskey | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_poskey | m_product_id | numeric | 10 | √ | null | |
c_poskey | name | varchar | 60 | |||
c_poskey | qty | numeric | 0 | √ | null | |
c_poskey | seqno | numeric | 10 | 0 | ||
c_poskey | spanx | numeric | 10 | √ | NULL::numeric | |
c_poskey | spany | numeric | 10 | √ | NULL::numeric | |
c_poskey | subkeylayout_id | numeric | 10 | √ | NULL::numeric | |
c_poskey | text | varchar | 22 | √ | NULL::character varying | |
c_poskey | updated | timestamp | 29,6 | now() | ||
c_poskey | updatedby | numeric | 10 | |||
c_poskeylayout | ad_client_id | numeric | 10 | |||
c_poskeylayout | ad_org_id | numeric | 10 | |||
c_poskeylayout | ad_printcolor_id | numeric | 10 | √ | NULL::numeric | |
c_poskeylayout | ad_printfont_id | numeric | 10 | √ | NULL::numeric | |
c_poskeylayout | c_poskeylayout_id | numeric | 10 | |||
c_poskeylayout | c_poskeylayout_uu | varchar | 36 | √ | NULL::character varying | |
c_poskeylayout | columns | numeric | 10 | √ | NULL::numeric | |
c_poskeylayout | created | timestamp | 29,6 | now() | ||
c_poskeylayout | createdby | numeric | 10 | |||
c_poskeylayout | description | varchar | 255 | √ | null | |
c_poskeylayout | help | varchar | 2000 | √ | null | |
c_poskeylayout | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_poskeylayout | name | varchar | 60 | |||
c_poskeylayout | poskeylayouttype | bpchar | 1 | √ | NULL::bpchar | |
c_poskeylayout | updated | timestamp | 29,6 | now() | ||
c_poskeylayout | updatedby | numeric | 10 | |||
m_pricelist | ad_client_id | numeric | 10 | |||
m_pricelist | ad_org_id | numeric | 10 | |||
m_pricelist | basepricelist_id | numeric | 10 | √ | null | |
m_pricelist | c_currency_id | numeric | 10 | |||
m_pricelist | created | timestamp | 29,6 | now() | ||
m_pricelist | createdby | numeric | 10 | |||
m_pricelist | description | varchar | 255 | √ | null | |
m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | |
m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | |
m_pricelist | issopricelist | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | m_pricelist_id | numeric | 10 | |||
m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | |
m_pricelist | name | varchar | 60 | |||
m_pricelist | priceprecision | numeric | 10 | 2 | ||
m_pricelist | updated | timestamp | 29,6 | now() | ||
m_pricelist | updatedby | numeric | 10 | |||
m_product | ad_client_id | numeric | 10 | |||
m_product | ad_org_id | numeric | 10 | |||
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | |
m_product | c_taxcategory_id | numeric | 10 | |||
m_product | c_uom_id | numeric | 10 | |||
m_product | classification | varchar | 12 | √ | null | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | |
m_product | created | timestamp | 29,6 | now() | ||
m_product | createdby | numeric | 10 | |||
m_product | customstariffnumber | varchar | 20 | √ | null | |
m_product | description | varchar | 255 | √ | null | |
m_product | descriptionurl | varchar | 120 | √ | null | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | |
m_product | documentnote | varchar | 2000 | √ | null | |
m_product | downloadurl | varchar | 120 | √ | null | |
m_product | group1 | varchar | 255 | √ | null | |
m_product | group2 | varchar | 255 | √ | null | |
m_product | guaranteedays | numeric | 10 | √ | null | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | |
m_product | help | varchar | 2000 | √ | null | |
m_product | imageurl | varchar | 120 | √ | null | |
m_product | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | ||
m_product | istoformule | bpchar | 1 | √ | null | |
m_product | isverified | bpchar | 1 | 'N'::bpchar | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | ||
m_product | lowlevel | numeric | 10 | (0)::numeric | ||
m_product | m_attributeset_id | numeric | 10 | √ | null | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | |
m_product | m_locator_id | numeric | 10 | √ | null | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | |
m_product | m_product_category_id | numeric | 10 | |||
m_product | m_product_id | numeric | 10 | |||
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | |
m_product | name | varchar | 255 | |||
m_product | processing | bpchar | 1 | √ | null | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | ||
m_product | r_mailtext_id | numeric | 10 | √ | null | |
m_product | s_expensetype_id | numeric | 10 | √ | null | |
m_product | s_resource_id | numeric | 10 | √ | null | |
m_product | salesrep_id | numeric | 10 | √ | null | |
m_product | shelfdepth | numeric | 10 | √ | null | |
m_product | shelfheight | numeric | 0 | √ | null | |
m_product | shelfwidth | numeric | 10 | √ | null | |
m_product | sku | varchar | 30 | √ | null | |
m_product | unitsperpack | numeric | 10 | 1 | ||
m_product | unitsperpallet | numeric | 0 | √ | null | |
m_product | upc | varchar | 30 | √ | null | |
m_product | updated | timestamp | 29,6 | now() | ||
m_product | updatedby | numeric | 10 | |||
m_product | value | varchar | 510 | |||
m_product | versionno | varchar | 20 | √ | null | |
m_product | volume | numeric | 0 | √ | 0 | |
m_product | weight | numeric | 0 | √ | 0 | |
m_warehouse | ad_client_id | numeric | 10 | |||
m_warehouse | ad_org_id | numeric | 10 | |||
m_warehouse | c_location_id | numeric | 10 | |||
m_warehouse | created | timestamp | 29,6 | now() | ||
m_warehouse | createdby | numeric | 10 | |||
m_warehouse | description | varchar | 255 | √ | null | |
m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | |
m_warehouse | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | |
m_warehouse | name | varchar | 60 | |||
m_warehouse | replenishmentclass | varchar | 60 | √ | null | |
m_warehouse | separator | bpchar | 1 | |||
m_warehouse | updated | timestamp | 29,6 | now() | ||
m_warehouse | updatedby | numeric | 10 | |||
m_warehouse | value | varchar | 40 |