This appendix contains these topics:
This appendix lists and discusses some of the important codes used in STAR.
The following lists the edit codes from which you can choose on Override Default Information. You can override the default edit code for individual columns on Column Specifications.
The following lists the column type codes from which you can choose on Column Specifications. A discussion of column type codes follows the list.
Column Type | Description |
---|---|
AB | Address Book Number |
AF | Authorization for Expenditure Number |
AJ | Accumulated Depreciation Account - Object |
AR | Account Range |
AS | Accumulated Depreciation Account - Subsidiary |
AU | Accumulated Depreciation Account - Business Unit |
AV | Account Value |
BL | Blank |
B1 | Balance Character Code 1 (Cost Accounts) |
B2 | Balance Character Code 2 (Accumulated Depreciation Accounts) |
B3 | Balance Character Code 3 (Secondary Accumulated Depreciation Accounts) |
B4 | Balance Character Code 4 (Depreciation Expense Accounts) |
B5 | Balance Character Code 5 (Secondary Depreciation Expense Accounts) |
B6 | Balance Character Code 6 (Tertiary Depreciation Expense Accounts) |
B7 | Balance Character Code 7 (Net Book Value Accounts) |
B8 | Balance Character Code 8 (Disposal Clearing Accounts) |
B9 | Balance Character Code 9 (Disposal Proceeds Accounts) |
C | Calculate Column |
CC | Responsible Cost Center |
CD | Contract Dates |
CJ | Cost Account - Object |
CM | Computation Method |
CO | Company |
CQ | Current Item Quantity |
CR | Calculate Column (recalculate at each level) |
CS | Cost Account - Subsidiary |
CU | Cost Account - Business Unit |
C3 - C9 | Category Codes 3 through 9 |
DA | Date Acquired |
DD | Date Disposed |
DE | Date Expired |
DJ | Depreciation Expense - Object |
DM | Depreciation Method |
DS | Depreciation Expense - Subsidiary |
DU | Depreciation Expense - Business Unit |
D1 | Description 1 |
D2 | Description 2 |
D3 | Description 3 |
ER | Expected Return Date |
ES | Equipment Status |
E1 | Explanation Line 1 |
E2 | Explanation Line 2 |
FM | Finance Method |
IC | Insurance Company |
IM | Item Master Data |
IN | Item Number |
IP | Insurance Policy Number |
IT | Investment Tax Credit Method (Depreciation Information) |
JR | Job Cost Account Range |
JV | Job Cost Account Value |
LC | Location Cost Center |
LR | Lessor, Renter, or Mortgagor Address |
MC | Major Class (Accounting Class - Category Code 1) |
MN | Monthly Payment |
NU | New or Used |
OQ | Original Item Quantity |
PC | Purchase Option Credit |
PM | Purchase Option Maximum Credit |
PN | Parent Number |
PP | Purchase Option Price |
PR | Propagate Column |
P1 | Parent Item Number |
P2 | Second Item Number |
RJ | Revenue Account - Object |
RM | Renewal Month |
RS | Revenue Account - Subsidiary |
RT | Retirement Amount |
RU | Revenue Account - Business Unit |
R1 | Remark 1 |
R2 | Remark 2 |
S# | Schedule Number |
SC | Sub Class (Equipment Class - Category Code 2) |
SD | Start Depreciation Date |
SE | Start Effective Date |
SI | Subledger Inactive |
SN | Serial Number |
ST | State |
SV | Salvage Value |
TE | Tax Entity |
TI | Transfer In Amount |
TO | Transfer Out Amount |
UN | Unit/Tag Number (Unit Number) |
11 - 23 | Category Codes 11 through 23 |
The IM (Item Master Data) column type code prints values from the Item Master table (F1201) and must be used with one of the following column amount codes:
CC (Cost Center Name)
CO (Company Code)
DC (Disposal Cost)
IA (Investment Tax Credit Amount Year-to-Date)
IP (Insurance Premium)
IV (Insurance Value)
PO (Purchase Option Price)
RC (Replacement Cost)
RL (Replacement Cost Last Year)
The following column type codes are used to retrieve the indicated information from special fields in the Item Balances table (F1202):
Code | Field |
---|---|
RT (Retirement Amount) | FLBORG |
SV (Salvage Value) | FLTKER |
TI (Transfer In Amount) | FLBREQ |
TO (Transfer Out Amount) | FLBAPR |
Note:
Document types AD and AT are used by the Fixed Assets Post program (R12800) to update the retirement and transfer fields along with the Period Amount field. Use caution not to duplicate totals in STAR. Disposals and transfers made with other document types (JE, for example) can result in reporting difficulties.You use column type AD to retrieve the current year's additions from the Item Balance table.
You use column type RT to retrieve book (AA) retirements from the Item Balances table (F1202).
The following lists the column amount codes from which you can choose on Column Specifications. A discussion of column amount codes follows the list.
Column Amount | Description |
---|---|
AB | Account Balance, through Current Period |
AB+NN | Account Balance, through Current + nn periods |
AB-NN | Account Balance, through Current - nn periods |
AB0NN | Account Balance, through Period nn |
AD | Asset Additions (Current Year) |
CC | Cost Center Name (Item Master) |
CO | Company Code (Item Master) |
DC | Disposal Cost (Item Master) |
FC | Standard Fuel Consumption (Item Master) |
IA | Investment Tax Credit Amount Year-to-Date (Item Master) |
IC | Inception-to-Date, through Current Period |
IC+NN | Inception-to-Date, through Current + nn Periods |
IC-NN | Inception-to-Date, through Current - nn Periods |
IC0NN | Inception-to-Date, through Period nn |
IP | Insurance Premium (Item Master) |
IV | Insurance Value (Item Master) |
IY | Inception-to-Date through Year-End |
LM | Life Months (Item Master) |
MP | Method of Percent (Item Master) |
PA | Period Activity, Current |
PA+NN | Period Account, Current + nn Periods |
PA-NN | Period Account, Current - nn Periods |
PA0NN | Period Activity, Period nn |
PB | Prior Year-End Balance Forward (Inception-to-Date) |
PC | Prior Year's Current Period |
PO | Purchase Option Price (Item Master) |
PR | Prior Year's Year-to-Date to Current Period |
PY | Prior Year-End Balance Forward (Year-to-Date Net) |
Q1 | Quarter-to-Date 1st Quarter |
Q2 | Quarter-to-Date 2nd Quarter |
Q3 | Quarter-to-Date 3rd Quarter |
Q4 | Quarter-to-Date 4th Quarter |
RC | Replacement Cost (Item Master) |
RL | Replacement Cost Last Year (Item Master) |
RT | Retirement Amount |
SV | Salvage Value |
TI | Transfer In Amount |
TO | Transfer Out Amount |
VI | Value Index (Future) |
YC | Year-to-Date Activity through Current Period |
YC+NN | Year-to-Date Activity, through Current + nn Periods |
YC-NN | Year-to-Date Activity, through Current - nn Periods |
YC0NN | Year-to-Date Activity, through Period nn |
YY | Year-to-Date through Year-End |
Some column amount codes are relative to the current reporting period. Four basic types are available:
Column Amount | Description |
---|---|
AB | Account Balance, through Current Period |
IC | Inception-to-Date, through Current Period |
PA | Period Activity, Current |
YC | Year-to-Date Activity through Current Period |
These basic types can be combined with a plus, minus, or equal to designation:
Column Amount | Description |
---|---|
+nn | Current period plus nn periods |
-nn | Current minus nn periods |
0nn | Period nn |
For example, if the current reporting period is March:
Column Amount | Description |
---|---|
PA | March period activity |
PA+01 | April period activity |
PA-01 | February period activity |
PA001 | January period activity |
Some column amount codes are relative to only the current fiscal year:
Column Amount | Description |
---|---|
IY | Inception-to-Date |
YY | Year-to-Date through year end |
Q1 - Q4 | 1st quarter through 4th quarter |
For example, for a calendar year:
Column Amount | Description |
---|---|
Q1 | January plus February plus March period activities |
YY | Year-to-date through December 31 |
IY | Inception-to-date through December 31 |
Four prior year codes are available:
Column Amount | Description |
---|---|
PB | Prior year-end balance forward. This is the prior year version of IY. |
PC | Prior year's current period. This is the prior year version of PA. |
PR | Prior year's year-to-date to current period. This is the prior year version of YC. |
PY | Prior year-end balance. This is the prior year version of YY. |
More than one column amount code might retrieve the same information, depending on the type of account and fiscal year selections.
For example, AB (account balance as of current period) is the same as:
IC (inception-to-date through current period) for balance sheet accounts
YC (year-to-date through current period) for income statement accounts
PC (prior year's current period) with fiscal year of blank (current fiscal year) is the same as PA (current period) with fiscal year of -1 (current fiscal year minus one).