PeopleSoft 9 Asset Management |
Table Name | ASSET_MAINT |
Table Description |
ASSET_MAINT |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | Yes |
ASSET_ID | char(12) | Yes | Yes |
MAINT_DTTM | PSDATETIME | Yes | No |
MAINT_TYPE | char(10) | Yes | No |
MAINT_STATUS | char(1) | No | No |
RESPONSIBILITY | char(30) | No | No |
VENDOR_ID | char(10) | No | No |
CONTRACT_NUM | char(25) | No | No |
EST_DOWN_HOURS | DECIMAL(8,2) | No | No |
DOWN_HOURS | DECIMAL(8,2) | No | No |
EST_LABOR_HOURS | DECIMAL(8,2) | No | No |
EST_LABOR_COST | decimal(26,3) | No | No |
EST_MATERIALS_COST | decimal(26,3) | No | No |
EST_OTHER_COST | decimal(26,3) | No | No |
LABOR_COST | decimal(26,3) | No | No |
LABOR_HOURS | DECIMAL(8,2) | No | No |
MATERIALS_COST | decimal(26,3) | No | No |
OTHER_COST | decimal(26,3) | No | No |
INSPECTION_SW | char(1) | No | No |
WARRANTY_SW | char(1) | No | No |
PROBLEM_ID | char(15) | No | No |
OFFSITE_SW | char(1) | No | No |
READY_DTTM | PSDATETIME | No | No |
PICKUP_DT | PSDATE | No | No |
PICKUP_CONTACT | char(30) | No | No |
PO_ID | char(10) | No | No |
REFERENCE | char(30) | No | No |
VOUCHER_ID | char(8) | No | No |
INVOICE_DT | PSDATE | No | No |
INVOICE_ID | char(30) | No | No |
CURRENCY_CD | char(3) | No | No |
BUSINESS_UNIT_WO | char(5) | No | No |
WO_ID | char(10) | No | No |
WO_TASK_ID | int | No | No |
REPAIR_CODE | char(8) | No | No |
LOCATION | char(10) | No | No |
AREA_ID | CHAR(10) | No | No |
CUSTODIAN | char(30) | No | No |
EMPLID | char(11) | No | No |
DEPTID | char(10) | No | No |
TOOLS_COST | DECIMAL(26,3) | No | No |
EST_TOOLS_COST | DECIMAL(26,3) | No | No |
PURCH_COST | DECIMAL(26,3) | No | No |
EST_PURCH_COST | DECIMAL(26,3) | No | No |
COMMENTS | TEXT | No | No |
Index |
Name | Type | Unique | Member |
PS_ASSET_MAINT | PK | Yes |
![]() |
Member(s) of "PS_ASSET_MAINT" Index |
BUSINESS_UNIT |
ASSET_ID |
MAINT_DTTM |
MAINT_TYPE |
Published December 16, 2006 |