PROCESS_INSTANCESETIDCLAIM_IDACH=Automated Clearing House
AV=Adjustment Voucher
CHK=Check
CM=Credit Memo
DD=Direct Debit
DR=Draft
EFT=Electronic Funds Transfer
PO_GENCLM_T1(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CLAIM_ID |
Character(15) | VARCHAR2(15) NOT NULL | Claim ID |
| 4 | CLAIM_DT | Date(10) | DATE | Claim Date |
| 5 | CLAIM_DUE_DT | Date(10) | DATE | Claim Due Date |
| 6 | SETTLEMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Vendor Rebate Settlement Method (Payment Method)
ACH=Automated Clearing House AV=Adjustment Voucher CHK=Check CM=Credit Memo DD=Direct Debit DR=Draft EFT=Electronic Funds Transfer |
| 7 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 8 | PYMNT_TERMS_CD2 | Character(5) | VARCHAR2(5) NOT NULL | Settlement Terms Code used in Vendor Rebate Agreement (For AR) |
| 9 | INC_VOUCHER_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Include Vouchered Trans Only |
| 10 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | TOTAL_CLAIM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim Amount |