Journal Line Attributes
The following Journal Line attributes are supported to capture information required for Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS), Digital Accountability and Transparency Act of 2014 (DATA Act), Classification Transactions and Accountability (CTA) interfaces and File-Based Data Import (FBDI) for the Import Journals scheduled process:
- Line: FVxUSGLJournalLines
| Name | Description | Optional/Required/Not Allowed | Need | Level | FBDI Mapping |
|---|---|---|---|---|---|
| BETC |
Identifies the type of activity (gross disbursement, offsetting collection, investment in Treasury securities, and so on) and the effect of a transaction on the FBWT. Is used in combination with the TAS to classify transactions reported to Treasury through all GWA-compliant FMS systems. When you save the journal line, this field is automatically populated with the BETC type (Payment or Collection) defined for the Treasury Account Symbol that is associated with the balancing segment (fund) entered on the journal line. If the GL account is mapped to a Payment BETC type on the Manage CTA FBWT Account Definitions window, the system automatically populates this field with the Payment BETC. If the GL account is mapped to a Collection BETC type on the Manage CTA FBWT Account Definitions window, the system automatically populates this field with the Collection BETC. |
Required if the GL account is mapped to an account, otherwise optional. | CTA | Line | Global Attribute 1 |
| Federal or Non-Federal Code |
Indicates the type of entity involved in transactions with the reporting entity: Federal (F): other federal entities Non-Federal (N): entities such as private/local/state/tribal/foreign governments Non-Federal Exception (E): exceptions for other non-federal partners Federal Exception (Z): unidentified federal activity that does not have a trading partner General Fund (G): General Fund of the US Government only (G). |
Optional | GTAS | Line | Global Attribute 2 |
| Trading Partner TAS | Identification code assigned by the Treasury in collaboration with the US Office of Management and Budget (OMB) and the owner agency to the trading partner's individual appropriation, receipt, or other fund account. |
Required if Federal or Non-Federal Code is Federal or General Fund. Otherwise, not allowed. |
CTA, GTAS | Line | Global Attribute Number 1 |
| Trading Partner BETC |
Identifies the trading partner's type of activity (gross disbursement, offsetting collection, investment in Treasury securities, and so on.) and the effect of a transaction on the FBWT. Is used in combination with the Trading Partner TAS to classify transactions reported to the Treasury through all Governmentwide Accounting (GWA)-compliant Financial Management Service (FMS) systems. If a value is entered in the Trading Partner TAS field, when you save the journal, this field is automatically populated with the Payment or Collection BETC defined for the Trading Partner TAS. The BETC and Trading Partner BETC can’t be the same BETC type. For example, if you enter a payment BETC in the BETC field, the Trading Partner BETC field must be a collection BETC. |
Required if the Trading Partner TAS is provided. | CTA | Line | Global Attribute 3 |
| Agency Location Code |
List of values containing all internal agency location codes defined. When you save the journal line, the system automatically populates the internal agency location code defined for the GL account on the Manage CTA FBWT Account Definitions window. |
Required if the journal category is defined as a value for the lookup type ORA_FV_CTA_RECLASS_JOURNAL. Otherwise, not allowed. | CTA | Line | Global Attribute 4 |
| Enable for DATA Act reporting | Indicates if the line is or is not DATA Act reportable. | Optional | DATA Act | Line | Global Attribute 5 |
| DATA Act Award Type |
Identifies the DATA Act Award Type: Procurement Financial Assistance |
Required if Enable for DATA Act reporting is Yes. Otherwise, optional. |
DATA Act | Line | Global Attribute 6 |
| Procurement Instrument Identifier (PIID) | The unique identifier of the specific award being reported. |
Required if the DATA Act Award Type is Procurement. Optional if the DATA Act Award Type is not specified. Otherwise, not allowed. |
DATA Act | Line | Global Attribute 7 |
| Parent Award ID | The identifier of the procurement award under which the specific award is issued, such as a Federal Supply Schedule. This data element currently applies to procurement actions only. |
Optional if the DATA Act Award Type is Procurement. Otherwise, not allowed. |
DATA Act | Line | Global Attribute 8 |
| Federal Assistance Identification Number (FAIN) | The FAIN is the unique ID within the federal agency for each (non-aggregate) financial assistance award. |
FAIN or URI is required if the DATA Act Award Type is Financial Assistance. Otherwise, not allowed. |
DATA Act | Line | Global Attribute 9 |
| Unique Record Identifier (URI) | An agency defined identifier that is unique for every financial assistance action reported by that agency. |
FAIN or Unique Record Identifier (URI) is required if the DATA Act Award Type is Financial Assistance. Otherwise, not allowed. |
DATA Act | Line | Global Attribute 10 |
| Trading Partner ALC | The Agency Location Code of the traing partner. | Required if the journal category is defined as a value for the lookup type ORA_ FV_CTA_RECLASS_JOURNAL. Otherwise, not allowed. | CTA | Line | Global Attribute 11 |
- Journals imported from subledger, for example, payables, receivables and so on.
- Encumbrance and budget type journals
- Manual tax journals as government agencies are not subject to tax.
The attributes BETC, Trading Partner TAS, and Trading Partner BETC are used for CTA Reclassification transactions. The attributes Enable for DATA Act reporting, DATA Act Award Type, PIID, Parent Award, FAIN, and URI are used for Data Act reporting.