RUN_CNTL_BOE(SQL Table) |
Index Back |
|---|---|
BOE worksheet run control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPR_DEF_TBL_PM |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 4 | BOE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bill Of Entry Type
1=Home Consumption 2=Warehousing 3=Ex-Bond |
| 5 | BILL_OF_ENTRY | Character(10) | VARCHAR2(10) NOT NULL |
Bill of Entry ID
Prompt Table: BOE_WS_BOE_VW |
| 6 | BILL_OF_ENTRY_TO | Character(10) | VARCHAR2(10) NOT NULL |
Bill of Entry
Prompt Table: BOE_WS_BOE_VW |
| 7 | BOE_DATE | Date(10) | DATE | Bill of Entry Date |
| 8 | BOE_DATE_TO | Date(10) | DATE | Bill of Entry Date |
| 9 | BOE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Bill of Entry Status
A=Assessed C=Closed H=Hold O=Open R=Ready |
| 10 | RPT_REQ_PARAM | Character(1) | VARCHAR2(1) NOT NULL | Date Initial Issue # Description 12/07/00 JJM R-JMESER-JM6J2 Added new label ID TS4 |