# Table: P/O Optional Fields

Table: POOFD
View: PO0580
Record length: 146
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Optional Field |  | LOCATION, OPTFIELD

## Fields: 31

Field | Type | Title | Presentation
--- | --- | --- | ---
LOCATION | Integer | Location | List: 17 entries
0 | = | Additional Costs
1 | = | Requisitions
2 | = | Requisition Details
3 | = | Purchase Orders
4 | = | Purchase Order Details
5 | = | Receipts
6 | = | Receipt Details
7 | = | Receipt Additional Costs
8 | = | Receipt Additional Cost Details
9 | = | Invoices
10 | = | Invoice Details
11 | = | Invoice Additional Cost Details
12 | = | Returns
13 | = | Return Details
14 | = | Credit/Debit Notes
15 | = | Credit/Debit Note Details
16 | = | Credit/Debit Note Additional Cost Details
OPTFIELD | String*12 | Optional Field | Mask: %-12N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DEFVAL | String*60 | Default Value | Mask: %-60c
TYPE | Integer | Type | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | Integer | Length |
DECIMALS | Integer | Decimals |
ALLOWNULL | Boolean | Allow Blank | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | Boolean | Validate | List: 2 entries
0 | = | No
1 | = | Yes
INITFLAG | Integer | Auto Insert | List: 2 entries
0 | = | No
1 | = | Yes
SWPM | Integer | External Cost Transactions | List: 1 entries
99 | = | Not Applicable
SWPAYCLRPO | Integer | Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWPAYCLRAP | Integer | Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWICCTL | Integer | Inventory Control | List: 1 entries
99 | = | Not Applicable
SWNSCLR | Integer | Non-Stock Clearing | List: 1 entries
99 | = | Not Applicable
SWNIPCLRPO | Integer | Non-Inventory Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWNIPCLRAP | Integer | Non-Inventory Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWNIEXPPO | Integer | Non-Inventory Expense | List: 1 entries
99 | = | Not Applicable
SWNIEXPAP | Integer | Non-Inventory Expense | List: 1 entries
99 | = | Not Applicable
SWACEXPPO | Integer | Additional Cost Expense | List: 1 entries
99 | = | Not Applicable
SWACEXPAP | Integer | Additional Cost Expense | List: 1 entries
99 | = | Not Applicable
SWAPINV | Integer | Invoices Optional Fields | List: 1 entries
99 | = | Not Applicable
SWPMLABOR | Integer | Labor | List: 1 entries
99 | = | Not Applicable
SWPMOH | Integer | Overhead | List: 1 entries
99 | = | Not Applicable
SWACPCLRPO | Integer | Additional Cost Expense Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWACPCLRAP | Integer | Additional Cost Expense Payables Clearing | List: 1 entries
99 | = | Not Applicable
SWREQUIRED | Integer | Required | List: 2 entries
0 | = | No
1 | = | Yes
SWSET | Integer | Value Set | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.