| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
Prompt Table:
ENTRY_USE_TBL
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
AUTO_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Function
A=Auto Entry
I=Item Entry
S=System Entry
Default Value: A
|
| 4 |
SYS_GENERATED_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Creates New Item
Y/N Table Edit
Default Value: N
|
| 5 |
ALLOWS_REASON_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Entry Reason Prompting
Y/N Table Edit
Default Value: N
|
| 6 |
NATURAL_SIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Natural Sign
N=Negative
P=Positive
U=Unsigned
Default Value: N
|
| 7 |
ALLOW_AUTO_NUMBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Supports Auto Numbering
Y/N Table Edit
Default Value: N
|
| 8 |
AUTO_NUMBER_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 9 |
NEXT_AUTO_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Next Number for Auto Numbering
|
| 10 |
SYS_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Type
A=Draft Management
B=Deductions Management
C=Cash Applied
D=Discounts
F=Overdue Charges
G=Payment Plan Item-Maintenance
I=Billing
M=Maintenance
P=Write-offs - Payments
R=Refunds - Maintenance
T=Transfers
W=Write-offs - Maintenance
X=Direct Debit
Y=Write Offs - Deduction
|
| 11 |
ORIGIN_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Type And Origin
N=Do Not Breakdown By Origin
Y=Breakdown By Origin
|
| 12 |
ENTRY_USE_PAIR |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Creates 2nd Item
Y/N Table Edit
|
| 13 |
ENTRY_USE_PARTNER |
Character(5) |
VARCHAR2(5) NOT NULL |
Entry Use Partner
|
| 14 |
VAT_AFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on VAT Processing
A=Adjust Intermediate VAT Liab
I=Include in Item Entry Totals
N=None
P=Move Intermediate VAT to Final
Default Value: N
|
| 15 |
CC_AFFECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
|
| 16 |
CC_USER_DEFINED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether user can redefine the defaults.
N=No
Y=Yes
|
| 17 |
CC_ACCT_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Data Source
D=Activity Dist Line
I=Item User Line
R=Dist Refund Control
U=Dist User Line
|
| 18 |
CC_DST_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Source Line
A=Accounts Receivable Entry
C=Cash Entry
D=Draft Receivable Entry
E=Disc Draft Receivable Entry
F=Disc Draft Liability Entry
I=InterUnit Entry
L=Cash Control Entry
M=Due From Entry
R=Realized Gain / Loss Entry
S=Refund Control Entry
T=Due To Entry
U=User Defined Entry
V=Declarable VAT Entry
W=Intermediate VAT Entry
|
| 19 |
CC_AMT_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate which the AR distribution line to pull the amount from when generating the commitment control source transactions. The XLAT values are subset of SYSTEM_DEFINED.
A=Accounts Receivable Entry
C=Cash Entry
D=Draft Receivable Entry
E=Disc Draft Receivable Entry
F=Disc Draft Liability Entry
I=InterUnit Entry
L=Cash Control Entry
M=Due From Entry
R=Realized Gain / Loss Entry
S=Refund Control Entry
T=Due To Entry
U=User Defined Entry
V=Declarable VAT Entry
W=Intermediate VAT Entry
|
| 20 |
CC_AMT_POS_MULT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
To reset the sign of the amount when generating commitment control source transaction.
|
| 21 |
CC_AMT_MULTIPLIER |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
To reset the sign of the amount when generating commitment control source transaction.
|
| 22 |
CC_REV_BUCKET |
Character(1) |
VARCHAR2(1) NOT NULL |
Inidcate which revenue bucket to update.
B=Both
C=Collected
N=None
R=Recognized
|
| 23 |
CC_REV_BUCKET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to indicate the valid options for CC_REV_BUCKET
|
| 24 |
CC_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
CC Tran Type
P=PrePay
|
| 25 |
CC_DM_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Management Tran Type
C=Cancel Draft
D=Dishonor Draft
G=Generate Trans
N=No Effect
R=Recognize Cash
V=Void Draft
|