PO_PCL_CTLID_VW

(SQL View)
Index Back

PCL EIP CTL ID View


SELECT A.EIP_CTL_ID , B.EMPLID , B.CREDIT_CARD_VENDOR , B.CRDMEM_ACCT_NBR , B.TRANS_NBR , B.TRANS_DT FROM PS_EO_EIP_CTL A , PS_CC_TRANS_EC B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.EIP_PROGRAM = 'PROCARD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
4 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
5 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
6 TRANS_DT Date(10) DATE Transaction Date