1. Using U.S. Federal Financials
  2. Accounts Receivable Attributes

Accounts Receivable Attributes

The following attributes are supported on transactions and receipts to capture information required for Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS), Digital Accountability and Transparency Act of 2014 (DATA Act) reporting, Classification Transactions and Accountability (CTA) reporting, and System for Award Management (SAM) customer data processing:

Transaction Global Attribute Category
  • Header: FVxUSRACustomerTrxHeaders
  • Distribution: FVxUSRATrxLineGLDistributions

Transaction Attributes

Name Segment Description Optional/Required/Not Allowed Level FBDI Mapping
Transaction Subcategory Code The transaction subcategory code for the billing header. Optional Header Global Attribute 1
Trading Partner TAS The Treasury Account Symbol ID for the billing transaction line. Optional Distribution Global Attribute Number 1
Trading Partner BETC The Business Event Type Code for the trading partner TAS in the billing transaction line. Optional Distribution Global Attribute 1
BETC The agency BETC for the billing transaction line. Optional Distribution Global Attribute 2
Agency Location Code The agency location code for the billing transaction line. Optional Distribution Global Attribute 3

Receipt and Adjustment Global Attribute Category

  • Receipt Method: FVxUSARReceivableMethods
  • Receipt Header: FVxUSARCashReceipts
  • Receipt Application: FVxUSARRecApplAll
  • Adjustments Distribution: FVxUSARAdjustments
  • Receivable Activity: FVxUSARReceivableActivities
  • Miscellaneous Receipt Distribution: FVxUSARMiscCashDistributions

Receipt and Adjustment Attributes

Name Segment Description Optional/Required/Not Allowed Level FBDI Mapping
Federal Transaction Category The transaction category on the receipt method.

Optional

 Receipt Method Global Attribute 1
Customer Name The customer name for the CTA transaction. Optional Receipt Header Global Attribute Number 1

Customer Account

 The customer account for the CTA transaction. Optional Receipt Header Global Attribute Number 2
CTA Transaction A yes/no selection to indicate if this is a CTA transaction or not. Required for miscellaneous receipts. Otherwise, optional. Receipt Header Global Attribute 1
Reversed Receipt Number The reversed receipt number of the receipt transaction being corrected. Optional Receipt Header Global Attribute Number 3
Trading Partner TAS The Treasury Account Symbol ID for the receipt application line. Optional Receipt Application Global Attribute Number 1
Trading Partner BETC The Business Event Type Code for the trading partner TAS on the receipt application line. Optional Receipt Application Global Attribute 1
BETC The agency BETC for the receipt application line. Optional Receipt Application Global Attribute 2
Agency Location Code The agency location code for the receipt application line. Optional Receipt Application Global Attribute 3
Adjustment Status for Treasury The adjustment status for the adjustment transaction. Optional Adjustments Distribution Global Attribute 1
Federal Transaction Category

The transaction category on the receivable activity.

For activity type adjustments, the user must select either of these transaction categories:

  • Reimbursable earned with advance
  • Reimbursable earned without advance

For activity type miscellaneous cash, the user must select one of these transaction categories:

  • Advance collection of reimbursable agreement
  • Collection for reimbursable services
  • Refund
  • Refund of advance or prepayment

If the user selects any other transaction category, the accounting for the receipt won't be processed correctly.

 Optional Receivable Activity Global Attribute 1
Trading Partner TAS The Treasury Account Symbol ID on the miscellaneous receipt transaction distribution. Optional Miscellaneous Receipt Distribution Global Attribute Number 1
Trading Partner BETC The Business Event Type Code for the trading partner TAS on the miscellaneous receipt transaction distribution. Optional Miscellaneous Receipt Distribution Global Attribute 1
BETC The agency BETC on the miscellaneous receipt transaction distribution. Optional Miscellaneous Receipt Distribution Global Attribute 2
Agency Location Code The agency location code on the miscellaneous receipt transaction distribution. Optional Miscellaneous Receipt Distribution Global Attribute 3
Important: When you import credit memos, invoices, and debit memos using the FBDI template, you must enter the TAS ID, and not the TAS name, in the GLOBAL_ATTRIBUTE_NUMBER1 column in the RA_INTERFACE_DISTRIBUTIONS_ALL tab. When you import customer accounts, you must enter the TAS ID in the GLOBAL_ATTRIBUTE_NUMBER1 column in the HZ_IMP_ACCOUNTS_T tab. You can download the TAS ID from the Manage Treasury Account Symbols page. To download the TAS ID and other TAS data in a spreadsheet, click Manage in Excel from the Actions menu on the Manage Treasury Account Symbols page.