| # |
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 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 5 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 6 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 7 |
SMT_DATE |
Date(10) |
DATE |
Date
|
| 8 |
DAYOFMONTH |
Number(2,0) |
SMALLINT NOT NULL |
Day of Month
|
| 9 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 10 |
SMT_GROUP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group ID
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 13 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 14 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 15 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 16 |
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
|
| 17 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 18 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 19 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 20 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 21 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 22 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 23 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 24 |
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
|
| 25 |
SMT_TERMS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 26 |
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.
|
| 27 |
SMT_SIGHT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 28 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
|
| 29 |
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.
|
| 30 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 31 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 32 |
SMT_SPLIT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Split ID
|
| 33 |
SMT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Split/Multi Payment Status
C=Canceled
E=Group Error
EB=Bank Account SEQ NBR Not Found
EI=Invalid Split ID
EP=Invalid Payment Method
ES=Invalid Sight Code
ET=Invalid Term Code
I=Inserted
PM=Valid Payment Method
S=Selected
SC=Valid Sight Code
SD=Set Due Date
SE=Set Scheduled Pay Date
SM=Set Maturity Date
SP=Set Payment Information
SS=Set Scheduled Maturity Date
U=Updated
|
| 34 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 35 |
SMT_SPLIT_PERCENT |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Reschedule Percentage
|
| 36 |
ROW_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Row_Number
|
| 37 |
TOTAL_ROWS |
Number(6,0) |
INTEGER NOT NULL |
Values Found
|
| 38 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
|
| 39 |
MAX_NBR |
Number(5,0) |
INTEGER NOT NULL |
Max Number
|
| 40 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 41 |
SPLIT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Split Amount
|
| 42 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 43 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 44 |
TEMP_DT |
Date(10) |
DATE |
Temp Date
|
| 45 |
NBR_OF_TERMS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Terms
|
| 46 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 47 |
PYMNT_TERMS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Type
M=Multi-Payment Terms
S=Single-Payment Terms
|
| 48 |
PAY_TRMS_TIME_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Timing Definition ID
|
| 49 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 50 |
TMG_BASIS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Timing Basis Option
F=Fixed Month/Day Values:
M=End of Relative Month:
N=None (Basis Date)
S=Specific Due Date:
|
| 51 |
TMG_REL_MONTH_VAL |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
End of Relative Month
|
| 52 |
TMG_MONTH_DUE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month Due
|
| 53 |
TMG_DAY_DUE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Day Due
|
| 54 |
TMG_DAY_INCR_VAL |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Day Increment
|
| 55 |
TMG_MONTH_INCR_VAL |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Month Increment
|
| 56 |
TMG_YEAR_INCR_VAL |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Year Increment
|
| 57 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 58 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 59 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 60 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 61 |
HOL_PROC_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing level
B=Specify Calendar at Bank level
U=Specify Calendar
|
| 62 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 63 |
NMBR_MTH |
Number(2,0) |
SMALLINT NOT NULL |
Number of Months
|
| 64 |
NMBR_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Number of Days
|
| 65 |
BASIS_DATE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis Date Code
D=Draft Issue Date
I=Invoice Date
|
| 66 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 67 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 68 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 69 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 70 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 71 |
AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 72 |
AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 73 |
PYMNT_MESSAGE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Message Code
|
| 74 |
ORDERBYNUM |
Number(3,0) |
SMALLINT NOT NULL |
Order-By Number
|
| 75 |
SMT_CREATE_KEY |
Number(5,0) |
INTEGER NOT NULL |
Create Key
|