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. |