The following table lists the columns in the Payables Procurement Card Transactions Interface Table and indicates which columns require values for importing into Payables. See also: Oracle Payables eTRM.
| Column Name | Null | Type | Comments |
|---|---|---|---|
| EMPLOYEE_ID | NUMBER(15) | Required Foreign key: HR_EMPLOYEES_ CURRENT_V | |
| CARD_ID | NUMBER(15) | Foreign key | |
| CARD_PROGRAM_ID | NOT NULL | NUMBER(15) | Required; Foreign key |
| CARD_NUMBER | NOT NULL | VARCHAR2(80) | Required |
| FEED_LINE_ID | NOT NULL | NUMBER(15) | Required; Primary key |
| REFERENCE_NUMBER | VARCHAR2(240) | Unique | |
| ALT_REFERENCE_ NUMBER | VARCHAR2(240) | ||
| CUSTOMER_CODE | VARCHAR2(240) | ||
| AMOUNT | NOT NULL | NUMBER | Required (must load as either positive or negative number) |
| ORIGINAL_CURRENCY_AMOUNT | NUMBER | ||
| ORIGINAL_CURRENCY_CODE | VARCHAR2(15) | ||
| POSTED_CURRENCY_CODE | VARCHAR2(15) | ||
| CURRENCY_CONVERSION_RATE | NUMBER | ||
| TRANSACTION_DATE | DATE | ||
| POSTED_DATE | NOT NULL | DATE | |
| RECORD_TYPE | VARCHAR2(25) | ||
| CREATE_DISTRIBUTION_FLAG | VARCHAR2(1) | ||
| MERCHANT_NAME | VARCHAR2(80) | ||
| MERCHANT_NUMBER | VARCHAR2(80) | ||
| CARD_CODE_VALUE | VARCHAR2(80) | ||
| CODE_ID | NUMBER(15) | Foreign key | |
| INDUSTRY_CODE1 | VARCHAR2(80) | ||
| INDUSTRY_CODE2 | VARCHAR2(80) | ||
| ALT_MERCHANT_NUMBER | VARCHAR2(80) | ||
| MERCHANT_ADDRESS1 | VARCHAR2(35) | ||
| MERCHANT_ADDRESS2 | VARCHAR2(35) | ||
| MERCHANT_ADDRESS3 | VARCHAR2(35) | ||
| MERCHANT_ADDRESS4 | VARCHAR2(35) | ||
| MERCHANT_CITY | VARCHAR2(25) | ||
| MERCHANT_PROVINCE_STATE | VARCHAR2(25) | ||
| MERCHANT_POSTAL_CODE | VARCHAR2(25) | ||
| MERCHANT_COUNTRY | VARCHAR2(25) | ||
| MERCHANT_PHONE | VARCHAR2(25) | ||
| SHIP_FROM_POSTAL_CODE | VARCHAR2(25) | ||
| SHIP_FROM_COUNTRY | VARCHAR2(25) | ||
| SHIP_TO_POSTAL_CODE | VARCHAR2(25) | ||
| SHIP_TO_COUNTRY | VARCHAR2(25) | ||
| MERCHANT_TAX_ID_NUMBER | VARCHAR2(80) | ||
| TAX_PAID_FLAG | VARCHAR2(1) | ||
| TAX_AMOUNT | NUMBER | ||
| TAX_RATE | NUMBER | ||
| TAX_TYPE | VARCHAR2(25) | ||
| ALT_MERCHANT_TAX_ID | VARCHAR2(80) | ||
| ALT_TAX_PAID_FLAG | NUMBER | ||
| ALT_TAX_AMOUNT | NUMBER | ||
| ALT_TAX_RATE | NUMBER | ||
| ALT_TAX_TYPE | VARCHAR2(25) | ||
| FREIGHT_AMOUNT | NUMBER | ||
| DUTY_AMOUNT | NUMBER | ||
| MERCHANT_BUSINESS_ TYPE | VARCHAR2(80) | ||
| MERCHANT_OWNER_TYPE | VARCHAR2(80) | ||
| PRODUCT_CODE | VARCHAR2(80) | ||
| ITEM_DESCRIPTION | VARCHAR2(240) | ||
| ITEM_QUANTITY | NUMBER | ||
| ITEM_UOM | VARCHAR2(80) | ||
| EXTENDED_ITEM_ AMOUNT | NUMBER | ||
| DISCOUNT_INDICATOR | VARCHAR2(1) | ||
| DISCOUNT_AMOUNT | NUMBER | ||
| EMPLOYEE_VERIFICATION_ID | NUMBER(15) | ||
| DESCRIPTION | VARCHAR2(240) | ||
| ORG_ID | NUMBER(15) | ||
| LAST_UPDATE_DATE | NOT NULL | DATE | |
| LAST_UPDATED_BY | NOT NULL | NUMBER(15) | |
| LAST_UPDATE_LOGIN | NUMBER(15) | ||
| CREATION_DATE | DATE | ||
| CREATED_BY | NUMBER(15) | ||
| ATTRIBUTE CATEGORY | VARCHAR2(150) | Optional | |
| ATTRIBUTE 1 - 30 | VARCHAR2(150) | Optional |