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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20