ACTN_LSTALL_VW (SQL View)	Index Back
Action List View

ACTN_LSTALL_VW

(SQL View)

Action List View

SELECT A.SETID , A.CUST_ID , A.CONDITION_ID , A.CUST_HIST_ID , A.ENTRY_TYPE , A.ENTRY_REASON , A.BUSINESS_UNIT , A.SEQ_NBR , A.TMPLT_ID , A.PLAN_ID , A.COND_ROLE , A.ACTION_STATUS , A.CANCEL_REASON_CD , A.DATE_ADDED , A.ACTION_DT , A.PRIORITY , A.OWNER_TYPE , A.ACTION_OWNER , A.ACTION_CODE , A.ACTION_PARM , A.DELIVERY_METHOD , A.PROPOSED_AUTOMATED , A.AMOUNT , A.CURRENCY_CD , A.DATE_QUERY_VALUE , A.TRANS_COUNT , A.PERCENTAGE , A.ITEM , A.ITEM_LINE , A.ASSN_OPRID , A.NUM_PER , A.COMPLETION_DATE , A.LAST_OPRID , A.RULE_LEVEL , A.CONVER_DTTM_INIT , A.CONVER_DT , A.CONVER_SEQ_NUM , A.CONVER_DTTM , A.CONVR_QUALIFIER_CD , A.DUN_ID_NUM , A.ST_ID_NUM , A.DESCR100 , A.CRSPD_SETID , A.CRSPD_CUST_ID , A.CONTACT_ID , A.CNTCT_SEQ_NUM , A.DUE_DT , A.NOTIFY_FLAG , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.ESCAL_MGR_DT , A.ESCAL_OWNER_DT , A.ESCAL_SPSLST_DT , A.ESCAL_MGR_OPRID , A.ESCAL_OWNER_OPRID , A.ESCAL_SPSLST_OPRID , A.OPRID_ENTERED_BY , A.LAST_MAINT_DTTM , A.LAST_MAINT_OPRID , C.NAME1 , C.CITY , C.STATE , C.COUNTRY , D.ROLEUSER_SUPR , E.AR_SPECIALIST , E.BAL_AMT_BASE , E.CURRENCY_CD , A.ANCHOR_AMOUNT , A.RULE_ANCHOR_AMOUNT , A.ANCHOR_CURRENCY , A.ANCHOR_RT_TYPE , A.ANCHOR_DATE , A.ANCHOR_CR_LIMIT , C.RISK_SCORE , A.PROMISE_CURRENCY , A.PROMISE_DT , A.PAY_PROMISE_AMT FROM PS_ACT_CUST1_VW C , PS_ROLEXLATOPR D , PS_ACTION_LST A , PS_ITEM E WHERE E.BUSINESS_UNIT (+) = A.BUSINESS_UNIT AND E.CUST_ID (+) = A.CUST_ID AND E.ITEM (+) = A.ITEM AND E.ITEM_LINE (+) = A.ITEM_LINE AND A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND A.ASSN_OPRID = D.OPRID AND A.ACTION_STATUS NOT IN ('SCA','SYS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.
Prompt Table: CUST_SRCH_VW

3 CONDITION_ID Character(4) VARCHAR2(4) NOT NULL Condition ID
ACLA=Approaching Credit Limit
ACLD=Approaching Credit Limit Exp
CCEX=Approaching CC expiration date
CCHD=Cancel Credit Hold
CFLU=Conversation Follow Up
CHLD=Credit Hold Code Exists
COLL=Collection
CPDB=Customer Promise Date Broken
CPDR=Customer Promise Date Review
DEDN=Deduction Item
DISP=Disputed Item
EBIL=eBill selection by user
ECLA=Exceeded Credit Limit
ECLD=Exceed CR Limit Expiration Dt
ETRC=Entry Type / Reason Code
KSTE=Key Statistics Exceeded
LACD=Large Amount Coming Due
ONLN=Online selection by user
RISK=Risk Score
WBDC=Welcome Back Dormant Customer
WCNC=Welcome New Customer

4 CUST_HIST_ID Character(10) VARCHAR2(10) NOT NULL History ID

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

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

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

9 TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Template ID

10 PLAN_ID Number(15,0) DECIMAL(15) NOT NULL Plan ID

11 COND_ROLE Character(1) VARCHAR2(1) NOT NULL Condition Role
B=Bill To Customer
C=Corporate Customer
P=Correspondence Customer
R=Remit From Customer

12 ACTION_STATUS Character(3) VARCHAR2(3) NOT NULL Action Status
CAN=Cancelled
CMP=Completed
FUT=Future
NEW=New
PND=Pending
PRS=In Process
SCA=System Cancelled
SYS=System Completed

13 CANCEL_REASON_CD Character(2) VARCHAR2(2) NOT NULL Cancel Reason Code
HO=Credit Hold Exists
IC=Item Closed
NC=No Longer In Violation COLL RL
NV=No Longer in Violation
OP=Operator Cancelled
RC=Rule Owner Change
UP=Template Upgrade
ZB=Zero Balance

14 DATE_ADDED Date(10) DATE Date Added

15 ACTION_DT Date(10) DATE Action Date

16 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

17 OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person

18 ACTION_OWNER Character(30) VARCHAR2(30) NOT NULL Action Owner

19 ACTION_CODE Character(4) VARCHAR2(4) NOT NULL Action Code
ALRT=Alert
CALL=Call the Customer
CRDT=Review Customer Credit Limit
DLTR=Dunning Letter
DNGD=Downgrade Credit Rating
FEBN=Follow up eBill Note
HOLD=Place Customer on Hold
OLTR=Send Other Letter
POD=Proof of Delivery
PRBK=Review Broken Promise Date
PRFO=Review Promise Date
REFR=Refer to Collection Agency
STMT=Send Statement of Account
WOFF=Write off Customer Balance

20 ACTION_PARM Character(6) VARCHAR2(6) NOT NULL Action Parameter

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

22 PROPOSED_AUTOMATED Character(1) VARCHAR2(1) NOT NULL Proposed/Automated
A=Automated
P=Proposed

23 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

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

25 DATE_QUERY_VALUE Date(10) DATE Date Query Value

26 TRANS_COUNT Number(3,0) SMALLINT NOT NULL Transaction Count

27 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

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

29 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

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

31 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods

32 COMPLETION_DATE Date(10) DATE Completion Date

33 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator

34 RULE_LEVEL Character(1) VARCHAR2(1) NOT NULL Rule Level
C=Customer
G=Customer Group
S=SetID

35 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime

36 CONVER_DT Date(10) DATE Conversation Date

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

38 CONVER_DTTM DateTime(26) TIMESTAMP Conversation DateTime

39 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
BA=Buy Agremt
BI=Invoice #
CP=Cust Pay
CT=Contract
D=Document
I=Item
L=Lading
P=PO Number
PY=Payment ID
QU=Quote
RM=RMA
SC=Case Num
SO=Sale Order

40 DUN_ID_NUM Number(8,0) INTEGER NOT NULL Dunning Number

41 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number

42 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

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

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

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

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

47 DUE_DT Date(10) DATE NOT NULL 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.

48 NOTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Recieve Notification

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

50 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

51 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

52 ESCAL_MGR_DT Date(10) DATE Esculate Manager Date

53 ESCAL_OWNER_DT Date(10) DATE Esculate Owner Date

54 ESCAL_SPSLST_DT Date(10) DATE Esculate Specialist Date

55 ESCAL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Date

56 ESCAL_OWNER_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Oper ID

57 ESCAL_SPSLST_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Specialist ID

58 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

59 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

60 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

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

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

63 STATE Character(6) VARCHAR2(6) NOT NULL State

64 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

65 ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User

66 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

67 BAL_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance - Base Currency

68 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

69 ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.

70 RULE_ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.

71 ANCHOR_CURRENCY Character(3) VARCHAR2(3) NOT NULL The base currency of the business unit that generates a given deal transaction.

72 ANCHOR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

73 ANCHOR_DATE Date(10) DATE Anchor Date

74 ANCHOR_CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit

75 RISK_SCORE Number(3,0) SMALLINT NOT NULL Risk Score used in Receivables Collections Workbench

76 PROMISE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Promise Currency Code

77 PROMISE_DT Date(10) DATE Promise Date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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. Prompt Table: CUST_SRCH_VW
3	CONDITION_ID	Character(4)	VARCHAR2(4) NOT NULL	Condition ID ACLA=Approaching Credit Limit ACLD=Approaching Credit Limit Exp CCEX=Approaching CC expiration date CCHD=Cancel Credit Hold CFLU=Conversation Follow Up CHLD=Credit Hold Code Exists COLL=Collection CPDB=Customer Promise Date Broken CPDR=Customer Promise Date Review DEDN=Deduction Item DISP=Disputed Item EBIL=eBill selection by user ECLA=Exceeded Credit Limit ECLD=Exceed CR Limit Expiration Dt ETRC=Entry Type / Reason Code KSTE=Key Statistics Exceeded LACD=Large Amount Coming Due ONLN=Online selection by user RISK=Risk Score WBDC=Welcome Back Dormant Customer WCNC=Welcome New Customer
4	CUST_HIST_ID	Character(10)	VARCHAR2(10) NOT NULL	History ID
5	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.
6	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""."
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
10	PLAN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Plan ID
11	COND_ROLE	Character(1)	VARCHAR2(1) NOT NULL	Condition Role B=Bill To Customer C=Corporate Customer P=Correspondence Customer R=Remit From Customer
12	ACTION_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Action Status CAN=Cancelled CMP=Completed FUT=Future NEW=New PND=Pending PRS=In Process SCA=System Cancelled SYS=System Completed
13	CANCEL_REASON_CD	Character(2)	VARCHAR2(2) NOT NULL	Cancel Reason Code HO=Credit Hold Exists IC=Item Closed NC=No Longer In Violation COLL RL NV=No Longer in Violation OP=Operator Cancelled RC=Rule Owner Change UP=Template Upgrade ZB=Zero Balance
14	DATE_ADDED	Date(10)	DATE	Date Added
15	ACTION_DT	Date(10)	DATE	Action Date
16	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
17	OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type A=Credit Analyst C=Collector O=Other R=AR Specialist S=Sales Person
18	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner
19	ACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Action Code ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance
20	ACTION_PARM	Character(6)	VARCHAR2(6) NOT NULL	Action Parameter
21	DELIVERY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Delivery Method E=Email F=Fax P=Print
22	PROPOSED_AUTOMATED	Character(1)	VARCHAR2(1) NOT NULL	Proposed/Automated A=Automated P=Proposed
23	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	DATE_QUERY_VALUE	Date(10)	DATE	Date Query Value
26	TRANS_COUNT	Number(3,0)	SMALLINT NOT NULL	Transaction Count
27	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
28	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.
29	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
30	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.
31	NUM_PER	Number(3,0)	SMALLINT NOT NULL	Number of Periods
32	COMPLETION_DATE	Date(10)	DATE	Completion Date
33	LAST_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Response Operator
34	RULE_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Rule Level C=Customer G=Customer Group S=SetID
35	CONVER_DTTM_INIT	DateTime(26)	TIMESTAMP	Initial Conversation DateTime
36	CONVER_DT	Date(10)	DATE	Conversation Date
37	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number
38	CONVER_DTTM	DateTime(26)	TIMESTAMP	Conversation DateTime
39	CONVR_QUALIFIER_CD	Character(2)	VARCHAR2(2) NOT NULL	Conversation Qualifier Code BA=Buy Agremt BI=Invoice # CP=Cust Pay CT=Contract D=Document I=Item L=Lading P=PO Number PY=Payment ID QU=Quote RM=RMA SC=Case Num SO=Sale Order
40	DUN_ID_NUM	Number(8,0)	INTEGER NOT NULL	Dunning Number
41	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
42	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
43	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
44	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
45	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
46	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
47	DUE_DT	Date(10)	DATE NOT NULL	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.
48	NOTIFY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Recieve Notification
49	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
50	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
51	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
52	ESCAL_MGR_DT	Date(10)	DATE	Esculate Manager Date
53	ESCAL_OWNER_DT	Date(10)	DATE	Esculate Owner Date
54	ESCAL_SPSLST_DT	Date(10)	DATE	Esculate Specialist Date
55	ESCAL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Owner Date
56	ESCAL_OWNER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Owner Oper ID
57	ESCAL_SPSLST_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Specialist ID
58	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
59	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
60	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
61	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
62	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
63	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
64	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
65	ROLEUSER_SUPR	Character(30)	VARCHAR2(30) NOT NULL	Supervisor Role User
66	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
67	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
68	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
69	ANCHOR_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Principal amount of a given deal transaction denominated in the anchor currency.
70	RULE_ANCHOR_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Principal amount of a given deal transaction denominated in the anchor currency.
71	ANCHOR_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the business unit that generates a given deal transaction.
72	ANCHOR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
73	ANCHOR_DATE	Date(10)	DATE	Anchor Date
74	ANCHOR_CR_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Limit
75	RISK_SCORE	Number(3,0)	SMALLINT NOT NULL	Risk Score used in Receivables Collections Workbench
76	PROMISE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Promise Currency Code
77	PROMISE_DT	Date(10)	DATE	Promise Date
78	PAY_PROMISE_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Promise to Pay amount