| # |
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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 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_SCHD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Type
A=Annual Calendar
P=Detail Calendar
Q=Quarterly Calendar
Default Value: P
|
| 12 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 13 |
AMR_CAL_ID_QT |
Character(2) |
VARCHAR2(2) NOT NULL |
Amortization qaurterly summary calendar
|
| 14 |
AMR_CAL_ID_YR |
Character(2) |
VARCHAR2(2) NOT NULL |
Amortization annual summary calendar
|
| 15 |
FISCAL_YEAR_FROM |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
Prompt Table:
%EDITTABLE
|
| 16 |
TO_YR |
Number(4,0) |
SMALLINT NOT NULL |
To Year/Period
Prompt Table:
%EDITTABLE3
|
| 17 |
FROM_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
From Period
Prompt Table:
%EDITTABLE2
|
| 18 |
TO_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
To Period
Prompt Table:
%EDITTABLE4
|
| 19 |
AMR_JDATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date Option
B=Beginning of Period
E=End of Period
Default Value: B
|
| 20 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 21 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 22 |
AMR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Amortization Status
C=Completed
I=In Progress
P=Pending
X=Cancelled
|
| 23 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 24 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 25 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 26 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 27 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 28 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 29 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 30 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 31 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 32 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 33 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 34 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 35 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 36 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 37 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 38 |
VOUCHER_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Amount
|
| 39 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 40 |
AMR_DISTRIB_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Distribution Line Amount
|
| 41 |
AMR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount To Amortize
|
| 42 |
AMR_OTHER_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Distribution Amount
|
| 43 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 44 |
AMR_AMT_FOREIGN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amortization foreign amount
|
| 45 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 46 |
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.
|
| 47 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 48 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 49 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 50 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 51 |
AMR_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amortization Balance
|
| 52 |
AMR_BAL_FOREIGN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amortization Balance Foreign
|
| 53 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 54 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 55 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 56 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 57 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 58 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 59 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 60 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
|
| 61 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 62 |
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
|
| 63 |
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
|
| 64 |
LOCKOUT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock out updates
|