EBS:AP_CREDIT_CARD_TRXNS_ALL

描述：雇员信用卡交易的详细信息

Primary Key: AP_CREDIT_CARD_TRXNS_PK

1. TRX_ID

Foreign Keys from this table:

Foreign Key Column	Foreign Table
AP_CREDIT_CARD_TRXNS_ALL.REPORT_HEADER_ID	AP_EXPENSE_REPORT_HEADERS_ALL
AP_CREDIT_CARD_TRXNS_ALL.REQUEST_ID	FND_CONCURRENT_REQUESTS
AP_CREDIT_CARD_TRXNS_ALL.LOCATION_ID	AP_EXP_LOCATIONS
AP_CREDIT_CARD_TRXNS_ALL.CARD_ACCEPTOR_ID	%
AP_CREDIT_CARD_TRXNS_ALL.CARD_ID	AP_CARDS_ALL

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_CC_TRX_DETAILS.TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
	AP_CREDIT_CARD_TRXNS_ALL
AP_EXPENSE_REPORT_LINES_ALL.CREDIT_CARD_TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.CREDIT_CARD_TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
AP_INVOICE_LINES_INTERFACE.CREDIT_CARD_TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
AP_NO_MATCH_TRXNS.TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
AP_NO_MATCH_TRXNS.NO_MATCH_TRX_ID	AP_CREDIT_CARD_TRXNS_ALL

Comments：

AP_CREDIT_CARD_TRXNS_ALL存储员工信用卡交易的详细信息。该表中的信息包括由商家在销售点捕获的交易数据，以及由您的信用卡提供商记录的数据。该表存储的信用卡交易代表公司(旅游)信用卡交易，而不是采购卡交易。该表对应于自助费用的信用卡交易窗口。