|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| REP_AUTO_GEN_ERRLOG_REFDOCOU | udd_ctxt_ouinstance | int(4) | Yes | Reference document OU | No |
| REP_AUTO_GEN_ERRLOG_REFDOCTYPE | udd_designparamcode | varchar(5) | Yes | Reference document type | No |
| REP_AUTO_GEN_ERRLOG_REFDOCNO | udd_documentno | varchar(40) | Yes | Reference document number | No |
| REP_AUTO_GEN_ERRLOG_PARTNO | udd_partno | varchar(40) | Yes | Part number | No |
| REP_AUTO_GEN_ERRLOG_MFRSRLNO | udd_partserialnumber | varchar(40) | Yes | mfr serial number | No |
| REP_AUTO_GEN_ERRLOG_INTSRLNO | udd_partserialnumber | varchar(40) | Yes | Initial serial number | No |
| REP_AUTO_GEN_ERRLOG_MFGLOTNO | udd_lotno | varchar(18) | Yes | Mfg lot number | No |
| REP_AUTO_GEN_ERRLOG_INTLOTNO | udd_lotno | varchar(18) | Yes | Initail lot number | No |
| REP_AUTO_GEN_ERRLOG_WAREHOUSE | udd_warehouse | varchar(10) | Yes | Warehouse | No |
| REP_AUTO_GEN_ERRLOG_DATE | udd_time | datetime(8) | Yes | Date | No |
| REP_AUTO_GEN_ERRLOG_ERRMSG | fin_efttext | nvarchar(3072) | Yes | Error message | No |
| REP_AUTO_GEN_ERRLOG_ERRSP | udd_txt255 | varchar(255) | Yes | Error slip | No |
| REPLICATION_KEY | udd_bigint | bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | rep_cst_process |
| Comment : | To store customer statement details for reporting purposes. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| document_grp_ou | fin_ouinstid | int(4) | Yes | Document group OU | No |
| document_grp_no | fin_documentnumber | varchar(18) | Yes | Document group number | No |
| document_grp_type | fin_cmntrantype | varchar(10) | Yes | Document group type | No |
| document_key | fin_desc40 | varchar(40) | Yes | Document key | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| COMPONENTNAME | udd_txt80 | varchar(80) | Yes | Component name | No |
| PARAMCATEGORY | udd_flag | varchar(25) | Yes | Parameter category | No |
| PARAMTYPE | udd_flag | varchar(25) | Yes | Parameter type | No |
| PARAMCODE | udd_flag | varchar(25) | Yes | Parameter code | No |
| PARAMDESC | udd_txt80 | varchar(80) | Yes | Parameter description | No |
| LANGID | udd_languageid | int(4) | Yes | Language id | No |
| CREATIONDATE | udd_datetime | varchar(30) | Yes | Creation Date | No |
| SORTBY | udd_int | int(4) | Yes | Sort by | No |
| REPLICATION_KEY | udd_bigint | bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| component_id | fin_componentshortid | varchar(20) | Yes | Component ID | No |
| parameter_type | fin_param_type | varchar(6) | Yes | Parameter type | No |
| parameter_category | fin_param_categ | varchar(16) | Yes | Parameter catogory | No |
| parameter_code | fin_param_code | varchar(6) | Yes | Parameter code | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| parameter_text | fin_param_text | varchar(255) | Yes | Parameter text | No |
| language_id | fin_lang_id | int(4) | Yes | Language id | No |
| extension_flag | fin_eflag | varchar(1) | Yes | Extension flag | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| createddate | fin_datetime | datetime(8) | Yes | Created date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | fin_datetime | datetime(8) | Yes | Modified date | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | rep_sst_process |
| Comment : | To store supplier statement details for reporting purposes. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| document_grp_ou | fin_ouinstid | int(4) | Yes | Document group OU | No |
| document_grp_no | fin_documentnumber | varchar(18) | Yes | Document group number | No |
| document_grp_type | fin_cmntrantype | varchar(10) | Yes | Document group type | No |
| document_key | fin_desc40 | varchar(40) | Yes | Document key | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes |