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 |