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 |