CC_TRANS_SRCHVW(SQL View) |
Index Back |
|---|---|
ProCard Trans. Statements |
| SELECT A.EMPLID , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , A.TRANS_NBR , A.SEQUENCENO , A.TRANS_DT , A.LINE_NBR , A.DTTM_STAMP , A.POST_DT , A.BILLING_DATE , A.CC_STATUS , A.MERCHANT , A.CHARGE_CATEGORY , A.BUSINESS_UNIT , B.CRDMEM_ACCT_MSK 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 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | CREDIT_CARD_VENDOR |
Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 3 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL | Card Number |
| 4 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 5 | SEQUENCENO |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 6 | TRANS_DT |
Date(10) | DATE NOT NULL | Transaction Date |
| 7 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 8 | DTTM_STAMP |
DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %DATE |
| 9 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
| 10 | BILLING_DATE | Date(10) | DATE | Billing Date |
| 11 | CC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Statement Status
0=Staged 1=Initial 2=Verified 3=Approved 4=Closed 5=Error 6=Processing |
| 12 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 13 | CHARGE_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Charge Type
1=New Charge 2=Other Debits 4=Payment 5=Other Credits |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 15 | CRDMEM_ACCT_MSK | Character(20) | VARCHAR2(20) NOT NULL | Cardmember Number |