| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
TILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Tile Id
|
| 3 |
APOP_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
0=Invoice Date
1=Invoice Received Date
Default Value: 0
|
| 4 |
APOP_DTSEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Selection
0=Prior 'x' Days
1=Specify Date Range
Default Value: 0
|
| 5 |
DAYS |
Number(6,0) |
INTEGER NOT NULL |
Days
Default Value: 90
|
| 6 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 7 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 8 |
APOP_BU_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
BU Selection
N=All
Y=Specific
Default Value: N
|
| 9 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 10 |
APOP_VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
|
| 11 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURR_TXN_VW
|
| 12 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_APBANK_NONVW
|
| 13 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_AP_VW1
|
| 14 |
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
Prompt Table:
BNK_ACCT_AP_VW1
|
| 15 |
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
|
| 16 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 17 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
|
| 18 |
APOP_USERDSP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Option
A=All
B=Bottom 5 Payable Users
S=Specific
T=Top 5 Payable Users
Default Value: T
|
| 19 |
DISPLAY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 20 |
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.
Prompt Table:
RT_TYPE_TBL
|