UPG_DM_AET

(SQL Table)
Index Back

Payment Predictor AE Cache

Payment Predictor AE Cache

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
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 ITEM_LINE2 Number(6,0) INTEGER NOT NULL Item Line
9 SPLIT_ID Number(3,0) SMALLINT NOT NULL Suffix Number
10 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
11 SUB_GROUP_ID Number(6,0) INTEGER NOT NULL Sub Group ID
12 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records
13 UPG_RELEASE Character(4) VARCHAR2(4) NOT NULL Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
14 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
15 SETID Character(5) VARCHAR2(5) NOT NULL SetID
16 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.
17 EFFDT Date(10) DATE Effective Date
18 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.
19 ENTRY_TYPE_WRK Character(5) VARCHAR2(5) NOT NULL Entry Type
20 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
21 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
22 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
23 DOCUMENT Character(30) VARCHAR2(30) NOT NULL Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
24 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
25 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
26 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
27 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
28 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
29 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
30 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)
31 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)
32 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)
33 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)
34 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)
35 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)
36 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)
37 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)
38 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).
39 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).
40 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).
41 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).
42 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).
43 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).
44 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).
45 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).
46 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).
47 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).
48 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).
49 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).
50 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).
51 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).
52 SALES_PERSON2 Character(8) VARCHAR2(8) NOT NULL Identifies a second Sales Person. Populated on the Item Table to identify an additional Sales Person the Item is applied to.
53 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
54 CLAIM_NO Character(30) VARCHAR2(30) NOT NULL Claim Number for an item
55 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.
56 BROKER_ID Character(15) VARCHAR2(15) NOT NULL Broker ID
57 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
58 CLAIM_DT Date(10) DATE Claim Date
59 CLASS_OF_TRADE Character(20) VARCHAR2(20) NOT NULL Class of Trade
60 DEDUCTION_STATUS Character(5) VARCHAR2(5) NOT NULL Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
61 DEDUCTION_DT Date(10) DATE Deduction Date
62 DIVISION Character(20) VARCHAR2(20) NOT NULL Division
63 DT_INVOICED Date(10) DATE Date Invoiced
64 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
65 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
66 INVOICE_BU Character(5) VARCHAR2(5) NOT NULL Invoice Business Unit
67 MAJOR_CLASS Character(10) VARCHAR2(10) NOT NULL Major Classification
68 PROOF_OF_DELIVERY Character(30) VARCHAR2(30) NOT NULL Proof of Delivery
69 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
70 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num
71 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
72 SOLD_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Sold To Address Sequence Num
73 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
74 MAX_WRITE_OFF_PCT Number(3,0) SMALLINT NOT NULL Write off Tolerance Percentage of amount
75 MAX_WRITE_OFF_DAYS Number(3,0) SMALLINT NOT NULL Write off Tolerance Days from Deduction date
76 WS_WOT_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Write off Tolerance
77 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
78 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
79 DM_CREATE_DTTM DateTime(26) TIMESTAMP Date created
80 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
81 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
82 DM_ACTION_STATUS Character(3) VARCHAR2(3) NOT NULL Deduction Action Status
A=All of the Above
C=Closed Items
D=Done
I=In-Process Items
N=New
O=Open Items
83 DM_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type
D=Done
I=In Process
N=New
84 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
85 DM_ACTION_CODE Character(5) VARCHAR2(5) NOT NULL DM Action Code
86 ACTION_OWNER Character(30) VARCHAR2(30) NOT NULL Action Owner
87 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
88 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.
89 COMPLETION_DATE Date(10) DATE Completion Date
90 OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person
91 ITEM_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.
92 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
93 CFSTRING1 Long Character(1000) VARCHAR2(1000) ChartField String
94 CFSTRING2 Long Character(1000) VARCHAR2(1000) ChartField String
95 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.