AMR_WC_VW

(SQL View)
 Index Back

Amortization header

Amortization header Record

SELECT DISTINCT A.BUSINESS_UNIT_GL , A.AMORTIZATION_ID , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.AMORT_TYPE , A.AMR_SETID , A.DST_CNTRL_ID , A.ACCTG_TMPL_SETID , A.AMR_STATUS , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF15_AN_SBR, A) , A.VOUCHER_AMT , A.TXN_CURRENCY_CD , A.AMR_DISTRIB_AMT , A.AMR_AMT , A.AMR_OTHER_AMT , A.CURRENCY_CD , A.AMR_AMT_FOREIGN , A.FOREIGN_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.LEDGER , A.LEDGER_GROUP , A.AMR_BAL_AMT , A.AMR_BAL_FOREIGN , %subrec(PC_CF1_N_SBR, A) , A.START_DATE , A.END_DATE , A.POST_STATUS_AP , A.ENTRY_STATUS , A.CALENDAR_ID , A.AMR_CAL_ID_QT , A.AMR_CAL_ID_YR , A.SCHEDULE_TYPE , A.VOUCHER_ID_RELATED , A.POST_STATUS FROM PS_AMR_VCHR_HDR_VW A WHERE A.AMR_STATUS = ('P' ) OR ( A.AMR_STATUS = ('I' ) AND A.AMORTIZATION_ID IN ( SELECT B.AMORTIZATION_ID FROM PS_AMR_SCH_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM AND A.AMORTIZATION_ID = B.AMORTIZATION_ID AND A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL AND B.AMR_SCH_STATUS = 'P' ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

2 AMORTIZATION_ID Character(10) VARCHAR2(10) NOT NULL Amortization ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AP_NONVW

4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

Default Value: 1

6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

7 AMORT_TYPE Character(4) VARCHAR2(4) NOT NULL Amortization Type

Prompt Table: AMR_TYPE_DVW

8 AMR_SETID Character(5) VARCHAR2(5) NOT NULL Amortization Type SETID
9 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
10 ACCTG_TMPL_SETID Character(5) VARCHAR2(5) NOT NULL Accounting Template SetID
11 AMR_STATUS Character(1) VARCHAR2(1) NOT NULL Amortization Status
C=Completed
I=In Progress
P=Pending
X=Cancelled
12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: AMR_VCHR_ACC_VW

13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

16 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

17 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

18 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

19 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

20 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

21 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

22 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

23 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

24 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

25 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

26 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

27 VOUCHER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Amount
28 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
29 AMR_DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Distribution Line Amount
30 AMR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount To Amortize
31 AMR_OTHER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Distribution Amount
32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
33 AMR_AMT_FOREIGN Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization foreign amount
34 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
35 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
36 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
37 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
38 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
39 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
40 AMR_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization Balance
41 AMR_BAL_FOREIGN Signed Number(28,3) DECIMAL(26,3) NOT NULL Amortization Balance Foreign
42 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

43 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

44 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

45 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

46 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

47 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

48 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

49 START_DATE Date(10) DATE Start Date for Gen Standing PO
50 END_DATE Date(10) DATE End Date
51 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
52 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
53 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
54 AMR_CAL_ID_QT Character(2) VARCHAR2(2) NOT NULL Amortization qaurterly summary calendar
55 AMR_CAL_ID_YR Character(2) VARCHAR2(2) NOT NULL Amortization annual summary calendar
56 SCHEDULE_TYPE Character(15) VARCHAR2(15) NOT NULL Phase Type
57 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
58 POST_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All
C=Complete
E=Errors
N=Not Posted