[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_EXPENSE_FEED_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_EXPENSE_FEED_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_EXPENSE_FEED_LINES_ALL stores detailed
information about the procurement card transactions
incurred by your employees. This information includes
data captured by suppliers at the point of sale, and data
captured by the issuer of the procurement card. You
populate this table by importing the data files your
procurement card issuer sends you.
.
This table corresponds to the Procurement Card Transactions window.
Scope: public
Product: OIE
Lifecycle: active
Display Name: OIE Procurement Card Transactions
Category: BUSINESS_ENTITY OIE_PCARD_TRXN
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_EXPENSE_FEED_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FEED_LINE_ID
|
| AP_EXPENSE_FEED_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EMPLOYEE_ID
|
| AP_EXPENSE_FEED_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_ID
|
| AP_EXPENSE_FEED_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REFERENCE_NUMBER
|
| AP_EXPENSE_FEED_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EMPLOYEE_VERIFICATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EMPLOYEE_ID | NUMBER | (15) | Employee identifier | |
| CARD_ID | NUMBER | (15) | Credit card identifier | |
| CARD_PROGRAM_ID | NUMBER | (15) | Yes | Credit card program identifier |
| CARD_NUMBER | VARCHAR2 | (80) | Yes | Credit card number |
| FEED_LINE_ID | NUMBER | (15) | Yes | Feed line identifier |
| REFERENCE_NUMBER | VARCHAR2 | (240) | Reference or unique transaction number | |
| ALT_REFERENCE_NUMBER | VARCHAR2 | (240) | Alternate reference number | |
| CUSTOMER_CODE | VARCHAR2 | (240) | Customer code | |
| AMOUNT | NUMBER | Yes | Amount | |
| ORIGINAL_CURRENCY_AMOUNT | NUMBER | Original currency amount | ||
| ORIGINAL_CURRENCY_CODE | VARCHAR2 | (15) | Original currency code | |
| POSTED_CURRENCY_CODE | VARCHAR2 | (15) | Posted currency code | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| TRANSACTION_DATE | DATE | Transaction date | ||
| POSTED_DATE | DATE | Yes | Date transaction posted by credit card issuer | |
| RECORD_TYPE | VARCHAR2 | (25) | Record type | |
| CREATE_DISTRIBUTION_FLAG | VARCHAR2 | (1) | Create distribution flag | |
| MERCHANT_NAME | VARCHAR2 | (80) | Merchant name | |
| MERCHANT_NUMBER | VARCHAR2 | (80) | Merchant number | |
| CARD_CODE_VALUE | VARCHAR2 | (80) | Card code value | |
| CODE_ID | NUMBER | (15) | Code identifier | |
| INDUSTRY_CODE1 | VARCHAR2 | (80) | Industry code #1 | |
| INDUSTRY_CODE2 | VARCHAR2 | (80) | Industry code #2 | |
| ALT_MERCHANT_NUMBER | VARCHAR2 | (80) | Alternate merchant number | |
| MERCHANT_ADDRESS1 | VARCHAR2 | (35) | Merchant address #1 | |
| MERCHANT_ADDRESS2 | VARCHAR2 | (35) | Merchant address #2 | |
| MERCHANT_ADDRESS3 | VARCHAR2 | (35) | Merchant address #3 | |
| MERCHANT_ADDRESS4 | VARCHAR2 | (35) | Merchant address #4 | |
| MERCHANT_CITY | VARCHAR2 | (25) | Merchant city | |
| MERCHANT_PROVINCE_STATE | VARCHAR2 | (25) | Merchant province or state | |
| MERCHANT_POSTAL_CODE | VARCHAR2 | (20) | Merchant postal code | |
| MERCHANT_COUNTRY | VARCHAR2 | (25) | Merchant country | |
| MERCHANT_PHONE | VARCHAR2 | (25) | Merchant phone | |
| SHIP_FROM_POSTAL_CODE | VARCHAR2 | (25) | Ship from postal code | |
| SHIP_FROM_COUNTRY | VARCHAR2 | (25) | Ship from country | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (25) | Ship to postal code | |
| SHIP_TO_COUNTRY | VARCHAR2 | (25) | Ship to country | |
| MERCHANT_TAX_ID | VARCHAR2 | (80) | Merchant tax identifier | |
| TAX_PAID_FLAG | VARCHAR2 | (1) | Tax paid flag | |
| TAX_AMOUNT | NUMBER | Tax amount | ||
| TAX_RATE | NUMBER | Tax rate | ||
| TAX_TYPE | VARCHAR2 | (25) | Tax type | |
| ALT_MERCHANT_TAX_ID | VARCHAR2 | (80) | Alternate merchant tax identifier | |
| ALT_TAX_PAID_FLAG | VARCHAR2 | (1) | Alternate tax paid flag | |
| ALT_TAX_AMOUNT | NUMBER | Alternate tax amount | ||
| ALT_TAX_RATE | NUMBER | Alternate tax rate | ||
| ALT_TAX_TYPE | VARCHAR2 | (25) | Alternate tax type | |
| FREIGHT_AMOUNT | NUMBER | Freight amount | ||
| DUTY_AMOUNT | NUMBER | Duty amount | ||
| MERCHANT_BUSINESS_TYPE | VARCHAR2 | (80) | Merchant business type | |
| MERCHANT_OWNER_TYPE | VARCHAR2 | (80) | Merchant owner type | |
| PRODUCT_CODE | VARCHAR2 | (80) | Product code | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| ITEM_QUANTITY | NUMBER | Item quantity | ||
| ITEM_UOM | VARCHAR2 | (80) | Item unit of measure | |
| EXTENDED_ITEM_AMOUNT | NUMBER | Extended item amount | ||
| DISCOUNT_INDICATOR | VARCHAR2 | (1) | Discount indicator | |
| DISCOUNT_AMOUNT | NUMBER | Discount amount | ||
| EMPLOYEE_VERIFICATION_ID | NUMBER | (15) | Employee verification identifier | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| REJECT_CODE | VARCHAR2 | (25) | Reject code | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_ID
, CARD_ID
, CARD_PROGRAM_ID
, CARD_NUMBER
, FEED_LINE_ID
, REFERENCE_NUMBER
, ALT_REFERENCE_NUMBER
, CUSTOMER_CODE
, AMOUNT
, ORIGINAL_CURRENCY_AMOUNT
, ORIGINAL_CURRENCY_CODE
, POSTED_CURRENCY_CODE
, CURRENCY_CONVERSION_RATE
, TRANSACTION_DATE
, POSTED_DATE
, RECORD_TYPE
, CREATE_DISTRIBUTION_FLAG
, MERCHANT_NAME
, MERCHANT_NUMBER
, CARD_CODE_VALUE
, CODE_ID
, INDUSTRY_CODE1
, INDUSTRY_CODE2
, ALT_MERCHANT_NUMBER
, MERCHANT_ADDRESS1
, MERCHANT_ADDRESS2
, MERCHANT_ADDRESS3
, MERCHANT_ADDRESS4
, MERCHANT_CITY
, MERCHANT_PROVINCE_STATE
, MERCHANT_POSTAL_CODE
, MERCHANT_COUNTRY
, MERCHANT_PHONE
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, MERCHANT_TAX_ID
, TAX_PAID_FLAG
, TAX_AMOUNT
, TAX_RATE
, TAX_TYPE
, ALT_MERCHANT_TAX_ID
, ALT_TAX_PAID_FLAG
, ALT_TAX_AMOUNT
, ALT_TAX_RATE
, ALT_TAX_TYPE
, FREIGHT_AMOUNT
, DUTY_AMOUNT
, MERCHANT_BUSINESS_TYPE
, MERCHANT_OWNER_TYPE
, PRODUCT_CODE
, ITEM_DESCRIPTION
, ITEM_QUANTITY
, ITEM_UOM
, EXTENDED_ITEM_AMOUNT
, DISCOUNT_INDICATOR
, DISCOUNT_AMOUNT
, EMPLOYEE_VERIFICATION_ID
, DESCRIPTION
, REJECT_CODE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM AP.AP_EXPENSE_FEED_LINES_ALL;
AP.AP_EXPENSE_FEED_LINES_ALL does not reference any database object
AP.AP_EXPENSE_FEED_LINES_ALL is referenced by following:
APPS
AP_EXPENSE_FEED_LINES
AP_EXPENSE_FEED_LINES_ALL
|
|
|
|