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 |