| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 2 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
SMT_GROUP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group ID
|
| 4 |
SMT_CREATE_KEY |
Number(5,0) |
INTEGER NOT NULL |
Create Key
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 7 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 8 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 10 |
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
|
| 11 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 12 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 13 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 14 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 15 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 16 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 17 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 18 |
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. "
|
| 19 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 20 |
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
|
| 21 |
SMT_TERMS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 22 |
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.
|
| 23 |
SMT_SIGHT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 24 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
|
| 25 |
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.
|
| 26 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 27 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 28 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 29 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 30 |
SMT_SPLIT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Split ID
|
| 31 |
SMT_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 32 |
SMT_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 33 |
SMT_BK_ACT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Seq Nbr
|
| 34 |
SMT_PYMT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 35 |
SMT_GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 36 |
SMT_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.
|
| 37 |
SMT_SCHED_PAY_DT |
Date(10) |
DATE |
Scheduled Pay Date
|
| 38 |
SMT_DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
|
| 39 |
SMT_DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 40 |
SMT_DFT_SCH_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 41 |
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
|
| 42 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
|
| 43 |
NET_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Netting Select Status
H=Hold
N=Not Applicable
S=Selected
|
| 44 |
BANK_SETID_PRIOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Prior Bank Setid
|
| 45 |
BANK_CD_PRIOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Prior Bank Code
|
| 46 |
BANK_ACCT_KEY_P |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|