描述:发放给员工的信用卡信息
Primary Key: AP_CARDS_PK
- CARD_ID
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
AP_CARDS_ALL.PROFILE_ID | AP_CARD_PROFILES_ALL |
AP_CARDS_ALL.CARD_PROGRAM_ID | AP_CARD_PROGRAMS_ALL |
AP_CARDS_ALL.REQUEST_ID | FND_CONCURRENT_REQUESTS |
AP_CARDS_ALL.CARD_REFERENCE_ID | IBY_CREDITCARD |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
AP_CARD_DETAILS.CARD_ID | AP_CARDS_ALL |
AP_CARD_EMP_CANDIDATES.CARD_ID | AP_CARDS_ALL |
AP_CARD_REQUESTS_ALL.CARD_ID | AP_CARDS_ALL |
AP_CARD_SUPPLIERS_ALL.CARD_ID | AP_CARDS_ALL |
AP_CREDIT_CARD_TRXNS_ALL.CARD_ID | AP_CARDS_ALL |
AP_EXPENSE_FEED_LINES_ALL.CARD_ID | AP_CARDS_ALL |
Comments:
AP_CARDS_ALL存储由您的公司信用卡提供商发放给您的员工的公司信用卡信息。该表存储有关采购卡和员工用于旅行和娱乐的信用卡的信息。该表中的每条记录对应于发给员工的一张卡片。一张卡可由多名员工使用,但每张卡只能记录一名员工。根据存储在AP_CARD_PROFILES_ALL中的分配配置文件,限制每个员工发放卡的使用。