| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUARDS_NONVW
|
| 6 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 7 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 8 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 9 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPER_UNIT_TBL
|
| 10 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_TBL
|
| 11 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_TBL
|
| 12 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_TBL
|
| 13 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_TBL
|
| 14 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_TBL
|
| 15 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 16 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 17 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 18 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CHARTFIELD1_TBL
|
| 19 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CHARTFIELD2_TBL
|
| 20 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CHARTFIELD3_TBL
|
| 21 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_ID_VW
|
| 22 |
DIVISION |
Character(20) |
VARCHAR2(20) NOT NULL |
Division
|
| 23 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 24 |
PIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Point in Time Reporting Types -- Y for Year to Date, M for Month to date, R for a range of dates, and S for a specified day.
M=Month to Date
R=Range of date
S=Specific Date
Y=Year to Date
Default Value: Y
|
| 25 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 26 |
FROM_DT |
Date(10) |
DATE |
From Date
Default Value: %date
|
| 27 |
TO_DT |
Date(10) |
DATE |
To Date
Default Value: %date
|
| 28 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 29 |
OPERATOR |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
OPR_DEF_VW_AR
|
| 30 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 31 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREE_NAME_VW
|
| 32 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table:
CR_ANALYST_TBL
|
| 33 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
Prompt Table:
SALES_PERSN_TBL
|
| 34 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
COLLECTOR_TBL
|
| 35 |
CUSTOMER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Type
1=User 1
2=User 2
3=User 3
4=User 4
F=Foreign
M=Commercial
N=Consumer
S=State and Local
X=Excluded Foreign Customer
|
| 36 |
CUST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Status
A=Active
I=Inactive
T=Template
|
| 37 |
USER_CHOICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Option
1=Sort by Customer Number
2=Sort by Customer Name
3=Sort by Customer Type
Default Value: 2
|
| 38 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
Prompt Table:
GROUP_TYPE_TBL
|
| 39 |
POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All
C=Complete
E=Errors
N=Not Posted
|
| 40 |
POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
Y/N Table Edit
Default Value: Y
|
| 41 |
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.
Prompt Table:
CUST_BI_A2_VW
|
| 42 |
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.
Prompt Table:
GROUP_CONTROL
|
| 43 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
Prompt Table:
DEPOST_TYPE_TBL
|
| 44 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
Prompt Table:
DEPOSIT_CONTROL
|
| 45 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table:
SP_BUARDE_NONVW
|
| 46 |
AGING_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging ID
Prompt Table:
AGING_TBL
|
| 47 |
AGING_SORT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Option
A=Analyst
B=Business Unit
C=Collector
D=Corporate Customer
S=Sales Person
Default Value: B
|
| 48 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 49 |
SUMM_DET_SORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary or Detail Sort Option
1=Summary - All
2=Detail - All
3=Summary - Primary
4=Detail - Primary
Default Value: 1
|
| 50 |
SYSACT_RPT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize
1=By Entry Type
2=By Entry Type and Entry Reason
3=By Group Type/Origin/Bank Code
4=By Activity Type
5=By Activity Type/Origin/Bank
Default Value: 1
|
| 51 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 52 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 53 |
DAYS_PER_CATEGORY |
Number(2,0) |
SMALLINT NOT NULL |
Days Per Category
|
| 54 |
CRSPD_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table:
CRSPD_VAL_VW
|
| 55 |
CURRENCY_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Type
B=Base Curr
E=Entry Curr
Default Value: B
|
| 56 |
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.
Prompt Table:
RT_TYPE_TBL
|
| 57 |
ST_DT |
Date(10) |
DATE |
Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
Default Value: %date
|
| 58 |
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.
Prompt Table:
ITEM_OPEN_BU_VW
|
| 59 |
DUN_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Dunning Group
%=All Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 60 |
DIRECT_TO_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Directly to AP
Y/N Table Edit
Default Value: N
|
| 61 |
ST_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Statement Group
%=All Statement Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 62 |
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
|
| 63 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
Default Value: OPR_DEF_TBL_AR.GROUP_BU
Prompt Table:
SP_BUARGR_NONVW
|
| 64 |
PRIME_RATE |
Number(16,7) |
DECIMAL(15,7) NOT NULL |
Prime Rate
|
| 65 |
DUN_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Dunning Number
Prompt Table:
DUN_PROMPT_VW
|
| 66 |
ST_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Statement Number
Prompt Table:
STMT_PROMPT_VW
|
| 67 |
OC_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Overdue Charge Number
Prompt Table:
OC_PROMPT_VW
|
| 68 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 69 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 70 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 71 |
DOCUMENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
|
| 72 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 73 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 74 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 75 |
ARCHIVE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID
Prompt Table:
MC_ARCHIVE_DEFN
|
| 76 |
ARCHIVE_DT |
Date(10) |
DATE |
Archive Date
|
| 77 |
BANK_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Bank File Name
|
| 78 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BD_VW
|
| 79 |
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_DRPT_VW
|
| 80 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the source or method of entry for a pending item group.
Prompt Table:
ORIGIN_TBL
|
| 81 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_LEDG_D_NONVW
|
| 82 |
DOC_SQ_FR |
Date(10) |
DATE |
From Doc Seq Date
|
| 83 |
DOC_SQ_TO |
Date(10) |
DATE |
To Doc Seq Date
|
| 84 |
JRNL_CD_FR |
Character(8) |
VARCHAR2(8) NOT NULL |
From Journal Code
Prompt Table:
JRNL_CODE_TBL
|
| 85 |
JRNL_CD_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
To Journal Code
Prompt Table:
JRNL_CODE_TBL
|
| 86 |
JRNL_TP_FR |
Character(2) |
VARCHAR2(2) NOT NULL |
From Journal Type
Prompt Table:
JRNL_TYPE_TBL
|
| 87 |
JRNL_TP_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
To Journal Type
Prompt Table:
JRNL_TYPE_TBL
|
| 88 |
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
|
| 89 |
SHOW_FOREIGN_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Foreign Currency Amount
Y/N Table Edit
|
| 90 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
|
| 91 |
SUBTOT_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Subtotal Level
1=Subtotal on 1 Chartfield
2=Subtotal on 2 ChartField
N=None
|
| 92 |
ACCT_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To
Prompt Table:
GL_ACCT_ALL_VW
|
| 93 |
ACCT_FR |
Character(10) |
VARCHAR2(10) NOT NULL |
From
Prompt Table:
GL_ACCT_ALL_VW
|
| 94 |
FROM_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
From Period
|
| 95 |
PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Period
|
| 96 |
CUST_ID_FRM |
Character(15) |
VARCHAR2(15) NOT NULL |
From Customer ID
Prompt Table:
CUSTOMER
|
| 97 |
CUST_ID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
To Customer ID
Prompt Table:
CUSTOMER
|
| 98 |
NO_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
No Hold
N=No
Y=Yes
|
| 99 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 100 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|