Credit card import application parameters
This table shows the credit card import application parameters that can be configured and implemented using Infor SAT.
| Parameter Name | Description |
|---|---|
| AmexBookNumber (parm_id = 3063554) | Amex Remittance
This parameter manages a unique four digit number assigned to the customer by American Express at the time of setup. No Dependencies Is Not Customer Editable |
| AmexCID (parm_id = 3063553) | Amex Remittance
This parameter manages a unique six digit number assigned to the customer by American Express at the time of setup. No Dependencies Is Not Customer Editable |
| amexEmpNumMatch (parm_id = 3069617) | This parameter is set to enabled for the
Amex 1205 and Amex 4322 CC Feeds to match the Amex card accounts to their
Expense Management users through employee numbers.
The default does not specify this parameter in the alwf_appl_parameters table. This means the parameter is initially disabled. No Dependencies Is Customer Editable |
| AmexFileSequence (parm_id = 3063555) | Amex Remittance
This parameter manages a numeric sequence of files sent to American Express appended to the file name. This parameter prevents skipped or duplicated files. Initially it is set to 1, it will be appended as 01, and the process handles the successive updates. No Dependencies Is Not Customer Editable |
| AmexPaymentType (parm_id = 3063557) | Amex Remittance
This parameter manages the payment type BOb ID for the American Express payment type in the alco_payment_type table. No Dependencies Is Not Customer Editable |
| AmexProcessorId (parm_id = 3063550) | Amex Remittance
This parameter manages the credit card processor Bob ID for the American Express card in the alcc_processor table. This is typically 50802 but can be specific to the installation. No Dependencies Is Not Customer Editable |
| AmexRemitDir (parm_id = 3063556) | Amex Remittance
This parameter manages the directory path where the output files are placed. Different directory separators must be used based on the operating system. Windows requires double slashes due to the use of an escape character. No Dependencies Is Not Customer Editable |
| AmexSenderId (parm_id = 3063552) | Amex Remittance
This parameter manages a unique ten digit number assigned to the customer by American Express at the time of setup. No Dependencies Is Not Customer Editable |
| amexSsnMatch (parm_id = 3069616) | This parameter is set to enabled for the
Amex 1205 CC Feed to match the Amex credit card accounts to their Expense
Management users through social security number.
The default does not specify this parameter in the alwf_appl_parameters table. This means the parameter is initially disabled. No Dependencies Is Customer Editable |
| AmexStatusAndTotalSummaryEMail (parm_id = 3063559) | Amex Remittance
This parameter manages the email address that the email described in the previous parameter is sent to. The email domain must be included. No Dependencies Is Not Customer Editable |
| AmexStatusAndTotalSummaryString (parm_id = 3063558) | Amex Remittance
This parameter manages the text of an email that will be sent to a specified recipient upon completion of the process. This is editable by the customer. This message also accepts these tokens populated by the bkg process.
No Dependencies Is Customer Editable |
| cc.Amex1205.EmpNumLength | The length of the employee id field in the Amex 1205 feed. For example, 27. The default is 10. |
| cc.Amex1205.EmpNumStart | The start position of the employee id in the Amex 1205 feed. For example, 122. The default is 112. |
| cc.Amex1205Global.EmpNumLength | The length of the employee id field in the Amex Global 1205 feed. The default is 15. |
| cc.Amex1205Global.EmpNumStart | The start position of the employee id in the Amex Global 1205 feed. The default is 211. |
| cc.AmexLevel3ReferenceNumberType | Must be either GL1025 or KR1025. When the Amex 1080 (hotel folio) feed is imported, the system tries to link the folio records to existing transactions. If the transactions are missing (usually because the 1080 is imported before the 1025 feed), the folio record is saved with a reference number that matches to the transaction. This parameter lets the system know whether to use the reference number for the KR1025 feed or for the GL1025. |
| cc.allowImportNonPCICompliantFeeds | Set the value of this parameter to true if non PCI Compliant CCfeeds must be imported. This parameter is used only if the value of either cc.checkRegex orcc.checkRegexBkg application parameter is set to true. Else, the non PCI Compliant CC feeds are skipped.By default, the value of this parameter is set to False. |
| cc.VCF40Feed.ignoreTransactionsWith TheseTypeCodes (parm_id = 3135454) | This parameter specifies the type codes that determine which transactions to exclude from the import. The Visa type codes are defined in a comma-separated list in the VCF40 format record type 5, field 18. Transactions with these type codes are excluded from the import. |
| cc.detachTransitions (parm_id = 3140877) | Use this parameter to specify a comma-separated list of workflow transition IDs. When an expense report is checked in for one of these transitions, the system detaches all of the transactions where the approved amount is zero provided that the application parameter cc.enableDetachOnZeroApprovedAmount = true. Is Not Customer Editable |
| cc.enabledRemovedTransactions (parm_id = 3135131) | Use this parameter to control whether the
button and
Show Removed link are
visible on the transactions page of the
Infor ER
HTML client and whether the
button and
Removed checkbox are
visible on the
Credit Card Transactions and
Credit Card Filter
screens of the Java client. Set this to false to hide
this functionality.
Default value is true Is Customer Editable |
| cc.enableDetachOnZeroApprovedAmount (parm_id = 3140876) | Use this parameter to enable detaching creidt
card transactions when the approved amount is zero. If a transaction is
itemized, the approved amount on all non-personal itemizations must be zero
before the transaction can be detached. If itemizations are generated from
hotel folio, the folio attachments are also removed.
Default value is false Is Not Customer Editable |
| ccExpenseWarning (parm_id = 3074543) | A flag indicating whether ambiguous expense
type warnings should be displayed to the user, to allow the user to select an
expense type, during a CC transaction attachment. Default is 1. Valid values
are:
Is Not Customer Editable |
| cc.er.changeExpenseType.enabled | If true, the credit card change expense type in ER is enabled. The default is false. |
| cc.feedNotImportPayment (parm_id = 3069625) | The cc.feedNotImportPayment parameter
indicates if transactions of payment types are needed or imported during the
feed. The payment type transactions are considered to be credit rather than
debit. Since they are credit rather than debit, some implementations do not
want to include them in the cc feed. Set this flag to true if you do not want
to import payment type transactions during the cc feed.
The default value is true No Dependencies Is Customer Editable |
| cc.feedNotInsertBobType.999100200 (parm_id = 3069621) | Use this parameter to indicate where new
data for the specified BOb type of # can be created during the feed.
For example, when cc.feedNotMapBobType.999100200 is set to false (default), a new row of data is created in the alco_air_service_class table if no similar data can be found in the specified table that is associated with a BOb type 999100200. No Dependencies Is Customer Editable |
| cc.feedNotMapBobType.999100200 (parm_id = 3069622) | When setting this parameter to true, a
default value, then the specified BOb type of # will not map during the credit
card feed.
For example, when cc.feedNotMapBobType.999100200 is set to false (default), the alcc_transaction_detail.airline_class_of_service_id table is created by matching the data provided from the alcc_transaction_detail.airline_class_of_service table to the data in alco_ari_service_class table, which is represented by a BOb type of 999100200. No Dependencies Is Customer Editable |
| cc.importCashAdvance (parm_id = 3128254) | This parameter is used to control the import
of credit card cash advance transaction data to the Expense Management
application. Set this parameter to true, default value,) to import cash advance
transactions during credit card feeds.
No Dependencies Is Customer Editable |
| cc.importThoseBilledCurrencyMatched (parm_id = 3061918) | Set this parameter to true to import credit
card transaction data only for those transactions where the billed currency
matches the user's default currency. Set to false to import all data regardless
of the currency types.
The default value is true. No Dependencies Is Not Customer Editable |
| cc.importTransactionDetail (parm_id = 3061916) | Set this parameter to true if the credit
card transaction detail, level 2 and 3, data are needed for cc import and to
import to alcc_transaction_detail table.
The default value is true. No Dependencies Is Not Customer Editable |
| cc.location.addEnabled | Set this parameter to true if the locations from credit card transactions
must be added to the location list of the user. The default value is true No Dependencies Is Not Customer Editable |
| cc.looseVCF40TransactionMatching (parm_id = 3135115) | For customers running the Visa VCF40 feed on
builds older than 6.6 SP3, two transactions that contain the same reference
number but different sequence numbers would cause the importer to update the
wrong transaction if it already existed in the transaction table.
The default is false. Is Not Customer Editable |
| cc.level2ValidDateRangeInDays | Airline departure date, hotel arrival date and hotel departure date are compared to the transaction date. If they are not within the number of days specified by this parameter, the level 2 data is flagged as an error and not inserted. The default is 180 days. |
| cc.maskAccountNumber (parm_id = 3135521) | Use this parameter to indicate whether to
mask the credit card numbers that are displayed in
Infor SAT.
If true then the credit card number is masked and shows only last four digits
of the card.
The default value is true. Is Customer Editable |
| cc.maskAccountNumberInImportLog (parm_id = 3136026) | Use this parameter to hide or mask the full
credit card number from the CC Transaction Import Log file.
The default is false. Is Customer Editable |
| cc.persistCardFilter | If true, the credit card filter is saved across sessions. The default it true. |
| cc.personalCardFunctionalityEnabled (parm_id = 3137076) | Use this parameter to enable/disable the
personal credit card import feature.
The default is false. Is Customer Editable |
| ccDateFormat (parm_id = 3081654) | Use this parameter to specify a date format
to use when importing the credit card transaction data. It is applied only for
the Standard CC Feed.
The default value is yyyyMMdd. No Dependencies Is Customer Editable |
| ccExpenseWarning (parm_id = 3074543) | This parameter is a flag indicating whether
expense type warnings should be displayed to the user, to enable the user to
select an expense type, during a CC transaction attachment.
Valid values are:
No Dependencies Is Not Customer Editable |
| ccUserKey (parm_id = 3081653) | Use this parameter to specify the
employeeNumber or SSN option for matching credit card accounts to their Expense
Management users. Applies only to the Standard CC Feed.
The default value is employeeNumber. No Dependencies Is Customer Editable |
| cc.VCF40.EmpNumPosition (parm_id = 3143937) | Use this parameter to specify the field
position within the Visa VCF40 file where the employee number is found.
The default value is 23. Is Customer Editable |
| cc.VCF40EmpNumMatch (parm_id = 3141126) | Use this parameter to enabled the match the
credit card to the user during import using employee number.
The default value is enabled. Is Customer Editable |
| cc.VCF40Feed.ignoreTransactionsWithTheseTypeCodes (parm_id = 3135454) | This is a comma-separated list of Visa type
codes as defined in the VCF40 format record type 5, field 18. Transactions
whose types are included in the list will be ignored.
The default value is -1. Is Customer Editable |
| cc.VCF40SsnMatch (parm_id = 3141125) | Use this parameter to enabled the match of
the credit card to the user during import using the social security number.
The default value is disabled. Is Customer Editable |
| creditCard (parm_id = 78023) | This parameter controls the switch that
enables the optional Credit Card Feed module. You must purchase the Credit Card
Feed module separately.
The valid values are:
This parameter is dependent on the creditCardReceipt application parameter. Is Not Customer Editable |
| creditCardHasReceipt (parm_id = 3134205) | If this parameter is set to true, the
Has Receipt will be
automatically selected when a credit card transaction is attached to an ER line
item.
The default value is true, Is Customer Editable |
| creditCardReceiptChecked (parm_id = 78024) | This parameter controls the switch that
enables the Credit Card Receipt option. The
Receipt Verified check
box is automatically selected when a credit card transaction is attached to an
ER line item. The Credit Card Receipt option is available only if you purchase
the optional Credit Card Feed module.
When this option is selected, credit card transactions are treated as if they had physical receipts. You need permission from the Internal Revenue Service to use this option. The valid values are:
Changes to this parameter affect new credit card transactions only. This parameter is dependent on the CreditCard application parameter. Is Customer Editable |
| er.showCCImportIncompleteWarning (parm_id = 3134214) | Use this parameter to activate the display
of an informative warning when an imported credit card transaction requires
additional information.
The default value is true. Is Customer Editable |
| geSbfEmpNumMatch (parm_id = 3069619) | This parameter is set to enabled for the GE
SBF CC Feed to match the GE Master card accounts to their users through
employee numbers.
The default does not specify this parameter in the alwf_appl_parameters table. This means the parameter is initially disabled. No Dependencies Is Customer Editable |
| geSbfSsnMatch (parm_id = 3069618) | This parameter is set to enabled for the GE
SBF CC Feed to match the Master card accounts to their users through social
security number.
The default does not specify this parameter in the alwf_appl_parameters table. This means the parameter is initially disabled. No Dependencies Is Customer Editable |
| maxCCUploadFileSize (parm_id = 3136961) | Use this parameter to determine the largest
file size in Kbytes that the user can upload for an OFX credit card
transactions file.
The default value is 2048 No Dependencies Is Customer Editable |
| UnassignedCCTransactionNotification.sendAtDaysTo{0} (parm_id = 3134590) | Use this parameter to determine the
recipient for e-mail. Valid values are:
The default value is 1. |
| UnassignedCCTransactionNotification.sendAtDaysTo{15} (parm_id = 3134591) | Use this parameter to determine the
recipient for e-mail. Valid values are:
The default value is 1. |
| UnassignedCCTransactionNotification.sendAtDaysTo{20} (parm_id = 3134592) | Use this parameter to determine the
recipient for e-mail.Valid values are:
The default value is 3. |
| UnassignedCCTransactionNotification.sendAtDaysTo{30} (parm_id = 3134593) | Use this parameter to determine the
recipient for e-mail. Valid values are:
The default value is 3. |
| UnassignedCCTransactionNotificationBkg.ignoreRemoved (parm_id = 3134594) | Use this parameter to specify whether to send emails for removed transactions for the credit card processor indicated; if ForXY Z is left out, the specified value will apply to all processors not otherwise configured. The default value is false. |
| UnassignedCCTransactionNotificationBkg.ignoreRemovedForAmerican Express (parm_id = 3132842) | Use this parameter to determine if the
systems should send emails about removed transactions for the credit card
processor indicated; if ForXY Z is left out, the specified value will apply to
all processors not otherwise configured.
The default value is false. Is Customer Editable |
| UnassignedCCTransactionNotificationBkg.ignoreRemovedForUSBank (parm_id = 3132843) |
Use this parameter to determine whether to send emails for removed transactions for the credit card processor indicated; if ForXY Z is left out, the specified value will apply to all processors not otherwise configured. The default value is true. Is Customer Editable |
| UnassignedCCTransactionNotificationBkg.sendAtDaysForAmerican ExpressTo{10} (parm_id = 3132839) | Use this parameter to determine the
Recipient for e-mail. Valid values are:
The default value is 3. Dependencies Is Customer Editable |
| UnassignedCCTransactionNotificationBkg.sendAtDaysForUSBankTo{15} (parm_id = 3132840) | Use this parameter to determine the
recipient for e-mail. Valid values are:
The default value is 3. Is Customer Editable |
| UnassignedCCTransactionNotificationBkg.since (parm_id = 3132838) | Use this parameter to determine the date to
use for comparison. Valid values are:
The default value is postingDate. Is Customer Editable |
| UnassignedCCTransactionNotificationBkg.useLongSearchWindow (parm_id = 3132841) | If this parameter is set to true, the
notification will send for transactions between the configured number of days
old and the next larger number, if any. If there is no larger number, it will
search for all transactions the configured number of days old or older.
For example, if notifications are set for 10, 15, and 30 days with this parameter set to true, the notifications will be sent for transactions that are 10-14 days old, 15-29 days old, and 30 days old or older, respectively. The default value is true. Dependencies Is Customer Editable |
| usBankSsnMatch (parm_id = 3069620) | This parameter is set to enabled for the US
Bank CC Feed to match the Visa card accounts to their users through social
security number.
The default does not specify this parameter in the alwf_appl_parameters table. This means the parameter is initially disabled. No Dependencies Is Customer Editable |
| cc.maskAccountNumberInImportLog (parm_id = 3136026) | If this parameter set to true, the credit card account number to be displayed in the import log will be masked and only the last four digits will be displayed. |
| cc.mastercard.ssnMatchEnabled (parm_id = 3145154) | If this parameter is set true, SSN matching for Mastercard CDF import is enabled. The default is false. |
| cc.mastercard.useAlternateEmployeeId (parm_id = 3145155) | If this parameter is set to true, the system will use EINNineDigit instead of EmployeeId as the element for the employee ID(or SSN, depending on cc.mastercard.ssnMatchEnabled). The default is false. |
| cc.enableDetachOnZeroApprovedAmount (parm_id = 3140876) | Set this parameter to true to enable detaching CC transactions when the approved amount is zero. If a transaction is itemized, the approved amount on all non-personal itemizations must be zero before the transaction can be detached. If itemizations are generated from hotel folio, the folio attachments are also removed. The default is false. |
| cc.deactivateUsersWithUnattachedTransactions (parm_id = 3147984) | If true, the system does not prevent the users to deactivate the unattached credit card transactions using HRBkg. If false, HRBkg throws an error if a deactivation is attempted and proceeds with the next record. Default value is true. |