SAC_PMT_EXT

(SQL Table)
Index Back

External Payment Information

External Payment Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
2 PYMNT_REF_ID Character(20) VARCHAR2(20) NOT NULL Payment ID
3 PAYMENT_DT Date(10) DATE Payment Date
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account