Таблица: PC01 - «Purchase Order Head» («Загол. Заказов на Зак.»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
PC01001 | STRING | 10 | PurchOrderNo | Да |
PC01002 | INTEGER | 1 | OrderType | |
PC01003 | VSTRING | 10 | SuppCodBuyer | |
PC01004 | VSTRING | 10 | CustCodeDel | |
PC01005 | VSTRING | 25 | AddressText1 | |
PC01006 | VSTRING | 25 | AddressText2 | |
PC01007 | INTEGER | 1 | FLPurchOrder | |
PC01008 | INTEGER | 1 | FLRemConf | |
PC01009 | INTEGER | 1 | FLRemShipm | |
PC01010 | SWITCH | 1 | FLDispNotEnt | |
PC01011 | SWITCH | 1 | FLInvEntered | |
PC01012 | INTEGER | 2 | TermsOfPaym | |
PC01013 | INTEGER | 2 | TermsOfDel | |
PC01014 | INTEGER | 2 | WayOfDel | |
PC01015 | DATE | 8 | OrderDate | |
PC01016 | DATE | 8 | DelDate | |
PC01017 | VSTRING | 20 | OurReference | |
PC01018 | VSTRING | 20 | YourReferenc | |
PC01019 | X_NUMERIC | 6 | OrderDiscoun | |
PC01020 | MONEY | 20 | OrderValue | |
PC01021 | INTEGER | 1 | LanguageCode | |
PC01022 | INTEGER | 2 | CurrCode | |
PC01023 | VSTRING | 6 | WareHouse | |
PC01024 | SWITCH | 1 | ExternalControl | |
PC01025 | VSTRING | 1 | SPARE | |
PC01026 | VSTRING | 1 | SPARE | |
PC01027 | VSTRING | 1 | UserOption1 | |
PC01028 | VSTRING | 1 | UserOption2 | |
PC01029 | VSTRING | 1 | UserOption3 | |
PC01030 | SWITCH | 1 | CurrContract | |
PC01031 | X_NUMERIC | 20 | FixedExcRate | |
PC01032 | VSTRING | 15 | ContractNo | |
PC01033 | ACCSTR | 50 | DefaultAcc | |
PC01034 | SWITCH | 1 | LetterOfCred | |
PC01035 | DATE | 8 | LetterOfCrOp | |
PC01036 | DATE | 8 | LetterOfCrDu | |
PC01037 | VSTRING | 20 | LettOfCreRef | |
PC01038 | SWITCH | 1 | PartiaDelCde | |
PC01039 | INTEGER | 2 | EDITransmCou | |
PC01040 | INTEGER | 2 | EDIRecveCoun | |
PC01041 | SWITCH | 1 | EDIFlag1 | |
PC01042 | SWITCH | 1 | EDIFlag2 | |
PC01043 | SWITCH | 1 | EDIFlag3 | |
PC01044 | SWITCH | 1 | EDIFlag4 | |
PC01045 | VSTRING | 2 | ShippAddrNo | |
PC01046 | VSTRING | 3 | Purchaser | |
PC01047 | X_NUMERIC | 10 | FixedExchgRate2 | |
PC01048 | STRING | 3 | FixedExchgAlgtm | |
PC01049 | SWITCH | 1 | EDIContractSwitch | |
PC01050 | STRING | 3 | OrAdminCode | |
PC01051 | VSTRING | 30 | ProjManagActivityID | |
PC01052 | STRING | 20 | SupplierSOrderNo | |
PC01053 | INTEGER | 1 | FLPurchOrderXML | |
PC01054 | INTEGER | 1 | FLRenConfXML | |
PC01055 | INTEGER | 1 | FLRemShipmXML | |
PC01056 | STRING | 12 | ProjectNumber | |
PC01057 | STRING | 25 | SiteCode | |
PC01058 | STRING | 20 | CustomerPoNumber | |
PC01059 | STRING | 20 | SupplierOrderNumber | |
PC01060 | STRING | 30 | Remark1 | |
PC01061 | STRING | 30 | Remark2 |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Order (Заказ на Закупку) | Purchase Order Head (Загол. Заказов на Зак.)