PO_GENCLM_T5(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 | VRBT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Vendor Rebate ID
Prompt Table: VRBT_HDR |
| 5 | CLAIM_DT | Date(10) | DATE | Claim Date |
| 6 | CLAIM_DUE_DT | Date(10) | DATE | Claim Due Date |
| 7 | 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 |
| 8 | 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. |
| 9 | PYMNT_TERMS_CD2 | Character(5) | VARCHAR2(5) NOT NULL | Settlement Terms Code used in Vendor Rebate Agreement (For AR) |
| 10 | INC_VOUCHER_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Include Vouchered Trans Only |
| 11 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | TOTAL_CLAIM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim Amount |
| 13 | TOT_CLAIM_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim Amount Base |
| 14 | TOT_CLAIM_AMT_ORG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Original Total Claim Amount |
| 15 | TOT_CLAIM_VAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim VAT Amount |
| 16 | TOT_CLAIM_VAT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim VAT Base Amount |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 18 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Prompt Table: CURRENCY_CD_TBL |
| 19 | AMT_CLAIM_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Rebate Amount |
| 20 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 21 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 22 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 23 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1 |