Service Directory > v25.1 > Resource_Management > Import_Credit_Card_Transactions
 

Operation: Import_Credit_Card_Transactions

This operation will add or update an Expense Credit Card Transaction File. Each file will load one or more Expense Credit Card Transactions. Expense Credit Card Transactions are used in the Expense Report lines. Expense Credit Card Transaction data includes the Corporate Credit Card Account, Employee ID, Cardholder Name, Amount, Currency, etc...


@ - A parameter name with this symbol denotes an XML attribute within the document instead of an XML element.


Contents

 

Web Service

 

Request

 

Response

 

Element(s)

 

Request Element: Credit_Card_Transaction_Header__HV__Request

Credit Card Transaction Header Request.
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
@Add_Only  boolean  [1..1]  Add Only Flag. Indicates that the service is an add only, not an update.   
Expense_Credit_Card_Transaction_File_Reference  Credit_Card_Transaction_FileObject  [0..1]  Reference to an existing Credit Card Transaction File for update only purposes.   
Expense_Credit_Card_Transaction_File_Data  Credit_Card_Transaction_File__HV__Data  [1..1]  Element containing all Credit Card Transaction File data   
Validation Description
The Web Service is set to Add Only; but the Expense Credit Card Transaction File already exists.  The Web Service is set to Add Only; but the Expense Credit Card Transaction File already exists. 
top
 

Response Element: Put_Import_Process_Response

Put Import Process Response element
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
Import_Process_Reference  Web_Service_Background_Process_RuntimeObject  [0..1]  Web Service Background Process Runtime element   
Header_Instance_Reference  InstanceObject  [0..1]  Header Instance element   
top
 

Credit_Card_Transaction_FileObject

part of: Credit_Card_Transaction_Header__HV__Request
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Credit_Card_Transaction_FileObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Credit_Card_Transaction_FileObjectID

part of: Credit_Card_Transaction_FileObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Expense_Credit_Card_File_Number  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Credit_Card_Transaction_File__HV__Data

part of: Credit_Card_Transaction_Header__HV__Request
Element containing all Credit Card Transaction File data
 
Parameter name Type/Value Cardinality Description Validations
File_Number  string  [0..1]  Expense Credit Card Transaction File Number. This is the Expense Credit Card Transaction File unique identifier   
File_Name  string  [0..1]  Expense Credit Card Transaction File Name   
Report_Create_Date  date  [1..1]  Expense Credit Card Transaction File Date   
Credit_Card_Type_Reference  Credit_Card_TypeObject  [1..1]  Credit Card Type Reference for Expense Credit Card Transaction File   
Report_Version_Date  date  [0..1]  Expense Credit Card Transaction File Report Version Date   
Report_Version  string  [0..1]  Expense Credit Card Transaction File Report Version   
Expense_Credit_Card_Transaction_Data  Credit_Card_Transaction__HV__Data  [0..*]  Element containing all Credit Card Transaction data 
Validation Description
The following transaction has already been expensed and cannot be updated: [number]   
 
top
 

Credit_Card_TypeObject

part of: Credit_Card_Transaction_File__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Credit_Card_TypeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Credit_Card_TypeObjectID

part of: Credit_Card_TypeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Credit_Card_Type_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Credit_Card_Transaction__HV__Data

part of: Credit_Card_Transaction_File__HV__Data
Element containing all Credit Card Transaction data
 
Parameter name Type/Value Cardinality Description Validations
Transaction_Number  string  [1..1]  Expense Credit Card Transaction Number. This is the Expense Credit Card Transaction unique identifier   
Transaction_Date  date  [1..1]  Expense Transaction Date   
Billing_Date  date  [1..1]  Expense Credit Card Billing Date   
Posted_Date  date  [0..1]  Transaction Posted Date   
Merchant_Code_Reference  Merchant_CodeObject  [0..1]  Merchant Code Reference   
Merchant_Code  string  [0..1]  Merchant Code   
MIS_Industry_Code_Reference  Merchant_CodeObject  [0..1]  MIS Merchant Code Reference   
MIS_Industry_Code  string  [0..1]  MIS Merchant Code   
Market_Code  string  [0..1]  Market Code   
Supplier_Reference_Number  string  [0..1]  Supplier Reference Number   
DUNS_Number_for_Supplier  string  [0..1]  DUNS Number that uniquely identifies the Supplier.   
Amount  decimal (26, 6)   [0..1]  Transaction Extended Amount   
Tax_Amount  decimal (26, 6)   [0..1]  Expense Credit Card Extended Tax Amount   
Sales_Taxes_Collected  boolean  [0..1]  Shows whether Sales Taxes were collected.   
Source_Currency_Reference  CurrencyObject  [1..1]  Source Currency Reference   
Currency_Exchange_Rate  decimal (28, 8) >0   [0..1]  Expense Credit Card Currency Exchange Rate   
Converted_Amount  decimal (26, 6)   [0..1]  Expense Credit Card Converted Amount   
Converted_Tax_Amount  decimal (26, 6)   [0..1]  Expense Credit Card Converted Tax Amount   
Converted_Currency_Reference  CurrencyObject  [1..1]  Converted Currency Reference   
Euro_Billed_Amount  decimal (26, 6)   [0..1]  Expense Credit Card Euro Billed Amount   
Euro_Billed_Tax_Amount  decimal (26, 6)   [0..1]  Expense Credit Card Euro Billed Tax Amount   
Transaction_Type_Code  string  [0..1]  Expense Credit Card Transaction Type Code   
Financial_Category_Code  string  [0..1]  Expense Credit Card Financial Category Code   
Charge_Description_Line_1  string  [0..1]  Charge Description Line 1   
Charge_Description_Line_2  string  [0..1]  Charge Description Line 2   
Cost_Center_Reference  Cost_CenterObject  [0..1]  Cost Center Reference for Credit Card Transaction   
Purchase_Order_Number  string  [0..1]  A unique Workday system generated Purchase Order Number. This number can be used to reference the instance of the Purchase Order.   
Release_Number  string  [0..1]  Release Number against Purchase Order previously placed.   
Expense_Credit_Card_Token  string  [0..1]  Expense Credit Card Token for Expense Credit Card used in Expense Credit Card Transaction   
Corporate_Account_Reference  Corporate_Credit_Card_AccountObject  [1..1]  Corporate Account Reference for Expense Credit Card in Expense Credit Card Transaction   
Employee_ID  string  [0..1]  Employee ID   
Cardholder_Name  string  [0..1]  Cardholder Name   
Account_Number  string  [0..1]  Account Number   
Charge_Description  string  [0..1]  Charge Description   
Number_of_Days_or_Nights  decimal (12, 0) >0   [0..1]  Number of Days or Nights   
Credit_Card_Merchant_Name  string  [0..1]  Credit Card Merchant Name   
Credit_Card_Merchant_Location  string  [0..1]  Credit Card Merchant Location   
Arrival_Date  date  [0..1]  Expense Credit Card Arrival Date   
Departure_Date  date  [0..1]  Expense Credit Card Departure Date   
Reference_Number  string  [0..1]  Expense Credit Card Reference Number   
Participant_Name  string  [0..1]  Expense Credit Card Participant Name   
Daily_Rate  decimal (26, 6) >0   [0..1]  Daily Rate   
Domestic  boolean  [0..1]  Expense Credit Card Domestic   
Ticket_Number  string  [0..1]  Ticket Number   
Class_of_Service  string  [0..1]  Class of Service   
Air_Routing  string  [0..1]  Air Routing   
Air_Carrier_Code  string  [0..1]  Air Carrier Code   
Origination_City  string  [0..1]  Origination City   
Origination_State  string  [0..1]  Origination State   
Origination_Country  string  [0..1]  Origination Country   
Destination_City  string  [0..1]  Destination City   
Destination_State  string  [0..1]  Destination State   
Destination_Country  string  [0..1]  Destination Country   
Class_of_Service_Reference  Class_of_ServiceObject  [0..1]  Class of Service Reference for Expense Credit Card Transaction   
Credit_Card_Transaction_Status_Reference  Expense_StatusObject  [0..1]  Credit Card Transaction Status Reference   
Credit_Card_Transaction_Line_Data  CC_Transaction_Line  [0..*]  Credit Card Transaction Line Data   
Name_Match_Data  Credit_Card_Transaction_Name_Match_Data  [0..*]  Element containing Credit Card Transaction Name matches for Travel Cities and Merchants. 
Validation Description
Credit Card Transaction Name Match must include either a Merchant, Origination City, or a Destination City as a match.   
Confidence level percentage must between 0 and 100.   
Credit Card Transaction matches should only include 1 match of either an Origin City, Destination City, or Merchant (Hotel, Airline, or Car Rental Agency).   
 
Validation Description
The following transaction has already been expensed and cannot be updated: [number]   
top
 

Merchant_CodeObject

part of: Credit_Card_Transaction__HV__Data, Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Merchant_CodeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Merchant_CodeObjectID

part of: Merchant_CodeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Merchant_Code  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

CurrencyObject

part of: Credit_Card_Transaction__HV__Data, Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  CurrencyObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

CurrencyObjectID

part of: CurrencyObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Currency_ID, Currency_Numeric_Code  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Cost_CenterObject

part of: Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Cost_CenterObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Cost_CenterObjectID

part of: Cost_CenterObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Cost_Center_Reference_ID, Organization_Reference_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Corporate_Credit_Card_AccountObject

part of: Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Corporate_Credit_Card_AccountObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Corporate_Credit_Card_AccountObjectID

part of: Corporate_Credit_Card_AccountObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Corporate_Credit_Card_Account_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Class_of_ServiceObject

part of: Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Class_of_ServiceObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Class_of_ServiceObjectID

part of: Class_of_ServiceObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Class_of_Service_Value, Spend_Data_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Expense_StatusObject

part of: Credit_Card_Transaction__HV__Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Expense_StatusObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Expense_StatusObjectID

part of: Expense_StatusObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Expense_Status_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

CC_Transaction_Line

part of: Credit_Card_Transaction__HV__Data
Credit Card Transaction Line Data
 
Parameter name Type/Value Cardinality Description Validations
Credit_Card_Transaction_Line_ID  decimal (12, 0) >0   [0..1]  Credit Card Transaction Line ID.   
Purchase_Order_Line_Number  decimal (4, 0) >0   [0..1]  The line number of the Purchase Order.   
Item_Description  string  [0..1]  Item Description   
UNSPSC_code  decimal (12, 0) >0   [0..1]  UNSPSC Code   
UPC  string  [0..1]  Universal Product Code   
Vendor_Part_Number  string  [0..1]  Vendor Part Number   
Quantity  decimal (22, 2)   [0..1]  Quantity   
Unit_of_Measure_Reference  Unit_of_MeasureObject  [0..1]  Reference to an existing Unit of Measure   
Unit_Price  decimal (26, 6)   [0..1]  Item Unit Price   
Extended_Amount  decimal (18, 3)   [0..1]  Extended Amount   
Tax_Rate  decimal (6, 3) >0   [0..1]  Tax Rate   
Tax_Amount  decimal (26, 6)   [0..1]  Total Tax Amount for Tax Rate   
Freight_Amount  decimal (26, 6)   [0..1]  Freight charges incurred.   
Handling_Amount  decimal (26, 6)   [0..1]  Handling charges incurred.   
Discount_Amount  decimal (26, 6)   [0..1]  Amount of discount applied.   
Flat_Rate_Amount  decimal (26, 6)   [0..1]  Flat rate negotiated.   
Lost_or_Damaged_Items_Amount  decimal (26, 6)   [0..1]  Charges as a result of lost or damaged items.   
One_Time_Miscellaneous_Charges_Amount  decimal (26, 6)   [0..1]  One time only charges.   
Other_Charges_Amount  decimal (26, 6)   [0..1]  Other miscellaneous charges.   
Miscellaneous_Charges_Amount  decimal (26, 6)   [0..1]  Sum of all other charges submitted.   
Miscellaneous_Charges_Description  string  [0..1]  Description of Miscellaneous Charges Amount.   
top
 

Unit_of_MeasureObject

part of: CC_Transaction_Line
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Unit_of_MeasureObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Unit_of_MeasureObjectID

part of: Unit_of_MeasureObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, UN_CEFACT_Common_Code_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Credit_Card_Transaction_Name_Match_Data

part of: Credit_Card_Transaction__HV__Data
Element containing Credit Card Transaction Name matches for Travel Cities and Merchants.
 
Parameter name Type/Value Cardinality Description Validations
Confidence_Percentage  decimal (6, 3) >0   [0..1]  Confidence level percentage of merchant, or travel city names matching Workday's persisted data.   
Merchant_Reference  Abstract_Spend_Data_NameObject  [0..1]  Merchant matching the merchant listed on the Credit Card Transaction. 
Validation Description
If a Merchant Reference is provided, it must be a Merchant, or an Alternate Name linked to a Merchant.   
 
Origination_City_Reference  Abstract_Spend_Data_NameObject  [0..1]  Workday Origination City matching the origination city on the Credit Card Transaction. 
Validation Description
If a Origination City Reference is provided, it must be a Travel City, or an Alternate Name linked to a Travel City.   
 
Destination_City_Reference  Abstract_Spend_Data_NameObject  [0..1]  Workday Destination City matching the destination city on the Credit Card Transaction. 
Validation Description
If a Destination City Reference is provided, it must be a Travel City, or an Alternate Name linked to a Travel City.   
 
Supplier_Reference  Abstract_Payee_Data_NameObject  [0..1]  Workday Supplier matching the Supplier on the Credit Card Transaction. 
Validation Description
If a Supplier Reference is provided, it must be a Supplier, or an Alternate Name linked to a Supplier.   
 
Validation Description
Credit Card Transaction Name Match must include either a Merchant, Origination City, or a Destination City as a match.   
Confidence level percentage must between 0 and 100.   
Credit Card Transaction matches should only include 1 match of either an Origin City, Destination City, or Merchant (Hotel, Airline, or Car Rental Agency).   
top
 

Abstract_Spend_Data_NameObject

part of: Credit_Card_Transaction_Name_Match_Data, Credit_Card_Transaction_Name_Match_Data, Credit_Card_Transaction_Name_Match_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Abstract_Spend_Data_NameObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Abstract_Spend_Data_NameObjectID

part of: Abstract_Spend_Data_NameObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Applicant_ID, Class_of_Service_Value, Contingent_Worker_ID, Employee_ID, Spend_Data_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Abstract_Payee_Data_NameObject

part of: Credit_Card_Transaction_Name_Match_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Abstract_Payee_Data_NameObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Abstract_Payee_Data_NameObjectID

part of: Abstract_Payee_Data_NameObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Ad_hoc_Payee_ID, Applicant_ID, Company_Reference_ID, Contingent_Worker_ID, Corporate_Credit_Card_Account_ID, Customer_ID, Customer_Reference_ID, Deduction_Recipient_ID, Employee_ID, Investor_ID, Organization_Reference_ID, Sponsor_ID, Sponsor_Reference_ID, Student_Financial_Account_ID, Supplier_Connection_ID, Supplier_ID, Supplier_Reference_ID, Tax_Authority_ID, Tax_Authority_Reference_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Web_Service_Background_Process_RuntimeObject

part of: Put_Import_Process_Response
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Web_Service_Background_Process_RuntimeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Web_Service_Background_Process_RuntimeObjectID

part of: Web_Service_Background_Process_RuntimeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Background_Process_Instance_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

InstanceObject

part of: Put_Import_Process_Response
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]     
ID  Instance_ID  [0..*]     
top
 

Instance_ID

part of: InstanceObject
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@parent_id  string  [1..1]     
@parent_type  string  [1..1]     
@type  string  [1..1]     
top
 

Credit_Card_Transaction_FileReferenceEnumeration

part of: Credit_Card_Transaction_FileObjectID
Base Type
string
top
 

Credit_Card_TypeReferenceEnumeration

part of: Credit_Card_TypeObjectID
Base Type
string
top
 

Merchant_CodeReferenceEnumeration

part of: Merchant_CodeObjectID
Base Type
string
top
 

CurrencyReferenceEnumeration

part of: CurrencyObjectID
Base Type
string
top
 

Cost_CenterReferenceEnumeration

part of: Cost_CenterObjectID
Base Type
string
top
 

Corporate_Credit_Card_AccountReferenceEnumeration

part of: Corporate_Credit_Card_AccountObjectID
Base Type
string
top
 

Class_of_ServiceReferenceEnumeration

part of: Class_of_ServiceObjectID
Base Type
string
top
 

Expense_StatusReferenceEnumeration

part of: Expense_StatusObjectID
Base Type
string
top
 

Unit_of_MeasureReferenceEnumeration

part of: Unit_of_MeasureObjectID
Base Type
string
top
 

Abstract_Spend_Data_NameReferenceEnumeration

part of: Abstract_Spend_Data_NameObjectID
Base Type
string
top
 

Abstract_Payee_Data_NameReferenceEnumeration

part of: Abstract_Payee_Data_NameObjectID
Base Type
string
top
 

Web_Service_Background_Process_RuntimeReferenceEnumeration

part of: Web_Service_Background_Process_RuntimeObjectID
Base Type
string
top