Overview
The Finance Enterprise Procurement Card module works based on a mapped file concept that tells the system what data needs to be converted. Use this page to define mapped files for multiple banks.
Add New Format
-
Click Add New Format to create a new file format.
-
Enter a Format Name. This is used to identify the mapping definition when you run the import process.
-
Select a Format Type.
-
If the bank statement includes headers, select the Has Headers checkbox.
-
If the bank statement includes a Data Identifier, indicate the identifier.
-
Select a Delimiter.
-
Select a Date Format.
-
Use the Requirements table to identify which fields are required for the data file.
Requirements
|
Format Type |
Has Headers |
Data Identifier |
Delimiter |
Data Field |
Column Number Start |
Column Number End |
P-Card Schema Name |
|---|---|---|---|---|---|---|---|
|
Delimited |
Yes |
No |
Comma, Pipe, or Tab |
Required. Enter the column header name from your file. |
Not applicable |
Not applicable |
Required. Select the P-Card field that matches the file value. |
|
Delimited |
No |
No |
Comma, Pipe, or Tab |
Not applicable |
Required. Enter the column number from your file. |
Not applicable |
Required. Select the P-Card field that matches the file value. |
|
Fixed Width |
Not applicable |
No |
Not applicable |
Not applicable |
Required. Enter the starting position from your file for the data item. |
Required. Enter the ending position from your file for the data item. |
Required. Select the P-Card field that matches the file value. |
|
Fixed Width |
Not applicable |
Yes. Enter the starting character that identifies which line in the file contains the statement data. |
Not applicable |
Not applicable |
Required. Enter the starting position from your file for the data item. |
Required. Enter the ending position from your file for the data item. |
Required. Select the P-Card field that matches the file value. |
Data Identifier
The Data Identifier field is used to identify which row of a data file includes the P-Card transaction information. This is used for files with multiple record types within the same file and will typically include a record type indicator at the beginning of each row.
P-Card Data Field Mapping to P-Card Tables
Format Name: Enter a name for the format. The format name is used to identify the mapping definition when running the import process.
Format Type: Select a format type.
Has Headers: If the bank statement includes headers, select the Has Headers checkbox.
Data Identifier: If the bank statement includes a Data Identifier, enter the identifier.
Delimiter: Select a delimiter from the list.
Date Format: Select a date format from the list.
Fields
Delimited File With Headers
For a delimited file with headers, provide the data field header name.
|
+ |
Data Field |
Column |
Number |
P-Card Schema Name |
|---|---|---|---|---|
|
Add row |
Header Name |
|
|
Field Name |
Fixed Width File
For a fixed-width data file, you must enter the position start and position length of the data values.
|
+ |
Data Field |
Position Start |
Position Length |
P-Card Schema Name |
|---|---|---|---|---|
|
Add row |
Header Name |
|
|
Field Name |
Available Mapping Fields
|
Field Name |
Description |
Required |
|---|---|---|
|
ApPcRef |
|
|
|
AprvDt |
|
|
|
AssetFlag |
|
|
|
AuditDt |
|
|
|
BankCd |
|
|
|
BillCurrencyCd |
|
|
|
CardAssignRef |
|
|
|
CardHolderName |
|
|
|
CardNumber |
|
Yes |
|
DbeFlag |
|
|
|
DiscAmt |
|
|
|
DueDt |
|
|
|
FiscalYear |
|
|
|
GlDeptCd |
|
|
|
GlDivCd |
|
|
|
ImportDt |
|
|
|
MccCd |
|
|
|
MerchantAddr |
|
|
|
MerchantAddr2 |
|
|
|
MerchantAssocVet |
|
|
|
MerchantAssocVietVet |
|
|
|
MerchantCity |
|
|
|
MerchantCountry |
|
|
|
MerchantDBAName |
|
|
|
MerchantDbe8a |
|
|
|
MerchantDbeHub |
|
|
|
MerchantDbeMinority |
|
|
|
MerchantDbeSmall |
|
|
|
MerchantDbeVeteran |
|
|
|
MerchantDbeWoman |
|
|
|
MerchantEmail |
|
|
|
MerchantId |
|
|
|
MerchantMinorityDesc |
|
|
|
MerchantName |
|
|
|
MerchantName2 |
|
|
|
MerchantPhone |
|
|
|
MerchantSoleName |
|
|
|
MerchantState |
|
|
|
MerchantTin |
|
|
|
MerchantZip |
|
|
|
OrigCurrencyCd |
|
|
|
OrigVendorId |
|
|
|
PoNo |
|
|
|
PostDt |
|
Yes |
|
PrItem |
|
|
|
PrNo |
|
|
|
PurchaseId |
|
|
|
PurchaseIdFmt |
|
|
|
ReconcilerId1 |
|
|
|
ReconcilerId2 |
|
|
|
ReconcilerId3 |
|
|
|
ReconcilerId4 |
|
|
|
ReviewDt |
|
|
|
SalesTaxAmt |
|
|
|
SalesTaxAmt2 |
|
|
|
SalesTaxCd |
|
|
|
ShipAmt |
|
|
|
StmtDt |
|
|
|
StmtHolderRef |
|
|
|
TaxReqFlag |
|
|
|
TransAmt |
|
Yes |
|
TransDesc |
|
|
|
TransDtTime |
|
Yes |
|
TransQty |
|
|
|
TransRef |
|
Yes |
|
TransTypeCd |
|
|
|
VendorAddrCd |
|
|
|
VendorId |
|
|