F1201F1217BusinessViewFetch

F1201F, F1201/1217 Fetch

Minor Business Rule

Object Name: B1300850

Parent DLL: CCRIN

Location: Client/Server

Language: C

Data Structure

D1300850 - F1201F1217 Business View Fetch

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAssetItemNumber	NUMB	MATH_NUMERIC	REQ	INPUT
An 8-digit number that uniquely identifies an asset.
szCompany	CO	char	OPT	OUTPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szCostCenter	MCU	char	OPT	OUTPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szCostCenterLocation	LOC	char	OPT	OUTPUT
The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table (F0006).
szCostCenterAlt	MMCU	char	OPT	OUTPUT
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
szEquipmentStatus	EQST	char	OPT	OUTPUT
A user defined code (12/ES) that identifies the equipment or disposal status of an asset, such as available, down, or disposed.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnAddressNumberLessor	LANO	MATH_NUMERIC	OPT	OUTPUT
The address book number for the lessor, renter, or lending institution.
szProductFamily	PRODF	char	OPT	OUTPUT
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.
szProductModel	PRODM	char	OPT	OUTPUT
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.
szMajorClass	ACL1	char	OPT	OUTPUT
A user defined code (12/C1) that determines the accounting class category code. You use this accounting category code to classify assets into groups or families, for example, 100 for land, 200 for vehicles, and 300 for general office equipment. J.D. Edwards recommends that you set up major class codes that correspond to the major general ledger object accounts in order to facilitate the reconciliation to the general ledger. Note: If you do not want to use the major accounting class code, you must set up a value for blank in the user defined code table.
szSubClass	ACL2	char	OPT	OUTPUT
A user defined code (12/C2) that is used to classify assets into groups or families. You use the equipment category code as a subclass to further define the accounting class, for example, 310 for copy equipment, 320 for projectors,and 330 for typewriters within the accounting class for general office equipment. Note: If you do not want to use the major equipment class, you must set up a value for blank in the user defined code table.
szClassCode3	ACL3	char	OPT	OUTPUT
A user defined code (12/C3) that classifies assets into groups or families. You use the manufacturer category code to further define subclass codes. For example, you can define an International Harvester, single-axle within the subclass for trucks.
szClassCode4	ACL4	char	OPT	OUTPUT
A user defined code (12/C4) that classifies assets into groups or families. You use the model year category code to further define the subclass codes. For example, you can define a 1990 International Harvester, single-axle within the subclass for trucks.
szClassCode5	ACL5	char	OPT	OUTPUT
A user defined code (12/C5) that classifies assets into groups or families. You use the usage category codes to further define the subclass codes.
szClassCode6	ACL6	char	OPT	OUTPUT
A user defined code (12/C6) that classifies assets into groups or families. You use this code to further define the subclass codes.
szClassCode7	ACL7	char	OPT	OUTPUT
A user defined code (12/C7) that classifies assets into groups or families. You use this category code to further define the subclass codes.
szClassCode8	ACL8	char	OPT	OUTPUT
A user defined code (system 12, type C8) that is used to classify assets into groups or families. You use this category code to further define the subclass codes.
szClassCode9	ACL9	char	OPT	OUTPUT
A user defined code (system 12, type C9) that is used to classify assets into groups or families. You use this category code to further define the subclass codes.
szClassCode0	ACL0	char	OPT	OUTPUT
A user defined code (12/CO) that groups similar items for billing. If you are an Equipment Management client and you use Equipment Billing, you must use this category code for rate group purposes only.
szCatagoryCodeFA	FA1	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F1 to view or change values for this category code.
szCategoryCodeFA2	FA2	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F2 to view or change values for this category code.
szCategoryCodeFA3	FA3	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F3 to view or change values for this category code.
szCategoryCodeFA4	FA4	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F4 to view or change values for this category code.
szCategoryCodeFA5	FA5	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F5 to view or change values for this category code.
szCategoryCodeFA6	FA6	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F6 to view or change values for this category code.
szCategoryCodeFA7	FA7	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F7 to view or change values for this category code.
szCategoryCodeFA8	FA8	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F8 to view or change values for this category code.
szCategoryCodeFA9	FA9	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F9 to view or change values for this category code.
szCategoryCodeFA0	FA0	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F0 to view or change values for this category code.
szCategoryCodeFA21	FA21	char	OPT	OUTPUT
A 10-digit category code that can be specified for any purpose. This code can then be used to selectively extract specific assets from the Item Master. See User Defined Codes, system 12, code 21 to view and/or change values for this category code.
szCategoryCodeFA22	FA22	char	OPT	OUTPUT
A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/22 to view or change values for this category code.
szCategoryCodeFA23	FA23	char	OPT	OUTPUT
A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/23 to view or change values for this category code.
szCategoryCodeCustomerProf	ZE01	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_2	ZE02	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_3	ZE03	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_4	ZE04	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_5	ZE05	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_6	ZE06	char	OPT	OUTPUT
A user defined reporting code for equipment. Enter a value from UDC 17/B6.
szCategoryCodeCustomerProf_7	ZE07	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_8	ZE08	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_9	ZE09	char	OPT	OUTPUT
A user defined reporting code for equipment.
szCategoryCodeCustomerProf_10	ZE10	char	OPT	OUTPUT
A user defined reporting code for equipment.
szSerialTagNumber	ASID	char	OPT	OUTPUT
A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track assets by the manufacturer's serial number. You are not required to use a serial number to identify an asset. Every serial number that you enter must be unique.
szUnitNumber	APID	char	OPT	OUTPUT
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is typically the serial number.
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.

Related Functions

None

Related Tables

None

F1201FetchAssetInformation

F1201F, F1201/1217 Fetch

Minor Business Rule

Object Name: B1300850

Parent DLL: CCRIN

Location: Client/Server

Language: C

Data Structure

D1300850A - F1201 Fetch Asset Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAssetItemNumber	NUMB	MATH_NUMERIC	REQ	INPUT
An 8-digit number that uniquely identifies an asset.
szCompany	CO	char	OPT	OUTPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szCostCenter	MCU	char	OPT	OUTPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szCostCenterLocation	LOC	char	OPT	OUTPUT
The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table (F0006).
szEquipmentStatus	EQST	char	OPT	OUTPUT
A user defined code (12/ES) that identifies the equipment or disposal status of an asset, such as available, down, or disposed.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnAddressNumberLessor	LANO	MATH_NUMERIC	OPT	OUTPUT
The address book number for the lessor, renter, or lending institution.
szMajorClass	ACL1	char	OPT	OUTPUT
A user defined code (12/C1) that determines the accounting class category code. You use this accounting category code to classify assets into groups or families, for example, 100 for land, 200 for vehicles, and 300 for general office equipment. J.D. Edwards recommends that you set up major class codes that correspond to the major general ledger object accounts in order to facilitate the reconciliation to the general ledger. Note: If you do not want to use the major accounting class code, you must set up a value for blank in the user defined code table.
szSubClass	ACL2	char	OPT	OUTPUT
A user defined code (12/C2) that is used to classify assets into groups or families. You use the equipment category code as a subclass to further define the accounting class, for example, 310 for copy equipment, 320 for projectors,and 330 for typewriters within the accounting class for general office equipment. Note: If you do not want to use the major equipment class, you must set up a value for blank in the user defined code table.
szClassCode3	ACL3	char	OPT	OUTPUT
A user defined code (12/C3) that classifies assets into groups or families. You use the manufacturer category code to further define subclass codes. For example, you can define an International Harvester, single-axle within the subclass for trucks.
szClassCode4	ACL4	char	OPT	OUTPUT
A user defined code (12/C4) that classifies assets into groups or families. You use the model year category code to further define the subclass codes. For example, you can define a 1990 International Harvester, single-axle within the subclass for trucks.
szClassCode5	ACL5	char	OPT	OUTPUT
A user defined code (12/C5) that classifies assets into groups or families. You use the usage category codes to further define the subclass codes.
szClassCode6	ACL6	char	OPT	OUTPUT
A user defined code (12/C6) that classifies assets into groups or families. You use this code to further define the subclass codes.
szClassCode7	ACL7	char	OPT	OUTPUT
A user defined code (12/C7) that classifies assets into groups or families. You use this category code to further define the subclass codes.
szClassCode8	ACL8	char	OPT	OUTPUT
A user defined code (system 12, type C8) that is used to classify assets into groups or families. You use this category code to further define the subclass codes.
szClassCode9	ACL9	char	OPT	OUTPUT
A user defined code (system 12, type C9) that is used to classify assets into groups or families. You use this category code to further define the subclass codes.
szClassCode0	ACL0	char	OPT	OUTPUT
A user defined code (12/CO) that groups similar items for billing. If you are an Equipment Management client and you use Equipment Billing, you must use this category code for rate group purposes only.
szCatagoryCodeFA	FA1	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F1 to view or change values for this category code.
szCategoryCodeFA2	FA2	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F2 to view or change values for this category code.
szCategoryCodeFA3	FA3	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F3 to view or change values for this category code.
szCategoryCodeFA4	FA4	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F4 to view or change values for this category code.
szCategoryCodeFA5	FA5	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F5 to view or change values for this category code.
szCategoryCodeFA6	FA6	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F6 to view or change values for this category code.
szCategoryCodeFA7	FA7	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F7 to view or change values for this category code.
szCategoryCodeFA8	FA8	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F8 to view or change values for this category code.
szCategoryCodeFA9	FA9	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F9 to view or change values for this category code.
szCategoryCodeFA0	FA0	char	OPT	OUTPUT
A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/F0 to view or change values for this category code.
szCategoryCodeFA21	FA21	char	OPT	OUTPUT
A 10-digit category code that can be specified for any purpose. This code can then be used to selectively extract specific assets from the Item Master. See User Defined Codes, system 12, code 21 to view and/or change values for this category code.
szCategoryCodeFA22	FA22	char	OPT	OUTPUT
A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/22 to view or change values for this category code.
szCategoryCodeFA23	FA23	char	OPT	OUTPUT
A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset Master. Use UDC 12/23 to view or change values for this category code.
szSerialTagNumber	ASID	char	OPT	OUTPUT
A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track assets by the manufacturer's serial number. You are not required to use a serial number to identify an asset. Every serial number that you enter must be unique.
szUnitNumber	APID	char	OPT	OUTPUT
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is typically the serial number.
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.

Related Functions

None

Related Tables

None