GPMX_NRP_INF_VW(SQL View) |
Index Back |
|---|---|
Information Node CFDIInformation Node CFDI |
| SELECT COMPANY , EFFDT , GPMX_ATTRIBUTE_CFD , GPMX_OPT_VALUE_CFD , PIN_SYSTEM_NUM + 50000000 , GPMX_DEFAULT_VALUE , GPMX_NODE_LEGAL_CD FROM PS_GPMX_INFO_NODE |
| # | 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 006=Version 007=Voucher Type 008=Payment Method 009=CFDI Use 010=Payment Type |
| 4 | GPMX_OPT_VALUE_CFD | Character(1) | VARCHAR2(1) NOT NULL |
Option values of attibutes
C=Catalog Value 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(40) | VARCHAR2(40) NOT NULL | Default value |
| 7 | GPMX_NODE_LEGAL_CD | Character(4) | VARCHAR2(4) NOT NULL |
Legal Codes for CFDI nodes
0000=Dummy |