UPG_AR_AET(SQL Table) |
Index Back |
|---|---|
AR Upgrade scripts State Recor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 7 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
| 8 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL | Represents the high level grouping of multiple general ledger business units. |
| 9 | 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. |
| 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | 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. |
| 13 | 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. |
| 14 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 15 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 16 | REMIT_DT | Date(10) | DATE | Remittance Date |
| 17 | REMIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Remittance ID |
| 18 | DRAFT_BUSN_EVENT | Character(2) | VARCHAR2(2) NOT NULL | Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft. |
| 19 | DRAFT_POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Draft Post Action
A=Actual D=Dishonor |
| 20 | DRAFT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 21 | DRAFT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. |
| 22 | ENTRY_USE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the System Function or type of processing associated with an entry type. |
| 23 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 24 | DST_ID_DM_AR | Character(10) | VARCHAR2(10) NOT NULL | Draft AR Distribution Code |
| 25 | DRAFT_SEL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Selected Amount |
| 26 | 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. |
| 27 | 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""." |
| 28 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 29 | ASOF_DT | Date(10) | DATE | As of Date |
| 30 | 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. |
| 31 | COLLECTOR | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer to collect overdue payments. |
| 32 | 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. |
| 33 | 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. |
| 34 | DST_ID_DM_DIS | Character(10) | VARCHAR2(10) NOT NULL | Draft Discount Receivable Code |
| 35 | DST_ID_DM_LIAB | Character(10) | VARCHAR2(10) NOT NULL | Draft Discount Liability Code |
| 36 | REMIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Remittance Business Unit |
| 37 | DISCOUNT_DRAFT | Character(1) | VARCHAR2(1) NOT NULL | Discount Draft |
| 38 | DRAFT_DUE_DT | Date(10) | DATE | Draft Due Date |
| 39 | RECOURSE_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL | Allow Recourse |
| 40 | DRAFT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2). |
| 41 | DRAFT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft. |
| 42 | OPEN_PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | Open Period From |
| 43 | OPEN_PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | Open Period To |
| 44 | OPEN_YEAR_FROM | Number(4,0) | SMALLINT NOT NULL | Open Year From |
| 45 | OPEN_YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Open Year To |
| 46 | CALL_SECTION | Character(1) | VARCHAR2(1) NOT NULL | Call Section Y/N |
| 47 | CC_GROUP_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Group Sequency |
| 48 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 49 | ITEM_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 50 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 51 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
| 52 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 53 | COUNTRY_VAT_RPTG | Character(3) | VARCHAR2(3) NOT NULL | VAT Reporting Country |
| 54 | VAT_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | VAT Document ID |
| 55 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 56 | DSCNT_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Discount Percentage |
| 57 | DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT. This is the first of two possible discounts associated with an item. |
| 58 | ENTRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of a pending item transaction such as invoice or credit memo. |
| 59 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 60 | AR_RECCOUNT | Number(10,0) | DECIMAL(10) NOT NULL | AR_Reccount |
| 61 | DOC_TYPE_IU | 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. |
| 62 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
| 63 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 64 | OLD_BILL_ALC | Number(8,0) | INTEGER NOT NULL | |
| 65 | OLD_CUST_ALC | Number(8,0) | INTEGER NOT NULL | |
| 66 | BILLING_ALC | Character(8) | VARCHAR2(8) NOT NULL | Billing Agency Location Code |
| 67 | CUSTOMER_ALC | Character(8) | VARCHAR2(8) NOT NULL | Customer Agency Location Code |
| 68 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 69 | CUTOFF_DT | Date(10) | DATE | The settlement cutoff date for a given bank/counterparty. |
| 70 | ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 71 | DST_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 72 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters. |
| 73 | EFFDT | Date(10) | DATE | Effective Date |
| 74 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 75 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 76 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 77 | DUN_ID_NUM | Number(8,0) | INTEGER NOT NULL | Dunning Number |
| 78 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 79 | DUN_TEXT | Long Character(1000) | VARCHAR2(1000) | Dunning letter text |
| 80 | STATE_VAT_PERFRM | Character(6) | VARCHAR2(6) NOT NULL | State Where Service Physically Performed |
| 81 | OPRID_FROM | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 82 | PROMISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cash Forecast |
| 83 | PROMISE_CONFIDENCE | Character(1) | VARCHAR2(1) NOT NULL |
Promise Confidence
H=High L=Low M=Medium |
| 84 | PROMISE_DT | Date(10) | DATE | Promise Date |
| 85 | REVIEW_COMP | Character(1) | VARCHAR2(1) NOT NULL | Review Completed |
| 86 | REVIEW_NEXT_DT | Date(10) | DATE | Next Review Date |
| 87 | REVIEW_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 88 | SUP_REVIEW | Character(1) | VARCHAR2(1) NOT NULL | Supervisor Review |
| 89 | SUP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Supervisor Review Status
I=Incomplete N=New R=Reviewed |
| 90 | SETID2 | Character(5) | VARCHAR2(5) NOT NULL | 2nd SetId |
| 91 | CUST_ID2 | 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. |
| 92 | CONVER_DTX | Date(10) | DATE | Conversation Date |
| 93 | CONVER_DTTM_INITX | DateTime(26) | TIMESTAMP | Initial Conversation DateTime |
| 94 | CONVER_SEQ_NUMX | Number(4,0) | SMALLINT NOT NULL | Conversation Sequence Number |
| 95 | CNTCT_SEQ_NUMX | Number(5,0) | INTEGER NOT NULL | Contact Seq Number |
| 96 | DUN_LETTER_COMPX | Character(1) | VARCHAR2(1) NOT NULL | Dunning Letter Complete |
| 97 | FOLLOW_UP_ACTIONX | Character(10) | VARCHAR2(10) NOT NULL | Follow-Up Action |
| 98 | FOLLOW_UP_COMPX | Character(1) | VARCHAR2(1) NOT NULL | Follow Up Completed |
| 99 | FOLLOW_UP_DTX | Date(10) | DATE | Date of Follow-up Letter |
| 100 | FOLLOW_UP_OPRIDX | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 101 | KEYWORD1X | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 102 | KEYWORD2X | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 103 | KEYWORD3X | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 104 | LETTER_CDX | Character(3) | VARCHAR2(3) NOT NULL | Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters. |
| 105 | OPRID_FROMX | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 106 | PROMISE_AMTX | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Cash Forecast |
| 107 | PROMISE_CONFIDENCX | Character(1) | VARCHAR2(1) NOT NULL | Promise Confidence |
| 108 | PROMISE_DTX | Date(10) | DATE | Promise Date |
| 109 | REVIEW_COMPX | Character(1) | VARCHAR2(1) NOT NULL | Review Completed |
| 110 | REVIEW_NEXT_DTX | Date(10) | DATE | Next Review Date |
| 111 | REVIEW_OPRIDX | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 112 | SUP_REVIEWX | Character(1) | VARCHAR2(1) NOT NULL | Supervisor Review |
| 113 | SUP_STATUSX | Character(1) | VARCHAR2(1) NOT NULL | Supervisor Review Status |
| 114 | THREAD_COUNT1 | Number(6,0) | INTEGER NOT NULL | Number of Entries |
| 115 | CONVER_SEQ_NUMY | Number(4,0) | SMALLINT NOT NULL | Conversation Sequence Number |
| 116 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 117 | CONVER_DT | Date(10) | DATE | Conversation Date |
| 118 | CONVER_DTTM_INIT | DateTime(26) | TIMESTAMP | Initial Conversation DateTime |
| 119 | CONVER_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Conversation Sequence Number |
| 120 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 121 | DUN_LETTER_COMP | Character(1) | VARCHAR2(1) NOT NULL | Dunning Letter Complete |
| 122 | FOLLOW_UP_ACTION | Character(10) | VARCHAR2(10) NOT NULL | Follow-Up Action |
| 123 | FOLLOW_UP_COMP | Character(1) | VARCHAR2(1) NOT NULL | Follow Up Completed |
| 124 | FOLLOW_UP_DT | Date(10) | DATE | Date of Follow-up Letter |
| 125 | FOLLOW_UP_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 126 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 127 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 128 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 129 | GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers. |
| 130 | GROUP_TYPE_ORIG | Character(1) | VARCHAR2(1) NOT NULL | Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers. |
| 131 | NET_REF_ID | Character(12) | VARCHAR2(12) NOT NULL | A reference identifier associated with a cash transaction subject to netting with a given bank/count |
| 132 | NET_CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Contract ID : To identify unique contract. |
| 133 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 134 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 135 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 136 | DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 137 | PAYMENT_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 138 | PAYMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 139 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 140 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 141 | UPG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Upgrade? |