| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUS_AP_NONVW
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT
|
| 3 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 4 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 5 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 6 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
|
| 7 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 8 |
BUDGET_MISC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Misc Status
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
|
| 9 |
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
Default Value: O
|
| 10 |
DOC_TOL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
Default Value: V
|
| 11 |
COMBO_ERROR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Vouchers with Combo Errors
Y/N Table Edit
Default Value: N
|
| 12 |
MATCH_STATUS_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
Default Value: N
|
| 13 |
APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P
|