RetrieveDistinctValuesFromF00167

Retrieve Distinct Values for all Columns from F00167

Minor Business Rule

Object Name: B9500167

Parent DLL: CCONVERT

Location: Client/Server

Language: C

Data Structure

D9500167 - Retrieve Distinct Values for all Columns from F00167

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szNameObject	OBNM	char	OPT	NONE
The name that identifies a system object. J.D. Edwards ERP architecture is object-based. Discrete software objects are the building blocks for all applications, and developers can reuse the objects in multiple applications. The Object Librarian tracks each object. Examples of system objects include: o Batch Applications (such as reports) o Interactive Applications o Business Views o Business Functions o Business Functions Data Structures o Event Rules o Media Object Data Structures
cMediaObjectDocTypeConstant	MODOCTPC	char	OPT	NONE
If this constant is selected, media object Document Type will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectDescriptionCon	MODL01CON	char	OPT	NONE
If this constant is selected, media object Description will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectDocAuthorConst	MOAUTHORC	char	OPT	NONE
If this constant is selected, media object Author will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCreatedDateCon	MOCDT	char	OPT	NONE
If this constant is selected, media object Creation Date will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectStatusConstant	MOSTATUSC	char	OPT	NONE
If this constant is selected, media object Status will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectEffectiveDateF	MOEFDTFRC	char	OPT	NONE
If this constant is selected, media object From Effective Date will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectEffectiveDateT	MOEFDTTOC	char	OPT	NONE
If this constant is selected, media object To Effective Date will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectReviewDateCons	MOREVDTC	char	OPT	NONE
If this constant is selected, media object Review Date will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCopyLinkFlagCo	MOCPYLINKC	char	OPT	NONE
If this constant is selected, media object Copy/Link will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectLanguageConsta	MOLNGPCON	char	OPT	NONE
If this constant is selected, media object Document Language will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectMCUConstant	MOMCU	char	OPT	NONE
If this constant is selected, media object Business Unit will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCompanyConstant	MOCO	char	OPT	NONE
If this constant is selected, media object Company will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCustomerConsta	MOAN8	char	OPT	NONE
If this constant is selected, media object Address Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectShipToNumberCo	MOSHAN	char	OPT	NONE
If this constant is selected, media object Ship To Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectSupplierConsta	MOAN8V	char	OPT	NONE
If this constant is selected, media object Supplier will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectEmployeeConsta	MOEMPLC	char	OPT	NONE
If this constant is selected, media object Employee will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectDocumentNumber	MODOCO	char	OPT	NONE
If this constant is selected, media object Document Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectDocumentTypeCo	MODCTO	char	OPT	NONE
If this constant is selected, media object Document type will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectItemNumberCons	MOITM	char	OPT	NONE
If this constant is selected, media object Item Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectLongItemNumber	MOLITM	char	OPT	NONE
If this constant is selected, media object Long Item Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObject3rdItemNumberC	MOAITM	char	OPT	NONE
If this constant is selected, media object 3rd Item Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCallNumberCons	MOCALLNUMC	char	OPT	NONE
If this constant is selected, media object Call Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectOpportunityNum	MOOPPNUMC	char	OPT	NONE
If this constant is selected, media object Opportunity Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectCompetitorNumb	MOCOMPETC	char	OPT	NONE
If this constant is selected, media object Competitor Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectVehicleNumberC	MOVEHN	char	OPT	NONE
If this constant is selected, media object Vehicle Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectAccountNumberC	MOAID	char	OPT	NONE
If this constant is selected, media object Account Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectAssetNumberCon	MONUMB	char	OPT	NONE
If this constant is selected, media object Asset Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectDrawNumberCons	MODRAW	char	OPT	NONE
If this constant is selected, media object Draw Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant1	MOCONST1	char	OPT	NONE
If this constant is selected, media object Category Code 1 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant3	MOCONST3	char	OPT	NONE
If this constant is selected, media object Category Code 3 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant4	MOCONST4	char	OPT	NONE
If this constant is selected, media object Category Code 4 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant5	MOCONST5	char	OPT	NONE
If this constant is selected, media object Category Code 5 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant6	MOCONST6	char	OPT	NONE
If this constant is selected, media object Category Code 5 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant7	MOCONST7	char	OPT	NONE
If this constant is selected, media object Category Code 7 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant8	MOCONST8	char	OPT	NONE
If this constant is selected, media object Category Code 8 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant9	MOCONST9	char	OPT	NONE
If this constant is selected, media object Category Code 9 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant10	MOCONST10	char	OPT	NONE
If this constant is selected, media object Category Code 10 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant11	MOCONST11	char	OPT	NONE
If this constant is selected, media object Category Code 11 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant12	MOCONST12	char	OPT	NONE
If this constant is selected, media object Category Code 12 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant13	MOCONST13	char	OPT	NONE
If this constant is selected, media object Category Code 13 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant14	MOCONST14	char	OPT	NONE
If this constant is selected, media object Category Code 14 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant15	MOCONST15	char	OPT	NONE
If this constant is selected, media object Category Code 15 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant16	MOCONST16	char	OPT	NONE
If this constant is selected, media object Category Code 16 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant17	MOCONST17	char	OPT	NONE
If this constant is selected, media object Category Code 17 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant18	MOCONST18	char	OPT	NONE
If this constant is selected, media object Category Code 18 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant19	MOCONST19	char	OPT	NONE
If this constant is selected, media object Category Code 19 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant20	MOCONST20	char	OPT	NONE
If this constant is selected, media object Category Code 20 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant21	MOCONST21	char	OPT	NONE
If this constant is selected, media object Category Code 21 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant22	MOCONST22	char	OPT	NONE
If this constant is selected, media object Category Code 22 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant23	MOCONST23	char	OPT	NONE
If this constant is selected, media object Category Code 23 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant24	MOCONST24	char	OPT	NONE
If this constant is selected, media object Category Code 24 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant25	MOCONST25	char	OPT	NONE
If this constant is selected, media object Category Code 25 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant26	MOCONST26	char	OPT	NONE
If this constant is selected, media object Category Code 26 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant27	MOCONST27	char	OPT	NONE
If this constant is selected, media object Category Code 27 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant28	MOCONST28	char	OPT	NONE
If this constant is selected, media object Category Code 28 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant29	MOCONST29	char	OPT	NONE
If this constant is selected, media object Category Code 29 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant30	MOCONST30	char	OPT	NONE
If this constant is selected, media object Category Code 30 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOCategoryConstant2	MOCONST2	char	OPT	NONE
If this constant is selected, media object Category Code 2 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMODateConstant1	MODTCON1	char	OPT	NONE
If this constant is selected, media object User Defined Date 1 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMODateConstant2	MODTCON2	char	OPT	NONE
If this constant is selected, media object User Defined Date 2 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMODateConstant3	MODTCON3	char	OPT	NONE
If this constant is selected, media object User Defined Date 3 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMODateConstant4	MODTCON4	char	OPT	NONE
If this constant is selected, media object User Defined Date 4 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMODateConstant5	MODTCON5	char	OPT	NONE
If this constant is selected, media object User Defined Date 5 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOMathNumConstant1	MOMNCON1	char	OPT	NONE
If this constant is selected, media object User Defined Number 1 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOMathNumConstant2	MOMNCON2	char	OPT	NONE
If this constant is selected, media object User Defined Number 2 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOMathNumConstant3	MOMNCON3	char	OPT	NONE
If this constant is selected, media object User Defined Number 3 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOMathNumConstant4	MOMNCON4	char	OPT	NONE
If this constant is selected, media object User Defined Number 4 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMOMathNumConstant5	MOMNCON5	char	OPT	NONE
If this constant is selected, media object User Defined Number 5 will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
szCrossReferenceSearchType	CRTYP	char	OPT	NONE
Select Search Type from list of valid values in UDC table 98/XF. Use visual assist to view and select valid values.
cMediaObjectCampaignNumber	MOCAMPNUMC	char	OPT	NONE
If this constant is selected, media object Campaign Number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectActivityFlag	MOACTFLG	char	OPT	NONE
If this constant is selected, media object activity flag will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectSERKFlag	MOSRKFLG	char	OPT	NONE
If this constant is selected, media object SERK number will be shown as a column in the Media Object Search application and its value can be entered in the Media Object Categories application.
cMediaObjectFutureChar1	MOFCHAR1	char	OPT	NONE
Media Object Future Use Char 1.
cMediaObjectFutureChar2	MOFCHAR2	char	OPT	NONE
Media Object Future Use Char 2.
cMediaObjectFutureChar3	MOFCHAR3	char	OPT	NONE
Media Object Future Use Char 3.
cMediaObjectFutureChar4	MOFCHAR4	char	OPT	NONE
Media Object Future Use Char 4.
cMediaObjectFutureChar5	MOFCHAR5	char	OPT	NONE
Media Object Future Use Char 5.
cMediaObjectFutureChar6	MOFCHAR6	char	OPT	NONE
Media Object Future Use Char 6.
cMediaObjectFutureChar7	MOFCHAR7	char	OPT	NONE
Media Object Future Use Char 7.
cMediaObjectFutureChar8	MOFCHAR8	char	OPT	NONE
Media Object Future Use Char 8.

Related Functions

None

Related Tables

None