I am brand new to Data Stage and I am trying read an EBCDIC file using complex flat file I am getting this error
Complex_Flat_File_375: At field "URF_CYL_TAX_DTAILS": At field "URF_CYL_TAX_DTAILS.URF_CYL_OTH_TAX_USA": Unrecognized type-specific format properties: {0, 0, 0} I was getting an error where it ask for a default value I added them and now I am stuck on this one. I also get this error
Complex_Flat_File_375_psubrec1: Error when checking operator: The supplied fieldname, URF_GCS_FACILITY_KEY, does not exist. On all the following fields... It list all on the input fields.
Complex Flat Files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 57
- Joined: Fri Feb 24, 2006 7:44 am
If you are from Mainframes take the cobol copy book (i mean the metadata) ftp it to your pc and save it with .cfd extension.
Then create a new table definition from cobol definitions and it automatically generates the table definitions for you.
Then do a ftp of your file with binary mode ,just read it with cff stage.
Path: ur file path
Data Format : EBCDIC
Record Style : Binary
and specify the record lentgh
This worked out for me see if this helps you anyway.
Then create a new table definition from cobol definitions and it automatically generates the table definitions for you.
Then do a ftp of your file with binary mode ,just read it with cff stage.
Path: ur file path
Data Format : EBCDIC
Record Style : Binary
and specify the record lentgh
This worked out for me see if this helps you anyway.
I did send the file from the mainframe in the way you said I set it as fixed which it is and still the same problem. I could not find the schema but I found this. I do not know how to attach it so I hope this does not take up to much space Thank you for your help This is very frustrating we are not going to have classes on Datastage until after we go to parallel testing so we are learning as we go.
record
(
URF_GCS_RECORD_TYPE:string[3];
URF_GCS_SYSTEM_ID:string[3] {redefines='URF_GCS_RECORD_TYPE'};
URF_GCS_RECORD_SUB_TYPE:string[3];
URF_GCS_ACCOUNT_NUMBER:string[8];
ORIGINALLY_3_CHAR_FILLER:subrec (
URF_GCS_CYCLE:string[2];
FILLER_2:string[1];
);
URF_GCS_REVENUE_OWNER:string[3];
URF_GCS_REV_OWNER_IND:string[1];
URF_GCS_INVOICE_OWNER:string[3];
URF_GCS_CONTROL_ACCOUNT:string[8];
URF_GCS_PRODUCT_CODE:string[1];
FILLER_3:string[2];
URF_GCS_ACCESS_IND:string[1];
URF_GCS_IFD:string[1];
URF_GCS_ACCOUNT_NAME:string[30];
URF_GCS_BILLING_ADDR_LINE_1:string[30];
URF_GCS_BILLING_ADDR_LINE_2:string[30];
URF_GCS_BILLING_CITY:string[28];
URF_GCS_BILLING_STATE:string[2];
URF_GCS_BILLING_ZIP_CODE:string[9];
URF_GCS_BILLING_CONTACT_NAME:string[30];
URF_GCS_BILLING_CONTACT_PHONE:string[15];
URF_GCS_BILLTYPE_FLAG:string[1];
URF_GCS_PREFIX_FLAG:string[1];
URF_GCS_COUNTRY_CODE:string[4];
URF_GCS_INVOICE_NUMBER:string[10];
URF_GCS_MKTS_SALES_SSN:string[9];
URF_GCS_MCII_SALES_CODE:string[4];
URF_GCS_DIVISION:string[2];
URF_GCS_DESCRIPTION:string[30];
URF_GCS_CURRENCY_DESC:string[28];
URF_GCS_TELCO_DESC:string[35];
FILLER_4:string[1];
URF_GCS_CATEGORY_CODE:string[16];
URF_GCS_SERVICE_CLASS_DESC:string[35];
URF_GCS_SERVICE_TYPE_DESC:string[35];
URF_GCS_SERVICE_TERM1:string[60];
URF_GCS_SERVICE_TERM2:string[60];
URF_GCS_SERVICE_TERM3:string[60];
URF_GCS_MKTS_CITY_CODE:string[4];
URF_GCS_ACQUISITION_SEGMENT:string[1];
URF_GCS_REVENUE_SEGMENT:string[1];
URF_GCS_NASP_ID:string[10];
URF_GCS_CUSTOMER_SEGMENT:string[1];
URF_GCS_DEPT_DESCRIPTION:string[35];
FILLER_5:string[3];
URF_GCS_AMT_USA:decimal[11,2] {zoned};
URF_GCS_REDUCTION_AMT_USA:decimal[7,2] {zoned};
URF_GCS_REDUCTION_IND:string[1];
URF_GCS_MTR_LOCAL_LD_IND:string[1];
URF_GCS_ORIG_TERM_IND:string[1];
FILLER_6:string[8];
URF_STN_INFO:subrec (
URF_GCS_CORP_ID:string[8];
URF_STN_CORP_ID:string[8] {redefines='URF_GCS_CORP_ID'};
URF_GCS_BILL_DATE:string[8];
)
URF_GCS_INVOICE_DATE:string[8];
URF_GCS_PERIOD_DATE:string[8];
URF_GCS_INCEPTION_DATE:string[8];
URF_GCS_CANCEL_DATE:string[8];
URF_GCS_COUNTRY_NAME:string[35];
URF_GCS_FED_ID:string[10];
URF_GCS_ISD_LABEL:string[50];
URF_GCS_CHRG_INFO:subrec (
URF_GCS_NODE_NUM:string[8];
URF_GCS_TYPE:string[2];
URF_GCS_SUBTYPE:string[4];
URF_GCS_GROUP_SVC_METH:string[3];
)
FILLER_7:string[7];
URF_GCS_CHRG_EFF_DATE:string[8];
URF_GCS_CHRG_END_DATE:string[8];
URF_GCS_FNE_BAN_NO:string[8];
URF_GCS_CONFERENCE_ID:string[9];
FILLER_8:string[21];
URF_GCS_DISCT_PERCENT:decimal[11,2] {zoned};
FILLER_9:string[22];
URF_GCS_AMT_FGN:decimal[11,2] {zoned};
FILLER_10:string[41];
URF_GCS_STATE_ABBREV:string[4];
URF_GCS_GTLINK_II_CODE:string[4];
URF_GCS_GTLINK_II_ORG_GEO_CODE:string[9];
URF_GCS_GTUXCODR_ZIP:string[9];
FILLER_11:string[22];
URF_GCS_INVOICE_TOTAL:decimal[11,2] {zoned};
URF_GCS_TAXES:subrec (
URF_GCS_FEDERAL_TAX:decimal[11,2] {zoned};
URF_GCS_STATE_TAX:decimal[11,2] {zoned};
URF_GCS_ULTS_TAX:decimal[11,2] {zoned};
URF_GCS_DEAF_TAX:decimal[11,2] {zoned};
URF_GCS_911_SURCHARGE:decimal[11,2] {zoned};
URF_GCS_GROSS_RECEIPT_TAX:decimal[11,2] {zoned};
URF_GCS_UTILITY_TAX:decimal[11,2] {zoned};
);
URF_GCS_FEDERAL_RATE:decimal[5,3] {zoned};
URF_GCS_STATE_RATE:decimal[5,3] {zoned};
URF_GCS_ULTS_RATE:decimal[5,3] {zoned};
URF_GCS_DEAF_RATE:decimal[5,3] {zoned};
URF_GCS_911_RATE:decimal[5,3] {zoned};
URF_GCS_GROSS_RECEIPT_RATE:decimal[5,3] {zoned};
URF_GCS_UTILITY_RATE:decimal[5,3] {zoned};
URF_GCS_PRO_FROM_DATE:string[8];
URF_GCS_PRO_TO_DATE:string[8];
URF_GCS_PRORATA_CODE:string[1];
URF_GCS_PAYER_IND:string[1];
URF_GCS_FGN_DECIMAL:string[1];
FILLER_12:string[1];
URF_GCS_SVCREF_NUMBER:subrec (
URF_GCS_SVCREF_CODE:string[4];
URF_GCS_SVCREF_NO:string[16];
);
URF_GCS_CURRENCY_CODE:string[5];
URF_GCS_DEPT_CODE:string[4];
URF_GCS_CHARGE_KEY:string[25];
URF_GCS_CIRCUIT_KEY:string[25] {redefines='URF_GCS_CHARGE_KEY'};
URF_GCS_FACILITY_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_FAC_SEQUENCE:subrec (
URF_GCS_FAC_SEQ:string[4];
URF_GCS_SUB_SEQ:string[2];
);
FILLER_13:string[19];
);
URF_GCS_EQUIP_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_EQUIP_NO:string[7];
URF_GCS_EQUIP_SEQ:string[5];
FILLER_14:string[13];
);
URF_GCS_SETL_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_SETL_SVC_MTH:decimal[4,0] {, default=0,zoned};
URF_GCS_SETL_CHARGE_PREFIX:string[1];
URF_GCS_SETL_CURR_CODE:string[5];
URF_GCS_SETL_SEQ_NUM:decimal[5,0] {, default=0,zoned};
FILLER_15:string[10];
);
URF_GCS_CHARGE_SEQ:string[5];
URF_GCS_COMMON_SREF:subrec (
URF_GCS_SREF_INPP_NO:string[5];
URF_GCS_SREF_PLSO:string[8];
URF_GCS_SREF_ORDER_NO:string[20];
URF_GCS_SREF_DEPT:string[20];
URF_GCS_SCAN_NO:string[20];
URF_GCS_SREF_SERV_TYPE:string[4];
URF_GCS_SREF_SERV_CLASS:string[4];
FILLER_16:string[60];
URF_GCS_SREF_ROUND_DIF:decimal[9,2] {zoned};
);
URF_GCS_COMMON_ACCT:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_17:string[141];
URF_GCS_ACCT_ROUND_DIF:decimal[9,2] {zoned};
);
URF_CYL_USAGE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CU_FREEPHONE_ID:string[15];
URF_CYL_CU_ISAC_ZONE:string[1];
URF_CYL_CU_ORIG_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_TERM_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_NUMBER_CALLED_FROM:string[16];
URF_CYL_CU_NUMBER_DIALED:string[16];
URF_CYL_CU_NUMBER_CALLED:string[16];
URF_CYL_CU_ORIG_COUNTRY_CODE:string[3];
URF_CYL_CU_TERM_COUNTRY_CODE:string[3];
URF_CYL_CU_CALL_DATE:string[8];
URF_CYL_CU_GMT_TIME:string[6];
URF_CYL_CU_LOC_TIME:string[6];
URF_CYL_CU_DURATION:decimal[7,1] {default=0.0,packed};
URF_CYL_CU_CALL_TYPE:string[1];
URF_CYL_CU_DATA:string[1];
URF_CYL_CU_NCR:string[1];
URF_CYL_CU_TERM:string[2];
URF_CYL_CU_CONF_ACCESS:string[2];
URF_CYL_CU_CONF_LEADER_ID:string[9];
URF_CYL_CU_ACCOUNTING_CODE:string[8];
URF_CYL_CU_CALLING_STATION:string[15];
URF_CYL_CU_CON_FOR_IND:string[1];
URF_CYL_CU_BAND_NBR:string[2];
URF_CYL_CU_ORIG_SUBZONE:string[2];
URF_CYL_CU_TERM_SUBZONE:string[2];
URF_CYL_CU_ISAC_CARRIER:string[2];
FILLER_18:string[2];
);
URF_CYL_NMT_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_19:string[7];
URF_CYL_NMT_BILL_DATE:string[8];
URF_CYL_NMT_FILLER1:string[20];
URF_CYL_NMT_CHRG_CODE:string[8];
URF_CYL_NMT_FILLER:string[107];
);
URF_CYL_CIRC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CIRC_DATE_INFO:subrec (
URF_CYL_CIRC_INCEPT_DATE:string[8];
URF_CYL_CIRC_EFF_DATE:string[8];
URF_CYL_CIRC_LAST_BILL_DATE:string[8];
URF_CYL_CIRC_CANCELLED_DATE:string[8];
);
URF_CYL_CIRC_PAYER_IND:string[1];
URF_CYL_CIRC_CYCLE:string[1];
URF_CYL_CIRC_CYCLE_MONTH:string[2];
URF_CYL_CIRC_IFD:string[1];
URF_CYL_CIRC_FILLER:string[16];
URF_CYL_CIRC_GL:string[1];
URF_CYL_CIRC_CUST_REF:string[15];
URF_CYL_CIRC_LOCATION:string[15];
URF_CYL_CIRC_STATE_ABBR:string[2];
URF_CYL_CIRC_ZIP:string[9];
URF_CYL_CIRC_GEO_CODE:string[9];
URF_CYL_CIRC_BILLABLE_IND:string[1];
URF_CYL_CIRC_VAT_CODE:string[1];
URF_CYL_CIRC_STRF:string[4];
URF_CYL_CIRC_STFQ:string[1];
FILLER_20:string[39];
);
URF_CYL_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_SPEC_DATE_INFO:subrec (
URF_CYL_SPEC_INCEPT_DATE:string[8];
URF_CYL_SPEC_EFF_DATE:string[8];
URF_CYL_SPEC_LAST_BILL_DATE:string[8];
URF_CYL_SPEC_CANCELLED_DATE:string[8];
);
URF_CYL_SPEC_PAYER_IND:string[1];
URF_CYL_SPEC_CYCLE:string[1];
URF_CYL_SPEC_CYCLE_MONTH:string[2];
URF_CYL_SPEC_IFD:string[1];
URF_CYL_SPEC_FILLER:string[16];
URF_CYL_SPEC_GL:string[1];
URF_CYL_SPEC_CUST_REF:string[15];
URF_CYL_SPEC_LOCATION:string[15];
URF_CYL_SPEC_STATE_ABBR:string[2];
URF_CYL_SPEC_ZIP:string[9];
URF_CYL_SPEC_GEO_CODE:string[9];
URF_CYL_SPEC_BILLABLE_IND:string[1];
URF_CYL_SPEC_PREFIX:string[1];
URF_CYL_SPEC_VAT_CODE:string[1];
URF_CYL_SPEC_STRF:string[4];
URF_CYL_SPEC_STFQ:string[1];
FILLER_21:string[38];
);
URF_CYL_TAX_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_FED_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_ST_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CITY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_OTH_TAX_USA:decimal[11,2] {default=0.00, , 0, 00, 0, ,packed};
URF_CYL_FED_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_ST_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CITY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_OTH_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_VAT_USA:decimal[11,2] {default=0.00,packed};
FILLER_22:string[79];
);
URF_GCS_COMMON_FAC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_FAC_TARIFF:subrec (
URF_GCS_FAC_SRV_TYPE:string[4];
URF_GCS_FAC_RATE_CODE:string[4];
URF_GCS_FAC_ORIG_CTRY:string[4];
URF_GCS_FAC_ORIG_CITY:string[4];
URF_GCS_FACC_DEST_CTRY:string[4];
URF_GCS_FAC_DEST_CITY:string[4];
);
URF_GCS_FAC_SALES_ID:string[9];
URF_GCS_FAC_SALES_CITY:string[6];
URF_GCS_FAC_CCITT_NO:string[25];
URF_GCS_FAC_INET_ACCESS_AMTS:subrec (
URF_GCS_FAC_INET_AMT1_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT1_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT2_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT2_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT3_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT3_FGN:decimal[12,2] {zoned};
);
FILLER_23:string[23];
);
URF_GCS_COMMON_CIRC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CIRC_GROUP:subrec (
URF_GCS_CIRC_TYPE:string[1];
URF_GCS_CIRC_TELCO:string[3];
URF_GCS_CIRC_COST:string[4];
URF_GCS_CIRC_TARF_CODE:string[2];
);
URF_GCS_CIRC_COND:string[6];
URF_GCS_CIRC_CHAN_DESIGN:string[14];
FILLER_24:string[120];
);
URF_GCS_COMMON_EQUIP:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_EQUIP_QTY:decimal[4,0] {zoned};
FILLER_25:string[146];
);
URF_GCS_COMMON_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_PRO_PREFIX:string[1];
URF_GCS_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
FILLER_26:string[113];
);
URF_GCS_COMMON_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPEC_PREFIX:string[1];
FILLER_27:string[149];
);
URF_GCS_COMMON_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPTX_PREFIX:string[1];
URF_GCS_SPTX_VAT:decimal[6,4] {zoned};
URF_GCS_SPTX_TAX_TYPE:string[1];
FILLER_28:string[142];
);
URF_GCS_COMMON_CDR:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CDR_LOC:string[3];
URF_GCS_CDR_BRACKET:string[2];
URF_GCS_CDR_CALLS:decimal[11,0] {zoned};
URF_GCS_CDR_MINUTES:decimal[11,1] {zoned};
URF_GCS_CDR_RATE:decimal[10,6] {zoned};
FILLER_29:string[8];
FILLER_30:string[105];
);
URF_GCS_COMMEB_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_31:string[1];
URF_MEB_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPEC_RATE:decimal[11,5] {zoned};
URF_MEB_SPEC_UNIT_MEAS:string[2];
FILLER_32:string[123];
);
URF_GCS_COMMEB_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_33:string[1];
URF_MEB_SPTX_VAT:decimal[6,4] {zoned};
URF_MEB_SPTX_TAX_TYPE:string[1];
URF_MEB_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPTX_RATE:decimal[11,5] {zoned};
URF_MEB_SPTX_UNIT_MEAS:string[2];
FILLER_34:string[116];
);
URF_GCS_COMMEB_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_35:string[1];
URF_MEB_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_QUANTITY:decimal[13,3] {zoned};
URF_MEB_PRO_RATE:decimal[11,5] {zoned};
URF_MEB_PRO_UNIT_MEAS:string[2];
URF_MEB_PRO_USAGE_PROD:string[8];
FILLER_36:string[79];
);
URF_GCS_COMMEB_BAT_DTL:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_DTL_INV_CATG_CODE:string[2];
URF_MEB_DTL_PROD_SHORT_NAME:string[15];
URF_MEB_DTL_QUANTITY:decimal[13,3] {zoned};
URF_MEB_DTL_RATE:decimal[11,5] {zoned};
URF_MEB_DTL_UNIT_MEAS:string[2];
URF_MEB_DTL_FOOT_NOTE:string[1];
FILLER_37:string[106];
);
URF_GCS_COMMEB_BAT_TAX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_TAX_FROM_LOC:string[20];
URF_MEB_TAX_TAXABLE_AMT:decimal[11,2] {zoned};
URF_MEB_TAX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_TAX_AMOUNT[5]:decimal[11,2] {zoned};
FILLER_38:string[51];
);
URF_GCS_SETL_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SETL_PART_KEY:subrec (
URF_GCS_SETL_SVC_MTH_2:decimal[4,0] {zoned};
URF_GCS_SETL_CHARGE_PREFIX_2:string[1];
URF_GCS_SETL_CURR_CODE_2:string[5];
URF_GCS_SETL_SEQ_NUM_2:decimal[5,0] {zoned};
);
URF_GCS_SETL_GAIN_LOSS:decimal[9,2] {zoned};
URF_GCS_ORIG_TYPE:string[2];
URF_GCS_ORIG_SUBTYPE:string[4];
URF_GCS_ORIG_CHARGE_KEY:subrec (
URF_GCS_ORIG_TAX_TYPE:string[2];
URF_GCS_ORIG_CURR_KEY:string[5];
URF_GCS_ORIG_SECONDARY:subrec (
URF_GCS_ORIG_CDR_RATE:decimal[13,6] {zoned};
FILLER_39:string[5];
);
);
URF_GCS_ORIG_CHARGE_SEQ_NO:string[5];
URF_GCS_SETL_CHRG_MONTH:string[4];
URF_GCS_SETL_ORIG_BIL_DATE:string[8];
URF_GCS_ORIG_AMT_USA:decimal[9,2] {zoned};
URF_GCS_ORIG_AMT_FGN:decimal[13,2] {zoned};
URF_GCS_ORIG_RATE:decimal[14,8] {zoned};
URF_GCS_SETL_RATE:decimal[14,8] {zoned};
FILLER_40:string[28];
);
URF_STN_USAGE_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_CALL_NUMBER:string[15];
URF_STN_ACCOUNT_CODE:string[8];
URF_STN_CALL_DATE:subrec (
URF_STN_CALL_CENTURY:string[2];
URF_STN_CALL_YYMMDD:string[6];
);
URF_STN_LOCAL_CONNECT_TIME:subrec (
URF_STN_CONNECT_HOUR:string[2];
URF_STN_CONNECT_MIN:string[2];
URF_STN_CONNECT_SECS:string[2];
);
URF_STN_CALL_TYPE:string[1];
URF_STN_AMT_FGN_PRE_DISC:decimal[13,2] {zoned};
URF_STN_DISC_AMT:decimal[9,2] {zoned};
URF_STN_DURATION_TIME:subrec (
URF_STN_DURATION_HR:decimal[2,0] {zoned};
URF_STN_DURATION_MIN:decimal[2,0] {zoned};
URF_STN_DURATION_SECS:decimal[2,0] {zoned};
URF_STN_DURATION_TENTHS:decimal[1,0] {zoned};
);
URF_STN_FROM_LOCATION:subrec (
URF_STN_FROM_CITY_NAME:string[10];
URF_STN_FROM_STATE_CODE:string[2];
);
URF_STN_TERM_LOCATION:subrec (
URF_STN_TERM_CITY_NAME:string[10];
URF_STN_TERM_STATE_CODE:string[2];
);
URF_STN_NUMBER_DIALED:string[15];
URF_STN_TO_CNTRY:string[6];
URF_STN_PROVINCE:string[2];
URF_STN_NUMBER_CALLED:string[15];
URF_STN_RATE_PERIOD_IND:string[1];
URF_STN_VCN_CALL_TYPE_IND:string[1];
URF_STN_ORGNG_VCN_POINTIND:string[2];
URF_STN_TERMG_VCN_POINTIND:string[2];
URF_STN_EMR_DTO_IND:string[1];
FILLER_41:string[14];
);
URF_STN_MISC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_MISC_START_DATE:string[8];
URF_STN_MISC_STOP_DATE:string[8];
URF_STN_MISC_QUANTITY:decimal[7,0] {zoned};
URF_STN_MISC_CHRGE_AMT:decimal[15,2] {zoned};
URF_STN_REG_CHRGE_IND:string[1];
URF_STN_CUST_CAMS_ID:decimal[9,0] {zoned};
URF_STN_SUNIT_ID:decimal[5,0] {zoned};
URF_STN_MSC_SETTL_CODE_IND:string[1];
FILLER_42:string[96];
);
URF_STN_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPEC_PSN:string[15];
URF_STN_SPEC_USAGE:string[8];
URF_STN_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPEC_UNIT:string[2];
URF_STN_SPEC_RATE:decimal[11,5] {zoned};
URF_STN_SPEC_FNOTE:string[1];
FILLER_43:string[100];
);
URF_STN_SPTX_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPTX_VAT:decimal[6,4] {zoned};
URF_STN_SPTX_TAX_TYPE:string[1];
URF_STN_SPTX_PSN:string[15];
URF_STN_SPTX_USAGE:string[8];
URF_STN_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPTX_UNIT:string[2];
URF_STN_SPTX_RATE:decimal[11,5] {zoned};
URF_STN_SPTX_FNOTE:string[1];
URF_STN_SPTX_TAX_CODE:string[8];
FILLER_44:string[85];
);
URF_STN_PRO_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_PRO_NEW_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_NEW_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_VAT:decimal[6,4] {zoned};
URF_STN_PRO_PSN:string[15];
URF_STN_PRO_USAGE:string[8];
URF_STN_PRO_QUANTITY:decimal[13,3] {zoned};
URF_STN_PRO_UNIT:string[2];
URF_STN_PRO_RATE:decimal[11,5] {zoned};
URF_STN_PRO_FNOTE:string[1];
FILLER_45:string[50];
);
URF_IFR_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEGA_CHG_CODE:decimal[4,0] {zoned};
URF_IFR_SVC_ID:string[8];
URF_IFR_CHG_BEG_DATE:string[10];
URF_IFR_CHG_END_DATE:string[10];
URF_IFR_PVC_ID:decimal[15,0] {packed};
URF_IFR_ORIG_PVC_COUNTRY:string[3];
URF_IFR_TERM_PVC_COUNTRY:string[3];
URF_IFR_BILLING_PERIOD:string[8];
URF_IFR_ACCESS_CLASS:string[1];
URF_IFR_PARTNER_ID:string[10];
URF_IFR_SERVICE_TYPE:string[4];
URF_IFR_METRO:string[1];
URF_IFR_PIP_COS:string[1];
URF_IFR_PQ_SPEED:decimal[10,1] {packed};
FILLER_46:string[73];
);
URF_FNE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_FNE_CHRG_CODE:string[6];
URF_FNE_CHRG_TYPE:string[1];
URF_FNE_CIRCUIT_TYPE:string[8];
URF_FNE_ADJ_IND:string[1];
URF_FNE_ADJ_DESC:string[14];
URF_FNE_PVC_SPEED:string[7];
URF_FNE_PORT_SPEED:string[8];
URF_FNE_BILL_METHOD:string[1];
URF_FNE_CONT_TERM:string[3];
URF_FNE_CONT_END_DATE:string[8];
URF_FNE_PUR_ORDER_NO:string[25];
URF_FNE_IXC_MILEAGE:string[6];
URF_FNE_SALES_PERSON:string[6];
URF_FNE_LOCA_NPA_NXX:string[6];
URF_FNE_LOCZ_NPA_NXX:string[6];
URF_FNE_LOCA_CITY:string[15];
URF_FNE_LOCA_CNTY_CD:string[3];
URF_FNE_LOCZ_CITY:string[15];
URF_FNE_LOCZ_CNTY_CD:string[3];
URF_FNE_PROMO_CD:string[8];
);
URF_GCS_SALES_REP_DIV_ID:string[2];
URF_GCS_SERVICE_SSN:string[9];
URF_GCS_SERVICE_CITY_CODE:string[4];
URF_GCS_SERVICE_REP_DIV_ID:string[2];
URF_GCS_SALES_CITY_CODE:string[4];
FILLER_47:string[1];
URF_GCS_ACQUISITION_CHANNEL:string[1];
URF_GCS_MEB_ORIG_INVNBR:string[10];
URF_GCS_CAT_CODE:subrec (
URF_GCS_CAT_PRIM:string[4];
URF_GCS_CAT_SUB:string[4];
URF_GCS_CAT_CTRY:string[4];
URF_GCS_CAT_CITY:string[4];
URF_GCS_CAT_DEPT:string[4];
);
FILLER_48:string[1];
URF_GCS_REV_LOCATION:string[3];
FILLER_49:string[51];
)
record
(
URF_GCS_RECORD_TYPE:string[3];
URF_GCS_SYSTEM_ID:string[3] {redefines='URF_GCS_RECORD_TYPE'};
URF_GCS_RECORD_SUB_TYPE:string[3];
URF_GCS_ACCOUNT_NUMBER:string[8];
ORIGINALLY_3_CHAR_FILLER:subrec (
URF_GCS_CYCLE:string[2];
FILLER_2:string[1];
);
URF_GCS_REVENUE_OWNER:string[3];
URF_GCS_REV_OWNER_IND:string[1];
URF_GCS_INVOICE_OWNER:string[3];
URF_GCS_CONTROL_ACCOUNT:string[8];
URF_GCS_PRODUCT_CODE:string[1];
FILLER_3:string[2];
URF_GCS_ACCESS_IND:string[1];
URF_GCS_IFD:string[1];
URF_GCS_ACCOUNT_NAME:string[30];
URF_GCS_BILLING_ADDR_LINE_1:string[30];
URF_GCS_BILLING_ADDR_LINE_2:string[30];
URF_GCS_BILLING_CITY:string[28];
URF_GCS_BILLING_STATE:string[2];
URF_GCS_BILLING_ZIP_CODE:string[9];
URF_GCS_BILLING_CONTACT_NAME:string[30];
URF_GCS_BILLING_CONTACT_PHONE:string[15];
URF_GCS_BILLTYPE_FLAG:string[1];
URF_GCS_PREFIX_FLAG:string[1];
URF_GCS_COUNTRY_CODE:string[4];
URF_GCS_INVOICE_NUMBER:string[10];
URF_GCS_MKTS_SALES_SSN:string[9];
URF_GCS_MCII_SALES_CODE:string[4];
URF_GCS_DIVISION:string[2];
URF_GCS_DESCRIPTION:string[30];
URF_GCS_CURRENCY_DESC:string[28];
URF_GCS_TELCO_DESC:string[35];
FILLER_4:string[1];
URF_GCS_CATEGORY_CODE:string[16];
URF_GCS_SERVICE_CLASS_DESC:string[35];
URF_GCS_SERVICE_TYPE_DESC:string[35];
URF_GCS_SERVICE_TERM1:string[60];
URF_GCS_SERVICE_TERM2:string[60];
URF_GCS_SERVICE_TERM3:string[60];
URF_GCS_MKTS_CITY_CODE:string[4];
URF_GCS_ACQUISITION_SEGMENT:string[1];
URF_GCS_REVENUE_SEGMENT:string[1];
URF_GCS_NASP_ID:string[10];
URF_GCS_CUSTOMER_SEGMENT:string[1];
URF_GCS_DEPT_DESCRIPTION:string[35];
FILLER_5:string[3];
URF_GCS_AMT_USA:decimal[11,2] {zoned};
URF_GCS_REDUCTION_AMT_USA:decimal[7,2] {zoned};
URF_GCS_REDUCTION_IND:string[1];
URF_GCS_MTR_LOCAL_LD_IND:string[1];
URF_GCS_ORIG_TERM_IND:string[1];
FILLER_6:string[8];
URF_STN_INFO:subrec (
URF_GCS_CORP_ID:string[8];
URF_STN_CORP_ID:string[8] {redefines='URF_GCS_CORP_ID'};
URF_GCS_BILL_DATE:string[8];
)
URF_GCS_INVOICE_DATE:string[8];
URF_GCS_PERIOD_DATE:string[8];
URF_GCS_INCEPTION_DATE:string[8];
URF_GCS_CANCEL_DATE:string[8];
URF_GCS_COUNTRY_NAME:string[35];
URF_GCS_FED_ID:string[10];
URF_GCS_ISD_LABEL:string[50];
URF_GCS_CHRG_INFO:subrec (
URF_GCS_NODE_NUM:string[8];
URF_GCS_TYPE:string[2];
URF_GCS_SUBTYPE:string[4];
URF_GCS_GROUP_SVC_METH:string[3];
)
FILLER_7:string[7];
URF_GCS_CHRG_EFF_DATE:string[8];
URF_GCS_CHRG_END_DATE:string[8];
URF_GCS_FNE_BAN_NO:string[8];
URF_GCS_CONFERENCE_ID:string[9];
FILLER_8:string[21];
URF_GCS_DISCT_PERCENT:decimal[11,2] {zoned};
FILLER_9:string[22];
URF_GCS_AMT_FGN:decimal[11,2] {zoned};
FILLER_10:string[41];
URF_GCS_STATE_ABBREV:string[4];
URF_GCS_GTLINK_II_CODE:string[4];
URF_GCS_GTLINK_II_ORG_GEO_CODE:string[9];
URF_GCS_GTUXCODR_ZIP:string[9];
FILLER_11:string[22];
URF_GCS_INVOICE_TOTAL:decimal[11,2] {zoned};
URF_GCS_TAXES:subrec (
URF_GCS_FEDERAL_TAX:decimal[11,2] {zoned};
URF_GCS_STATE_TAX:decimal[11,2] {zoned};
URF_GCS_ULTS_TAX:decimal[11,2] {zoned};
URF_GCS_DEAF_TAX:decimal[11,2] {zoned};
URF_GCS_911_SURCHARGE:decimal[11,2] {zoned};
URF_GCS_GROSS_RECEIPT_TAX:decimal[11,2] {zoned};
URF_GCS_UTILITY_TAX:decimal[11,2] {zoned};
);
URF_GCS_FEDERAL_RATE:decimal[5,3] {zoned};
URF_GCS_STATE_RATE:decimal[5,3] {zoned};
URF_GCS_ULTS_RATE:decimal[5,3] {zoned};
URF_GCS_DEAF_RATE:decimal[5,3] {zoned};
URF_GCS_911_RATE:decimal[5,3] {zoned};
URF_GCS_GROSS_RECEIPT_RATE:decimal[5,3] {zoned};
URF_GCS_UTILITY_RATE:decimal[5,3] {zoned};
URF_GCS_PRO_FROM_DATE:string[8];
URF_GCS_PRO_TO_DATE:string[8];
URF_GCS_PRORATA_CODE:string[1];
URF_GCS_PAYER_IND:string[1];
URF_GCS_FGN_DECIMAL:string[1];
FILLER_12:string[1];
URF_GCS_SVCREF_NUMBER:subrec (
URF_GCS_SVCREF_CODE:string[4];
URF_GCS_SVCREF_NO:string[16];
);
URF_GCS_CURRENCY_CODE:string[5];
URF_GCS_DEPT_CODE:string[4];
URF_GCS_CHARGE_KEY:string[25];
URF_GCS_CIRCUIT_KEY:string[25] {redefines='URF_GCS_CHARGE_KEY'};
URF_GCS_FACILITY_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_FAC_SEQUENCE:subrec (
URF_GCS_FAC_SEQ:string[4];
URF_GCS_SUB_SEQ:string[2];
);
FILLER_13:string[19];
);
URF_GCS_EQUIP_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_EQUIP_NO:string[7];
URF_GCS_EQUIP_SEQ:string[5];
FILLER_14:string[13];
);
URF_GCS_SETL_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_SETL_SVC_MTH:decimal[4,0] {, default=0,zoned};
URF_GCS_SETL_CHARGE_PREFIX:string[1];
URF_GCS_SETL_CURR_CODE:string[5];
URF_GCS_SETL_SEQ_NUM:decimal[5,0] {, default=0,zoned};
FILLER_15:string[10];
);
URF_GCS_CHARGE_SEQ:string[5];
URF_GCS_COMMON_SREF:subrec (
URF_GCS_SREF_INPP_NO:string[5];
URF_GCS_SREF_PLSO:string[8];
URF_GCS_SREF_ORDER_NO:string[20];
URF_GCS_SREF_DEPT:string[20];
URF_GCS_SCAN_NO:string[20];
URF_GCS_SREF_SERV_TYPE:string[4];
URF_GCS_SREF_SERV_CLASS:string[4];
FILLER_16:string[60];
URF_GCS_SREF_ROUND_DIF:decimal[9,2] {zoned};
);
URF_GCS_COMMON_ACCT:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_17:string[141];
URF_GCS_ACCT_ROUND_DIF:decimal[9,2] {zoned};
);
URF_CYL_USAGE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CU_FREEPHONE_ID:string[15];
URF_CYL_CU_ISAC_ZONE:string[1];
URF_CYL_CU_ORIG_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_TERM_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_NUMBER_CALLED_FROM:string[16];
URF_CYL_CU_NUMBER_DIALED:string[16];
URF_CYL_CU_NUMBER_CALLED:string[16];
URF_CYL_CU_ORIG_COUNTRY_CODE:string[3];
URF_CYL_CU_TERM_COUNTRY_CODE:string[3];
URF_CYL_CU_CALL_DATE:string[8];
URF_CYL_CU_GMT_TIME:string[6];
URF_CYL_CU_LOC_TIME:string[6];
URF_CYL_CU_DURATION:decimal[7,1] {default=0.0,packed};
URF_CYL_CU_CALL_TYPE:string[1];
URF_CYL_CU_DATA:string[1];
URF_CYL_CU_NCR:string[1];
URF_CYL_CU_TERM:string[2];
URF_CYL_CU_CONF_ACCESS:string[2];
URF_CYL_CU_CONF_LEADER_ID:string[9];
URF_CYL_CU_ACCOUNTING_CODE:string[8];
URF_CYL_CU_CALLING_STATION:string[15];
URF_CYL_CU_CON_FOR_IND:string[1];
URF_CYL_CU_BAND_NBR:string[2];
URF_CYL_CU_ORIG_SUBZONE:string[2];
URF_CYL_CU_TERM_SUBZONE:string[2];
URF_CYL_CU_ISAC_CARRIER:string[2];
FILLER_18:string[2];
);
URF_CYL_NMT_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_19:string[7];
URF_CYL_NMT_BILL_DATE:string[8];
URF_CYL_NMT_FILLER1:string[20];
URF_CYL_NMT_CHRG_CODE:string[8];
URF_CYL_NMT_FILLER:string[107];
);
URF_CYL_CIRC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CIRC_DATE_INFO:subrec (
URF_CYL_CIRC_INCEPT_DATE:string[8];
URF_CYL_CIRC_EFF_DATE:string[8];
URF_CYL_CIRC_LAST_BILL_DATE:string[8];
URF_CYL_CIRC_CANCELLED_DATE:string[8];
);
URF_CYL_CIRC_PAYER_IND:string[1];
URF_CYL_CIRC_CYCLE:string[1];
URF_CYL_CIRC_CYCLE_MONTH:string[2];
URF_CYL_CIRC_IFD:string[1];
URF_CYL_CIRC_FILLER:string[16];
URF_CYL_CIRC_GL:string[1];
URF_CYL_CIRC_CUST_REF:string[15];
URF_CYL_CIRC_LOCATION:string[15];
URF_CYL_CIRC_STATE_ABBR:string[2];
URF_CYL_CIRC_ZIP:string[9];
URF_CYL_CIRC_GEO_CODE:string[9];
URF_CYL_CIRC_BILLABLE_IND:string[1];
URF_CYL_CIRC_VAT_CODE:string[1];
URF_CYL_CIRC_STRF:string[4];
URF_CYL_CIRC_STFQ:string[1];
FILLER_20:string[39];
);
URF_CYL_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_SPEC_DATE_INFO:subrec (
URF_CYL_SPEC_INCEPT_DATE:string[8];
URF_CYL_SPEC_EFF_DATE:string[8];
URF_CYL_SPEC_LAST_BILL_DATE:string[8];
URF_CYL_SPEC_CANCELLED_DATE:string[8];
);
URF_CYL_SPEC_PAYER_IND:string[1];
URF_CYL_SPEC_CYCLE:string[1];
URF_CYL_SPEC_CYCLE_MONTH:string[2];
URF_CYL_SPEC_IFD:string[1];
URF_CYL_SPEC_FILLER:string[16];
URF_CYL_SPEC_GL:string[1];
URF_CYL_SPEC_CUST_REF:string[15];
URF_CYL_SPEC_LOCATION:string[15];
URF_CYL_SPEC_STATE_ABBR:string[2];
URF_CYL_SPEC_ZIP:string[9];
URF_CYL_SPEC_GEO_CODE:string[9];
URF_CYL_SPEC_BILLABLE_IND:string[1];
URF_CYL_SPEC_PREFIX:string[1];
URF_CYL_SPEC_VAT_CODE:string[1];
URF_CYL_SPEC_STRF:string[4];
URF_CYL_SPEC_STFQ:string[1];
FILLER_21:string[38];
);
URF_CYL_TAX_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_FED_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_ST_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CITY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_OTH_TAX_USA:decimal[11,2] {default=0.00, , 0, 00, 0, ,packed};
URF_CYL_FED_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_ST_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CITY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_OTH_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_VAT_USA:decimal[11,2] {default=0.00,packed};
FILLER_22:string[79];
);
URF_GCS_COMMON_FAC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_FAC_TARIFF:subrec (
URF_GCS_FAC_SRV_TYPE:string[4];
URF_GCS_FAC_RATE_CODE:string[4];
URF_GCS_FAC_ORIG_CTRY:string[4];
URF_GCS_FAC_ORIG_CITY:string[4];
URF_GCS_FACC_DEST_CTRY:string[4];
URF_GCS_FAC_DEST_CITY:string[4];
);
URF_GCS_FAC_SALES_ID:string[9];
URF_GCS_FAC_SALES_CITY:string[6];
URF_GCS_FAC_CCITT_NO:string[25];
URF_GCS_FAC_INET_ACCESS_AMTS:subrec (
URF_GCS_FAC_INET_AMT1_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT1_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT2_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT2_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT3_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT3_FGN:decimal[12,2] {zoned};
);
FILLER_23:string[23];
);
URF_GCS_COMMON_CIRC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CIRC_GROUP:subrec (
URF_GCS_CIRC_TYPE:string[1];
URF_GCS_CIRC_TELCO:string[3];
URF_GCS_CIRC_COST:string[4];
URF_GCS_CIRC_TARF_CODE:string[2];
);
URF_GCS_CIRC_COND:string[6];
URF_GCS_CIRC_CHAN_DESIGN:string[14];
FILLER_24:string[120];
);
URF_GCS_COMMON_EQUIP:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_EQUIP_QTY:decimal[4,0] {zoned};
FILLER_25:string[146];
);
URF_GCS_COMMON_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_PRO_PREFIX:string[1];
URF_GCS_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
FILLER_26:string[113];
);
URF_GCS_COMMON_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPEC_PREFIX:string[1];
FILLER_27:string[149];
);
URF_GCS_COMMON_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPTX_PREFIX:string[1];
URF_GCS_SPTX_VAT:decimal[6,4] {zoned};
URF_GCS_SPTX_TAX_TYPE:string[1];
FILLER_28:string[142];
);
URF_GCS_COMMON_CDR:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CDR_LOC:string[3];
URF_GCS_CDR_BRACKET:string[2];
URF_GCS_CDR_CALLS:decimal[11,0] {zoned};
URF_GCS_CDR_MINUTES:decimal[11,1] {zoned};
URF_GCS_CDR_RATE:decimal[10,6] {zoned};
FILLER_29:string[8];
FILLER_30:string[105];
);
URF_GCS_COMMEB_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_31:string[1];
URF_MEB_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPEC_RATE:decimal[11,5] {zoned};
URF_MEB_SPEC_UNIT_MEAS:string[2];
FILLER_32:string[123];
);
URF_GCS_COMMEB_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_33:string[1];
URF_MEB_SPTX_VAT:decimal[6,4] {zoned};
URF_MEB_SPTX_TAX_TYPE:string[1];
URF_MEB_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPTX_RATE:decimal[11,5] {zoned};
URF_MEB_SPTX_UNIT_MEAS:string[2];
FILLER_34:string[116];
);
URF_GCS_COMMEB_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_35:string[1];
URF_MEB_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_QUANTITY:decimal[13,3] {zoned};
URF_MEB_PRO_RATE:decimal[11,5] {zoned};
URF_MEB_PRO_UNIT_MEAS:string[2];
URF_MEB_PRO_USAGE_PROD:string[8];
FILLER_36:string[79];
);
URF_GCS_COMMEB_BAT_DTL:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_DTL_INV_CATG_CODE:string[2];
URF_MEB_DTL_PROD_SHORT_NAME:string[15];
URF_MEB_DTL_QUANTITY:decimal[13,3] {zoned};
URF_MEB_DTL_RATE:decimal[11,5] {zoned};
URF_MEB_DTL_UNIT_MEAS:string[2];
URF_MEB_DTL_FOOT_NOTE:string[1];
FILLER_37:string[106];
);
URF_GCS_COMMEB_BAT_TAX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_TAX_FROM_LOC:string[20];
URF_MEB_TAX_TAXABLE_AMT:decimal[11,2] {zoned};
URF_MEB_TAX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_TAX_AMOUNT[5]:decimal[11,2] {zoned};
FILLER_38:string[51];
);
URF_GCS_SETL_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SETL_PART_KEY:subrec (
URF_GCS_SETL_SVC_MTH_2:decimal[4,0] {zoned};
URF_GCS_SETL_CHARGE_PREFIX_2:string[1];
URF_GCS_SETL_CURR_CODE_2:string[5];
URF_GCS_SETL_SEQ_NUM_2:decimal[5,0] {zoned};
);
URF_GCS_SETL_GAIN_LOSS:decimal[9,2] {zoned};
URF_GCS_ORIG_TYPE:string[2];
URF_GCS_ORIG_SUBTYPE:string[4];
URF_GCS_ORIG_CHARGE_KEY:subrec (
URF_GCS_ORIG_TAX_TYPE:string[2];
URF_GCS_ORIG_CURR_KEY:string[5];
URF_GCS_ORIG_SECONDARY:subrec (
URF_GCS_ORIG_CDR_RATE:decimal[13,6] {zoned};
FILLER_39:string[5];
);
);
URF_GCS_ORIG_CHARGE_SEQ_NO:string[5];
URF_GCS_SETL_CHRG_MONTH:string[4];
URF_GCS_SETL_ORIG_BIL_DATE:string[8];
URF_GCS_ORIG_AMT_USA:decimal[9,2] {zoned};
URF_GCS_ORIG_AMT_FGN:decimal[13,2] {zoned};
URF_GCS_ORIG_RATE:decimal[14,8] {zoned};
URF_GCS_SETL_RATE:decimal[14,8] {zoned};
FILLER_40:string[28];
);
URF_STN_USAGE_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_CALL_NUMBER:string[15];
URF_STN_ACCOUNT_CODE:string[8];
URF_STN_CALL_DATE:subrec (
URF_STN_CALL_CENTURY:string[2];
URF_STN_CALL_YYMMDD:string[6];
);
URF_STN_LOCAL_CONNECT_TIME:subrec (
URF_STN_CONNECT_HOUR:string[2];
URF_STN_CONNECT_MIN:string[2];
URF_STN_CONNECT_SECS:string[2];
);
URF_STN_CALL_TYPE:string[1];
URF_STN_AMT_FGN_PRE_DISC:decimal[13,2] {zoned};
URF_STN_DISC_AMT:decimal[9,2] {zoned};
URF_STN_DURATION_TIME:subrec (
URF_STN_DURATION_HR:decimal[2,0] {zoned};
URF_STN_DURATION_MIN:decimal[2,0] {zoned};
URF_STN_DURATION_SECS:decimal[2,0] {zoned};
URF_STN_DURATION_TENTHS:decimal[1,0] {zoned};
);
URF_STN_FROM_LOCATION:subrec (
URF_STN_FROM_CITY_NAME:string[10];
URF_STN_FROM_STATE_CODE:string[2];
);
URF_STN_TERM_LOCATION:subrec (
URF_STN_TERM_CITY_NAME:string[10];
URF_STN_TERM_STATE_CODE:string[2];
);
URF_STN_NUMBER_DIALED:string[15];
URF_STN_TO_CNTRY:string[6];
URF_STN_PROVINCE:string[2];
URF_STN_NUMBER_CALLED:string[15];
URF_STN_RATE_PERIOD_IND:string[1];
URF_STN_VCN_CALL_TYPE_IND:string[1];
URF_STN_ORGNG_VCN_POINTIND:string[2];
URF_STN_TERMG_VCN_POINTIND:string[2];
URF_STN_EMR_DTO_IND:string[1];
FILLER_41:string[14];
);
URF_STN_MISC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_MISC_START_DATE:string[8];
URF_STN_MISC_STOP_DATE:string[8];
URF_STN_MISC_QUANTITY:decimal[7,0] {zoned};
URF_STN_MISC_CHRGE_AMT:decimal[15,2] {zoned};
URF_STN_REG_CHRGE_IND:string[1];
URF_STN_CUST_CAMS_ID:decimal[9,0] {zoned};
URF_STN_SUNIT_ID:decimal[5,0] {zoned};
URF_STN_MSC_SETTL_CODE_IND:string[1];
FILLER_42:string[96];
);
URF_STN_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPEC_PSN:string[15];
URF_STN_SPEC_USAGE:string[8];
URF_STN_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPEC_UNIT:string[2];
URF_STN_SPEC_RATE:decimal[11,5] {zoned};
URF_STN_SPEC_FNOTE:string[1];
FILLER_43:string[100];
);
URF_STN_SPTX_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPTX_VAT:decimal[6,4] {zoned};
URF_STN_SPTX_TAX_TYPE:string[1];
URF_STN_SPTX_PSN:string[15];
URF_STN_SPTX_USAGE:string[8];
URF_STN_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPTX_UNIT:string[2];
URF_STN_SPTX_RATE:decimal[11,5] {zoned};
URF_STN_SPTX_FNOTE:string[1];
URF_STN_SPTX_TAX_CODE:string[8];
FILLER_44:string[85];
);
URF_STN_PRO_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_PRO_NEW_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_NEW_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_VAT:decimal[6,4] {zoned};
URF_STN_PRO_PSN:string[15];
URF_STN_PRO_USAGE:string[8];
URF_STN_PRO_QUANTITY:decimal[13,3] {zoned};
URF_STN_PRO_UNIT:string[2];
URF_STN_PRO_RATE:decimal[11,5] {zoned};
URF_STN_PRO_FNOTE:string[1];
FILLER_45:string[50];
);
URF_IFR_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEGA_CHG_CODE:decimal[4,0] {zoned};
URF_IFR_SVC_ID:string[8];
URF_IFR_CHG_BEG_DATE:string[10];
URF_IFR_CHG_END_DATE:string[10];
URF_IFR_PVC_ID:decimal[15,0] {packed};
URF_IFR_ORIG_PVC_COUNTRY:string[3];
URF_IFR_TERM_PVC_COUNTRY:string[3];
URF_IFR_BILLING_PERIOD:string[8];
URF_IFR_ACCESS_CLASS:string[1];
URF_IFR_PARTNER_ID:string[10];
URF_IFR_SERVICE_TYPE:string[4];
URF_IFR_METRO:string[1];
URF_IFR_PIP_COS:string[1];
URF_IFR_PQ_SPEED:decimal[10,1] {packed};
FILLER_46:string[73];
);
URF_FNE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_FNE_CHRG_CODE:string[6];
URF_FNE_CHRG_TYPE:string[1];
URF_FNE_CIRCUIT_TYPE:string[8];
URF_FNE_ADJ_IND:string[1];
URF_FNE_ADJ_DESC:string[14];
URF_FNE_PVC_SPEED:string[7];
URF_FNE_PORT_SPEED:string[8];
URF_FNE_BILL_METHOD:string[1];
URF_FNE_CONT_TERM:string[3];
URF_FNE_CONT_END_DATE:string[8];
URF_FNE_PUR_ORDER_NO:string[25];
URF_FNE_IXC_MILEAGE:string[6];
URF_FNE_SALES_PERSON:string[6];
URF_FNE_LOCA_NPA_NXX:string[6];
URF_FNE_LOCZ_NPA_NXX:string[6];
URF_FNE_LOCA_CITY:string[15];
URF_FNE_LOCA_CNTY_CD:string[3];
URF_FNE_LOCZ_CITY:string[15];
URF_FNE_LOCZ_CNTY_CD:string[3];
URF_FNE_PROMO_CD:string[8];
);
URF_GCS_SALES_REP_DIV_ID:string[2];
URF_GCS_SERVICE_SSN:string[9];
URF_GCS_SERVICE_CITY_CODE:string[4];
URF_GCS_SERVICE_REP_DIV_ID:string[2];
URF_GCS_SALES_CITY_CODE:string[4];
FILLER_47:string[1];
URF_GCS_ACQUISITION_CHANNEL:string[1];
URF_GCS_MEB_ORIG_INVNBR:string[10];
URF_GCS_CAT_CODE:subrec (
URF_GCS_CAT_PRIM:string[4];
URF_GCS_CAT_SUB:string[4];
URF_GCS_CAT_CTRY:string[4];
URF_GCS_CAT_CITY:string[4];
URF_GCS_CAT_DEPT:string[4];
);
FILLER_48:string[1];
URF_GCS_REV_LOCATION:string[3];
FILLER_49:string[51];
)
etlbets
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The first error message relates to the default value for the decimal type - technically 0.00 ("all zeroes") is not permitted. There is an environment variable - whose name I don't recall at the moment - to allow "all zeroes".
The second error is mysterious - the field does exist in the schema, though it is of type subrec (which is OK). That one requires more thought. Maybe there's a glitch in parsing a subrecord that contains a subrecord - which is theoretically allowable.
The second error is mysterious - the field does exist in the schema, though it is of type subrec (which is OK). That one requires more thought. Maybe there's a glitch in parsing a subrecord that contains a subrecord - which is theoretically allowable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I tried something different I uncompressed the file on the mainframe and sent it to data stage as ASCII but I get this error
Complex_Flat_File_375,0: Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).
Complex_Flat_File_375,0: Expected 185 bytes, got 159.
Complex_Flat_File_375,0: Import error at record 30477.
I think it is reading past the last record there are 30314 records in the file is there a way to stop the read at the end of file?
Complex_Flat_File_375,0: Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).
Complex_Flat_File_375,0: Expected 185 bytes, got 159.
Complex_Flat_File_375,0: Import error at record 30477.
I think it is reading past the last record there are 30314 records in the file is there a way to stop the read at the end of file?
etlbets
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: