IBM SC23-8765-00 manual Purchview Table

Page 67

COLUMN	REQUIRED	MAXTYPE	LENGTH

NEWASSETSTATUS	0	ALN	20
ORGID	1	UPPER	8
PLUSRPROPERTYID	1	INTEGER	12
PLUSRPROPTRANSID	1	INTEGER	12
PLUSRTRANSACTIONID	1	INTEGER	12
PLUSRTRANSEXTSYSID	1	INTEGER	12
PROPERTYCLASS	0	UPPER	25
QUANTITY	1	DECIMAL	15
SITEID	1	UPPER	8
SOURCE	0	UPPER	25
TOPARENT	0	UPPER	12
TOPRICE	0	AMOUNT	10
TOPROPERTYID	0	INTEGER	12
TOSITE	0	UPPER	8
TOSTATUS	0	ALN	20
TOUII	0	ALN	100
TOUIIMARK	0	ALN	256
TRANSACTIONDATE	1	DATETIME	10
TRANSACTIONID	1	INTEGER	12
TRANSACTIONMEMO	0	ALN	254
TRANSACTIONMEMO_LONGDESCRIPTION	0	LONGALN	32000
TRANSACTIONNAME	1	UPPER	25
TRANSPERSONID	1	UPPER	30
USERPERSONID	0	UPPER	30

PURCHVIEW 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

Government Database Tables and Columns

57

Image 67

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