PG_REQUEST_TAO

(SQL Table)
Index Back

AR PGG Service Request Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.
4 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.
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 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.
7 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.
8 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
9 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.
10 TAO_SUFFIX Character(1) VARCHAR2(1) NOT NULL TAO table suffix (optional)
11 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
12 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.
13 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
14 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.
15 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
16 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
17 PYMT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
18 PYMT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
19 PYMT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.

Default Value: 1

20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
22 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.
23 PGG_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL PGG Group Type
B=Billing
D=Draft
F=Finance Charge
M=Maintenance
P=Payment
T=Transfer
U=Unpost
24 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
25 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Specifies the source or method of entry for a pending item group.
26 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.
27 CASH_CNTRL_USE Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a payment group created by a payment worksheet or by Payment Predictor includes a cash control entry debiting cash.
28 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
29 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
30 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
31 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
32 PGG_MODE Character(1) VARCHAR2(1) NOT NULL PGG Mode of Operation
33 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

34 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
35 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.