Attachment J-4.2_ T&E to Financial Management Business Information Exchange.xlsx

XLSX spreadsheet 185 KB Posted Oct 20, 2023

Attached to: E-Gov Travel Service, Next Generation (ETSNext) Travel and Expense (T&E) Technology Managed Service
Solicitation number: 47QMCB23R0011
Issued by: GSA Federal Acquisition Service

About this file

Written by GovTribe AI · Dec 21, 2023

This document provides details regarding a forthcoming solicitation for the E-Gov Travel Service, Next Generation (ETSNext) Travel and Expense (T&E) Technology Managed Service. The solicitation number is 47QMCB23R0011 and will be issued by the General Services Administration Federal Acquisition Service.

The ETSNext program will seek to establish a managed service to provide a cloud-based travel and expense management solution for federal agencies. The solution will include a travel booking and authorization system integrated with an expense management system. It will also incorporate a business intelligence exchange to share travel and expense data across government in support of financial management activities. Pricing will be conducted on a firm-fixed price basis for base and option years of performance. Response and award dates were not specified in this document.

View the file

Other files

File	Type	Posted
A00010_47QMCB23R0011_SF30CORRECTEDSigned_2024-07_16.pdf	PDF	Jul 16, 2024
A00010_47QMCB23R0011_SF30Signed_2024-07-10.pdf	PDF	Jul 10, 2024
Attachment J-10_ETSNext Demonstration ScenariosRev3_2024-05-22.docx	DOCX document	May 22, 2024
A00009_47QMCB23R0011_ETSNextGenerationSF30Signed_2024-05-22.pdf	PDF	May 22, 2024
A00009_47QMCB23R00011_ETSNextGenerationRFP_2024-05-22.pdf	PDF	May 22, 2024
A00008_47QMCB23R0011_SF30Signed_2024-05-17.pdf	PDF	May 20, 2024
A00008_47QMCB23R00011_ETSNextGenerationRFP_2024-05-17.pdf	PDF	May 20, 2024
Attachment J-10_ETSNext Demonstration Scenarios_Rev2024-05-17.docx	DOCX document	May 20, 2024
A00007_47QMCB23R00011_ETSNextGenerationRFP_2024-04-30.pdf	PDF	Apr 30, 2024
A00007_47QMCB23R0011_SF30Signed_2024-04-30.pdf	PDF	Apr 30, 2024
A00006_47QMCB23R00011_ETSNextGenerationRFP_2024-02-13.pdf	PDF	Feb 13, 2024
A00006_47QMCB23R00011_SF30Signed_2024-02-13.docx.pdf	PDF	Feb 13, 2024
47QMCB23R0011_QuestionsandAnswersPart4_2024-01-16.xlsx	XLSX spreadsheet	Jan 16, 2024
A00005_47QMCB23R0011_SF30Signed_2024-01-08.pdf	PDF	Jan 8, 2024
47QMCB23R0011_QuestionsandAnswersPart3_2024-01-04.xlsx	XLSX spreadsheet	Jan 4, 2024
47QMCB23R0011_QandAsPart2Update_2023-12-21.xlsx	XLSX spreadsheet	Dec 21, 2023
A00004_47QMCB23R0011_SF30Signed_2023-12-20.pdf	PDF	Dec 20, 2023
Attachment J-3_ Requirements Traceability Matrix dated 2023-12-20.xlsx	XLSX spreadsheet	Dec 20, 2023
A00004_47QMCB23R00011_ETSNextGenerationRFP_2023-12-20.pdf	PDF	Dec 20, 2023
47QMCB23R0011_QuestionsandAnswersPart2_2023-12-19.xlsx	XLSX spreadsheet	Dec 19, 2023
Attachment J-3_ Requirements Traceability Matrix dated 2023-12-18.xlsx	XLSX spreadsheet	Dec 18, 2023
Attachment J-2 - Performance Requirements Summary dated 12-18-2023.docx	DOCX document	Dec 18, 2023
A00003_47QMCB23R00011_ETSNextGenerationRFP_2023-12-18.pdf	PDF	Dec 18, 2023
A00003_47QMCB23R0011_SF30Signed_2023-12-18.pdf	PDF	Dec 18, 2023
47QMCB23R0011_ETSNextRFPPreProposalConferenceforIndustry_2023-12-07.pdf	PDF	Dec 13, 2023
47QMCB23R0011_ETSNextInterestedPartiesList_2023-12-06.pdf	PDF	Dec 6, 2023
47QMCB23R0011_QuestionswithAnswers_2023-12-05.xlsx	XLSX spreadsheet	Dec 5, 2023
Attachment J-19.1_ETSNext Demonstration Configuration Guidance 2023-12-4.docx	DOCX document	Dec 4, 2023
A00002_47QMCB23R0011_SF30Signed_2023-12-04.pdf	PDF	Dec 4, 2023
Attachment J-3_ Requirements Traceability Matrix dated 2023-12-4.xlsx	XLSX spreadsheet	Dec 4, 2023
A00002_47QMCB23R00011_ETSNextGenerationRFP_2023-12-4.pdf	PDF	Dec 4, 2023
A00001_47QMCB23R0011_SF30Signed_2023-11-09.pdf	PDF	Nov 9, 2023
Attachment J-3_ Requirements Traceability Matrix dated 2023-11-09.xlsx	XLSX spreadsheet	Nov 9, 2023
Attachment J-19.2_Appendix ETSNext Demonstration Configuration Guide 2023-11-9.docx	DOCX document	Nov 9, 2023
Attachment J-19.1_ETSNext Demonstration Configuration Guidance 2023-11-9.docx	DOCX document	Nov 9, 2023
Attachment J-19.3_ MOI Notional User Profiles dated 2023-11-09.xlsx	XLSX spreadsheet	Nov 9, 2023
Attachment J-10_ETSNext Demonstration Scenariosdated 2023-11-09.docx	DOCX document	Nov 9, 2023
Attachment J-15_ Sample Test Case- Domestic Trip.xlsx	XLSX spreadsheet	Oct 20, 2023
Attachment J-9 - TandE Management Business Scenarios.docx	DOCX document	Oct 20, 2023
Attachment J-10_ ETSNext Demonstration Scenarios as of 10_10_23.pdf	PDF	Oct 20, 2023
Attachment J-18_ FedRAMP Security Controls Baseline Tailoring.xlsx	XLSX spreadsheet	Oct 20, 2023
Attachment J-16 Subcontracting Plan Template - Individual-January 2023.docx	DOCX document	Oct 20, 2023
Attachment J-3 -Requirements Traceability Matrix dated 10-16-2023.xlsx	XLSX spreadsheet	Oct 20, 2023
Attachment J-4.3_ FMCF-6 Core FS Pre-Built Business Information Exchanges Release FY2024.xlsx	XLSX spreadsheet	Oct 20, 2023
Attachment J-13_ Travel and Expense Process Flow.docx	DOCX document	Oct 20, 2023
Attachment J-2 - Performance Requirements Summary dated 10-20-2023.docx	DOCX document	Oct 20, 2023
Attachment J-12.1_ GFI - ETSNext Service Blueprint - Domestic Trip_10-11-23.pdf	PDF	Oct 20, 2023
Attachment J-12.6_ GFI - ETSNext Service Blueprint - Short-distance Trip_10-11-23.pdf	PDF	Oct 20, 2023
Attachment J-6 - Existing Governance and Customer Engagement Organizations.docx	DOCX document	Oct 20, 2023
Attachment J-12.3_ GFI - ETSNext Service Blueprint - Domestic Trip w Cancellation_10-11-23.pdf	PDF	Oct 20, 2023

Show 40 more

Latest 50 of 61 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

BIE Principles and Assumptions

TRT-Specific BIE Assumptions
TRT-1	In the TRT Functional Area, an entity (payee) FFM Transaction for the traveler will be generated from Travel Personnel Baseline Profile at the time of travel authorization and voucher to ensure FFM has the most current information on the traveler prior to processing an FFM Transaction. An entity (payee) FFM Transaction will not need to be generated by the TRT Functional Area for charge card issuer companies because when the government establishes the contract with the charge card issuer company, they are required to establish their entity and payment information in GSA SAM. This information can be retrieved by FFM using the Unique Entity Identifier (UEI) provided by the TRT Functional Area.
TRT-2	In the TRT Functional Area, every type of Travel Authorization (i.e., Unlimited Open, Limited Open, Individual Trip-by-Trip, and Group Trip-by-Trip) will generate a funds obligation FFM Transaction.

• Under Unlimited Open and Limited Open Travel Authorizations, there are no further travel authorizations for a specific trip; the traveler can submit multiple Travel Advance Vouchers and TDY Travel Vouchers for one or more trips against the open travel authorization.

• Under an Individual Trip-by-Trip Travel Authorization, individuals can submit multiple Travel Advance Vouchers and a single TDY Travel Voucher (subsequent TDY Travel Vouchers will amend the traveler's previously approved TDY Travel Voucher).

• Under a Group Trip-by-Trip Travel Authorization, a list of travelers will be included in the travel authorization, however estimated travel expenses will not be broken down by traveler. Therefore, the funds obligation FFM Transaction for a Group Trip-by-Trip Travel Authorization will include a generic payee. Individual travelers can submit multiple Travel Advance Vouchers and a single TDY Travel Voucher (subsequent TDY Travel Vouchers will amend the traveler's previously approved TDY Travel Voucher). The vouchers will provide the specific payee information for the associated payable FFM Transaction.

TRT-3	In the TRT Functional Area, once travel authorizations or TDY Travel Vouchers are approved, if subsequent changes are required, they would be amended instead of updated and the amendment will generate an FFM Transaction; in these cases, the TRT solution/service will store documentation of both the original document and amendment for traceability and auditing purposes. Travel Advance Vouchers and Local Vouchers cannot be amended (changed or updated) after approval.
TRT-4	If a trip is canceled after the travel authorization is approved and expenses have incurred, but prior to trip departure, a TDY Travel Voucher will be submitted for the amount of residual fees (e.g., transaction fees, cancelation fees) and generate a payable FFM Transaction at the time the TDY Travel Voucher is approved. A travel authorization amendment indicating the trip was canceled will be created and generate a funds obligation FFM Transaction with a negative amount to de-obligate the remaining funds.
TRT-5	In the TRT Functional Area, an accrual FFM Transaction will not be generated at the time a traveler incurs expenses; however, a payable FFM Transaction will be generated at the time a TDY Travel Voucher or Local Voucher is approved.
TRT-6	Local Vouchers used to reimburse federal employees for expenses, such as, telephone, local transportation, office supplies, or professional liability insurance will generate a payable FFM Transaction that does not have an associated Travel Authorization (obligation) document (similar to an acquisition micro-purchase). If the business unit wants to reserve funds for Local Vouchers, it will be executed using the FM solution/service.
TRT-7	Line items in TDY Travel Vouchers for travel expenses paid via a Centrally Billed Account (CBA) charge card will not generate a payable FFM Transaction (or liquidate the previous line item obligation). Payables to CBA charge card companies (and obligation liquidation) will be initiated in the FM solution/service based on government receipt of charge card issuer billing statements.
TRT-8	Line items in TDY Travel Vouchers for travel expenses paid via a Government Transportation Request (GTR) will not generate a payable FFM Transaction (or liquidate the previous line item obligation). A payable to the transportation vendor (and obligation liquidation) will be initiated in the FM solution/service when the vendor submits the GTR invoice to the Federal government for reimbursement.
TRT-9	Line items in TDY Travel Vouchers for travel expenses paid via an Individually Billed Account (IBA) government-issued travel card will generate a payable FFM Transaction specifying the payee as the traveler's charge card issuer company identified in the Travel Personnel Profile Information. A separate payable FFM Transaction will be generated for line items indicating cash travel expenses (e.g., tips, tolls) to be reimbursed to the Federal traveler; the method of payment to the traveler (e.g., ACH, check) and traveler's bank account information will be provided from the Travel Personnel Profile Information.
TRT-10	Line items in TDY Travel Vouchers for travel expenses paid via a Non-Federal Source Payment Type of "In Kind" will not generate a payable FFM Transaction since the expense was paid directly to the vendor by the Non-Federal Source entity (e.g., hotel room expense), but will generate a funds obligation FFM Transaction with a negative amount to de-obligate the funds reserved in case the Non-Federal Source did not pay for the expense.

When a Non-Federal Source will reimburse an agency for a travel expense, the travel expenses must first be paid via CBA, IBA, or cash and generate the associated FFM Transactions. Reconciliation of travel expenses with any reimbursement to the Federal agency will be performed outside of the TRT solution/service and any necessary payable or receivable transactions will be executed using the FM solution/service.

TRT-11 Travel Advance Vouchers and TDY Travel Vouchers may be processed before, during, or upon completion of official travel.

• A Travel Advance Voucher submitted before travel begins may be used to pay for anticipated expenses. The traveler will identify the associated travel authorization expense line item for which the travel advance is required and the payee must be the traveler (i.e., cannot be an IBA). One or more TDY Travel Vouchers will later be submitted and will indicate which Travel Advance Voucher line items have now been expensed by the traveler.

• A TDY Travel Voucher submitted before travel begins may also be used for reimbursement of expenses incurred prior to travel (e.g., payment for a room deposit) and the payee may be the traveler, an IBA, or a CBA.

• A TDY Travel Voucher may be used during travel for reimbursement of expenses incurred while in a continuous travel status and the payee may be the traveler, an IBA, or a CBA.

• A TDY Travel Voucher submitted upon completion of a trip will be used to reimburse expenses incurred and the payee may be the traveler, an IBA, or a CBA.

• All types of vouchers will generate a payable FFM transaction; however, TDY Travel Vouchers that indicate the expensing of a previously received travel advance will not result in a new disbursement of funds to the traveler but rather the expensinig of the previously disbursed travel advance funds.

TRT-12	When a travel authorization is canceled or amended because estimated amount of expenses is decreased and a travel advance in excess of the canceled or amended travel authorization was issued to the traveler, a receivable FFM transaction will be generated in addition to the de-obligation FFM transaction.
TRT-13	If an audit identifies an overpayment to a traveler, any receivables and associated payments (collections) from travelers (also known as a "Due U.S.") will be executed using the FM solution/service, not the TRT solution/service.
TRT-14	Determination of Federal employee taxes and payroll deductions for long term travel will be performed by the HCM compensation (payroll) function and not the FFM Functional Area. The HCM payroll information provided to FFM will include summarized tax withholding/payroll deduction information.

47QMCB23R0009 - Draft RFP - ETSNext Generation

Page &P of &N	&F
&A	Date: June 23, 2023

TRT-FFM BIE

Entity - Payee/Payer Maintenance

Requisition - Commitment

Order - Obligation

Receipt and Acceptance - Accrual

Invoice - Payable

Billing Invoice - Receivable

Public Receipt - Collection

Journal Voucher

FIBF FFM: Data Element Label

FIBF FFM: Data Element Definition

FIBF FFM: Data Group Name

FIBF FFM: Domain Values

BIE: Applicable FFM Transaction Type(s)

BIE: Required/Optional/Conditional

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules)

FIBF TRT:

Data Element Label

FIBF TRT-FFM:

BIE Logic (Business Rules) AgencyTransactionIdentifier The identifier an agency provides for a transaction. FFM Transaction Information Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher

Required

AgencyTransactionIdentifier

Generated and stored by the TRT solution/service at the time of FFM Transaction creation.

N/A

AgencyTransactionIdentifier

Generated and stored by the TRT solution/service at the time of FFM Transaction creation.

N/A

AgencyTransactionIdentifier

Generated and stored by the TRT solution/service at the time of FFM Transaction creation.

AgencyTransactionIdentifier

Generated and stored by the TRT solution/service at the time of FFM Transaction creation.

N/A

FinancialTransactionTypeCode

A code that identifies the type of transaction generated by a source system and processed by a financial management system.

FFM Transaction Information

Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher-Accrual;

Journal Voucher-Asset;

Journal Voucher-Payroll Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher

Required

N/A

Always set to "Entity-Payee/Payer Maintenance" for this transaction type

N/A

Always set to "Order-Obligation" for this transaction type

N/A

Always set to "Invoice-Payable" for this transaction type

N/A

Always set to "Billing Invoice-Receivable" for this transaction type

N/A

TransactionIdentificationDate

The date of the transaction (ex. Deposit date of a payment, effective date of the adjustment, etc.). It is the effective date of the transaction.

FFM Transaction Information

Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher	Required	TravelAuthorizationStatusDate;
TravelAuthorizationStatusTypeName	Use the TravelAuthorizationStatusDate when the associated TravelAuthorizationStatusTypeName is equal to "Approved"	N/A	N/A	TravelAuthorizationStatusDate;
TravelAuthorizationStatusTypeName	Use the TravelAuthorizationStatusDate when the associated TravelAuthorizationStatusTypeName is equal to "Approved"	N/A	N/A	VoucherStatusDate;
VoucherStatusTypeName	Use the VoucherStatusDate when the associated VoucherStatusTypeName is equal to "Approved"	TravelAuthorizationStatusDate;
TravelAuthorizationStatusTypeName	Use the amended travel authorizaton's TravelAuthorizationStatusDate when the associated TravelAuthorizationStatusTypeName is equal to "Approved"	N/A	N/A	N/A	N/A
	DocumentReferenceNumber
	Details a unique identifying number created by a system for a document, e.g., payment or collection document.	FFM Transaction Information;
Reimbursable Performance Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher

Required

TravelAuthorizationID

Direct mapping

N/A

TravelAuthorizationID

Direct mapping

N/A

VoucherID

Direct mapping

VoucherID

Direct mapping from the travel advance voucher

N/A

SourceDocumentDescription

A brief description associated with the source document (e.g., requisition, order, or invoice).

FFM Transaction Information

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher Conditional: Required when the information is available N/A N/A N/A N/A TravelAuthorizationTypeName Direct mapping : [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Eric: would you want to augment the TRT domain values? Eg "Unlimited Open" = "Unlimited open travel authorization"?	N/A	N/A	VoucherTypeName	Direct mapping	N/A	Always set to "Travel advance in excess of expenses"	N/A	N/A	N/A	N/A
	SourceDocumentModificationIdentifier	An identifier issued by an agency that uniquely identifies a modification or amendment to an order, reimbursable agreement, travel authorization, etc.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher

Conditional: Required when the source document is a modification or amendment to the original document

TravelAuthorizationAmendmentID

Direct mapping

N/A

TravelAuthorizationAmendmentID

Direct mapping

N/A

VoucherAmendmentID

Direct Mapping

N/A

PrecedingSourceDocumentIdentifier

An identifier that references the preceding document in the lifecycle, e.g., if the current document is a travel voucher, this would reference the travel authorization.

FFM Transaction Information

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Public Receipt-Collection;

Journal Voucher Conditional: Required when the FFM Transaction Type has a preceding FFM Transaction Type that needs to be liquidated, e.g., a "Requisition-Commitment" transaction needs to be liquidated by a subsequent "Order-Obligation" N/A N/A N/A N/A N/A Travel Authorization is the first document in the travel lifecycle N/A N/A VoucherTypeName;

TravelAuthorizationID;

VoucherID If VoucherTypeName is "Local Voucher", then leave blank;

If VoucherTypeName is "Travel Advance Voucher" then direct mapping from TravelAuthorizationID;

If VoucherTypeName is "TDY Travel Voucher" and the TDY Travel Voucher references a Travel Advance Voucher, then direct mapping from Travel Advance Voucher's VoucherID; otherwise, direct mapping from TravelAuthorizationID

TravelAuthorizationID

Direct mapping

N/A

ReceivableNetCollectionTerms

This is the term for the billing invoice which indicates the collection terms. Example would be Net 30, which indicates that a collection process happens within the agency to collect monies owed before finance charges take effect, or before the collection is considered past due.

FFM Transaction Information

Billing Invoice - Receivable

Required

N/A

Always set to "Net 30 days"

N/A

LegalEntityIdentifier

An identifier that uniquely identifies the entity.

FFM Transaction Information

Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher Conditional: Required when FinancialTransactionTypeCode is "Entity - Payee/Payer Maintenance", "Receipt and Acceptance - Accrual", "Invoice - Payable", "Billing Invoice - Receivable", and "Public Receipt - Collection";

Optional when FinancialTransactionTypeCode is "Requisition-Commitment", "Order - Obligation", and "Journal Voucher"	TravelPersonnelPayeeID	Direct mapping	N/A	N/A	TravelAuthorizationTypeName;
TravelPersonnelPayeeID	If TravelAuthorizationTypeName is "Group Trip-by-Trip", then default to generic payee; otherwise, direct mapping	N/A	N/A	TravelExpensePaymentMethodTypeName;

ChargeCardIssuerIdentifier;

TravelPersonnePayeelID

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then direct mapping from ChargeCardIssuerIdentifier;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from TravelPersonnelPayeeID;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

TravelPersonnelPayeeID	Direct mapping from the travel advance voucher	N/A	N/A	N/A	N/A
LegalEntityIdentifierTypeCode	The code that identifies the type of legal entity identifier.	FFM Transaction Information	DUNS Number;

Employer Identification Number (EIN);

Individual Taxpayer Identification Number (ITIN);

Other;

Preparer Taxpayer Identification Number (PTIN) Social Security Number (SSN);

Tax Identification Number (TIN);

Taxpayer Identification Number for Pending U.S. Adoptions (ATIN) Traveler Personnel ID;

Unique Entity Identifier (UEI)

NOTE: References to DUNS have been retained to accommodate historical data

Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Optional when FinancialTransactionTypeCode is "Requisition-Commitment", "Order - Obligation", and "Journal Voucher" N/A Always set to "Traveler Personnel ID" N/A N/A N/A If TravelAuthorizationTypeName is "Group Trip-by-Trip", then leave blank; otherwise, set to "Traveler Personnel ID" N/A N/A TravelExpensePaymentMethodTypeName If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then set to "Unique Entity Identifier (UEI)";

If TravelExpensePaymentMethodTypeName is "Cash", then set to "Traveler Personnel ID";

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

N/A	Always set to "Traveler Personnel ID"	N/A	N/A	N/A	N/A
LegalEntityOrganizationName	The name of the organization associated with the entity identifier.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher Conditional: Required when FinancialTransactionTypeCode is "Entity - Payee/Payer Maintenance", "Order - Obligation", "Receipt and Acceptance - Accrual", "Invoice - Payable", "Billing Invoice - Receivable", and "Public Receipt - Collection" when the legal entity is a business or government organization (LegalEntityTypeCode is "Business", "Educational Institution", "Federal Government", "Foreign/Soverign Government", "State/Local Government", or "Tribal Government");

Optional when FinancialTransactionTypeCode is "Requisition-Commitment" and "Journal Voucher"	N/A
	N/A	N/A	N/A	N/A
	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
ChargeCardIssuerName	If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then direct mapping from ChargeCardIssuerName;

If TravelExpensePaymentMethodTypeName is "Cash", then leave blank;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

N/A	N/A	N/A	N/A	N/A	N/A
LegalEntityDBAName	The name that an organization is using to do business.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Journal Voucher	Optional	N/A
	N/A	N/A	N/A	N/A
	N/A	N/A	N/A	N/A
	N/A	N/A	N/A	N/A	N/A	N/A	N/A
	PersonGivenName	A first name of a person.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Optional when FinancialTransactionTypeCode is "Requisition-Commitment" and "Journal Voucher" PersonGivenName Direct mapping N/A N/A PersonGivenName Direct mapping N/A N/A PersonGivenName If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

PersonGivenName	Direct mapping from the travel advance voucher	N/A	N/A	N/A	N/A
PersonMiddleName	A middle name of a person.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Optional when FinancialTransactionTypeCode is "Requisition-Commitment" and "Journal Voucher" PersonMiddleName Direct mapping N/A N/A PersonMiddleName Direct mapping N/A N/A PersonMiddleName If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

PersonMiddleName	Direct mapping from the travel advance voucher	N/A	N/A	N/A	N/A
PersonSurName	A last name or family name of a person.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Optional when FinancialTransactionTypeCode is "Requisition-Commitment" and "Journal Voucher" PersonFamilyName Direct mapping N/A N/A PersonFamilyName Direct mapping N/A N/A PersonFamilyName If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

PersonFamilyName	Direct mapping from the travel advance voucher	N/A	N/A	N/A	N/A
PersonNameSuffixText	A term appended after the family name that qualifies the name.	FFM Transaction Information		Entity-Payee/Payer Maintenance;

Requisition-Commitment;

Order-Obligation;

Receipt and Acceptance-Accrual;

Invoice-Payable;

Billing Invoice-Receivable;

Public Receipt-Collection;

Optional when FinancialTransactionTypeCode is "Requisition-Commitment" and "Journal Voucher" PersonSuffixName Direct mapping N/A N/A PersonSuffixName Direct mapping N/A N/A PersonSuffixName If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

PersonSuffixName

Direct mapping from the travel advance voucher

N/A

EmailAddressText

The email address for the party involved in the transaction.

FFM Transaction Information

Entity-Payee/Payer Maintenance

Optional

EmailAddressName

Direct mapping

N/A

AddressTypeCode

The code that identifies the type of address, e.g., shipping or billing.

FFM Transaction Information;

Reimbursable Order Information

Billing;

Shipping;

Mailing;

Physical

Entity-Payee/Payer Maintenance

Required

TravelPersonnelProfileLocationTypeName

Direct mapping

N/A

LegalEntityAddressLine1

First line of where the legal entity's legal address is located.

FFM Transaction Information;

Reimbursable Order Information

Entity-Payee/Payer Maintenance

Required

TravelPersonnelProfileMailingAddress1Text

Direct mapping

N/A

LegalEntityAddressLine2

Second line of where the legal entity's legal address is located.

FFM Transaction Information;

Reimbursable Order Information

Entity-Payee/Payer Maintenance

Optional

TravelPersonnelProfileMailingAddress2Text

Direct mapping

N/A

LegalEntityAddressLine3

Third line of where the legal entity's legal address is located.

FFM Transaction Information;

Reimbursable Order Information

Entity-Payee/Payer Maintenance

Optional

N/A

LegalEntityCityCode

Code for the city in which the legal entity's domestic address is located.

FFM Transaction Information;

Reimbursable Order Information

Use Census for city code: https://www.census.gov/library/reference/code-lists/ansi.html

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACEFP". Also extract "STATEFP" because city codes are not unique across states

NOTE: The Census city file contains city codes for both U.S. states and territories

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileDomesticCityCode

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityCityName

Name of the city in which the legal entity's domestic address is located.

FFM Transaction Information;

Reimbursable Order Information

Use Census for city name: https://www.census.gov/library/reference/code-lists/ansi.html

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACENAME"

NOTE: The Census city file contains city names for both U.S. states and territories

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileDomesticCityName

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityStateOrTerritoryCode

Code for the state or territory in which the legal entity's domestic address is located.

FFM Transaction Information;

Reimbursable Order Information

Use Census for state and territory code: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "STATE"

NOTE: The Census state file contains both U.S. states and territories

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileDomesticStateOrTerritoryCode

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityStateOrTerritoryName

Name of the state or territory in which the legal entity's domestic address is located.

FFM Transaction Information

Use Census for state and territory name: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "NAME"

NOTE: The Census state file contains both U.S. states and territories

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileDomesticStateOrTerritoryName

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityZIP5Number

USPS five digit zoning code associated with the legal entity's domestic address.

FFM Transaction Information

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileZIPPostalCode

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityZIPLast4Number

USPS four digit extension code associated with the legal entity's domestic address.

FFM Transaction Information

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located in a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfile+4PostalCode

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityCountyCode

A code for the county in which the legal entity's domestic address is located.

FFM Transaction Information

Use Census for county code: https://www.census.gov/library/reference/code-lists/ansi.html

Navigate to the section "County and County Equivalents". Select "United States" from the dropdown menu. Download text file. Extract "COUNTYFP". Also extract "STATEFP" because county codes are not unique across states

NOTE: The Census county file contains counties for both U.S. states and territories Entity-Payee/Payer Maintenance Conditional: Required when entity's legal address is located in a US state TravelPersonnelProfileCountryCode;

TravelPersonnelProfileZipPostalCode;

TravelPersonnelProfile+4PostalCode

If TravelPersonnelProfileCountryCode is other than "840" (USA), then leave blank; otherwise; use TravelPersonnelProfileZipPostalCode and TravelPersonnelProfile+4PostalCode crosswalk to derive LegalEntityCountyCode

N/A

LegalEntityCountyName

A name for the county in which the legal entity's domestic address is located.

FFM Transaction Information

Use Census for county name: https://www.census.gov/library/reference/code-lists/ansi.html

Navigate to the section "County and County Equivalents". Select "United States" from the dropdown menu. Download text file. Extract "COUNTYNAME"

TravelPersonnelProfileZipPostalCode;

TravelPersonnelProfile+4PostalCode

N/A

LegalEntityCountryCode

Code for the country in which the legal entity's legal address is located.

FFM Transaction Information;

Reimbursable Order Information

Use National Geospatial-Intelligence Agency - GENC

API: https://nsgreg.nga.mil/restApi/GeopoliticalEntityResources.jsp

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Numeric Code"

Entity-Payee/Payer Maintenance

Required

TravelPersonnelProfileCountryCode

Direct mapping

N/A

LegalEntityCountryName

Name of the country in which the legal entity's legal address is located.

FFM Transaction Information

Use National Geospatial-Intelligence Agency - GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" to download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Name"

Entity-Payee/Payer Maintenance

Required

TravelPersonnelProfileCountryName

Direct mapping

N/A

LegalEntityForeignCityCode

Code for the city in which the legal entity's foreign address is located.

FFM Transaction Information;

Reimbursable Order Information

Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located outside of a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileForeignCityCode

If TravelPersonnelProfileCountryCode is "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityForeignCityName

Name of the city in which the legal entity's foreign address is located.

FFM Transaction Information;

Reimbursable Order Information

Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes" and use the column titled "City Name"

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located outside of a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileForeignCityName

If TravelPersonnelProfileCountryCode is "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityForeignSubdivisionCode

Code for the country's subdivsion (e.g., state, provice, locality) in which the legal entity's foreign address is located.

FFM Transaction Information

Use National Geospatial-Intelligence Agency -

GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "6-character Code"

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located outside of a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileForeignStateCode

If TravelPersonnelProfileCountryCode is "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityForeignSubdivisionName

Name for the country's subdivsion (e.g., state, provice, locality) in which the legal entity's foreign address is located.

FFM Transaction Information

Use National Geospatial-Intelligence Agency -

GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "Administrative Subdivision Preferred Name"

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located outside of a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileForeignStateName

If TravelPersonnelProfileCountryCode is "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityForeignPostalCode

Postal code in which legal entity's foreign address is located.

FFM Transaction Information;

Reimbursable Order Information

Entity-Payee/Payer Maintenance

Conditional: Required when entity's legal address is located outside of a US state or territory

TravelPersonnelProfileCountryCode;

TravelPersonnelProfileForeignPostalCode

If TravelPersonnelProfileCountryCode is "840" (USA), then leave blank; otherwise direct mapping

N/A

LegalEntityTypeCode

The category of the entity regardless of the type of financial transaction conducted.

FFM Transaction Information

Business;

Educational Institution;

Federal Government;

Foreign/Sovereign Government;

Individual;

State/Local Government;

Tribal Government

Entity-Payee/Payer Maintenance

Required

N/A

Always set to "Individual"

N/A

InternalRevenueService1099Indicator

Determines if the entity is IRS Form 1099 eligible. The Form 1099 is used to report payments to independent contractors, rental property income, income from interest and dividends, sales proceeds, and other miscellaneous income.

FFM Transaction Information

No;

Yes

Entity-Payee/Payer Maintenance

Required

N/A

Always set to "No"

N/A

PaymentMethod

Contains the mechanism of the payment.

FFM Transaction Information;

Banking Information

Domestic ACH;

Domestic Wire Transfer;

International ACH;

International Wire Transfer;

Other;

Treasury Check Entity-Payee/Payer Maintenance;

Invoice-Payable Required PaymentMethod Direct mapping from the Travel Personnel Baseline Profile N/A N/A N/A N/A N/A N/A TravelExpensePaymentMethodTypeName;

PaymentMethod If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then set to "Domestic ACH";

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from PaymentMethod;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

N/A	N/A	N/A	N/A	N/A	N/A
BankIdentifier	A code established by international standard (ISO 9362). It provides an identifier for institutions within the financial services industry to facilitate automated processing of telecommunication messages in banking and related financial transaction environments.

NOTE: ISO refers to this as the Business Identifier Code or BIC.	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance;

Invoice-Payable Conditional: Required when PaymentMethod is "International ACH" or “International Wire Transfer”

Optional when PaymentMethod is "Domestic ACH" and "Domestic Wire"	BusinessIdentifierCode	Direct mapping from the Travel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
BusinessIdentifierCode	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from BusinessIdentifierCode;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	RoutingTransitNumber	The 9-digit account number assigned by the American Banking Association that the bank or the financial institution has with the Federal Reserve.	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance;

Invoice-Payable

	Conditional: Required when PaymentMethod is “Domestic ACH” or “Domestic Wire Transfer”	RoutingTransitNumber	Direct mapping from the Travel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
RoutingTransitNumber	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from RoutingTransitNumber;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	BankName	The name of the financial institution.	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance;

Invoice-Payable

	Conditional: Required when PaymentMethod is “Domestic ACH”, "International ACH", “Domestic Wire Transfer”,
or “International Wire Transfer”	BankName	Direct mapping from the TTravel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
BankName	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from BankName;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	BankAccountTypeCode	The code that identifies the type of account associated with the transaction, such as checking or savings.	FFM Transaction Information;
Banking Information	Checking;
Savings	Entity-Payee/Payer Maintenance;

Invoice-Payable

	Conditional: Required when PaymentMethod is “Domestic ACH”, "International ACH", “Domestic Wire Transfer”,
or “International Wire Transfer”	BankAccountTypeCode	Direct mapping from the Travel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
BankAccountTypeCode	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from BankAccountTypeCode;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	DomesticBankAccountNumber	The domestic account number at the financial institution involved in the transaction. Also referred to as a Basic Bank Account Number (BBAN).	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance;

Invoice-Payable

	Conditional: Required when PaymentMethod is “Domestic ACH” or “Domestic Wire Transfer”	BasicBankAccountNumber	Direct mapping from the Travel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
BasicBankAccountNumber	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from BasicBankAccountNumber;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	InternationalBankAccountNumber	An international bank account number (IBAN) at the financial institution involved in the transaction. This is an expanded version of the Basic Bank Account Number (BBAN).	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance;

Invoice-Payable

	Conditional: Required when PaymentMethod is “International ACH” or “International Wire Transfer”	InternationalBankAccountNumber	Direct mapping from the Travel Personnel Baseline Profile	N/A	N/A	N/A	N/A	N/A	N/A	TravelExpensePaymentMethodTypeName;
InternationalBankAccountNumber	If TDY Travel Voucher references a Travel Advance Voucher, then leave blank;

If TravelExpensePaymentMethodTypeName is "Centrally Billed Account (CBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Individually Billed Account (IBA)", then leave blank;

If TravelExpensePaymentMethodTypeName is "Cash", then direct mapping from InternationalBankAccountNumber;

If TravelExpensePaymentMethodTypeName is "Government Transportation Request (GTR)", then leave blank

	N/A	N/A	N/A	N/A	N/A	N/A
	PaymentMethod2	Contains the mechanism of the payment.	FFM Transaction Information;
Banking Information	Domestic ACH;

Domestic Wire Transfer;

International ACH;

International Wire Transfer;

Other;

Treasury Check

Entity-Payee/Payer Maintenance

Optional: Used if an agency allows more than one payment method on an payee's entity record

N/A

Bank2Identifier

A code established by international standard (ISO 9362). It provides an identifier for institutions within the financial services industry to facilitate automated processing of telecommunication messages in banking and related financial transaction environments.

NOTE: ISO refers to this as the Business Identifier Code or BIC.	FFM Transaction Information;
Banking Information		Entity-Payee/Payer Maintenance
	Conditional: Required when PaymentMethod2 is "International ACH" or “International Wire Transfer”

Optional when PaymentMethod2 is "Domestic ACH" and "Domestic Wire"

N/A

RoutingTransit2Number

The 9-digit account number assigned by the American Banking Association that the bank or the financial institution has with the Federal Reserve.

FFM Transaction Information;

Banking Information

Entity-Payee/Payer Maintenance

Conditional: Required when PaymentMethod2 is “Domestic ACH” or “Domestic Wire Transfer”

N/A

Bank2Name

The name of the financial institution.

FFM Transaction Information;

Banking Information

Entity-Payee/Payer Maintenance

Conditional: Required when PaymentMethod2 is “Domestic ACH”, "International ACH", “Domestic Wire Transfer”,

or “International Wire Transfer”

N/A

BankAccount2TypeCode

The code that identifies the type of account associated with the transaction, such as checking or savings.

FFM Transaction Information;

Banking Information

Checking;

Savings

Entity-Payee/Payer Maintenance

Conditional: Required when PaymentMethod2 is “Domestic ACH”, "International ACH", “Domestic Wire Transfer”,

or “International Wire Transfer”

N/A

DomesticBankAccount2Number

The domestic account number at the financial institution involved in the transaction. Also referred to as a Basic Bank Account Number (BBAN).

FFM Transaction Information;

Banking Information

Entity-Payee/Payer Maintenance

Conditional: Required when PaymentMethod2 is “Domestic ACH” or “Domestic Wire Transfer”

N/A

InternationalBankAccount2Number

An international bank account number (IBAN) at the financial institution involved in the transaction. This is an expanded version of the Basic Bank Account Number (BBAN).

FFM Transaction Information;

Banking Information

Entity-Payee/Payer Maintenance

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Oct 20, 2023.