MIN_BARCD_RULE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | BARCD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Barcode Type
GS1=GS1 HIBC=HIBC |
| 3 | BARCD_AI_FLG |
Character(5) | VARCHAR2(5) NOT NULL | Application Identifier |
| 4 | BARCD_QTY_FMT_CHAR |
Character(1) | VARCHAR2(1) NOT NULL | Qty Format |
| 5 | BARCD_QTY_VAL_LEN |
Number(1,0) | SMALLINT NOT NULL | Qty Length |
| 6 | BARCD_DATE_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Date Flag |
| 7 | BARCD_DATE_FMT |
Character(12) | VARCHAR2(12) NOT NULL | Date Format |
| 8 | BARCD_DATE_USG_TPE | Character(1) | VARCHAR2(1) NOT NULL |
Date Usage
E=Expire Date M=Manufacturer Date |
| 9 | BARCD_DATA_USG_TPE |
Character(3) | VARCHAR2(3) NOT NULL |
Data Usage
LOT=Lot Id S/N=Serial Id |
| 10 | BARCD_AI_VLE_LN_TP | Character(1) | VARCHAR2(1) NOT NULL |
Identifier Value Length Type
F=Fixed V=Variable |
| 11 | BARCD_AI_VLE_LEN | Number(4,0) | SMALLINT NOT NULL | Identifier Value Length |
| 12 | BARCD_LINK_CHAR | Character(1) | VARCHAR2(1) NOT NULL | Link Char |
| 13 | BARCD_MOD_CHAR | Character(1) | VARCHAR2(1) NOT NULL | Mod Check Char |
| 14 | BARCD_CUST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Define this rule weather predefine or customize, use Y or N.
Y/N Table Edit Default Value: Y |
| 15 | BARCD_TYPE_SEC_IDF | Character(1) | VARCHAR2(1) NOT NULL | Definition for check data type, primary data or secondary data, use P or S |
| 16 | BARCD_REG_EXP | Long Character(500) | VARCHAR2(500) | Barcode Regluar Expressions |
| 17 | PRIORITY_LVL | Number(1,0) | SMALLINT NOT NULL | Priority |
| 18 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 19 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |