USAS User’s Manual –
Chapter 6 – Transaction Codes (continued)
Financial Table Posting Indicators
The highlighted portion of the screen contains Financial Table Posting Indicators. These indicators control transactions posting to the Financial Tables.
Note: To maintain a complete audit trail, Comptroller General Ledger (GL) and Accounting Event (AE) tables are always posted.
A picture of the USAS Transaction Code Decision Profile screen
TEXAS S28A UNIFORM STATEWIDE ACCOUNTING SYSTEM 10/12/95 02:18 PM
LINK TO: TRANSACTION CODE DECISION PROFILE PROD
ACTION: R (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
TRAN CODE: 231 TITLE: VOUCHER PAYABLE - ENCUMBERED
GENERAL LEDGER DR-1: 5501 CR-1: 1009 DR-2: CR-2
POSTING DR-3: CR-3: DR-4: 9005 CR-4: 9001
TRANS DODC DUDT SVDT R CDOC I RDOC I MODI I AGCY R IDX PCA R COBJ R
EDIT AOBJ RVRS PDR CI 1099 WARR INVC VNUM R VNAM R VADD
INDS:DMETH R APN# R FUND R GLA N AGL GRNT SUBG PROJ MULT DI#
POST SEQ: 4 REG NO: 2 WW IND: 1 D/I: D WAR CANCL TC: 951 PYTC: FUTMY: N
GEN TC: GEN ACCR TC: FACTS TC: INTERFACE IND: 1
PAY LIQ TC: 380 BALANCING TC:
A/S BT MATCH GLA DOC A/S BT MATCH GLA DOC
DF: + 03 M 8 2 + 04 M 8 2
FILE AP: - 18 + 17
POSTING AB: - 18 + 17
INDS: CC:
GP: - 18 + 17
PJ: - 18 + 17
AGY GL: 2 STATUS CODE: A
EFF START DATE: 09011994 EFF END DATE: LAST PROC DATE: 08221995
Z06 RECORD SUCCESSFULLY RECALLED
F1-HELP F3-END F4-INTERRUPT F6-PROCESS F10-28B PROFILE
Highlighted Elements
- DF
- Document Table contains document level pre-encumbrance, encumbrance,
accounts receivable transactions, and outstanding transactions and balances.
Note: The Document Table has its own unique set of balance types. They are:
- 01 Original Amount
- 02 Adjustments
- 03 Liquidations
- 04 Collections/Payments
- AP
- Appropriation Table contains appropriation balances, revenues, expenditures, and encumbrances against appropriations. Agency Fund Table (AF) is simultaneously updated when the AP table is updated.
- AB
- Agency Budget Table contains agency budget transactions and balances, revenues, expenditures, and encumbrances against agency budgets for those agencies that establish and maintain agency budgets in USAS.
- CC
- Cash Control Table contains transactions and balances of each appropriated fund's available cash.
- GP
- Grant Table contains budgets, expenditures, and revenues for grants.
- PJ
- Project Table contains budgets, expenditures, and revenues for projects.
Note: For more information on table posting in USAS, see the Understanding Financial Tables chapter in this manual.
The remaining elements in the 28A profile define the following for each table:
- A/S
- Add/Subtract determines whether the cumulative total for a given BT on a particular table will be increased (+) or decreased (-) by the transaction.
- BT
- Identified on the D05 Profile. Balance Type groups transactions by Category of Accounts event and stores financial data in the related table. For example, transactions with BT ‘17’ are Accrued Expenditures transactions. Transaction codes impacting balance type ‘17’ will be combined and stored in the related financial table for online inquiry and reporting purposes. (Transactions with Balance Type ‘18’ are Encumbrances Outstanding transactions.)
Note: The Document Table has its own unique set of balance types.
They are:
- 01 Original Amount
- 02 Adjustments
- 03 Liquidations
- 04 Collections/Payments
The following fields determine the rules for posting to the Document Table:
- Match
- Ensures documents are correctly established and liquidated for the Document Table.
M an edit is performed to verify that the ref doc number matches a previously entered document. The document number must currently exist; for example, a liquidating encumbrance reference document number must match the current document number of the original encumbrance transaction. Example: For T-Code 231, the updating of the Document Table (DF) for liquidations (BT 03) must match the original encumbrance (or pre-encumbered) document with the reference document number on the liquidating transaction.
N document number must not exist. The current document number must be unique. Blank no match control. - GLA
- Identifies the general ledger account (1–8) from the “General
Ledger Posting’ section of the 28A used as a reference point to the Document Table.
Example: For T-Code 231, the Comptroller General Ledger Account updated is number 8 (9001–Encumbrances).
- Doc
- Determines the Document Number used to post to the Document Table. Valid values:
Blank No Document Number Used 1 Current Document Number (CDOC) 2 Reference Document Number (RDOC) Example: For T-Code 231, the document which will be used on this transaction will be 2–Reference Document.
- AGY GL
- Allows agencies to further break down certain Comptroller GL accounts. These values represent which of the Comptroller GL accounts previously listed can be supported by an Agency GL. The values are 1-8 to represent each Comptroller GL listed (for example, a ‘1’ represents the first GL field, DR-1; and ‘2’ represents the second GL field, CR-1). Determines the Comptroller GL account (1-8) from the ‘GL Posting’ section which the entered agency GL account supports. See the D32 Profile for more information.