Per Diem TXT Batch Upload Format

The TXT file fields are separated by double quotes. Following is the definition of each section within a double quote and the field it is loaded into in the Per Diem tables.

Text fields

Per Diem Table Description

CONUS field

OCONUS field

Region Code

State Alpha

Country Code

Region Name

State Name

Country Name

N/A

CONUS indicator

CONUS indicator

Primary Destination

 

Location Name

Location Name

County

Other Location

 

N/A

Time Zone

Time Zone

N/A

Linked to State

Linked Country Code

N/A

Linked Location

Linked Location Name

N/A

DOD Indicator

DOD Indicator

Effective From Date

Effective Date

Effective Date

N/A

Expiration Date

Expiration Date

Season Begin Month and Day

Season Start Date

Season Start Date

N/A

Season End Date

Season End Date

Lodging

Lodging Rate

Lodging Rate

Meals and Incidentals

Local Meals (includes incidentals)

Local Meals (includes incidentals)

N/A

Meals Rate Only (excludes incidentals)

Meals Rate Only (excludes incidentals)

N/A

Proportional Meals Rate

Proportional Meals Rate

N/A

Incidentals

Incidentals

N/A

Footnote reference

Footnote reference

N/A

Footnote Rate

Footnote Rate

N/A

Max Per Diem

Max Per Diem

More:

Travel Agency Data Upload