PeopleSoft 9.0
Cash Management

Table Name POS_GEN_ENT_TBL

Table Description
POS_GEN_ENT_TBL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
POS_CATEGORY CHAR(20) Yes No
VALUE_DT PSDATE Yes No
REFERENCE CHAR(30) Yes No
SEQ_NBR DECIMAL(15) Yes No
BUSINESS_UNIT CHAR(5) No No
CURRENCY_CD CHAR(3) No No
AMOUNT DECIMAL(26,3) No No
BNK_ID_NBR CHAR(20) No No
BANK_ACCOUNT_NUM CHAR(17) No No
TREE_NAME CHAR(18) No No
SOURCE_SET CHAR(20) No No
DESCR50 CHAR(50) No No
DAYOFTHEWEEK CHAR(2) No No
MONTHCD CHAR(2) No No
DAYOFMONTH SMALLINT No No
OPRID CHAR(30) No No
DTTM_STAMP_SEC PSDATETIME No No
Index
Name Type Unique Member
PS_POS_GEN_ENT_TBL PK Yes
Member(s) of "PS_POS_GEN_ENT_TBL" Index
SETID
POS_CATEGORY
VALUE_DT
REFERENCE
SEQ_NBR

Published April 30, 2007