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 | ||
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 | ||
PrItem | ||
PrNo | ||
PurchaseId | ||
PurchaseIdFmt | ||
ReconcilerId1 | ||
ReconcilerId2 | ||
ReconcilerId3 | ||
ReconcilerId4 | ||
ReviewDt | ||
SalesTaxAmt | ||
SalesTaxAmt2 | ||
SalesTaxCd |