AR33000_TMP

(SQL Table)
Index Back

Dunning Letter table for AE

2021-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
Set Control Field: CURRENCY_CD

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
Set Control Field: RT_TYPE

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