PROCESS_INSTANCEBUSINESS_UNITLEAD_DAYSPROC_DATEM=Check Mtls Mgmt Exceptions
R=Check Receiving Exceptions
S=Check Shipping Exceptions
A=Push Ahead
S=Push Back
FS_FSPZBCAL_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEAD_DAYS |
Number(4,0) | SMALLINT NOT NULL | Lead Days for Calendar |
| 4 | PROC_DATE |
Date(10) | DATE | Processing Date |
| 5 | PROC_TYPE_CAL | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
M=Check Mtls Mgmt Exceptions R=Check Receiving Exceptions S=Check Shipping Exceptions |
| 6 | DATE_CALC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Date Calculation Option
A=Push Ahead S=Push Back |
| 7 | EVENT_DT | Date(10) | DATE | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |