PeopleSoft 9
Account Payables

Table Name PYCYCL_PRENOTE

Table Description
PYCYCL_PRENOTE
Columns
Name Datatype Is PK Is FK
SOURCE_TXN VARCHAR(4) Yes Yes
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
REMIT_SETID VARCHAR(5) Yes No
REMIT_VENDOR VARCHAR(10) Yes No
VNDR_LOC VARCHAR(10) Yes No
EMPLID VARCHAR(11) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
BANK_SETID VARCHAR(5) No No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
REMIT_BANK_SETID VARCHAR(5) No No
REMIT_BANK_CD VARCHAR(5) No No
REMIT_BNK_ACCT_KEY VARCHAR(4) No No
PYMNT_METHOD VARCHAR(3) No No
PRENOTE_DATE PSDATE No No
PRENOTE_REQD VARCHAR(1) No No
PRENOTE_WAIT_DAYS SMALLINT No No
EFT_PYMNT_FMT_CD VARCHAR(3) No No
EFT_RTNG_FLG VARCHAR(1) No No
EFT_RTNG_STATUS VARCHAR(1) No No
EFT_TRANS_HANDLING VARCHAR(1) No No
EFT_DOM_COSTS_CD VARCHAR(1) No No
EFT_CORR_COSTS_CD VARCHAR(1) No No
EFT_CROSSED_CHECK VARCHAR(1) No No
EFT_CHECK_FWRD_CD VARCHAR(1) No No
EFT_CHECK_DRAW_CD VARCHAR(1) No No
EFT_PAY_INST_CD1 VARCHAR(3) No No
EFT_PAY_INST_CD2 VARCHAR(3) No No
EFT_PAY_INST_CD3 VARCHAR(3) No No
EFT_PAY_INST_CD4 VARCHAR(3) No No
EFT_PAY_INST_REF1 VARCHAR(40) No No
EFT_PAY_INST_REF2 VARCHAR(40) No No
Index
Name Type Unique Member
PS_PYCYCL_PRENOTE PK Yes
Member(s) of "PS_PYCYCL_PRENOTE" Index
SOURCE_TXN
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
REMIT_SETID
REMIT_VENDOR
VNDR_LOC
EMPLID
EFFDT

Published June 06, 2007