AR38000_TMP(SQL Table) |
Index Back |
|---|---|
Payment Plan ReportPayment Plan Report data table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CRSPD_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_FS_VW.SETID Prompt Table: SP_SETCS_NONVW |
| 3 | CRSPD_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CUST_CR_A1S_VW |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | 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. |
| 6 | PAYMENT_PLAN |
Character(15) | VARCHAR2(15) NOT NULL | Payment Plan |
| 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 | PYPLRPT_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Plan Report Line Type
0=Source Item 1=Installment Item |
| 10 | PAYPLAN_RPT_DT | Date(10) | DATE | Payment Plan Report Date |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 13 | 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. |
| 14 | 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""." |
| 15 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 16 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 17 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 18 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 19 | ORIG_ITEM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Original Item Amount |
| 20 | PAYMENT_PLN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Plan Status
A=Active D=Draft P=Paid |
| 21 | PAYPLAN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Plan Amount |
| 22 | REMIT_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address1 |
| 23 | REMIT_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address2 |
| 24 | REMIT_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address3 |
| 25 | REMIT_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address4 |
| 26 | REMIT_CITY | Character(30) | VARCHAR2(30) NOT NULL | Remit City |
| 27 | REMIT_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Remit Num1 |
| 28 | REMIT_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Remit number 2 |
| 29 | REMIT_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Remit House Type |
| 30 | REMIT_IN_CITY_LMT | Character(1) | VARCHAR2(1) NOT NULL | Remit In City Limit |
| 31 | REMIT_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | Remit County |
| 32 | REMIT_STATE | Character(6) | VARCHAR2(6) NOT NULL | Remit State |
| 33 | REMIT_GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Remit Tax Supplier Geo Code |
| 34 | REMIT_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Remit Postal Code |
| 35 | REMIT_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Remit Country |
| 36 | REMIT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Remit Phone Number |
| 37 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 38 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 39 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 40 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 41 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 42 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 43 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 44 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 45 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 46 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 47 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 48 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 49 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 50 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 51 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 52 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 53 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 54 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 55 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
| 56 | CLCT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Collector Name |
| 57 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 58 | 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) |
| 59 | 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) |
| 60 | 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) |
| 61 | 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) |
| 62 | 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) |
| 63 | 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) |
| 64 | 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) |
| 65 | 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) |
| 66 | 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). |
| 67 | 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). |
| 68 | 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). |
| 69 | 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). |
| 70 | 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). |
| 71 | 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). |
| 72 | 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). |
| 73 | 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). |
| 74 | 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). |
| 75 | 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). |
| 76 | 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). |
| 77 | 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). |
| 78 | 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). |
| 79 | 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). |