USE [agroib_db]
GO
SET IDENTITY_INSERT [dbo].[IB_FILE_FIELD] ON 

INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(9 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'H', N'Identifier', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'A', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'H', N'Job_Type', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'B', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(11 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'H', N'Primary_Debit_Account', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'C', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(12 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'H', N'Company_Code', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'D', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(13 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'H', N'Company_Name', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'E', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(14 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'H', N'Crediting_Date', CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'ddMMyyyy', NULL, CAST(1 AS Numeric(19, 0)), N'F', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(15 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'H', N'Arahan_Patriot_No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'G', CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(16 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'H', N'Customer_Transaction_Ref', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'H', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(17 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'H', N'Additional_Reference', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'I', CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(18 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'H', N'Occupation_Code', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'J', CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(19 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), N'H', N'Source_Of_Funds', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'K', CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(20 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), N'H', N'Payment_Type', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'L', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(21 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(13 AS Numeric(19, 0)), N'H', N'Total_Batch_Records', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'M', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(22 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), N'H', N'Total_Batch_Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(1 AS Numeric(19, 0)), N'N', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(23 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), N'D', N'Debit_Acct', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, CAST(4 AS Numeric(19, 0)), N'A', CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(24 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'H', N'Record Type', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(25 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'H', N'HQ Employer No.', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(26 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'H', N'Branch Employer No.', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(27 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'H', N'Deduction Year', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(28 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'H', N'Deduction Month', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(29 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'H', N'Total PCB Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(30 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'H', N'Total PCB Record', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(31 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'H', N'Total CP38 Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(32 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'H', N'Total CP38 Record', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(33 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'D', N'Record Type', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(34 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'D', N'Tax Reference No.', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(35 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'D', N'Wife Code', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(36 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'D', N'Employee Name', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(60 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(37 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'D', N'Old IC No.', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(38 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'D', N'New IC No.', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(39 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'D', N'Passport No.', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(40 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'D', N'Country Code', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(41 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'D', N'PCB Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(42 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'D', N'CP38 Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(43 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), N'D', N'Employee No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10024 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'D', N'SOCSO Registration No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10025 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'D', N'Company Registration No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(20 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10026 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'D', N'IC', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10027 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'D', N'NAME', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(150 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10028 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'D', N'Contribution Month', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10029 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'D', N'Contribution', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10030 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'D', N'Termination Date', CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'ddMMyyyy', NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10031 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'D', N'Employment Status', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10032 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'H', N'H', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10033 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'H', N'Filler', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10034 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'H', N'Registration/Payment Indicator', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10035 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'H', N'Tax Payment Option', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10036 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'H', N'Value Date', CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'yyyyMMdd', NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10037 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'H', N'EPF Employer Ref No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10038 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'H', N'Company Contact Person', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(25 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10039 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'H', N'Company Contact number', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10040 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'H', N'Penalty Sequence Number', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10041 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'H', N'Contribution Month and year', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10044 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), N'H', N'EPF Employer Name', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(40 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10045 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), N'H', N'Company State Code', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10046 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(13 AS Numeric(19, 0)), N'H', N'Client Code', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10047 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), N'H', N'PIR Reference No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10048 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'D', N'D', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10049 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'D', N'Company Staff No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10050 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'D', N'Filler', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10051 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'D', N'Malaysian', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10052 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'D', N'Employee Ref No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10053 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'D', N'Employee Old IC No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10054 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'D', N'Employee New IC No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10055 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'D', N'Employee Passport No', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10056 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'D', N'Salary Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(16 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10057 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'D', N'Employer EPF Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10058 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), N'D', N'Employee Initial', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10059 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), N'D', N'Employee Name', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(40 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10060 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(13 AS Numeric(19, 0)), N'D', N'Employee Identifying Key', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10061 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), N'D', N'Member Wages', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10062 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), N'D', N'Row Emp Hash', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(13 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10063 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'T', N'T', CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10064 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'T', N'Total Record', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10065 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), N'T', N'Total Salary Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(16 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10066 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), N'T', N'Total Employer EPF Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10067 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), N'T', N'Total Amount', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10068 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), N'T', N'Hashing Value', CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(15 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10069 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(7 AS Numeric(19, 0)), N'T', N'Bank code', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10070 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(8 AS Numeric(19, 0)), N'T', N'Filler', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10071 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(9 AS Numeric(19, 0)), N'T', N'Debit Account No', CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(0 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10072 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(10 AS Numeric(19, 0)), N'T', N'Filler', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(6 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10073 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(11 AS Numeric(19, 0)), N'T', N'Debit Reference', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(14 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
INSERT [dbo].[IB_FILE_FIELD] ([OID], [CATEGORY_ID], [FIELD_ORDER], [FIELD_TYPE], [FIELD_NAME], [DATA_TYPE], [LETTER_CASE], [DATA_SIZE], [DATE_FORMAT], [SECTION], [ROW_COUNT], [COLUMN_COUNT], [IS_MANDATORY], [DECIMAL_POINT]) VALUES (CAST(10074 AS Numeric(19, 0)), CAST(5 AS Numeric(19, 0)), CAST(12 AS Numeric(19, 0)), N'T', N'Debit Description', CAST(0 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(40 AS Numeric(19, 0)), NULL, NULL, NULL, NULL, CAST(1 AS Numeric(19, 0)), NULL)
SET IDENTITY_INSERT [dbo].[IB_FILE_FIELD] OFF
