PeopleSoft 9 Asset Management |
Table Name | ASSET_INSRNCE_H |
Table Description |
ASSET_INSRNCE_H |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | Yes |
ASSET_ID | char(12) | Yes | Yes |
POLICY_ID | char(50) | Yes | No |
INSURANCE_VNDR | char(10) | Yes | No |
BUSINESS_UNIT_AM | char(5) | No | No |
INSURANCE_TYPE | char(30) | No | Yes |
Index |
Name | Type | Unique | Member |
PS_ASSET_INSRNCE_H | PK | Yes |
![]() |
PS0ASSET_INSRNCE_H | IE1 | No |
![]() |
Member(s) of "PS_ASSET_INSRNCE_H" Index |
BUSINESS_UNIT |
ASSET_ID |
POLICY_ID |
INSURANCE_VNDR |
Member(s) of "PS0ASSET_INSRNCE_H" Index |
INSURANCE_TYPE |
BUSINESS_UNIT |
ASSET_ID |
POLICY_ID |
INSURANCE_VNDR |
Published December 16, 2006 |