IBM SC23-8765-00 manual Plusrheader Table, Plusrproperty Table

Page 59

COLUMN	REQUIRED	MAXTYPE	LENGTH

TOTALCOST	0	DECIMAL	10
TRANSFERWARRANTY	1	YORN	1
VENDNOTIFYPERIOD	0	INTEGER	12
VENDOR	0	UPPER	12
VENDORREFNUM	0	ALN	12
VENDTERMALLOWED	1	YORN	1
WARRANTYDURATION	0	INTEGER	12
WARRANTYSTART	0	DATE	4

PLUSRHEADER 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
PLUSRHEADERID	1	INTEGER	12
RECORDCOUNT	0	INTEGER	12
REPORTNUM	1	UPPER	12

PLUSRPROPERTY Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

ASSETNUM	0	UPPER	12
CONTRACTNUM	0	UPPER	8
CUSTODIANPERSONID	0	UPPER	30
EMAIL	0	ALN	100
EXTERNALSYSTEM	0	UPPER	25
FILEFORMAT	0	UPPER	25
FORMNAME	0	UPPER	25
ITEMNUM	1	UPPER	30
ITEMSETID	1	UPPER	8
LOCATION	0	UPPER	12

Government Database Tables and Columns

49

Image 59

Contents Maximo User’s Guide Addendum Page Contents Inventory Module Resources Module IBM Maximo for Government Maximo User’s Guide Addendum Document Description About This PublicationIntended Audience Related InformationIBM 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 Tabs Administration ModuleGovernment Application in the Administration Module Organizations Gv ApplicationUII Templates Dialog Box Property Transaction DefinitionsUII Templates Property Transaction Definitions Dialog BoxGovernment Defaults Dialog Box Government DefaultsOrganizations Gv Application Government Applications in the Assets Module Assets ModuleAssets Gv Application Property Tab Assets Gv ActionsAdd Property Record Capture UIIsLocations 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 Property Tab Contract Lines TabTerms and Conditions Tab Property Summary 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 TableItem Table Issuecurrentitem TableContractline Table Inventory TableLeaseview Table Laborview TableMatrectrans Table Leaseviewline TableMasterview Table Plusrcontsummary Table Matusetrans TableMaxvarinput Table Plusrcontsumhead TablePlusrformtrans Table Plusrform TablePlusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrproperty Table Plusrheader TablePlusrproptrans Table Fromuiimark ALN Touiimark ALN Plusruiitemplate Table Plusrtransaction TablePlusrtransextsys Table Plusrtransform TablePlusruploadtrans Table Plusrupload TablePlusruploadfile Table Plusrvproperty Table Plusrvheader TablePlusrvupload Table Purchview Table Transfercuritem Table Serviceitems TableToolinv Table Toolitem 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