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 NameField TypeColumn TypeDescription
ECBUSDOCIDNumber(9,0)DECIMAL(9) NOT NULLEC Business Document ID
ECBUSDOCSTATUSCharacter(1)VARCHAR2(1) NOT NULLStatus
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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19