IBM SC23-8765-00 manual Government Database Tables and Columns, Asset Table, Assetcust Table

Page 49

Government Database	9
Government Database
Tables and Columns

This chapter lists Government-specific database tables and their columns. It also lists Government-specific columns added to existing Maximo database tables.

ASSET Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRUII	0	ALN	100
PLUSRUIIAFFIXDATE	0	DATETIME	10
PLUSRUIIAFFIXED	1	YORN	1
PLUSRUIIAFFIXEDBY	0	UPPER	30
PLUSRUIIASSETUID	0	UPPER	30
PLUSRUIIBAGGTAGG	0	UPPER	1
PLUSRUIIEID	0	UPPER	25
PLUSRUIIIAC	0	UPPER	25
PLUSRUIILOTBATCH	0	UPPER	30
PLUSRUIIMARK	0	ALN	256
PLUSRUIIORIITEMNUM	0	UPPER	30
PLUSRUIIRENDERDATE	0	DATETIME	10
PLUSRUIIRENDERED	1	YORN	1
PLUSRUIIRENDEREDBY	0	UPPER	30
PLUSRUIIREQUIRED	1	YORN	1
PLUSRUIITEMPLATE	0	UPPER	25
PLUSRUIITYPE	0	UPPER	25

ASSETCUST Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRUII	0	ALN	100
PLUSRUIIAFFIXDATE	0	DATETIME	10
PLUSRUIIAFFIXED	1	YORN	1
PLUSRUIIAFFIXEDBY	0	UPPER	30

© Copyright IBM Corp. 2007

39

Image 49

Contents Maximo User’s Guide Addendum Page Contents Inventory Module Resources Module IBM Maximo for Government Maximo User’s Guide Addendum Intended Audience About This PublicationRelated Information Document DescriptionIBM Support About This Publication IBM Support Government-specific Functions Government FeaturesApplication Government-specific Functions Government Features IBM Maximo for Government Maximo User’s Guide Addendum Government Application in the Administration Module Administration ModuleOrganizations Gv Application TabsUII Templates Property Transaction DefinitionsProperty Transaction Definitions Dialog Box UII Templates Dialog BoxGovernment Defaults Dialog Box Government DefaultsOrganizations Gv Application Assets Gv Application Assets ModuleGovernment Applications in the Assets Module Add Property Record Assets Gv ActionsCapture UIIs Property TabLocations Gv Application Locations Gv Actions Create Property Upload Files Locations Gv Application Government Contracts Gv Application Contracts ModuleGovernment Application in the Contracts Module Properties Tab Contract TabContract Tab Terms and Conditions Tab Contract Lines TabProperty Summary Tab Property TabGovernment Contracts Gv Actions Government Applications in the Inventory Module Inventory one Module5Inventory Gv Actions Inventory Gv ApplicationInventory Tab Item Master Gv Application Item Tab Item Master Gv ActionsIssue Tab Issues and Transfers Gv ApplicationIssue Tab Transfer In Tab Transfer Out TabTransfer Out Tab Storerooms Gv Application Issues and Transfers Gv ActionsTransfer In Tab Storerooms Gv Actions Personal Property Gv Application Personal Property Gv ModuleGovernment Application in the Personal Property Gv Module Personal Property Gv Actions Create Property Transaction Reports Minus Property TransactionView Property Transaction Reports Run Property Transaction Reports Edit Property Transaction ReportsCompanies Gv Application Purchasing ModuleGovernment Applications in the Purchasing Module Company Tab Company TabCompanies Gv Actions Receiving Gv ApplicationMaterial Receipts Tab Receiving ActionsAssign / Mark UIIs Receiving Gv Application People Gv Application Resources ModuleGovernment Application in the Resources Module People Gv Actions Asset Table Government Database Tables and ColumnsAssetcust Table Contract Table Companies TableContractline Table Issuecurrentitem TableInventory Table Item TableLeaseview Table Laborview TableMasterview Table Leaseviewline TableMatrectrans Table Maxvarinput Table Matusetrans TablePlusrcontsumhead Table Plusrcontsummary TablePlusrformtrans Table Plusrform TablePlusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrproperty Table Plusrheader TablePlusrproptrans Table Fromuiimark ALN Touiimark ALN Plusrtransextsys Table Plusrtransaction TablePlusrtransform Table Plusruiitemplate TablePlusruploadfile Table Plusrupload TablePlusruploadtrans Table Plusrvproperty Table Plusrvheader TablePlusrvupload Table Purchview Table Toolinv Table Serviceitems TableToolitem Table Transfercuritem TableWarrantyviewline Table Warrantyview TableIBM Maximo for Government Maximo User’s Guide Addendum Copyright IBM Corp IBM Maximo for Government Maximo User’s Guide Addendum IBM AIX TrademarksIBM Maximo for Government Maximo User’s Guide Addendum