CC_TRANS_LD1_VW

(SQL View)
Index Back

SELECT A.CREDIT_CARD_VENDOR , A.BILLING_DATE , A.CC_STATUS , A.EMPLID , A.CRDMEM_ACCT_NBR , B.CRDMEM_ACCT_MSK , A.TRANS_DT , A.TRANS_NBR , A.SEQUENCENO , A.LINE_NBR , A.MERCHANT , A.CURRENCY_CD , A.CC_STATUS , A.BUSINESS_UNIT_AP , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.MERCHANDISE_AMT FROM PS_CC_TRANS_LINE A , PS_CC_CARD_MSK B WHERE A.CRDMEM_ACCT_NBR = B.CRDMEM_ACCT_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor

Prompt Table: CC_CARD_TBL_VW

2 BILLING_DATE Date(10) DATE NOT NULL Billing Date

Prompt Table: CC_BILLDATE1_VW

3 CC_STATUS0 Character(1) VARCHAR2(1) NOT NULL This field is used for prompting
0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=All Trans
6=Not Closed
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

5 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number

Prompt Table: CC_CARD_DATA_EX
Set Control Field: CREDIT_CARD_VENDOR

6 CRDMEM_ACCT_MSK Character(20) VARCHAR2(20) NOT NULL Cardmember Number
7 TRANS_DT Date(10) DATE NOT NULL Transaction Date
8 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
9 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

13 CC_STATUS Character(1) VARCHAR2(1) NOT NULL Statement Status
0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=Error
6=Processing
14 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
15 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
16 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
17 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label