| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 6 |
ARRE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process status indicator for AR Commitment Control
B=Processed by Billing
C=Corrected online
E=Unknown Error
M=Unable dist to multi rev lines
N=No effect on revenue estimate
O=Transfered out of Bus Unit
P=Processed successfully
R=No item rev lines
S=Skip process
T=No transfer 'from' item found
U=No revenue lines
X=Error exists in prior activity
|
| 7 |
MSGNUM |
Number(5,0) |
INTEGER NOT NULL |
Message Number
|
| 8 |
MSGPARM1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parm 1
|
| 9 |
MSGPARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parm 2
|
| 10 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 11 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 12 |
TRAN_SENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether to hold the transactions or send them directly.
N=No
Y=Yes
|
| 13 |
TRAN_SPECIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether to specify the transaction template or default to business unit.
N=No
Y=Yes
|
| 14 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 15 |
AR_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Type
|
| 16 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 17 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 18 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 19 |
NOTHING |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Field
|
| 20 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 21 |
MAX_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Max Sequence Number
|
| 22 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 23 |
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.
|
| 24 |
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.
|
| 25 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 26 |
REV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 27 |
REV_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 28 |
REV_ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 29 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 30 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 31 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 32 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 33 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 34 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 35 |
ACCOUNTING_DT_BI |
Date(10) |
DATE |
Billing Accounting Date
|
| 36 |
ACCT_ENTRY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Entry Type
|
| 37 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 38 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 39 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 40 |
AE_VERSION |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Version
|
| 41 |
RELEASELABEL |
Character(50) |
VARCHAR2(50) NOT NULL |
Release Label
00=Core
10=Education and Government
18=Service Industries
19=Comm., Transportation & Util
20=Retail
21=Performance Measurement
22=HealthCare
23=Student Administration
25=U.S. Federal Govt
26=Canadian Govt
30=Intl Translations
32=Netherlands
33=United Kingdom
34=Espanol/Spain
35=France
36=Portuguese
37=Italy
39=German
50=South Africa
60=Latin America Local
61=Mexico
62=Argentina
63=Brazil
81=Japanese
88=Asia/Pacific
99=PeopleSoft Select
00=Core
10=Education and Government
18=Service Industries
19=Comm., Transportation & Util
20=Retail
21=Performance Measurement
22=HealthCare
23=Student Administration
25=U.S. Federal Govt
26=Canadian Govt
30=Intl Translations
32=Netherlands
33=United Kingdom
34=Espanol/Spain
35=France
36=Portuguese
37=Italy
39=German
50=South Africa
60=Latin America Local
61=Mexico
62=Argentina
63=Brazil
81=Japanese
88=Asia/Pacific
99=PeopleSoft Select
|
| 42 |
COMMITMENT_CNTL_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on AR
|
| 43 |
MAX_NBR |
Number(5,0) |
INTEGER NOT NULL |
Max Number
|
| 44 |
GROUP_ID_CC |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|
| 45 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 46 |
AUTO_NUMBER_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 47 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 48 |
TOTAL_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Total Count
|
| 49 |
BUDGET_DT_OVER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Date Override
|
| 50 |
SYNC_BUDGET_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether to use the same budget date for both recognized and collected bucket
N=No
Y=Yes
|
| 51 |
AUTO_NBR_PREFIX2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 52 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 53 |
AR_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
A number that is assigned to draft items to ensure uniqueness of key
|
| 54 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|