AR33000_TMP(SQL Table) |
Index Back |
---|---|
Dunning Letter table for AE2021-03 - Payment Plan feature added new fields |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_FS_VW.SETID Prompt Table: SP_SETCS_NONVW |
2 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CUST_CR_A1S_VW |
3 | DUN_ID_NUM | Number(8,0) | INTEGER NOT NULL | Dunning Number |
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 | 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. |
7 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
8 | DUN_DT | Date(10) | DATE | Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR. |
9 | DUN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Dunning Method
A=Dunning by Action List D=Dunning by Days L=Dunning by Level |
10 | DUN_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Dunning Sequence Number |
11 | DUN_INTERVAL | Number(3,0) | SMALLINT NOT NULL | Dunning Interval |
12 | DAYS_BETWEEN_DC | Number(4,0) | SMALLINT NOT NULL | Days Between Dunning Charges |
13 | FC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR. |
14 | FC_AMT_DSP | Number(27,3) | DECIMAL(26,3) NOT NULL | Finance Charge Amount in Display Currency |
15 | LC_AMT | Number(6,2) | DECIMAL(5,2) NOT NULL | Dunning Letter Charge Amount |
16 | LC_AMT_DSP | Number(27,3) | DECIMAL(26,3) NOT NULL | Dunning Letter Charge in Display Currency |
17 | INCLUDE_FC | Character(1) | VARCHAR2(1) NOT NULL | Include Finance Charge |
18 | INCLUDE_DC | Character(1) | VARCHAR2(1) NOT NULL |
Include Dunning Letter Charge Indicator
N=Not Include Letter Charge Y=Include Letter Charge |
19 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters. |
20 | PRINT_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Print Completed
Y/N Table Edit |
21 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
22 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
23 | 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. |
24 | 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""." |
25 | 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. |
26 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
27 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
28 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
29 | BAL_AMT_LAST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Display Letter Amount |
30 | DSP_CUR_CD_WSH | Character(3) | VARCHAR2(3) NOT NULL |
Worksheet Disp. Currency Code
Default Value: BUS_UNIT_OPT_AR.DSP_CUR_CD_WSH Prompt Table:
CURRENCY_CD_TBL
|
31 | DC_RT_TYPE_WSH | Character(5) | VARCHAR2(5) NOT NULL |
Worksheet Rate Type
Default Value: BUS_UNIT_OPT_AR.DC_RT_TYPE_WSH Prompt Table:
RT_TYPE_TBL
|
32 | EFFDT_OPT_WSH | Character(1) | VARCHAR2(1) NOT NULL |
Worksheet Effect. Date Option
A=Accounting Date O=Other T=As of Today Default Value: BUS_UNIT_OPT_AR.EFFDT_OPT_WSH |
33 | CUR_EFFDT | Date(10) | DATE | Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. |
34 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
35 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
36 | DAYS_LATE | Signed Number(7,0) | DECIMAL(6) NOT NULL | Days Late |
37 | REMIT_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address1 |
38 | REMIT_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address2 |
39 | REMIT_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address3 |
40 | REMIT_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address4 |
41 | REMIT_CITY | Character(30) | VARCHAR2(30) NOT NULL | Remit City |
42 | REMIT_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Remit Num1 |
43 | REMIT_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Remit number 2 |
44 | REMIT_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Remit House Type |
45 | REMIT_IN_CITY_LMT | Character(1) | VARCHAR2(1) NOT NULL | Remit In City Limit |
46 | REMIT_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | Remit County |
47 | REMIT_STATE | Character(6) | VARCHAR2(6) NOT NULL | Remit State |
48 | REMIT_GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Remit Tax Supplier Geo Code |
49 | REMIT_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Remit Postal Code |
50 | REMIT_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Remit Country |
51 | REMIT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Remit Phone Number |
52 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
53 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
54 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
55 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
56 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
57 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
58 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
59 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
60 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
61 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
62 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
63 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
64 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
65 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
66 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
67 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
68 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
69 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
70 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
71 | CLCT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Collector Name |
72 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
73 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
74 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
75 | DELIVERY_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Method
E=Email F=Fax P=Print |
76 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
77 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
78 | PRINTER | Character(20) | VARCHAR2(20) NOT NULL | Printer Specification |
79 | 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. |
80 | AG_PRINT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Acceptgiro Print Flag - Yes/No |
81 | AG_REF_NBR | Number(16,0) | DECIMAL(16) NOT NULL | Payment Reference Number |
82 | AG_REF_CHR | Character(16) | VARCHAR2(16) NOT NULL | Payment Reference Number |
83 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
84 | BANK_ACCOUNT_NUM1 | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given internal partner bank/counterparty acco |
85 | 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) |
86 | 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) |
87 | 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) |
88 | 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) |
89 | 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) |
90 | 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) |
91 | 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) |
92 | 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) |
93 | 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). |
94 | 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). |
95 | 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). |
96 | 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). |
97 | 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). |
98 | 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). |
99 | 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). |
100 | 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). |
101 | 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). |
102 | 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). |
103 | 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). |
104 | 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). |
105 | 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). |
106 | 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). |
107 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
108 | PAYMENT_PLAN | Character(15) | VARCHAR2(15) NOT NULL | Payment Plan |
109 | ITEM_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Item Source ID |
110 | ITEM_SOURCE_LINE | Number(6,0) | INTEGER NOT NULL | Item Source Line |