| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DRAFT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table:
SP_BUARDS_NONVW
|
| 2 |
DRAFT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
Default Value: NEXT
Prompt Table:
DRAFT_CONTROL
|
| 3 |
DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
A=Accepted
C=Complete
D=Dishonored
E=Void
I=Identified
L=Collateral
M=Discounted
N=No Action
P=Pending
R=Remitted
T=Endorsed
Default Value: I
|
| 4 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
SP_CSRCH2_NONVW
Set Control Field: DRAFT_BU
|
| 5 |
DRAFT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.
|
| 6 |
DRAFT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Draft Count
|
| 7 |
DRAFT_DUE_DT |
Date(10) |
DATE |
Draft Due Date
|
| 8 |
DRAFT_DUE_DATE2 |
Date(10) |
DATE |
Draft Due Date
|
| 9 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 10 |
DRAFT_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required
|
| 11 |
DRAFT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
DRAFT_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document
|
| 13 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
Prompt Table:
DRAFT_MICR_VW
|
| 14 |
GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
|
| 15 |
HOLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Switch
N=No Hold
Y=On Hold
Default Value: N
|
| 16 |
DISCOUNT_DRAFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Draft
Y/N Table Edit
|
| 17 |
RECOURSE_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Recourse
|
| 18 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 19 |
DRAFT_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a draft payment in the business unit's base currency. This field is maintained by the Draft Creation process.
|
| 20 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
BANK_SETID_VW
|
| 21 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BR_VW2
|
| 22 |
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_ACCTKEY_V1
|
| 23 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 24 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 25 |
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
Default Value: U
|
| 26 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 27 |
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
Default Value: UNR
|
| 28 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 29 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 30 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
|
| 31 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 32 |
DISCOUNT_PROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Processed Switch
Y/N Table Edit
Default Value: N
|
| 33 |
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.
|
| 34 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 35 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 36 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 37 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 38 |
DRAFT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
Prompt Table:
DR_TYPE_ENT_VW
Set Control Field: DRAFT_BU
|
| 39 |
DRAFT_DOC_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Draft Reference
|
| 40 |
DRAFT_ACCEPT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Accepted by
|
| 41 |
DRAFT_PAYER_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Payer Name
|
| 42 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 43 |
SEL_REF_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Range of References
Default Value: N
|
| 44 |
WS_REF_MATCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Reference Match Type
E=Exact Match
L=Like Match
Default Value: E
|
| 45 |
EFT_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
EFT Process Instance
|
| 46 |
RECON_PROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Processed
Y/N Table Edit
Default Value: N
|
| 47 |
DR_DISHONOR_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Dishonor Reason Code
|
| 48 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 49 |
REMIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remittance ID
|
| 50 |
REMIT_DT |
Date(10) |
DATE |
Remittance Date
|
| 51 |
DRAFT_RISK_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Draft Risk Days
|
| 52 |
WO_ITEM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Item
|
| 53 |
AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Adjusted
|
| 54 |
DRAFT_SEL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Selected Amount
|
| 55 |
CUSTOMER_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Criteria
C=Customer Items
N=None
P=Corporate Items
R=Remit From Items
Default Value: N
|
| 56 |
DRAFT_STATUS_OLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Old Draft Status
|
| 57 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 58 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 59 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 60 |
RATE_MULT_REAL |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Real Gain Loss Rate Multiplier
|
| 61 |
RATE_DIV_REAL |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Real Gain Loss Rate Divisor
Default Value: 1
|
| 62 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 63 |
DRAFT_EFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
EFT Draft Flag
Y/N Table Edit
|
| 64 |
BANK_ACCT_RVL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
|
| 65 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 66 |
ITEM_IN_EXCLUSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Exclude Items
A=All Items
D=Deduction Items Only
I=Items in Dispute Only
Default Value: A
|
| 67 |
EXCLUDE_COLLECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 68 |
EXCLUDE_DEDUCTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
Y/N Table Edit
Default Value: N
|
| 69 |
EXCLUDE_DISPUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Dispute Items
Y/N Table Edit
Default Value: N
|
| 70 |
OPRID_APPROVED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Approved By
|
| 71 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 72 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|