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

Page 51

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
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 Assets Module Assets Gv ApplicationGovernment Applications in the Assets Module Property Tab Assets Gv ActionsAdd Property Record Capture UIIsLocations 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 TabGovernment Contracts Gv Actions Government Applications in the Inventory Module Inventory one Module5Inventory Gv Application Inventory Gv ActionsInventory Tab Item Master Gv Application Item Tab Item Master Gv ActionsIssues 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 ReportsPurchasing Module Companies Gv ApplicationGovernment Applications in the Purchasing Module Company Tab Company TabCompanies Gv Actions Receiving Gv ApplicationMaterial Receipts Tab Receiving ActionsAssign / 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 TableItem Table Issuecurrentitem TableContractline Table Inventory TableLeaseview Table Laborview TableLeaseviewline Table Masterview TableMatrectrans 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 TablePlusrupload Table Plusruploadfile TablePlusruploadtrans 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