Contract
C_Contract
Contract
Overview
| Table Name | C_Contract |
|---|---|
| Access Level | Client Only |
| Entity Type | MM02 |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Client |
| Wiki | View on iDempiere Wiki |
Columns (61)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
AD_OrgTrx_ID |
Table(22) | No | - | Performing or initiating organization |
AD_Tenant_ID |
Table(22) | No | - | Tenant for this installation. |
AD_User_ID |
Table Direct(22) | No | -1 | User within the system - Internal or Business Partner Contact |
Bill_BPartner_ID |
Search(10) | Yes | - | Business Partner to be invoiced |
BillingOffsetDays |
Integer(14) | Yes | 0 | Billing Offset Days |
Bill_Location_ID |
Table(10) | Yes | - | Business Partner Location for invoicing |
Bill_User_ID |
Table(10) | No | - | Business Partner Contact for invoicing |
C_Activity_ID |
Table Direct(22) | No | - | Business Activity |
CancelDate |
Date(7) | No | - | Date when was document cancelled |
C_BPartner_Location_ID |
Table Direct(22) | Yes | -1 | Identifies the (ship to) address for this Business Partner |
C_Contract_ID |
ID(22) | Yes | - | - |
C_ConversionType_ID |
Table Direct(22) | No | - | Currency Conversion Rate Type |
C_Currency_ID |
Table Direct(22) | No | @C_Currency_ID@ | The Currency for this record |
C_Order_ID |
Search(22) | No | - | Order |
COReference |
String(120) | No | - | Transaction Reference Number Contract of your Business Partner |
C_PaymentTerm_ID |
Table Direct(10) | Yes | - | The terms of Payment (timing, discount) |
C_Project_ID |
Table Direct(22) | No | - | Financial Project |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
DocAction |
Button(2) | No | CO | The targeted status of the document |
DocBaseType |
List(3) | No | - | Logical type of document |
DocStatus |
List(2) | Yes | DR | The current status of the document |
Duration |
Integer(22) | No | 1 | Normal Duration in Duration Unit |
DurationUnit |
List(1) | No | M | Unit of Duration |
EndDate |
Date(7) | Yes | - | Last effective date (inclusive) |
GrandTotal |
Amount(22) | No | - | Total amount of document |
Help |
Text(2000) | No | - | Comment or Hint |
IncoTerm |
List(3) | Yes | DAP | Defines the Inco Term strategy |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsApproved |
Yes-No(1) | No | - | Indicates if this document requires approval |
IsPrinted |
Yes-No(1) | Yes | - | Indicates if this document / line is printed |
IsSOTrx |
Yes-No(1) | Yes | @IsSOTrx@ | This is a Sales Transaction |
IsSummary |
Yes-No(1) | No | N | This is a summary entity |
IsTaxIncluded |
Yes-No(1) | Yes | N | Tax is included in the price |
LastInvoiceDate |
Date(7) | No | - | Last Invoice Date |
LastRenewalDate |
Date(7) | No | - | Last Renewal Date |
Length |
Quantity(14) | Yes | 1 | - |
M_DiscountSchema_ID |
Search(10) | No | - | Schema to calculate the trade discount percentage |
M_PriceList_ID |
Search(22) | Yes | - | Unique identifier of a Price List |
Name |
String(60) | No | - | Alphanumeric identifier of the entity |
PeriodType |
List(1) | Yes | Y | Period Type |
Processed |
Yes-No(1) | Yes | - | The document has been processed |
ProcessedOn |
Number(20) | No | - | The date+time (expressed in decimal format) when the document has been processed |
RenewalDate |
Date(7) | No | - | Date when a subscription renewal |
RenewalSchedule |
List(3) | No | 1ST | Define renewal scheduling for Contract |
SalesRep_ID |
Table(22) | Yes | - | Sales Representative or Company Agent |
StartDate |
Date(7) | Yes | @#Date@ | First effective day (inclusive) |
TotalLines |
Amount(22) | Yes | 0 | Total of all document lines |
TrialEndDate |
Date(7) | No | - | When trial period expire |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
User1_ID |
Table(22) | No | - | User defined element #1 |
User2_ID |
Table(22) | No | - | User defined element #2 |
DocumentNo |
String(30) | Yes | - | Document sequence number of the document |
C_BPartner_ID |
Search(22) | Yes | - | Identifies a Business Partner |
C_DocType_ID |
Table Direct(22) | Yes | 0 | Document type or rules |
C_Contract_UU |
String(36) | No | - | - |
C_DocTypeTarget_ID |
Table(10) | Yes | -1 | Target document type for conversing documents |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_OrgTrx_ID |
AD_OrgTrx.AD_OrgTrx_ID | Performing or initiating organization |
AD_Tenant_ID |
AD_Tenant.AD_Tenant_ID | Tenant for this installation. |
AD_User_ID |
AD_User.AD_User_ID | User within the system - Internal or Business Partner Contact |
Bill_BPartner_ID |
Bill_BPartner.Bill_BPartner_ID | Business Partner to be invoiced |
Bill_Location_ID |
Bill_Location.Bill_Location_ID | Business Partner Location for invoicing |
Bill_User_ID |
Bill_User.Bill_User_ID | Business Partner Contact for invoicing |
C_Activity_ID |
C_Activity.C_Activity_ID | Business Activity |
C_BPartner_Location_ID |
C_BPartner_Location.C_BPartner_Location_ID | Identifies the (ship to) address for this Business Partner |
C_ConversionType_ID |
C_ConversionType.C_ConversionType_ID | Currency Conversion Rate Type |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_Order_ID |
C_Order.C_Order_ID | Order |
C_PaymentTerm_ID |
C_PaymentTerm.C_PaymentTerm_ID | The terms of Payment (timing, discount) |
C_Project_ID |
C_Project.C_Project_ID | Financial Project |
M_DiscountSchema_ID |
M_DiscountSchema.M_DiscountSchema_ID | Schema to calculate the trade discount percentage |
M_PriceList_ID |
M_PriceList.M_PriceList_ID | Unique identifier of a Price List |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
User1_ID |
User1.User1_ID | User defined element #1 |
User2_ID |
User2.User2_ID | User defined element #2 |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
C_DocType_ID |
C_DocType.C_DocType_ID | Document type or rules |
C_DocTypeTarget_ID |
C_DocTypeTarget.C_DocTypeTarget_ID | Target document type for conversing documents |
Generated on 2026-05-03T16:39:15.701359494Z