P-Card Statement Import Mapping - APPCUTMP
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 |