AR_DMS_REC_AET

(SQL Table)
Index Back

Debt Management Services (DMS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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
Set Control Field: BUSINESS_UNIT

4 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.
5 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
6 AGENCYID Character(9) VARCHAR2(9) NOT NULL New field used to store a proprietary DMS Agency_Id code.
7 BAL_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance - Base Currency
8 FC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
9 OC_PNLTY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
10 OC_ADMIN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
11 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.
12 TOTAL_BASE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Base Amount
13 LINE_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Create Charge by Item Line
14 ASOF_DT Date(10) DATE As of Date
15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
16 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
17 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
18 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
19 ERROR_FLG1 Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator
20 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
21 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.
22 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""."
23 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.
24 DST_ID_AR Character(10) VARCHAR2(10) NOT NULL Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
25 PRINCIPAL_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the principal.
26 TRANS_TYPE_DMS Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
AD1=Adjustment Transaction-Up
AD2=Adjustment Transaction-Down
OFF=Offset
PAY=Payment
27 FC_DT Date(10) DATE Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
28 OC_ADMIN_DT Date(10) DATE Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
29 OC_PNLTY_DT Date(10) DATE Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
30 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
31 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
32 ITEM_LINE_ORIG Number(6,0) INTEGER NOT NULL Original OC Item Line
33 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.
34 MAX_SEQ Number(3,0) SMALLINT NOT NULL Max Sequence Number
35 TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
36 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
37 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
38 SETID Character(5) VARCHAR2(5) NOT NULL SetID
39 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
40 WORK_CNT Number(10,0) DECIMAL(10) NOT NULL Count of Anything
41 TOTAL_NET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Net Amount
42 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records
43 TRANSACTION_COUNT Number(6,0) INTEGER NOT NULL
44 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
45 ABORT_FLAG Character(1) VARCHAR2(1) NOT NULL Abort Process Flag