|
1
|
INSERT [dbo].[TR_REQUEST_COSTCENTER] ([REQ_COST_ID], [COST_ID], [REQ_ID], [NOTES], [AUTH_STATUS], [MAKER_ID], [CREATE_DT], [CHECKER_ID], [APPROVE_DT]) VALUES (N'TRCC00001106213', N'DM0000000000008', N'TRRD00001124152', N'', N'A', N'tucgn', NULL, N'phuongtln1', NULL)
|
|
2
|
GO
|
|
3
|
INSERT [dbo].[TR_REQUEST_COSTCENTER] ([REQ_COST_ID], [COST_ID], [REQ_ID], [NOTES], [AUTH_STATUS], [MAKER_ID], [CREATE_DT], [CHECKER_ID], [APPROVE_DT]) VALUES (N'TRCC00001106214', N'DM0000000000008', N'TRRD00001124152', N'', N'A', N'tucgn', NULL, N'phuongtln1', NULL)
|
|
4
|
GO
|
|
5
|
INSERT [dbo].[TR_REQUEST_DOC] ([REQ_ID], [REQ_CODE], [REQ_NAME], [REQ_DT], [REQ_TYPE], [REQ_CONTENT], [PROCESS_ID], [PL_REQ_ID], [TOTAL_AMT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [BRANCH_DO], [REQ_REASON], [BRANCH_CREATE], [USER_REQUEST], [BRANCH_DVMS], [USER_DVMS], [DMMS_ID], [DEP_CREATE], [REQ_PARENT_ID], [SIGN_USER]) VALUES (N'TRRD00001124152', N'PUR/2020/00009740', NULL, NULL, NULL, N'', N'', N'PLRD00001105599', NULL, N'', N'1', N'tucgn', NULL, N'A', N'phuongtln1', NULL, N'', N'Quảng cáo Livestream Facebook', N'', N'tucgn', N'', N'', N'', N'', N'', N'')
|
|
6
|
GO
|
|
7
|
INSERT [dbo].[TR_REQUEST_DOC_DT] ([REQDT_ID], [REQ_DOC_ID], [PL_REQDT_ID], [GD_ID], [SUP_ID], [DESCRIPTION], [TRAN_TYPE_ID], [QUANTITY], [PRICE], [TOTAL_AMT], [AMOUNT_PAID], [INVOICENO], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [PRICE_ETM], [TOTAL_AMT_ETM], [REQ_DT], [AMORT_MONTH], [HANGHOA_ID], [CURRENCY], [EXCHANGE_RATE], [TAXES], [DVDM_ID], [BID_ID], [OFFERING_VALUE], [NOTE_DVMS], [PO_ID], [PO_AMT]) VALUES (N'TRRDD0001124750', N'TRRD00001124152', N'PLRDD0001105949', NULL, NULL, N'', N'VCCB', CAST(1 AS Decimal(18, 0)), CAST(10000000.00 AS Decimal(18, 2)), CAST(10000000.00 AS Decimal(18, 2)), NULL, N'', N'', N'1', N'tucgn', NULL, N'A', N'phuongtln1', NULL, NULL, NULL, NULL, NULL, N'HH0000000112275', N'VND', CAST(1.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'DM0000000000008', N'', NULL, NULL, NULL, NULL)
|
|
8
|
GO
|
|
9
|
INSERT [dbo].[TR_REQUEST_DOC_DT] ([REQDT_ID], [REQ_DOC_ID], [PL_REQDT_ID], [GD_ID], [SUP_ID], [DESCRIPTION], [TRAN_TYPE_ID], [QUANTITY], [PRICE], [TOTAL_AMT], [AMOUNT_PAID], [INVOICENO], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [PRICE_ETM], [TOTAL_AMT_ETM], [REQ_DT], [AMORT_MONTH], [HANGHOA_ID], [CURRENCY], [EXCHANGE_RATE], [TAXES], [DVDM_ID], [BID_ID], [OFFERING_VALUE], [NOTE_DVMS], [PO_ID], [PO_AMT]) VALUES (N'TRRDD0001124751', N'TRRD00001124152', N'PLRDD0001105949', NULL, NULL, N'', N'VCCB', CAST(1 AS Decimal(18, 0)), CAST(81000000.00 AS Decimal(18, 2)), CAST(81000000.00 AS Decimal(18, 2)), NULL, N'', N'', N'1', N'tucgn', NULL, N'A', N'phuongtln1', NULL, NULL, NULL, NULL, NULL, N'HH0000000112275', N'VND', CAST(1.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'DM0000000000008', N'', NULL, NULL, NULL, NULL)
|
|
10
|
GO
|