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 |