MIN_BARCD_AI(SQL Table) |
Index Back |
|---|---|
Barcode Application IdentifierFor GS1 support |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | BARCD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Barcode Type
GS1=GS1 HIBC=HIBC Default Value: MIN_BARCD_SYM.BARCD_TYPE Prompt Table:
MIN_BARCD_SYM
|
| 3 | BARCD_AI |
Character(4) | VARCHAR2(4) NOT NULL | Application Identifier |
| 4 | BARCD_AI_PREFIX | Character(2) | VARCHAR2(2) NOT NULL | Identifier Prefix |
| 5 | BARCD_AI_LEN | Number(4,0) | SMALLINT NOT NULL | Identifier Lengh |
| 6 | BARCD_AI_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifier Type
A=Alpha N=Numeric Default Value: A |
| 7 | BARCD_AI_VLE_TP | Character(1) | VARCHAR2(1) NOT NULL |
Identifier Value Type
A=Alpha N=Numeric Default Value: N |
| 8 | BARCD_AI_VLE_LEN | Number(4,0) | SMALLINT NOT NULL | Identifier Value Length |
| 9 | BARCD_AI_MUL | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Data Fields In AI
Default Value: N |
| 10 | BARCD_AI_VLE_LN_TP | Character(1) | VARCHAR2(1) NOT NULL |
Identifier Value Length Type
F=Fixed V=Variable Default Value: F |
| 11 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELD |
| 13 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |