GPMX_INFO_NODE(SQL Table) |
Index Back |
---|---|
Information Node CFDIInformation Node CFDI |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | GPMX_ATTRIBUTE_CFD | Character(3) | VARCHAR2(3) NOT NULL |
Setup Attinutes values for CFDI
001=Serial 002=Folio 003=Certificate Number 004=Certificate 005=Stamp |
4 | GPMX_OPT_VALUE_CFD | Character(1) | VARCHAR2(1) NOT NULL |
Option values of attibutes
D=Default Value E=System Elements P=Do not Print S=Sequence Default Value: P |
5 | PIN_SYSTEM_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_SY1_VW |
6 | GPMX_DEFAULT_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Default value |