STMT_EXTRCT_LN(SQL Table) |
Index Back |
|---|---|
Extract Statement Line TableExtract Statement Line Table 2021-03 - Payment Plan feature added new fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CRSPD_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CRSPD_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 4 | ST_ID_NUM |
Number(8,0) | INTEGER NOT NULL | Statement Number |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | 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. |
| 7 | 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. |
| 8 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 9 | ITEM_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 10 | DRAFT_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
Draft Flag
Default Value: N |
| 11 | BAL_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 12 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 13 | ST_DT | Date(10) | DATE | Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR. |
| 14 | ST_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Statement Type
B=Bal Fwd O=Open Item |
| 15 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 16 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 17 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 18 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 19 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 20 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 21 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 22 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 23 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 24 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 25 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 26 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 27 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 28 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 29 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 30 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 31 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 32 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 33 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
| 34 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 35 | CLCT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Collector Name |
| 36 | REMIT_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address1 |
| 37 | REMIT_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address2 |
| 38 | REMIT_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address3 |
| 39 | REMIT_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Remit Address4 |
| 40 | REMIT_CITY | Character(30) | VARCHAR2(30) NOT NULL | Remit City |
| 41 | REMIT_NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Remit Num1 |
| 42 | REMIT_NUM2 | Character(4) | VARCHAR2(4) NOT NULL | Remit number 2 |
| 43 | REMIT_HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Remit House Type |
| 44 | REMIT_IN_CITY_LMT | Character(1) | VARCHAR2(1) NOT NULL | Remit In City Limit |
| 45 | REMIT_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | Remit County |
| 46 | REMIT_STATE | Character(6) | VARCHAR2(6) NOT NULL | Remit State |
| 47 | REMIT_GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Remit Tax Supplier Geo Code |
| 48 | REMIT_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Remit Postal Code |
| 49 | REMIT_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Remit Country |
| 50 | REMIT_ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 51 | REMIT_ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 52 | REMIT_ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 53 | REMIT_COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Remit Country |
| 54 | REMIT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Remit Phone Number |
| 55 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 56 | 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. |
| 57 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 58 | DAYS_LATE | Signed Number(7,0) | DECIMAL(6) NOT NULL | Days Late |
| 59 | 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. |
| 60 | DISC_AMT1 | 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_DT1. This is the second of two possible discounts associated with an item. |
| 61 | DISC_DT | Date(10) | DATE | Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the first of two possible discounts and is associated with the discount amount specified in DISC_AMT. |
| 62 | DISC_DT1 | Date(10) | DATE | Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the second of two possible discounts and is associated with the discount amount specified in DISC_AMT1. |
| 63 | 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. |
| 64 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 65 | DESCRSHORT2 | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 66 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 67 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 68 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 69 | BALFWD_STMT_DUE_DT | Date(10) | DATE | Balance Forward Due Date |
| 70 | ACT_ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Item Activity Entry Type |
| 71 | 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. |
| 72 | 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. |
| 73 | 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. |
| 74 | UPDATE_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Don't Post Duplicate Entries |
| 75 | PRINT_COMP | Character(1) | VARCHAR2(1) NOT NULL | Print Completed |
| 76 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 77 | DRAFT_DOC_REF | Character(20) | VARCHAR2(20) NOT NULL | Draft Reference |
| 78 | CREATE_DATE | Date(10) | DATE | Creation Date |
| 79 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 80 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 81 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 82 | DELIVERY_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Method
E=Email F=Fax P=Print |
| 83 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 84 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 85 | PRINTER | Character(20) | VARCHAR2(20) NOT NULL | Printer Specification |
| 86 | 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. |
| 87 | AG_PRINT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Acceptgiro Print Flag - Yes/No |
| 88 | AG_REF_NBR | Number(16,0) | DECIMAL(16) NOT NULL | Payment Reference Number |
| 89 | AG_REF_CHR | Character(16) | VARCHAR2(16) NOT NULL | Payment Reference Number |
| 90 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 91 | BANK_ACCOUNT_NUM1 | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given internal partner bank/counterparty acco |
| 92 | 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) |
| 93 | 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) |
| 94 | 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) |
| 95 | 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) |
| 96 | 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) |
| 97 | 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) |
| 98 | 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) |
| 99 | 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) |
| 100 | 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). |
| 101 | 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). |
| 102 | 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). |
| 103 | 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). |
| 104 | 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). |
| 105 | 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). |
| 106 | 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). |
| 107 | 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). |
| 108 | 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). |
| 109 | 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). |
| 110 | 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). |
| 111 | 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). |
| 112 | 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). |
| 113 | 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). |
| 114 | STATEMENT_IMG | Character(1) | VARCHAR2(1) NOT NULL |
Statement Image
0=Not Statement Image 1=Original Statement Image |
| 115 | VIEW_STMT_IMAGE | Character(1) | VARCHAR2(1) NOT NULL | Date Init Issue Description 040209 JJM eBill Stmt Img Added VIEW_STMT_IMAGE field |
| 116 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 117 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |
| 118 | CONSOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Print Consolidated Invoice
N=Turn Off CONSOL INVS Y=Turn On CONSOL INVS |
| 119 | CONSOL_INVOICE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Consolidated Invoice Amount |
| 120 | PAYMENT_PLAN | Character(15) | VARCHAR2(15) NOT NULL | Payment Plan |
| 121 | ITEM_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Item Source ID |
| 122 | ITEM_SOURCE_LINE | Number(6,0) | INTEGER NOT NULL | Item Source Line |