BUSINESS_UNITDFT_SIGHT_CDEFFDTD=Draft Issue Date
I=Invoice Date
APB_DFSGHTCD_VW(SQL View) |
Index Back |
|---|---|
APBU Draft Sight Cd Eff View |
| SELECT A.BUSINESS_UNIT , B.DFT_SIGHT_CD , B.EFFDT , B.BASIS_DATE_CD , B.NMBR_DAY , B.NMBR_MTH FROM PS_BUS_UNIT_TBL_AP A , PS_APD_SIGHTCD_TBL B WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'FS_55' AND I.RECNAME = 'APD_SIGHTCD_TBL') AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DFT_SIGHT_CD |
Character(5) | VARCHAR2(5) NOT NULL | Draft Sight Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | BASIS_DATE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Basis Date Code
D=Draft Issue Date I=Invoice Date |
| 5 | NMBR_DAY | Number(3,0) | SMALLINT NOT NULL | Number of Days |
| 6 | NMBR_MTH | Number(2,0) | SMALLINT NOT NULL | Number of Months |