Mapping Codes for Federal Financials
Predefined mapping codes are available for defining mapping sets for Oracle U.S. Federal Financials. You must select the natural account code for each mapping code based on its description. This natural account code is used in the Oracle Subledger Accounting rules.
This table shows the mapping codes for Federal Financials:
|
Name |
Description |
|---|---|
|
USSGL 310700 |
USSGL Account 310700 |
| USSGL 310710 - 31071001 | USSGL Account 310710 |
| USSGL 42X100 - 42210001 | USSGL Account 422100: Receipt Method Global Attribute 1 = ORA_REIM_WO_ADV |
| USSGL 42X100 - 42210001 - Misc Receipts | USSGL Account 422100: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_WO_ADV |
| USSGL 42X100 - 42510001 | USSGL Account 425100: Receipt Method Global Attribute 1 = ORA_COLL |
| USSGL 42X100 - 42510001 - Misc Receipts | USSGL Account 425100: Receivables Activity Distributions Global Attribute 1 = ORA_COLL |
| USSGL 42X200 - 42220001 | USSGL Account 422200: Receipt Method Global Attribute 1 = ORA_REIM_ADV |
| USSGL 42X200 - 42220001 - Misc Receipts | USSGL Account 422200: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_ADV |
| USSGL 42X200 - 42520001 | USSGL Account 425200: Receipt Method Global Attribute 1 = ORA_COLL |
| USSGL 42X200 - 42520001 - Misc Receipts | USSGL Account 425200: Receivables Activity Distributions Global Attribute 1 = ORA_COLL |
| USSGL 422X00 - 42210001 | USSGL Account 422100: FV Transaction Category = ORA_REIM_WO_ADV |
| USSGL 422X00 - 42210001 - Adjustments | USSGL Account 422100: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_WO_ADV |
| USSGL 422X00 - 42220001 - Adjustments | USSGL Account 422200: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_ADV |
| USSGL 422X00 - 42220001 | USSGL Account 422200: FV Transaction Category = ORA_REIM_ADV |
| USSGL 425X00 - 42510001 | USSGL Account 425100: FV Transaction Category = ORA_REIM_WO_ADV |
| USSGL 425X00 - 42510001 - Adjustments | USSGL Account 425100: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_WO_ADV |
| USSGL 425X00 - 42520001 | USSGL Account 425200: FV Transaction Category = ORA_REIM_ADV |
| USSGL 425X00 - 42520001 - Adjustments | USSGL Account 425200: Receivables Activity Distributions Global Attribute 1 = ORA_REIM_ADV |
|
USSGL 431000 |
USSGL Account 431000: Unexpired TAS |
|
USSGL 445000 or 46X000 - 445000 |
USSGL Account 445000: Unexpired TAS, Apportionment Category A or B, Prior Budget Fiscal Year |
| USSGL 445000 or 46X000 - 44500002 | USSGL 445000 or 46X000 - 44500002 : Federal Fund Expired Status = 'Unexpired' AND Federal Prior Year Flag = 'Y' |
|
USSGL 445000 or 46X000 - 461000 |
USSGL Account 461000: Unexpired TAS, Apportionment Category A or B, Current Budget Fiscal Year |
| USSGL 445000 or 46X000 - 46100002 | USSGL 445000 or 46X000 - 46100002 : Federal Fund Expired Status = 'Unexpired' AND Federal Prior Year Flag = 'N' AND ( Federal Apportionment Category = 'A' OR Federal Apportionment Category = 'B' ) |
|
USSGL 445000 or 46X000 - 462000 |
USSGL Account 462000: Unexpired TAS, Apportionment Category E |
| USSGL 445000 or 46X000 - 46200002 | USSGL 445000 or 46X000 - 46200002 : Federal Fund Expired Status = 'Unexpired' AND Federal Apportionment Category = 'E' |
|
USSGL 445000 or 46X000 - 465000 |
USSGL Account 465000: Expired TAS, Prior Budget Fiscal Year |
| USSGL 445000 or 46X000 - 46500002 | USSGL 445000 or 46X000 - 46500002 : Federal Fund Expired Status = 'Expired' AND Federal Prior Year Flag = 'Y' |
|
USSGL 46X000 - 461000 |
USSGL Account 461000: Unexpired TAS, Apportionment Category A or B |
|
USSGL 46X000 - 462000 |
USSGL Account 462000: Unexpired TAS, Apportionment Category E |
|
USSGL 47X000 - 470000 |
USSGL Account 470000: Unexpired TAS, Apportionment Category A or B, Current Budget Fiscal Year |
|
USSGL 47X000 - 472000 |
USSGL Account 472000: Unexpired TAS, Apportionment Category E, Current Budget Fiscal Year |
|
USSGL 47X000 - 8XXXXX |
USSGL Account 8XXXXX: Prior Budget Fiscal Year |
|
USSGL PY Commit |
USSGL Account 8XXXXX: Prior Budget Fiscal Year |
|
USSGL 480100 |
USSGL Account 480100 |
|
USSGL 480200 |
USSGL Account 480200 |
| USSGL 480200 - 48020001 | USSGL 480200 - 48020001 : FV Transaction Category = 'ORA_REF_ADV_PP' AND Federal Prior Year Flag = 'N' |
|
USSGL 487100 or 488100 - 487100 |
USSGL Account 487100: Prior Budget Fiscal Year, Downward Adjustment |
|
USSGL 487100 or 488100 - 488100 |
USSGL Account 487200: Prior Budget Fiscal Year, Upward Adjustment |
|
USSGL 487100 or 488100 Offset - 487100 |
USSGL Account 487100: Prior Budget Fiscal Year, Downward Adjustment Offset |
|
USSGL 487100 or 488100 Offset - 488100 |
USSGL Account 487200: Prior Budget Fiscal Year, Upward Adjustment Offset |
| USSGL 487200 or 488200 - 48720001 | USSGL 487200 or 488200 - 48720001 : FV Transaction Category = 'ORA_REF_ADV_PP' AND Federal Prior Year Flag = 'Y' AND Accounted Amount > 0 |
| USSGL 487200 or 488200 - 48820001 | USSGL 487200 or 488200 - 48820001 : FV Transaction Category = 'ORA_REF_ADV_PP' AND Federal Prior Year Flag = 'Y' AND Accounted Amount < 0 |
|
USSGL 490100 |
USSGL Account 490100 |
|
USSGL 490200 |
USSGL Account 490200 |
| USSGL 490200 - 49020001 | USSGL 490200 - 49020001 : FV Transaction Category = 'ORA_REF' AND Federal Prior Year Flag = 'N' |
|
USSGL 497100 or 498100 - 497100 |
USSGL Account 497100: Prior Budget Fiscal Year, Downward Adjustment |
|
USSGL 497100 or 498100 - 498100 |
USSGL Account 498100: Prior Budget Fiscal Year, Upward Adjustment |
|
USSGL 497100 or 498100 Offset - 497100 |
USSGL Account 497100: Prior Budget Fiscal Year, Downward Adjustment Offset |
|
USSGL 497100 or 498100 Offset - 498100 |
USSGL Account 498100: Prior Budget Fiscal Year, Upward Adjustment Offset |
|
USSGL 497200 or 498200 |
USSGL Account 497200: Prior Budget Fiscal Year, Downward Adjustment |
|
USSGL 497200 or 498200 |
USSGL Account 498200: Prior Budget Fiscal Year, Upward Adjustment |
| USSGL 497200 or 498200 - 49720001 | USSGL 497200 or 498200 - 49720001 : FV Transaction Category = 'ORA_REF' AND Federal Prior Year Flag = 'Y' AND Accounted Amount > 0 |
| USSGL 497200 or 498200 - 49820001 | USSGL 497200 or 498200 - 49820001 : FV Transaction Category = 'ORA_REF' AND Federal Prior Year Flag = 'Y' AND Accounted Amount < 0 |
|
USSGL 497200 or 498200 Offset - 497200 |
USSGL Account 497200: Prior Budget Fiscal Year, Downward Adjustment Offset |
|
USSGL 497200 or 498200 Offset - 498200 |
USSGL Account 498200: Prior Budget Fiscal Year, Upward Adjustment Offset |
|
USSGL 4X9000 - 459000 |
USSGL Account 459000: Unexpired TAS, Apportionment Category A or B, Prior Budget Fiscal Year |
|
USSGL 4X9000 - 469000 |
USSGL Account 469000: Unexpired TAS, Apportionment Category E, Prior Budget Fiscal Year |
|
USSGL 570000 |
USSGL Account 570000 |
| USSGL 570010 - 57001001 | USSGL Account 570010 |