AR_FG_PROC_AET(SQL Table) |
Index Back |
|---|---|
AR-FG process, AR_FG_PROC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DD_ID | Character(15) | VARCHAR2(15) NOT NULL | Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process. |
| 3 | DD_BU | Character(5) | VARCHAR2(5) NOT NULL | Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process. |
| 4 | MICR_ID | Character(30) | VARCHAR2(30) NOT NULL | MICR ID |
| 5 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 6 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 7 | 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 |
| 8 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 9 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 10 | LOOP_COUNT | Number(4,0) | SMALLINT NOT NULL | Number of Program Loops |
| 11 | LAST_LOOP_COUNT | Number(4,0) | SMALLINT NOT NULL | Number of Program Loops |
| 12 | PMT_MAX_MSG_TRANS | Number(8,0) | INTEGER NOT NULL | Import Max Payments per Msg |
| 13 | PAY_RUN_AR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Run Status
1=Exceptions found 2=Nothing to process 3=Process running 6=Rejected 7=Selected/Staged 8=Waiting for Certification C=Completed D=Reset E=Error K=Restarted N=New R=Selected U=Created V=Trial Register Approved X=Printed Y=Confirmed Z=Positive Payment Formatted |
| 14 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 16 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 17 | BATCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 18 | NUM_RECORDS | Number(15,0) | DECIMAL(15) NOT NULL | Number of Records |
| 19 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 20 | STD_ID_NUM | Character(35) | VARCHAR2(35) NOT NULL | ID Number |
| 21 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 22 | PMT_MANDATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Mandate direct debit |
| 23 | PMT_PAYMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Mandate direct debit
O=One-Off Payment R=Recurrence Payment |
| 24 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 25 | 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. |
| 26 | CUSTOMER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 27 | ORG_PMT_ID | Character(15) | VARCHAR2(15) NOT NULL | Original Transaction / Payment ID - used for reversal process. |
| 28 | PARTY_ID | Character(30) | VARCHAR2(30) NOT NULL | Payee ID |
| 29 | PARTY_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 30 | MANDATE_BU | Character(5) | VARCHAR2(5) NOT NULL | Mandate Business Unit |
| 31 | EFT_LAYOUT_CD | Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |