| tHE_AcctTransArchiveItem |
| |
Naziv |
Tip |
Null |
Privzeto |
Opis |
| acKey | char(13) | 0 | ('') | |
| anNo | int | 0 | (0) | |
| acAcct | char(8) | 1 | ('') | |
| acSubject | char(30) | 1 | ('') | |
| anDebit | money | 0 | (0) | |
| anCredit | money | 0 | (0) | |
| acDoc | varchar(35) | 1 | ('') | |
| adDateDoc | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| acLinkDoc | varchar(35) | 1 | ('') | |
| adDateDue | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| acLnkKey | char(13) | 1 | ('') | |
| acCurrency | char(3) | 1 | ('EUR') | |
| anFXRate | decimal(12,6) | 0 | (1) | |
| anValDebit | money | 0 | (0) | |
| anValCredit | money | 0 | (0) | |
| adTimeIns | datetime | 1 | | |
| acDept | char(30) | 1 | ('') | |
| acNote | varchar(255) | 1 | ('') | |
| acVATPayed | char(1) | 1 | ('') | |
| acContraAcct | char(8) | 1 | ('') | |
| acForeignDoc | varchar(35) | 1 | ('') | |
| anUserIns | smallint | 1 | | |
| adTimeChg | datetime | 1 | | |
| anUserChg | smallint | 1 | | |
| adDateVAT | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| acCostDrv | char(16) | 1 | ('') | |
| anOrgNo | int | 0 | (0) | |