PYFRCST_RUN_AP(SQL Table) |
Index Back |
---|---|
Forcasting Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | BANK_SETID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bank Setid
Y/N Table Edit Default Value: N |
4 | BUS_UNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
Y/N Table Edit Default Value: N |
5 | PAY_METHOD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
Y/N Table Edit Default Value: N |
6 | BANK_CD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bank Code
Y/N Table Edit Default Value: N |
7 | BANK_ACCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bank Account
Y/N Table Edit Default Value: N |
8 | VENDOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Supplier
Y/N Table Edit Default Value: N |
9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
10 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETBNK_NONVW |
11 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW2 |
12 | 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
Prompt Table: BANK_ACCT_VW |
13 | 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 |
14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW11 |
15 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETVND_NONVW |
16 | PYFRCST_CYCLE_ID | Character(5) | VARCHAR2(5) NOT NULL |
Payment Forecast Cycle ID
Prompt Table: PYFRCST_CYCLE |