SAC_ERP_AP_STS (SQL Table)	Index Back
PO EIP sts log table

SAC_ERP_AP_STS

(SQL Table)

PO EIP sts log table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 SAC_SYNC_STS Character(1) VARCHAR2(1) NOT NULL Sync Sts flag
C=Change
N=New
U=Update

4 SAC_INTG_PO_STS Character(1) VARCHAR2(1) NOT NULL PO sts
C=Change
E=Error
N=New
P=Published
R=Rejected
S=Synched
U=Update

5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

6 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	SAC_SYNC_STS	Character(1)	VARCHAR2(1) NOT NULL	Sync Sts flag C=Change N=New U=Update
4	SAC_INTG_PO_STS	Character(1)	VARCHAR2(1) NOT NULL	PO sts C=Change E=Error N=New P=Published R=Rejected S=Synched U=Update
5	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
6	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.