Filetype Excel XLSX | Posted on 24 Jun 2022 | 3 years ago
Authentication
digital resources
176x Filetype XLSX File size 0.04 MB Source: workday.yale.edu
Sheet 1: Key Points
| This document describes the file layout for submission of Journal transactions to Workday. | Last updated 9/27/2016 | ||
| Key points: | |||
| 1 | Three different layouts are used for Workday Journal transactions: 1. An Internal Service Provider (ISP) layout, which is used for ISP transactions 2. A 'NonISP Standard' layout, which is used for most transactions that are not Internal Service Provider (ISP) transactions 3. An 'NonISP Extended' layout, which is used by central units and for transactions that include the 'Location' segment, for transactions that are not Internal Service Provider (ISP) transactions |
||
| 2 | For each of the three layouts, you will find a tab with the 'File Format' and a tab with a 'List of Fields' | ||
| 3 | Only the lines highlighted in yellow are included in the file that is submitted. The technical format of the Journal file is the same as is used for Oracle JSA submissions. | ||
| 4 | The Workday 'Journal Source' will be the same value as is used in Oracle for JSA submissions. | ||
| 5 | Workday provides fewer discrete columns for text than does Oracle. For nonISP transactions, leverage the two 'Memo' columns to include the text that is important to your area. For ISP transactions, refer to the guidance in the 'File Format' and 'List of Fields' tabs. | ||
| 6 | There is no technical limitation to the number of characters in the 'Memo' columns. Use common sense. | ||
| RESTRICTIONS | REQUIRED | REQUIRED | REQUIRED | REQUIRED | REQUIRED | REQUIRED | OPTIONAL | REQUIRED | ||||||||||
| Field Format | Text - CONSTANT | Text (Journal Source -YYYY-MM-DD-Sequence # | Text | Date: YYYY-MM-DD | Text | Text | Text | Number (18,2) | ||||||||||
| Field Name | Header Indicator | Accounting Journal ID | Company | Accounting Date | Journal Source | Header Memo 1 | Header External Reference ID | Control Total Amount | ||||||||||
| GLH | MBOT-2016-07-01-0001 | CO01 | 2016-07-01 | MBOT | Allocation of shared costs | MB101 Series | 49208.55 | |||||||||||
| ONE OF THESE IS REQUIRED | AT LEAST ONE OF THESE IS REQUIRED | |||||||||||||||||
| RESTRICTIONS | REQUIRED | REQUIRED | REQUIRED | REQUIRED | OPTIONAL | OPTIONAL | REQUIRED | OPTIONAL | REQUIRED | OPTIONAL | OPTIONAL | OPTIONAL | REQUIRED, Leave empty for Grants |
REQUIRED, Leave empty for Grants |
REQUIRED, Leave empty for Grants |
OPTIONAL, Leave empty for Grants |
REQUIRED FOR SPEND TRANSACTIONS | REQUIRED FOR REVENUE TRANSACTIONS |
| Field Format | Text - CONSTANT | Text | Text | Text | Number (18,2) | Number (18,2) | Text | Text | Date: YYYY-MM-DD | Text | Text | Text | Text | Text | Text | Text | Text | Text |
| Field Name | Line Indicator | Line ID | Line Company | Ledger Account | Ledger Debit Amount | Ledger Credit Amount | Line Memo 1 | Line External Reference ID | Budget Date | Grant | Gift | Yale Designated | Cost Center | Program | Project | Assignee | Spend Category | Revenue Category |
| GLD | 1 | CO01 | 82001 | 49208.55 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | GT000186 | RC103 | |||||||||
| GLD | 2 | CO01 | 83010 | 49000.00 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | YD000001 | CC1022 | PG00032 | PJ000001 | SAG3 | SC202 | |||||
| GLD | 3 | CO01 | 83010 | 208.55 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | GS050014 | CC1022 | PG00032 | PJ000001 | SAG3 | SC202 | |||||
| LEGEND | ||||||||||||||||||
| Restrictions/inclusion requirements | ||||||||||||||||||
| Field Format | ||||||||||||||||||
| Field Name | ||||||||||||||||||
| Sample data | ||||||||||||||||||
| RESTRICTIONS | REQUIRED | REQUIRED | REQUIRED | REQUIRED | REQUIRED | REQUIRED | OPTIONAL | REQUIRED | OPTIONAL | REQUIRED | REQUIRED | OPTIONAL | ||||||||||
| Field Format | Text - CONSTANT | Text (Journal Source -YYYY-MM-DD-Sequence # | Text | Date: YYYY-MM-DD | Text | Text | Text | Number (18,2) | Text | Text | Text | Date: YYYY-MM-DD | ||||||||||
| Field Name | Header Indicator | Accounting Journal ID | Company | Accounting Date | Journal Source | Header Memo 1 | Header External Reference ID | Control Total Amount | Book Code | Ledger | Adjustment Journal | Reversal Date | ||||||||||
| GLH | MBOT-2016-07-01-0001 | CO01 | 2016-07-01 | MBOT | Allocation of shared costs | MB101 Series | 49208.55 | gaap_adjustment | Actual | N | 2016-08-01 | |||||||||||
| ONE OF THESE IS REQUIRED | AT LEAST ONE OF THESE IS REQUIRED | |||||||||||||||||||||
| RESTRICTIONS | REQUIRED | REQUIRED | REQUIRED | REQUIRED | OPTIONAL | OPTIONAL | REQUIRED | OPTIONAL | REQUIRED | OPTIONAL | OPTIONAL | OPTIONAL | REQUIRED, Leave empty for Grants |
REQUIRED, Leave empty for Grants |
REQUIRED, Leave empty for Grants |
OPTIONAL, Leave empty for Grants |
REQUIRED FOR SPEND TRANSACTIONS | REQUIRED FOR REVENUE TRANSACTIONS | OPTIONAL | OPTIONAL | OPTIONAL | OPTIONAL |
| Field Format | Text - CONSTANT | Text | Text | Text | Number (18,2) | Number (18,2) | Text | Text | Date: YYYY-MM-DD | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text |
| Field Name | Line Indicator | Line ID | Line Company | Ledger Account | Ledger Debit Amount | Ledger Credit Amount | Line Memo 1 | Line External Reference ID | Budget Date | Grant | Gift | Yale Designated | Cost Center | Program | Project | Assignee | Spend Category | Revenue Category | Location | Fund | Debt Line | Donor ID |
| GLD | 1 | CO01 | 82001 | 49208.55 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | GT000186 | RC103 | |||||||||||||
| GLD | 2 | CO01 | 83010 | 49000.55 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | YD000001 | CC1022 | PG00032 | PJ000001 | SAG3 | SC202 | |||||||||
| GLD | 3 | CO01 | 83010 | 208.55 | Allocate supplies cost across accounts | Internal Ref# MB101 | 2016-05-12 | GS050014 | CC1022 | PG00032 | PJ000001 | SAG3 | SC202 | |||||||||
| LEGEND | ||||||||||||||||||||||
| Restrictions/inclusion requirements | ||||||||||||||||||||||
| Field Format | ||||||||||||||||||||||
| Field Name | ||||||||||||||||||||||
| Sample data | ||||||||||||||||||||||
no reviews yet
Please Login to review.
