PeopleSoft 9
Account Payables

Table Name APD_SIGHTCD_TBL

Table Description
APD_SIGHTCD_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
DFT_SIGHT_CD VARCHAR(5) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
DESCR50 VARCHAR(50) No No
DESCRSHORT VARCHAR(10) No No
BASIS_DATE_CD VARCHAR(1) No No
NMBR_DAY SMALLINT No No
NMBR_MTH SMALLINT No No
Index
Name Type Unique Member
PS_APD_SIGHTCD_TBL PK Yes
Member(s) of "PS_APD_SIGHTCD_TBL" Index
SETID
DFT_SIGHT_CD
EFFDT

Published June 06, 2007