AR33004_TMP (SQL Table)	Index Back
PS/AR FollowUp Letter Report PS/AR FollowUp Letter Report Table

AR33004_TMP

(SQL Table)

PS/AR FollowUp Letter Report

PS/AR FollowUp Letter Report Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime
Default Value: %datetime

7 CONVER_DT Date(10) DATE Conversation Date

8 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number

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

10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

11 REVIEW_NEXT_DT Date(10) DATE Next Review Date

12 PROMISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Forecast

13 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 PROMISE_DT Date(10) DATE Promise Date

16 REMIT_ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Remit Address1

17 REMIT_ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Remit Address2

18 REMIT_ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Remit Address3

19 REMIT_ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Remit Address4

20 REMIT_CITY Character(30) VARCHAR2(30) NOT NULL Remit City

21 REMIT_NUM1 Character(6) VARCHAR2(6) NOT NULL Remit Num1

22 REMIT_NUM2 Character(4) VARCHAR2(4) NOT NULL Remit number 2

23 REMIT_HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL Remit House Type

24 REMIT_IN_CITY_LMT Character(1) VARCHAR2(1) NOT NULL Remit In City Limit

25 REMIT_COUNTY Character(30) VARCHAR2(30) NOT NULL Remit County

26 REMIT_STATE Character(6) VARCHAR2(6) NOT NULL Remit State

27 REMIT_GEO_CODE Character(11) VARCHAR2(11) NOT NULL Remit Tax Supplier Geo Code

28 REMIT_POSTAL Character(12) VARCHAR2(12) NOT NULL Remit Postal Code

29 REMIT_COUNTRY Character(3) VARCHAR2(3) NOT NULL Remit Country

30 REMIT_ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

31 REMIT_ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

32 REMIT_ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

33 REMIT_PHONE Character(24) VARCHAR2(24) NOT NULL Remit Phone Number

34 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

35 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

36 CNTCT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name1

37 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

38 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

39 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

40 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

41 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

42 CITY Character(30) VARCHAR2(30) NOT NULL City

43 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

44 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

45 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

46 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

47 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

48 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

49 COUNTY Character(30) VARCHAR2(30) NOT NULL County

50 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

51 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

52 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

53 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

54 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

55 DESCRLONG Long Character CLOB Long Description

56 KEYWORD1 Character(10) VARCHAR2(10) NOT NULL Keyword

57 KEYWORD2 Character(10) VARCHAR2(10) NOT NULL Keyword

58 KEYWORD3 Character(10) VARCHAR2(10) NOT NULL Keyword

59 DELIVERY_METHOD Character(1) VARCHAR2(1) NOT NULL Delivery Method
E=Email
F=Fax
P=Print

60 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

61 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

62 PRINTER Character(20) VARCHAR2(20) NOT NULL Printer Specification

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	CONVER_DTTM_INIT	DateTime(26)	TIMESTAMP	Initial Conversation DateTime Default Value: %datetime
7	CONVER_DT	Date(10)	DATE	Conversation Date
8	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number
9	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.
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	REVIEW_NEXT_DT	Date(10)	DATE	Next Review Date
12	PROMISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Forecast
13	PAY_PROMISE_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Promise to Pay amount
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	PROMISE_DT	Date(10)	DATE	Promise Date
16	REMIT_ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Remit Address1
17	REMIT_ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Remit Address2
18	REMIT_ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Remit Address3
19	REMIT_ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Remit Address4
20	REMIT_CITY	Character(30)	VARCHAR2(30) NOT NULL	Remit City
21	REMIT_NUM1	Character(6)	VARCHAR2(6) NOT NULL	Remit Num1
22	REMIT_NUM2	Character(4)	VARCHAR2(4) NOT NULL	Remit number 2
23	REMIT_HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Remit House Type
24	REMIT_IN_CITY_LMT	Character(1)	VARCHAR2(1) NOT NULL	Remit In City Limit
25	REMIT_COUNTY	Character(30)	VARCHAR2(30) NOT NULL	Remit County
26	REMIT_STATE	Character(6)	VARCHAR2(6) NOT NULL	Remit State
27	REMIT_GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Remit Tax Supplier Geo Code
28	REMIT_POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Remit Postal Code
29	REMIT_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Remit Country
30	REMIT_ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
31	REMIT_ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
32	REMIT_ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
33	REMIT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Remit Phone Number
34	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
35	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
36	CNTCT_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Contact Name1
37	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
38	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
39	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
40	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
41	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
42	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
43	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
44	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
45	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
46	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
47	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
48	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
49	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
50	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
51	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
52	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
53	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
54	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
55	DESCRLONG	Long Character	CLOB	Long Description
56	KEYWORD1	Character(10)	VARCHAR2(10) NOT NULL	Keyword
57	KEYWORD2	Character(10)	VARCHAR2(10) NOT NULL	Keyword
58	KEYWORD3	Character(10)	VARCHAR2(10) NOT NULL	Keyword
59	DELIVERY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Delivery Method E=Email F=Fax P=Print
60	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
61	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
62	PRINTER	Character(20)	VARCHAR2(20) NOT NULL	Printer Specification
63	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.