PeopleSoft 9 Asset Management |
Table Name | ALLOC_BASIS |
Table Description |
ALLOC_BASIS |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | No |
BASIS_ID | char(10) | Yes | No |
EFFDT | PSDATE | Yes | No |
DESCR | char(30) | No | No |
EFF_STATUS | char(1) | No | No |
TRANS_GRP | char(5) | No | No |
TOTAL_ALLOC_UNITS | decimal(13,2) | No | No |
ALLOC_TYPE_AM | char(3) | No | No |
UNIT_OF_MEASURE | char(3) | No | No |
SUM_ALLOC_UNITS | decimal(13,2) | No | No |
Index |
Name | Type | Unique | Member |
PS_ALLOC_BASIS | PK | Yes |
![]() |
Member(s) of "PS_ALLOC_BASIS" Index |
SETID |
BASIS_ID |
EFFDT |
Published December 16, 2006 |