PeopleSoft 9
Account Payables

Table Name PYCYCL

Table Description
PYCYCL
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes No
DESCR VARCHAR(30) No No
PAY_FROM_DT PSDATE No No
PAY_THRU_DT PSDATE No No
PYMNT_DT PSDATE No No
BUS_UNIT_SW VARCHAR(1) No No
ACCT_DT_OPTION VARCHAR(1) No No
ACCOUNTING_DT PSDATE No No
BANK_OVERRIDE_FLG VARCHAR(1) No No
VNDR_PAYGRP_FLG VARCHAR(1) No No
NEXT_PYMNT_DT PSDATE No No
NEXT_PAY_THRU_DT PSDATE No No
PRENOTE_CREATE_FLG VARCHAR(1) No No
CRYSTAL_CHECK_FLG VARCHAR(1) No No
BUS_DAY_EDT_CD VARCHAR(1) No No
HOLIDAY_LIST_ID VARCHAR(10) No Yes
EDT_PYMNT_DT VARCHAR(1) No No
EDT_PAY_THRU_DT VARCHAR(1) No No
DATE_INC_TYPE VARCHAR(1) No No
DATE_INC_SIZE SMALLINT No No
RSTRT_ALIGNMENTS SMALLINT No No
ZERO_PAYMENTS_FLG VARCHAR(1) No No
PREFERRED_LANG_FLG VARCHAR(1) No No
PREFERRED_LANGUAGE VARCHAR(3) No No
PAUSE_AFTER_SELECT VARCHAR(1) No No
WTHD_DT_OPTION VARCHAR(1) No No
WTHD_DATE PSDATE No No
INCLUDE_DISC_ALERT VARCHAR(1) No No
PRINT_LC_ADVICE VARCHAR(1) No No
IN_USE_SW VARCHAR(1) No No
EXPRESS_PYMNT_FLG VARCHAR(1) No No
NETTING_OPTION VARCHAR(1) No No
PROC_DFT_OPT VARCHAR(1) No No
DFT_OPT_DEF_FLG VARCHAR(1) No No
DFT_MAX_NUM SMALLINT No No
PROC_DFT_ROUND VARCHAR(1) No No
DFT_ROUND_DEF_FLG VARCHAR(1) No No
DFT_AMT_POS SMALLINT No No
DFT_REMAIN_OPT VARCHAR(1) No No
PYMNT_METHOD_ALT VARCHAR(3) No No
DFT_PAUSE VARCHAR(1) No No
DFT_PREAPPROVE VARCHAR(1) No No
BANK_CHARGE_OPT VARCHAR(1) No No
VALUE_DATE_OPT VARCHAR(1) No No
CREDIT_PROCESS_OPT VARCHAR(1) No No
HURDLE_RT_CALC_FLG VARCHAR(1) No No
GFAP_EFT_BULKEXPRY PSDATE No No
Index
Name Type Unique Member
PS_PYCYCL PK Yes
Member(s) of "PS_PYCYCL" Index
PAY_CYCLE

Published June 06, 2007