IBM SC23-8765-00 manual Plusrform Table, Plusrformtrans Table

Page 55

COLUMN	REQUIRED	MAXTYPE	LENGTH

DELETIONS	1	DECIMAL	15
ENDINGACQCOST	1	DECIMAL	15
ENDINGQUANTITY	1	INTEGER	12
MISSINGUIIACQCOST	1	DECIMAL	15
MISSINGUIIQUANTITY	1	INTEGER	12
ORGID	1	UPPER	8
PLUSRCONTSUMMARYID	1	INTEGER	12
PROPERTYCLASS	1	UPPER	25

PLUSRFORM Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

CREATEDDATE	1	DATETIME	10
CREATEDPERSONID	1	UPPER	30
FILENAME	1	UPPER	25
FORMNAME	1	UPPER	25
ORGID	1	UPPER	8
PATHNAME	0	ALN	500
PLUSRFORMID	1	INTEGER	12
PROPERTYTRANSID	1	INTEGER	12
SITEID	1	UPPER	8

PLUSRFORMTRANS Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

EMAIL	0	ALN	100
FORMID	1	INTEGER	12
ORGID	1	UPPER	8
PLUSRFORMTRANSID	1	INTEGER	12
SITEID	1	UPPER	8
STATUS	1	UPPER	25
TRANSACTIONDATE	1	DATETIME	10
TRANSPERSONID	1	UPPER	30

Government Database Tables and Columns

45

Image 55

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 Gv Application Assets ModuleGovernment 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 Government Contracts Gv Application Contracts ModuleGovernment Application in the Contracts Module Properties Tab Contract 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 Actions Inventory Gv ApplicationInventory Tab Item Master Gv Application Item Tab Item Master Gv ActionsIssue Tab Issues and Transfers Gv ApplicationIssue Tab Transfer In Tab Transfer Out TabTransfer Out Tab Storerooms Gv Application Issues and Transfers Gv ActionsTransfer In Tab Storerooms Gv Actions Personal Property Gv Application Personal Property Gv ModuleGovernment Application in the Personal Property Gv Module Personal Property Gv Actions Create Property Transaction Reports Minus Property TransactionView Property Transaction Reports Run Property Transaction Reports Edit Property Transaction ReportsCompanies Gv Application Purchasing ModuleGovernment Applications in the Purchasing Module Company Tab Company TabCompanies Gv Actions Receiving Gv ApplicationMaterial Receipts Tab Receiving ActionsAssign / Mark UIIs Receiving Gv Application People Gv Application Resources ModuleGovernment Application in the Resources Module People Gv Actions Asset Table Government Database Tables and ColumnsAssetcust Table Contract Table Companies TableItem Table Issuecurrentitem TableContractline Table Inventory TableLeaseview Table Laborview TableMasterview Table Leaseviewline 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 TablePlusruploadfile Table Plusrupload 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