ECBUSHDR_IN_VW

index back

EC Bus Doc Data Header Inbound


select distinct ps_ecbusdochdr.ecbusdocid, ecbusdocstatus from ps_ecbusdochdr, ps_ecbusdocln where ps_ecbusdochdr.ecbusdocid = ps_ecbusdocln.ecbusdocid and ps_ecbusdochdr.ectransinoutsw = 'I'

PeopleSoft Field Name Field Type Column Type Description
ECBUSDOCID Number(9,0) DECIMAL(9) NOT NULL EC Business Document ID
ECBUSDOCSTATUS Character(1) VARCHAR2(1) NOT NULL Status
0=Logged
1=Pre-Loaded
2=Error
3=Loaded
4=File Not Found

Default: 0

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19