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