BUSINESS_UNITVCHR_BLD_CODEB=Receiver/Purchase Order
D=Default
P=Purchase Order Only
R=Receiver Only
VCHR_BLD_CD_VW2(SQL View) |
Index Back |
|---|---|
Voucher Build Code |
| SELECT DISTINCT B.BUSINESS_UNIT , F.VCHR_BLD_CODE , F.DESCR , F.VCHR_BLD_TYPE FROM PS_BUS_UNIT_TBL_AP B , PS_SET_CNTRL_REC D , PS_VCHR_BLD_CODE F WHERE D.SETCNTRLVALUE = B.BUSINESS_UNIT AND D.RECNAME = 'VCHR_BLD_DEFN' AND F.SETID = D.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VCHR_BLD_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Voucher Build Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | VCHR_BLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Build Type
B=Receiver/Purchase Order D=Default P=Purchase Order Only R=Receiver Only |