IBM SC23-8765-00 manual Plusrvupload Table

Page 66

COLUMN	REQUIRED	MAXTYPE	LENGTH

TOCUSTODIAN	0	UPPER	30
TOUSER	0	UPPER	30
TRANSACTIONDATE	0	DATETIME	10
TRANSACTIONMEMO	0	ALN	254
TRANSACTIONMEMO_LONGDESCRIPTION	0	LONGALN	32000
TRANSACTIONNAME	0	UPPER	25
USERPERSONID	0	UPPER	30

PLUSRVUPLOAD Table

COLUMN	REQUIRED	MAXTYPE	LENGTH

ASSETNUM	0	UPPER	12
CONTRACTNUM	0	UPPER	8
CUSTODIANPERSONID	0	UPPER	30
EXTERNALSYSTEM	1	UPPER	25
FILEFORMAT	1	UPPER	25
FROMPARENT	0	UPPER	12
FROMPRICE	0	AMOUNT	10
FROMPROPERTYID	0	INTEGER	12
FROMSITE	0	UPPER	8
FROMSTATUS	0	ALN	20
FROMUII	0	ALN	100
FROMUIIMARK	0	ALN	256
HASLD	1	YORN	1
ITEMNUM	1	UPPER	30
ITEMSETID	1	UPPER	8
LANGCODE	1	UPPER	4
LOCATION	0	UPPER	12
MATRECTRANSID	0	INTEGER	12
MATUSETRANSID	0	INTEGER	12
MINUSDATE	0	DATETIME	10
MINUSMEMO	0	ALN	254
MINUSMEMO_LONGDESCRIPTION	0	LONGALN	32000
MINUSPERSONID	0	UPPER	30

56	IBM Maximo for Government: Maximo User’s Guide Addendum

Image 66

Contents Maximo User’s Guide Addendum Page Contents Inventory Module Resources Module IBM Maximo for Government Maximo User’s Guide Addendum Related Information About This PublicationIntended Audience Document DescriptionIBM Support About This Publication IBM Support Government Features Government-specific FunctionsApplication Government-specific Functions Government Features IBM Maximo for Government Maximo User’s Guide Addendum Organizations Gv Application Administration ModuleGovernment Application in the Administration Module TabsProperty Transaction Definitions Dialog Box Property Transaction DefinitionsUII Templates UII Templates Dialog BoxGovernment Defaults Government Defaults Dialog BoxOrganizations Gv Application Assets Module Assets Gv ApplicationGovernment Applications in the Assets Module Capture UIIs Assets Gv ActionsAdd Property Record Property TabLocations 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 Summary Tab Contract Lines TabTerms and Conditions Tab Property TabGovernment Contracts Gv Actions Inventory one Module5 Government Applications in the Inventory ModuleInventory Gv Application Inventory Gv ActionsInventory Tab Item Master Gv Application Item Master Gv Actions Item TabIssues 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 Edit Property Transaction Reports Run Property Transaction ReportsPurchasing Module Companies Gv ApplicationGovernment Applications in the Purchasing Module Company Tab Company TabReceiving Gv Application Companies Gv ActionsReceiving Actions Material Receipts TabAssign / 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 Companies Table Contract TableInventory Table Issuecurrentitem TableContractline Table Item TableLaborview Table Leaseview TableLeaseviewline Table Masterview TableMatrectrans Table Plusrcontsumhead Table Matusetrans TableMaxvarinput Table Plusrcontsummary TablePlusrform Table Plusrformtrans TablePlusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrheader Table Plusrproperty TablePlusrproptrans Table Fromuiimark ALN Touiimark ALN Plusrtransform Table Plusrtransaction TablePlusrtransextsys Table Plusruiitemplate TablePlusrupload Table Plusruploadfile TablePlusruploadtrans Table Plusrvheader Table Plusrvproperty TablePlusrvupload Table Purchview Table Toolitem Table Serviceitems TableToolinv Table Transfercuritem TableWarrantyview Table Warrantyviewline TableIBM Maximo for Government Maximo User’s Guide Addendum Copyright IBM Corp IBM Maximo for Government Maximo User’s Guide Addendum Trademarks IBM AIXIBM Maximo for Government Maximo User’s Guide Addendum