Monday, July 12, 2021

Customized PWC Table

 

ODM Master Sheet Tables:

 PWC_ODM_JOB_CLUBBING_TERRY   --job name

PWC_ODM_HISTORY_JOB_TERRY   ----job history

PWC_ODM_HISTORY_TERRY    --------item history

PWC_ODM_COMPO_CODE_TERY_GREIGE   ------Yarn/Greige

PWC_ODM_COMPO_CODE_TERY_CHMCL   ------Chemical

PWC_ODM_COMPO_CODE_TERY_ACSORS  ------Accessories

PWC_ODM_JOB_COMPONENTS_TERRY_V  -------Components



PWC_ODM_JOB_CLUBBING_WVNG   ------job name

PWC_ODM_HISTORY_JOB_WVNG   -------job history

PWC_ODM_HISTORY_WVNG       -------item histiry

PWC_ODM_COMPO_CODE_WVNG_GREIGE  -----Yarn/Greige

PWC_ODM_COMPO_CODE_WVNG_CHMCL  -----Dyes/Chemicals



PWC_ODM_MASTER_SHT_PRCSNG_LINE  -----batch details

PWC_ODM_MASTER_SHT_JOB_PRCSNG   -----job name

PWC_ODM_MSTR_SHT_RESURC_PRCSNG  -----routing details

PWC_ODM_MSTR_SHT_PRCSNG_FBRC    -----fabric details

PWC_ODM_MSTR_HSTRY_PRCSNG       -----job history

PWC_ODM_MASTER_SHT_PRCSNG_HDR   -----header

PWC_ODM_INSP_PRC_FAULT_ENTRIES  -----inspection faults

PWC_ODM_MSTR_SHT_TL_VLM_PRCSNG  -----volume calculation

PWC_ODM_MSTR_SHT_PRCSNG_CHMCL   -----chemical details

NG_ODM_ORDER_WISE_JOB_DTLS_V    NOWJV


ED Form All Tables:


PWC_ED_COMERCIL_CONTNR_DETL

PWC_ED_COMMERCIAL_FORM_TT_REF

PWC_ED_COMMERCIAL_INVOICE_HDR

PWC_ED_COMMERCIAL_INVOICE_L

PWC_ED_EXPORT_ATTACHMENT

PWC_ED_EXPORT_FORM_HEADER

PWC_ED_EXPORT_FORM_MASTER_LC

PWC_ED_EXPORT_FORM_PI_HDR

PWC_ED_EXPORT_FORM_PI_LINES

PWC_ED_EXPORT_FORM_RECEIPT

PWC_ED_EXPORT_FORM_TT_REF

PWC_ED_REMITTANCE_HDR

PWC_ED_REMITTANCE_LINE


OTL NG Tables:

NG_HO_OTL_INT_FCT  ----- To get data from timecard interface.
TEMP_OTL_MACHINE_DATA  ---- To get data migration information for head office.
TEMP_TIME_LABOR_INTERFACE ---- To get data migration information for factory.

No comments:

Post a Comment