AMAE_TMPLID_TBL(SQL Table) |
Index Back |
|---|---|
Acctg Entry Template ID Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ACCT_ENT_TMPL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Account Entry Template ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DEROGATORY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Derogatory Depreciation
Y/N Table Edit Default Value: N |
| 5 | LIKE_KIND_SW | Character(1) | VARCHAR2(1) NOT NULL |
Like Kind Exchange
Y/N Table Edit Default Value: N |
| 6 | REVALUATION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Revaluation
Y/N Table Edit Default Value: N |
| 7 | SALE_ACCT_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Sale Accounting Method
G=Create Gain/Loss Lines N=Create Net Book Value lines Default Value: G |
| 8 | BOOK_CODE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Show Book Code
Y/N Table Edit Default Value: N |
| 9 | CAP_THRSHLD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Cap Threshold Processing
Y/N Table Edit Default Value: N |
| 10 | REV_NET_METHOD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Net Method
Y/N Table Edit Default Value: N |
| 11 | AM_FED_FUND_SW | Character(1) | VARCHAR2(1) NOT NULL |
Federal Fund
Y/N Table Edit Default Value: N |