TMS формирует документ списания по ЧЗ 552 схема с типом 13

Материал из wiki.standart-n.ru
Перейти к: навигация, поиск
INSERT INTO GROUPS (ID, PARENT_ID, CAPTION, GROUPTABLE, STATUS, SYSTEMFLAG, DESCRIPTION, IMAGEINDEX, DATA, COLOR, SORTING, SID)
            VALUES (10015, -400, 'Выгрузка для списания по ЧЗ проданных товаров', 'TMS                            ', 0, 0, NULL, -1, X'504B030414000000080074828D5525496E753A000000460000000F00000050726F6A656374312E737370726F6A8B76CBCC492D8EE5E502D186B6A1799925867A05C5C9BC5C3E8979E9A589E940410388AC737E695E89AD212F976F62661E482144352F172F1700504B030414000000080074828D55B155611E18110000F149000009000000556E6974312E706375CD5C7D6C1C57B59FFDF0EEFA3359272AD0F6F1A60E6A52486CC76911381FD49FA98BEDA6F626A994C266BC33B6A7DD9D71676663BB8F4279A95410A09282FA9E9A4AA4B4D2535441D1E38FB6EFD1C77BA5153C90A02D51916805A6C18DF3E5D8312D945725EFDCD9B9DE33B36767776DC970A5D578EEB973CEEF7CDC73CFBDB36BC9DA279929292DF64C29A9AC258DA415B1574D2BD78605BB6D864F7FADE0DBA2F00908B70AD570ED4A4BA6A99831A7AB11AE7B0D69625C4D2DF75DCF86E99A65E869B3CAE9BB11AEBDBA913139AF6D70ED56A5B43EB6FCDC27EDE7325D96915EEEBB15AE038A694A637999B7C37578DADC6FA9E9657607E19AD0F5F44155E35D87E1DA9719EB574D8B3FA9C2559EEA99EA912D83F799765F9766698A1176FA1EB0FB12FD7CCC51FBBEBB9341E37DDF70FAF61AAACCFBFE8521B3645B8388D3F7345CB3DA80A46A41A7E719A67A2787F92C83D979675631A66B9CAEE7EDAE6E09BC25990A07F5B2CDA87B800BFBB9CD26C13C6A563B7DA7E09A1A95A76CDB70DBFFDEB6A1965D86F44ECE809692E12016E1DA99B52C5D5BB6F25FE1DA3365B9BC110EE4F5AB73FA1A024CE4B0925652568FAC5A1CEEF5D03F2059E31C5A13DC834A8A0D8D336C85CEB191A41D961C6E7B8085942A2FFBB623C0C24E9DE83464DE753B63669BDE8C3B5DC301669E5E43CA285D59D3D233DD6ACAE2C2551B240487AC4F9A1CA1652334EFE560EE877B735C49A7A50935B1AFB7B53E2159C329439DB0FAB4515D880DE9594BD514B321101E0429919A643239D0D1370897EA0392A1DA9E680844E16F9B1E1952CC6CDADAD8ADA4D2922159AAAE0DEB5923A5ECD3CDD0A160ACC318EBD364652A783536A0CBEAA8AA18D148461FD43525B237AD8F48E9584DCE4D89E9092528D41C504D75444DABD6743476E4C8BEEC485A4D09424D9FD99BD5528C7D35E3D9A567352B28D4754E0F29A370CF540C0AB53930398142BC4B4AA7550DC66A47148D3D1AAD4EA5986BA1DF25C7589613CD61C21A8660FAD2EA7D2D50867AD531A6187B3E12312D03F0607DAFD2FAE6A507AD365AF8236B203C50C4AFDF5A13C577D0C21F5B03E1515319CB40CCD0081E5F0304B15158BF34F88B86F0D41A400867B3AA4C8BFFDE1A888FE8C658325304C00FD702C07D49594F9934809F9505209E7B5691ED8A22E7D884B310E6C1B1AEFBECB511C18B96012F2319F7D2F07EF5378717BB2F39AE48B262D000DFF89B030C59864663BBB4526C0D002461489A29D92B551EA1875011CE30E02CB2062CFD5D010DCA2334CC8672CA000A666D225F21E63142EF08EFAD086040A5F17DAC2C7C79005155B39431C5A83CA127B56C86C670E35A6088184A2AA9E93482D6B5401034D3B4F4DE95C7C8B09DDAED2D108A917C6F193122AC637B17A7F6F5D6BDB14E655C3AA2EA4634668E0CC2FE0E6AD6FD9A6AD9E3AAD85FDBF3DBC87EF83C0C3576A3677B5983FE3E1464B5B8BBE5C5B10D0CDBABF6C2982FC0C856342A041BBE2E43811D06D28F13D9DE823DE06DBC6B277CC6E126EEA19BE990F35718760DDF21380CF6F533540D0C5520209C8021DF470A8484BB43A91C2A57F6C0C04E106CB95806ECA1604E6BDC20F1051DB15DF079066EAE41E4802087E40CEC5FF66B72A65F1D3124631A8B7CC6C7164CF48B045D1EA977A85DA0E88F61C455689CBA591809F5C2FE0A36F01310959A95903358E28F4B58FFDFE0A6BE40221FB11B3E6F92234268C44F6943AD131C4301D8DF786037837FBA955109B6463C6FD28E623EBD40E810433A9C03FA3A0F9DA736CCE7CF041F1E338CCFBBC11C60DCD48F387F3085AF0D0905EDB5F97717662E5E9DBD20FE69E6EC79F1EDFF3BBDB074E6DC5CBB88FD7A03F160CDB251E34546E060BC4260875D209E265F225838D384598B4D930761C849D73419CA4F13BB84E114163B0F120C2308D33D40AFF6D07315208E9F274254FC44D088478AF28939D85908FD6BC81D42C1C05008C58E8D1E9BE3E5E2E6E059E39550E559E315826D1819E524D0EB3C74562E6193BC439A248C46BC5E840B9E536F872A9C53551C2EA81C0D0B05ADB7A37FB8073BE6DDA28E616B07770C531FE3E804C7EC83D534D335AEA4EEE5AEC1DA6D09D3DA61D9D7848BC9AE45B29B3CB2874036D2980B3FEA9099EFDE223437ED633491714FCA603B71D4D033CEAD62496A5ACCC8E2E4B86228A23205EB9B296E711E51E5DCD849280198C5272403A89313CEE8C98966D69354E5DD1999FF294A9ACC28F76525CDDADD7A937DDF8420D65615420404CD293D93512D00A888BBC4CDADDB9B5B6F696E6B6D6BDB6C73E023593AA92338F0928049D84B49D8620302D6AD36BFDCDD1E71DBF69BC43143CF4E8823D362DE463B5D022986789D4984F3F98C376B079E147215350287C4C1AA6221C19EB343023E87AADC21D10721317C673F95E00E11A0C3423EBA0E7B58B5099F1712CA94E5543A269BC3EB1DB1F757B92BAC80F05670D4C864244D828A746AA20DAA82DC79345117DCEF633DA6F951D236EC213B19402A7BC803B536FCDB60BF3ED6672500C4400EC45DFBDA78ECB3EB0942686268BF2B037CABA8C9F9B2C2ECF4B847F863B0AC74C0043CB29C9831CF17CA72E38B1E9EBB81A7A28F526E7C91508437113E3FF2A1DFE0D03FE7A97EF92D03FCFB2AA22EC003677C043494A03300A781FEB2A71F2F659F880805CDB3B26F8D54B2B26F2518E28AEA9A887B7BC01A3F3CC1719988500B590C8DD8EBC309AFEEFB22E5AFEE8CEF8311B2E6C4A2751FD1780DF9A748596B085E3D4F12F6B3574F2CFFB88F7C3C7BBE1B29357B78B0310334470B453B6BD1FEFD7DDDC9C41DC9AEDB3A86B6ECED194CB28E2D37C1FA628AECE074AB68AF46522679444A6715D69D3BD0CC2D6136C914F9D2C5C7C2D2B5F98EA1BDC981EECD3B7146FFAF48E196D172953907A3D4086CA2DBA3C54D8493C160B4EC9C3E48D807E7F4E168F9397D32BA8A9C3E4900C1D67990B40ECEE95F8E569CD34F1242594EC7467FC2C7E8382E9F8A968A4BCCF5D73E5C3942E6D25902210BCEE519098A9FF1483E0A927B55252D774EB3130ECAED6708B68C1D5388B972C1C3F2A4F0D7608799F379C2E68DB92D1409A24607E062D4BD847D499809002BB6F3E76FC88988582CC2953536A35E8AE6F757D834D8CCD7C5FC9DC71A33734B4C2868B9C98E0DBD3D56B1A1B7138CB1A1DB639518BA9DE0860DBD33B61243EF24B8E28D6B4D2CF7E58A42E3E0242F135C0A92FC8112FEE093E973B1529309279E8762AB483C0F11B879A261A1F10D82EECA3B8FC4CACA3B18F0B3AB01FC6C9120E036FE8F183D2F30E6FFAC1CF39BABC1FCA64F8831CC73BE21C6519F2D0F355E36AEC4A8E3D21B9DBF987F3FEE2DAEA1EDFACC54262D1E510C132A9ADD4DB0736C12152DA5CB302B7737ED4FF46EFB54D367F6D87B4F07DAD66A37B40F0987850E594687BC1855473585EA4308D5E72954B29ECAB297DAA6682A268396CCAABB9BB0EFE56ADAF7FCEFB833C6DBF622D1DF23E84DD8183B3ED924827D34B37DCA04F9E39635D1DED2323939D93CB9A319BCD6D2D6DABABDE5AE81FEE1D4B89291B6A99A69495A4A69DA83615062B0459FADC8A22F93161511DF73843C11DAAE49D51A970D69524A8BB91296D5704DB7DCD2D6E4F2F0858AF0046A283C1B119EEBBC79D0C1636332B323F7408D0A48F6E069B2A9A6D834E177716794B7F16D0793DC46D077B52091981935189BE5E69A4ACCD2479AE5C388EF989F59F40925F7DA891DA9287BAE43CF7D9B786E1ADAB64C669B2C37259AC6C7DB339976D3FC44EBCDEDADADEC117BD5843CF6788D7BD51C0BCE04347DD27FD17C9C90D7C0990603C2710FD31F0253F6D542899D362A0915CA055FFEC709FEBCC58BD0B9659972DF279DEC31207E907A003BFA071539FA15D2D118E05B7E8E864CC75E47ECC1E70A733525CE15CE228EDEAD42DC43E78DAD4BBC7A3AEF71D953503DF56956420715FD9D75BE84B3283AEF62B6F833E92C6E04CC891A89BDF47E455E6AA8A5BCD488F8DE487CE9D6E5253B8EB02E9DC413B2DC9CC934B3E988E7DD6DB52B9877B711ECF1BCEBAB5DDDBCEBF3F99671BC089D7731E50E10F49C2B0B661C3514FBF2AEDA4A7C99217DB90DF13DE1E7CBFC2A98B4A627943DDB77EC6AF1F66170DFAD08DC7324385CF09CF203A71BB03F70DE2D982E186F9484816BD8F76A5751C3BE4720C41B85AB04DD75E81CA8ABB87CDD5447D90DAF7BDDDE3743C86EB8ED32C72C55735513FD75C54E96792F139022042CBFD5C0BB63A5AEE2DDB142F0C6BB63ADAE92DDB14670E32D5E84CEF7254CD329820E75916D37CC871A8763F2FEBA52318997B547EA4A2C6BDF44E2A865ED9B041CFC9EFEEB94001C074F178D83E593406078D2A3D5AFC1BD83EC24D0F12BD6E9BF4BE9F41384F99C47A9060FDDDB06E1F333A0FFCED38F557AB5A84AF89CF4545DD92F4D4EF900DA5882CEDE59FC06E8777B14751DEDD697F7A58CCFA2F70754307CD6FB7E4170BFAAB8D5470E8B5F4663A6F96A7D4EEFBCAC3F09D2C4445A4DD9E523E449FB7732449AFC2A8180ED59EA1CCEC7EADD46FFB47059E899B2BFB395E8C84BC02C8F112C19505EB83D5AEFF6764B6026009169C0768EE9362159E3FE8BFEA34504B0C602E629827E4B5B5B122D90BC9B39E16962382E7C9EAB2F2C7C064B153ECF114CAB91119EF7303D0A4CED92A774F9FA3CC11A1F2BBE505F78AC982879ACF802C1155B89A2E3F5F44704DD65E6177D629DCDA95FF9C43AAEFB5FAD5F69DDFF6A0915293A3EDD7F83A0374F65D298073506CFE87B3C33956BC97E7A80AD116A283E8ED5EFDC1AE106B73596C01AECA7783DF63739FCED11F6267DD45816AC027A934F16DC5F26C6031E8C9B60C2772B69C55218527F8C077C308A0E063F1D0E02FD7A8F0EB8C67CB2611535E69384F08F3A5716303F25E8BFFCCBDC1FCECDB48B1767C50BF3A797C4A53FCE9C9FBBFC81FD05BB76119BF7351FF3F27B3B6C0929B8907DBDA1E2D3E30F5663950F083CF8ED4D8D7796433B55A0FDC675E569BF91E0D687A42509BA38B77869FEFC076796662F2F5E15FFB8B0747AEE82786961FEBDD9C5C5F90B5BC53333E716E6CF5E9ECD7DEB710EEE2F2D2D5E9E838EF94BB30B33EFCD5D81AE8BF3A7E731104A107683B4AE2C37604B1D2BCB52C7CBB4D4F112967A67AD2C4509AA7568CC5273EBDCC7E2D7093581E1717DD2F9CD2EC49EF3235F27F8F0162CBA9EDA82851D096C39AF5BEFF64314EAFD5E43C1DFF0E6497F137CB6C170D593407AEEEA4B08684CDFFAC24489A793B57E15D3893DEC6DD73A57E6B6C708FA6B4BEFCF2E5E7E7BE9CAFB736773AE616966F6A23B704EAC2F2F70BE4348C091FDE4FA8A77CAAF936EC227CB0B84D0E5DD714BF12386CBEB2B39E9A889973AF8BCC14B7670E0F31617804DF14A00EC2401F0ED09E33B4000B08FA8722F975CB2EF28291B87A5115F45581A04ACE52A14583D1C772FFA877881EBBBDC3F4C70C565F357E22B2E9BBF42B0C605ECD72847F33F18EDEB25343EEEC196046C65BC3928A1F1131EAE0F73AEA5357E82608D15A2E838B33C4F59A4E84F0230E717882771E679295E5EE6F91F820FCE3C3F89979579F077EBFE40B084B504A33B5726BA73042BFCC3880582EEFE61043502FF30E22D1A2C4E20D58D5402C1EAFC43A37F99CE93C7471BDDC64C41F218968E40A4D9653A9DBF3E458AC7EBEDEEC692EB2D4E4A871B5791940E7B7F0626E4556776CD10F48F4313F13C7EA0712599EB0182359EC75F6C5C71E6FA22C19AB778113ACE6C5F26E82266F0CFC4006C91638D2BC96CC74A58E4D1C61567B6474B5884A25FEF5C99457E4059E497B98AF5EA724E83D2F5EDD985BFCC5E9CC1BCA967714EFAF7C6B27212273347FDC2C7812C0DFC6FA3CF012D2B402FC0805B3D03F001EB95C66207ACCBAF04E053B3C18DFC4EFABBC25869F688B7F11F21B1C8897B580E0B7787BAEC1F7AB87FBD83BF15F38F1BE81FD08411DF8F6DF02695BB4376527171C526B8794339C7E69F2EE03BC4F9167C4B7B88D01D92337E1F3B4A0C7929175D337474514FE0BDD1F886C2BD91097BA34C91BD111FBB033E06C13BF71F5CF85D479151FF0F504B030414000000080074828D55B340AB3FF40600007213000009000000556E6974312E707363C557DB6E1B3713BE0F907720D48B952B7925CB4DD1CA568A58B25303767AB082FE770B4AA424B67B50B85C4B7EBD5EF5A6050AF40154278295C492653B7FD1A045D319EEAE8E6B59775DC01697339CF966F871861BF8DC7FF88090B24D7D1866C95349DB2D518751D97395F46C181D78D2819F8AA0B6D7D412A7AC244A8EB9EFD326AE3B39F39F2B017368ADEA79F677C2CD9243A779247C9525ACBBDFDD674AE2A8EC2A97EB51F508FF57F6D05A387A2A0503638A850ED058E01E53B055D903737BDF045C9EE1A04215AD519F67415E3906707B555AB31149BDC1BA211480E7062136C51D6D6C2F50CA73616EBFABA21826CE60E509B7795DED3301908FA96A815DAAF834B066CD52E806F32418A6C216ED3DC9D07F3413B807923ABC1CF8CA732AA2AEF4C27A03F2C1BC0E82A2FE0F59E2B7B86DD3B6D879F8E0E183532A09A436AB0A59029ED536C879D3E12EBC3484CD5D30089603CC8D279B96C38AC45752B8CD1D344EC80B8B79B0672F2C87CA1FE0A7C529E3B248AA877B2F3063919A926E16FE0A444BAA92BA3EAD2BE1B9A198D570BE16A7365A24B208C17203274B24AF5BAE5724C255BCC965A4E1DB68F04403C2EDD631D57853B8384079B1342336CB924356F5624003B2392C665D8BD3AEB037B40EC02A31C73C800402F3DA9E0B79491BAC666CC426CC0A6FD0C0563172D0AFED84BE63ECC5523E8E271C42BE8B25E3D7D1FFC7BDE187FE2579D77BFD969CFFF5727C7BF166502446E6A3ADFC475BDBD1224272B99FDE83DAB04F463757E3DEF9DBFE70F8579F5CF6C66F066470B179D103D9797F3C1CBD26EFDEBD0ABD877B839BA2A3D4EC5D8A6FAA642E0410CA70C7EE4D52AC78472AE6BC7C4D81A1E516AF03AA036A4F767AA230E3A85842AB335988549E80F414AC37A2F5130CDBA4582286AF0F1241558B0114D2909E13BD7245854D1C463A2D2E39E15DE0844FD2D112C142DD0E951C03685309D24E3BD2EEB44D9CB1042B392C1E12EA3294BC08A8AB4AF90DFD6E64624C063833EB9EE308055838D9258691DF32F38FCC42BE50308C25F5B436047A792D0ADF1E93CDAD0DD2945ED026B533328D6D87188B093CF9E6C8ACF2AE82EC4D19D4908E435D2897B2DB2E98475EF350A5D5F61207E2CC2A194C37A6D3021E13D753B116F71A8479B1383A6C64E6118DB4C054A8165F9024AA8700A2BAB19AABCB0B92799BA0B748AC55BA8B0C5B54548559A63D7F7E58B1AA5F59E52F9F7C9B7EBAFFCCC289F40650C18F0AA7260E75AC536A071CA7C34A1AB24D8B7C12B32CD6059619C657DF3EB58E2B86B163AC823BB3E58504BDC4CD2FAC4CEA02119635312ECC015456273D597620B8CDF6CE9E41CF481BA8626C984FFCB0FC26F98BD2B0DA4EA8748FA5B5B72E291946C148B299A48A41ADAB1B024FD2F66DF309636963F78BAE6393532E7D60652905752145B85BF71844594A3DAF1E6C7E96FAE27122B88909E8BE01B66B1FFAB68F76AC409452460691668CD4ACF5ED4F53041CBA7EB1EB834E4BA9763197EB743A6667DB04B4B9423EBF95FBDFF1D149BDC51DBA295C5F51B7CE53AB21E078B723548B49DAA136090F191238F5E851618DC5DA801FD4BE87D304CB1E1B993075196337373BBD961DAFCD25D500B0E0822DBC42526C4ABC2A904F67F06C3ACE2663A96AAAD52A3A4ED1F733F94F8AF9BC91853AD7D940BF8B66D6F20D7B810D1F9C1EBAAAEA015DD322B3A5ED4D446B1BBA033E63A6E39818C40CDAA9FE5AE6A79B65A9B3367FBCB5BD9B5B9C5B33DB120E5DD457FDE43589276E3B4195BB6C766AD1D7ECB3EB379570213B514B9A2B1893EE3853333495C235CB8EE15A06DB34371DD97D0655753924E86FD0E03EF91C5A9C27A1634FDAE24672CFBBABE911BCD4FCDC1B5CF687A3F3DE70D0D737C1DEE42A98B8627AAB8C470BD0E734F1FA8EF515E290702E71AA0D1F1769DA6EDBA2AE096EEE7739260E88F4A850B066786064AA589635F734999F01DD40CD9AE1770C02A64DA82D497D4A678C1C80E2BEBE6FA5636077646B75C6426B781DA940FB551CEDAE63F13EA33A634954FDE5CFC1EF6F7A45BC7E5F8E5EDE92DB57BDB7839BBFF55EE1657DE23B39F455A67F5B309131C8E0FA6AF4F6EF8BDBFECDF507F26A7CFB727049AEC6A33FFAD7D7A3CB2CB9E8BD198F5EDF844C210378BFBABDBE19C0C4E8AA3FEEFD31F807A686A397A3C4A3387D4E5A5E27FA82FE2F61C0193F903CA94F4F1FB8A4279CC158E8B2BB65700348CEFBAFB7EFFBD737E7B7FFBC1FBC0E43C04DED0FD7D8CE3B1D2E95C6DC1AB57161DD6C15BE7781AEFA61EBBF533729FAE971C6119C5B081A5B4B3887239C5BF1757A4F86F4D72DFC9BD269E17376319A137A0ACEE7CF71E2A593DC4398C4BDFE181E00BD5ED4BF84ECFD308917680C1FD67FF687BDBB522CA69FF7D3678E25BAAF4DDE96BF73CDB2FE3E9C2ED01FD3F361C67D6E6ED28743EC448718136EFC18A2EE2DA07EF820C4F32F504B0102140014000000080074828D5525496E753A000000460000000F000000000000000100200000000000000050726F6A656374312E737370726F6A504B0102140014000000080074828D55B155611E18110000F1490000090000000000000000002000000067000000556E6974312E706375504B0102140014000000080074828D55B340AB3FF4060000721300000900000000000000010020000000A6110000556E6974312E707363504B05060000000003000300AB000000C11800000000', NULL, 99, NULL);


COMMIT WORK;