Receivables US Federal Attributes
Capture federal attributes in Oracle Receivables for transactions, receipts, and customer information. Capturing these attributes provides the correct information on miscellaneous receipts for Treasury reporting, and on transactions for appropriate IPAC reporting purposes.
Attributes Captured for Customers
|
Attribute Name |
Level |
Column Name |
|---|---|---|
|
Federal or Non-Federal Code |
Customer |
Global Attribute 1 |
|
Trading Partner Agency Identifier |
Customer |
Global Attribute 2 |
|
Unique Entity Identifier |
Customer |
Global Attribute 3 |
|
EFT Indicator |
Customer |
Global Attribute 4 |
|
Limit Trading Partner TAS to AID |
Customer |
Global Attribute 5 |
|
Default Trading Partner TAS |
Customer |
Global Attribute Number 1 |
|
Agency Location Code |
Customer |
Global Attribute 6 |
|
SAM Site |
Site |
Global Attribute 1 |
|
SAM Registration Status |
Site |
Global Attribute 2 |
|
SAM Synchronized Date |
Site |
Global Attribute Date 1 |
|
Legal Business Name |
Site |
Global Attribute 3 |
|
DBA Name |
Site |
Global Attribute 4 |
|
Entity Division Name |
Site |
Global Attribute 5 |
|
CAGE / NCAGE Code |
Site |
Global Attribute 6 |
|
Small / Other Than Small |
Site |
Global Attribute 7 |
|
Debarred |
Site |
Global Attribute 8 |
Attributes Captured on Transactions
|
Attribute Name |
Level |
Column Name |
|---|---|---|
|
Transaction Subcategory Code |
Header |
Global Attribute 1 |
|
Trading Partner TAS |
Distribution |
Global Attribute Number 1 |
|
Trading Partner BETC |
Distribution |
Global Attribute 1 |
| BETC |
Distribution |
Global Attribute 2 |
|
Agency Location Code |
Distribution |
Global Attribute 3 |
Attributes Captured on Receipts, Miscellaneous Receipts, and Adjustments
|
Attribute Name |
Level |
Column Name |
|---|---|---|
|
Federal Transaction Category |
Receipt Method |
Global Attribute 1 |
|
Customer Name |
Receipt Header |
Global Attribute Number 1 |
|
Customer Account |
Receipt Header |
Global Attribute Number 2 |
| CTA Transaction |
Receipt Header |
Global Attribute 1 |
| Reversed Receipt Number |
Receipt Header |
Global Attribute Number 3 |
|
Trading Partner TAS |
Receipt Application |
Global Attribute Number 1 |
|
Trading Partner BETC |
Receipt Application |
Global Attribute 1 |
|
BETC |
Receipt Application |
Global Attribute 2 |
|
Agency Location Code |
Receipt Application |
Global Attribute 3 |
|
Adjustment Status |
Adjustment Distribution |
Global Attribute 1 |
|
Direct or Reimbursable Code |
Adjustment Distribution |
Global Attribute 2 |
|
Federal Transaction Category |
Receivable Activity |
Global Attribute 1 |
|
Trading Partner TAS |
Miscellaneous Receipt Distribution |
Global Attribute Number 1 |
|
Trading Partner BETC |
Miscellaneous Receipt Distribution |
Global Attribute 1 |
|
BETC |
Miscellaneous Receipt Distribution |
Global Attribute 2 |
|
Agency Location Code |
Miscellaneous Receipt Distribution |
Global Attribute 3 |
|
Federal Apportionment Category |
Miscellaneous Receipt Distribution |
Global Attribute 4 |
|
Federal Prior Year Fund |
Miscellaneous Receipt Distribution |
Global Attribute 5 |
|
Federal Fund Expired Status |
Miscellaneous Receipt Distribution |
Global Attribute 6 |
|
Direct or Reimbursable Code |
Miscellaneous Receipt Distribution |
Global Attribute 7 |
Customer Page
Customer Page
Business Benefit:
- Efficiently generate reports required by the US Department of the Treasury in the required format with the required structure.
Steps to Enable
U.S. Federal Financials must be enabled.
Tips And Considerations
No specific tips and considerations needed.
Key Resources
- For more information on federal attributes, refer to the Implementing U.S. Federal Financials and Using U.S. Federal Financials guides.
Access Requirements
To use this feature, you need the following job roles:
- Accounts Receivable Specialist (ORA_AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB)
- Accounts Receivable Manager (ORA_AR_ACCOUNTS_RECEIVABLE_MANAGER_SOD_JOB)