Import Journals- Field description for Custom Template
- Knowledge Assistant
List of fields and descriptions available for Custom Templates in Import Journals
Import Journals
Custom Templates
Flat Journal Import | |
|---|---|
Name | Description |
Account Type | Account Type |
Actual Amount | Amount of actuals. To be used with Actual Debit or Credit. |
Actual Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Actual Amount. |
Additional Description | Additional Description |
Allocation Code | Allocation Code |
Benefit Check | Oklahoma Benefit specific field |
Check Date | Oklahoma Payroll specific field |
Check Number | Oklahoma Payroll specific field |
Clerk | User who created the journal |
Comment | Comment |
Cost Ctr | ISIS Payroll specific field |
Credit Gross | Credit amount. To be used with Debit Gross |
Cross-Reference Account | X-Reference Account |
Debit Gross | Debit amount. To be used with Credit Gross |
Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Gross. |
Effective Date | Effective Date |
Encumbrance Amount | Amount of encumbrances. To be used with Encumbrance Debit or Credit. |
Encumbrance Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Encumbrance Amount. |
Fiscal Period | Fiscal Period |
Fiscal Year | Fiscal Year |
Fuel Tank Number | FASTER specific field |
Full Account | Full Account String. Requires Account Type. |
G_L | ISIS Payroll specific field |
Gross | Gross amount. To be used with 'Debit or Credit'. |
Job | ISIS Payroll specific field |
Journal IE Histories Id | Value to search for in JournalImportExportHistories.JournalReference |
Object | GL Object Code |
Org | GL Organization Code |
Org Unit | ISIS Payroll specific field |
Post Desc | ISIS Payroll specific field |
Program Code | FASTER specific field |
Project | GL Project Code |
Project String | Full Project String. |
Project String Type | Project String Type |
Record Type Code | FASTER specific field |
Reference 1 | Ref1 |
Reference 2 | Ref2 |
Reference 3 | Ref3 |
Reference 4 | Ref4 |
Responsibility Code | FASTER specific field |
Rpt Cat | ISIS Payroll specific field |
Sch_Loc | PeopleSoft specific field |
Segment 1 | Fund code |
Segment 2 | Segment 2 code |
Segment 3 | Segment 3 code |
Segment 4 | Segment 4 code |
Segment 5 | Segment 5 code |
Segment 6 | Segment 6 code |
Segment 7 | Segment 7 code |
Segment 8 | Segment 8 code |
Sequence | Journal detail line number |
Signed Amount | Signed Amount. Not to be used with 'Debit or Credit', Gross, Credit Gross, or Debit Gross. |
Source | Journal Source code |
Sublet Indicator | FASTER specific field |
Transaction Type | The type of transaction. |
Vendor Name | Oklahoma Benefit specific field |
Header/Detail Journal Import- Line Type Header | |
|---|---|
Name | Description |
Effective Date | Effective date of journal. |
Fiscal Period | Fiscal period of journal. |
Fiscal Year | Fiscal year of journal. |
Header Identifier | Indicates that this is a header line. used in alongside with the Value field in Journal Import Templates |
Reference 1 | Journal Reference |
Short Description | Journal Short Description. Reference 1. |
Header/Detail Journal Import- Line Type Detail | |
|---|---|
Name | Description |
Account Type | Account Type |
Actual Amount | Amount of actuals. To be used with Actual Debit or Credit. |
Actual Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Actual Amount. |
Additional Description | Additional Description |
Allocation Code | Allocation Code |
Comment | Comment |
Credit Gross | Credit amount. To be used with Debit Gross |
Cross-Reference Account | X-Reference Account |
Debit Gross | Debit amount. To be used with Credit Gross |
Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Gross. |
Detail Identifier | Indicates that this is a detail line. |
Effective Date | Effective Date |
Encumbrance Amount | Amount of encumbrances. To be used with Encumbrance Debit or Credit. |
Encumbrance Debit or Credit | 'D' for Debit or 'C' for Credit. To be used with Encumbrance Amount. |
Full Account | Full Account String |
Gross | Gross amount. To be used with 'Debit or Credit'. |
Long Account | Masked Long Account string. Requires Account Type. |
Object | GL Object Code |
Org | GL Organization Code |
Project | GL Project Code |
Project String | Full Project String. |
Project String Type | Project String Type |
Reference 1 | Ref1 |
Reference 2 | Ref2 |
Reference 3 | Ref3 |
Reference 4 | Ref4 |
Signed Amount | Signed Amount. Not to be used with 'Debit or Credit', Gross, Credit Gross, or Debit Gross. |
Transaction Type | The type of transaction. |