| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PAY_CYCLE_SEQ_NUM2 |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 3 |
CK_EDIT_MASK |
Character(10) |
VARCHAR2(10) NOT NULL |
Edit Mask
|
| 4 |
CK_PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 5 |
CK_REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Setid
|
| 6 |
CK_REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Supplier
|
| 7 |
CK_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location
|
| 8 |
CK_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 9 |
CK_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 10 |
CK_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 11 |
CK_PYMNT_REF_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Reference Number
|
| 12 |
CK_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 13 |
CK_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 14 |
CK_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
|
| 15 |
CK_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 16 |
CK_CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 17 |
CK_BANK_ACCT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 18 |
CK_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 19 |
CK_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 20 |
CK_PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 21 |
CK_PAY_DOC_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Advice Sequence
|
| 22 |
CK_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 23 |
CK_SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 24 |
CK_PAY_DOC_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advice ID
|
| 25 |
CK_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 1
|
| 26 |
CK_ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 2
|
| 27 |
CK_ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 28 |
CK_ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 4
|
| 29 |
CK_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 30 |
CK_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 31 |
CK_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 32 |
CK_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 33 |
CK_IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 34 |
CK_COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 35 |
CK_GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Tax Supplier Geographical Code
|
| 36 |
CK_PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 37 |
CK_PYMNT_HNDL_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 38 |
CK_PYMNT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
|
| 39 |
CK_POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
|
| 40 |
CK_PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type
|
| 41 |
CK_PREFERRED_LANG |
Character(3) |
VARCHAR2(3) NOT NULL |
Preferred Language
|
| 42 |
CK_NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 43 |
CK_NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 44 |
CK_HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
|
| 45 |
CK_PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 46 |
CK_PAY_CYCLE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 47 |
CK_PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 48 |
CK_CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 49 |
CK_ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 50 |
CK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 51 |
CK_CASH_CLEARD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Cleared Flag
|
| 52 |
CK_CANCEL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Action
|
| 53 |
CK_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Id
|
| 54 |
CK_FORM_NBR_CNFRMD |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Number Confirmed
|
| 55 |
CK_DOC_SEQ_DATE |
Date(10) |
DATE |
Document Sequence Date
|
| 56 |
CK_DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Document Sequence Number
|
| 57 |
CK_DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Sequencing Status
|
| 58 |
CK_DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
|
| 59 |
CHAR_FIELD |
Character(50) |
VARCHAR2(50) NOT NULL |
Character Field
|
| 60 |
PROCESS_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Payment
|
| 61 |
FIRST_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
First Field
|
| 62 |
FIRST_ADVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
First Advice
|
| 63 |
FIRST_REMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
First Remitance
|
| 64 |
FIRST_REMITANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
First Remitance
|
| 65 |
BASE_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 66 |
PYMNT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 67 |
MAINSORT |
Character(254) |
VARCHAR2(254) NOT NULL |
Main Sort
|
| 68 |
PAY_DOC_SRCH |
Character(8) |
VARCHAR2(8) NOT NULL |
Pay Document Search
|
| 69 |
INVOICE1_ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 70 |
INVOICE1_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 71 |
INVOICE2_ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 72 |
INVOICE2_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 73 |
NEW_ADVICE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Advice Flag
|
| 74 |
CK_NBR_LEN |
Number(3,0) |
SMALLINT NOT NULL |
Check # Length
|
| 75 |
BASE_CURR_GL_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 76 |
DOCSQ_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 77 |
NUM_OF_ALIGNMENTS |
Number(2,0) |
SMALLINT NOT NULL |
Check Restart Alignment Count
|
| 78 |
ALIGNMENTS_DONE |
Number(2,0) |
SMALLINT NOT NULL |
Check Restart Alignment Count
|
| 79 |
LEADING_ZERO_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Check # Length
|
| 80 |
PAY_PYMNT_ID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Reference
|
| 81 |
PAY_PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 82 |
OLD_PYMNT_ID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Reference Number
|
| 83 |
AR_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Our Customer Number
|
| 84 |
ZEROES |
Character(20) |
VARCHAR2(20) NOT NULL |
Zeroes
|
| 85 |
PRIOR_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 86 |
PRIOR_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 87 |
PRIOR_BNK_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
|
| 88 |
PRIOR_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 89 |
LAST_EFT_FILE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Last File Number
|
| 90 |
DOCSQ_ENABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Doc Sequencing Enabled ?
|
| 91 |
LEADING_ZEROES |
Character(20) |
VARCHAR2(20) NOT NULL |
Zeroes
|
| 92 |
BUS_UNIT_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Table
|
| 93 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 94 |
EFT_KEY_FIELD1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 95 |
EFT_KEY_FIELD2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Supplier ID
|
| 96 |
EFT_KEY_FIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location
|
| 97 |
EFT_KEY_FIELD4 |
Date(10) |
DATE |
Effective Date
|
| 98 |
EFT_KEY_FIELD5 |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Seq Number
|
| 99 |
EFT_KEY_FIELD6 |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Seq Number
|
| 100 |
CUR_RT_TYPE_PAID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Rate Type
|
| 101 |
CK_NBR_LEN_P |
Number(3,0) |
SMALLINT NOT NULL |
Check # Length
|
| 102 |
EXPRESS_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Express Payment ?
|
| 103 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 104 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 105 |
BRANCH_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Name
|
| 106 |
TOTAL_PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Paid Amount
|
| 107 |
DFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Payment Status
A=Approved
C=Created
D=Due
N=Non-Draft Payment
R=Reconciled
W=Write Off
X=Write Off Posted
|
| 108 |
CK_ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 109 |
CK_ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 110 |
CK_ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 111 |
FILE_EXTENSION |
Character(4) |
VARCHAR2(4) NOT NULL |
File Extension
|
| 112 |
FORM_LAYOUT |
Character(2) |
VARCHAR2(2) NOT NULL |
Form Layout
|
| 113 |
PREPAID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid offering
N=Exclude Prepaid
Y=Include Prepaid
|
| 114 |
WTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding
Y=Withholdeable
|
| 115 |
SBI_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
SBI_num
|
| 116 |
ADVICE_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Advice sequence Number
|
| 117 |
ADVICE_SEQ_CHAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Advice Sequence
|
| 118 |
RPT_CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 119 |
EFT_CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 120 |
CK_BUS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 121 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 122 |
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.
|
| 123 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 124 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 125 |
SEQ_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sequence By
C=Journal Code
D=Document Type
|
| 126 |
C_SEQ_RANGE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
C Sequence Range ID
|
| 127 |
JRNL_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Journal Code
|
| 128 |
D_SEQ_RANGE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
D Sequence Range ID
|
| 129 |
SEQ_RANGE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Sequence Range
|
| 130 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 131 |
GRP_PYMNT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group by Payment Date
|
| 132 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 133 |
SELECT_WHERE |
Long Character |
CLOB |
Select Where Clause
|
| 134 |
PREPAID_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 135 |
PREPAID_VCHR1 |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 136 |
PREPAID_VCHR2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 137 |
PREPAID_CNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 138 |
REF_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 139 |
REF_VCHR |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 140 |
REF_CNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 141 |
RSTRT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 142 |
RSTRT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 143 |
RSTRT_BNK_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 |
RSTRT_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
DD=Direct Debit
DFT=Draft - Supplier Initiated
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Report
|
| 145 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 146 |
DFT_CONTROL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Draft Control ID
|
| 147 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 148 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 149 |
DFT_MASTER_ID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 150 |
DFT_CREATE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Create Key
|
| 151 |
PROC_DFT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Optimization
Y/N Table Edit
Default Value: N
|
| 152 |
DFT_STMP_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Draft StampTax Amount
|
| 153 |
DFT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Type
A=Automatic
M=Manual
|
| 154 |
OK_TO_CREATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Ok to Create
|
| 155 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 156 |
COMMIT_STATUS2 |
Number(2,0) |
SMALLINT NOT NULL |
Commit Status
|
| 157 |
IS_DRAFT_PYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Draft Payment
|
| 158 |
CHAR_FIELD_15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Character Field
|
| 159 |
SPEC_PYMNT_EX_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Specify Pymnt Ex Rate
|
| 160 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 161 |
PAID_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as
|
| 162 |
PAID_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is store
|
| 163 |
TEMP_NUM2 |
Number(2,0) |
SMALLINT NOT NULL |
Temp Num2
|
| 164 |
APPLIED_AMT_PPAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Applied to Prepayment
|
| 165 |
REMIT_LINES |
Number(3,0) |
SMALLINT NOT NULL |
Remit Lines
|
| 166 |
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
|
| 167 |
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
|
| 168 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
|
| 169 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 170 |
PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 171 |
SINGLE_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Payment
|
| 172 |
IPAC_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Payment flag - will indicate that a payment is for IPAC
|
| 173 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 174 |
LAST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The status of a given position limit when the same last underwent processing.
O=Over
U=Under
|
| 175 |
DFT_APPROVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Issue Approval Required
|
| 176 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 177 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 178 |
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
|
| 179 |
LAST_FORM_NBR_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Ref Number
|
| 180 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 181 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 182 |
PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Flag
|
| 183 |
PYMNT_FILENAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Report ID
|
| 184 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 185 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 186 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 187 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|