Mostrar código-fonte de Predefinição:Info.Terceiro (Janela ID-291 V1.0.0)

[[en:Business Partner Info (Window ID-291)]]
[[ar:Business Partner Info (نافذة ID-291)]]
[[bg:Информация за партньора (прозорец ID-291)]]
[[da:Business Partner Info (Vindue ID-291)]]
[[de:Info Geschäftspartner (Fenster ID-291)]]
[[el:Πληροφορίες Συναλλασσόμενου (παράθυρο ID-291)]]
[[es:Información del Tercero (Ventana ID-291)]]
[[fr:Info partenaires d'affaire (Fenêtre ID-291)]]
[[hu:Üzleti partner infó (Aablak ID-291)]]
[[id:Info Partner Bisnis (jendela ID-291)]]
[[it:Informazioni Business Partner (finestra ID-291)]]
[[ja:ビジネスパートナー情報 (ウィンドウ ID-291)]]
[[ms:Info Partner Bisnis (tetingkap ID-291)]]
[[nl:Business Partner Info (Venster ID-291)]]
[[pl:Dokumenty wg kontrahentów (Okno ID-291)]]
[[pt:Info.Terceiro (Janela ID-291)]]
[[ro:Info Partener (fereastră ID-291)]]
[[ru:Инфо о бизнес-партнерах (окно ID-291)]]
[[sr:Информације о комитенту (прозор ID-291)]]
[[sv:Affärspartnerinformation (Fönster ID-291)]]
[[th:ข้อมูลบริษัทคู่ค้า (หน้าต่าง ID-291)]]
[[tr:Business Partner Info (pencere ID-291)]]
[[zh:业务伙伴信息 (窗口 ID-291)]]
 


== Janela: Info.Terceiro ==

'''Descrição:''' Document Information of Business Partners

'''Ajudar:''' null

 

    
    
=== TAB: Terceiros, Selecção ===

'''Descrição:''' Business Partner Selection 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Selecção - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Search Key
|Codigo para Selecção
|Codigo principal para selecção de registos - deve ser unico 
|A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|Value<br>character varying(40) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Name
|Nome
|Alphanumeric identifier of the entity 
|The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.
|Name<br>character varying(60) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Description
|Descrição
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Active
|Activo
|The record is active in the system 
|There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records:
(1) The system requires the record for audit purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
|IsActive<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Business Partner Group
|Grupo de Terceiros
|Business Partner Group 
|The Business Partner Group provides a method of defining defaults to be used for individual Business Partners.
|C_BP_Group_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Open Balance
|Open Balance
|Total Open Balance Amount in primary Accounting Currency 
|The Total Open Balance Amount is the calculated open item amount for Customer and Vendor activity.  If the Balance is below zero, we owe the Business Partner.  The amout is used for Credit Management.
Invoices and Payment Allocations determine the Open Balance (i.e. not Orders or Payments).
|TotalOpenBalance<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Customer
|Cliente
|Indicates if this Business Partner is a Customer 
|The Customer checkbox indicates if this Business Partner is a customer.  If it is select additional fields will display which further define this customer.
|IsCustomer<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Vendor
|Fornecedor
|Indicates if this Business Partner is a Vendor 
|The Vendor checkbox indicates if this Business Partner is a Vendor.  If it is selected, additional fields will display which further identify this vendor.
|IsVendor<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Sales Representative
|Representante Comercial
|Indicates if  the business partner is a sales representative or company agent 
|The Sales Rep checkbox indicates if this business partner is a sales representative. A sales representative may also be an emplyee, but does not need to be.
|IsSalesRep<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Employee
|Funcionário
|Indicates if  this Business Partner is an employee 
|The Employee checkbox indicates if this Business Partner is an Employee.  If it is selected, additional fields will display which further identify this employee.
|IsEmployee<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Encomendas ===

'''Descrição:''' Business Partner Orders 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Encomendas - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Active
|Activo
|The record is active in the system 
|There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records:
(1) The system requires the record for audit purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
|IsActive<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Process Order
|Processar Encomenda
|null 
|null
|DocAction<br>character(2) NOT NULL<br>Button
|-valign="top" 
|-

|-valign="top" 
|Target Document Type
|Tipo documento destino
|Target document type for conversing documents 
|You can convert document types (e.g. from Offer to Order or Invoice).  The conversion is then reflected in the current type.  This processing is initiated by selecting the appropriate Document Action.
|C_DocTypeTarget_ID<br>numeric(10) NOT NULL<br>Table
|-valign="top" 
|-

|-valign="top" 
|Credit Approved
|Crédito Aprovado
|Credit  has been approved 
|Credit Approved indicates if the credit approval was successful for Orders
|IsCreditApproved<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Printed
|Impresso
|Indicates if this document / line is printed 
|The Printed checkbox indicates if this document or line will included when printing.
|IsPrinted<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Invoiced
|Facturado
|It is invoiced 
|Indicator if invoiced
|IsInvoiced<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Delivered
|Expedido em
|null 
|null
|IsDelivered<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Approved
|Aprovado
|Indicates if this document requires approval 
|The Approved checkbox indicates if this document requires approval before it can be processed.
|IsApproved<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Transferred
|Transferido
|Transferred to General Ledger (i.e. accounted) 
|The transferred checkbox indicates if the transactions associated with this document should be transferred to the General Ledger.
|IsTransferred<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Activity
|Actividade
|Business Activity 
|Activities indicate tasks that are performed and used to utilize Activity based Costing
|C_Activity_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Processed
|Processado
|The document has been processed 
|The Processed checkbox indicates that a document has been processed.
|Processed<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Charge amount
|Montante de Encargos
|Charge Amount 
|The Charge Amount indicates the amount for an additional charge.
|ChargeAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Charge
|Encargos
|Additional document charges 
|The Charge indicates a type of Charge (Handling, Shipping, Restocking)
|C_Charge_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Order Reference
|Encomenda, Referência
|O numero de Encomenda (de referência interna) para o Terceiro 
|The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference.  A standard number can be defined in the Business Partner (Customer) window.
|POReference<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|User/Contact
|Utilizador
|User within the system - Internal or Business Partner Contact 
|The User identifies a unique user in the system. This could be an internal user or a business partner contact
|AD_User_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Process Order
|Processar Encomenda
|null 
|null
|Processing<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Shipper
|Remetente
|Method or manner of product delivery 
|The Shipper indicates the method of delivering product
|M_Shipper_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Delivery Via
|Meio de Expedição
|How the order will be delivered 
|The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
|DeliveryViaRule<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Invoice Contact
|Contacto para "Drop Shipment"
|Business Partner Contact for Drop Shipment 
|null
|Bill_User_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Send EMail
|Enviar eMail
|Enable sending Document EMail 
|Send emails with document attached (e.g. Invoice, Delivery Note, etc.)
|SendEMail<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Cash Journal Line
|Diário de Caixa, linha
|Cash Journal Line 
|The Cash Journal Line indicates a unique line in a cash journal.
|C_CashLine_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Payment
|ID Pagamento
|Payment identifier 
|The Payment is a unique identifier of this payment.
|C_Payment_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Selected
|Seleccionado
|null 
|null
|IsSelected<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Price includes Tax
|Preço inclui IVA
|Tax is included in the price  
|The Tax Included checkbox indicates if the prices include tax.  This is also known as the gross price.
|IsTaxIncluded<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Posted
|Lançado
|Posting status 
|The Posted field indicates the status of the Generation of General Ledger Accounting Lines 
|Posted<br>character(1) NOT NULL<br>Button
|-valign="top" 
|-

|-valign="top" 
|Discount Printed
|Desconto Impresso
|Print Discount on Invoice and Order 
|The Discount Printed Checkbox indicates if the discount will be printed on the document.
|IsDiscountPrinted<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Freight Cost Rule
|Frete, Método de Custeio
|Method for charging Freight 
|The Freight Cost Rule indicates the method used when charging for freight.
|FreightCostRule<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Referenced Order
|Referenced Order
|Reference to corresponding Sales/Purchase Order 
|Reference of the Sales Order Line to the corresponding Purchase Order Line or vice versa.
|Ref_Order_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Payment BPartner
|Payment BPartner
|Business Partner responsible for the payment 
|null
|Pay_BPartner_ID<br>numeric(10)<br>ID
|-valign="top" 
|-

|-valign="top" 
|Payment Location
|Payment Location
|Location of the Business Partner responsible for the payment 
|null
|Pay_Location_ID<br>numeric(10)<br>ID
|-valign="top" 
|-

|-valign="top" 
|Currency Type
|Divisa, Tipo
|Currency Conversion Rate Type 
|The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates.
|C_ConversionType_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|User List 1
|Utilizador1
|User defined element #1 
|The user defined element displays the optional elements that have been defined for this account combination.
|User1_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|User List 2
|Utilizador2
|User defined element #2 
|The user defined element displays the optional elements that have been defined for this account combination.
|User2_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Trx Organization
|Trx Organismo
|Performing or initiating organization 
|The organization which performs or initiates this transaction (for another organization).  The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.
|AD_OrgTrx_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Copy Lines
|Copiar Linhas
|Copy Lines from other Order 
|null
|CopyFrom<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Freight Amount
|Frete, Montante
|Freight Amount  
|The Freight Amount indicates the amount charged for Freight in the document currency.
|FreightAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document No
|N.º Documento
|Document sequence number of the document 
|The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|DocumentNo<br>character varying(30) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Description
|Descrição
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>Text
|-valign="top" 
|-

|-valign="top" 
|Document Type
|Tipo documento
|Document type or rules 
|The Document Type determines document sequence and processing rules
|C_DocType_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Status
|Documento Status
|The current status of the document 
|The Document Status indicates the status of a document at this time.  If you want to change the document status, use the Document Action field
|DocStatus<br>character(2) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Date Ordered
|Encomendado em
|Date of Order 
|Indicates the Date an item was ordered.
|DateOrdered<br>timestamp without time zone NOT NULL<br>Date
|-valign="top" 
|-

|-valign="top" 
|Account Date
|Data de Lançamento
|Accounting Date 
|The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any cirrency conversion.
|DateAcct<br>timestamp without time zone NOT NULL<br>Date
|-valign="top" 
|-

|-valign="top" 
|Date Promised
|Prometido para
|Date Order was promised 
|The Date Promised indicates the date, if any, that an Order was promised for.
|DatePromised<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Date printed
|Impresso em
|Date the document was printed. 
|Indicates the Date that a document was printed.
|DatePrinted<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Business Partner 
|Terceiros
|Identifica uma entidade externa à empresa (cliente, fornecedor, vendedor, etc. ) 
|Terceiros são todas as instituições, sociedades ou individuos com quem a empresa tem um relacionamento comercial ou de trabalho. Exemplos: clientes, fornecedores, funcionários, vendedores ou representantes comerciais, etc.
|C_BPartner_ID<br>numeric(10) NOT NULL<br>Search
|-valign="top" 
|-

|-valign="top" 
|Invoice Partner
|Terceiro para Entrega Indirecta
|Terceiro para "Drop Shipment" 
|Terceiro que entrega ao cliente os artigos de uma encomenda que foi redireccionada para um fornecedor. "Drop Shipment" é uma venda em que a empresa recebe a encomenda do cliente e coloca com base na encomenda um pedido de compras a um fornecedor que também fará a entrega dos artigos ao cliente final. 
|Bill_BPartner_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Partner Location
|Endereço Envio
|Identifica o endereço de envio para a Entidade 
|Identifica o endereço de envio a usar para esta Entidade
|C_BPartner_Location_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Invoice Location
|Local Descarga
|Business Partner Shipment Location for Drop Shipment 
|null
|Bill_Location_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Delivery Rule
|Método de Entrega
|Defines the timing of Delivery 
|The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available.
|DeliveryRule<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Priority
|Prioridade
|Priority of a document 
|The Priority indicates the importance (high, medium, low) of this document
|PriorityRule<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Warehouse
|Armazém / Loja
|Storage Warehouse and Service Point 
|The Warehouse identifies a unique Warehouse where products are stored or Services are provided.
|M_Warehouse_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Drop Shipment
|Drop Shipment
|Drop Shipments are sent from the Vendor directly to the Customer 
|Drop Shipments do not cause any Inventory reservations or movements as the Shipment is from the Vendor's inventory. The Shipment of the Vendor to the Customer must be confirmed.
|IsDropShip<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Invoice Rule
|Método de Facturação
|Frequency and method of invoicing  
|The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
|InvoiceRule<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Sales Transaction
|Vendas
|This is a Sales Transaction 
|Esta checkbox indica se este item é uma transacção de Vendas.
|IsSOTrx<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Price List
|Tabela Preços
|Unique identifier of a Price List 
|Price Lists are used to determine the pricing, margin and cost of items purchased or sold.
|M_PriceList_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Currency
|Divisa
|The Currency for this record 
|Indicates the Currency to be used when processing or reporting on this record
|C_Currency_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Sales Representative
|Representante Comercial
|Sales Representative or Company Agent 
|The Sales Representative indicates the Sales Rep for this Region.  Any Sales Rep must be a valid internal user.
|SalesRep_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Self-Service
|Self-service
|This is a Self-Service entry or this entry can be changed via Self-Service 
|Self-Service allows users to enter data or update their data.  The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality.
|IsSelfService<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Payment Rule
|Modo de Pagamento
|How you pay the invoice 
|The Payment Rule indicates the method of invoice payment.
|PaymentRule<br>character(1) NOT NULL<br>Payment
|-valign="top" 
|-

|-valign="top" 
|Payment Term
|Forma de Pagamento
|The terms for Payment of this transaction 
|Payment Terms identify the method and timing of payment for this transaction.  
|C_PaymentTerm_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Project
|Projecto
|Financial Project 
|A Project allows you to track and control internal or external activities.
|C_Project_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Campaign
|Campanha
|Marketing Campaign 
|The Campaign defines a unique marketing program.  Projects can be associated with a pre defined Marketing Campaign.  You can then report based on a specific Campaign.
|C_Campaign_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Total Lines
|Linhas Totais
|Total of all document lines 
|The Total amount displays the total of all lines in document currency
|TotalLines<br>numeric NOT NULL<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Grand Total
|Total geral
|Total amount of document 
|The Grand Total displays the total amount including Tax and Freight in document currency
|GrandTotal<br>numeric NOT NULL<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Order
|Encomenda Vendas
|Encomenda de Vendas 
|As Encomendas são documentos base do sistema.  Uma Encomenda será dada como satisfeita ou completa quando a quantidade encomendada for igual à quantidade entregue e facturada.
|C_Order_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Expedições ===

'''Descrição:''' Business Partner Shipments 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Expedições - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Type
|Tipo documento
|Document type or rules 
|The Document Type determines document sequence and processing rules
|C_DocType_ID<br>numeric(10) NOT NULL<br>Table
|-valign="top" 
|-

|-valign="top" 
|Document No
|N.º Documento
|Document sequence number of the document 
|The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|DocumentNo<br>character varying(30) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Document Status
|Documento Status
|The current status of the document 
|The Document Status indicates the status of a document at this time.  If you want to change the document status, use the Document Action field
|DocStatus<br>character(2) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Movement Type
|Tipo Movimento
|Method of moving the inventory 
|The Movement Type indicates the type of movement (in, out, to production, etc)
|MovementType<br>character(2) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Movement Date
|Movimento, Data
|Date a product was moved in or out of inventory 
|The Movement Date indicates the date that a product moved in or out of inventory.  This is the result of a shipment, receipt or inventory movement.
|MovementDate<br>timestamp without time zone NOT NULL<br>Date
|-valign="top" 
|-

|-valign="top" 
|Sales Representative
|Representante Comercial
|Sales Representative or Company Agent 
|The Sales Representative indicates the Sales Rep for this Region.  Any Sales Rep must be a valid internal user.
|SalesRep_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Description
|Descrição
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>Text
|-valign="top" 
|-

|-valign="top" 
|Warehouse
|Armazém / Loja
|Storage Warehouse and Service Point 
|The Warehouse identifies a unique Warehouse where products are stored or Services are provided.
|M_Warehouse_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|In Dispute
|In Dispute
|Document is in dispute 
|The document is in dispute. Use Requests to track details.
|IsInDispute<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Order
|Encomenda Vendas
|Encomenda de Vendas 
|As Encomendas são documentos base do sistema.  Uma Encomenda será dada como satisfeita ou completa quando a quantidade encomendada for igual à quantidade entregue e facturada.
|C_Order_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Shipment/Receipt
|Expedição/Recepção
|Material Shipment Document 
|The Material Shipment / Receipt 
|M_InOut_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Facturas ===

'''Descrição:''' Business Partner Invoices 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Facturas - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Type
|Tipo documento
|Document type or rules 
|The Document Type determines document sequence and processing rules
|C_DocType_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document No
|N.º Documento
|Document sequence number of the document 
|The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|DocumentNo<br>character varying(30) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Document Status
|Documento Status
|The current status of the document 
|The Document Status indicates the status of a document at this time.  If you want to change the document status, use the Document Action field
|DocStatus<br>character(2) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Self-Service
|Self-service
|This is a Self-Service entry or this entry can be changed via Self-Service 
|Self-Service allows users to enter data or update their data.  The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality.
|IsSelfService<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Date Invoiced
|Facturado em
|Date printed on Invoice 
|The Date Invoice indicates the date printed on the invoice.
|DateInvoiced<br>timestamp without time zone NOT NULL<br>Date
|-valign="top" 
|-

|-valign="top" 
|Sales Representative
|Representante Comercial
|Sales Representative or Company Agent 
|The Sales Representative indicates the Sales Rep for this Region.  Any Sales Rep must be a valid internal user.
|SalesRep_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Description
|Descrição
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>Text
|-valign="top" 
|-

|-valign="top" 
|Paid
|Pago
|The document is paid 
|null
|IsPaid<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|In Dispute
|In Dispute
|Document is in dispute 
|The document is in dispute. Use Requests to track details.
|IsInDispute<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Currency
|Divisa
|The Currency for this record 
|Indicates the Currency to be used when processing or reporting on this record
|C_Currency_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Grand Total
|Total geral
|Total amount of document 
|The Grand Total displays the total amount including Tax and Freight in document currency
|GrandTotal<br>numeric NOT NULL<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Order
|Encomenda Vendas
|Encomenda de Vendas 
|As Encomendas são documentos base do sistema.  Uma Encomenda será dada como satisfeita ou completa quando a quantidade encomendada for igual à quantidade entregue e facturada.
|C_Order_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Invoice
|Factura
|Invoice Identifier 
|The Invoice Document.
|C_Invoice_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Pagamentos ===

'''Descrição:''' Business Partner Payments 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Pagamentos - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Prepayment
|Prepayment
|The Payment/Receipt is a Prepayment 
|Payments not allocated to an invoice with a charge are posted to Unallocated Payments. When setting this flag, the payment is posted to the Customer or Vendor Prepayment account.
|IsPrepayment<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Type
|Tipo documento
|Document type or rules 
|The Document Type determines document sequence and processing rules
|C_DocType_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document No
|N.º Documento
|Document sequence number of the document 
|The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|DocumentNo<br>character varying(30) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Document Status
|Documento Status
|The current status of the document 
|The Document Status indicates the status of a document at this time.  If you want to change the document status, use the Document Action field
|DocStatus<br>character(2) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Self-Service
|Self-service
|This is a Self-Service entry or this entry can be changed via Self-Service 
|Self-Service allows users to enter data or update their data.  The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality.
|IsSelfService<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Transaction Date
|Data Transacção
|Transaction Date 
|The Transaction Date indicates the date of the transaction.
|DateTrx<br>timestamp without time zone NOT NULL<br>Date
|-valign="top" 
|-

|-valign="top" 
|Bank Account
|Conta de Banco
|Account at the Bank 
|The Bank Account identifies an account at this Bank.
|C_BankAccount_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Online Access
|Acesso Online
|Can be accessed online  
|The Online Access check box indicates if the application can be accessed via the web. 
|IsOnline<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Currency
|Divisa
|The Currency for this record 
|Indicates the Currency to be used when processing or reporting on this record
|C_Currency_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Payment amount
|Pagamento, montante
|Amount being paid 
|Indicates the amount this payment is for.  The payment amount can be for single or multiple invoices or a partial payment for an invoice.
|PayAmt<br>numeric NOT NULL<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Discount Amount
|Valor Desconto
|Calculated amount of discount 
|The Discount Amount indicates the discount amount for a document or line.
|DiscountAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Write-off Amount
|Montante Regularizações
|Amount to write-off 
|The Write Off Amount indicates the amount to be written off as uncollectible.
|WriteOffAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Delayed Capture
|Captura Diferida
|Charge after Shipment 
|Delayed Capture is required, if you ship products.  The first credit card transaction is the Authorization, the second is the actual transaction after the shipment of the product.
|IsDelayedCapture<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Invoice
|Factura
|Invoice Identifier 
|The Invoice Document.
|C_Invoice_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Payment
|ID Pagamento
|Payment identifier 
|The Payment is a unique identifier of this payment.
|C_Payment_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Activos ===

'''Descrição:''' Business Partner Assets 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Activos - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Search Key
|Codigo para Selecção
|Codigo principal para selecção de registos - deve ser unico 
|A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|Value<br>character varying(40) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Asset Group
|Grupo de Activos
|Group of Assets 
|The group of assets determines default accounts.  If an asset group is selected in the product category, assets are created when delivering the asset.
|A_Asset_Group_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Name
|Nome
|Alphanumeric identifier of the entity 
|The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.
|Name<br>character varying(60) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Description
|Descrição
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Product
|Artigo
|Product, Service, Item 
|Identifies an item which is either purchased or sold in this organization.
|M_Product_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Attribute Set Instance
|Atributos, Série de Valores
|Product Attribute Set Instance 
|The values of the actual Product Attributes
|M_AttributeSetInstance_ID<br>numeric(10)<br>Product Attribute
|-valign="top" 
|-

|-valign="top" 
|Lot No
|N.º Lote
|Lot number (alphanumeric) 
|The Lot Number indicates the specific lot that a product was part of.
|Lot<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Serial No
|N.º Série
|Product Serial Number  
|The Serial Number identifies a tracked, warranted product.  It can only be used when the quantity is 1.
|SerNo<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Quantity
|Quantidade
|Quantity 
|The Quantity indicates the number of a specific product or item for this document.
|Qty<br>numeric<br>Quantity
|-valign="top" 
|-

|-valign="top" 
|In Service Date
|Na Data Serviço
|Date when Asset was put into service 
|The date when the asset was put into service - usually used as start date for depreciation.
|AssetServiceDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Guarantee Date
|Data Garantia
|Date when guarantee expires 
|Date when the normal guarantee or availability expires
|GuaranteeDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-
|}
  



    
    
=== TAB: Terceiros, Requisições ===

'''Descrição:''' Business Partner Requests 


'''Ajudar''' null


[[image:Info.Terceiro - Terceiros, Requisições - Janela (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Nome''''' 
!style="background:#efefef;" |'''''Descrição''''' 
!style="background:#efefef;" |'''''Ajudar''''' 
!style="background:#efefef;" |'''''Especificações''''' 
|-valign="top" 
|- 


|-valign="top" 
|Client
|Empresa
|A Empresa instalada neste sistema. 
|A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.
|AD_Client_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Organization
|Organismo
|Unidade organizacional componente da Empresa 
|A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.
|AD_Org_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Request Type
|Tipo de Solicitação
|Type of request (e.g. Inquiry, Complaint, ..) 
|Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc.
|R_RequestType_ID<br>numeric(10) NOT NULL<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document No
|N.º Documento
|Document sequence number of the document 
|The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|DocumentNo<br>character varying(30) NOT NULL<br>String
|-valign="top" 
|-

|-valign="top" 
|Group
|Group
|Request Group 
|Group of requests (e.g. version numbers, responsibility, ...)
|R_Group_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Category
|Category
|Request Category 
|Category or Topic of the Request 
|R_Category_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Status
|Status
|Request Status 
|Status if the request (open, closed, investigating, ..)
|R_Status_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Resolution
|Resolution
|Request Resolution 
|Resolution status (e.g. Fixed, Rejected, ..)
|R_Resolution_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Priority
|Prioridade
|Indicates if this request is of a high, medium or low priority. 
|The Priority indicates the importance of this request.
|Priority<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|User Importance
|User Importance
|Priority of the issue for the User 
|null
|PriorityUser<br>character(1)<br>List
|-valign="top" 
|-

|-valign="top" 
|Sales Representative
|Representante Comercial
|Sales Representative or Company Agent 
|The Sales Representative indicates the Sales Rep for this Region.  Any Sales Rep must be a valid internal user.
|SalesRep_ID<br>numeric(10) NOT NULL<br>Table
|-valign="top" 
|-

|-valign="top" 
|Summary
|Resumo
|Texto resumo explicativo da Tarefa 
|The Summary allows free form text entry of a recap of this request.
|Summary<br>character varying(2000) NOT NULL<br>Text
|-valign="top" 
|-

|-valign="top" 
|Date last action
|Data última Operação
|Date this request was last acted on 
|The Date Last Action indicates that last time that the request was acted on.
|DateLastAction<br>timestamp without time zone<br>Date+Time
|-valign="top" 
|-

|-valign="top" 
|Last Result
|Último Resultado
|Result of last contact 
|The Last Result identifies the result of the last contact made.
|LastResult<br>character varying(2000)<br>String
|-valign="top" 
|-

|-valign="top" 
|Due type
|Tipo Vencimento
|Status of the next action for this Request 
|The Due Type indicates if this request is Due, Overdue or Scheduled.
|DueType<br>character(1) NOT NULL<br>List
|-valign="top" 
|-

|-valign="top" 
|Date next action
|Data próxima Operação
|Date that this request should be acted on 
|The Date Next Action indicates the next scheduled date for an action to occur for this request.
|DateNextAction<br>timestamp without time zone<br>Date+Time
|-valign="top" 
|-
|}