prudhvi
Active Member
Can any body help me out in writing equivalent SQL query to the following select structure...Thanks in advance...
/**************************************************************************
* Business Function: CreateF03B11SelectStruct
*
* Description: Populates Select Data Structure For F03B11
*
* Parameters:
* LPBHVRCOM lpBhvrCom Business Function Communications
* LPVOID lpVoid Void Parameter - DO NOT USE!
* LPDSD03B0203B lpDS Parameter Data Structure Pointer
*
*************************************************************************/
ID I03B0203_FillF03B11SelectStructure(LPDSD03B0203A lpDS, NEWSELECTSTRUCT* SelectF03B11, int* nNumSelectF03B11)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "R1";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "R5";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "RU";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "RB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_OPEN;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_OR;
SelectF03B11[*nNumSelectF03B11].lpValue = "RB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_ICUT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "IB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_CLOSE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_POST);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "D";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_OPEN;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_POST);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_OR;
SelectF03B11[*nNumSelectF03B11].lpValue = "D";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_ISTR);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "1";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_CLOSE;
(*nNumSelectF03B11)++;
if (!IsStringBlank(lpDS->szAccountId))
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_AID);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = lpDS->szAccountId;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnCentury) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_CTRY);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnCentury;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnFiscalYear) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_FY);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnFiscalYear;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnPeriodNumber) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_PN);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnPeriodNumber;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
return (0);
}
/**************************************************************************
* Business Function: CreateF03B11SelectStruct
*
* Description: Populates Select Data Structure For F03B11
*
* Parameters:
* LPBHVRCOM lpBhvrCom Business Function Communications
* LPVOID lpVoid Void Parameter - DO NOT USE!
* LPDSD03B0203B lpDS Parameter Data Structure Pointer
*
*************************************************************************/
ID I03B0203_FillF03B11SelectStructure(LPDSD03B0203A lpDS, NEWSELECTSTRUCT* SelectF03B11, int* nNumSelectF03B11)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "R1";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "R5";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "RU";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "RB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_OPEN;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_DCT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_OR;
SelectF03B11[*nNumSelectF03B11].lpValue = "RB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_ICUT);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "IB";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_CLOSE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_POST);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "D";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_OPEN;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_POST);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_OR;
SelectF03B11[*nNumSelectF03B11].lpValue = "D";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_NE;
(*nNumSelectF03B11)++;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_ISTR);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = "1";
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
SelectF03B11[*nNumSelectF03B11].nParen = JDEDB_PAREN_CLOSE;
(*nNumSelectF03B11)++;
if (!IsStringBlank(lpDS->szAccountId))
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_AID);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = lpDS->szAccountId;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_EQ;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnCentury) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_CTRY);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnCentury;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnFiscalYear) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_FY);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnFiscalYear;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
if (MathZeroTest(&lpDS->mnPeriodNumber) != 0)
{
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szDict, NID_PN);
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item1.szTable, NID_F03B11);
SelectF03B11[*nNumSelectF03B11].Item1.idInstance = 0;
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szDict, "");
jdeNIDcpy(SelectF03B11[*nNumSelectF03B11].Item2.szTable, "");
SelectF03B11[*nNumSelectF03B11].Item2.idInstance = 0;
SelectF03B11[*nNumSelectF03B11].nValues = 1;
SelectF03B11[*nNumSelectF03B11].nAndOr = JDEDB_ANDOR_AND;
SelectF03B11[*nNumSelectF03B11].lpValue = &lpDS->mnPeriodNumber;
SelectF03B11[*nNumSelectF03B11].nCmp = JDEDB_CMP_GE;
(*nNumSelectF03B11)++;
}
return (0);
}