Contractline Table, Inventory Table, Item Table | IBM SC23-8765-00

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRPROPERTYADMIN	0	UPPER	30
PLUSRSCHEDENDDATE	0	DATE	4

CONTRACTLINE Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRCLIN	0	UPPER	12

INVENTORY Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRGOVBALANCE	1	DECIMAL	15

ISSUECURRENTITEM Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRCONTRACTNUM	0	UPPER	8
PLUSRCUSTODIANPERSONID	0	UPPER	30
PLUSRPROPERTYCLASS	0	UPPER	25
PLUSRSOURCE	0	UPPER	25
PLUSRTOCUSTODIANPERSONID	0	UPPER	30
PLUSRTOUSERPERSONID	0	UPPER	30
PLUSRUSERPERSONID	0	UPPER	30

ITEM Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

PLUSRACQCOST	0	DECIMAL	15
PLUSRNSN	0	UPPER	20
PLUSRPROPERTYCLASS	0	UPPER	25

Government Database Tables and Columns

41

Image 51

IBM SC23-8765-00 manual Contractline Table, Inventory Table, Issuecurrentitem Table, Item Table

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 Information IBM Support About This Publication IBM Support Government-specific Functions Government Features Application Government-specific Functions Government Features IBM Maximo for Government Maximo User’s Guide Addendum Tabs Administration ModuleGovernment Application in the Administration Module Organizations Gv Application UII Templates Dialog Box Property Transaction DefinitionsUII Templates Property Transaction Definitions Dialog Box Government Defaults Dialog Box Government Defaults Organizations Gv Application Assets Module Assets Gv ApplicationGovernment Applications in the Assets Module Property Tab Assets Gv ActionsAdd Property Record Capture UIIs Locations Gv Application Locations Gv Actions Create Property Upload Files Locations Gv Application Contracts Module Government Contracts Gv ApplicationGovernment Application in the Contracts Module Contract Tab Properties TabContract Tab Property Tab Contract Lines TabTerms and Conditions Tab Property Summary Tab Government Contracts Gv Actions Government Applications in the Inventory Module Inventory one Module5 Inventory Gv Application Inventory Gv ActionsInventory Tab Item Master Gv Application Item Tab Item Master Gv Actions Issues and Transfers Gv Application Issue TabIssue Tab Transfer Out Tab Transfer In TabTransfer Out Tab Issues and Transfers Gv Actions Storerooms Gv ApplicationTransfer In Tab Storerooms Gv Actions Personal Property Gv Module Personal Property Gv ApplicationGovernment Application in the Personal Property Gv Module Personal Property Gv Actions Minus Property Transaction Create Property Transaction ReportsView Property Transaction Reports Run Property Transaction Reports Edit Property Transaction Reports Purchasing Module Companies Gv ApplicationGovernment Applications in the Purchasing Module Company Tab Company Tab Companies Gv Actions Receiving Gv Application Material Receipts Tab Receiving Actions Assign / Mark UIIs Receiving Gv Application Resources Module People Gv ApplicationGovernment Application in the Resources Module People Gv Actions Government Database Tables and Columns Asset TableAssetcust Table Contract Table Companies Table Item Table Issuecurrentitem TableContractline Table Inventory Table Leaseview Table Laborview Table Leaseviewline Table Masterview TableMatrectrans Table Plusrcontsummary Table Matusetrans TableMaxvarinput Table Plusrcontsumhead Table Plusrformtrans Table Plusrform Table Plusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrproperty Table Plusrheader Table Plusrproptrans Table Fromuiimark ALN Touiimark ALN Plusruiitemplate Table Plusrtransaction TablePlusrtransextsys Table Plusrtransform Table Plusrupload Table Plusruploadfile TablePlusruploadtrans Table Plusrvproperty Table Plusrvheader Table Plusrvupload Table Purchview Table Transfercuritem Table Serviceitems TableToolinv Table Toolitem Table Warrantyviewline Table Warrantyview Table IBM Maximo for Government Maximo User’s Guide Addendum Copyright IBM Corp IBM Maximo for Government Maximo User’s Guide Addendum IBM AIX Trademarks IBM Maximo for Government Maximo User’s Guide Addendum