| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
START_POS |
Number(4,0) |
SMALLINT NOT NULL |
Start Position
|
| 3 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 4 |
OC_AMT_MULT |
Number(25,8) |
DECIMAL(24,8) NOT NULL |
Amount Multiplier
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 7 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 8 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 9 |
MAX_DATE |
Date(10) |
DATE |
10/09/01 EGS (CN#PL900-1): Added.
|
| 10 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
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.
|
| 13 |
CRSPD_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Correspondence Customer
|
| 14 |
OC_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Overdue Charge Group
%=All Overdue Charge Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 15 |
OC_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Overdue Charge Number
|
| 16 |
NO_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
No Hold
N=No
Y=Yes
|
| 17 |
PRIME_RATE |
Number(16,7) |
DECIMAL(15,7) NOT NULL |
Prime Rate
|
| 18 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
|
| 19 |
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.
|
| 20 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 21 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 22 |
NEW_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Add An Item
|
| 23 |
INCREASE_ITEMS |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Minimum Item Charge
|
| 24 |
INCREASE_TOTAL |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Minimum Business Unit Charge
|
| 25 |
NBR_DAYS_CALC_YR |
Number(3,0) |
SMALLINT NOT NULL |
Days in Calculation Year
|
| 26 |
OC_RATE_PERCENT |
Number(24,7) |
DECIMAL(23,7) NOT NULL |
Overdue Charge Rate Percent
|
| 27 |
PRT_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Completed Records
|
| 28 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 29 |
PUBLIC_SECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Sector
|
| 30 |
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.
|
| 31 |
AUTO_NUMBER_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 32 |
NEXT_AUTO_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Next Number for Auto Numbering
|
| 33 |
LAST_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Last Customer ID tagged
|
| 34 |
BAL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code - Bal Amount
|
| 35 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 36 |
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.
|
| 37 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 38 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 39 |
AE_CNV_IN_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE input convert field
|
| 40 |
AE_CNV_OUT_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE output converion field
|
| 41 |
AE_CNV_JUSTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Convert Justify Indicator
|
| 42 |
AE_STRIP_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Strip Zeros
|
| 43 |
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.
|
| 44 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 45 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 46 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 47 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 48 |
DEFAULT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default
|
| 49 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 50 |
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.
|
| 51 |
ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
|
| 52 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 53 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 54 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 55 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
|
| 56 |
WHERE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Where Option
B=Both
N=None
P=Process Instance
V=By Value
|
| 57 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 58 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 59 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 60 |
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
|
| 61 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 62 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 63 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 64 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 65 |
NOTHING |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Field
|
| 66 |
AR_ROUND_1 |
Character(32) |
VARCHAR2(32) NOT NULL |
Rounding String
|
| 67 |
AR_ROUND_2 |
Character(32) |
VARCHAR2(32) NOT NULL |
Rounding String
|
| 68 |
AR_ROUND_3 |
Character(32) |
VARCHAR2(32) NOT NULL |
Rounding String
|
| 69 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 70 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 71 |
CONTROL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
|
| 72 |
ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the total currency amount of all pending items actually entered in a group and is compared with the control total amount. The Receivables Update program automatically calculates this total.
|
| 73 |
OVERDUE_CHG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charge Type
A=Admin
F=Finance
P=Penalty
|
| 74 |
OC_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
OC Business Unit
|
| 75 |
OC_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
OC Customer ID
|
| 76 |
OC_ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
OC Item
|
| 77 |
OC_ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
OC Item Line
|
| 78 |
OC_ADMIN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 79 |
OC_ADMIN_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 80 |
FC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 81 |
FC_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 82 |
OC_PNLTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 83 |
OC_PNLTY_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 84 |
SECURITY_CLEARANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Clearance
0=Not Required
1=Classified
2=Secret
3=Top Secret
4=Sensitive Compartmented Info
5=Q Sensitive
6=Q Non-Sensitive
7=L (Atomic Energy Act)
8=Other
|
| 85 |
SECURITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security
|