Table FACTOR
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| FACTOR | FCT | Factors | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| FCT0 | FCTCOD | No | |
| FCT1 | FCTNAM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=21;ACCCOD;[V]GSUPCLE | Block | ||||
| ADDFCT | Factor address | 3 | A | 30 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BANACC | Account | GAC | [GAC]GAC0=COA;BANACC | Block | ||||
| BANBPR | BP code | BPR | [BPR]BPR0=[FCT]BANBPR | Block | ||||
| BANCPY | Company | CPY | [CPY]CPY0=[FCT]BANCPY | Block | ||||
| BANCUR | Currency | CUR | [TCU]TCU0=[FCT]BANCUR | Block | ||||
| BANFCY | Site | FCY | [FCY]FCY0=[FCT]BANFCY | Block | ||||
| BID | Bank account number | BID | ||||||
| COA | Chart code | COA | [COA]COA0=[FCT]COA | Block | ||||
| COLBPC | To be deleted | A | 10 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[FCT]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTY | City | CTY | ||||||
| FAX | Fax | A | 20 | |||||
| FCTBAN | Payment bank | BAN | [BAN]BAN0=[FCT]FCTBAN | Block | ||||
| FCTBPCACC | To be deleted | A | 15 | |||||
| FCTCOD | Factor code | FCT | [FCT]FCT0=[FCT]FCTCOD | Delete | ||||
| FCTCPTNUM | To be deleted | A | 15 | |||||
| FCTNAM | Factor name | A | 30 | |||||
| FCTQTCVCR | Receipt sequence no. | ANM | [ANM]ANM0=[FCT]FCTQTCVCR | Block | ||||
| FCTRES | Reserve % | DCB | 3.2 | |||||
| FCTTYP | Factoring type | M | 12 | 3626 | ||||
| FILEXT | File extension | A | 3 | |||||
| FILNAM | File name | TFB | [TFB]TFB0=FILNAM;"";1;0;"";1 | Block | ||||
| PAB1 | Paying bank 1 | A | 30 | |||||
| PAB2 | Paying bank 2 | A | 30 | |||||
| POSCOD | Postal code | POS | ||||||
| SALCOD | Vendor code | A | 10 | |||||
| SAT | State | SAT | ||||||
| TEL | Telephone | TEL | ||||||
| TXTSBRGT | Text | 6 | A | 77 | ||||
| TYPRAT | Rate type | M | 15 | 202 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WEB | Internet address | A | 50 |