EMPLIDPrompt Table: PERSONAL_DATA
CREDIT_CARD_VENDORCRDMEM_ACCT_NBRTRANS_NBRSEQUENCENOTRANS_DTLINE_NBRDTTM_STAMPDefault Value: %DATE
CC_TRANS_MSK_VW(SQL View) |
Index Back |
|---|---|
ProCard Trans Mask View |
| 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 , 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 | CRDMEM_ACCT_MSK | Character(20) | VARCHAR2(20) NOT NULL | Cardmember Number |