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 |