ITEM_ACT_SI_VW(SQL View) |
Index Back |
|---|---|
Customer Item Activity by SI |
| SELECT B.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.ITEM_SEQ_NUM , A.ENTRY_TYPE , A.ENTRY_REASON , A.ENTRY_AMT , A.ACCOUNTING_DT , A.POST_DT , A.ASOF_DT , A.DOCUMENT , A.DOCUMENT_LINE , A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , A.DRAFT_BU , A.DRAFT_ID , A.GROUP_BU , A.GROUP_ID , A.GROUP_SEQ_NUM , A.HIST_STATUS , A.SUBCUST_QUAL1 , A.SUBCUST_QUAL2 , A.SUBCUST_STATUS , A.ENTRY_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.PAYMENT_AMT , A.PAYMENT_CURRENCY , A.PYMT_RT_TYPE , A.PYMT_RATE_MULT , A.PYMT_RATE_DIV , A.ENTRY_AMT_BASE , A.CURRENCY_CD , A.REAL_GAIN_LOSS , A.ENTRY_USE_ID , A.ORIGIN_ID , A.PAYMENT_ID , A.GROUP_TYPE , A.VOUCHER_ID , A.SENT_TO_AP , A.CONSOL_BUS_UNIT , A.CONSOL_INVOICE , A.CR_ANALYST , A.SALES_PERSON , A.COLLECTOR , A.PO_REF , A.PO_LINE , A.BILL_OF_LADING , A.ORDER_NO , A.CONTRACT_NUM , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_OM , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.POSTED_PI , A.USER_AMT1 , A.USER_AMT2 , A.USER_AMT3 , A.USER_AMT4 , A.USER_AMT5 , A.USER_AMT6 , A.USER_AMT7 , A.USER_AMT8 , A.USER_DT1 , A.USER_DT2 , A.USER_DT3 , A.USER_DT4 , A.USER1 , A.USER2 , A.USER3 , A.USER4 , A.USER5 , A.USER6 , A.USER7 , A.USER8 , A.USER9 , A.USER10 , A.BUSINESS_UNIT_CA , A.CONTRACT_LINE_NUM , A.SUBROG_CASE_NUM FROM PS_ITEM_ACTIVITY A , PS_SET_CNTRL_REC B WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'CUSTOMER' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_FS |
| 3 | 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 |
| 4 | 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. |
| 5 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 6 | ITEM_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 7 | 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.
Prompt Table: ENTRY_TYPE_TBL |
| 8 | 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""."
Prompt Table: ENTRY_REASN_TBL |
| 9 | ENTRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of a pending item transaction such as invoice or credit memo. |
| 10 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 11 | POST_DT | Date(10) | DATE NOT NULL | The Date a transaction was Posted. |
| 12 | ASOF_DT | Date(10) | DATE | As of Date |
| 13 | 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. |
| 14 | DOCUMENT_LINE | Number(6,0) | INTEGER NOT NULL | Specifies the line number of a Document ID used as a reference on a Receivables item. |
| 15 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 16 | 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. |
| 17 | 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. |
| 18 | DRAFT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. |
| 19 | DRAFT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 20 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL | Represents the high level grouping of multiple general ledger business units. |
| 21 | 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. |
| 22 | 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. |
| 23 | HIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
History Status
N=No T=Transfer Y=Yes Y/N Table Edit Default Value: N |
| 24 | 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. |
| 25 | 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. |
| 26 | SUBCUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL | SubCustomer History Status |
| 27 | ENTRY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency associated with the monetary amount of a pending item. |
| 28 | 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. |
| 29 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 30 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 31 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 32 | 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. |
| 33 | 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. |
| 34 | 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. |
| 35 | 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 |
| 36 | ENTRY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit. |
| 37 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 38 | REAL_GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables). |
| 39 | ENTRY_USE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the System Function or type of processing associated with an entry type. |
| 40 | ORIGIN_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the source or method of entry for a pending item group. |
| 41 | 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. |
| 42 | 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. |
| 43 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 44 | SENT_TO_AP | Character(1) | VARCHAR2(1) NOT NULL |
Sent to AP
Y/N Table Edit Default Value: N |
| 45 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Billing business unit associated with a consolidated bill. |
| 46 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |
| 47 | 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. |
| 48 | 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. |
| 49 | COLLECTOR | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer to collect overdue payments. |
| 50 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 51 | PO_LINE | Number(3,0) | SMALLINT NOT NULL | Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF. |
| 52 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 53 | 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 |
| 54 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 55 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 56 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 57 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 58 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 59 | 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 |
| 60 | POSTED_PI | Number(10,0) | DECIMAL(10) NOT NULL | Last Post Process Instance |
| 61 | USER_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 62 | USER_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 63 | USER_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 64 | USER_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 65 | USER_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 66 | USER_AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 67 | USER_AMT7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 68 | USER_AMT8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 69 | USER_DT1 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 70 | USER_DT2 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 71 | USER_DT3 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 72 | USER_DT4 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 73 | USER1 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 74 | USER2 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 75 | USER3 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 76 | USER4 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 77 | USER5 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 78 | USER6 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 79 | USER7 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 80 | USER8 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 81 | USER9 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 82 | USER10 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 83 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 84 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 85 | SUBROG_CASE_NUM | Character(30) | VARCHAR2(30) NOT NULL | Subrogation case number used for Insurance |