IBM SC23-8765-00 manual Plusrvheader Table, Plusrvproperty Table

Page 65

COLUMN	REQUIRED	MAXTYPE	LENGTH

TRANSPERSONID	1	UPPER	30
UPLOADFILEID	1	INTEGER	12

PLUSRVHEADER Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

EMAIL	0	ALN	50
INDUSTRYFLAG	1	ALN	1
NAME	1	UPPER	30
ORGANIZATION	1	UPPER	20
PHONE	1	ALN	20
RECORDCOUNT	0	INTEGER	12
REPORTNUM	1	UPPER	12
REPORTNUMNP	0	UPPER	12

PLUSRVPROPERTY Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

ASSETNUM	0	UPPER	12
CONTRACTNUM	0	UPPER	8
CONTRACTOR	0	UPPER	12
CUSTODIANPERSONID	0	UPPER	30
EXTERNALSYSTEM	0	UPPER	25
FILEFORMAT	0	UPPER	25
ITEMNUM	0	UPPER	30
ITEMSETID	0	UPPER	8
LOCATION	0	UPPER	12
ORGID	1	UPPER	8
PRICE	0	AMOUNT	10
PROPERTYCLASS	0	UPPER	25
QUANTITY	0	DECIMAL	15
SITEID	0	UPPER	8
SOURCE	0	UPPER	25
TOCONTRACT	0	UPPER	8

Government Database Tables and Columns

55

Image 65

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 Government Applications in the Assets Module Assets ModuleAssets Gv Application Add Property Record Assets Gv ActionsCapture UIIs Property TabLocations Gv Application Locations Gv Actions Create Property Upload Files Locations Gv Application Government Application in the Contracts Module Contracts ModuleGovernment Contracts Gv Application Contract Tab Contract TabProperties Tab Terms and Conditions Tab Contract Lines TabProperty Summary Tab Property TabGovernment Contracts Gv Actions Government Applications in the Inventory Module Inventory one Module5Inventory Tab Inventory Gv ApplicationInventory Gv Actions Item Master Gv Application Item Tab Item Master Gv ActionsIssue Tab Issues and Transfers Gv ApplicationIssue Tab Transfer Out Tab Transfer Out TabTransfer In Tab Transfer In Tab Issues and Transfers Gv ActionsStorerooms Gv Application Storerooms Gv Actions Government Application in the Personal Property Gv Module Personal Property Gv ModulePersonal Property Gv Application Personal Property Gv Actions View Property Transaction Reports Minus Property TransactionCreate Property Transaction Reports Run Property Transaction Reports Edit Property Transaction ReportsGovernment Applications in the Purchasing Module Purchasing ModuleCompanies Gv Application Company Tab Company TabCompanies Gv Actions Receiving Gv ApplicationMaterial Receipts Tab Receiving ActionsAssign / Mark UIIs Receiving Gv Application Government Application in the Resources Module Resources ModulePeople Gv Application People Gv Actions Assetcust Table Government Database Tables and ColumnsAsset Table Contract Table Companies TableContractline Table Issuecurrentitem TableInventory Table Item TableLeaseview Table Laborview TableMatrectrans Table Leaseviewline TableMasterview 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 TablePlusruploadtrans Table Plusrupload TablePlusruploadfile 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