AR_DMS_OVR_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
|
| 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_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""." |
| 22 | 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 |
| 23 | 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. |
| 24 | 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. |
| 25 | 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. |
| 26 | 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. |
| 27 | PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete E=Errors N=Initialize P=In Process |