SCR_VND_PAY_HST(SQL Table) |
Index Back |
|---|---|
SCR Supplier Paymnt AdjustmentSCR Location Payment Adjustment History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCR_ID |
Character(15) | VARCHAR2(15) NOT NULL | Supplier Change Request ID |
| 2 | SCR_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Update Sequence Number |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | SCR_EFFDT | Date(10) | DATE | Approved Changes Take Effect |
| 8 | SCR_CHG_EFF_WHEN | Character(1) | VARCHAR2(1) NOT NULL |
Change Effective
I=Approval Date S=Future Date |
| 9 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 10 | 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 |
| 11 | EMAIL_ADVICE | Character(1) | VARCHAR2(1) NOT NULL |
Email Payment Advice
N=No Y=Yes Y/N Table Edit |
| 12 | REMIT_ADVISE_OPT | Character(1) | VARCHAR2(1) NOT NULL | Flag to be used for sending remittance advise through FG |
| 13 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 14 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 15 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Datetime |