PeopleSoft 9
Account Payables

Table Name PYFRCST_LEDGER

Table Description
PYFRCST_LEDGER
Columns
Name Datatype Is PK Is FK
PYFRCST_CYCLE_ID VARCHAR(5) Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes No
BANK_ACCT_KEY VARCHAR(4) Yes No
VENDOR_SETID VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes No
PYMNT_METHOD VARCHAR(3) Yes No
SCHEDULED_PAY_DT PSDATE Yes No
PYFRCST_REC_TYPE VARCHAR(1) Yes No
VOUCHER_ID VARCHAR(8) Yes Yes
PYMNT_CNT int Yes Yes
INVOICE_ID VARCHAR(30) No No
INVOICE_DT PSDATE No No
TXN_CURRENCY_CD VARCHAR(3) No No
CURRENCY_PYMNT VARCHAR(3) No No
PYMNT_AMT decimal(26,3) No No
PYFRCST_AGE_BUCKET SMALLINT No No
Index
Name Type Unique Member
PS_PYFRCST_LEDGER PK Yes
Member(s) of "PS_PYFRCST_LEDGER" Index
PYFRCST_CYCLE_ID
BUSINESS_UNIT
BANK_SETID
BANK_CD
BANK_ACCT_KEY
VENDOR_SETID
VENDOR_ID
PYMNT_METHOD
SCHEDULED_PAY_DT
PYFRCST_REC_TYPE
VOUCHER_ID
PYMNT_CNT

Published June 06, 2007