SSF_VCHPYMT_STG(SQL Table) |
Index Back |
---|---|
Voucher Staging Misc ChargesVoucher Payment Staging table.This is used for processing Single Payment Voucher data for integration with AP. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Character(25) | VARCHAR2(25) NOT NULL | Voucher Build Key Char 1 | |
4 | Character(25) | VARCHAR2(25) NOT NULL | Voucher Build Key Char 1 | |
5 | Number(10,0) | DECIMAL(10) NOT NULL | Voucher Build Key Num 1 | |
6 | Number(10,0) | DECIMAL(10) NOT NULL | Vchr Build Key Num 2 | |
7 | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID | |
8 | Number(5,0) | INTEGER NOT NULL | Payments | |
9 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
10 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | Bank account. |
11 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Type or Method of payment. Indicator as to how the payment should be handled
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Customer Initiated Draft CHK=System Check DD=Direct Debit DFT=Vendor Initiated Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire Flat File WIR=Wire Report |
12 | PYMNT_MESSAGE | Character(70) | VARCHAR2(70) NOT NULL | Payment Message |
13 | PYMNT_VCHR_PCT | Signed Number(33,15) | DECIMAL(31,15) NOT NULL | Used to hold the percentage of a closed voucher. |
14 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL |
Payment handling code.
HD=High Dollar Payment IN=Internal Distribution PO=Route to Purchasing RE=Regular Payments |
15 | PYMNT_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Payment on hold.
Default Value: N |
16 | PYMNT_HOLD_REASON | Character(3) | VARCHAR2(3) NOT NULL | Hold Reason |
17 | MESSAGE_CD | Character(6) | VARCHAR2(6) NOT NULL | Message Code |
18 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
19 | PYMNT_SEPARATE | Character(1) | VARCHAR2(1) NOT NULL | Separate Payment |
20 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
21 | PYMNT_ACTION | Character(1) | VARCHAR2(1) NOT NULL | Payment Action |
22 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
23 | PYMNT_GROUP_CD | Character(2) | VARCHAR2(2) NOT NULL | Paygroup code. |
24 | EFT_LAYOUT_CD | Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |