Table: Optional Fields

Table: APOFD
View: AP0500
Record Length: 150

Flags: A R 

Keys: 1

Title Flags Fields

Optional Field LOCATIONOPTFIELD

Fields: 33

Field Type Title Presentation

LOCATION Integer Location List:7 entries
0 = Vendors and Vendor Groups
1 = Remit-To Locations
2 = Invoices
3 = Invoice Details
4 = Payments
5 = Adjustments
6 = Revaluation
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
SWCONTROL Integer Payables Control List:1 entries
99 = Not Applicable
SWRTG Integer Retainage List:1 entries
99 = Not Applicable
SWDISCOUNT Integer Purchase Discount List:1 entries
99 = Not Applicable
SWTAXRECOV Integer Recoverable Tax List:1 entries
99 = Not Applicable
SWTAXEXP Integer Expense Tax List:1 entries
99 = Not Applicable
SWREXCHG Integer Exchange Gain List:1 entries
99 = Not Applicable
SWREXCHL Integer Exchange Loss List:1 entries
99 = Not Applicable
SWUREXCHG Integer Unrealized Exchange Gain List:1 entries
99 = Not Applicable
SWUREXCHL Integer Unrealized Exchange Loss List:1 entries
99 = Not Applicable
SWROUND Integer Rounding List:1 entries
99 = Not Applicable
SWDISTRIB Integer Distribution List:1 entries
99 = Not Applicable
SWPREPAY Integer Prepayment List:1 entries
99 = Not Applicable
SWMISCPAY Integer Miscellaneous Payment List:1 entries
99 = Not Applicable
SWBANK Integer Bank List:1 entries
99 = Not Applicable
SWADJ Integer Adjustment List:1 entries
99 = Not Applicable
SWLABOUR Integer Labor List:1 entries
99 = Not Applicable
SWOHEAD Integer Overhead List:1 entries
99 = Not Applicable
SWPM Integer External Cost Transactions 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