| # |
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).
Prompt Table:
OPR_DEF_TBL_AP
|
| 3 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 4 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 5 |
PAY_RUN_DT |
Date(10) |
DATE |
Payment Run Date
|
| 6 |
PAY_FROM_DT |
Date(10) |
DATE |
Pay From Date
|
| 7 |
PAY_THRU_DT |
Date(10) |
DATE |
Pay Through Date
|
| 8 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 9 |
NEXT_PAY_THRU_DT |
Date(10) |
DATE |
Next Pay Through Date
|
| 10 |
NEXT_PYMNT_DT |
Date(10) |
DATE |
Next Payment Date
|
| 11 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 12 |
VNDR_PAYGRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Supplier Pay Group
|
| 13 |
SEL_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Selected Count
|
| 14 |
NEG_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Negative Balance Record Count
|
| 15 |
ERROR_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Error Count
|
| 16 |
SELECT_CNT |
Number(8,0) |
INTEGER NOT NULL |
Select Statement count
|
| 17 |
BAD_CUR_CNV_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Bad Currency Conversion Count
|
| 18 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 19 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 20 |
PYMNT_DEFN |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment Mapping Definition
|
| 21 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 22 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 23 |
PYMNT_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
|
| 24 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 25 |
PAY_DOC_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advice ID
|
| 26 |
PAY_DOC_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Advice Sequence
|
| 27 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 28 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 29 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 30 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 31 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 32 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 33 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 34 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 35 |
CUR_RT_TYPE_PYMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
|
| 36 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 37 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 38 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 39 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 40 |
BNK_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is stored either as
|
| 41 |
BNK_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is store
|
| 42 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 43 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 44 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 45 |
PYCYCL_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Cycle Operator (< or <=)
|
| 46 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 47 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 48 |
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
|
| 49 |
PREFERRED_LANG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Recipient's Pref. Lang.
|
| 50 |
PREFERRED_LANGUAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 51 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 52 |
PYCYCL_KEY_FIELD1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Pay Cycle Mapping Key Field 1
|
| 53 |
PYCYCL_KEY_FIELD2 |
Date(10) |
DATE |
Pay Cycle Mapping Key Field 2
|
| 54 |
PYCYCL_KEY_FIELD3 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Pay Cycle Mapping Key Field 3
|
| 55 |
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
|
| 56 |
PAY_GROUP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Pay Group SETID
|
| 57 |
PYMNT_GROUP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Group Code
|
| 58 |
PAY_DOC_DT |
Date(10) |
DATE |
Advice Date
|
| 59 |
PAUSE_AFTER_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pause after Payment Selection
|
| 60 |
PYCYCL_PROC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Processing Option
A=Payment Selection and Creation
B=Payment Creation
C=Reset Payments
D=Payment Selection
E=Check Restart
F=Draft Staging
|
| 61 |
INCLUDE_DISC_ALERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Lost Discount
|
| 62 |
CURTEMPINSTANCE |
Number(4,0) |
SMALLINT NOT NULL |
Temp Table Instance
|
| 63 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 64 |
PREV_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 65 |
SQL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
SQL Type
|
| 66 |
LOOP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 67 |
LOOP_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 68 |
LOOP_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 69 |
LOOP_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
|
| 70 |
LOOP_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 71 |
LOOP_PYMNT_HNDL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 72 |
PYMNT_OVRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Handling Override Amt
|
| 73 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 74 |
BANK_OVERRIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Replace
|
| 75 |
PRENOTE_CREATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process EFT/ACH Pre-Note
|
| 76 |
CRYSTAL_CHECK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Crystal Checks
|
| 77 |
RSTRT_ALIGNMENTS |
Number(2,0) |
SMALLINT NOT NULL |
Check Restart Alignment Count
|
| 78 |
PAY_RUN_AP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Run Status
1=Exceptions found
2=Nothing to process
3=Process running
6=Rejected
7=Selected/Staged
8=Waiting for Certification
C=Completed
D=Reset
E=Error
K=Restarted
N=New
R=Selected
U=Created
V=Trial Register Approved
X=Printed
Y=Confirmed
Z=Positive Payment Formatted
|
| 79 |
SAME_REF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Same Reference Numbers
|
| 80 |
RESTART_MODE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart Mode Flag
|
| 81 |
REMIT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Setid
|
| 82 |
REMIT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Code
|
| 83 |
REMIT_BNK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Remit Bank Account
|
| 84 |
LOOP_SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 85 |
LOOP_REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Setid
|
| 86 |
LOOP_REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Supplier
|
| 87 |
LOOP_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 88 |
LOOP_CURRENCY_PYMT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 89 |
LOOP_SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 90 |
LOOP_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 91 |
LOOP_MAX_REMIT_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Number of Remittances
|
| 92 |
EFT_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Selected Count
|
| 93 |
EFT_PAID_AMT_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gross Paid Amount
|
| 94 |
EFT_PAID_AMT_DSCNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Discount on Paid Amount
|
| 95 |
EFT_PAID_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Paid Amount
|
| 96 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 97 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 98 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 99 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 100 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 101 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 102 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 103 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 104 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 105 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 106 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 107 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 108 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 109 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 110 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 111 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 112 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 113 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 114 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 115 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 116 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 117 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 118 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 119 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 120 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 121 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 122 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 123 |
GROUP_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Selected Count
|
| 124 |
DO_DOC_SEQUENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Document Sequencing
|
| 125 |
MAX_REMITTANCE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Number of Remittances
|
| 126 |
BANKS_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Banks Found
|
| 127 |
MORE_BANKS |
Character(1) |
VARCHAR2(1) NOT NULL |
More Banks
|
| 128 |
AP_PAYMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
AP Payments
|
| 129 |
EX_PAYMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
EX Payments
|
| 130 |
ADVICE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Advice Exists
|
| 131 |
RPT_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Mode
|
| 132 |
EFTS_PROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
EFTs Processed
|
| 133 |
FORM_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow
|
| 134 |
QUOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Quote Symbol
|
| 135 |
PRENOTE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenote Type
|
| 136 |
PRENOTE_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Prenote Count
|
| 137 |
NEW_EFT_BANK |
Character(1) |
VARCHAR2(1) NOT NULL |
New EFT Bank ?
|
| 138 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 139 |
SORTFIELD |
Character(40) |
VARCHAR2(40) NOT NULL |
Sort Field
|
| 140 |
FILE_COPY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
File Copy
|
| 141 |
EFT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 142 |
EFT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 143 |
EFT_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
|
| 144 |
PRINT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Type
|
| 145 |
RPT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 146 |
RPT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 147 |
RPT_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
|
| 148 |
RPT_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 149 |
REPORT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Name
|
| 150 |
PRINT_SWITCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Switch
|
| 151 |
EFT_FILE_ID |
Number(4,0) |
SMALLINT NOT NULL |
EFT File ID
|
| 152 |
LAST_PYMNT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Payment Id
|
| 153 |
INPUT_NUM_P |
Number(10,0) |
DECIMAL(10) NOT NULL |
Input Number (Parameter)
|
| 154 |
OUTPUT_STRING_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Output String (Parameter)
|
| 155 |
EDIT_MASK_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Edit Mask
|
| 156 |
LAST_FORM_REF |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Form Reference
|
| 157 |
LAST_FORM_NBR_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Ref Number
|
| 158 |
LAST_PYMNT_ID_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Payment Id
|
| 159 |
SETID_P |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 160 |
BANK_CD_P |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 161 |
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
|
| 162 |
PYMNT_METHOD_P |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 163 |
RESTART_MODE_FLG_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart Mode Flag
|
| 164 |
SAME_REF_FLG_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Same Reference Numbers
|
| 165 |
NEXT_PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 166 |
PYMNT_ID_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Payment ID Count
|
| 167 |
NEXT_PYMNT_ID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Reference
|
| 168 |
PYMNT_ID_REF_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Payment ID Reference Count
|
| 169 |
DFI_ID_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
|
| 170 |
DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
|
| 171 |
REP_RTNG_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Routing Code
|
| 172 |
REMIT_BANK_ACCOUNT |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Account Number
|
| 173 |
REMIT_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch ID
|
| 174 |
REMIT_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 175 |
EFT_PYMNT_FMT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
|
| 176 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 177 |
UPDATE_PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 178 |
UPDATE_FORM_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Reference
|
| 179 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 180 |
RECON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
|
| 181 |
EFT_TRANS_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
|
| 182 |
DUPLICATE_PYMNT_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Payment ID ?
|
| 183 |
DUP_PYMNT_ID_REF |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Payment ID ?
|
| 184 |
COMMIT_STATUS |
Number(2,0) |
SMALLINT NOT NULL |
Commit Status
|
| 185 |
TOTAL_PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payments
|
| 186 |
REMIT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Remit Count
|
| 187 |
EFT_RTNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing
|
| 188 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
|
| 189 |
PYMNT_SORT_CD |
Number(3,0) |
SMALLINT NOT NULL |
Sort Code
|
| 190 |
VCHR_PYMNT_HNDLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Voucher Payment Handling
|
| 191 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 192 |
ADDR_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Address Name 1
|
| 193 |
ADDR_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Address Name 2
|
| 194 |
SELECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Select Status
|
| 195 |
PYMNT_SRC_PROD |
Character(2) |
VARCHAR2(2) NOT NULL |
PeopleSoft Product
AP=Payables
EX=Expenses
PO=Purchasing
PR=Payroll
TR=Treasury
|
| 196 |
PYMNT_SRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Type
O=External
P=PeopleSoft
|
| 197 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 198 |
LAST_PAYMENT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Payment Number Numeric
|
| 199 |
ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 200 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 201 |
BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 202 |
CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 203 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 204 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 205 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 206 |
FORM_ALIGNMENT_CNT |
Number(2,0) |
SMALLINT NOT NULL |
Form Alignment Count
|
| 207 |
FORM_NBR_CONFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm Numbers
|
| 208 |
REMIT_MAX_LINES |
Number(3,0) |
SMALLINT NOT NULL |
Advice Lines
|
| 209 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 210 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 211 |
RECON_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
|
| 212 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 213 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|
| 214 |
POSITIVE_PAY_DT |
Date(10) |
DATE |
Positive Payment Date
|
| 215 |
POSITIVE_PAY_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Payment Status
C=Sent to bank
N=Not Sent to bank
S=Selected for transmission
Z=Zero Payment
|
| 216 |
TRANSIT_NUM |
Character(9) |
VARCHAR2(9) NOT NULL |
Bank Transit #
|
| 217 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
|
| 218 |
DISCOUNT_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 219 |
PYMNT_ADVICE_COMBO |
Character(38) |
VARCHAR2(38) NOT NULL |
Payment Advice Combo Key
|
| 220 |
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. "
|
| 221 |
CALENDAR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetID
|
| 222 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 223 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 224 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 225 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 226 |
REMIT_LINE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remit Line Type
A=Remittance Advice Line
M=Remittance Message Line
|
| 227 |
MIN_PYMNT_ID_REF |
Character(12) |
VARCHAR2(12) NOT NULL |
Last Form Reference
|
| 228 |
STARTING_FORM_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
First Payment
|
| 229 |
PRINT_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Payment ?
|
| 230 |
TMP_REMIT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Remit Count
|
| 231 |
PAID_VOUCHER_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Paid Vouchers Count
|
| 232 |
COUNT_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Done
|
| 233 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 234 |
OVERFLOW_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Overflow Location
C=Same report as check
N=No advice report
S=Separate advice report
|
| 235 |
AE_APPL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Application
|
| 236 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 237 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
Default Value: 0
|
| 238 |
CALC_LINE_NBR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate PO Line Numbers
|
| 239 |
DUMMY_NUM |
Number(6,0) |
INTEGER NOT NULL |
DUMMY NUM
|
| 240 |
ERRORS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates errors were found
N=No
Y=Yes
Default Value: N
|
| 241 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 242 |
VNDR_SERVICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Type
|
| 243 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 244 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 245 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|