SMT_SPLIT_DTL(SQL Table) |
Index Back |
---|---|
Split Conditions Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | SMT_SPLIT_ID | Character(5) | VARCHAR2(5) NOT NULL | Payment Split ID |
3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
6 | ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL | Row_Number |
7 | SMT_SPLIT_PERCENT | Number(12,8) | DECIMAL(11,8) NOT NULL | Reschedule Percentage |
8 | 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 |
9 | SMT_TERMS_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SMTTM_NONVW |
10 | 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.
Prompt Table: SMT_PYMT_TRM_VW |
11 | SMT_SIGHT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SMTST_NONVW |
12 | DFT_SIGHT_CD | Character(5) | VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table: SMT_SIGHTCD_VW |
13 | REUSABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit Default Value: N |
14 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETBNK_NONVW |
15 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW8 |
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
Prompt Table: BANK_ACCT_VW11 |