CC_CARD_TAG(SQL Table) |
Index Back |
|---|---|
ProCard Tags AssignmentDate Initials Ref# Description 29/08/2023 SS PSFTPO-13581 We ensured that to show legal name in EMPLID prompt as part of preferred name feature enhancement |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE |
| 2 | CREDIT_CARD_VENDOR |
Character(5) | VARCHAR2(5) NOT NULL |
Corporate Card Vendor
Prompt Table:
CC_EMPL_CCV_VW
|
| 3 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL |
Cardmember Number
Prompt Table:
CC_CARD_DATA_EX
|
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 5 | ACCOUNT_CODE |
Character(20) | VARCHAR2(20) NOT NULL |
Accounting Tag
Prompt Table: CC_TAG_SEL_DVW |
| 6 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit Default Value: N |