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

idempiere9.adempiere contains 339 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
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
c_bpartner ad_language varchar 6  √  null Language for this entity
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_bp_group ad_printcolor_id numeric 10  √  null Color used for printing and display
ad_printformat ad_printformat_uu varchar 36  √  NULL::character varying AD_PrintFormat_UU
ad_printformat ad_printheaderfooter_id numeric 10  √  NULL::numeric Print Header/Footer
ad_printformat ad_printtableformat_id numeric 10  √  null Table Format in Reports
ad_printformat ad_reportview_id numeric 10  √  null View used to generate this report
c_dunningrunentry ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_printformat ad_window_id numeric 10  √  NULL::numeric Data entry or display window
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_printformat args varchar 510  √  null Args
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
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
ad_user bpname varchar 60  √  NULL::character varying BP Name
c_bp_group c_bp_group_uu varchar 36  √  NULL::character varying C_BP_Group_UU
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
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
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_bp_group c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_dunning c_dunning_uu varchar 36  √  NULL::character varying C_Dunning_UU
c_dunningrun c_dunninglevel_id numeric 10  √  null Dunning Level
c_dunninglevel c_dunninglevel_uu varchar 36  √  NULL::character varying C_DunningLevel_UU
c_dunningrun c_dunningrun_uu varchar 36  √  NULL::character varying C_DunningRun_UU
c_dunningrunentry c_dunningrunentry_uu varchar 36  √  NULL::character varying C_DunningRunEntry_UU
c_dunningrunline c_dunningrunline_uu varchar 36  √  NULL::character varying C_DunningRunLine_UU
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_dunningrunline c_invoice_id numeric 10  √  null Invoice Identifier
c_dunningrunline c_invoicepayschedule_id numeric 10  √  null Invoice Payment Schedule
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
c_dunningrunline c_payment_id numeric 10  √  null Payment identifier
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_dunninglevel c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
ad_printformat classname varchar 240  √  null Java Classname
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_printformat createcopy bpchar 1  √  null Create Copy
c_bp_group creditwatchpercent numeric 0  √  null Credit Watch - Percent of Credit Limit when OK switches to Watch
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
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
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
ad_printformat description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
c_bp_group description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_dunning description varchar 255  √  null Optional short description of the record
c_dunninglevel description varchar 255  √  null Optional short description of the record
c_dunningrun description varchar 255  √  null Optional short description of the record
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_dunninglevel dunning_printformat_id numeric 10  √  null Print Format for printing Dunning Letters
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
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
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_currency emurate numeric 0  √  0 Official rate to the Euro
ad_user fax varchar 40  √  null Facsimile number
c_bpartner_location fax varchar 40  √  null Facsimile number
c_dunninglevel feeamt numeric 0  √  0 Fee amount in invoice currency
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_dunninglevel interestpercent numeric 0  √  0 Percentage interest to charge on overdue invoices
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_dunninglevel invoicecollectiontype bpchar 1  √  NULL::bpchar Invoice Collection Status
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
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_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
ad_printformat jasperprocess_id numeric 10  √  null The Jasper Process used by the printengine if any process defined
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
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bp_group m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bp_group m_pricelist_id numeric 10  √  null Unique identifier of a Price List
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 name2 varchar 60  √  null Additional Name
c_dunninglevel note varchar 2000  √  null Optional additional user defined information
c_dunningrunentry note varchar 2000  √  null Optional additional user defined information
c_bpartner numberemployees numeric 10  √  null Number of employees
ad_user password varchar 1024  √  null Password of any length (case sensitive)
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
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_bp_group po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
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_bp_group po_pricelist_id numeric 10  √  null Price List used by this Business Partner
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_bp_group pricematchtolerance numeric 0  √  null PO-Invoice Match Price Tolerance in percent of the purchase price
ad_printformat printername varchar 40  √  null Name of the Printer
c_bp_group prioritybase bpchar 1  √  null Base of Priority
ad_user processing bpchar 1  √  null Process Now
c_dunningrun processing bpchar 1  √  null Process Now
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
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_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
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_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user securityquestion varchar 1024  √  null Security Question
c_dunningrun sendit bpchar 1  √  null Send
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
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
c_bpartner taxid varchar 20  √  null Tax Identification
ad_user title varchar 40  √  null Name this entity is referred to as
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
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
ad_printformat ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
c_bp_group ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_location ad_client_id numeric 10 Client/Tenant for this installation.
c_currency ad_client_id numeric 10 Client/Tenant for this installation.
c_dunning ad_client_id numeric 10 Client/Tenant for this installation.
c_dunninglevel ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrun ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrunentry ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrunline ad_client_id numeric 10 Client/Tenant for this installation.
ad_printformat ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
c_bp_group ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
c_currency ad_org_id numeric 10 Organizational entity within client
c_dunning ad_org_id numeric 10 Organizational entity within client
c_dunninglevel ad_org_id numeric 10 Organizational entity within client
c_dunningrun ad_org_id numeric 10 Organizational entity within client
c_dunningrunentry ad_org_id numeric 10 Organizational entity within client
c_dunningrunline ad_org_id numeric 10 Organizational entity within client
ad_printformat ad_printcolor_id numeric 10 Color used for printing and display
ad_printformat ad_printfont_id numeric 10 Maintain Print Font
ad_printformat ad_printformat_id numeric 10 Data Print Format
ad_printformat ad_printpaper_id numeric 10 Printer paper definition
ad_printformat ad_table_id numeric 10 Database Table information
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
c_dunningrunentry amt numeric 0 0 Amount
c_dunningrunline amt numeric 0 0 Amount
c_bp_group c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_dunningrunentry c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_dunningrunentry c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_currency c_currency_id numeric 10 The Currency for this record
c_dunningrunentry c_currency_id numeric 10 The Currency for this record
c_dunning c_dunning_id numeric 10 Dunning Rules for overdue invoices
c_dunninglevel c_dunning_id numeric 10 Dunning Rules for overdue invoices
c_dunningrun c_dunning_id numeric 10 NULL::numeric Dunning Rules for overdue invoices
c_dunninglevel c_dunninglevel_id numeric 10 Dunning Level
c_dunningrunentry c_dunninglevel_id numeric 10 NULL::numeric Dunning Level
c_dunningrun c_dunningrun_id numeric 10 Dunning Run
c_dunningrunentry c_dunningrun_id numeric 10 Dunning Run
c_dunningrunentry c_dunningrunentry_id numeric 10 Dunning Run Entry
c_dunningrunline c_dunningrunentry_id numeric 10 Dunning Run Entry
c_dunningrunline c_dunningrunline_id numeric 10 Dunning Run Line
c_dunninglevel chargefee bpchar 1 'Y'::bpchar Indicates if fees will be charged for overdue invoices
c_dunninglevel chargeinterest bpchar 1 'Y'::bpchar Indicates if interest will be charged on overdue invoices
c_dunningrunline convertedamt numeric 0 0 Converted Amount
c_currency costingprecision numeric 10 Rounding used costing calculations
ad_printformat created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
c_bp_group created timestamp 29,6 now() 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_currency created timestamp 29,6 now() Date this record was created
c_dunning created timestamp 29,6 now() Date this record was created
c_dunninglevel created timestamp 29,6 now() Date this record was created
c_dunningrun created timestamp 29,6 now() Date this record was created
c_dunningrunentry created timestamp 29,6 now() Date this record was created
c_dunningrunline created timestamp 29,6 now() Date this record was created
ad_printformat createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
c_bp_group 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_currency createdby numeric 10 User who created this records
c_dunning createdby numeric 10 User who created this records
c_dunninglevel createdby numeric 10 User who created this records
c_dunningrun createdby numeric 10 User who created this records
c_dunningrunentry createdby numeric 10 User who created this records
c_dunningrunline createdby numeric 10 User who created this records
c_dunning createlevelssequentially bpchar 1 'N'::bpchar Create Dunning Letter by level sequentially
c_dunninglevel daysafterdue numeric 10 Days after due date to dun (if negative days until due)
c_dunninglevel daysbetweendunning numeric 10 Days between sending dunning notices
c_dunningrunline daysdue numeric 10 0 Number of days due (negative: due in number of days)
c_currency description varchar 255 Optional short description of the record
c_dunningrun dunningdate timestamp 29,6 Date of Dunning
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
c_dunningrunline feeamt numeric 0 0 Fee amount in invoice currency
ad_printformat footermargin numeric 10 Margin of the Footer in 1/72 of an inch
ad_printformat headermargin numeric 10 Margin of the Header in 1/72 of an inch
c_dunningrunline interestamt numeric 0 0 Interest Amount
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_printformat isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_group 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_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunning isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunninglevel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrun isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrunentry isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrunline 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
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
ad_printformat isbreakpageperrecord bpchar 1 'Y'::bpchar Page Break after each record
c_bp_group isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_printformat isdefault bpchar 1 'N'::bpchar Default value
c_bp_group isdefault bpchar 1 'N'::bpchar Default value
c_dunning isdefault bpchar 1 'N'::bpchar Default value
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_currency isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
c_currency iseuro bpchar 1 'N'::bpchar This currency is the Euro
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_printformat isform bpchar 1 'N'::bpchar If Selected, a Form is printed, if not selected a columnar List report
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
c_dunningrunline isindispute bpchar 1 'N'::bpchar Document is in dispute
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 isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
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_dunninglevel issetcreditstop bpchar 1 'N'::bpchar Set the business partner to credit stop
c_dunninglevel issetpaymentterm bpchar 1 'N'::bpchar Set the payment term of the Business Partner
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
c_dunninglevel isshowalldue bpchar 1 'N'::bpchar Show/print all due invoices
c_dunninglevel isshownotdue bpchar 1 'N'::bpchar Show/print all invoices which are not due (yet).
ad_printformat isstandardheaderfooter bpchar 1 'Y'::bpchar The standard Header and Footer is used
c_dunninglevel isstatement bpchar 1 'N'::bpchar Dunning Level is a definition of a statement
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_printformat istablebased bpchar 1 'Y'::bpchar Table based List Reporting
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
ad_printformat name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
c_bp_group name varchar 60 Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_dunning name varchar 60 Alphanumeric identifier of the entity
c_dunninglevel name varchar 60 'x'::character varying Alphanumeric identifier of the entity
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
c_dunningrunline openamt numeric 0 Open item amount
c_dunninglevel printname varchar 60 The label text to be printed on a document or correspondence.
c_dunningrun processed bpchar 1 'N'::bpchar The document has been processed
c_dunningrunentry processed bpchar 1 'N'::bpchar The document has been processed
c_dunningrunline processed bpchar 1 'N'::bpchar The document has been processed
c_dunningrunentry qty numeric 0 0 Quantity
c_dunningrunentry salesrep_id numeric 10 Sales Representative or Company Agent
c_dunning senddunningletter bpchar 1 'Y'::bpchar Indicates if dunning letters will be sent
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_dunningrunline timesdunned numeric 10 0 Number of times dunned previously
c_dunningrunline totalamt numeric 0 0 Total Amount
ad_printformat updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
c_bp_group updated timestamp 29,6 now() 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_currency updated timestamp 29,6 now() Date this record was updated
c_dunning updated timestamp 29,6 now() Date this record was updated
c_dunninglevel updated timestamp 29,6 now() Date this record was updated
c_dunningrun updated timestamp 29,6 now() Date this record was updated
c_dunningrunentry updated timestamp 29,6 now() Date this record was updated
c_dunningrunline updated timestamp 29,6 now() Date this record was updated
ad_printformat updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
c_bp_group 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_currency updatedby numeric 10 User who updated this records
c_dunning updatedby numeric 10 User who updated this records
c_dunninglevel updatedby numeric 10 User who updated this records
c_dunningrun updatedby numeric 10 User who updated this records
c_dunningrunentry updatedby numeric 10 User who updated this records
c_dunningrunline updatedby numeric 10 User who updated this records
c_bp_group value varchar 40 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