VCHR_AIA_AET (SQL Table)	Index Back
Vchr AIA Guid Temp Table Guid Look up temp table

VCHR_AIA_AET

(SQL Table)

Vchr AIA Guid Temp Table

Guid Look up temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 AP_VCHR_AIA_GUID Character(36) VARCHAR2(36) NOT NULL Voucher GUID from AIA

3 AP_VNDR_PSFT_GUID Character(36) VARCHAR2(36) NOT NULL Vendor GUID from AIA

4 AP_VNLC_PSFT_GUID Character(36) VARCHAR2(36) NOT NULL Vendor Location GUID from AIA

5 AP_PYTR_PSFT_GUID Character(36) VARCHAR2(36) NOT NULL GUID Common Identifier for Payment Terms

6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AP_VCHR_AIA_GUID	Character(36)	VARCHAR2(36) NOT NULL	Voucher GUID from AIA
3	AP_VNDR_PSFT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Vendor GUID from AIA
4	AP_VNLC_PSFT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Vendor Location GUID from AIA
5	AP_PYTR_PSFT_GUID	Character(36)	VARCHAR2(36) NOT NULL	GUID Common Identifier for Payment Terms
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
8	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
9	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.