AMR_SCH_DTL (SQL Table)	Index Back
Amortization Schedule Detail Amortization Schedule Detail

AMR_SCH_DTL

(SQL Table)

Amortization Schedule Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
Default Value: 1

4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
Default Value: 1

5 AMORTIZATION_ID Character(10) VARCHAR2(10) NOT NULL Amortization ID

6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BU_GL_NONVW

7 AMR_SEQ Number(5,0) INTEGER NOT NULL Amortization Sequence

8 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

9 AMR_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Stage ID

10 AMORT_TYPE Character(4) VARCHAR2(4) NOT NULL Amortization Type
Prompt Table: AMORT_TYP

11 AMR_JRNL_DATE Date(10) DATE Journal Creation Date

12 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

13 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

16 AMR_JRNL_STATUS Character(1) VARCHAR2(1) NOT NULL Journal Status
C=Created
E=Journal Has Errors
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
V=Valid Journal - Edits Complete

17 AMR_JRNL_TYPE Character(1) VARCHAR2(1) NOT NULL Journal type
R=Actual Journal
S=Stage Journal

18 AMR_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule status
C=Completed
D=Created
P=Pending
R=Ready
X=Canceled

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number Default Value: 1
4	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
5	AMORTIZATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Amortization ID
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
7	AMR_SEQ	Number(5,0)	INTEGER NOT NULL	Amortization Sequence
8	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
9	AMR_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Stage ID
10	AMORT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Amortization Type Prompt Table: AMORT_TYP
11	AMR_JRNL_DATE	Date(10)	DATE	Journal Creation Date
12	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
13	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
16	AMR_JRNL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Journal Status C=Created E=Journal Has Errors N=No Status - Needs to be Edited P=Posted to Ledger(s) V=Valid Journal - Edits Complete
17	AMR_JRNL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Journal type R=Actual Journal S=Stage Journal
18	AMR_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule status C=Completed D=Created P=Pending R=Ready X=Canceled