AR35001_TMP (SQL Table)	Index Back
Overdue Charges Report table Overdue Charges Report table

AR35001_TMP

(SQL Table)

Overdue Charges Report table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

3 OC_ID_NUM Number(8,0) INTEGER NOT NULL Overdue Charge 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 OVERDUE_CHG_TYPE Character(1) VARCHAR2(1) NOT NULL Overdue Charge Type
A=Admin
F=Finance
P=Penalty

9 OC_DT Date(10) DATE Overdue Charge Date

10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

30 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

49 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name

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

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

52 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""."

53 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance

54 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount

55 PRINT_COMP Character(1) VARCHAR2(1) NOT NULL Print Completed

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
3	OC_ID_NUM	Number(8,0)	INTEGER NOT NULL	Overdue Charge 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	OVERDUE_CHG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Overdue Charge Type A=Admin F=Finance P=Penalty
9	OC_DT	Date(10)	DATE	Overdue Charge Date
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
12	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
13	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
14	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
15	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
16	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
17	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
18	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
19	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
20	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
21	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
22	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
23	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
24	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
25	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
26	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
27	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
28	CNTCT_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Contact Name1
29	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
30	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
31	REMIT_ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Remit Address1
32	REMIT_ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Remit Address2
33	REMIT_ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Remit Address3
34	REMIT_ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Remit Address4
35	REMIT_CITY	Character(30)	VARCHAR2(30) NOT NULL	Remit City
36	REMIT_NUM1	Character(6)	VARCHAR2(6) NOT NULL	Remit Num1
37	REMIT_NUM2	Character(4)	VARCHAR2(4) NOT NULL	Remit number 2
38	REMIT_HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Remit House Type
39	REMIT_IN_CITY_LMT	Character(1)	VARCHAR2(1) NOT NULL	Remit In City Limit
40	REMIT_COUNTY	Character(30)	VARCHAR2(30) NOT NULL	Remit County
41	REMIT_STATE	Character(6)	VARCHAR2(6) NOT NULL	Remit State
42	REMIT_GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Remit Tax Supplier Geo Code
43	REMIT_POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Remit Postal Code
44	REMIT_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Remit Country
45	REMIT_ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
46	REMIT_ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
47	REMIT_ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
48	REMIT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Remit Phone Number
49	NAMESHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Name
50	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.
51	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.
52	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""."
53	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
54	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
55	PRINT_COMP	Character(1)	VARCHAR2(1) NOT NULL	Print Completed
56	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
57	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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).