138x Filetype XLS File size 0.06 MB Source: chemexcil.in
Sheet 1: RLSALUR
#1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 14.1 | 14.2 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | ||
#CASE NUMBER | DUMPING | COUNTRY | REPORTING COMPANY | ACCOUNTING CURRENCY | FILE DATE | DESTINATION | RELATED SALES | SEQUENTIAL NUMBER | PRODUCT CONTROL NUMBER | PRODUCT CONTROL NUMBER | PRODUCT CONTROL NUMBER | PRODUCT SALES CODE | SOURCE | SUPPLIER | CUSTOMER TYPE | TRADE LEVEL AM OR OEM | OEM CONTRACT/ TENDER NUMBER | INVOICE DATE | YEAR AND MONTH | INVOICE NUMBER | CUSTOMER CODE IN YOUR RECORDS | CUSTOMER NAME | SALES ORDER OR CONTRACT NUMBER OF THE TRANSACTION | NUMBER OF BILL OF LOADING OR OTHER TRANSPORT DOCUMENT | COUNTRY OF DESTINATION OF GOODS | DELIVERY TERMS | PLACE OF DELIVERY | PAYMENT TERMS: AT SIGHT, 30 DAYS, E.T.C. | UNIT OF MEASUREMENT OF THE QUANTITY | QUANTITY INVOICED IN METRIC TONNES | GROSS INVOICE VALUE INCLUDING TAXES | TAXES A ON THE INVOICE | TAXES B ON THE INVOICE | FREIGHT RECOVERY ON THE INVOICE | DISCOUNTS DEDUCTED ON THE INVOICE CURRENCY OF SALE | NET INVOICE VALUE AFTER TAXES & DISCOUNTS | CREDIT NOTE NUMBER | CREDIT NOTE DATE | CREDIT NOTE QUANTITY IN METRIC TONNES | CREDIT NOTE VALUE IN I | INVOICE CURRENCY | EXCHANGE RATE | NET INVOICE QUANTITY in METRIC TONNES | NET INVOICE VALUE IN ACCOUNTING CURRENCY | CIF VALUE IN ACCOUNTING CURRENCY | HANDLING LOADING AND ANCILLARY EXPENSES AT THE PREMISES IN EXPORTING COUNTRY | FREIGHT IN EXPORTING COUNTRY | OCEAN FREIGHT | OCEAN INSURANCE | EU: CUSTOMS DUTY | EU: OTHER IMPORT CHARGES | EU: FREIGHT IN THE EUROPEAN COMMUNITY | EU: HANDLING LOADING AND ANCILLARY EXPENSES | EXPORT DUTY IN COUNTRY CONCERNED | PACKING EXPENSES | CREDIT COST | WARRANTY AND GUARANTEE EXPENSES | EXPENSES FOR TECHNICAL ASSISTANCE AND SERVICES | BANK CHARGES | COMMISSION | CURRENCY CONVERSION | QUANTITY DISCOUNTS | OTHER DISCOUNTS | YEAR-END REBATES | OTHER ALLOWANCES | TOTAL ALLOWANCES | EXCHANGE RATE FOR CONVERSION IN CURRENCY OF EXPORTING COUNTRY | NET INVOICE VALUE IN CURRENCY OF EXPORTING COUNTRY | CIF VALUE IN CURRENCY OF EXPORTING COUNTRY | TOTAL OF ALLOWANES IN CURRENCY OF EXPORTING COUNTRY | CORRESPONDING SN IN EUSALRL | COMPANY COMMENT | INWARD PROCESSING SALES Y/N |
TBT_CASE_NUMBER | TBT_DI | TBT_COUNTRY | TBT_REPORTING_COMPANY | TBT_ACNTG_CURNCY | TBT_FILE_DATE | TBT_FLOW | TBT_RLTED | TBT_SN | Product type: D, A, Q |
Sulphate content: U, R, N | TBT_PCN | TBT_PSC | TBT_SOURCE | TBT_SUPPLIER | TBT_CHANNEL | TBT_AM_OEM | TBT_OEM_CONTRACT | TBT_INV_DATE | TBT_PERIOD | TBT_INV_NUM | TBT_CUSTCODE | TBT_CUSTNAME | TBT_SALESORDER | TBT_BILLNUM | TBT_MS | TBT_DELTERM | TBT_DELPLACE | TBT_PAYTERM | TBT_INVQTYUNIT | TBT_INVMT | TBT_INVGRVAL | TBT_INVTAXA | TBT_INVTAXB | TBT_FREIGHTRECO | TBT_INVSALDISC | TBT_INV_NET_VAL | TBT_CRDNUM | TBT_CRDDATE | TBT_CRDQTY_MT | TBT_CRDVAL | TBT_INVCUR | TBT_EXCH | TBT_NET_INVOICE_QTY | TBT_NET_INV | TBT_CIFVAL_EUR | TBT_EXPPREM | TBT_EXPFREIGHT | TBT_SEAFREIGHT | TBT_SEAINSRCE | TBT_EUCUSTDUTY | TBT_EUIMPFEES | TBT_EUFREIGHT | TBT_EUHDLGLOADG | TBT_EXPDUTY | TBT_PACKING | TBT_CRDT_COST | TBT_WARGUAR | TBT_ASSIST | TBT_BANK_CHARGES | TBT_COMM | TBT_CURR_CONV | TBT_QTYDISCNT | TBT_OTHDISCNT | TBT_YEARRBTS | TBT_OTH_ALLOW | TBT_TTALLO | TBT_EXPEXCHANGE | TBT_NET_INVOICE_VALUE | TBT_CIF_VALUE | TBT_TOTAL_OF_ALLOWANCES | TBT_SN_RL | TBT_INFOCOMMENT | TBT_INFOPRCSSG |
R672 | D | IND | xxx | INR | 5/15/2015 | EUSALES | N | 1 | D | N | DN | xxx | RL | 1 | OEM | 12345 | 5/12/2009 | 200905 | D1256 | xxx | xxx | xxx | xxx | DE | DDP | ERFURT | 90 | T | 605000 | 105000 | 0 | 0 | 0 | 500000 | EUR | 1 | 1 | 500000 | 450000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000 | 50000 | 5 | 2500000 | 2250000 | 250000 | |||||||||
ALLOWANCES ON EXPORT SALES IN ACCOUNTING CURRENCY ARE EXPLAINED IN THE QUESTIONNAIRE SECTION H - 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
See the sheet 'information' | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The first line of the report is the "STANDARD_NAMES" of each column. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The file must include one transaction per line. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
N.B: All numbers must follow this format: “1230900.0000” | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The decimal separator is a dot. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Do not put thousand separators. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Date format is DD/MM/YYYY. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Please note that a "transaction" is a line on an invoice. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
no reviews yet
Please Login to review.