ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2A63869E053B46B63588994Y SELECT CONTRACT_NUMBER C_4A,--C_4A DELIVERY_ORDER C_4B, --4 B CONTRACT_VALUE C_5, --5 PROGRESS_PAYMENT_RATE C_6A,--6 A LIQUIDATION_RATE C_6B, --6B COST_ELIGIBLE_FOR_PP C_11, --11 COST_ELIGIBLE_FOR_PP C_12A, --12 A GREATEST(((CONTRACT_VALUE/(1+(EAC_RATE/100))) - COST_ELIGIBLE_FOR_PP),0) C_12B,--12B (COST_ELIGIBLE_FOR_PP + (GREATEST(CONTRACT_VALUE/(1+(EAC_RATE/100)) - COST_ELIGIBLE_FOR_PP,0))) C_12C,--12C (COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100)) C_13, SUBCONTRACTOR_PROGRESS_AMT C_14A, SUBCONTRACTOR_LIQ_AMT C_14B, (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_14C, (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_14E, ((COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100))+ (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)) C_15, (CONTRACT_VALUE * (LIQUIDATION_RATE/100)) C_16, LEAST(((COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100))+ (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),(CONTRACT_VALUE * (LIQUIDATION_RATE/100)))C_17, PREVIOUS_PROGRESS_PAYMENT C_18, SECII_ELIGIBLE_PP_AMOUNT C_19, SECIII_COST_INCLUDED C_20A, (COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED) C_20B, ((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) C_20C, (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_20D, (((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)) C_20E, SECIII_SHIPMENT_INVOICED C_21A, (CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) C_21B, ((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)) C_21C, ((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)) C_21E, LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100))) C_22, SECIII_LIQ_AMOUNT C_23, (PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT) C_24 , (LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)))-(PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT)) C_25, LEAST((LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)))-(PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT)),SECII_ELIGIBLE_PP_AMOUNT) C_26 FROM PA_SF1443_REPORT_DETAILS SFRD, PA_DRAFT_CONSOLIDATED_INV_ALL DI WHERE DI.DRAFT_INVOICE_NUM=SFRD.DRAFT_INVOICE_NUM AND DI.BILL_GROUP_ID=SFRD.BILL_GROUP_ID AND (DI.RA_INVOICE_NUMBER= :ARINVNUM OR (DI.RA_INVOICE_NUMBER IS NULL AND (DI.DRAFT_INVOICE_NUM= :CONSINVNUM AND DI.BILL_GROUP_ID=:BILL_GROUP))) PA PAXFBPPS_XML AR PA تقرير SF 1443 الفيدرالي Application: المشروعات Source: إدارة: تقرير SF 1443 الفيدرالي Short Name: PAXFBPPS_XML DB package: D PA SF 1443 auf Bundesebene Application: Projects Source: PA: SF 1443 auf Bundesebene Short Name: PAXFBPPS_XML DB package: F PA Fédéral - Formulaire standard 1443 Application: Projects Source: MGT : Fédéral - Formulaire standard 1443 Short Name: PAXFBPPS_XML DB package: US PA Federal SF 1443 Application: Projects Source: MGT: Federal SF 1443 Short Name: PAXFBPPS_XML DB package: ZHS PA MGT：联邦 SF 1443 Application: 项目 Source: MGT：联邦 SF 1443 Short Name: PAXFBPPS_XML DB package: BI Publisher :arinvnum :bill_group :consinvnum :operating_unit 1 10 :arinvnum Char Y AR رقم فاتورة المقبوضات D DE-Rechnungsnummer F Numéro de facture client US AR Invoice Number ZHS AR 发票编号