UPG_DM_AET(SQL Table) |
Index Back |
---|---|
Payment Predictor AE CachePayment 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. |