USR$INV CONTRACT
Материал из GedeminWiki
(Различия между версиями)
MoS (обсуждение | вклад) (Новая страница: «Документ Договор (форма) <syntaxhighlight lang="sql"> CREATE TABLE USR$INV_CONTRACT ( DOCUMENTKEY DINTKEY NOT NULL, USR$BASES DTEXT8…») |
MoS (обсуждение | вклад) |
||
| Строка 4: | Строка 4: | ||
CREATE TABLE USR$INV_CONTRACT | CREATE TABLE USR$INV_CONTRACT | ||
( | ( | ||
| − | DOCUMENTKEY DINTKEY NOT NULL, | + | DOCUMENTKEY DINTKEY NOT NULL, |
| − | USR$BASES DTEXT80, | + | USR$BASES DTEXT80, |
USR$CONTACTKEY USR$INV_DCONTACT NOT NULL, | USR$CONTACTKEY USR$INV_DCONTACT NOT NULL, | ||
| − | USR$DATEEND DDATE, | + | USR$DATEEND DDATE, |
| − | USR$IMAGE DBMP, | + | USR$IMAGE DBMP, |
USR$OPTIONDELIVERYKEY USR$INV_DOPTIONDELIVERY, | USR$OPTIONDELIVERYKEY USR$INV_DOPTIONDELIVERY, | ||
USR$PAYCONDKEY USR$INV_DPAYCOND, | USR$PAYCONDKEY USR$INV_DPAYCOND, | ||
USR$PURPOSEKEY USR$INV_DPURPOSE, | USR$PURPOSEKEY USR$INV_DPURPOSE, | ||
USR$TYPECONTRACTKEY USR$MGAZ_DTYPECONTRACT, | USR$TYPECONTRACTKEY USR$MGAZ_DTYPECONTRACT, | ||
| − | USR$PREDDAYS DINTEGER, | + | USR$PREDDAYS DINTEGER, |
| − | + | PRIMARY KEY (DOCUMENTKEY) | |
); | ); | ||
Текущая версия на 16:21, 24 мая 2021
CREATE TABLE USR$INV_CONTRACT ( DOCUMENTKEY DINTKEY NOT NULL, USR$BASES DTEXT80, USR$CONTACTKEY USR$INV_DCONTACT NOT NULL, USR$DATEEND DDATE, USR$IMAGE DBMP, USR$OPTIONDELIVERYKEY USR$INV_DOPTIONDELIVERY, USR$PAYCONDKEY USR$INV_DPAYCOND, USR$PURPOSEKEY USR$INV_DPURPOSE, USR$TYPECONTRACTKEY USR$MGAZ_DTYPECONTRACT, USR$PREDDAYS DINTEGER, PRIMARY KEY (DOCUMENTKEY) );