A_Asset_ID |
Search(22) |
No |
- |
Asset used internally or by customers |
BillingDate |
Date(7) |
No |
- |
Date of billing |
ContractChargeMode |
List(1) |
Yes |
D |
Payment is due at the beginning (for example, the first day of the month) or end of the charge period (for example, the last day of the month). |
ContractLineType |
List(1) |
Yes |
R |
Define Product will be charged One Time, Recurring or based on Usage/expense |
DatePromised |
Date(29) |
No |
- |
Date Order was promised |
Discount |
Number(10) |
Yes |
0 |
Discount in percent |
DurationUnit |
List(1) |
No |
- |
Unit of Duration |
EndDate |
Date(29) |
No |
- |
Last effective date (inclusive) |
GuaranteeDate |
Date(7) |
No |
- |
Date when guarantee expires |
GuaranteeMonths |
List(2) |
No |
- |
Number of Months the product is guaranteed or available |
IsDescription |
Yes-No(1) |
Yes |
N |
if true, the line is just description and no transaction |
IsFixedAssetInvoice |
Yes-No(1) |
No |
- |
- |
IsPrinted |
Yes-No(1) |
Yes |
Y |
Indicates if this document / line is printed |
LastBillingDate |
Date(7) |
No |
- |
Last Date of billing |
LastDateExpense |
Date(7) |
No |
- |
Last Date of expense |
LastRenewalDate |
Date(7) |
No |
- |
Last Renewal Date |
LineTotalAmt |
Amount(22) |
No |
- |
Total line amount incl. Tax |
M_AttributeSetInstance_ID |
Product Attribute(22) |
Yes |
- |
Product Attribute Set Instance |
M_RMALine_ID |
Table Direct(22) |
No |
- |
Return Material Authorization Line |
PriceEntered |
Costs+Prices(22) |
Yes |
- |
Price Entered - the price based on the selected/base UoM |
Processed |
Yes-No(1) |
Yes |
- |
The document has been processed |
QtyEntered |
Quantity(22) |
Yes |
1 |
The Quantity Entered is based on the selected UoM |
QtyInvoiced |
Quantity(22) |
Yes |
1 |
Invoiced Quantity |
Ref_InvoiceLine_ID |
ID(22) |
No |
- |
- |
RenewalDate |
Date(29) |
No |
- |
Date when a subscription renewal |
RenewalSchedule |
List(3) |
No |
1ST |
Define renewal scheduling for Contract |
S_ResourceAssignment_ID |
Assignment(22) |
No |
- |
Resource Assignment |
StartDate |
Date(29) |
No |
- |
First effective day (inclusive) |
S_TimeExpenseRule_ID |
Table Direct(22) |
No |
- |
- |
TaxAmt |
Amount(22) |
No |
- |
Tax Amount for a document |
UsageDataAggregation |
List(1) |
No |
- |
- |
C_Contract_ID |
Search(22) |
Yes |
- |
- |
M_Product_ID |
Search(22) |
No |
- |
Product, Service, Item |
Line |
Integer(22) |
Yes |
@SQL=SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM C_ContractLine WHERE C_Contract_ID=@C_Contract_ID@ |
Unique line for this document |
LineNetAmt |
Amount(22) |
Yes |
- |
Line Extended Amount (Quantity x Actual Price) without Freight and Charges |
A_Asset_Group_ID |
Table Direct(10) |
No |
- |
Group of Assets |
A_CapvsExp |
List(3) |
No |
- |
- |
A_CreateAsset |
Yes-No(1) |
No |
'N' |
- |
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(10) |
No |
- |
Performing or initiating organization |
A_Processed |
Yes-No(1) |
No |
'N' |
- |
C_Activity_ID |
Table Direct(10) |
No |
- |
Business Activity |
C_Campaign_ID |
Table Direct(10) |
No |
- |
Marketing Campaign |
C_Charge_ID |
Table Direct(22) |
No |
- |
Additional document charges |
C_ContractLine_ID |
ID(22) |
Yes |
- |
- |
C_ContractLine_UU |
String(36) |
No |
- |
- |
C_OrderLine_ID |
Search(22) |
No |
- |
Sales Order Line |
C_Project_ID |
Table Direct(10) |
No |
- |
Financial Project |
C_ProjectPhase_ID |
Table Direct(10) |
No |
- |
Phase of a Project |
C_ProjectTask_ID |
Table Direct(10) |
No |
- |
Actual Project Task in a Phase |
Created |
Date+Time(7) |
Yes |
SYSDATE |
Date this record was created |
CreatedBy |
Search(22) |
Yes |
- |
User who created this records |
C_Tax_ID |
Table Direct(22) |
Yes |
- |
Tax identifier |
C_UOM_ID |
Table Direct(22) |
No |
@#C_UOM_ID@ |
Unit of Measure |
Description |
Text(255) |
No |
- |
Optional short description of the record |
IsActive |
Yes-No(1) |
Yes |
Y |
The record is active in the system |
M_InOutLine_ID |
Search(22) |
No |
- |
Line on Shipment or Receipt document |
PriceActual |
Costs+Prices(22) |
Yes |
- |
Actual Price |
PriceLimit |
Costs+Prices(22) |
Yes |
- |
Lowest price for a product |
PriceList |
Costs+Prices(22) |
Yes |
- |
List Price |
RRAmt |
Amount(22) |
No |
- |
Revenue Recognition Amount |
RRStartDate |
Date+Time(7) |
No |
- |
Revenue Recognition Start Date |
Updated |
Date+Time(7) |
Yes |
SYSDATE |
Date this record was updated |
UpdatedBy |
Search(22) |
Yes |
- |
User who updated this records |
User1_ID |
Table(10) |
No |
- |
User defined element #1 |
User2_ID |
Table(10) |
No |
- |
User defined element #2 |