AR_PYMNT_AET(SQL Table) |
Index Back |
|---|---|
State record for payment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DEPOSIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 3 | 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. |
| 4 | 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. |
| 5 | FS_EVENT_LINE_NO |
Number(15,0) | DECIMAL(15) NOT NULL | Event Line Number |
| 6 | 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. |
| 7 | CHECK_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Work field used to store status values |
| 8 | 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. |
| 9 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 10 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 11 | 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 |
| 12 | BANK_ACCT_LED_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
The general ledger account type associated with a given bank/counterparty account.
12/04/02 VL Added Translate Dit - AR for JFMIP RM1.1
A=Cash - AR B=Bank Charge C=Cash - AP D=Draft - AP F=Fees G=Control H=Cash I=Interest L=Cntrl - AP P=Dep - AR R=Cntrl - AR S=Draft - AR T=Disc - AR U=AROffSetDr V=AROffSetCr W=Dit - AR |
| 13 | SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | SQL Text |