JG_CST_FSCL_DOC_RELATIONS

Details

Schema: FUSION
Object owner: JG
Object type: VIEW

Columns

Name
DOC_RELATION_ID FISCAL_DOC_KEY FISCAL_DOC_TYPE TRX_ID STATUS DOC_HDR_ID DOC_LINE_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE DOC_NUM SERIES FISCAL_DOC_DATE MODEL DOC_ISSUE_TYPE DOC_NATURE DOC_GEN_PROCESS CONTINGENCY_DATE CONTINGENCY_JUSTIFICATION VOID_DATE REJECTION_REASON REF_DOC_HDR_ID REF_DOC_NUM REF_FISCAL_DOC_KEY REF_FISCAL_DOC_DATE REF_MODEL REF_SERIES REF_ISSUER_TAXPAYER_ID REF_RURAL_FLAG RPS_NUMBER VOID_REASON CANCEL_REASON CONTINGENCY_TYPE PROCESSED_DATE_TIME PROTOCOL_NUMBER TAX_INVOICE_NUMBER_FLAG CONTINGENCY_SERIES SENDING_FILE_NAME RECEIVED_FILE_NAME REF_DOC_ISSUER_STATE_CODE TAX_AUTH_DOC_NUMBER TAX_SETTLEMENT_DATE LEGAL_REPORTING_UNIT_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Name

DOC_RELATION_ID

FISCAL_DOC_KEY

FISCAL_DOC_TYPE

TRX_ID

STATUS

DOC_HDR_ID

DOC_LINE_ID

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

DOC_NUM

SERIES

FISCAL_DOC_DATE

MODEL

DOC_ISSUE_TYPE

DOC_NATURE

DOC_GEN_PROCESS

CONTINGENCY_DATE

CONTINGENCY_JUSTIFICATION

VOID_DATE

REJECTION_REASON

REF_DOC_HDR_ID

REF_DOC_NUM

REF_FISCAL_DOC_KEY

REF_FISCAL_DOC_DATE

REF_MODEL

REF_SERIES

REF_ISSUER_TAXPAYER_ID

REF_RURAL_FLAG

RPS_NUMBER

VOID_REASON

CANCEL_REASON

CONTINGENCY_TYPE

PROCESSED_DATE_TIME

PROTOCOL_NUMBER

TAX_INVOICE_NUMBER_FLAG

CONTINGENCY_SERIES

SENDING_FILE_NAME

RECEIVED_FILE_NAME

REF_DOC_ISSUER_STATE_CODE

TAX_AUTH_DOC_NUMBER

TAX_SETTLEMENT_DATE

LEGAL_REPORTING_UNIT_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT DOC_RELATION_ID , FISCAL_DOC_KEY , FISCAL_DOC_TYPE , TRX_ID , STATUS , DOC_HDR_ID , DOC_LINE_ID , APPLICATION_ID , ENTITY_CODE, EVENT_CLASS_CODE, DOC_NUM , SERIES, FISCAL_DOC_DATE , MODEL, DOC_ISSUE_TYPE, DOC_NATURE , DOC_GEN_PROCESS, CONTINGENCY_DATE , CONTINGENCY_JUSTIFICATION , VOID_DATE , REJECTION_REASON, REF_DOC_HDR_ID, REF_DOC_NUM , REF_FISCAL_DOC_KEY , REF_FISCAL_DOC_DATE , REF_MODEL , REF_SERIES , REF_ISSUER_TAXPAYER_ID , REF_RURAL_FLAG , RPS_NUMBER , VOID_REASON , CANCEL_REASON , CONTINGENCY_TYPE , PROCESSED_DATE_TIME, PROTOCOL_NUMBER, TAX_INVOICE_NUMBER_FLAG, CONTINGENCY_SERIES , SENDING_FILE_NAME , RECEIVED_FILE_NAME , REF_DOC_ISSUER_STATE_CODE , TAX_AUTH_DOC_NUMBER , TAX_SETTLEMENT_DATE , LEGAL_REPORTING_UNIT_ID , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN FROM JG_FSCL_DOC_RELATIONS where APPLICATION_ID=707 AND ENTITY_CODE ='SALES_ORDER_ISSUE' AND EVENT_CLASS_CODE= 'SALES_ORDER_ISSUE' AND DOC_LINE_ID >=0

SQL_Statement

SELECT

DOC_RELATION_ID ,

FISCAL_DOC_KEY ,

FISCAL_DOC_TYPE ,

TRX_ID ,

STATUS ,

DOC_HDR_ID ,

DOC_LINE_ID ,

APPLICATION_ID ,

ENTITY_CODE,

EVENT_CLASS_CODE,

DOC_NUM ,

SERIES,

FISCAL_DOC_DATE ,

MODEL,

DOC_ISSUE_TYPE,

DOC_NATURE ,

DOC_GEN_PROCESS,

CONTINGENCY_DATE ,

CONTINGENCY_JUSTIFICATION ,

VOID_DATE ,

REJECTION_REASON,

REF_DOC_HDR_ID,

REF_DOC_NUM ,

REF_FISCAL_DOC_KEY ,

REF_FISCAL_DOC_DATE ,

REF_MODEL ,

REF_SERIES ,

REF_ISSUER_TAXPAYER_ID ,

REF_RURAL_FLAG ,

RPS_NUMBER ,

VOID_REASON ,

CANCEL_REASON ,

CONTINGENCY_TYPE ,

PROCESSED_DATE_TIME,

PROTOCOL_NUMBER,

TAX_INVOICE_NUMBER_FLAG,

CONTINGENCY_SERIES ,

SENDING_FILE_NAME ,

RECEIVED_FILE_NAME ,

REF_DOC_ISSUER_STATE_CODE ,

TAX_AUTH_DOC_NUMBER ,

TAX_SETTLEMENT_DATE ,

LEGAL_REPORTING_UNIT_ID ,

CREATION_DATE ,

CREATED_BY ,

LAST_UPDATE_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_LOGIN

FROM JG_FSCL_DOC_RELATIONS

where APPLICATION_ID=707

AND ENTITY_CODE ='SALES_ORDER_ISSUE'

AND EVENT_CLASS_CODE= 'SALES_ORDER_ISSUE'

AND DOC_LINE_ID >=0