Uğur Özpınar 6a4b451b1c düzeltme
2018-10-03 16:24:16 +03:00
..
2018-10-03 16:24:16 +03:00

Field Name Field Type Field Size Field Offset Expression
LOGICALREF Longint 4 0 Item Transaction Logical Reference
STOCKREF Longint 4 4 Item Card Reference
LINETYPE Byte 1 8 Line Type ;0 Material;1 Promotion;2 Discount;3 Surcharge;4 Service;5 Deposit;6 Mixed Case;7 Mixed Case Line;8 Fixed Asset;9 Optional Material;10 Material Class;11 Subcontracting1
PREVLINEREF Longint 4 9 Parent Material Class Line Reference
PREVLINENO Integer 2 13 Parent Material Class Line Number
DETLINE Byte 1 15 Detail Line of Material Class ;(1- Yes, 0- No)2
TRCODE Integer 2 16 Voucher Type That Connected ;15, 16, 17, 18, 19 User Defined Input Slip;20, 21, 22, 23, 24 User Defined Output Slip;30, 31, 32, 33, 34 User defined purchase receipts;35, 36, 37, 38, 39 User defined sales dispatches3
DATE_ Longint 4 18 Voucher Date
FTIME Longint 4 22 Voucher Time
GLOBTRANS Byte 1 26 (For Discount, Surcharge, Promotion Lines) Applied to Voucher Bottom ;(1 for general, 0 for details) (1- Yes, 0- No)4
CALCTYPE Byte 1 27 (For Discount, Surcharge, Promotion Lines) Calculation Type ;0 Percentage;1 Quantity;2 Formula5
PRODORDERREF Longint 4 28 Production Order Reference
SOURCETYPE Byte 1 32 Resource Type ;(0- Warehouse, 1- Workstation)6
SOURCEINDEX Integer 2 33 Resource Warehouse Number
SOURCECOSTGRP Integer 2 35 Resource Warehouse Cost Group
SOURCEWSREF Longint 4 37 Resource Workstation Reference
SOURCEPOLNREF Longint 4 41 Resource Work Order Reference
DESTTYPE Byte 1 45 Target Type ;(0- Warehouse, 1- Workstation)7
DESTINDEX Integer 2 46 Target Warehouse Number
DESTCOSTGRP Integer 2 48 Target Warehouse Cost Group
DESTWSREF Longint 4 50 Target Workstation Reference
DESTPOLNREF Longint 4 54 Target Work Order Reference
FACTORYNR Integer 2 58 Plant Number
IOCODE Integer 2 60 Input / Output Code ;1 Input;2 Input From Warehouse;3 Output From Warehouse;4 Output8
STFICHEREF Longint 4 62 Item Voucher Reference
STFICHELNNO Integer 2 66 Item Voucher Line Number
INVOICEREF Longint 4 68 Invoice Reference
INVOICELNNO Integer 2 72 Invoice Line Number
CLIENTREF Longint 4 74 Accounts Receivable & Payable Reference
ORDTRANSREF Longint 4 78 Order Voucher Line Logical Reference
ORDFICHEREF Longint 4 82 Order Voucher Reference
CENTERREF Longint 4 86 Overhead Pool Reference
ACCOUNTREF Longint 4 90 General Ledger Account Reference
VATACCREF Longint 4 94 VAT Account Reference
VATCENTERREF Longint 4 98 VAT Overhead Pool Reference
PRACCREF Longint 4 102 Promotion Account Reference
PRCENTERREF Longint 4 106 Promotion Overhead Pool Reference
PRVATACCREF Longint 4 110 VAT of Promotion Account Reference
PRVATCENREF Longint 4 114 VAT of Promotion Overhead Pool Reference
PROMREF Longint 4 118 Promotion Card Reference
PAYDEFREF Longint 4 122 Payment Plan Reference
SPECODE ZString 17 126 Aux. Code
DELVRYCODE ZString 11 143 Delivery Code
AMOUNT Double 8 154 Quantity
PRICE Double 8 162 Unit Price
TOTAL Double 8 170 Total
PRCURR Byte 1 178 Pricing Currency Type
PRPRICE Double 8 179 Price of Pricing Currency
TRCURR Byte 1 187 Transaction Currency Type
TRRATE Double 8 188 Transaction Currency Exchange Rate
REPORTRATE Double 8 196 Reporting Currency Exchange Rate
DISTCOST Double 8 204 Distributed Cost to Line
DISTDISC Double 8 212 Distributed Discount to Line
DISTEXP Double 8 220 Distributed Surcharge to Line
DISTPROM Double 8 228 Distributed Promotion to Line
DISCPER Double 8 236 Percentage of Discount
LINEEXP ZString 81 244 Line Description
UOMREF Longint 4 325 Unit Reference
USREF Longint 4 329 Unit Set Reference
UINFO1 Double 8 333 Conversion Factor
UINFO2 Double 8 341 Conversion Factor
UINFO3 Double 8 349 Dimension Factor
UINFO4 Double 8 357 Dimension Factor
UINFO5 Double 8 365 Dimension Factor
UINFO6 Double 8 373 Dimension Factor
UINFO7 Double 8 381 Dimension Factor
UINFO8 Double 8 389 Dimension Factor
PLNAMOUNT Double 8 397 Planned Quantity
VATINC Byte 1 405 Included / Excluded VAT ;(0- Excluded, 1- Included)9
VAT Double 8 406 VAT
VATAMNT Double 8 414 Net VAT Amount
VATMATRAH Double 8 422 VAT Base Amount
BILLEDITEM Longint 4 430 Item That Need To Be Billed
BILLED Byte 1 434 Billed
CPSTFLAG Byte 1 435 Mixed Case Line
RETCOSTTYPE Byte 1 436 Return Transaction Cost Type ;0 Output;1 At The Moment;2 Amount
SOURCELINK Longint 4 437 Connection of Resource Transaction in Returns
RETCOST Double 8 441 Return Cost For Return Voucher
RETCOSTCURR Double 8 449 Return Cost In F.Currency For Return Voucher
OUTCOST Double 8 457 Output Vouchers Output Cost
OUTCOSTCURR Double 8 465 Output Cost In F.Currency of Output Voucher
RETAMOUNT Double 8 473 Return Quantity
FAREGREF Longint 4 481 Fixed Asset Record Reference
FAATTRIB Byte 1 485 Fixed Asset Record Relation Type
CANCELLED Byte 1 486 Cancelled ;(1- Yes, 0- No)
LINENET Double 8 487 Net Line Total
DISTADDEXP Double 8 495 Distributed Additional Surcharge To Line
FADACCREF Longint 4 503 Fixed Asset Accumulated Depreciation Account
FADCENTERREF Longint 4 507 Fixed Asset Accumulated Depreciation Overhead Pool Reference
FARACCREF Longint 4 511 Fixed Asset Revalution Account
FARCENTERREF Longint 4 515 Fixed Asset Revalution Depreciation Overhead Pool Reference
DIFFPRICE Double 8 519 Price Difference Total
DIFFPRCOST Double 8 527 Cost Because Of Price Difference
DECPRDIFF Byte 1 535 Price Difference ;0 Raiser;1 Reducer
LPRODSTAT Integer 2 536 Status
PRDEXPTOTAL Double 8 538 Total Surcharge Voucher That Added to Input From Production
DIFFREPPRICE Double 8 546 Total Price Difference Reporting Currency
DIFFPRCRCOST Double 8 554 Reporting Currency Cost Because of Price Difference
SALESMANREF Longint 4 562 Sales Representative Reference
FAPLACCREF Longint 4 566 Fixed Asset Profit / Loss Account
FAPLCENTERREF Longint 4 570 Fixed Asset Profit / Loss Overhead Pool Reference
OUTPUTIDCODE ZString 25 574 Output Log Code
DREF Longint 4 599 Distribution Template Reference
COSTRATE Double 8 603 Percentage of Line Cost For Input From Production Slip
XPRICEUPD Byte 1 611 Internal Usage
XPRICE Double 8 612 Internal Usage
XREPRATE Double 8 620 Internal Usage
DISTCOEF Double 8 628 Price Difference Distribution Factor
TRANSQCOK Byte 1 636 Inspection Conformity
SITEID Integer 2 637 Data Processing Site
RECSTATUS Integer 2 639 Record Status
ORGLOGICREF Longint 4 641 Original Record Logical Reference
WFSTATUS Longint 4 645 Not In Use
POLINEREF Longint 4 649 Production Order Line Reference
PLNSTTRANSREF Longint 4 653 Planned Item Transaction Reference
NETDISCFLAG Byte 1 657 Net Discount Line And Amount Flag (Yes / No)
NETDISCPERC Double 8 658 Net Discount Rate (%)
NETDISCAMNT Double 8 666 Net Discount Amount
VATCALCDIFF Double 8 674 VAT Difference In Purchase Invoice
CONDITIONREF Longint 4 682 Purchase / Sales Condition Reference
DISTORDERREF Longint 4 686 Distribution Order Reference
DISTORDLINEREF Longint 4 690 Distribution Order Line Reference
CAMPAIGNREFS1 Longint 4 694 Campaign Card Reference 1
CAMPAIGNREFS2 Longint 4 698 Campaign Card Reference 2
CAMPAIGNREFS3 Longint 4 702 Campaign Card Reference 3
CAMPAIGNREFS4 Longint 4 706 Campaign Card Reference 4
CAMPAIGNREFS5 Longint 4 710 Campaign Card Reference 5
POINTCAMPREF Longint 4 714 Point Campaign Card Reference
CAMPPOINT Double 8 718 Campaign Point
PROMCLASITEMREF Longint 4 726 Promotion Class Reference Earned From Campaign
CMPGLINEREF Longint 4 730 Campaign Line Reference
PLNSTTRANSPERNR Longint 4 734 Planned Material Transaction Period Number
PORDCLSPLNAMNT Double 8 738 Planned Closed Amount
VENDCOMM Double 8 746 Commision Rate
PREVIOUSOUTCOST Double 8 754 Previous Output Cost
COSTOFSALEACCREF Longint 4 762 Cost Of Sales General Ledger Account Reference
PURCHACCREF Longint 4 766 Purchase General Ledger Account Reference
COSTOFSALECNTREF Longint 4 770 Cost of Sales Overhead Pool Reference
PURCHCENTREF Longint 4 774 Purchase Overhead Pool Reference
PREVOUTCOSTCURR Double 8 778 Previous Output Cost Currency
ABVATAMOUNT Double 8 786 European Union VAT Amount
ABVATSTATUS Integer 2 794 VAT Calculating Status
PRRATE Double 8 796 Pricing Currency Exchange Rate
ADDTAXRATE Double 8 804 Additional Tax Rate
ADDTAXCONVFACT Double 8 812 Additional Tax Conversion Factor
ADDTAXAMOUNT Double 8 820 Additional Tax Amount
ADDTAXPRCOST Double 8 828 Additional Tax Cost
ADDTAXRETCOST Double 8 836 Additional Tax Return Cost
ADDTAXRETCOSTCURR Double 8 844 Additional Tax Return Cost (Reporting Currency)
GROSSUINFO1 Double 8 852 Gross Unit Conversion Factor 1
GROSSUINFO2 Double 8 860 Gross Unit Conversion Factor 2
ADDTAXPRCOSTCURR Double 8 868 Additional Tax Cost (Reporting Currency)
ADDTAXACCREF Longint 4 876 Additional Tax General Ledger Account Reference
ADDTAXCENTERREF Longint 4 880 Additional Tax Overhead Pool Reference
ADDTAXAMNTISUPD Byte 1 884 Additional Tax is Edited
INFIDX Double 8 885 Inflation Index
ADDTAXCOSACCREF Longint 4 893 Reduced Additional Tax G/L Account Reference
ADDTAXCOSCNTREF Longint 4 897 Reduced Additional Tax Overhead Pool Reference
PREVIOUSATAXPRCOST Double 8 901 Previous Additional Tax Cost
PREVATAXPRCOSTCURR Double 8 909 Previous Additional Tax Cost (Reporting Currency)
PRDORDTOTCOEF Double 8 917 Total Of Input From Production (Quantity * Cost Factor)
DEMPEGGEDAMNT Double 8 925 Quantity Used in Demand Delivery
STDUNITCOST Double 8 933 Standard Material Cost
STDRPUNITCOST Double 8 941 Standard Material Cost (Reporting Currency)
COSTDIFFACCREF Longint 4 949 Contains Detail Description
COSTDIFFCENREF Longint 4 953 Additional Tax Discount Amount
TEXTINC Byte 1 957 Contains Detail Description
ADDTAXDISCAMOUNT Double 8 958 Additional Tax Discount Quantity
ORGLOGOID ZString 25 966 Data Processing Site
EXIMFICHENO ZString 31 991 Import Export File Number
EXIMFCTYPE Integer 2 1022 Foreign Trade Slip Type
TRANSEXPLINE Byte 1 1024 Freight Surcharge
INSEXPLINE Byte 1 1025 Insurance Surcharge
EXIMWHFCREF Longint 4 1026 EXIMWHFC Reference
EXIMWHLNREF Longint 4 1030 EXIMWHTRANS Reference
EXIMFILEREF Longint 4 1034 INVEXIMINFO Reference
EXIMPROCNR Integer 2 1038 Foreign Trade Transaction Order
EISRVDSTTYP Byte 1 1040 Service Distribution Type ;0: By Warehouse;1: General
MAINSTLNREF Longint 4 1041 Item Transactions Reference
MADEOFSHRED Byte 1 1045 Generated by Parting? ;0: No;1: Yes
FROMORDWITHPAY Byte 1 1046 With payment / Without payment From order?
PROJECTREF Longint 4 1047 PROJECT Reference
STATUS Integer 2 1051 Status
DORESERVE Byte 1 1053 Will be reserved / Will not be reserved
POINTCAMPREFS1 Longint 4 1054 Campaign Cards Logical Reference
POINTCAMPREFS2 Longint 4 1058 Campaign Cards Logical Reference
POINTCAMPREFS3 Longint 4 1062 Campaign Cards Logical Reference
POINTCAMPREFS4 Longint 4 1066 Campaign Cards Logical Reference
CAMPPOINTS1 Double 8 1070 Campaign Points1
CAMPPOINTS2 Double 8 1078 Campaign Points2
CAMPPOINTS3 Double 8 1086 Campaign Points3
CAMPPOINTS4 Double 8 1094 Campaign Points4
CMPGLINEREFS1 Longint 4 1102 Campaign Lines Logical Reference1
CMPGLINEREFS2 Longint 4 1106 Campaign Lines Logical Reference2
CMPGLINEREFS3 Longint 4 1110 Campaign Lines Logical Reference3
CMPGLINEREFS4 Longint 4 1114 Campaign Lines Logical Reference4
PRCLISTREF Longint 4 1118 Purchase / Sales Prices Logical Reference
PORDSYMOUTLN Byte 1 1122 Production Order Semi Finished Good Output Line
MONTH_ Integer 2 1123 Month
YEAR_ Integer 2 1125 Year
EXADDTAXRATE Double 8 1127 Exception Additional Tax Rate
EXADDTAXCONVF Double 8 1135 Exception Additional Tax Conversion Factor
EXADDTAXAREF Longint 4 1143 General Ledger Accounts Logical Reference
EXADDTAXCREF Longint 4 1147 Overhead Pools Logical Reference
OTHRADDTAXAREF Longint 4 1151 General Ledger Accounts Logical Reference
OTHRADDTAXCREF Longint 4 1155 Overhead Pools Logical Reference
EXADDTAXAMNT Double 8 1159 Exception Additional Tax Amount
AFFECTCOLLATRL Byte 1 1167 (Affect) Collateral 0:Not Affect 1: Affect
ALTPROMFLAG Byte 1 1168 Alternative Promotion had been applied?
EIDISTFLNNR Byte 1 1169 Distribution Type 0: File Order Number 1: General
EXIMTYPE Byte 1 1170 0: Import 1: Export
VARIANTREF Longint 4 1171 Variant Port Logical Reference
CANDEDUCT Byte 1 1175 Apply Deduction
OUTREMAMNT Double 8 1176 Remaining Quantity
OUTREMCOST Double 8 1184 Remaining Cost
OUTREMCOSTCURR Double 8 1192 Remaining Cost (Reporting Currency)
REFLVATACCREF Longint 4 1200 General Ledger Accounts Reference
REFLVATOTHACCREF Longint 4 1204 General Ledger Accounts Reference
PARENTLNREF Longint 4 1208 Item Transactions Reference
AFFECTRISK Byte 1 1212 Affects Risk
INEFFECTIVECOST Byte 1 1213 Material cots will be affected 0: Yes 1:No
ADDTAXVATMATRAH Double 8 1214 Additional Tax Base
REFLACCREF Longint 4 1222 General Ledger Accounts Reference
REFLOTHACCREF Longint 4 1226 General Ledger Accounts Reference
CAMPPAYDEFREF Longint 4 1230 Payment Plans Reference
FAREGBINDDATE Longint 4 1234 Matching Date
RELTRANSLNREF Longint 4 1238 Material Remittance Related Slip Line Ref.
FROMTRANSFER Byte 1 1242 From Material Remittance Line
COSTDISTPRICE Double 8 1243 Total Cost Distribution Amount-Local Currency
COSTDISTREPPRICE Double 8 1251 Total Cost Distribution Amount-Reporting Currency
DIFFPRICEUFRS Double 8 1259 Price Difference Total IFRS
DIFFREPPRICEUFRS Double 8 1267 Total Price Difference Reporting Currency IFRS
OUTCOSTUFRS Double 8 1275 Output Slips Output Cost IFRS
OUTCOSTCURRUFRS Double 8 1283 Output Slips Output Cost In F. Currency IFRS
DIFFPRCOSTUFRS Double 8 1291 Cost Because Of Price Difference IFRS
DIFFPRCRCOSTUFRS Double 8 1299 Reporting Currency Cost Because of Price Difference IFRS
RETCOSTUFRS Double 8 1307 Return Transaction Cost IFRS
RETCOSTCURRUFRS Double 8 1315 Return Cost In F.Currency For Return Voucher IFRS
OUTREMCOSTUFRS Double 8 1323 Remaining Cost IFRS
OUTREMCOSTCURRUFRS Double 8 1331 Remaining Cost (Reporting Currency) IFRS
INFIDXUFRS Double 8 1339 Inflation Index IFRS
ADJPRICEUFRS Double 8 1347 IFRS Difference
ADJREPPRICEUFRS Double 8 1355 IFRS Difference (Reporting Currency)
ADJPRCOSTUFRS Double 8 1363 Cost Because Of IFRS Difference
ADJPRCRCOSTUFRS Double 8 1371 Cost Because Of IFRS Difference (Reporting Currency)
COSTDISTPRICEUFRS Double 8 1379 Total Cost Distribution Amount-Local Currency IFRS
COSTDISTREPPRICEUFRS Double 8 1387 Total Cost Distribution Amount-Reporting Currency IFRS
PURCHACCREFUFRS Longint 4 1395 Purchase General Ledger Account Reference (IFRS)
PURCHCENTREFUFRS Longint 4 1399 Purchase Overhead Pool Reference (IFRS)
COSACCREFUFRS Longint 4 1403 Cost Of Sales General Ledger Account Reference (IFRS)
COSCNTREFUFRS Longint 4 1407 Cost of Sales Overhead Pool Reference (IFRS)
PROUTCOSTUFRSDIFF Double 8 1411 Previous Output Cost (IFRS)
PROUTCOSTCRUFRSDIFF Double 8 1419 Previous Output Cost Currency (IFRS)
UNDERDEDUCTLIMIT Byte 1 1427 Under Deduction Limit
GLOBALID ZString 51 1428 Global ID
DEDUCTIONPART1 Integer 2 1479 Material Line Deduction Rate Numerator
DEDUCTIONPART2 Integer 2 1481 Material Line Deduction Rate Denominator
GUID ZString 37 1483 Aux. Code