PeopleSoft 9
Account Payables

Table Name PYCYCL_RST_TBL

Table Description
PYCYCL_RST_TBL
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
SOURCE_TXN VARCHAR(4) Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
PAY_DOC_ID VARCHAR(20) Yes Yes
PAY_DOC_SEQ int Yes Yes
PYCYCL_KEY_FIELD1 VARCHAR(20) Yes Yes
PYCYCL_KEY_FIELD2 PSDATE Yes Yes
PYCYCL_KEY_FIELD3 decimal(15) Yes Yes
PAY_DOC_DT PSDATE No No
DUE_DT PSDATE No No
DSCNT_DUE_DT PSDATE No No
SCHEDULED_PAY_DT PSDATE No No
PYMNT_GROSS_AMT decimal(26,3) No No
GROSS_AMT_BSE decimal(26,3) No No
DSCNT_PAY_AMT decimal(26,3) No No
PYMNT_METHOD VARCHAR(3) No No
PYMNT_MESSAGE VARCHAR(70) No No
PYMNT_SEPARATE VARCHAR(1) No No
PYMNT_HANDLING_CD VARCHAR(2) No No
BASE_CURRENCY VARCHAR(3) No No
TXN_CURRENCY_CD VARCHAR(3) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
CUR_RT_TYPE VARCHAR(5) No No
PYMNT_SELCT_STATUS VARCHAR(1) No No
BANK_SETID VARCHAR(5) No No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
PYMNT_GROUP_CD VARCHAR(2) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
PAID_AMT decimal(26,3) No No
PAID_AMT_BSE decimal(26,3) No No
PAID_AMT_GROSS decimal(26,3) No No
PAID_AMT_DSCNT decimal(26,3) No No
PAID_AMT_GROSS_BSE decimal(26,3) No No
PAID_AMT_DSCNT_BSE decimal(26,3) No No
PAID_AMT_BNK_BSE decimal(26,3) No No
CURRENCY_PYMNT VARCHAR(3) No No
CUR_RT_TYPE_PYMNT VARCHAR(5) No No
PYMNT_RATE_MULT decimal(15,8) No No
PYMNT_RATE_DIV decimal(15,8) No No
BASE_CURRENCY_BNK VARCHAR(3) No No
CUR_RT_TYPE_BNK VARCHAR(5) No No
BNK_RATE_MULT decimal(15,8) No No
BNK_RATE_DIV decimal(15,8) No No
PYMNT_ID VARCHAR(10) No No
VOUCHER_ID VARCHAR(8) No No
INVOICE_ID VARCHAR(30) No No
REMIT_SETID VARCHAR(5) No No
REMIT_VENDOR VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
BANK_ACCT_SEQ_NBR SMALLINT No No
ADDRESS_SEQ_NUM INT No No
VENDOR_NAME_SHORT VARCHAR(14) No No
GRP_AP_ID VARCHAR(10) No No
EMPLID VARCHAR(11) No No
STTLMNT_DT_EST PSDATE No No
ACCOUNTING_DT PSDATE No No
PYMNT_DT PSDATE No No
PREFERRED_LANGUAGE VARCHAR(3) No No
REMIT_BANK_SETID VARCHAR(5) No No
REMIT_BANK_CD VARCHAR(5) No No
REMIT_BNK_ACCT_KEY VARCHAR(4) 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
NAME1_AC VARCHAR(40) No No
NAME2_AC VARCHAR(40) No No
VNDR_SERVICE_TYPE VARCHAR(3) No No
DOC_TYPE VARCHAR(8) No No
DOC_SEQ_DATE PSDATE No No
DOC_SEQ_NBR VARCHAR(12) No No
DOC_SEQ_STATUS VARCHAR(1) No No
PYCYCL_FIELD1 VARCHAR(10) No No
PYCYCL_FIELD2 VARCHAR(10) No No
PYCYCL_FIELD3 VARCHAR(10) No No
PYCYCL_FIELD4 VARCHAR(10) No No
PYCYCL_FIELD5 VARCHAR(10) No No
PYCYCL_FIELD6 VARCHAR(10) No No
PYCYCL_FIELD7 VARCHAR(10) No No
PYCYCL_FIELD8 VARCHAR(10) No No
PYCYCL_FIELD9 VARCHAR(10) No No
PYCYCL_FIELD10 VARCHAR(10) No No
PRENOTE_STATUS VARCHAR(1) No No
DSCNT_AMT_BSE decimal(26,3) No No
HOL_PROC_OPT VARCHAR(1) No No
HOL_PROC_DAYS SMALLINT No No
HOL_PROC_OVERFL VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
GRP_PYMNT_DT VARCHAR(1) No No
WTHD_SW VARCHAR(1) No No
CUR_RT_TYPE_PAID VARCHAR(5) No No
PAID_RATE_MULT decimal(15,8) No No
PAID_RATE_DIV decimal(15,8) No No
SPEC_PYMNT_EX_RT VARCHAR(1) No No
DFT_SIGHT_CD VARCHAR(5) No Yes
DFT_MAT_DT PSDATE No No
DFT_SCHED_MAT_DT PSDATE No No
DFT_GROUP_CD VARCHAR(5) No No
DFT_MASTER_ID VARCHAR(10) No No
DFT_CREATE_KEY VARCHAR(10) No No
EFT_KEY_FIELD1 VARCHAR(5) No No
EFT_KEY_FIELD2 VARCHAR(12) No No
EFT_KEY_FIELD3 VARCHAR(10) No No
EFT_KEY_FIELD4 PSDATE No No
EFT_KEY_FIELD5 SMALLINT No No
EFT_KEY_FIELD6 SMALLINT No No
LC_ID VARCHAR(12) No No
PYMNT_REASON_CD VARCHAR(4) No No
SCHEDULE_ID VARCHAR(10) No No
LATE_CHRG_CD VARCHAR(4) No No
LATE_CHRG_OPT VARCHAR(1) No No
LATE_CHRG_AMT decimal(26,3) No No
LATE_CHRG_AMT_BSE decimal(26,3) No No
LATE_CHRG_PAID decimal(26,3) No No
LATE_CHRG_PAID_BSE decimal(26,3) No No
LATE_CHRG_DNIE decimal(26,3) No No
LATE_CHRG_DNIE_BSE decimal(26,3) No No
ECN_DSCNT_DNIE_FLG VARCHAR(1) No No
VOUCHER_ID_RELATED VARCHAR(8) No No
BUS_UNIT_RELATED VARCHAR(5) No No
PYMNT_CNT_RELATED int No No
APPL_CREDIT_STATUS VARCHAR(1) No No
PAY_SCHEDULE_TYPE VARCHAR(3) No No
PYMNT_SORT_CD SMALLINT No No
PYMNT_IMAGE_ID decimal(10) No No
SINGLE_PYMNT_FLG VARCHAR(1) No No
BANK_RPL_STATUS VARCHAR(1) No No
IPAC_PYMNT_FLG VARCHAR(1) No No
EFT_LAYOUT_CD VARCHAR(10) No No
STL_THROUGH VARCHAR(2) No No
INFO_ONLY_FLG VARCHAR(1) No No
EXCEPTION_FLAG VARCHAR(1) No No
REBATE_TERM_FLG VARCHAR(1) No No
REBATE_PERCENT decimal(11,8) No No
REBATE_MAX_PERCENT decimal(11,8) No No
DESCR254_MIXED VARCHAR(254) No No
Index
Name Type Unique Member
PS_PYCYCL_RST_TBL PK Yes
Member(s) of "PS_PYCYCL_RST_TBL" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
SOURCE_TXN
BUSINESS_UNIT
PAY_DOC_ID
PAY_DOC_SEQ
PYCYCL_KEY_FIELD1
PYCYCL_KEY_FIELD2
PYCYCL_KEY_FIELD3

Published June 06, 2007