FindBillDetail
This Activity Function retrieves an array of AsBillDetail records. It may be configured to execute multiple times within an Activity.
The array of AsBillDetail records can be passed to the CreateBill (APE) for the resulting AsBill record. The function accepts threshold and date parameters to limit the number of BillDetail records returned. Only Pending detail records that fall within the parameter values are included in the array. All parameter values are inclusive meaning BillDetail dates will be greater than or equal to the StartDate parameters and bill amounts must be greater than or equal to the BillMinimumAmountThreshold value.
TYPE=FindBillDetail | |||
Element | Attribute Value | Element Value | Definition |
<MathStatement> | Opening element for math variable | ||
TYPE |
Required attribute: "ACTIVITYFUNCTION" |
Defines the math statement type | |
FUNCTIONNAME |
Required attribute: "FINDBILLDETAIL" |
Defines the function to run value | |
<Parameters> |
Opening element of the parameters | ||
<Parameter> |
|
Required attribute: A field or math variable containing a date
|
Defines the parameter of the function |
NAME |
Required attribute: A field or math variable containing a date Value from "StartDate" |
Defined input name. |
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT" |
Function parameter type: Input/Output |
|
<Parameter> |
|
Predefined MathVariable Name |
|
NAME |
Required attribute: A field or math variable containing a Name Value from "EndDate |
Defines the parameter to assign the value |
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT |
Predefined MathVariable Type |
|
<Parameter> |
|
Predefined parameters for the function to assign the value |
|
NAME |
Required attribute: A field or math variable containing a "BillGroupGUID" Value from "BillGroupGUID" |
|
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT |
Function parameter type: Input/Output |
|
<Parameter> |
|
Predefined parameters for the function |
|
NAME |
Required attribute: A field or math variable containing a "BillMinimumAmountThreshold" Value from "BillMinimumAmountThreshold" |
|
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT |
Function parameter type: Input/Output |
|
<Parameter> |
|
Predefined parameters to assign the value . Value is the field or math variable containing a currency amount |
|
NAME |
Required attribute: A field or math variable containing a "BillMaximumAmountThreshold" Value from "BillMaximumAmountThreshold" |
|
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT |
Function parameter type: Input/Output |
|
<Parameter> |
|
Predefined parameters for the function |
|
NAME |
Required attribute: A field or math variable containing a "BillGroupGUID" Value from "BillGroupGUID" |
|
|
TYPE |
Required attribute: A field or math variable containing a type Value from "INPUT |
Function parameter type: Input/Output |
|
<Parameter> |
|
Predefined parameters to assign the value . Value is the field or math variable containing a string array |
|
NAME |
Required attribute: A field or math variable containing a "BillDetailArray" Value from "BillDetailArray" |
|
|
TYPE |
Required attribute: A field or math variable containing a type Value from "OUTPUT" |
Function parameter type: Input/Output |
XML Example
<Transaction>
<EffectiveDate STATUS= "Enabled" TYPE= "SYSTEM"></EffectiveDate>
<Fields>
<Field>
<Name>StartDate</Name>
<Display>Billing Detail Start Date</Display>
<DataType>Date</DataType>
</Field>
<Field>
<Name>EndDate</Name>
<Display>Billing Detail End Date</Display>
<DataType>Date</DataType> </Field>
<Field>
<Name>ThreshholdMinimumAmount</Name>
<Display>Bill Detail Minimum Threshhold Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>ThreshholdMaximumAmount</Name>
<Display>Bill Detail Maximum Threshhold Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>BillGroupGUID</Name>
<Display>Bill Entity Guid</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>BillOwnerGUID</Name>
<Display>Bill Owner Guid</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>ReferenceID</Name>
<Display>Reference ID</Display>
<DataType>Text</DataType>
</Field>
</Fields>
<Math>
<MathVariables>
<MathVariable VARIABLENAME="BillDetailArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"/> </MathVariable> <MathVariable VARIABLENAME="ReferenceIDMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:ReferenceID</MathVariable>
<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">BillingStartDate</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">BillingEndDate</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">BillGroupGUID</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMinimumAmount</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMaximumAmount</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">BillDetailArrayMV</Parameter>
</Parameters>
</MathStatement>
</MathVariables>
</Math>
</Transaction>
XML Schema
<GenerateBillDetail>
<BillDetail RECEIVABLEDUETYPE=”[AsCodeValue]” BILLGROUPGUID=”[MathVariable GUID]” BILLGROUPTYPE=”[AsCodeValue]”>
<Tests>
<Test>[test expression]</Test>
</Tests>
<BillAmount BILLENTITYGUID=”[MathVariable GUID]” BILLENTITYTYPE=”[AsCodeValue]” DUEDATE=”[MathVariable Date]”>[MathVariable Currency Amount]</BillAmount>
<Fields>
<Field>
<From>[MathVariable or Field]</From>
</Field>
</Fields>
</BillDetail>
</GenerateBillDetail>