AR_CANDEB_SR_VW

(SQL View)
Index Back

SELECT A.SETID ,A.CREDITOR_ID1 ,A.EFFDT FROM PS_AR_CANC_DEBT_CR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CREDITOR_ID1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
3 EFFDT Date(10) DATE Effective Date

Default Value: %date