Pcard Proxies .us



CT_CORE_CC_CARD_PROXY

Purpose of Query

Pcard Proxies - All proxies for all pcards within an agency.

Folder

PCARD

Tables

A.CTW_PCD_RQSTHDR - P-Card Requestor Header Stg

B.CTW_PCD_CRDXREF - P-Card Coordinator Xref Stg

C.CTW_CC_CARDROLE - P-Card MasterCard Role Stg

D.CTW_PERSONAL_FN - Financial EE Personal Data

Prompts

:1 = BUSINESS_UNIT - Business Unit=

Sample results:

Please note, due to page size limitations, sample results may be incomplete.

[pic].

Criteria

Note: Runtime prompts are included as criteria.

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.BUSINESS_UNIT - Business Unit |Char5 | | | |Business Unit |

|2 |A.DEPTID - Department |Char10 |  |  |  |DeptID |

|3 |A.REQUEST_ID - Request ID |Char10 |  |  |  |Request ID |

|4 |A.EMPLID - Empl ID |Char11 |  |  |  |Employee ID |

|5 |D.NAME - Name |Char50 |  |  |  |Name |

|6 |B.CT_CC_CARD_LIST - Procurement Card Number |Char4 |  |  |  |Card Number |

|7 |A.CT_PCD_STATUS - PCard Status |Char1 |  |L |  |Status |

|8 |C.OPRID - User ID |Char30 |  |  |  |User |

|9 |A.MERCHANT_REF - Reference Number |Char30 |  |  |  |Merchant Reference |

|10 |C.ROLENAME - Role Name |Char30 |  |  |  |Role Name |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download