PROCESS_INSTANCEACH=Automated Clearing House
AV=Adjustment Voucher
CHK=Check
CM=Credit Memo
DD=Direct Debit
DR=Draft
EFT=Electronic Funds Transfer
PO_ACCTDTVL_AET(SQL Table) |
Index Back |
|---|---|
Accounting Date Validation AETSupplier Rebate Accounting Date Validation AET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 3 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 4 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 7 | PSFT_PRODUCT | Character(2) | VARCHAR2(2) NOT NULL | PeopleSoft Product |
| 8 | 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 |
| 9 | TRANSACTION_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Transaction Type |
| 10 | FROM_DATE | Date(10) | DATE | From Date |
| 11 | TO_DATE | Date(10) | DATE | To Date |