| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WS_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Worksheet Business Unit
Default Value: OPR_DEF_TBL_AR.GROUP_BU
Prompt Table:
SP_BUARWS_NONVW
|
| 2 |
WS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
Default Value: NEXT
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 4 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
Prompt Table:
OPRID_VW
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
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.
Default Value: M
|
| 7 |
BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
Default Value: O
|
| 8 |
EDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group has been edited for valid values and control total balance. This field is populated automatically during online data entry and during the Receivables update process.
E=Edited
N=Not Edited
Default Value: E
|
| 9 |
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
Default Value: N
|
| 10 |
AR_WOAPPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved Write-Off
D=Denied Write-Off
I=Initial
P=Pending Write-Off Approval
Default Value: I
|
| 11 |
AR_RFAPPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved Refund
D=Denied Refund
I=Initial
P=Pending Refund Approval
Default Value: I
|
| 12 |
POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View
Default Value: A
|
| 13 |
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.
|
| 14 |
CONTROL_CNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
|
| 15 |
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.
|
| 16 |
ENTERED_CNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the number of pending items actually entered in a group and is compared with the control total count. The Receivables Update program automatically calculates this total.
|
| 17 |
POSTED_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.
|
| 18 |
POSTED_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the total number of pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.
|
| 19 |
GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
|
| 20 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the source or method of entry for a pending item group.
Default Value: PS_AR
|
| 21 |
RECEIVED_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
Default Value: %date
|
| 22 |
ENTRY_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
Default Value: %date
|
| 23 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 24 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 25 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 26 |
DST_BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the accounting entries for a group of pending items are balanced. This field is maintained by the Pending group Generator in PeopleSoft receivables.
I=Balanced
O=Not Balanced
Default Value: O
|
| 27 |
ALLOW_DST |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a group of receivables pending items is to be posted to the general ledger. It tells the Pending Group Generator (a program) how to set the GL_DISTRIB_STATUS for the accounting entries it creates. If ALLOW_DST is set to Y then GL_DISTRIB_STATUS is set to N. If ALLOW_DST is set to N then GL_DISTRIB_STATUS is set to I.
Y/N Table Edit
Default Value: N
|
| 28 |
CREATE_DST_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is no longer in use
Y/N Table Edit
Default Value: N
|
| 29 |
SEL_CUST_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via Customer ID
Y/N Table Edit
Default Value: N
|
| 30 |
SEL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via Postal
Y/N Table Edit
Default Value: N
|
| 31 |
SEL_REMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via REMIT TO
Y/N Table Edit
Default Value: N
|
| 32 |
SEL_CORP_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via CORP ACCT
Y/N Table Edit
Default Value: N
|
| 33 |
SEL_MICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via MICR ID
Y/N Table Edit
Default Value: N
|
| 34 |
SEL_OPEN_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via OPEN ITEM
Y/N Table Edit
Default Value: N
|
| 35 |
SEL_DOCUMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via DOCUMENT
Y/N Table Edit
Default Value: N
|
| 36 |
SEL_REF_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Range of References
Y/N Table Edit
Default Value: N
|
| 37 |
ID_SEQ_CUST |
Number(3,0) |
SMALLINT NOT NULL |
Sequence control for CUST ID
|
| 38 |
ID_SEQ_ITEM |
Number(5,0) |
INTEGER NOT NULL |
Sequence control for ITEM
|
| 39 |
WS_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Worksheet Items
|
| 40 |
WS_DTTM |
DateTime(26) |
TIMESTAMP |
Worksheet Created Date/Time
|
| 41 |
WS_REF_MATCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Reference Match Type
E=Exact Match
L=Like Match
Default Value: E
|
| 42 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 43 |
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.
|
| 44 |
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""."
|
| 45 |
REQUIRE_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Reason
|
| 46 |
WS_TOTAL_DR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Debits
|
| 47 |
WS_TOTAL_CR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Credits
|
| 48 |
WS_TOTAL_WO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off
|
| 49 |
WS_TOTAL_REF |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Worksheet Refunds
|
| 50 |
WS_TOTAL_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Adjustments
|
| 51 |
WS_NET |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Group Balance
|
| 52 |
POST_ACTION_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete worksheet switch
A=No Action
C=Clear All Worksheets
D=Delete Worksheet
G=Review Accounting Entries
L=Post Later
N=Post Now
V=View
Default Value: A
|
| 53 |
POST_ACTION_GLDIST |
Character(1) |
VARCHAR2(1) NOT NULL |
GL
A=No Action
D=Delete Worksheet
G=Review Accounting Entries
L=Post Later
N=Post Now
Default Value: A
|
| 54 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURR_CD_AR_VW
|
| 55 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 56 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 57 |
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.
|
| 58 |
WS_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Distribution Status
G=Generated
N=Not Generated
Default Value: N
|
| 59 |
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.
|
| 60 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 61 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 62 |
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
|
| 63 |
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
|
| 64 |
WS_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
WS_REASON_TBL
|
| 65 |
ANCHOR_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
5 character value used to identify the anchor business unit.
Prompt Table:
BUS_UNIT_TBL_AR
|
| 66 |
BALANCING_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
3 character value used to identify the anchor currency.
Prompt Table:
CURR_CD_AR_VW
|
| 67 |
DST_ID_MAINT_CTL |
Character(10) |
VARCHAR2(10) NOT NULL |
10 character value used to identify the maintenance worksheet control distribution code.
Prompt Table:
DST_CODE_CTL_VW
|
| 68 |
ITEM_IN_EXCLUSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Exclude Items
A=All Items
D=Deduction Items Only
I=Items in Dispute Only
Default Value: A
|
| 69 |
EXCLUDE_COLLECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 70 |
EXCLUDE_DEDUCTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
Y/N Table Edit
Default Value: N
|
| 71 |
EXCLUDE_DISPUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Dispute Items
Y/N Table Edit
Default Value: N
|
| 72 |
ACCOUNTING_DT_TO |
Date(10) |
DATE |
The range of the accounting entry construction dates
|
| 73 |
ACCOUNTING_DT_FROM |
Date(10) |
DATE |
The range of the accounting entry construction dates
|
| 74 |
DUE_DT_FROM |
Date(10) |
DATE |
Used in Voucher Maintenance Component
|
| 75 |
DUE_DT_TO |
Date(10) |
DATE |
Used in Voucher Maintenance Component
|
| 76 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALIST
|
| 77 |
BROKER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Broker ID
Prompt Table:
CUST_BRK_A1S_VW
|
| 78 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
Prompt Table:
DEDUCTION_TBL
|
| 79 |
OPRID_APPROVED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Approved By
|
| 80 |
REQ_WO_COMMENTS |
Long Character |
CLOB |
Requestor Write-off Comments
|
| 81 |
REQ_RF_COMMENTS |
Long Character |
CLOB |
Requestor Refund Comments
|