| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 5 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 6 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 7 |
TEMP_NBR1 |
Number(7,0) |
INTEGER NOT NULL |
Temporary Number
|
| 8 |
TEMP_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
Temporary Query Value
|
| 9 |
SEQ_NUM2 |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
|
| 10 |
RESET_OK |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset OK
|
| 11 |
VOUCHER_ID_TMP |
Character(8) |
VARCHAR2(8) NOT NULL |
Temporary Voucher ID
|
| 12 |
PYMNT_CNT_NEXT |
Number(5,0) |
INTEGER NOT NULL |
Next Sequential Payment Count
|
| 13 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 14 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 15 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 16 |
NETTING_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Netting Option
A=Process All Netting IDs
N=Not Applicable
S=Specify Netting ID
|
| 17 |
NET_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank SetID
|
| 18 |
NET_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank Code
|
| 19 |
NET_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Netting Bank Account Key
|
| 20 |
PAYMENT_METHOD_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method - Payable
ACH=ACH
CHK=System Check
DD=Direct Debit
EFT=EFT
MAN=Manual Check
WIR=Wire Report
|
| 21 |
PAY_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID for a bank on the disbursing side of a settlement transaction.
|
| 22 |
PAY_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The bank for the disbursing side of a settlement transaction.
|
| 23 |
PAY_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The bank account for the disbursing side of a settlement transaction.
|
| 24 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 25 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 26 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 27 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 28 |
NET_CLOSING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Closing Method
F=Full
P=Partial
|
| 29 |
NET_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A reference identifier associated with a cash transaction subject to netting with a given bank/count
|
| 30 |
NETTING_SEQ_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Netting Sequence Number
|
| 31 |
NET_TXN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Status
B=Balance
D=DeSelect - Full
DB=DeSelect Split - Balance
DF=DeSelect - Full
DN=DeSelect Split - Net
N=Net
NA=Not Applicable
S=Split - Net / Balance
|
| 32 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 33 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 34 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 35 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 36 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 37 |
NETTING_DATE |
Date(10) |
DATE |
Netting Date. Used to Define the date that the netting will take place.
|
| 38 |
NETTING_STL_DATE |
Date(10) |
DATE |
Netting Settlement Date. This date becomes the due date of the Netting Balance for AP and AR transactions.
|
| 39 |
NETTING_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Netting Currency
|
| 40 |
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. "
|
| 41 |
DSLCT_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
DeSelected Amount
|
| 42 |
DSLCT_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Deselect Amount Base
|
| 43 |
NET_PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netting Payment Amount
|
| 44 |
NET_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Amount
|
| 45 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 46 |
BAL_PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Payment Amount
|
| 47 |
BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance - Base Currency
|
| 48 |
DISC_APPL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Discount Applied Amount
|
| 49 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
Default Value: 1
|
| 50 |
PYMNT_CNT_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total Payment Count
Default Value: 1
|
| 51 |
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.
|
| 52 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 53 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 54 |
TOTAL_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all outbound transact
|
| 55 |
TOTAL_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payment Amount - Base
|
| 56 |
TOTAL_AP_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Payable Transactions
|
| 57 |
TOTAL_RCV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all inbound transacti
|
| 58 |
TOTAL_REC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Receivable Amount - Base
|
| 59 |
TOTAL_AR_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Receivable Transactions
|
| 60 |
NET_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netted Amount
|
| 61 |
NET_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netting Balance Amount Base
|
| 62 |
BAL_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount
|
| 63 |
BAL_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount Base
|
| 64 |
PAY_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount
|
| 65 |
PAY_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount Base
|
| 66 |
PAY_DISC_APPL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Paid Amount
|
| 67 |
PAY_DISC_APPL_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Paid Amount Base
|
| 68 |
RCV_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount
|
| 69 |
RCV_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount Base
|
| 70 |
RCV_DISC_APPL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Paid Amount
|
| 71 |
RCV_DISC_APPL_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Paid Amount Base
|
| 72 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 73 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 74 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 75 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
|
| 76 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 77 |
VCHR_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
|
| 78 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 79 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 80 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 81 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 82 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 83 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 84 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 85 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 86 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 87 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 88 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 89 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 90 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 91 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 92 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 93 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 94 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 95 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 96 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 97 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 98 |
EFT_PYMNT_FMT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
|
| 99 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 100 |
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
|
| 101 |
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
|
| 102 |
BUDGET_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
|
| 103 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 104 |
CUR_RT_TYPE_PAID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Rate Type
|
| 105 |
BUSINESS_UNIT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
|
| 106 |
VOUCHER_ID_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
To Voucher ID
|
| 107 |
PYMNT_CNT2 |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 108 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 109 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 110 |
NET_APPLY_DSCNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to apply AP/AR discount amounts to the netted transactions.
|