BUSINESS_UNIT_GLDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW
AMORTIZATION_IDDefault Value: 1
Default Value: 1
AMR_SCH_HDR_VW(SQL View) |
Index Back |
|---|---|
Amortization Schedule Hdr viewAmortization Schedule Header view |
| SELECT BUSINESS_UNIT_GL , AMORTIZATION_ID , BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , DISTRIB_LINE_NUM FROM PS_AMR_SCH_HDR |
| # | 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 |
| 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 |