IBM SC23-8765-00 manual FOB ALN Freightterms Freighttermslongdescription Longaln

Page 57

COLUMN	REQUIRED	MAXTYPE	LENGTH

FOB	0	ALN	20
FREIGHTTERMS	0	ALN	50
FREIGHTTERMS_LONGDESCRIPTION	0	LONGALN	32000
HASINSURANCE	1	YORN	1
HASLD	1	YORN	1
HISTORYFLAG	1	YORN	1
INCLUDESMAINT	1	YORN	1
INCLUSIVE1	1	YORN	1
INCLUSIVE2	1	YORN	1
INCLUSIVE3	1	YORN	1
INCLUSIVE4	1	YORN	1
INCLUSIVE5	1	YORN	1
INSPECTIONREQUIRED	1	YORN	1
INSURANCEEXPDATE	0	DATE	4
INSURANCEREQ	1	YORN	1
INTERIMCHG	0	AMOUNT	10
LANGCODE	1	UPPER	4
LASTSCHEDULEDATE	0	DATE	4
LEASERATEFACTOR	0	DECIMAL	10
LEASESUSPACCT	0	GL	23
LINESTATUS	0	UPPER	12
MAINTHIERCHY	1	YORN	1
MASTERNUM	0	UPPER	8
MASTERREVNUM	0	INTEGER	12
NOTIFYCONTACT	0	ALN	50
NOTIFYONMOVE	1	YORN	1
NP_STATUSMEMO	0	ALN	50
NUMOFPAYMENTS	0	INTEGER	12
ORGID	0	UPPER	8
OUTSIDEMAINT	1	YORN	1
OWNERSYSID	0	ALN	10
PAYMENTSCHED	1	YORN	1
PAYMENTTERMS	0	ALN	20

Government Database Tables and Columns

47

Image 57

Contents Maximo User’s Guide Addendum Page Contents Inventory Module Resources Module IBM Maximo for Government Maximo User’s Guide Addendum Intended Audience About This PublicationRelated Information Document DescriptionIBM 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 Government Application in the Administration Module Administration ModuleOrganizations Gv Application TabsUII Templates Property Transaction DefinitionsProperty Transaction Definitions Dialog Box UII Templates Dialog BoxGovernment Defaults Dialog Box Government DefaultsOrganizations Gv Application Assets Module Assets Gv ApplicationGovernment Applications in the Assets Module Add Property Record Assets Gv ActionsCapture UIIs 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 Terms and Conditions Tab Contract Lines TabProperty Summary Tab Property 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 TableContractline Table Issuecurrentitem TableInventory Table Item TableLeaseview Table Laborview TableLeaseviewline Table Masterview TableMatrectrans Table Maxvarinput Table Matusetrans TablePlusrcontsumhead Table Plusrcontsummary TablePlusrformtrans Table Plusrform TablePlusrgovcontract Table FOB ALN Freightterms Freighttermslongdescription Longaln Revcommentslongdescription Longaln Plusrproperty Table Plusrheader TablePlusrproptrans Table Fromuiimark ALN Touiimark ALN Plusrtransextsys Table Plusrtransaction TablePlusrtransform Table Plusruiitemplate TablePlusrupload Table Plusruploadfile TablePlusruploadtrans Table Plusrvproperty Table Plusrvheader TablePlusrvupload Table Purchview Table Toolinv Table Serviceitems TableToolitem Table Transfercuritem 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