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) and Digital Accountability and Transparency Act of 2014 (DATA Act) reporting:
Customer Global Attribute Category
- Customer: FVxUSHZCustomerAccounts
- Site: FVxUSHZCustomerAccountSites
| Name | Segment Description | Optional/Required/Not Allowed | Level | FBDI Mapping |
|---|---|---|---|---|
| Federal or Non-Federal Code | The Federal or Non-Federal Code for the customer account. | Required | Customer | Global Attribute 1 |
| Trading Partner Agency Identifier | The Trading Partner Agency Identifier for the customer account. | Required, if Federal or Non-Federal Code = Federal or General Fund. | Customer | Global Attribute 2 |
| Unique Entity Identifier | The Unique Entity Identifier for the customer account. | Optional | Customer | Global Attribute 3 |
| EFT Indicator | The EFT Indicator for the customer account. | Optional | Customer | Global Attribute 4 |
| Limit Trading Partner TAS to AID | The Limit Trading Partner TAS option for the customer account. | Optional | Customer | Global Attribute 5 |
| Default Trading Partner TAS | The Default Trading Partner TAS for the customer account. | Optional | Customer | Global Attribute Number 1 |
| Agency Location Code | The Agency Location Code associated with the customer account. | Required, if Federal or Non-Federal Code = Federal or General Fund. | Customer | Global Attribute 6 |
| SAM Site | This signifies to the user that the information on the Customer Site and Account was populated using the GSA System for Award Management system. | Optional | Site | Global Attribute 1 |
| SAM Registration Status | This attribute tracks the registration status of the entity. | Optional | Site | Global Attribute 2 |
| SAM Synchronized Date | This attribute indicates the latest date when Customer Site and Customer Account were last updated from the SAM download file. | Optional | Site | Global Attribute Date 1 |
| Legal Business Name | This attribute indicates the entity's legal business name registered with the entity's state filing office or the name used on legal documents, tax returns or banking documents. | Optional | Site | Global Attribute 3 |
| DBA Name | The Doing Business As name of the entity. This name must be different from the Legal Business Name. | Optional | Site | Global Attribute 4 |
| Entity Division Name | This System for Award Management attribute indicates the division name or number as provided by the entity. | Optional | Site | Global Attribute 5 |
| CAGE / NCAGE Code | Commercial And Government Entity code is a unique identifier assigned to an entity which provides a standardized method of identifying a given facility at a specific location. | Optional | Site | Global Attribute 6 |
| Small / Other Than Small | This System for Award Management attribute indicates if the entity is a small business or other than a small business. | Optional | Site | Global Attribute 7 |
| Debarred | This System for Award Management Attribute indicates the eligibility of an entity to engage in business with the federal government. | Optional | Site | Global Attribute 8 |
Transaction Global Attribute Category
- Header: FVxUSRACustomerTrxHeaders
- Distribution: FVxUSRATrxLineGLDistributions
| 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
| 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. | 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:
For activity type miscellaneous cash, the user must select one of these transaction categories:
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.