C_BPartner_Location_ID |
Table Direct(10) |
Yes |
- |
Identifies the (ship to) address for this Business Partner |
C_LeadSource_ID |
Table Direct(10) |
No |
- |
- |
C_OppAgeDays |
Integer(14) |
No |
- |
Age of Opportunity calculated in Days |
C_OppStatusAgeDays |
Integer(14) |
No |
- |
Age of Status in Days |
LastContact |
Date(7) |
No |
- |
Date this individual was last contacted |
LastContactAge |
Integer(14) |
No |
- |
Age of Last Contact calculated in Days |
LastStatusChange |
Date(7) |
No |
- |
The date last status change |
LeadSource |
List(10) |
No |
- |
The source of this lead/opportunity |
Margin |
Number(32) |
No |
- |
Margin for a product as a percentage |
MarginAmt |
Amount(32) |
No |
- |
Difference between actual and limit price multiplied by the quantity |
Name |
String(255) |
No |
- |
Alphanumeric identifier of the entity |
C_BPartner_ID |
Search(10) |
Yes |
- |
Identifies a Business Partner |
DocumentNo |
String(60) |
Yes |
- |
Document sequence number of the document |
Description |
String(255) |
No |
- |
Optional short description of the record |
OpportunityAmt |
Amount(22) |
Yes |
- |
The estimated value of this opportunity. |
C_Currency_ID |
Table Direct(10) |
Yes |
- |
The Currency for this record |
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_User_ID |
Table(10) |
Yes |
-1 |
User within the system - Internal or Business Partner Contact |
C_Campaign_ID |
Table Direct(10) |
No |
- |
Marketing Campaign |
CloseDate |
Date(7) |
No |
- |
Close Date |
Comments |
Text(5000) |
No |
- |
Comments or additional information |
C_Opportunity_ID |
ID(22) |
Yes |
- |
- |
C_Opportunity_UU |
String(36) |
No |
- |
- |
C_Order_ID |
Search(10) |
No |
- |
Order |
Cost |
Amount(22) |
No |
0 |
Cost information |
Created |
Date+Time(7) |
Yes |
SYSDATE |
Date this record was created |
CreatedBy |
Search(22) |
Yes |
- |
User who created this records |
C_SalesStage_ID |
Table(10) |
Yes |
@SQL=SELECT C_SalesStage_ID FROM C_SalesStage WHERE AD_Client_ID=@#AD_Client_ID@ order by SeqNo ASC Fetch First Row Only |
Stages of the sales process |
ExpectedCloseDate |
Date(7) |
Yes |
- |
Expected Close Date |
IsActive |
Yes-No(1) |
Yes |
Y |
The record is active in the system |
Probability |
Integer(22) |
Yes |
- |
- |
SalesRep_ID |
Table(10) |
No |
@#AD_User_ID@ |
Sales Representative or Company Agent |
Updated |
Date+Time(7) |
Yes |
SYSDATE |
Date this record was updated |
UpdatedBy |
Search(22) |
Yes |
- |
User who updated this records |
WeightedAmt |
Amount(22) |
No |
- |
The amount adjusted by the probability. |