| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 3 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 4 |
DEPOSIT_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Deposit ID Sequence Number
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 6 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
Prompt Table:
DST_CODE_AR_VW
|
| 7 |
DST_ID_REAL |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
Prompt Table:
DST_CODE_RL_VW
|
| 8 |
DST_ID_REAL_GAIN |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
Prompt Table:
DST_CODE_RL_VW
|
| 9 |
DST_ID_REAL_LOSS |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
Prompt Table:
DST_CODE_RL_VW
|
| 10 |
DST_ID_ROUND |
Character(10) |
VARCHAR2(10) NOT NULL |
Rounding Account Code
Prompt Table:
DST_CODE_ROU_VW
|
| 11 |
DST_ID_UNREAL_GAIN |
Character(10) |
VARCHAR2(10) NOT NULL |
Unrealized Gain Code
Prompt Table:
DST_CODE_URL_VW
|
| 12 |
DST_ID_UNREAL_LOSS |
Character(10) |
VARCHAR2(10) NOT NULL |
Unrealized Loss Code
Prompt Table:
DST_CODE_URL_VW
|
| 13 |
DST_ID_TRANSLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Translate Distribution Code
Prompt Table:
DST_CODE_AR_VW
|
| 14 |
DST_ID_DM_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft AR Distribution Code
Prompt Table:
DST_CODE_DMR_VW
|
| 15 |
DST_ID_DM_RMT |
Character(10) |
VARCHAR2(10) NOT NULL |
Remitted Draft Receivable Code
Prompt Table:
DST_CODE_DMB_VW
|
| 16 |
DST_ID_DM_DIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Discount Receivable Code
Prompt Table:
DST_CODE_DMD_VW
|
| 17 |
DST_ID_DM_LIAB |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Discount Liability Code
Prompt Table:
DST_CODE_DML_VW
|
| 18 |
DST_ID_DM_REJ |
Character(10) |
VARCHAR2(10) NOT NULL |
Dishonored Draft Code
Prompt Table:
DST_CODE_DMJ_VW
|
| 19 |
DST_ID_REFUND |
Character(10) |
VARCHAR2(10) NOT NULL |
Refund Distribution Code
Prompt Table:
DST_CODE_RFD_VW
|
| 20 |
DST_ID_DB |
Character(10) |
VARCHAR2(10) NOT NULL |
Doubtful Distribution Code
Prompt Table:
DST_CODE_DB_VW
|
| 21 |
DST_ID_MAINT_CTL |
Character(10) |
VARCHAR2(10) NOT NULL |
10 character value used to identify the maintenance worksheet control distribution code.
Prompt Table:
DST_CODE_CTL_VW
|
| 22 |
DST_ID_TRAN_CTL |
Character(10) |
VARCHAR2(10) NOT NULL |
10 character value used to identify the transfer worksheet control distribution code.
Prompt Table:
DST_CODE_TRN_VW
|
| 23 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 24 |
APPL_JRNL_ID_MISC |
Character(10) |
VARCHAR2(10) NOT NULL |
Direct Journal
Prompt Table:
JRNLGEN_APPL_ID
|
| 25 |
APPL_JRNL_ID_CC |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines Journal Generator Template for Cash Control Entries
Prompt Table:
JRNLGEN_APPL_ID
|
| 26 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
%EDITTABLE
|
| 27 |
ORIGIN_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
AP Origin ID
Prompt Table:
%EDITTABLE2
|
| 28 |
AR_VOUCHER_SEQ_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
AR Voucher ECQUEUEINSTANCE Num
|
| 29 |
DD_AUTO_REMIT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Remit Direct Debits
Y/N Table Edit
Default Value: N
|
| 30 |
CASH_CNTL_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit To Cash Occurs At
E=Payment Entry
R=Bank Reconciliation
|
| 31 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Default Value: Y
|
| 32 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 33 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 34 |
ENTRY_TYPE_FEES |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Fees Entry Type
Prompt Table:
ENTRY_TYPE_TBL
|
| 35 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table:
ENTRY_TYPE_TBL
|
| 36 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
ENTRY_REASN_TBL
|
| 37 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
Prompt Table:
%EDITTABLE3
|
| 38 |
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.
Prompt Table:
DOC_TYPE_TBL
|
| 39 |
DOC_TYPE_IU |
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.
Prompt Table:
DOC_TYPE_A_VW
|
| 40 |
USE_BUS_DAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Business Day
Y/N Table Edit
Default Value: N
|
| 41 |
GO_NXT_PRV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Go Next or Prior Business Day
N=Next Business Day
P=Prior Business Day
|
| 42 |
DST_ID_TRANS_GAIN |
Character(10) |
VARCHAR2(10) NOT NULL |
Translate Realized Gain Code
Prompt Table:
DST_CODE_RL_VW
|
| 43 |
DST_ID_TRANS_LOSS |
Character(10) |
VARCHAR2(10) NOT NULL |
Translate Realized Loss Code
Prompt Table:
DST_CODE_RL_VW
|
| 44 |
AG_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Acceptgiro Contract - inital implementation wil only include type A/S, future enhancements may include additional Acceptgiro types.
0=None
1=A/S Contract
Default Value: 0
|
| 45 |
AG_REF_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Payment Reference Sequence
|
| 46 |
LAST_RECEIPT_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Receipt Number
|
| 47 |
CRCARD_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Profile ID
Prompt Table:
AR_CRCARD_PRFL
|
| 48 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BR_VW1
|
| 49 |
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_AR_R_VW1
|
| 50 |
VAT_ADVPAY_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Adjustment on Advance Pymt
Y/N Table Edit
Default Value: N
|
| 51 |
AUTONB_PREFIX_SPID |
Character(3) |
VARCHAR2(3) NOT NULL |
SP Item ID Prefix
|
| 52 |
NEXT_AUTONB_SPID |
Number(10,0) |
DECIMAL(10) NOT NULL |
SP Item ID
|
| 53 |
AUTONB_PREFIX_CNL |
Character(3) |
VARCHAR2(3) NOT NULL |
Cancel Prefix
|
| 54 |
NEXT_AUTONB_CNL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Cancel ID
|
| 55 |
AUTONB_PREFIX_REF |
Character(3) |
VARCHAR2(3) NOT NULL |
Refund Prefix
|
| 56 |
NEXT_AUTONB_REF |
Number(10,0) |
DECIMAL(10) NOT NULL |
Refund ID
|
| 57 |
VAT_WO_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Adjustment for WO
Y/N Table Edit
Default Value: N
|
| 58 |
SCM_CCI_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Credit Card Group
Prompt Table:
SCM_CC_GROUP_VW
|
| 59 |
EPAY_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ePayment Profile
Prompt Table:
AR_EPAY_PRFL
|
| 60 |
TR02_DSTCD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retain Original Item Dist Code
Y/N Table Edit
Default Value: N
|
| 61 |
GST_ADVPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
GST Advance Flag
Y/N Table Edit
Default Value: N
|
| 62 |
SINGLE_PYMNT_VCHR |
Character(3) |
VARCHAR2(3) NOT NULL |
Single Payment Refund Voucher
|
| 63 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 64 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_AR3_DVW
|
| 65 |
EFT_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_AR4_DVW
|
| 66 |
ENABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Single Payment Supplier
Y/N Table Edit
Default Value: N
|
| 67 |
AR_FROM_EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|