AM_DOCTYPE_TMPL

(SQL Table)
Index Back

AM doc type template

# 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 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

3 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

Prompt Table: TRANS_CODE_VW

4 DOC_TYPE_ADD Character(10) VARCHAR2(10) NOT NULL Add

Prompt Table: DOC_TYPE_TBL

5 DOC_TYPE_ADJ Character(10) VARCHAR2(10) NOT NULL Adjustment

Prompt Table: DOC_TYPE_TBL

6 DOC_TYPE_DEPR Character(10) VARCHAR2(10) NOT NULL Depreciation

Prompt Table: DOC_TYPE_TBL

7 DOC_TYPE_DEPR_REV Character(10) VARCHAR2(10) NOT NULL Depr Reversal

Prompt Table: DOC_TYPE_TBL

8 DOC_TYPE_IMPAIR Character(10) VARCHAR2(10) NOT NULL Impairment

Prompt Table: DOC_TYPE_TBL

9 DOC_TYPE_IMPREV Character(10) VARCHAR2(10) NOT NULL Impairment Reverse

Prompt Table: DOC_TYPE_TBL

10 DOC_TYPE_INFLATION Character(10) VARCHAR2(10) NOT NULL Inflation

Prompt Table: DOC_TYPE_TBL

11 DOC_TYPE_LEASEPAY Character(10) VARCHAR2(10) NOT NULL Lease Payment

Prompt Table: DOC_TYPE_TBL

12 DOC_TYPE_LSEPAYREV Character(10) VARCHAR2(10) NOT NULL Lease Pay Reversal

Prompt Table: DOC_TYPE_TBL

13 DOC_TYPE_PDP Character(10) VARCHAR2(10) NOT NULL PDP

Prompt Table: DOC_TYPE_TBL

14 DOC_TYPE_PDPREV Character(10) VARCHAR2(10) NOT NULL PDP Reverse

Prompt Table: DOC_TYPE_TBL

15 DOC_TYPE_REINSTATE Character(10) VARCHAR2(10) NOT NULL Reinstate

Prompt Table: DOC_TYPE_TBL

16 DOC_TYPE_RESERVE Character(10) VARCHAR2(10) NOT NULL Reserve

Prompt Table: DOC_TYPE_TBL

17 DOC_TYPE_RETIRE Character(10) VARCHAR2(10) NOT NULL Retire

Prompt Table: DOC_TYPE_TBL

18 DOC_TYPE_RECAT Character(10) VARCHAR2(10) NOT NULL Recategorize

Prompt Table: DOC_TYPE_TBL

19 DOC_TYPE_TRANS Character(10) VARCHAR2(10) NOT NULL Transfer

Prompt Table: DOC_TYPE_TBL

20 DOC_TYPE_REVALUTE Character(10) VARCHAR2(10) NOT NULL Revaluation

Prompt Table: DOC_TYPE_TBL