Expense Reports and Credit Cards

Payables Procurement Card Transactions Interface Table

Payables Procurement Card Transactions Interface Table Column Descriptions

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.

AP_EXPENSE_FEED_LINES_ALL

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