03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| STOCK_TRAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Label | Prefix | Postfix | Minlength | Maxlength | Widthhint | Padding | Alignment | Casesensitive | Allcaps | Dp | Minvalue | Maxvalue | Validchars | Validformat | Tooltip | Sample | Default | Nature | Storage | Usage | Primary Key | Details | ||||||||||||||||||||||||||||||||||||
| COST_PRICE | Cost Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Unit cost price | 5 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitcost</validentry> | Unit cost price. | |||||||||||||||||||||||||||||||||||||||
| DATE | Date | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Transaction Date | 2451158 | JulianDateNumber | Date | RequiredUse | > | The transaction date. | ||||||||||||||||||||||||||||||||||||||||
| DETAILS | Details | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Transaction details | A sale | Text | String | OptionalUse | > | A text description for the transaction. | ||||||||||||||||||||||||||||||||||||||||
| NEXT_ITEM | Next | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | Next Item Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of next transaction for product. | |||||||||||||||||||||||||||||||||||||||
| PREV_ITEM | Prev | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | Next Item Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of prev transaction for product. | |||||||||||||||||||||||||||||||||||||||
| QTY_USED | Qty Used | 0 | 14 | 12 | RightAlignment | Y | Y | 2 | 0 | 1E+11 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Quantity used | 1000 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | Quantity already used up. | |||||||||||||||||||||||||||||||||||||||
| QUANTITY | Quantity | 0 | 14 | 12 | RightAlignment | Y | Y | 2 | 0 | 1E+11 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Transaction quantity | 1000 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The transaction quantity. | |||||||||||||||||||||||||||||||||||||||
| REFERENCE | Ref. | 0 | 30 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Reference | DCW | Text | String | OptionalUse | > | A transaction reference. | ||||||||||||||||||||||||||||||||||||||||
| RESERVED | Reserved | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 255 | ^.*$ | ^.*$ | Reserved | 0 | Numeric | 1ByteInt | ReservedUse | > | Reserved | ||||||||||||||||||||||||||||||||||||||||
| SALES_PRICE | Sales Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Unit sale price | 10 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | Unit sale price. | |||||||||||||||||||||||||||||||||||||||
| STOCK_CODE | Product Code | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Product identifier | A-WIDGET-CODE | Text | String | RequiredUse | > | The stock code for the transaction. | ||||||||||||||||||||||||||||||||||||||||
| TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 10 | ^[A-Z]*$ | ^[A-Z]?[A-Z]$ | Transaction type code | 1 | Enumerated | 2ByteInt | OptionalUse | > | <validentry>UN</validentry> | <validentry>AI</validentry> | <validentry>AO</validentry> | <validentry>GI</validentry> | <validentry>GO</validentry> | <validentry>MI</validentry> | <validentry>MO</validentry> | <validentry>GR</validentry> | <validentry>DI</validentry> | <validentry>DO</validentry> | <validentry>WO</validentry> | Type code for the transaction. | |||||||||||||||||||||||||||||
| RecordNumber | RecordNumber | 0 | 10 | 10 | 0 | RightAlignment | N | N | 0 | 0 | 2147483647 | ^[0-9]*$ | ^[0-9]*$ | Record number | 12 | PaddedNumeric | None | SpecialUse | primary="Y" | > | The record number. A pseudo primary index. | ||||||||||||||||||||||||||||||||||||||
| Project | Project | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Project Reference | SKYEWR01 | Text | String | OptionalUse | > | The reference a Project that the split is attached to. | ||||||||||||||||||||||||||||||||||||||||
| ProjectCostCode | Cost Code | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Project CostCode | LAB | Text | String | OptionalUse | > | The reference a ProjectCostCode that the split is associated with. | </header> | </sydd> | ||||||||||||||||||||||||||||||||||||||