Invoice fields data dictionary
This data dictionary defines the fields used in the invoice data model. It provides clear descriptions, examples, and default indicators for each field to ensure consistent interpretation and use across systems, reporting, and integrations. The dictionary serves as a reference for understanding invoice structure, data sources, and field behavior.
| Field Name | Description | Example | Default Field |
|---|---|---|---|
Invoice Date |
Date when the invoice was generated (statement date) |
11-Dec-2025 |
Yes |
Billing Period End Date |
Final date of the billing period; all approved items on or before this date are included in the invoice |
7-Dec-2025 |
Yes |
Invoice ID |
System-generated unique identifier for the consolidated invoice |
2532 |
Yes |
Invoice Type |
Indicates invoice type: Preliminary (PI), a draft, or Final (FI) for payment processing |
PRELIMINARY |
Yes |
Invoice Line Item ID |
Unique identifier for each invoice line item |
TS_1093_2025-06-30_874ae1ae |
Yes |
Financial Record Type |
Specifies the type of billed record (timesheet, expense, milestone) |
Timesheet |
Yes |
Supplier Name |
Name of the supplier providing the service or resource |
Staffing Supplier A |
Yes |
Payment Terms |
Agreed payment terms with the supplier, for example, Net 15, Net 30 |
NET_15 |
Yes |
Worker Name |
Name of the individual performing the work |
Worker Name |
Yes |
Engagement ID |
Unique identifier for the worker engagement |
1023-000001 |
Yes |
Engagement Job Profile |
Job title associated with the worker’s engagement |
Software Developer |
Yes |
Hiring Manager Name |
Name of the manager overseeing the engagement |
Manager Name |
Yes |
Cost Center Name |
Name of the finance cost center associated with the line item |
CC Admin |
Yes |
Cost Center Code |
Unique code identifying the cost center |
123456 |
Yes |
Company Code |
System identifier for company entity; engagements source for time/expense data types |
masters |
Yes |
Company Code |
System identifier for company entity; contracts source for milestone data types |
masters |
Yes |
Company Name |
Legal or operating company name; engagements source for time/expense data types |
Masters Industries |
Yes |
Company Name |
Legal or operating company name; contracts source for milestone data types |
Masters Industries |
Yes |
Timesheet ID |
Unique identifier for the timesheet record |
2036 |
Yes |
Weekending Date |
Last date of item’s reporting week, based on BP week start configuration |
2025-08-23 00:00:00 |
Yes |
Spend Date |
Date when the work or expense occurred |
18-Aug-2025 |
Yes |
Time Code Name |
Type of time recorded, for example, regular, overtime |
Regular |
Yes |
Hours |
Total hours recorded for the timesheet entry |
7.55 |
Yes |
Allocation Rate |
Calculated rate applied to hours worked in numeric only format |
75 |
Yes |
Rate Frequency |
Rate frequency, for example, hourly, daily |
HOURLY |
Yes |
Timesheet Status |
Current status of the timesheet, for example, approved, invoiced |
INVOICE_PENDING |
Yes |
Expense ID |
Unique identifier for the expense entry |
1896.0 |
Yes |
Expense Category |
General category of the expense, for example, travel |
fuel |
Yes |
Expense Type |
Indicates whether the expense is worker-specific or general supplier expense |
WORKER_EXPENSE |
Yes |
Expense Name |
Name of the expense item |
Fuel |
Yes |
Vendor |
Vendor associated with the expense. |
test vendor expense merchant |
Yes |
Expense Status |
Current status of the expense, for example, approved, invoiced |
INVOICE_PENDING |
Yes |
Milestone ID |
Unique identifier for the milestone |
33 |
Yes |
Milestone Name |
Descriptive name of the milestone |
Development |
Yes |
Completed Date |
Date the milestone was completed |
2025-10-31 00:00:00 |
Yes |
Contract ID |
Unique identifier for the associated contract |
12 |
Yes |
Contract Title |
Title or name of the associated contract |
Sunset App Project |
Yes |
Approval Date |
Date the item was approved |
10-Dec-2025 |
Yes |
Approving Manager |
Name of the person who approved the item |
Manager Name |
Yes |
Currency |
Currency used for financial amounts |
USD |
Yes |
Unit |
Quantity for invoicing, for example, hours or fixed cost |
7.55 |
Yes |
Unit of Measure |
Unit type for invoicing, for example, hourly, fixed fee |
Hourly |
Yes |
Adjustment |
Indicates whether the record is an adjustment (Yes/No) |
No |
Yes |
Adjustment Type |
Classification of the adjustment (Credit or Debit) |
Debit |
Yes |
Gross Amount |
Total monetary value, excludes fees or taxes in numeric only format |
600 |
Yes |
Total Fees |
Total additional fees applied in numeric only format |
48 |
Yes |
Total Taxes |
Total tax amount applied in numeric only format |
30 |
Yes |
Client Amount |
Net amount billed to the client (numeric format) |
630 |
Yes |
Supplier Amount |
Net amount due to the supplier (numeric format) |
582 |
Yes |
Workday Worker Reference ID |
Internal identifier for the worker in Workday |
b3d8a3f7-1a2b-4c5d-8e9f-0a1b2c3d4e5f |
No |
Legal First Name |
Worker’s legal first name |
First |
No |
Legal Middle Name |
Worker’s legal middle name |
Middle |
No |
Legal Last Name |
Worker’s legal last name |
Last |
No |
Worker ID |
Unique identifier assigned to the worker in the system |
1023.0 |
No |
PO Number |
Purchase order number associated with the engagement |
PO-2024-00123 |
No |
Supplier Reference ID |
Internal supplier identifier from the supplier profile |
Supplier_A |
No |
Approving Manager Work Email |
Email address of the approving manager |
No |
|
Engagement Accountable Person Name |
Name of the person accountable for the engagement |
Person Name |
No |
Approval Time |
Time when the item was approved |
18:15 |
No |
Rate Code |
Code representing the rate type |
bill_rate |
No |
Allocation Rate Formatted |
Calculated rate applied to hours worked, formatted with currency |
75.00 USD |
No |
Gross Amount Formatted |
Total amount excluding fees or taxes, formatted with currency |
600.00 USD |
No |
Client Amount Formatted |
Net amount billed to client, formatted with currency |
582.00 USD |
No |
Supplier Amount Formatted |
Net amount due to supplier, formatted with currency |
630.00 USD |
No |
<All Engagement Rates> |
Numeric value of the rate (bill rate, overtime rate, pay rate, etc.) applied to the engagement |
75 |
No |
<All Engagement Rates> Frequency |
Frequency of rate applied to the engagement, for example, hourly, daily |
Hourly |
No |
<All Engagement Rates> Formula |
Formula for calculating billed amount for the line item |
75.00 / hr |
No |
<All Engagement Rates> Calculated |
Calculated allocation amount with currency, for example, 600.00 USD = rate x hours |
600.00 USD |
No |
<All Engagement Fees> |
Numeric fee (client fee, VMS fee) applied to engagement |
30 |
No |
<All Engagement Fees> Formula |
Formula for calculating fee amount |
-0.02 x bill_rate |
No |
<All Engagement Fees> Calculated |
Calculated fee amount with currency |
30.00 USD |
No |
<All Engagement Taxes> |
Numeric tax (State tax, VAT tax) applied to engagement |
64 |
No |
<All Engagement Taxes> Formula |
Formula for calculating tax amount |
0.15 x bill_rate |
No |
<All Engagement Taxes> Calculated |
Calculated tax amount with currency |
64.00 USD |
No |
Supplier Invoice ID |
Unique identifier for each supplier invoice line item in the consolidated invoice |
1984_dfd69f |
No |
Bill Frequency |
Billing frequency defined in the invoice blueprint, for example, weekly, monthly |
WEEKLY |
No |
Invoice Name |
System-generated name for the consolidated invoice |
PI_blueprint name_Bill_End_20251207_Ran_20251211_185829 |
No |
Supplier Invoice Name |
System-generated name for the supplier invoice portion of the consolidated invoice |
PI_blueprint name_Bill_End_20251207_Ran_20251211_185829_3fcf94 |
No |
Time Code |
Code representing the type of time recorded, for example, REG, OT |
regular |
No |
Time In |
Start time recorded on the timesheet |
13:02 |
No |
Time Out |
End time recorded on the timesheet |
16:58 |
No |
Submission Date |
Date the timesheet was submitted for approval |
25-Jun-2025 |
No |
Submission Time |
Time the timesheet was submitted for approval |
18:15 |
No |
Submission Supplier Name |
Supplier who submitted the timesheet |
Supplier A |
No |
Submission Worker ID |
Worker ID of the individual who submitted the timesheet |
2546 |
No |
Submission Worker Name |
Name of the worker who submitted the timesheet |
Worker Name |
No |
Submission Imported by Person Name |
Name of the person who imported the timesheet |
User Name |
No |
Submission Source Name |
Source system or entity for the timesheet submission |
SUPPLIER |
No |
Allocation Reference ID |
Unique identifier for the allocation line item |
7e0d5016-915a-42a4-ad77-8f86cb2e12a5 |
No |
Time Attestation Accepted |
Indicates whether time attestation was accepted (True/False) |
False |
No |
Meal Break Attestation |
Indicates whether meal break attestation was provided (Yes/No) |
YES |
No |
Engagement Start Date |
Start date of the engagement |
3-Aug-2025 |
No |
Engagement End Date |
End date of the engagement |
31-Dec-2025 |
No |
Business Site Name |
Name of the business site for the engagement |
1 Eglinton Road, Dublin, D04, Ireland |
No |
Business Site Address |
Address of the business site for the engagement |
Leinster, IE |
No |
Engagement Remote Address |
Remote work address for the engagement |
Jacksonville, Florida, United States |
No |
Engagement Classification |
Classification of the engagement, for example, non-employee, temporary |
Non-Employee |
No |
Expense Description |
Detailed description of the expense item |
test expense description |
No |
Expense Note |
Notes entered for the expense item |
Dec 10, 2025 12:24 PM (GMT-5) test notes (Supplier) |
No |
Cost Center ID |
Identifier for the cost center associated with the invoiced item |
cc-admin |
No |
Engagement Custom Field(s) |
Active custom fields on the engagement at allocation time, for example, rate information, comments |
Rate Information, Comments, etc. |
No |
All Active Financial Field(s) |
Active financial fields on the engagement at allocation time, for example, GL code, department |
GL Code = 12345, Department = Finance, etc. |
No |
Milestone Description |
Detailed description of the milestone |
Milestone text description |
No |
Acceptance Criteria |
Criteria required for milestone acceptance |
Acceptance criteria text description |
No |
Milestone Custom Field(s) |
Active custom fields on the milestone at allocation time, for example, comments |
Milestone comment custom field values |
No |
External Invoice ID |
Invoice ID submitted externally during manual milestone invoicing |
1234 |
No |
Submitter |
Name of the user who submitted the milestone |
User 1 |
No |
Milestone Status |
Current status of the milestone, for example, approved |
Approved |
No |
Contracting Party Type |
Type of contracting party associated with the milestone, for example, supplier |
Supplier |
No |
Contracting Party Name |
Name of the contracting party associated with the milestone |
Supplier A |
No |
MSP Fee |
MSP fee applied to the expense |
0.0 |
No |
External Invoice Date |
Date of the externally submitted invoice during manual milestone invoicing |
31-Dec-2025 |
No |