{"id":375,"date":"2014-09-18T16:57:39","date_gmt":"2014-09-18T13:57:39","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=375"},"modified":"2015-01-15T23:12:52","modified_gmt":"2015-01-15T21:12:52","slug":"logo-tanimli-alanlar-tablosu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-tanimli-alanlar-tablosu\/","title":{"rendered":"Logo Tan\u0131ml\u0131 alanlar tablosu"},"content":{"rendered":"

SYS’de girilen tan\u0131ml\u0131 ve zorunlu alanlar ile ilgili bilgi ve \u00f6rnekler a\u015fa\u011f\u0131dad\u0131r;<\/p>\n

 <\/p>\n

<\/p>\n

L_DEFNFLDSD\u00a0\u00a0\u00a0 :SYS’de tan\u0131mlanan alanlar\u0131n tutuldu\u011fu tablodur.<\/p>\n

MODULENR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Hangi mod\u00fcle ait tan\u0131ml\u0131 alan oldu\u011funu g\u00f6sterir. (Fatura 4 , Malzeme Kart\u0131 6)<\/p>\n

LEVEL_\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Ek alan\u0131n t\u00fcr\u00fcn\u00fc g\u00f6sterir\u00a0\u00a0\u00a0\u00a0\u00a0 (0 – Ba\u015fl\u0131k ek alan\u0131, 1 – Sat\u0131r ek alan\u0131)<\/p>\n

NR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Ek alan numaras\u0131<\/p>\n

TYP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Veri tipi (1 – Metin, 2 – Say\u0131sal, 3 – Liste, 4 – Tarih)<\/p>\n

L_MANDFLDS\u00a0\u00a0\u00a0\u00a0 : SYS’de tan\u0131mlanan alanlar\u0131n Zorunlu olup olmad\u0131\u011f\u0131n\u0131 g\u00f6steren tablo. (MANDATORY=1 ise zorunlu alan)<\/p>\n

LG_CATEGLISTS\u00a0 : Liste se\u00e7imli alanlarda liste i\u00e7eri\u011fi bu tabloda tutuluyor.<\/p>\n

LG_002_DEFNFLDSCARDV\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Kartlardaki tan\u0131ml\u0131 alanlar\u0131n tutuldu\u011fu tablodur. (Malzeme Kart\u0131, Cari Hesap Kart\u0131, Muhasebe Hesap Kart\u0131)<\/p>\n

LG_002_01_DEFNFLDSTRANV\u00a0 : Fi\u015f ve fi\u015f sat\u0131rlar\u0131ndaki tan\u0131ml\u0131 alanlar\u0131n tutuldu\u011fu tablodur. (Fatura,\u0130rsaliye,Sipari\u015f,Malzeme Fi\u015fleri,Muhasebe Fi\u015fleri)<\/p>\n

 <\/p>\n

Kart ve fi\u015flerde girilen bilgiler DEFNFLDSTRANV,DEFNFLDSCARDV tablolar\u0131ndaki TEXTFLD1,TEXTFLD2,TEXTFLD3,…. tablolar\u0131nda tutulmaktad\u0131r.<\/p>\n

Di\u011fer TEXTFLD ve NUMFLD ile ba\u015flayan alanlar girdi\u011fimiz verileri tutuyor.<\/p>\n

 <\/p>\n

 <\/p>\n

———————————————————————————————————————————–<\/p>\n

FATURA TANIMLI ALAN;<\/p>\n

Fatura tan\u0131ml\u0131 alanlar\u0131 L_DEFNFLDSD tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :4 – Fatura<\/p>\n

INVAICE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSD Tablosundaki\u00a0 PARENTREF alan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

– _SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=4 AND PARENTREF='”+STR(R23.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

————————————————————————————————————————————-<\/p>\n

CAR\u0130 HESAP KARTI TANIMLI ALAN;<\/p>\n

 <\/p>\n

Cari Hesap Kart\u0131 tan\u0131ml\u0131 alanlar LG_001_DEFNFLDSCARDV\u00a0 tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :5<\/p>\n

CLCARD Tablosundaki LOGICALREF alan\u0131 DEFNFLDSCARDV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=5 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

———————————————————————————————————————————–<\/p>\n

MALZEME KARTI TANIMLI ALAN;<\/p>\n

Malzeme Kart\u0131 tan\u0131ml\u0131 alanlar LG_001_DEFNFLDSCARDV\u00a0 tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :6<\/p>\n

ITEMS Tablosundaki LOGICALREF alan\u0131 DEFNFLDSCARDV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=6 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

——————————————————————————————————————————-<\/p>\n

MALZEME\u00a0 F\u0130\u015e\u0130 TANIMLI ALAN;<\/p>\n

Muhasebe Fi\u015fi tan\u0131ml\u0131 alanlar LG_001_01_DEFNFLDSTRANV\u00a0 tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :2<\/p>\n

STFICHE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSTRANV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=2 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

——————————————————————————————————————————-<\/p>\n

MUHASEBE HESAP PLAN KARTI TANIMLI ALAN;<\/p>\n

Muhasebe Hesap Kart\u0131 tan\u0131ml\u0131 alanlar LG_001_DEFNFLDSCARDV\u00a0 tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :3<\/p>\n

EMUHACC Tablosundaki LOGICALREF alan\u0131 DEFNFLDSCARDV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=3 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

—————————————————————————————————————————–<\/p>\n

MUHASEBE F\u0130\u015e\u0130 TANIMLI ALAN;<\/p>\n

Muhasebe Fi\u015fi tan\u0131ml\u0131 alanlar LG_001_01_DEFNFLDSTRANV\u00a0 tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR :7<\/p>\n

EMFICHE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSTRANV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=7 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

F\u0130\u015e SATIRLARI \u0130\u00c7\u0130N<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_003_01_DEFNFLDSTRANV”,”MODULENR=7 AND OWNERREF='”+STR(R2.logicalRef)+”‘”)<\/p>\n

 <\/p>\n

—————————————————————————————————————————-<\/p>\n

\u0130RSAL\u0130YE TANIMLI ALANLAR;<\/p>\n

\u0130rsaliye Fi\u015flerindeki tan\u0131ml\u0131 alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR:9<\/p>\n

STFICHE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSTRANV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=9 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)<\/p>\n

————————————————————————————————————————–<\/p>\n

FATURA \u0130\u00c7ER\u0130S\u0130NDE \u0130RSAL\u0130YE TANIMLI ALANLAR;<\/p>\n

\u0130rsaliye Fi\u015flerindeki tan\u0131ml\u0131 alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR:9<\/p>\n

STFICHE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSTRANV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“D.TEXTFLDS1”,”LG_001_01_DEFNFLDSTRANV D, LG_001_01_STFICHE S “,”D.MODULENR=9 AND D.PARENTREF=S.LOGICALREF AND S.INVOICEREF='”+STR(R23.logicalRef)+”‘”)<\/p>\n

————————————————————————————————————————-<\/p>\n

S\u0130PAR\u0130\u015e TANIMLI ALANLAR;<\/p>\n

Sipari\u015f Fi\u015flerindeki tan\u0131ml\u0131 alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktad\u0131r.<\/p>\n

MODULENR:8<\/p>\n

ORFICHE Tablosundaki LOGICALREF alan\u0131 DEFNFLDSTRANV Tablosundaki\u00a0 PARENTREFalan\u0131na e\u015fittir.<\/p>\n

\u00d6RNEK:<\/p>\n

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=8 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

SYS’de girilen tan\u0131ml\u0131 ve zorunlu alanlar ile ilgili bilgi ve \u00f6rnekler a\u015fa\u011f\u0131dad\u0131r;  <\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-375","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=375"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/375\/revisions"}],"predecessor-version":[{"id":376,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/375\/revisions\/376"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}