| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 4 |
CHARTFIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField
|
| 5 |
CHARTFIELD_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value
|
| 6 |
CF_INH_OBJ |
Character(254) |
VARCHAR2(254) NOT NULL |
State Record field used to hold the concatenated Charfield Inheritance Setid/Group object.
|
| 7 |
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.
|
| 8 |
CORPORATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 9 |
CORPORATE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Corporate Customer
|
| 10 |
AE_COND_OPER |
Character(2) |
VARCHAR2(2) NOT NULL |
Condition Operator
|
| 11 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 12 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 13 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 14 |
AUTOMNT_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Automatic Maintenance Method
|
| 15 |
MATCH_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Across Business Units
|
| 16 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 17 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 18 |
STEP_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Method Step
|
| 19 |
STEP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Option
M=Match References
U=Execute Algorithm
W=No Match Write-off
|
| 20 |
DEBIT_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Debit Field
|
| 21 |
CREDIT_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Credit Field
|
| 22 |
MATCH_OPERATOR |
Character(4) |
VARCHAR2(4) NOT NULL |
Operator
==Equal
LIKE=Like Comparison
|
| 23 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 24 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 25 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 26 |
AMT_MATCH_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Remaining Balance
1== 0
2=> 0, within tolerance
3=> 0, over tolerance
4=< 0, within tolerance
5=< 0, over tolerance
|
| 27 |
RESOLVE_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Action
1=Resolve
2=Resolve, write-off balance
3=Resolve, Create new item
4=Release to the next step
5=Apply, remaining Balance open
|
| 28 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 32 |
ENTRY_USE_ID_WRK |
Character(5) |
VARCHAR2(5) NOT NULL |
System Function ID
|
| 33 |
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""."
|
| 34 |
ENTRY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency associated with the monetary amount of a pending item.
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 36 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 37 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 38 |
ANCHOR_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
5 character value used to identify the anchor business unit.
|
| 39 |
ANCHOR_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the business unit that generates a given deal transaction.
|
| 40 |
ANCHOR_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.
|
| 41 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 42 |
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.
|
| 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 |
TUNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuning Mode
D=On - Display Bind Setups
N=Delete Work Files
S=On - Stop at specified stmt
W=Retain Work Files
Y=On
|
| 46 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 47 |
MATCH_CUST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Level
C=Corporate Customer
N=No Customer Relationships
R=Remit From Customer
|
| 48 |
MATCH_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Type
1=One to One
3=All
|
| 49 |
EXCLUDE_DEDUCTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
Y/N Table Edit
|
| 50 |
EXCLUDE_DISPUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Dispute Items
Y/N Table Edit
|
| 51 |
EXCLUDE_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Other Debit Items
Y/N Table Edit
|
| 52 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 53 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 54 |
AE_WHERE |
Character(254) |
VARCHAR2(254) NOT NULL |
AE Generic Where Clause
|
| 55 |
AE_WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic where clause
|
| 56 |
WORKSHEET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet
|
| 57 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 58 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 59 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname 2
|
| 60 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 61 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 62 |
NEXT_AUTO_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Next Number for Auto Numbering
|
| 63 |
AUTO_NUMBER_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 64 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 65 |
MATCH_GROUP_ID |
Character(95) |
VARCHAR2(95) NOT NULL |
Match Group ID
|
| 66 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
|
| 67 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 68 |
TOTAL_DEBIT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The total debit amount for a given accounting entry build.
|
| 69 |
TOTAL_CREDIT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The total credit amount for a given accounting entry build.
|
| 70 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 71 |
BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Balance
|
| 72 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 73 |
FIELD_LIST |
Long Character(4000) |
CLOB |
Field List
|
| 74 |
AR_DATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Activity Date
1=All Dates
2=<= Today
3=<= Specific Date
|
| 75 |
LAST_ACTIVITY_DT |
Date(10) |
DATE |
Last Activity Date
|
| 76 |
CHECK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work field used to store status values
|
| 77 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|