| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 2 |
CONTROL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 5 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 6 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 7 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 8 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 9 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 10 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 11 |
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
|
| 12 |
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. "
|
| 13 |
LATE_CHRG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges
N=Not Applicable
|
| 14 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
|
| 15 |
LATE_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount
|
| 16 |
MIN_LATE_CHRG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimum Late Charge
|
| 17 |
SIMPLE_INTR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Simple Interest Days
|
| 18 |
COMPOUND_INTR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Compound Interest Days
|
| 19 |
NO_PAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
No Pay Days
|
| 20 |
DAYS_IN_YEAR |
Number(3,0) |
SMALLINT NOT NULL |
Days in Year
|
| 21 |
INTEREST_RATE |
Number(9,5) |
DECIMAL(8,5) NOT NULL |
Interest Rate
|
| 22 |
COMPOUND_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Compound Days
|
| 23 |
SIMPLE_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Simple Days
|
| 24 |
SIMPLE_INTR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Simple Interest Amount
|
| 25 |
COMPOUND_INTR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Compound Interest Amount
|
| 26 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 28 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 29 |
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
TMPL=Template Voucher
|
| 30 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 31 |
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
|
| 32 |
INTEREST_RATE1 |
Number(9,5) |
DECIMAL(8,5) NOT NULL |
Annual Interest
|