PO_ACCTDTVL_AET

(SQL Table)
Index Back

Accounting Date Validation AET

Supplier 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