View idempiere9.adempiere.c_dunning_line_v
Dunning Letter Lines

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_language varchar 6  √  null Language for this entity
c_dunningrunline_id numeric 10  √  null Dunning Run Line
c_dunningrunentry_id numeric 10  √  null Dunning Run Entry
amt numeric 0  √  null Amount
convertedamt numeric 0  √  null Converted Amount
daysdue numeric 10  √  null Number of days due (negative: due in number of days)
timesdunned numeric 10  √  null Number of times dunned previously
interestamt numeric 0  √  null Interest Amount
feeamt numeric 0  √  null Fee amount in invoice currency
totalamt numeric 0  √  null Total Amount
c_invoice_id numeric 10  √  null Invoice Identifier
issotrx bpchar 1  √  null This is a Sales Transaction
documentno varchar 30  √  null Document sequence number of the document
docstatus bpchar 2  √  null The current status of the document
datetrx timestamp 29,6  √  null Transaction Date
c_doctype_id numeric 10  √  null Document type or rules
documenttype varchar 60  √  null Document Type
description varchar 255  √  null Optional short description of the record
c_currency_id numeric 10  √  null The Currency for this record
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
dateacct timestamp 29,6  √  null Accounting Date
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
dateordered timestamp 29,6  √  null Date of Order
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
isindispute bpchar 1  √  null Document is in dispute
paymentterm varchar 60  √  null Payment Term
c_charge_id numeric 10  √  null Additional document charges
chargeamt numeric 0  √  null Charge Amount
totallines numeric 0  √  null Total of all document lines
grandtotal numeric 0  √  null Total amount of document
amtinwords numeric 0  √  null Amount in words
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
ispaid bpchar 1  √  null The document is paid
isallocated bpchar 1  √  null Indicates if the payment has been allocated
tendertype bpchar 1  √  null Method of Payment
discountamt numeric 0  √  null Calculated amount of discount
c_invoicepayschedule_id numeric 10  √  null Invoice Payment Schedule
c_payment_id numeric 10  √  null Payment identifier
c_dunningrunline_isindispute bpchar 1  √  null c_dunningrunline_isindispute
openamt numeric 0  √  null Open item amount
c_dunningrunline_processed bpchar 1  √  null c_dunningrunline_processed
c_invoice_ad_org_id numeric 10  √  null C_Invoice_AD_Org_ID
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoice_c_bpartner_id numeric 10  √  null c_invoice_c_bpartner_id
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_dunninglevel_id numeric 10  √  null Dunning Level
c_invoice_c_order_id numeric 10  √  null c_invoice_c_order_id
c_invoice_c_payment_id numeric 10  √  null c_invoice_c_payment_id
c_invoice_created timestamp 29,6  √  null c_invoice_created
c_invoice_createdby numeric 10  √  null c_invoice_createdby
dateprinted timestamp 29,6  √  null Date the document was printed.
docaction bpchar 2  √  null The targeted status of the document
dunninggrace timestamp 29,6  √  null Dunning Grace Date
generateto bpchar 1  √  null Generate To
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_invoice_isactive bpchar 1  √  null c_invoice_isactive
c_invoice_isapproved bpchar 1  √  null c_invoice_isapproved
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
isprinted bpchar 1  √  null Indicates if this document / line is printed
c_invoice_isselfservice bpchar 1  √  null c_invoice_isselfservice
istaxincluded bpchar 1  √  null Tax is included in the price
istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
m_rma_id numeric 10  √  null Return Material Authorization
paymentrule bpchar 1  √  null How you pay the invoice
c_invoice_posted bpchar 1  √  null c_invoice_posted
c_invoice_processedon numeric 0  √  null c_invoice_processedon
processing bpchar 1  √  null Process Now
ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoice_reversal_id numeric 10  √  null c_invoice_reversal_id
salesrep_id numeric 10  √  null Sales Representative or Company Agent
sendemail bpchar 1  √  null Enable sending Document EMail
c_invoice_updated timestamp 29,6  √  null c_invoice_updated
c_invoice_updatedby numeric 10  √  null c_invoice_updatedby
c_paymentterm_ad_org_id numeric 10  √  null C_PaymentTerm_AD_Org_ID
afterdelivery bpchar 1  √  null Due after delivery rather than after invoicing
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm_description varchar 255  √  null c_paymentterm_description
discount numeric 0  √  null Discount in percent
discount2 numeric 0  √  null Discount in percent
discountdays numeric 10  √  null Number of days from invoice date to be eligible for discount
discountdays2 numeric 10  √  null Number of days from invoice date to be eligible for discount
documentnote varchar 2000  √  null Additional information for a Document
fixmonthcutoff numeric 10  √  null Last day to include for next due date
fixmonthday numeric 10  √  null Day of the month of the due date
fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
gracedays numeric 10  √  null Days after due date to send first dunning letter
c_paymentterm_isactive bpchar 1  √  null c_paymentterm_isactive
isduefixed bpchar 1  √  null Payment is due on a fixed date
isnextbusinessday bpchar 1  √  null Payment due on the next business day
isvalid bpchar 1  √  null Element is valid
netday bpchar 1  √  null Day when payment is due net
netdays numeric 10  √  null Net Days in which payment is due
paymenttermusage bpchar 1  √  null Payment term usage indicates if this payment term is used for sales, purchases or both.
c_paymentterm_value varchar 40  √  null c_paymentterm_value
a_city varchar 60  √  null City or the Credit Card or Account Holder
a_country varchar 40  √  null Country
c_payment_ad_org_id numeric 10  √  null c_payment_ad_org_id
a_email varchar 60  √  null Email Address
a_ident_dl varchar 20  √  null Payment Identification - Driver License
a_name varchar 60  √  null Name on Credit Card or Account holder
a_state varchar 40  √  null State of the Credit Card or Account holder
a_street varchar 60  √  null Street address of the Credit Card or Account holder
a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment_c_bpartner_id numeric 10  √  null c_payment_c_bpartner_id
c_payment_c_charge_id numeric 10  √  null C_Payment_C_Charge_ID
c_payment_chargeamt numeric 0  √  null c_payment_chargeamt
checkno varchar 20  √  null Check Number
c_payment_c_invoice_id numeric 10  √  null C_Payment_C_Invoice_ID
c_payment_c_order_id numeric 10  √  null c_payment_c_order_id
c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_payment_created timestamp 29,6  √  null c_payment_created
c_payment_createdby numeric 10  √  null c_payment_createdby
c_payment_isactive bpchar 1  √  null c_payment_isactive
isapproved bpchar 1  √  null Indicates if this document requires approval
isdelayedcapture bpchar 1  √  null Charge after Shipment
isonline bpchar 1  √  null Can be accessed online
isoverunderpayment bpchar 1  √  null Over-Payment (unallocated) or Under-Payment (partial payment)
isprepayment bpchar 1  √  null The Payment/Receipt is a Prepayment
isreconciled bpchar 1  √  null Payment is reconciled with bank statement
c_payment_isselfservice bpchar 1  √  null c_payment_isselfservice
micr varchar 20  √  null Combination of routing no, account and check no
orig_trxid varchar 20  √  null Original Transaction ID
overunderamt numeric 0  √  null Over-Payment (unallocated) or Under-Payment (partial payment) Amount
payamt numeric 0  √  null Amount being paid
ponum varchar 60  √  null Purchase Order Number
c_payment_posted bpchar 1  √  null c_payment_posted
c_payment_processed bpchar 1  √  null c_payment_processed
c_payment_processedon numeric 0  √  null c_payment_processedon
r_authcode varchar 20  √  null Authorization Code returned
r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
r_avsaddr bpchar 1  √  null This address has been verified
r_avszip bpchar 1  √  null The Zip Code has been verified
r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
ref_payment_id numeric 10  √  null Referenced Payment
c_payment_reversal_id numeric 10  √  null c_payment_reversal_id
r_info varchar 2000  √  null Response info
routingno varchar 20  √  null Bank Routing Number
r_pnref varchar 20  √  null Payment reference
r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
r_respmsg varchar 60  √  null Response message
r_result varchar 20  √  null Result of transmission
swipe varchar 80  √  null Track 1 and 2 of the Credit Card
taxamt numeric 0  √  null Tax Amount for a document
trxtype bpchar 1  √  null Type of credit card transaction
c_payment_updated timestamp 29,6  √  null c_payment_updated
c_payment_updatedby numeric 10  √  null c_payment_updatedby
voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
writeoffamt numeric 0  √  null Amount to write-off

Analyzed at 2021-12-25 14:53 +0100