IBM SC23-8765-00 manual Leaseviewline Table, Masterview Table, Matrectrans Table

Page 53

LEASEVIEWLINE Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRCLIN	0	UPPER	12

MASTERVIEW Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRCAPRECEIPTS	1	YORN	1
PLUSRCONTRACTADMIN	0	UPPER	30
PLUSRCONTRACTOR	0	UPPER	12
PLUSRCONTRACTTYPE	0	UPPER	25
PLUSRCUSTOMER	0	UPPER	12
PLUSRGFPRECEIPTS	1	YORN	1
PLUSRPARCONTRACT	0	UPPER	8
PLUSRPARCONTRACTOR	0	UPPER	12
PLUSRPRICONTRACTOR	0	UPPER	12
PLUSRPRIMECONTRACT	0	UPPER	8
PLUSRPROPERTYADMIN	0	UPPER	30
PLUSRSCHEDENDDATE	0	DATE	4

MATRECTRANS Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRCONTRACTNUM	0	UPPER	8
PLUSRCUSTODIANPERSONID	0	UPPER	30
PLUSRPROPERTYCLASS	0	UPPER	25
PLUSRSOURCE	0	UPPER	25
PLUSRTOCUSTODIANID	0	UPPER	30
PLUSRTOUSERID	0	UPPER	30
PLUSRUSERPERSONID	0	UPPER	30

Government Database Tables and Columns

43

Image 53

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