API tools faq
paste
Advertisement
mugs

Insert into GL_ENTRY_T

mugs
Jul 10th, 2015
289
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 6.97 KB | None | 0 0
raw download clone embed print report
  1. --------------------------------------------------------
  2. --  File created - Friday-July-10-2015  
  3. --------------------------------------------------------
  4. REM INSERTING INTO GL_ENTRY_T
  5. SET DEFINE OFF;
  6. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  7. (2015,'I','1GQ0009','-----','7011','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  8. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  9. (2015,'I','1GQ0009','-----','7012','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  10. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  11. (2015,'I','1GQ0009','-----','7013','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  12. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  13. (2015,'I','1GQ0009','-----','7015','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  14. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  15. (2015,'I','1GQ0009','-----','7016','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  16. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  17. (2015,'I','1GQ0009','-----','7014','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  18. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  19. (2015,'I','1GQ0009','-----','7017','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  20. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  21. (2015,'I','1GQ0009','-----','7018','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  22. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  23. (2015,'I','1GQ0009','-----','7019','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
  24. INSERT INTO GL_ENTRY_T (UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD,FIN_BALANCE_TYP_CD,FIN_OBJ_TYP_CD,UNIV_FISCAL_PRD_CD,FDOC_TYP_CD,FS_ORIGIN_CD,FDOC_NBR,TRN_ENTR_SEQ_NBR,TRN_LDGR_ENTR_DESC,TRN_LDGR_ENTR_AMT,TRN_DEBIT_CRDT_CD,TRANSACTION_DT,ORG_DOC_NBR,PROJECT_CD,ORG_REFERENCE_ID,FDOC_REF_TYP_CD,FS_REF_ORIGIN_CD,FDOC_REF_NBR,FDOC_REVERSAL_DT,TRN_ENCUM_UPDT_CD,TRN_POST_DT,TIMESTAMP) VALUES
  25. (2015,'I','1GQ0009','-----','7020','---','AC','AS','03','ND','01','861454',1,'TP Generated Bank Offset',8000,'C',TO_DATE('07-MAY-15','DD-MON-RR'),NULL,'----------',NULL,NULL,NULL,NULL,NULL,' ',TO_DATE('13-MAY-15','DD-MON-RR'),TO_DATE('14-MAY-15','DD-MON-RR'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!