EMPLIDPrompt Table: PERSONAL_DATA
CREDIT_CARD_VENDORCRDMEM_ACCT_NBRPrompt Table:
CC_CARD_DATA_EX
Set Control Field: CREDIT_CARD_VENDOR
TRANS_NBRSEQUENCENOTRANS_DTLINE_NBRDTTM_STAMPDefault Value: %DATE
VCHR_CC_XREF(SQL Table) |
Index Back |
|---|---|
CC Trans/ Vchr Line XrefCross-Reference between Credit Card Transactions and Voucher Lines. |
| # | 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 |
Cardmember Number
Prompt Table:
CC_CARD_DATA_EX
|
| 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 11 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |